convert queries from sql-lib to SQLA (query did not respond to var); opt_t

replace SQL::Library query with SQLAM query - saves having to pass duplicate duration variable

fix duplicate records due to duplicate authorisation entries in request_history * update script to use getopts

add new screening categories to genomics_haemonc script; add new field to genomics_v3.2 xsd

RfC339L - include HTS myeloid sequencing in PNH NCG data feed; update requests table request_number col definition to allow >32768 requests/year

* bhods hl7 script - exit unless requests, no need for remote connection * complete acute-non-myeloid cron script

new script to email new acute non-myeloid leukaemias

added command-line options to crons to allow default duration override

HTS myeloid test charged for all referral sources, uses list of lab-tests instead of presentation to allocate BMASEQ sample type

retired 'Outreach' screening term and replaced with separate outreach categories (ready to switch off auto-screening Outreach); stopped retrieveing outreach data in C::Report::outreach as it's (re)fetched in downstream load() function; defined pnh, hiv, outreach & molecular screening terms as global vars in Model::Audit - easier to amend categories; new simple SQL search field Request Notes

activated apparent_sender = no-reply@hmds.info to avoid rejection of messages from non-existent domain; adapted yearly register_and_error_log.pl to use same tt as monthly version; a failed cytogenetics result is now more verbose so cytogenetics_failed query needs to look for 'failed' as an rlike

added diagnosis context warnings as static view for non-admin users - moved common code to C::Roles::Misc; appended new International Scale result to imatinib tt; adapted Imatinib chart to handle change to International Standard of reporting scheduled for mid-2017; HTS myeloid sequencing set to chargeable outside Y&H region; added Genomcis consent date to Consent update section & added new menu option; email address change for PNH service

2 unimplemented changes a) delete patient with request if no other associated requests - delayed pending review of conseqeunces for Outreach/HMRN, etc b) message 'from' header change to prevent blocking due to non-existant leedsth.nhs.uk domain - pending confirmation of receipt from some sources; added epithelial tumour to histopathology notifications; Comodo secure seal on login page

amended plasma storage worklist template as requested in RfC; corrected genomics_xml update success from $n to $result->rows & added warning on failure to update

moved storage vial deletion validation to DFV method and added 'reason for deletion' form field; added centre id to mail_reports.pl cron log entry; ppm_and_results.pl uses IPC::System::Simple to capture more explicit tar error (was returning 'cannot stat file' msg without script name & location info); added inadequate unfixed specimen to weekly notifications