test script edits for migration of deployment server - create/drop triggers require SUPER privileges if log_bin enabled after MySQL v5.0.x

Merge branch 'master' of jti.org.uk:/home/raj/git/hilis4

no signicant change - updating remote git for pulling from HMDS server

bugfixes for UCLH - null nhs number no longer show duplicate entry, new user manual entry validation now case-independant & forces to lower case for db write; changed sysmex socket port to 9001 after having data receipt falure on 9002

new sysmex.pl daemon script

updated .t scripts; unlink pdf tmp file only if exists - occasionally doesn't so generates unlink error

replaced DoI highlighted specimen table cell with biohazard image; extended DoI alert to all worklists (was missing from some); changed C::R::Misc::get_unique_ids to get_unique_request_ids for clarity in caller

major bugfix to worklists - get_unique_ids() incorrectly performed map within foreach loop - caused timeout on block_refs

moved incomplete_requests sql out into library.sql; removed time from incomplete_requests date fields

incomplete_requests.pl split into separate emails per reporter; bugfix to hmrn demographics, broken by previous outreach demographics change

new Molcular sequencing worklist - split out pcr_worklist functions for sharing; amended outreach get_overdue_packs() calculation of overdue-ness to include packs returned same day as dispatch (CML pateints handled in clinic); outreach demographics - skip inactive GP's unless already selected

bugfixes: user_messages template had duplicate new_msg id's; gallium_pending generating duplicate records if request_history duplicated (eg authorised)

put duration display on last_login date for admin user manager

admin user manager highlights if user never logged in; bugfix to readonly field

added last_login to admin user manager display; switched username lookup from drop-down to autosuggest