Local::QueryLog * modify substitute_placeholders method to handle bind params containing parens-within-parens * modify Local::DBIxSimple, RDBO & RDBO::Manager to join bind params on null-byte instead of comma to avoid breaking split on bind params which already contain commas * protect placeholder substitution from vars containing question-mark * protect SQL::Abstract::Tree query formatting from control characters (eg parens, question-marks) * append undef's to end of @bind for any trailing table cols with default values (eg timestamp cols) * substitute NULL for undef bind params * simplify _warn_handler() logic, returns early if not required

report notification admin functions

cgiapp_prerun() skips redirect for report notification request; new report_notification search function; function for user to register for report notifications; moved DBIxSimple::dump_query to Local::Utils for sharing with Local::DB; get_practitioner_by_code() now shared with report_notification so loads speculatively; replaced report_available_notification.pl queries with new Local::DB::insert_or_update_if_greater

tightened family_id validation to match existing participant_id + 1st 3 digits of participant_id base range

refactored Roles::PDF so that all reports are generated by same method inline_html_to_pdf_no_webkit() so reports should be identical whether by print run, individual print or print_run.pl cron, and only have one sub to define pdf settings for all functions; print_run.pl takes getopt -t for test; moved family_id validation prefix definition to settings.cfg so test & live can have different values; new entry for pcr_and_sequencing_worksheet.tt

fix error in date calculation - datetime col needs DATE() for single day; moved dump_query() to LL::DBIxSimple and Local::DB

patched L::L::DBIxSimple to handle omiholders and placeholders in same query; new dbix-simple.t to test it; moved loop queries to data-maps in activity_data.pl; replace pipe-delimited file with xl file in gallium data for quintiles

RDBO debug method changed again - now have to specifically ask for $RBDO::Debug to and $RDBO::Manager::Debug using DDBO_DEBUG & RDBO_DEBUG_ON env flags - difficult to get desired outcome from fastcgi processes, crons, devel server and test scripts wrt log files and stderr

changed RDBO_DEBUG flag to RDBO_DEBUG_ON; view_lantronix_log function - unfinished; hilis4.fcgi checks for CENTRE env var and checks pidfile before creating new

changed LIMS::RDBO Rose debugging flags to require RDBO_DEBUG env param to be set - eg lims_server.pl, locally in test scripts, or export console ENV param

date fields on registration made jQuery watermark; a few bugfixes to stop apache error log entries

patched L::Local::DBIxSimple to skip warn if SKIP_RDBO_DEBUG flag set

bugfixes & tweaks; L::L::DBIxSimple doesn't need insert/update/delete method overrides as sql statements go to logs anyway (not sure how)

sub-classed DBIx::Simple in L::Local::DBIxSimple to allow debug output from queries; bugfix in L::C::Test