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

added result summary template function to report section; renamed C::Ajax function result_template to load_template

patched C::Report::preview_report() to handle Outreach requests; refactored some M::Outreach code into new M::Roles::Outreach role for sharing between reporting function and followup option editing

adjusted outreach follow-up edit rules again; added more detail to outreach follow-up edit history

amended implementation of rulwes for updating Outreach follow-up decision; bug-fix to template display of non-numeric data

Outreach data summary displays calculated values where required; modified Outreach params chart output to accomodate calculated values; Outreach data summary template displays default vals as 'N'K', and numerical results to 3 sig figs; improved HMRN treatment options admin interface