integrated date_contraints.tt with user stats; chnaged outreach interim report to show diagnosis & comment when authorised, not just reported; ScriptHelpers::mail_admin() accepts 'subject' arg

patched L::L::DBIxSimple to handle omiholders and placeholders in same query; new dbix-simple.t to test it; moved loop queries to data-maps in activity_data.pl; replace pipe-delimited file with xl file in gallium data for quintiles

patched all M::Email::send_message() returns to handle Return::Value object instead of string/undef

new function to exempt certain patient names from PDS/SMS lookup; removed recently discontinued email methods

new gallium trial data cron

MAJOR CHANGE: combined send_message and send_attachment into a single method dispatch() in L::Local::Mail - consistently returns a Return::Value object so no longer handling returns from simple mail and attachments differerntly - affects app and crons; fix for resources meter chart for swap mem on Deb6 VM; patched M::Outreach::update_followup() to prevent unnecessary db lookups for non-duration followup (eg other), and prevented crash when attempting to update non-existant table entry; moved loading of local-lib above FindBin in hilis4.fcgi to avoid fastcgi error in Deb6 VM

MAJOR CHANGE: moved sql_lib() from M::Base to new M::Role::Query; moved all M::R::QueryFormatter methods into M::R::Query; removed sql_lib() from ScriptHelpers - using new M::Roles::Query method; removed lims_dbix() from M::Base - now loaded via M::Role::DBIxSimple on demand; moved get_sql_with_constraint() from M::R::DBIxSimple to M::R::Query; method gets dbh from lims_db not lims_dbix in M::LabSection::update_lab_sections() & M::Specimen::update_specimens(); added elements() to Local::QueryLibrary

added full_path accessor to ScriptHelpers to allow scripts at other relative paths to use ScriptHelper methods; lantronix now has functional admin_alert for corrupt data streams

refactored L::Utils::get_yaml to only require args needed for construction of path/to/yaml_dir/filename to remove duplication from components requiring a get_yaml_file() method (Controllers, Model & ScriptHelpers)

added get_yaml_file method to L::Model::Base for use by L::L::R::DiagnosisConfirm; moved all instances of YAML::Tiny->read code to L::Local::Utils

moved diagnosis_confirmation_required from Local::Utils to new Local::Role::DiagnosisConfirm - didn't belong in Utils class, and function now needs to access LIMS config to load yaml files dir dynamically depending on CENTRE env param

added get_yaml_file() to ScriptHelpers; expanded null_nhs_numbers.pl to include all requests, and exempted clinical_trials section of nhs_numbers_exempt.yml

patched ScriptHelpers::send_mail() to accept recipient in email address format; patched HMRN treatment data validation to exempt default date from chronological order test; modifcations to requests_and_reports.pl

made all fields read-only/disabled in results page if record is locked; patched Local::Search::generate_query() to skip 'date_extend' field - was causing errors when submitted without date fields; added NHS number to outreach worklists

patched ScriptHelpers::ftp_file() to return ftp->message() only if put command failed, not as method return value, as message() gets replaced by output of quit(); patched ppm_and_results.pl to set unknown referrer value to empty