completed outreach overdue pack notification function; moved logic to skip if notification already sent from template to model; separated outreach worklists from other worklists; switched off PDS lookup for test scripts; patched validation_profiles/admin.t consistent with change to username validation

outreach pack overdue letters dispatch worklist

modified outreach overdue model method to avoid needing ever-expanding NHS number list in 2nd query

added check_username() method to validation to allow hyphenated surnames; added requirement for PB with BMA sample to report

tweak outreach eq5d template

MAJOR CHANGE: moved sql_lib() from M::Base to new M::Role::Query; moved all M::R::QueryFormatter methods into M::R::Query; removed sql_lib() from ScriptHelpers - using new M::Roles::Query method; removed lims_dbix() from M::Base - now loaded via M::Role::DBIxSimple on demand; moved get_sql_with_constraint() from M::R::DBIxSimple to M::R::Query; method gets dbh from lims_db not lims_dbix in M::LabSection::update_lab_sections() & M::Specimen::update_specimens(); added elements() to Local::QueryLibrary

added timestamp col to practice_blood_tube; sorted practice blood tube overrides by post-code (ascii-numeric)

new resource outreach practice blood tube overrides; template replace function in flash_dfv_msg.tt

corrected Outreach pack forms worklist to use GP post-code to determine blood tube types, not patient address post-code

re-factored M::Outreach::get_overdue_packs() to avoid multiple table lookups within loops; chimerism chart requires > 1 dataset to plot; bugfixes, reworded user/reset_password.tt

change to rules for hiding unauthorised reports pre-2006 to guest users

bugfixes to outreach add alternate address function & bcr-abl import data function

added H&E/Giemsa test to H&E worklist; major Outreach changes - changed self_care_1 & self_care_2 fields to self_care & usual_activity; made all lab-param fields optional for validation; made heath_index field on outreach.questionnaire_eq5d optional; M::Outreach::update_patient_questionnaire() only attempts to write new data if data for table exists - to allow outreach questionnaire submission with empty EQ5D fields; outreach demographics.dispatch_to val defaults to home

bugfixes; added new Outreach method get_lab_param()

moved patient_notes from Outreach reqeusts to all reqeusts; report page loads chart if applicable to request type