added authentication function using D2::Plugin::Auth::Extensible; new admin function to register new user; removed GET /login route - using auto_page()

changed user authentication from hilis4.users to hilis4.draft_report_users - automatically creates new entry in draft_report_users table if user exists in hilis.users table

args to Local::DB either dsn or dbname; integration with other apps and Local::QueryLogger; switched off query logging for test scripts

switched off auto-inflate dates in Local::DB pending removal of dates -> datetimes in app/templates

fix for 'mysql gone away' problem in Routes::AJAX - app definition was incorrect, and gave it a 'before' hook to check_db_connection as precaution; removed debugging info in DB::check_db_connection

fix for persistence of broken dbix in DB::sql_lib; added debug info to DB for mysql timeout - used in conjunction with Local::DB debug info

custom 500.tt for errors; replaced 'var' with 'token' in before_template_render - useage breaks custom error tt rendering

fix for 'mysql server has gone away' message - new DB check_db_connection() method clears dbix object if no ping received from db, forcing dbix object recreation; wrapped 'horrible' deferred keyword in flash() method; dev logger uses Console::Colored output

provided get_table_cols method in SQL::Lib; provided method calls for app version & git history

returns message to report screen after submission; forced 'updated_at' timestamp as ON UPDATE doesn't seem to work; moved generation of previous reports list from login to search page and out of session into var; prevented ajax lookup if < 3 chars (seems to generate persistent error if db does search with undef param); moved SQL::Lib methods query construction to new create_query() method; moved 'deferred' display to main layout tt

retrieve list of previously reported requests at login

switched model & app validation classes - DFV currently more suitable for model than HTML::FormHandler: eg manipulating validation profile required fields in model instead of template

retrieves previous requests on nhs_number match; fixed t/validation.t after validation code change

replaced HTTP::Validate with Data::Formvalidator in Reporter::Validator; retrieval of request data includes previous report if submitted by same user otherwise new draft report created; request data saved in session for template in case db update/insert fails and original data needs to be re-displayed; changed validation from HTML::FormHandler to Data::FormValidator, pending ability to select validation profiles; app now fully functional

queries to retrieve test results & result summaries from db; new route class for ajax calls; formatted report_form.tt; provided some tt vars via before_template_render hook