* move env dbname to uppercase to further disambiguate from app param 'db_name' * use Types::Standard assert_Int/Str for a degree of input param validation * add 'sending....' message to form when sending email * move 'incorrect password' display to #result div to overwrite new 'sending....' msg * new test file for model methods

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)

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

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

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)

reversed previous chnage on login page replacing uri with javascript - was meant for patient_details submission form

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