1. PatientAccess.git
 RSS Git Download  Clone
  bin 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
  environments patched pack_dispatches query to return 0 for NULL section_data_count to avoid tt undefined value error; patched _autoinflate_dates() to handle zero values (ie false but still defined); changed method of formatting year from String plugin - test script can't handle it; new test script to grep 'current pack status' content for all patients 10 years ago
  lib adapt queries for alternate setup using hilis4 & outreach db's only * just needs config dbname change and enabling alternate query sets 7 years ago
  public 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
  src 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
  t switched to nhs_number login for test; fixed url link for report - didn't work for both devel and deployment 10 years ago
  views adapt queries for alternate setup using hilis4 & outreach db's only * just needs config dbname change and enabling alternate query sets 7 years ago
  .gitignore 68B added timer for script execution; fixed incorrect name for login password field 10 years ago
  MANIFEST 435B initial commit - working framework 10 years ago
  MANIFEST.SKIP 166B initial commit - working framework 10 years ago
  Makefile.PL 795B initial commit - working framework 10 years ago
  README.txt 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
  config.yml 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
  cpanfile 300B initial commit - working framework 10 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 **