LIMS::Local::QueryLog - fix permissions issue with previous commit (9171b6a & bf60ec8); format queries for console & log file using SQL::Abstract::Tree

tidy-up .gitignore

fix inability to accept result value zero (0); new tests for 0 result

tidy up (new files + .gitignore)

patches to support Debian 9 test server * replaced hard-coded wkhtmltopdf-<version> with wkhtmltopdf (symlink) as only loaded once for entire app * added return 0 if undefined \$user_location to avoid apache log warnings on non-logged-in user * added block to ftp genomics_transfer.log to main xml_transfer.pl script (no longer need Deb6 curl hack) * lims.fcgi accepts CENTRE arg for use with apache mod_fcgid

add sample ID validation for Genomics; remove genomics.xsd symlink from repository tracking

fix anonymise_db.pl failure to update nhs_number if value already exists in patients table and not yet replaced - didn't consider existing values when generating replacement nhs_numbers; adjusted vertical spacing of HaemOnc SLF for test server

updated auto_screen.t with recent change to screening category names

extended xml validation to include patterns that cannot be validated using XML libs (eg family id pattern); modifications to lab-test field names

moved genomics_xml uat definitions to settings file; new process_size charting script

* new permission update_worklists - necessasy after removing 'data entry' from view_worklist permissions * Model::WorkList::_get_request_status_query_args method tests for @ids - caused error on new deployment

bugfixes: auto_expand lab tests didn't test for value, just presence of table col; gitignored local css files; user message function doesn't need user_location if accessed from 'PM' link

added row counter to do_complete_selected_tests() so only 1st change of status to complete is logged in history file; split incomplete lab-tests display over new lines for genomics settings; added lab-test quick links; added some result-data-types links

bugfixes: specimen validation removes non-alphanum chars (eg xbl,); fixed position of user id display on report for guest using MSIE

new local worklists: outreach unreported & outreach unauthorised