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

minor bugfix to C::Chart::hiv() calculation of results - case-insensitive to accomodate legecy data; added 'next 50' link to print run output

changed arrangement of blank & neg immunohistochemistry labels for tests & panels; fixed 'copy to' bug in printed reports; results sections displays test name with disabled checkbox if test already has a result - changed from skipped if test has result

tweaked fish worksheets & worklist display order