bugfix to admin new user tt for comparison of last_name to username if apostrophe present

fixed inflate_mysql_date_to_datetime() to protect against invalid dates from pre-HILIS4 data; changed prognostic_indicator test script to manipulate dob instead of diagnosis date to provide better control of age; highlight invalid age in HMRN event data table

adapted xNA extraction worksheets to split xFU into xF & xU samples and adjust for number of blocks for xF, xU & xBL samples; xNA extration worksheets append empty rows to max 12; patched view_cron_log() regex to include hyphenated script names; DB::RequestExternalRef status field required larger varchar value

added process size logging facility to fastcgi process; authorised/incomplete records worklist displays outstanding lab tests; added cd SCRIPT_DIR to fcgi script so git version info loaded when restarted from outside HILIS4 dir

bugfixes: LL::Search doesn't have access to is_lab_staff() method of LIMS::Base so had to create own version; {QUERY_STRING} not passed in 'post' method in request form upload, so substituted CGI, needed 'tkn' param addition to FileUploader default.tt

adapted request forms upload function to provide encrypted 'centre' token so FileUploader puts request forms in correct location (leeds/uclh)

changed update patient method to prevent modification of patient with an NHS number if single_record_only mode selected (nhs number is unique col and can't be shared with another patient profile); new register_edit.t tests

applied same server-side validation to storage vialId as already done by ajax, factored out common regex to LLU; moved M::Ajax::check_storage_vialId() to M::Validation::has_storage_vialId(); applied check that patient entry exists to C::Patient::_check_nhs_number_usage() for PID change, but not implemented as creation of new patient works OK; alphabetically sorted lims_messages.pl dfv section

added linked lab tests function to histology processing_update worklist; adjusted test-lib.pl to skip tables containing REFINER (ucfirst function)

1st part of new function to generate xl worksheet for chimerism data calculation

configured ability to expand panels to lab-tests, configurable by section through yml file + tests appended to results.t; new potential_trial_cases cron

allowing apostrophies in surname for user application; fixed NHS number validation allowing non-digit chars

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

removed escapeHTML function from L::L::Utils to prevent use of CGI/CGI::Simple and risk of clobbering cgi scripts form params if acquired using CGI::Simple - replaced with HTML::Escape::escape_html

solved fileuploader problem - affected registration script also - cgi scripts using CGI::Simple object had params clobbered by L::L::Utils using a global CGI::Simple object (introduced to overcome CGI::Simple::Standard::escapeHTML causing print_run to hang in symbolise() under dev server) - replaced by global CGI object, pending solution to print_run problem under dev server