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)

added email patient demographics function (test failure mode not working)

added pre-compiled reports as htm files

switched to custom database for project; imported data from hilis4 & outreach tables for dummy patients; _query uses wantarray for return context; patient details form submission jquery; patient_details.tt presentation edits

adapted dumper.tt to use Template::Plugin::DataPrinter; replaced login page with bootsnipp(et) - forgotten password link doesn't work; tidied up welcome page tables

model auto-inflates dates; model uses D2 app_config instead of FindBin; new patient details table