adjusted M::Audit::_lab_test_data() to return timestamps instead of dates for lab_test_audit.pl script - does not affect lab test turnaround times resource

new lab-test audit script; moved common M::Audit::turnaround_times_lab_tests() functions into M::Audit::_lab_test_data() for share with new lab_test_turnaround_export() function; lab test turnaround times sets correct start time of tests auto-requested at registration (eg histology stains), previously assumed to be at screening; M::Roles::Query::_set_search_constraints() accepts DateTime objects for date_from & date_to params

moved Spreadsheet::WriteExcel::Simple function in Audit M & C classes to Local::Excelhander::generate_spreadsheet(); mail_reports.pl includes filename in stdout to identify potential report failures in cron.log

adapted C::Roles::PatientDemographics to work with RequestForm::Validate - moved some var constructions to wrapper methods overridden in RequestForm::Role::PDS; adapted trial_cases.pl script to generate one XL tab per trial - data includes patient so requires secure contact addresses

bugfix - recent change to new user validation required location param which isn't submitted in user manager page - now optional param; changed quarterly list of specified trial cases to monthly list of all except specified trials; option to specify 'centre' param to lims_server at command-line; changed misleading address for user application form in login template

improved new_user() method of validating input data and tt handling of errs - missing input caused misleading error messages, data validated in both preview & post actions; new status_complete.pl script

moved incomplete_requests sql out into library.sql; removed time from incomplete_requests date fields

added function to edit request diagnosis error via audit resource

cron script adjustments

moved some sql queries from local.sql to library.sql

moved image_server location to /data/files/<centre>

added lab-tests signed-off to Resources audit section; added results summary updates to ppm & results server feed; results summary textbox & select entries joined by new-line not semi-colon

moved report footer to configurable item; lab-test turnaround times includes test auto-requested at diagnosis

lab test turnaround times audit function

fixed failure of report page to load gross_description; fixed failure to record outreach pack dispatch date in history log; printed report contains ICDO3; ppm and results data feed includes morphology, biopsy_site & secondary diagnosis details; report header image moved from tt to settings as configurable option