RSS Git Download  Clone
..
  layouts update_tables.pl - update patient_access table; add registered date to last report display; replace :3000 with :8000 for dev env (previously removed port so relied on fastcgi running) 7 years ago
  bootsnipp_login.tt 2kB first commit for adaptation to use HILIS4 export database - replaced D2::Plugin::Database with Local::DB, uses HILIS to print report, uses HILIS patient.id as username, enabled querylogger output to console, amended pack.tt logic to handle 'live' situations 10 years ago
  dumper.tt 443B adapted dumper.tt to use Template::Plugin::DataPrinter; replaced login page with bootsnipp(et) - forgotten password link doesn't work; tidied up welcome page tables 10 years ago
  gitlog.tt 834B html tidy reports; git version function 10 years ago
  index.tt 5kB initial commit - working framework 10 years ago
  login.tt 216B new lab_sections_data table for update_tables; new get /login route so config loaded for webapp_name 10 years ago
  packs.tt 5kB update_tables.pl looks at request.created_at date and left-joins request_followup and pack_dispatch so all outreach requests included, not just when follow-up option and pack dispatch date decided; added session: Cookie to config file - was default for dev but not production; included status = reported to packs.tt request_status.match list - no requests now fail to match a pack status definition 10 years ago
  patient_details.tt 4kB update_tables.pl - update patient_access table; add registered date to last report display; replace :3000 with :8000 for dev env (previously removed port so relied on fastcgi running) 7 years ago
  welcome.tt 2kB adapt queries for alternate setup using hilis4 & outreach db's only * just needs config dbname change and enabling alternate query sets 7 years ago
  README.txt
Outreach patient access ======================= * default db = outreach_patient_access - updated on LTH149890 daily by cron (bin/update_tables.pl) * alternative 'patient_access_demo' database loaded using command-line param: dbname=patient_access_demo plackup -p xxxx bin/app.psgi * can also be run using hilis4 & outreach db's only - change queries in SQL.pm and config dbname to outreach also don't need dbix() in SQL.pm if using hilis4/outreach - don't need get_cols() patient_access_demo users (email/nhs_number): * user1@email.net/1111111111 : Walter MELON : Next assessment is due on dd.Mon.yyyy [today + 2d] * user2@email.net/2222222222 : Justin CASE : A pack was sent on 21.May.2015 [xx days ago] but has not been received. * user3@email.net/3333333333 : Orsen CART : A pack was received on 12.May.2015 and initial results indicate that no urgent action is required. * user4@email.net/4444444444 : Hazel NUTT : A pack was received on 13.May.2015 and laboratory tests have been initiated. * user5@email.net/5555555555 : Sandy SHORE : A pack was sent on dd.Mon.yyyy [3 days ago] * user6@email.net/6666666666 : Rose PETAL : Return to clinic * login username = email address, patient NHS number or prefix 'OUT' + patient.id (requires >= 2-digit patient id so not for demo) * login password = 'outreach' for default outreach_patient_access, user-part of email (user1, user2, etc) for patient_access_demo, but not required for dev env Pack status rules: IF request_status = complete IF pack_due >= today Next assessment is due on <date> ELSIF pack_sent < today; A pack was sent on <date> [<days> ago] IF > 7 days but has not been received. Please call us to discuss. ELSIF pack_due AND NOT pack_sent Pack was due for dispatch on <date> but has not been sent. Please call us to discuss. ELSE # ? no pack_due date ? <outcome eg return-to-clinic> ELSIF flow AND outreach data A pack was received on <date> and initial results indicate that no urgent action is required. It may take three weeks to obtain all the laboratory test results but we will contact your GP if there are any issues. ELSIF request_status = new, screened or reported A pack was received on <date> and laboratory tests have been initiated. ELSE ** UNKNOWN RECORD STATUS - CHECK DETAILS **