interface/forms/procedure_order/new.php

   1 <?php
   2 /**
   3 * Encounter form for entering procedure orders.
   4 *
   5 * Copyright (C) 2010-2013 Rod Roark <rod@sunsetsystems.com>
   6 *
   7 * LICENSE: This program is free software; you can redistribute it and/or
   8 * modify it under the terms of the GNU General Public License
   9 * as published by the Free Software Foundation; either version 2
  10 * of the License, or (at your option) any later version.
  11 * This program is distributed in the hope that it will be useful,
  12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14 * GNU General Public License for more details.
  15 * You should have received a copy of the GNU General Public License
  16 * along with this program.  If not, see <http://opensource.org/licenses/gpl-license.php>.
  17 *
  18 * @package   OpenEMR
  19 * @author    Rod Roark <rod@sunsetsystems.com>
  20 */
  21
  22 require_once("../../globals.php");
  23 require_once("$srcdir/api.inc");
  24 require_once("$srcdir/forms.inc");
  25 require_once("$srcdir/options.inc.php");
  26 require_once("$srcdir/formdata.inc.php");
  27 require_once("$srcdir/formatting.inc.php");
  28 require_once("../../orders/qoe.inc.php");
  29 require_once("../../orders/gen_hl7_order.inc.php");
  30 require_once("../../../custom/code_types.inc.php");
  31
  32 // Defaults for new orders.
  33 $row = array(
  34   'provider_id' => $_SESSION['authUserID'],
  35   'date_ordered' => date('Y-m-d'),
  36   'date_collected' => date('Y-m-d H:i'),
  37 );
  38
  39 if (! $encounter) { // comes from globals.php
  40  die("Internal error: we do not seem to be in an encounter!");
  41 }
  42
  43 function cbvalue($cbname) {
  44  return $_POST[$cbname] ? '1' : '0';
  45 }
  46
  47 function cbinput($name, $colname) {
  48  global $row;
  49  $ret  = "<input type='checkbox' name='$name' value='1'";
  50  if ($row[$colname]) $ret .= " checked";
  51  $ret .= " />";
  52  return $ret;
  53 }
  54
  55 function cbcell($name, $desc, $colname) {
  56  return "<td width='25%' nowrap>" . cbinput($name, $colname) . "$desc</td>\n";
  57 }
  58
  59 function QuotedOrNull($fld) {
  60   if (empty($fld)) return "NULL";
  61   return "'$fld'";
  62 }
  63
  64 $formid = formData('id', 'G') + 0;
  65
  66 // If Save or Transmit was clicked, save the info.
  67 //
  68 if ($_POST['bn_save'] || $_POST['bn_xmit']) {
  69   $ppid = formData('form_lab_id') + 0;
  70
  71   $sets =
  72     "date_ordered = " . QuotedOrNull(formData('form_date_ordered'))     . ", " .
  73     "provider_id = " . (formData('form_provider_id') + 0)               . ", " .
  74     "lab_id = " . $ppid                                                 . ", " .
  75     "date_collected = " . QuotedOrNull(formData('form_date_collected')) . ", " .
  76     "order_priority = '" . formData('form_order_priority')              . "', " .
  77     "order_status = '" . formData('form_order_status')                  . "', " .
  78     "patient_instructions = '" . formData('form_patient_instructions')  . "', " .
  79     "patient_id = '" . $pid                                             . "', " .
  80     "encounter_id = '" . $encounter                                     . "'";
  81
  82   // If updating an existing form...
  83   //
  84   if ($formid) {
  85     $query = "UPDATE procedure_order SET $sets "  .
  86       "WHERE procedure_order_id = '$formid'";
  87     sqlStatement($query);
  88   }
  89
  90   // If adding a new form...
  91   //
  92   else {
  93     $query = "INSERT INTO procedure_order SET $sets";
  94     $formid = sqlInsert($query);
  95     addForm($encounter, "Procedure Order", $formid, "procedure_order", $pid, $userauthorized);
  96   }
  97
  98   // Remove any existing procedures and their answers for this order and
  99   // replace them from the form.
 100
 101   sqlStatement("DELETE FROM procedure_answers WHERE procedure_order_id = ?",
 102     array($formid));
 103   sqlStatement("DELETE FROM procedure_order_code WHERE procedure_order_id = ?",
 104     array($formid));
 105
 106   for ($i = 0; isset($_POST['form_proc_type'][$i]); ++$i) {
 107     $ptid = $_POST['form_proc_type'][$i] + 0;
 108     if ($ptid <= 0) continue;
 109
 110     $prefix = "ans$i" . "_";
 111
 112     $poseq = sqlInsert("INSERT INTO procedure_order_code SET ".
 113       "procedure_order_id = ?, " .
 114       "diagnoses = ?, " .
 115       "procedure_code = (SELECT procedure_code FROM procedure_type WHERE procedure_type_id = ?), " .
 116       "procedure_name = (SELECT name FROM procedure_type WHERE procedure_type_id = ?)",
 117       array($formid, strip_escape_custom($_POST['form_proc_type_diag'][$i]), $ptid, $ptid));
 118
 119     $qres = sqlStatement("SELECT " .
 120       "q.procedure_code, q.question_code, q.options, q.fldtype " .
 121       "FROM procedure_type AS t " .
 122       "JOIN procedure_questions AS q ON q.lab_id = t.lab_id " .
 123       "AND q.procedure_code = t.procedure_code AND q.activity = 1 " .
 124       "WHERE t.procedure_type_id = ? " .
 125       "ORDER BY q.seq, q.question_text", array($ptid));
 126
 127     while ($qrow = sqlFetchArray($qres)) {
 128       $options = trim($qrow['options']);
 129       $qcode = trim($qrow['question_code']);
 130       $fldtype = $qrow['fldtype'];
 131       $data = '';
 132       if ($fldtype == 'G') {
 133         if ($_POST["G1_$prefix$qcode"]) {
 134           $data = $_POST["G1_$prefix$qcode"] * 7 + $_POST["G2_$prefix$qcode"];
 135         }
 136       }
 137       else {
 138         $data = $_POST["$prefix$qcode"];
 139       }
 140       if (!isset($data) || $data === '') continue;
 141       if (!is_array($data)) $data = array($data);
 142       foreach ($data as $datum) {
 143         // Note this will auto-assign the seq value.
 144         sqlStatement("INSERT INTO procedure_answers SET ".
 145           "procedure_order_id = ?, " .
 146           "procedure_order_seq = ?, " .
 147           "question_code = ?, " .
 148           "answer = ?",
 149           array($formid, $poseq, $qcode, strip_escape_custom($datum)));
 150       }
 151     }
 152   }
 153
 154   $alertmsg = '';
 155   if ($_POST['bn_xmit']) {
 156     $hl7 = '';
 157     $alertmsg = gen_hl7_order($formid, $hl7);
 158     if (empty($alertmsg)) {
 159       $alertmsg = send_hl7_order($ppid, $hl7);
 160     }
 161     if (empty($alertmsg)) {
 162       sqlStatement("UPDATE procedure_order SET date_transmitted = NOW() WHERE " .
 163         "procedure_order_id = ?", array($formid));
 164     }
 165   }
 166
 167   formHeader("Redirecting....");
 168   if ($alertmsg) {
 169     echo "\n<script language='Javascript'>alert('";
 170     echo addslashes(xl('Transmit failed') . ': ' . $alertmsg);
 171     echo "')</script>\n";
 172   }
 173   formJump();
 174   formFooter();
 175   exit;
 176 }
 177
 178 if ($formid) {
 179   $row = sqlQuery ("SELECT * FROM procedure_order WHERE " .
 180     "procedure_order_id = ?",
 181     array($formid)) ;
 182 }
 183
 184 $enrow = sqlQuery("SELECT p.fname, p.mname, p.lname, fe.date FROM " .
 185   "form_encounter AS fe, forms AS f, patient_data AS p WHERE " .
 186   "p.pid = ? AND f.pid = p.pid AND f.encounter = ? AND " .
 187   "f.formdir = 'newpatient' AND f.deleted = 0 AND " .
 188   "fe.id = f.form_id LIMIT 1",
 189   array($pid, $encounter));
 190 ?>
 191 <html>
 192 <head>
 193 <?php html_header_show(); ?>
 194 <link rel="stylesheet" href="<?php echo $css_header;?>" type="text/css" />
 195
 196 <style>
 197
 198 td {
 199  font-size:10pt;
 200 }
 201
 202 .inputtext {
 203  padding-left:2px;
 204  padding-right:2px;
 205 }
 206
 207 </style>
 208
 209 <style type="text/css">@import url(<?php echo $GLOBALS['webroot'] ?>/library/dynarch_calendar.css);</style>
 210 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/dynarch_calendar.js"></script>
 211 <?php include_once("{$GLOBALS['srcdir']}/dynarch_calendar_en.inc.php"); ?>
 212 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/dynarch_calendar_setup.js"></script>
 213
 214 <script type="text/javascript" src="../../../library/dialog.js"></script>
 215 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/textformat.js"></script>
 216
 217 <script language='JavaScript'>
 218
 219 // This invokes the find-procedure-type popup.
 220 // formseq = 0-relative index in the form.
 221 var gbl_formseq;
 222 function sel_proc_type(formseq) {
 223  var f = document.forms[0];
 224  // if (!f.form_lab_id.value) {
 225  //  alert('<?php echo xls('Please select a procedure provider'); ?>');
 226  //  return;
 227  // }
 228  gbl_formseq = formseq;
 229  var ptvarname = 'form_proc_type[' + formseq + ']';
 230  /********************************************************************
 231  dlgopen('../../orders/types.php?popup=1' +
 232   '&labid=' + f.form_lab_id.value +
 233   '&order=' + f[ptvarname].value +
 234   '&formid=<?php echo $formid; ?>' +
 235   '&formseq=' + formseq,
 236   '_blank', 800, 500);
 237  ********************************************************************/
 238  // This replaces the above for an easier/faster order picker tool.
 239  dlgopen('../../orders/find_order_popup.php' +
 240   '?labid=' + f.form_lab_id.value +
 241   '&order=' + f[ptvarname].value +
 242   '&formid=<?php echo $formid; ?>' +
 243   '&formseq=' + formseq,
 244   '_blank', 800, 500);
 245 }
 246
 247 // This is for callback by the find-procedure-type popup.
 248 // Sets both the selected type ID and its descriptive name.
 249 function set_proc_type(typeid, typename) {
 250  var f = document.forms[0];
 251  var ptvarname = 'form_proc_type[' + gbl_formseq + ']';
 252  var ptdescname = 'form_proc_type_desc[' + gbl_formseq + ']';
 253  f[ptvarname].value = typeid;
 254  f[ptdescname].value = typename;
 255 }
 256
 257 // This is also for callback by the find-procedure-type popup.
 258 // Sets the contents of the table containing the form fields for questions.
 259 function set_proc_html(s, js) {
 260  document.getElementById('qoetable[' + gbl_formseq + ']').innerHTML = s;
 261  eval(js);
 262 }
 263
 264 // New lab selected so clear all procedures and questions from the form.
 265 function lab_id_changed() {
 266  var f = document.forms[0];
 267  for (var i = 0; true; ++i) {
 268   var ix = '[' + i + ']';
 269   if (!f['form_proc_type' + ix]) break;
 270   f['form_proc_type' + ix].value = '-1';
 271   f['form_proc_type_desc' + ix].value = '';
 272   document.getElementById('qoetable' + ix).innerHTML = '';
 273  }
 274 }
 275
 276 // Add a line for entry of another procedure.
 277 function addProcLine() {
 278  var f = document.forms[0];
 279  var table = document.getElementById('proctable');
 280  // Compute i = next procedure index.
 281  var i = 0;
 282  for (; f['form_proc_type[' + i + ']']; ++i);
 283  var row = table.insertRow(table.rows.length);
 284  var cell = row.insertCell(0);
 285  cell.vAlign = 'top';
 286  cell.innerHTML = "<b><?php echo xls('Procedure'); ?> " + (i + 1) + ":</b>";
 287  var cell = row.insertCell(1);
 288  cell.vAlign = 'top';
 289  cell.innerHTML =
 290   "<input type='text' size='50' name='form_proc_type_desc[" + i + "]'" +
 291   " onclick='sel_proc_type(" + i + ")'" +
 292   " onfocus='this.blur()'" +
 293   " title='<?php echo xla('Click to select the desired procedure'); ?>'" +
 294   "  style='width:100%;cursor:pointer;cursor:hand' readonly />" +
 295   " <input type='hidden' name='form_proc_type[" + i + "]' value='-1' />" +
 296   "<br /><b><?php echo xla('Diagnoses'); ?>: </b>" +
 297   "<input type='text' size='50' name='form_proc_type_diag[" + i + "]'" +
 298   " onclick='sel_related(this.name)'" +
 299   " title='<?php echo xla('Click to add a diagnosis'); ?>'" +
 300   " onfocus='this.blur()'" +
 301   " style='cursor:pointer;cursor:hand' readonly />" +
 302   " <div style='width:95%;' id='qoetable[" + i + "]'></div>";
 303  sel_proc_type(i);
 304  return false;
 305 }
 306
 307 // The name of the form field for find-code popup results.
 308 var rcvarname;
 309
 310 // This is for callback by the find-code popup.
 311 // Appends to or erases the current list of related codes.
 312 function set_related(codetype, code, selector, codedesc) {
 313  var f = document.forms[0];
 314  var s = f[rcvarname].value;
 315  if (code) {
 316   if (s.length > 0) s += ';';
 317   s += codetype + ':' + code;
 318  } else {
 319   s = '';
 320  }
 321  f[rcvarname].value = s;
 322 }
 323
 324 // This invokes the find-code popup.
 325 function sel_related(varname) {
 326  rcvarname = varname;
 327  // codetype is just to make things easier and avoid mistakes.
 328  // Might be nice to have a lab parameter for acceptable code types.
 329  // Also note the controlling script here runs from interface/patient_file/encounter/.
 330  dlgopen('find_code_popup.php?codetype=<?php echo attr(collect_codetypes("diagnosis","csv")) ?>', '_blank', 500, 400);
 331 }
 332
 333 var transmitting = false;
 334
 335 // Issue a Cancel/OK warning if a previously transmitted order is being transmitted again.
 336 function validate(f) {
 337 <?php if (!empty($row['date_transmitted'])) { ?>
 338  if (transmitting) {
 339   if (!confirm('<?php echo xls('This order was already transmitted on') . ' ' .
 340     addslashes($row['date_transmitted']) . '. ' .
 341     xls('Are you sure you want to transmit it again?'); ?>')) {
 342     return false;
 343   }
 344  }
 345 <?php } ?>
 346  top.restoreSession();
 347  return true;
 348 }
 349
 350 </script>
 351
 352 </head>
 353
 354 <body class="body_top">
 355
 356 <form method="post" action="<?php echo $rootdir ?>/forms/procedure_order/new.php?id=<?php echo $formid ?>"
 357  onsubmit="return validate(this)">
 358
 359 <p class='title' style='margin-top:8px;margin-bottom:8px;text-align:center'>
 360 <?php
 361   echo xl('Procedure Order for') . ' ';
 362   echo $enrow['fname'] . ' ' . $enrow['mname'] . ' ' . $enrow['lname'];
 363   echo ' ' . xl('on') . ' ' . oeFormatShortDate(substr($enrow['date'], 0, 10));
 364 ?>
 365 </p>
 366
 367 <center>
 368
 369 <p>
 370 <table border='1' width='95%' id='proctable'>
 371
 372  <tr>
 373   <td width='1%' valign='top' nowrap><b><?php xl('Ordering Provider','e'); ?>:</b></td>
 374   <td valign='top'>
 375 <?php
 376 generate_form_field(array('data_type'=>10,'field_id'=>'provider_id'),
 377   $row['provider_id']);
 378 ?>
 379   </td>
 380  </tr>
 381
 382  <tr>
 383   <td width='1%' valign='top' nowrap><b><?php xl('Sending To','e'); ?>:</b></td>
 384   <td valign='top'>
 385    <select name='form_lab_id' onchange='lab_id_changed()'>
 386  <?php
 387   $ppres = sqlStatement("SELECT ppid, name FROM procedure_providers " .
 388     "ORDER BY name, ppid");
 389   while ($pprow = sqlFetchArray($ppres)) {
 390     echo "<option value='" . attr($pprow['ppid']) . "'";
 391     if ($pprow['ppid'] == $row['lab_id']) echo " selected";
 392     echo ">" . text($pprow['name']) . "</option>";
 393   }
 394 ?>
 395    </select>
 396   </td>
 397  </tr>
 398
 399  <tr>
 400   <td width='1%' valign='top' nowrap><b><?php xl('Order Date','e'); ?>:</b></td>
 401   <td valign='top'>
 402 <?php
 403     echo "<input type='text' size='10' name='form_date_ordered' id='form_date_ordered'" .
 404       " value='" . $row['date_ordered'] . "'" .
 405       " title='" . xl('Date of this order') . "'" .
 406       " onkeyup='datekeyup(this,mypcc)' onblur='dateblur(this,mypcc)'" .
 407       " />" .
 408       "<img src='$rootdir/pic/show_calendar.gif' align='absbottom' width='24' height='22'" .
 409       " id='img_date_ordered' border='0' alt='[?]' style='cursor:pointer'" .
 410       " title='" . xl('Click here to choose a date') . "' />";
 411 ?>
 412   </td>
 413  </tr>
 414
 415  <tr>
 416   <td width='1%' valign='top' nowrap><b><?php xl('Internal Time Collected','e'); ?>:</b></td>
 417   <td valign='top'>
 418 <?php
 419     echo "<input type='text' size='16' name='form_date_collected' id='form_date_collected'" .
 420       " value='" . substr($row['date_collected'], 0, 16) . "'" .
 421       " title='" . xl('Date and time that the sample was collected') . "'" .
 422       // " onkeyup='datekeyup(this,mypcc)' onblur='dateblur(this,mypcc)'" .
 423       " />" .
 424       "<img src='$rootdir/pic/show_calendar.gif' align='absbottom' width='24' height='22'" .
 425       " id='img_date_collected' border='0' alt='[?]' style='cursor:pointer'" .
 426       " title='" . xl('Click here to choose a date and time') . "' />";
 427 ?>
 428   </td>
 429  </tr>
 430
 431  <tr>
 432   <td width='1%' valign='top' nowrap><b><?php xl('Priority','e'); ?>:</b></td>
 433   <td valign='top'>
 434 <?php
 435 generate_form_field(array('data_type'=>1,'field_id'=>'order_priority',
 436   'list_id'=>'ord_priority'), $row['order_priority']);
 437 ?>
 438   </td>
 439  </tr>
 440
 441  <tr>
 442   <td width='1%' valign='top' nowrap><b><?php xl('Status','e'); ?>:</b></td>
 443   <td valign='top'>
 444 <?php
 445 generate_form_field(array('data_type'=>1,'field_id'=>'order_status',
 446   'list_id'=>'ord_status'), $row['order_status']);
 447 ?>
 448   </td>
 449  </tr>
 450
 451  <tr>
 452   <td width='1%' valign='top' nowrap><b><?php xl('Patient Instructions','e'); ?>:</b></td>
 453   <td valign='top'>
 454    <textarea rows='3' cols='40' name='form_patient_instructions' style='width:100%'
 455     wrap='virtual' class='inputtext' /><?php echo $row['patient_instructions'] ?></textarea>
 456   </td>
 457  </tr>
 458
 459 <?php
 460
 461   // This section merits some explanation. :)
 462   //
 463   // If any procedures have already been saved for this form, then a top-level table row is
 464   // created for each of them, and includes the relevant questions and any existing answers.
 465   // Otherwise a single empty table row is created for entering the first or only procedure.
 466   //
 467   // If a new procedure is selected or changed, the questions for it are (re)generated from
 468   // the dialog window from which the procedure is selected, via JavaScript.  The sel_proc_type
 469   // function and the types.php script that it invokes collaborate to support this feature.
 470   //
 471   // The generate_qoe_html function in qoe.inc.php contains logic to generate the HTML for
 472   // the questions, and can be invoked either from this script or from types.php.
 473   //
 474   // The $i counter that you see below is to resolve the need for unique names for form fields
 475   // that may occur for each of the multiple procedure requests within the same order.
 476   // procedure_order_seq serves a similar need for uniqueness at the database level.
 477
 478   $oparr = array();
 479   if ($formid) {
 480     $opres = sqlStatement("SELECT " .
 481       "pc.procedure_order_seq, pc.procedure_code, pc.procedure_name, " .
 482       "pc.diagnoses, pt.procedure_type_id " .
 483       "FROM procedure_order_code AS pc " .
 484       "LEFT JOIN procedure_type AS pt ON pt.lab_id = ? AND " .
 485       "pt.procedure_code = pc.procedure_code " .
 486       "WHERE pc.procedure_order_id = ? " .
 487       "ORDER BY pc.procedure_order_seq",
 488       array($row['lab_id'], $formid));
 489     while ($oprow = sqlFetchArray($opres)) {
 490       $oparr[] = $oprow;
 491     }
 492   }
 493   if (empty($oparr)) $oparr[] = array('procedure_name' => '');
 494
 495   $i = 0;
 496   foreach ($oparr as $oprow) {
 497     $ptid = -1; // -1 means no procedure is selected yet
 498     if (!empty($oprow['procedure_type_id'])) {
 499       $ptid = $oprow['procedure_type_id'];
 500     }
 501 ?>
 502  <tr>
 503   <td width='1%' valign='top'><b><?php echo xl('Procedure') . ' ' . ($i + 1); ?>:</b></td>
 504   <td valign='top'>
 505    <input type='text' size='50' name='form_proc_type_desc[<?php echo $i; ?>]'
 506     value='<?php echo attr($oprow['procedure_name']) ?>'
 507     onclick="sel_proc_type(<?php echo $i; ?>)"
 508     onfocus='this.blur()'
 509     title='<?php xla('Click to select the desired procedure','e'); ?>'
 510     style='width:100%;cursor:pointer;cursor:hand' readonly />
 511    <input type='hidden' name='form_proc_type[<?php echo $i; ?>]' value='<?php echo $ptid ?>' />
 512    <br /><b><?php echo xlt('Diagnoses'); ?>:</b>
 513    <input type='text' size='50' name='form_proc_type_diag[<?php echo $i; ?>]'
 514     value='<?php echo attr($oprow['diagnoses']) ?>' onclick='sel_related(this.name)'
 515     title='<?php echo xla('Click to add a diagnosis'); ?>'
 516     onfocus='this.blur()'
 517     style='cursor:pointer;cursor:hand' readonly />
 518    <!-- MSIE innerHTML property for a TABLE element is read-only, so using a DIV here. -->
 519    <div style='width:95%;' id='qoetable[<?php echo $i; ?>]'>
 520 <?php
 521 $qoe_init_javascript = '';
 522 echo generate_qoe_html($ptid, $formid, $oprow['procedure_order_seq'], $i);
 523 if ($qoe_init_javascript)
 524   echo "<script language='JavaScript'>$qoe_init_javascript</script>";
 525 ?>
 526    </div>
 527   </td>
 528  </tr>
 529 <?php
 530     ++$i;
 531   }
 532 ?>
 533
 534 </table>
 535
 536 <p>
 537 <input type='button' value='<?php echo xla('Add Procedure'); ?>' onclick="addProcLine()" />
 538 &nbsp;
 539 <input type='submit' name='bn_save' value='<?php echo xla('Save'); ?>' onclick='transmitting = false;' />
 540 &nbsp;
 541 <input type='submit' name='bn_xmit' value='<?php echo xla('Save and Transmit'); ?>' onclick='transmitting = true;' />
 542 &nbsp;
 543 <input type='button' value='<?php echo xla('Cancel'); ?>' onclick="top.restoreSession();location='<?php echo $GLOBALS['form_exit_url']; ?>'" />
 544 </p>
 545
 546 </center>
 547
 548 <script language='JavaScript'>
 549 Calendar.setup({inputField:'form_date_ordered', ifFormat:'%Y-%m-%d',
 550  button:'img_date_ordered'});
 551 Calendar.setup({inputField:'form_date_collected', ifFormat:'%Y-%m-%d %H:%M',
 552  button:'img_date_collected', showsTime:true});
 553 </script>
 554
 555 </form>
 556 </body>
 557 </html>
 558