update_tables.pl - update patient_access table; add registered date to last report display; replace :3000 with :8000 for dev env (previously removed port so relied on fastcgi running)

bugfix - remove OUT prefix from userId; css tweak

include email as a userId for login; improve README documentation

provide switch to patient_access_demo db using command-line param; requires dynamic loading of patient cols (so Model::SQL gets access to dbix)

move dbix and query functions to new Model classes; general tidy up

switch on file query logging - now off by default (RfC361L); remove spaces from NHS number

adapted login to accept NHS number or OUT + patient.id; implemented check_db_connection in response to mysql has gone away condition

switched to nhs_number login for test; fixed url link for report - didn't work for both devel and deployment

update_tables.pl looks at request.created_at date and left-joins request_followup and pack_dispatch so all outreach requests included, not just when follow-up option and pack dispatch date decided; added session: Cookie to config file - was default for dev but not production; included status = reported to packs.tt request_status.match list - no requests now fail to match a pack status definition

patched pack_dispatches query to return 0 for NULL section_data_count to avoid tt undefined value error; patched _autoinflate_dates() to handle zero values (ie false but still defined); changed method of formatting year from String plugin - test script can't handle it; new test script to grep 'current pack status' content for all patients

new lab_sections_data table for update_tables; new get /login route so config loaded for webapp_name

adjustments for deployment on test server - reduced height of logo as chrome cannot handle button/link overlapping image (using negative margin css)

moved web title to settings webapp_name; moved last login line upwards to prevent title wrapping; pdf report opens in new target link

first commit for adaptation to use HILIS4 export database - replaced D2::Plugin::Database with Local::DB, uses HILIS to print report, uses HILIS patient.id as username, enabled querylogger output to console, amended pack.tt logic to handle 'live' situations

changed db to patient_access_demo - new version will use outreach_patient_access db