moved request audit in screening function to optional & disabled it; moved set_querylog_args & set_errorhandler_args near top of cgiapp_prerun() so they take effect for login & session update handling

minor edits & fixes; added clinical trial header to printed reports

patched t/ tests in line with recent app changes

added allow_inline_column_values() to DB::User to allow 'NOW()' to be passed inline - first attempt to fix peristent "could not parse datetime 'now' - invalid date format" error

some bugfixes to hili3_convert scripts (convert MyISAM <=> InnoDB issues)

script runtime displays on nav bar; minor syntax changes to lims_external.fcgi; improved javascript in screen/load_data.tt

new admin/screen/category functions; screening menu uses ajax to populate screening terms manu with selectionbased on screening category

minor bugfixes & syntax changes

new screen_category table; moved screens 'type' col to category_id; modified all screening terms & screening tests admin functions to accomodate new screen_category table; removed ajax validation from screen description & lab test field_label as these use 2 & 3-col unique keys so can't be validated by AJAX; email reports function uses users secure email address as sender; modifed portal_access function to supply SHA1 hash of current date - so failed login not sent back to portal page without explanation; modified mail_reports.pl to use item names instead of table id accessors

HMRN post-code at diagnosis also needs updating during original demographics submission; added validation to HMRN post_code_at_diagnosis value

added hmrn.patient_post_code to hold value at diagnosis (in case it changes as Outreach patient); added function to display & edit hmrn post-code at diagnosis

modified HMRN previous diagnoses list to only skip previous ICDO3 diagnoses if /3 or MGUS (not other /1 or /6); HMRN previous diagnosis list can retrieve records based on record id or patient.id; changed query_modifiers to an array instead of str in site/lab_number.tt; print report only highlights diagnosis if modified AFTER authorisation date

buxfix to print_run calculation of end_date - subtracted 1 min instead of 1 sec, so any relevant change to report in last minute of day would be ignored; added total count hidden field to print_run to allow calculation of last 'next 50' link

added self-close js function for popup windows; changed null request history times (00:00:00) to display as ??:??:??

logic for deciding whether to 'please use NHS number' stamp moved to yml file