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

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

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

last minor modifications before adaptation to use live HILIS data - codebase frozen as v1 tag

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

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

queries handled by SQL::Library; login function responds to user email address as username

initial commit - working framework