interface/new/new_patient_save.php

   1 <?php
   2 require_once("../globals.php");
   3
   4 // Validation for non-unique external patient identifier.
   5 if (!empty($_POST["pubpid"])) {
   6     $form_pubpid = trim($_POST["pubpid"]);
   7     $result = sqlQuery("SELECT count(*) AS count FROM patient_data WHERE " .
   8     "pubpid = ?", array($form_pubpid));
   9     if ($result['count']) {
  10         // Error, not unique.
  11         require_once("new.php");
  12         exit();
  13     }
  14 }
  15
  16 require_once("$srcdir/pid.inc");
  17 require_once("$srcdir/patient.inc");
  18
  19 //here, we lock the patient data table while we find the most recent max PID
  20 //other interfaces can still read the data during this lock, however
  21 sqlStatement("lock tables patient_data read");
  22
  23 $result = sqlQuery("select max(pid)+1 as pid from patient_data");
  24
  25 // TBD: This looks wrong to unlock the table before we have added our
  26 // patient with its newly allocated pid!
  27 //
  28 sqlStatement("unlock tables");
  29 //end table lock
  30 $newpid = 1;
  31
  32 if ($result['pid'] > 1) {
  33     $newpid = $result['pid'];
  34 }
  35
  36 setpid($newpid);
  37
  38 if ($pid == null) {
  39     $pid = 0;
  40 }
  41
  42 // what do we set for the public pid?
  43 if (isset($_POST["pubpid"]) && ($_POST["pubpid"] != "")) {
  44     $mypubpid = $_POST["pubpid"];
  45 } else {
  46     $mypubpid = $pid;
  47 }
  48
  49 if ($_POST['form_create']) {
  50     $form_fname = ucwords(trim($_POST["fname"]));
  51     $form_lname = ucwords(trim($_POST["lname"]));
  52     $form_mname = ucwords(trim($_POST["mname"]));
  53
  54   // ===================
  55   // DBC SYSTEM WAS REMOVED
  56     $form_sex               = trim($_POST["sex"]) ;
  57     $form_dob               = DateToYYYYMMDD(trim($_POST["DOB"])) ;
  58     $form_street            = '' ;
  59     $form_city              = '' ;
  60     $form_postcode          = '' ;
  61     $form_countrycode       = '' ;
  62     $form_regdate           = DateToYYYYMMDD(trim($_POST['regdate']));
  63   // EOS DBC
  64   // ===================
  65
  66     newPatientData(
  67         $_POST["db_id"],
  68         $_POST["title"],
  69         $form_fname,
  70         $form_lname,
  71         $form_mname,
  72         $form_sex, // sex
  73         $form_dob, // dob
  74         $form_street, // street
  75         $form_postcode, // postal_code
  76         $form_city, // city
  77         "", // state
  78         $form_countrycode, // country_code
  79         "", // ss
  80         "", // occupation
  81         "", // phone_home
  82         "", // phone_biz
  83         "", // phone_contact
  84         "", // status
  85         "", // contact_relationship
  86         "", // referrer
  87         "", // referrerID
  88         "", // email
  89         "", // language
  90         "", // ethnoracial
  91         "", // interpreter
  92         "", // migrantseasonal
  93         "", // family_size
  94         "", // monthly_income
  95         "", // homeless
  96         "", // financial_review
  97         "$mypubpid",
  98         $pid,
  99         "", // providerID
 100         "", // genericname1
 101         "", // genericval1
 102         "", // genericname2
 103         "", // genericval2
 104         "", //billing_note
 105         "", // phone_cell
 106         "", // hipaa_mail
 107         "", // hipaa_voice
 108         0,  // squad
 109         0,  // $pharmacy_id = 0,
 110         "", // $drivers_license = "",
 111         "", // $hipaa_notice = "",
 112         "", // $hipaa_message = "",
 113         $form_regdate
 114     );
 115
 116     newEmployerData($pid);
 117     newHistoryData($pid);
 118     newInsuranceData($pid, "primary");
 119     newInsuranceData($pid, "secondary");
 120     newInsuranceData($pid, "tertiary");
 121
 122   // Set referral source separately because we don't want it messed
 123   // with later by newPatientData().
 124     if ($refsource = trim($_POST["refsource"])) {
 125         sqlQuery("UPDATE patient_data SET referral_source = ? " .
 126         "WHERE pid = ?", array($refsource, $pid));
 127     }
 128 }
 129 ?>
 130 <html>
 131 <body>
 132 <script language="Javascript">
 133 <?php
 134 if ($alertmsg) {
 135     echo "alert('" . addslashes($alertmsg) . "');\n";
 136 }
 137
 138   echo "window.location='$rootdir/patient_file/summary/demographics.php?" .
 139     "set_pid=" . attr($pid) . "&is_new=1';\n";
 140 ?>
 141 </script>
 142
 143 </body>
 144 </html>