new db anonymisation function; screen categories sorted lc (for new PNH/AA entry); fixed syntax error in mpla deployment script

new mlpa lab-section deployment script

new MLPA worklits for new MLPA lab-section - needs rewrite of pcr_and_sequancing _worksheet which is a mess; added department_id to index for DB::EmailContact to allow same location and email address to have multiple departments; adapted M::LabTest::get_section_lab_test() to accept (section name or section.id) + (test name or field label)

genomics v3.2 updates (HaemOnc); added department to email_contacts table unique key

simplified report_notification script, replaced 3 separate timestamp-based queries with 1 request_history query looking for specific actions; removed result_summary change from notification triggers; added linked lab-tests to MPLA deployment script

new MPLA lab-section deployment script; amended trigger definitions; corrected error in genomics xsd file; tested for existence of self_authorisable.yml file or some print_view.t tests fail

fix for persistent apache log warning from IE11 requests; replaced genomics notifications recipient; comment for PrintRun about May Day 2017

bugfixes - var to set genomics system user after xml data transfer failure due to changing users.username without telling perl script; fixed incorrect service address in request_followup.pl template

request lab-test history logs results input/update/delete actions; bugix to .t following recent .tt format changes

moved error reformatting to GenomicsValidation for sharing between genomics_xml.pl & xml_validate.pl; replaced message formatting mess with Template

improved notification message for genomics xml validation failure to specify lab test label and lab section - lab_test_map loaded in GenomicsValidation and shared with genomics_xml.pl

fixed slow running query due to position of th.action & rh.action in SQLA::More - see http://scsys.co.uk:8007/559045 and https://metacpan.org/pod/SQL::Abstract::More#Join-specifications; rearranged order of events in apply_local_rules in view of creation of new row for BMASEQ sample type (pushing on @rows skips any subsequent rules)

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

genomics validation failure notifies relevant centre (Leeds or Sheffield); added update to patient table as trigger for xml data transfer, and initial port to SQL::Abstract::More method of generating query, but far too slow; minor improvement for recent bugfix to linked/default.tt

highlighted selected entry for linked lab test & screen tests (shared component tt); tt bugfix - avoid uninitialized value in addition