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   }
 162
 163   // TBD: Implement and set a transmit date in the order.
 164   // Add code elsewhere to show a warning if a previously transmitted order is opened.
 165
 166   formHeader("Redirecting....");
 167   if ($alertmsg) {
 168     echo "\n<script language='Javascript'>alert('";
 169     echo addslashes(xl('Transmit failed') . ': ' . $alertmsg);
 170     echo "')</script>\n";
 171   }
 172   formJump();
 173   formFooter();
 174   exit;
 175 }
 176
 177 if ($formid) {
 178   $row = sqlQuery ("SELECT * FROM procedure_order WHERE " .
 179     "procedure_order_id = ?",
 180     array($formid)) ;
 181 }
 182
 183 $enrow = sqlQuery("SELECT p.fname, p.mname, p.lname, fe.date FROM " .
 184   "form_encounter AS fe, forms AS f, patient_data AS p WHERE " .
 185   "p.pid = ? AND f.pid = p.pid AND f.encounter = ? AND " .
 186   "f.formdir = 'newpatient' AND f.deleted = 0 AND " .
 187   "fe.id = f.form_id LIMIT 1",
 188   array($pid, $encounter));
 189 ?>
 190 <html>
 191 <head>
 192 <?php html_header_show(); ?>
 193 <link rel="stylesheet" href="<?php echo $css_header;?>" type="text/css" />
 194
 195 <style>
 196
 197 td {
 198  font-size:10pt;
 199 }
 200
 201 .inputtext {
 202  padding-left:2px;
 203  padding-right:2px;
 204 }
 205
 206 </style>
 207
 208 <style type="text/css">@import url(<?php echo $GLOBALS['webroot'] ?>/library/dynarch_calendar.css);</style>
 209 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/dynarch_calendar.js"></script>
 210 <?php include_once("{$GLOBALS['srcdir']}/dynarch_calendar_en.inc.php"); ?>
 211 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/dynarch_calendar_setup.js"></script>
 212
 213 <script type="text/javascript" src="../../../library/dialog.js"></script>
 214 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/textformat.js"></script>
 215
 216 <script language='JavaScript'>
 217
 218 // This invokes the find-procedure-type popup.
 219 // formseq = 0-relative index in the form.
 220 var gbl_formseq;
 221 function sel_proc_type(formseq) {
 222  var f = document.forms[0];
 223  // if (!f.form_lab_id.value) {
 224  //  alert('<?php echo xls('Please select a procedure provider'); ?>');
 225  //  return;
 226  // }
 227  gbl_formseq = formseq;
 228  var ptvarname = 'form_proc_type[' + formseq + ']';
 229  /********************************************************************
 230  dlgopen('../../orders/types.php?popup=1' +
 231   '&labid=' + f.form_lab_id.value +
 232   '&order=' + f[ptvarname].value +
 233   '&formid=<?php echo $formid; ?>' +
 234   '&formseq=' + formseq,
 235   '_blank', 800, 500);
 236  ********************************************************************/
 237  // This replaces the above for an easier/faster order picker tool.
 238  dlgopen('../../orders/find_order_popup.php' +
 239   '?labid=' + f.form_lab_id.value +
 240   '&order=' + f[ptvarname].value +
 241   '&formid=<?php echo $formid; ?>' +
 242   '&formseq=' + formseq,
 243   '_blank', 800, 500);
 244 }
 245
 246 // This is for callback by the find-procedure-type popup.
 247 // Sets both the selected type ID and its descriptive name.
 248 function set_proc_type(typeid, typename) {
 249  var f = document.forms[0];
 250  var ptvarname = 'form_proc_type[' + gbl_formseq + ']';
 251  var ptdescname = 'form_proc_type_desc[' + gbl_formseq + ']';
 252  f[ptvarname].value = typeid;
 253  f[ptdescname].value = typename;
 254 }
 255
 256 // This is also for callback by the find-procedure-type popup.
 257 // Sets the contents of the table containing the form fields for questions.
 258 function set_proc_html(s, js) {
 259  document.getElementById('qoetable[' + gbl_formseq + ']').innerHTML = s;
 260  eval(js);
 261 }
 262
 263 // New lab selected so clear all procedures and questions from the form.
 264 function lab_id_changed() {
 265  var f = document.forms[0];
 266  for (var i = 0; true; ++i) {
 267   var ix = '[' + i + ']';
 268   if (!f['form_proc_type' + ix]) break;
 269   f['form_proc_type' + ix].value = '-1';
 270   f['form_proc_type_desc' + ix].value = '';
 271   document.getElementById('qoetable' + ix).innerHTML = '';
 272  }
 273 }
 274
 275 // Add a line for entry of another procedure.
 276 function addProcLine() {
 277  var f = document.forms[0];
 278  var table = document.getElementById('proctable');
 279  // Compute i = next procedure index.
 280  var i = 0;
 281  for (; f['form_proc_type[' + i + ']']; ++i);
 282  var row = table.insertRow(table.rows.length);
 283  var cell = row.insertCell(0);
 284  cell.vAlign = 'top';
 285  cell.innerHTML = "<b><?php echo xls('Procedure'); ?> " + (i + 1) + ":</b>";
 286  var cell = row.insertCell(1);
 287  cell.vAlign = 'top';
 288  cell.innerHTML =
 289   "<input type='text' size='50' name='form_proc_type_desc[" + i + "]'" +
 290   " onclick='sel_proc_type(" + i + ")'" +
 291   " onfocus='this.blur()'" +
 292   " title='<?php echo xla('Click to select the desired procedure'); ?>'" +
 293   "  style='width:100%;cursor:pointer;cursor:hand' readonly />" +
 294   " <input type='hidden' name='form_proc_type[" + i + "]' value='-1' />" +
 295   "<br /><b><?php echo xla('Diagnoses'); ?>: </b>" +
 296   "<input type='text' size='50' name='form_proc_type_diag[" + i + "]'" +
 297   " onclick='sel_related(this.name)'" +
 298   " title='<?php echo xla('Click to add a diagnosis'); ?>'" +
 299   " onfocus='this.blur()'" +
 300   " style='cursor:pointer;cursor:hand' readonly />" +
 301   " <div style='width:95%;' id='qoetable[" + i + "]'></div>";
 302  sel_proc_type(i);
 303  return false;
 304 }
 305
 306 // The name of the form field for find-code popup results.
 307 var rcvarname;
 308
 309 // This is for callback by the find-code popup.
 310 // Appends to or erases the current list of related codes.
 311 function set_related(codetype, code, selector, codedesc) {
 312  var f = document.forms[0];
 313  var s = f[rcvarname].value;
 314  if (code) {
 315   if (s.length > 0) s += ';';
 316   s += codetype + ':' + code;
 317  } else {
 318   s = '';
 319  }
 320  f[rcvarname].value = s;
 321 }
 322
 323 // This invokes the find-code popup.
 324 function sel_related(varname) {
 325  rcvarname = varname;
 326  // codetype is just to make things easier and avoid mistakes.
 327  // Might be nice to have a lab parameter for acceptable code types.
 328  // Also note the controlling script here runs from interface/patient_file/encounter/.
 329  dlgopen('find_code_popup.php?codetype=<?php echo attr(collect_codetypes("diagnosis","csv")) ?>', '_blank', 500, 400);
 330 }
 331
 332 </script>
 333
 334 </head>
 335
 336 <body class="body_top">
 337
 338 <form method="post" action="<?php echo $rootdir ?>/forms/procedure_order/new.php?id=<?php echo $formid ?>" onsubmit="return top.restoreSession()">
 339
 340 <p class='title' style='margin-top:8px;margin-bottom:8px;text-align:center'>
 341 <?php
 342   echo xl('Procedure Order for') . ' ';
 343   echo $enrow['fname'] . ' ' . $enrow['mname'] . ' ' . $enrow['lname'];
 344   echo ' ' . xl('on') . ' ' . oeFormatShortDate(substr($enrow['date'], 0, 10));
 345 ?>
 346 </p>
 347
 348 <center>
 349
 350 <p>
 351 <table border='1' width='95%' id='proctable'>
 352
 353  <tr>
 354   <td width='1%' valign='top' nowrap><b><?php xl('Ordering Provider','e'); ?>:</b></td>
 355   <td valign='top'>
 356 <?php
 357 generate_form_field(array('data_type'=>10,'field_id'=>'provider_id'),
 358   $row['provider_id']);
 359 ?>
 360   </td>
 361  </tr>
 362
 363  <tr>
 364   <td width='1%' valign='top' nowrap><b><?php xl('Sending To','e'); ?>:</b></td>
 365   <td valign='top'>
 366    <select name='form_lab_id' onchange='lab_id_changed()'>
 367  <?php
 368   $ppres = sqlStatement("SELECT ppid, name FROM procedure_providers " .
 369     "ORDER BY name, ppid");
 370   while ($pprow = sqlFetchArray($ppres)) {
 371     echo "<option value='" . attr($pprow['ppid']) . "'";
 372     if ($pprow['ppid'] == $row['lab_id']) echo " selected";
 373     echo ">" . text($pprow['name']) . "</option>";
 374   }
 375 ?>
 376    </select>
 377   </td>
 378  </tr>
 379
 380  <tr>
 381   <td width='1%' valign='top' nowrap><b><?php xl('Order Date','e'); ?>:</b></td>
 382   <td valign='top'>
 383 <?php
 384     echo "<input type='text' size='10' name='form_date_ordered' id='form_date_ordered'" .
 385       " value='" . $row['date_ordered'] . "'" .
 386       " title='" . xl('Date of this order') . "'" .
 387       " onkeyup='datekeyup(this,mypcc)' onblur='dateblur(this,mypcc)'" .
 388       " />" .
 389       "<img src='$rootdir/pic/show_calendar.gif' align='absbottom' width='24' height='22'" .
 390       " id='img_date_ordered' border='0' alt='[?]' style='cursor:pointer'" .
 391       " title='" . xl('Click here to choose a date') . "' />";
 392 ?>
 393   </td>
 394  </tr>
 395
 396  <tr>
 397   <td width='1%' valign='top' nowrap><b><?php xl('Internal Time Collected','e'); ?>:</b></td>
 398   <td valign='top'>
 399 <?php
 400     echo "<input type='text' size='16' name='form_date_collected' id='form_date_collected'" .
 401       " value='" . substr($row['date_collected'], 0, 16) . "'" .
 402       " title='" . xl('Date and time that the sample was collected') . "'" .
 403       // " onkeyup='datekeyup(this,mypcc)' onblur='dateblur(this,mypcc)'" .
 404       " />" .
 405       "<img src='$rootdir/pic/show_calendar.gif' align='absbottom' width='24' height='22'" .
 406       " id='img_date_collected' border='0' alt='[?]' style='cursor:pointer'" .
 407       " title='" . xl('Click here to choose a date and time') . "' />";
 408 ?>
 409   </td>
 410  </tr>
 411
 412  <tr>
 413   <td width='1%' valign='top' nowrap><b><?php xl('Priority','e'); ?>:</b></td>
 414   <td valign='top'>
 415 <?php
 416 generate_form_field(array('data_type'=>1,'field_id'=>'order_priority',
 417   'list_id'=>'ord_priority'), $row['order_priority']);
 418 ?>
 419   </td>
 420  </tr>
 421
 422  <tr>
 423   <td width='1%' valign='top' nowrap><b><?php xl('Status','e'); ?>:</b></td>
 424   <td valign='top'>
 425 <?php
 426 generate_form_field(array('data_type'=>1,'field_id'=>'order_status',
 427   'list_id'=>'ord_status'), $row['order_status']);
 428 ?>
 429   </td>
 430  </tr>
 431
 432  <tr>
 433   <td width='1%' valign='top' nowrap><b><?php xl('Patient Instructions','e'); ?>:</b></td>
 434   <td valign='top'>
 435    <textarea rows='3' cols='40' name='form_patient_instructions' style='width:100%'
 436     wrap='virtual' class='inputtext' /><?php echo $row['patient_instructions'] ?></textarea>
 437   </td>
 438  </tr>
 439
 440 <?php
 441
 442   // This section merits some explanation. :)
 443   //
 444   // If any procedures have already been saved for this form, then a top-level table row is
 445   // created for each of them, and includes the relevant questions and any existing answers.
 446   // Otherwise a single empty table row is created for entering the first or only procedure.
 447   //
 448   // If a new procedure is selected or changed, the questions for it are (re)generated from
 449   // the dialog window from which the procedure is selected, via JavaScript.  The sel_proc_type
 450   // function and the types.php script that it invokes collaborate to support this feature.
 451   //
 452   // The generate_qoe_html function in qoe.inc.php contains logic to generate the HTML for
 453   // the questions, and can be invoked either from this script or from types.php.
 454   //
 455   // The $i counter that you see below is to resolve the need for unique names for form fields
 456   // that may occur for each of the multiple procedure requests within the same order.
 457   // procedure_order_seq serves a similar need for uniqueness at the database level.
 458
 459   $oparr = array();
 460   if ($formid) {
 461     $opres = sqlStatement("SELECT " .
 462       "pc.procedure_order_seq, pc.procedure_code, pc.procedure_name, " .
 463       "pc.diagnoses, pt.procedure_type_id " .
 464       "FROM procedure_order_code AS pc " .
 465       "LEFT JOIN procedure_type AS pt ON pt.lab_id = ? AND " .
 466       "pt.procedure_code = pc.procedure_code " .
 467       "WHERE pc.procedure_order_id = ? " .
 468       "ORDER BY pc.procedure_order_seq",
 469       array($row['lab_id'], $formid));
 470     while ($oprow = sqlFetchArray($opres)) {
 471       $oparr[] = $oprow;
 472     }
 473   }
 474   if (empty($oparr)) $oparr[] = array('procedure_name' => '');
 475
 476   $i = 0;
 477   foreach ($oparr as $oprow) {
 478     $ptid = -1; // -1 means no procedure is selected yet
 479     if (!empty($oprow['procedure_type_id'])) {
 480       $ptid = $oprow['procedure_type_id'];
 481     }
 482 ?>
 483  <tr>
 484   <td width='1%' valign='top'><b><?php echo xl('Procedure') . ' ' . ($i + 1); ?>:</b></td>
 485   <td valign='top'>
 486    <input type='text' size='50' name='form_proc_type_desc[<?php echo $i; ?>]'
 487     value='<?php echo attr($oprow['procedure_name']) ?>'
 488     onclick="sel_proc_type(<?php echo $i; ?>)"
 489     onfocus='this.blur()'
 490     title='<?php xla('Click to select the desired procedure','e'); ?>'
 491     style='width:100%;cursor:pointer;cursor:hand' readonly />
 492    <input type='hidden' name='form_proc_type[<?php echo $i; ?>]' value='<?php echo $ptid ?>' />
 493    <br /><b><?php echo xlt('Diagnoses'); ?>:</b>
 494    <input type='text' size='50' name='form_proc_type_diag[<?php echo $i; ?>]'
 495     value='<?php echo attr($oprow['diagnoses']) ?>' onclick='sel_related(this.name)'
 496     title='<?php echo xla('Click to add a diagnosis'); ?>'
 497     onfocus='this.blur()'
 498     style='cursor:pointer;cursor:hand' readonly />
 499    <!-- MSIE innerHTML property for a TABLE element is read-only, so using a DIV here. -->
 500    <div style='width:95%;' id='qoetable[<?php echo $i; ?>]'>
 501 <?php
 502 $qoe_init_javascript = '';
 503 echo generate_qoe_html($ptid, $formid, $oprow['procedure_order_seq'], $i);
 504 if ($qoe_init_javascript)
 505   echo "<script language='JavaScript'>$qoe_init_javascript</script>";
 506 ?>
 507    </div>
 508   </td>
 509  </tr>
 510 <?php
 511     ++$i;
 512   }
 513 ?>
 514
 515 </table>
 516
 517 <p>
 518 <input type='button' value='<?php echo xla('Add Procedure'); ?>' onclick="addProcLine()" />
 519 &nbsp;
 520 <input type='submit' name='bn_save' value='<?php echo xla('Save'); ?>' />
 521 &nbsp;
 522 <input type='submit' name='bn_xmit' value='<?php echo xla('Save and Transmit'); ?>' />
 523 &nbsp;
 524 <input type='button' value='<?php echo xla('Cancel'); ?>' onclick="top.restoreSession();location='<?php echo $GLOBALS['form_exit_url']; ?>'" />
 525 </p>
 526
 527 </center>
 528
 529 <script language='JavaScript'>
 530 Calendar.setup({inputField:'form_date_ordered', ifFormat:'%Y-%m-%d',
 531  button:'img_date_ordered'});
 532 Calendar.setup({inputField:'form_date_collected', ifFormat:'%Y-%m-%d %H:%M',
 533  button:'img_date_collected', showsTime:true});
 534 </script>
 535
 536 </form>
 537 </body>
 538 </html>
 539