* 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

fix debug output on 002_index_routes.t; tt tweak for consistent console output for all_patients.t

fix broken demo reports link; fix broken all_patients.t

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

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