completed molecular pcr worksheet functions

fixed gross description not updating row if specimen_date present

bugfixes - reintroduced new/screened status to gross description worklist; replaced incorrect id on report morphology field preventing javascript replace function working

modified request_report table schema to retain original comment field - morphology becomes a new field; updated simple sql query to new schema

refactored request_report table again - replaced 'vertical' request_specimen_detail and request_report_detail tables with conventional 1-2-1 mapping with request table

interim report refactor commit

histology block refs displayed in year groups; changed date ref to 16 char string for recorded delivery info; returned list of records updated instead of redirect to redisplay block ref worklist

commited changes to production server, made during report refactor on dev box - changed method of retrieving data for chart from screened_as to requested lab-tests; outreach CML patients use same chart as for Imatinib monitoring; activity_data.pl replaces default unknown dates< 1900 with NULL entry; bugfix to audit/revised_diagnosis.tt for users with 0 requests reported during selected duration

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 patient name to gross-description local worklist

changed 'distinct' clause in M::Local::get_outstanding_gross_description() to retrieve sample type

new function to add gross description from worklist

changed local worklist Cut-up & Processing cells for flow option from a result to a status option

changed diagnosis_change_options.reason col to option_id

replaced C::Local::Worklist::Preregistratation::delete() call to L::Model::get_unregistered_request() with call to M::Base::get_object_by_param(), reverted get_unregistered_request() to previous version