Local::QueryLog * modify substitute_placeholders method to handle bind params containing parens-within-parens * modify Local::DBIxSimple, RDBO & RDBO::Manager to join bind params on null-byte instead of comma to avoid breaking split on bind params which already contain commas * protect placeholder substitution from vars containing question-mark * protect SQL::Abstract::Tree query formatting from control characters (eg parens, question-marks) * append undef's to end of @bind for any trailing table cols with default values (eg timestamp cols) * substitute NULL for undef bind params * simplify _warn_handler() logic, returns early if not required

Add diagnostic information

fix print_view.t failing tests resulting from RfC464

add 3 new data items to genomics_data.pl; change die command to ok() for yml file check

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

updated report_notification table definition; updated tests to cope with clinical_details now required field (unless confif override); inserted error_clinical_details in tt

adapted email_contacts table to accept department code and report status values (setup/schema/email_reports.sql); redesigned mail_reports.pl -> email_reports.pl to allow multiple departments per hospital/organisation (not supported by mail_reports), and department and report status info now derived from email_contacts tbl, not hard-coded into script; reverted referrer_department => {updated some tests with year change or change of html tag

moved biopsy site reporting from free text to select menu; new ncrs_cosd script to generate xml/snomed data for NCRS; 3434 tests pass

changed print_view.css pre { word-break: keep-all } definition to 'normal' to prevent chrome/wkhtml2pdf line-breaking within words

adapted expire_sessions.pl for multiple centres; application form loads logo from config

logic to determine whether to set request status to complete considers result summary datetime relative to authorisation datetime; replaced io unlink() with system unlink in render_pdf - was giving occasional errors; replaced M::Base::does_authorisation method with Moose attr to save repeat db queries; fixed oversight in _archive_report_details() causing history log to record amended specimen_date at every authorisation; gallium_data.pl checks for comment field to prevent fatal error; more report_status.t tests to test for status change on delayed result summary entry

configured request registration to auto-increment request number (for Cambridge); patched tests to work with auto-incrementing lab number flag

added datetime specimen taken to registration and print_view pages; removed CPA icon from report display (interferes with messaging lionks); changed colours on additional comments display

removed refs to request_gross_description; commented request_status_view for test scripts; added block ref to guest_view.tt; renamed guest_view.t to print_view.t