* 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

fix pack status to return sensible output on default unknown date; standardised dbname env param & db_name app config param

update D2 keyword (path_info); update demo_data.sql

url for reports dependent on dbname (demo uses static html instead of dynamically-generated, dbname defined in init.d script); update params keyword to body_parameters; update documentation

adapt for deployment - apache mod_proxy to carton installation

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

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

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

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