include email as a userId for login; improve README documentation

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

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)

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

added timer for script execution; fixed incorrect name for login password field

new patient dataset for recent pack dispatch

html tidy reports; git version function

removed code block to retrieve results from outreach db - not using it for demo; removed redundant patient_edit.tt - function performed by ajax now; query for new HILIS4 method to retrieve most recent request_id for logged-in user

minor re-factoring and improved code documentation

set development Email::Sender transport to Mbox; highlight changes in patient demographics email; set keyword 'fail' in email param to trigger email failure message; success message to form replaces rather than appends to previous message(s)