interface/orders/single_order_results.inc.php

   1 <?php
   2 /**
   3 * Script to display results for a given procedure order.
   4 *
   5 * Copyright (C) 2013-2016 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["srcdir"] . "/acl.inc");
  23 require_once($GLOBALS["srcdir"] . "/formdata.inc.php");
  24 require_once($GLOBALS["srcdir"] . "/options.inc.php");
  25 require_once($GLOBALS["srcdir"] . "/formatting.inc.php");
  26 require_once($GLOBALS["srcdir"] . "/classes/Document.class.php");
  27
  28 function getListItem($listid, $value) {
  29   $lrow = sqlQuery("SELECT title FROM list_options " .
  30     "WHERE list_id = ? AND option_id = ? AND activity = 1",
  31     array($listid, $value));
  32   $tmp = xl_list_label($lrow['title']);
  33   if (empty($tmp)) $tmp = (($value === '') ? '' : "($value)");
  34   return $tmp;
  35 }
  36
  37 function myCellText($s) {
  38   $s = trim($s);
  39   if ($s === '') return '&nbsp;';
  40   return text($s);
  41 }
  42
  43 // Check if the given string already exists in the $aNotes array.
  44 // If not, stores it as a new entry.
  45 // Either way, returns the corresponding key which is a small integer.
  46 function storeNote($s) {
  47   global $aNotes;
  48   $key = array_search($s, $aNotes);
  49   if ($key !== FALSE) return $key;
  50   $key = count($aNotes);
  51   $aNotes[$key] = $s;
  52   return $key;
  53 }
  54
  55 // Display a single row of output including order, report and result information.
  56 //
  57 function generate_result_row(&$ctx, &$row, &$rrow, $priors_omitted=false) {
  58   $lab_id         = empty($row['lab_id'             ]) ? 0 : ($row['lab_id'             ] + 0);
  59   $order_type_id  = empty($row['order_type_id'      ]) ? 0 : ($row['order_type_id'      ] + 0);
  60   $order_seq      = empty($row['procedure_order_seq']) ? 0 : ($row['procedure_order_seq'] + 0);
  61   $report_id      = empty($row['procedure_report_id']) ? 0 : ($row['procedure_report_id'] + 0);
  62   $procedure_code = empty($row['procedure_code'  ]) ? '' : $row['procedure_code'];
  63   $procedure_name = empty($row['procedure_name'  ]) ? '' : $row['procedure_name'];
  64   $date_report    = empty($row['date_report'     ]) ? '' : substr($row['date_report'], 0, 16);
  65   $date_report_suf = empty($row['date_report_tz' ]) ? '' : (' ' . $row['date_report_tz' ]);
  66   $date_collected = empty($row['date_collected'  ]) ? '' : substr($row['date_collected'], 0, 16);
  67   $date_collected_suf = empty($row['date_collected_tz' ]) ? '' : (' ' . $row['date_collected_tz' ]);
  68   $specimen_num   = empty($row['specimen_num'    ]) ? '' : $row['specimen_num'];
  69   $report_status  = empty($row['report_status'   ]) ? '' : $row['report_status'];
  70   $review_status  = empty($row['review_status'   ]) ? 'received' : $row['review_status'];
  71
  72   $report_noteid = '';
  73   if ($report_id && !isset($ctx['seen_report_ids'][$report_id])) {
  74     $ctx['seen_report_ids'][$report_id] = true;
  75     if ($review_status != 'reviewed') {
  76       if ($ctx['sign_list']) $ctx['sign_list'] .= ',';
  77       $ctx['sign_list'] .= $report_id;
  78     }
  79     // Allowing for multiple report notes separated by newlines.
  80     if (!empty($row['report_notes'])) {
  81       $notes = explode("\n", $row['report_notes']);
  82       foreach ($notes as $note) {
  83         if ($note === '') continue;
  84         if ($report_noteid) $report_noteid .= ', ';
  85         $report_noteid .= 1 + storeNote($note);
  86       }
  87     }
  88   }
  89   // allow for 0 to be displayed as a result value
  90   if($rrow['result'] == '' && $rrow['result'] !== 0 && $rrow['result'] !== '0') {
  91     $result_result = '';
  92   } else {
  93     $result_result = $rrow['result'];
  94   }
  95   $result_code      = empty($rrow['result_code'     ]) ? '' : $rrow['result_code'];
  96   $result_text      = empty($rrow['result_text'     ]) ? '' : $rrow['result_text'];
  97   $result_abnormal  = empty($rrow['abnormal'        ]) ? '' : $rrow['abnormal'];
  98   $result_units     = empty($rrow['units'           ]) ? '' : $rrow['units'];
  99   $result_facility  = empty($rrow['facility'        ]) ? '' : $rrow['facility'];
 100   $result_comments  = empty($rrow['comments'        ]) ? '' : $rrow['comments'];
 101   $result_range     = empty($rrow['range'           ]) ? '' : $rrow['range'];
 102   $result_status    = empty($rrow['result_status'   ]) ? '' : $rrow['result_status'];
 103   $result_document_id = empty($rrow['document_id'   ]) ? '' : $rrow['document_id'];
 104
 105   // Someone changed the delimiter in result comments from \n to \r.
 106   // Have to make sure results are consistent with those before that change.
 107   $result_comments = str_replace("\r", "\n", $result_comments);
 108
 109   if ($i = strpos($result_comments, "\n")) { // "=" is not a mistake!
 110     // If the first line of comments is not empty, then it is actually a long textual
 111     // result value with lines delimited by "~" characters.
 112     $result_comments = str_replace("~", "\n", substr($result_comments, 0, $i)) .
 113       substr($result_comments, $i);
 114   }
 115   $result_comments = trim($result_comments);
 116
 117   $result_noteid = '';
 118   if (!empty($result_comments)) {
 119     $result_noteid = 1 + storeNote($result_comments);
 120   }
 121   if ($priors_omitted) {
 122     if ($result_noteid) $result_noteid .= ', ';
 123     $result_noteid .= 1 + storeNote(xl('This is the latest of multiple result values.'));
 124     $ctx['priors_omitted'] = true;
 125   }
 126
 127   // If a performing organization is provided, make a note for it also.
 128   $result_facility = trim(str_replace("\r", "\n", $result_facility));
 129   if ($result_facility) {
 130     if ($result_noteid) $result_noteid .= ', ';
 131     $result_noteid .= 1 + storeNote(xl('Performing organization') . ":\n" . $result_facility);
 132   }
 133
 134   if ($ctx['lastpcid'] != $order_seq) {
 135     ++$ctx['encount'];
 136   }
 137   $bgcolor = "#" . (($ctx['encount'] & 1) ? "ddddff" : "ffdddd");
 138
 139   echo " <tr class='detail' bgcolor='$bgcolor'>\n";
 140
 141   if ($ctx['lastpcid'] != $order_seq) {
 142     $ctx['lastprid'] = -1; // force report fields on first line of each procedure
 143     $tmp = text("$procedure_code: $procedure_name");
 144     // Get the LOINC code if one exists in the compendium for this order type.
 145     if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) {
 146       $trow = sqlQuery("SELECT standard_code FROM procedure_type WHERE " .
 147         "lab_id = ? AND procedure_code = ? AND procedure_type = 'ord' " .
 148         "ORDER BY procedure_type_id LIMIT 1",
 149         array($lab_id, $procedure_code));
 150       if (!empty($trow['standard_code'])) {
 151         $tmp = "<a href='javascript:educlick(\"LOINC\",\"" . attr($trow['standard_code']) .
 152           "\")'>$tmp</a>";
 153       }
 154     }
 155     echo "  <td>$tmp</td>\n";
 156   }
 157   else {
 158     echo "  <td style='background-color:transparent'>&nbsp;</td>";
 159   }
 160
 161   // If this starts a new report or a new order, generate the report fields.
 162   if ($report_id != $ctx['lastprid']) {
 163     echo "  <td>";
 164     echo myCellText(oeFormatShortDate(substr($date_report, 0, 10)) . substr($date_report, 10) . $date_report_suf);
 165     echo "</td>\n";
 166
 167     echo "  <td>";
 168     echo myCellText(oeFormatShortDate(substr($date_collected, 0, 10)) . substr($date_collected, 10) . $date_collected_suf);
 169     echo "</td>\n";
 170
 171     echo "  <td>";
 172     echo myCellText($specimen_num);
 173     echo "</td>\n";
 174
 175     echo "  <td title='" . xla('Check mark indicates reviewed') . "'>";
 176     echo myCellText(getListItem('proc_rep_status', $report_status));
 177     if ($row['review_status'] == 'reviewed') {
 178       echo " &#x2713;"; // unicode check mark character
 179     }
 180     echo "</td>\n";
 181
 182     echo "  <td align='center'>";
 183     echo myCellText($report_noteid);
 184     echo "</td>\n";
 185   }
 186   else {
 187     echo "  <td colspan='5' style='background-color:transparent'>&nbsp;</td>\n";
 188   }
 189
 190   if ($result_code !== '' || $result_document_id) {
 191     $tmp = myCellText($result_code);
 192     if (empty($GLOBALS['PATIENT_REPORT_ACTIVE']) && !empty($result_code)) {
 193       $tmp = "<a href='javascript:educlick(\"LOINC\",\"" . attr($result_code) .
 194         "\")'>$tmp</a>";
 195     }
 196     echo "  <td>$tmp</td>\n";
 197     echo "  <td>";
 198     echo myCellText($result_text);
 199     echo "</td>\n";
 200     echo "  <td>";
 201     $tmp = myCellText(getListItem('proc_res_abnormal', $result_abnormal));
 202     if ($result_abnormal && strtolower($result_abnormal) != 'no') {
 203       echo "<b><font color='red'>$tmp</font></b>";
 204     }
 205     else {
 206       echo $tmp;
 207     }
 208     echo "</td>\n";
 209     //
 210     if ($result_document_id) {
 211       $d = new Document($result_document_id);
 212       echo "  <td colspan='3'>";
 213       if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) {
 214         echo "<a href='" . $GLOBALS['webroot'] . "/controller.php?document";
 215         echo "&retrieve&patient_id=$patient_id&document_id=$result_document_id' ";
 216         echo "onclick='top.restoreSession()'>";
 217       }
 218       echo $d->get_url_file();
 219       if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) {
 220         echo "</a>";
 221       }
 222       echo "</td>\n";
 223       $narrative_notes = sqlQuery("select group_concat(note SEPARATOR '\n') as notes from notes where foreign_id = ?",array($result_document_id));
 224       if(!empty($narrative_notes)){
 225         $nnotes = explode("\n",$narrative_notes['notes']);
 226         $narrative_note_list = '';
 227         foreach($nnotes as $nnote){
 228                 if($narrative_note_list == '') $narrative_note_list = 'Narrative Notes:';
 229                 $narrative_note_list .= $nnote;
 230         }
 231
 232         if($narrative_note_list != ''){ if ($result_noteid) $result_noteid .= ', '; $result_noteid .= 1 + storeNote($narrative_note_list);}
 233       }
 234
 235     }
 236     else {
 237       echo "  <td>";
 238       echo myCellText($result_result);
 239       echo "</td>\n";
 240       echo "  <td>";
 241       echo myCellText($result_range);
 242       echo "</td>\n";
 243       echo "  <td>";
 244       // Units comes from the lab so might not match anything in the proc_unit list,
 245       // but in that case the call will return the same value.
 246       echo myCellText(getListItemTitle('proc_unit', $result_units));
 247       echo "</td>\n";
 248     }
 249     echo "  <td align='center'>";
 250     echo myCellText($result_noteid);
 251     echo "</td>\n";
 252   }
 253   else {
 254     echo "  <td colspan='7' style='background-color:transparent'>&nbsp;</td>\n";
 255   }
 256
 257   echo " </tr>\n";
 258
 259   $ctx['lastpcid'] = $order_seq;
 260   $ctx['lastprid'] = $report_id;
 261   ++$ctx['lino'];
 262 }
 263
 264 function generate_order_report($orderid, $input_form=false, $genstyles=true, $finals_only=false) {
 265   global $aNotes;
 266
 267   // Check authorization.
 268   $thisauth = acl_check('patients', 'med');
 269   if (!$thisauth) return xl('Not authorized');
 270
 271   $orow = sqlQuery("SELECT " .
 272     "po.procedure_order_id, po.date_ordered, po.control_id, " .
 273     "po.order_status, po.specimen_type, po.patient_id, " .
 274     "pd.pubpid, pd.lname, pd.fname, pd.mname, pd.cmsportal_login, pd.language, " .
 275     "fe.date, " .
 276     "pp.name AS labname, " .
 277     "u.lname AS ulname, u.fname AS ufname, u.mname AS umname " .
 278     "FROM procedure_order AS po " .
 279     "LEFT JOIN patient_data AS pd ON pd.pid = po.patient_id " .
 280     "LEFT JOIN procedure_providers AS pp ON pp.ppid = po.lab_id " .
 281     "LEFT JOIN users AS u ON u.id = po.provider_id " .
 282     "LEFT JOIN form_encounter AS fe ON fe.pid = po.patient_id AND fe.encounter = po.encounter_id " .
 283     "WHERE po.procedure_order_id = ?",
 284     array($orderid));
 285
 286   $patient_id = $orow['patient_id'];
 287   $language = $orow['language'];
 288 ?>
 289
 290 <?php if ($genstyles) { ?>
 291         <style>
 292
 293             <?php if (empty($_SESSION['language_direction']) || $_SESSION['language_direction'] == 'ltr') { ?>
 294
 295             .labres tr.head   { font-size:10pt; background-color:#cccccc; text-align:center; }
 296             .labres tr.detail { font-size:10pt; }
 297             .labres a, .labres a:visited, .labres a:hover { color:#0000cc; }
 298
 299             .labres table {
 300                 border-style: solid;
 301                 border-width: 1px 0px 0px 1px;
 302                 border-color: black;
 303             }
 304             .labres td, .labres th {
 305                 border-style: solid;
 306                 border-width: 0px 1px 1px 0px;
 307                 border-color: black;
 308             }
 309             /***** What is this for? Seems ugly to me. --Rod
 310             .labres tr{
 311                 background-color: #cccccc;
 312             }
 313             *****/
 314
 315             <?php } else { ?>
 316
 317             .labres tr.head   { font-size:10pt;  text-align:center; }
 318             .labres tr.detail { font-size:10pt; }
 319
 320             .labres table {
 321                 border-style: none;
 322                 border-width: 1px 0px 0px 1px;
 323                 border-color: black;
 324             }
 325             .labres td, .labres th {
 326                 border-style: none;
 327                 border-width: 0px 1px 1px 0px;
 328                 border-color: black;
 329                 padding: 4px;
 330             }
 331             .labres table td.td-label{
 332
 333                 font-weight: bold;
 334             }
 335
 336
 337             <?php } ?>
 338
 339         </style>
 340 <?php } ?>
 341
 342 <?php if ($input_form) { ?>
 343 <script type="text/javascript" src="<?php echo $GLOBALS['webroot']; ?>/library/textformat.js"></script>
 344 <?php } // end if input form ?>
 345
 346 <?php if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) { ?>
 347
 348 <script type="text/javascript" src="<?php echo $GLOBALS['webroot']; ?>/library/dialog.js"></script>
 349 <script language="JavaScript">
 350
 351 var mypcc = '<?php echo $GLOBALS['phone_country_code'] ?>';
 352
 353 // Called to show patient notes related to this order in the "other" frame.
 354 // This works even if we are in a separate window.
 355 function showpnotes(orderid) {
 356  // Find the top or bottom frame that contains or opened this page; return if none.
 357  var w = window.opener ? window.opener : window;
 358  for (; w.name != 'RTop' && w.name != 'RBot'; w = w.parent) {
 359   if (w.parent == w) {
 360    // This message is not translated because a developer will need to find it.
 361    alert('Internal error locating target frame in ' + (window.opener ? 'opener' : 'window'));
 362    return false;
 363   }
 364  }
 365  var othername = (w.name == 'RTop') ? 'RBot' : 'RTop';
 366  w.parent.left_nav.forceDual();
 367  w.parent.left_nav.loadFrame('pno1', othername, 'patient_file/summary/pnotes_full.php?orderid=' + orderid);
 368  return false;
 369 }
 370
 371 // Process click on LOINC code for patient education popup.
 372 function educlick(codetype, codevalue) {
 373   dlgopen('<?php echo $GLOBALS['webroot']; ?>/interface/patient_file/education.php' +
 374     '?type=' + encodeURIComponent(codetype) +
 375     '&code=' + encodeURIComponent(codevalue) +
 376     '&language=<?php echo urlencode($language); ?>',
 377     '_blank', 1024, 750,true); // Force a new window instead of iframe to address cross site scripting potential
 378 }
 379
 380 </script>
 381
 382 <?php } // end if not patient report ?>
 383
 384 <?php if ($input_form) { ?>
 385 <form method='post' action='single_order_results.php?orderid=<?php echo $orderid; ?>'>
 386 <?php } // end if input form ?>
 387
 388 <div class='labres'>
 389
 390 <table width='100%' cellpadding='2' cellspacing='0'>
 391  <tr>
 392   <td class="td-label" width='5%' nowrap><?php echo xlt('Patient ID'); ?></td>
 393   <td width='45%'><?php echo myCellText($orow['pubpid']); ?></td>
 394   <td class="td-label" width='5%' nowrap><?php echo xlt('Order ID'); ?></td>
 395   <td width='45%'>
 396 <?php
 397   if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) {
 398     echo "   <a href='" . $GLOBALS['webroot'];
 399     echo "/interface/orders/order_manifest.php?orderid=";
 400     echo attr($orow['procedure_order_id']);
 401     echo "' target='_blank' onclick='top.restoreSession()'>";
 402   }
 403   echo myCellText($orow['procedure_order_id']);
 404   if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) {
 405     echo "</a>\n";
 406   }
 407   if ($orow['control_id']) {
 408     echo myCellText(' ' . xl('Lab') . ': ' . $orow['control_id']);
 409   }
 410 ?>
 411   </td>
 412  </tr>
 413  <tr>
 414   <td class="td-label" nowrap><?php echo xlt('Patient Name'); ?></td>
 415   <td><?php echo myCellText($orow['lname'] . ', ' . $orow['fname'] . ' ' . $orow['mname']); ?></td>
 416   <td class="td-label" nowrap><?php echo xlt('Ordered By'); ?></td>
 417   <td><?php echo myCellText($orow['ulname'] . ', ' . $orow['ufname'] . ' ' . $orow['umname']); ?></td>
 418  </tr>
 419  <tr>
 420   <td class="td-label" nowrap><?php echo xlt('Order Date'); ?></td>
 421   <td><?php echo myCellText(oeFormatShortDate($orow['date_ordered'])); ?></td>
 422   <td class="td-label" nowrap><?php echo xlt('Print Date'); ?></td>
 423   <td><?php echo oeFormatShortDate(date('Y-m-d')); ?></td>
 424  </tr>
 425  <tr>
 426   <td class="td-label" nowrap><?php echo xlt('Order Status'); ?></td>
 427   <td><?php echo myCellText($orow['order_status']); ?></td>
 428   <td class="td-label" nowrap><?php echo xlt('Encounter Date'); ?></td>
 429   <td><?php echo myCellText(oeFormatShortDate(substr($orow['date'], 0, 10))); ?></td>
 430  </tr>
 431  <tr>
 432   <td class="td-label" nowrap><?php echo xlt('Lab'); ?></td>
 433   <td><?php echo myCellText($orow['labname']); ?></td>
 434   <td class="td-label" nowrap><?php echo $orow['specimen_type'] ? xlt('Specimen Type') : '&nbsp;'; ?></td>
 435   <td><?php echo myCellText($orow['specimen_type']); ?></td>
 436  </tr>
 437 </table>
 438
 439 &nbsp;<br />
 440
 441 <table width='100%' cellpadding='2' cellspacing='0'>
 442
 443  <tr class='head'>
 444   <td class="td-label" rowspan='2' valign='middle'><?php echo xlt('Ordered Procedure'); ?></td>
 445   <td  class="td-label" colspan='5'><?php echo xlt('Report'); ?></td>
 446   <td class="td-label" colspan='7'><?php echo xlt('Results'); ?></td>
 447  </tr>
 448
 449  <tr class='head'>
 450   <td><?php echo xlt('Reported'); ?></td>
 451   <td><?php echo xlt('Collected'); ?></td>
 452   <td><?php echo xlt('Specimen'); ?></td>
 453   <td><?php echo xlt('Status'); ?></td>
 454   <td><?php echo xlt('Note'); ?></td>
 455   <td><?php echo xlt('Code'); ?></td>
 456   <td><?php echo xlt('Name'); ?></td>
 457   <td><?php echo xlt('Abn'); ?></td>
 458   <td><?php echo xlt('Value'); ?></td>
 459   <td><?php echo xlt('Range'); ?></td>
 460   <td><?php echo xlt('Units'); ?></td>
 461   <td><?php echo xlt('Note'); ?></td>
 462  </tr>
 463
 464 <?php
 465   $query = "SELECT " .
 466     "po.lab_id, po.date_ordered, pc.procedure_order_seq, pc.procedure_code, " .
 467     "pc.procedure_name, " .
 468     "pr.date_report, pr.date_report_tz, pr.date_collected, pr.date_collected_tz, " .
 469     "pr.procedure_report_id, pr.specimen_num, pr.report_status, pr.review_status, pr.report_notes " .
 470     "FROM procedure_order AS po " .
 471     "JOIN procedure_order_code AS pc ON pc.procedure_order_id = po.procedure_order_id " .
 472     "LEFT JOIN procedure_report AS pr ON pr.procedure_order_id = po.procedure_order_id AND " .
 473     "pr.procedure_order_seq = pc.procedure_order_seq " .
 474     "WHERE po.procedure_order_id = ? " .
 475     "ORDER BY pc.procedure_order_seq, pr.date_report, pr.procedure_report_id";
 476
 477   $res = sqlStatement($query, array($orderid));
 478   $aNotes = array();
 479   $finals = array();
 480   $empty_results = array('result_code' => '');
 481
 482   // Context for this call that may be used in other functions.
 483   $ctx = array(
 484     'lastpcid' => -1,
 485     'lastprid' => -1,
 486     'encount' => 0,
 487     'lino' => 0,
 488     'sign_list' => '',
 489     'seen_report_ids' => array(),
 490   );
 491
 492   while ($row = sqlFetchArray($res)) {
 493     $report_id = empty($row['procedure_report_id']) ? 0 : ($row['procedure_report_id'] + 0);
 494
 495     $query = "SELECT " .
 496       "ps.result_code, ps.result_text, ps.abnormal, ps.result, ps.range, " .
 497       "ps.result_status, ps.facility, ps.units, ps.comments, ps.document_id, ps.date " .
 498       "FROM procedure_result AS ps " .
 499       "WHERE ps.procedure_report_id = ? " .
 500       "ORDER BY ps.procedure_result_id";
 501
 502     $rres = sqlStatement($query, array($report_id));
 503
 504     if ($finals_only) {
 505       // We are consolidating reports.
 506       if (sqlNumRows($rres)) {
 507         $rrowsets = array();
 508         // First pass creates a $rrowsets[$key] for each unique result code in *this* report, with
 509         // the value being an array of the corresponding result rows. This caters to multiple
 510         // occurrences of the same result code in the same report.
 511         while ($rrow = sqlFetchArray($rres)) {
 512           $result_code = empty($rrow['result_code']) ? '' : $rrow['result_code'];
 513           $key = sprintf('%05d/', $row['procedure_order_seq']) . $result_code;
 514           if (!isset($rrowsets[$key])) $rrowsets[$key] = array();
 515           $rrowsets[$key][] = $rrow;
 516         }
 517         // Second pass builds onto the array of final results for *all* reports, where each final
 518         // result for a given result code is its *array* of result rows from *one* of the reports.
 519         foreach ($rrowsets as $key => $rrowset) {
 520           // When two reports have the same date, use the result date to decide which is "latest".
 521           if (isset($finals[$key]) &&
 522             $row['date_report'] == $finals[$key][0]['date_report'] &&
 523             !empty($rrow['date']) && !empty($finals[$key][1]['date']) &&
 524             $rrow['date'] < $finals[$key][1]['date'])
 525           {
 526             $finals[$key][2] = true; // see comment below
 527             continue;
 528           }
 529           // $finals[$key][2] indicates if there are multiple results for this result code.
 530           $finals[$key] = array($row, $rrowset, isset($finals[$key]));
 531         }
 532       }
 533       else {
 534         // We have no results for this report.
 535         $key = sprintf('%05d/', $row['procedure_order_seq']);
 536         $finals[$key] = array($row, array($empty_results), false);
 537       }
 538     }
 539     else {
 540       // We are showing all results for all reports.
 541       if (sqlNumRows($rres)) {
 542         while ($rrow = sqlFetchArray($rres)) {
 543           generate_result_row($ctx, $row, $rrow, false);
 544         }
 545       }
 546       else {
 547         generate_result_row($ctx, $row, $empty_results, false);
 548       }
 549     }
 550   }
 551
 552   if ($finals_only) {
 553     // The sort here was removed because $finals is already ordered by procedure_result_id
 554     // within procedure_order_seq which is probably desirable.  Sorting by result code defeats
 555     // the sequencing of results chosen by the sender.
 556     // ksort($finals);
 557     foreach ($finals as $final) {
 558       foreach ($final[1] as $rrow) {
 559         generate_result_row($ctx, $final[0], $rrow, $final[2]);
 560       }
 561     }
 562   }
 563
 564 ?>
 565
 566 </table>
 567
 568 &nbsp;<br />
 569 <table width='100%' style='border-width:0px;'>
 570  <tr>
 571   <td style='border-width:0px;'>
 572 <?php
 573   if (!empty($aNotes)) {
 574     echo "<table cellpadding='3' cellspacing='0'>\n";
 575     echo " <tr bgcolor='#cccccc'>\n";
 576     echo "  <th align='center' colspan='2'>" . xlt('Notes') . "</th>\n";
 577     echo " </tr>\n";
 578     foreach ($aNotes as $key => $value) {
 579       echo " <tr>\n";
 580       echo "  <td valign='top'>" . ($key + 1) . "</td>\n";
 581       // <pre> tag because white space and a fixed font are often used to line things up.
 582       echo "  <td><pre style='white-space:pre-wrap;'>" . text($value) . "</pre></td>\n";
 583       echo " </tr>\n";
 584     }
 585     echo "</table>\n";
 586   }
 587 ?>
 588   </td>
 589   <td style='border-width:0px;' align='right' valign='top'>
 590 <?php if ($input_form && !empty($ctx['priors_omitted']) /* empty($_POST['form_showall']) */ ) { ?>
 591    <input type='submit' name='form_showall' value='<?php echo xla('Show All Results'); ?>'
 592     title='<?php echo xla('Include all values reported for each result code'); ?>' />
 593 <?php } else if ($input_form && !empty($_POST['form_showall'])) { ?>
 594    <input type='submit' name='form_latest' value='<?php echo xla('Latest Results Only'); ?>'
 595     title='<?php echo xla('Show only latest values reported for each result code'); ?>' />
 596 <?php } ?>
 597 <?php if (empty($GLOBALS['PATIENT_REPORT_ACTIVE'])) { ?>
 598    &nbsp;
 599    <input type='button' value='<?php echo xla('Related Patient Notes'); ?>'
 600     onclick='showpnotes(<?php echo $orderid; ?>)' />
 601 <?php } ?>
 602 <?php if ($input_form && $ctx['sign_list']) { ?>
 603    &nbsp;
 604    <input type='hidden' name='form_sign_list' value='<?php echo attr($ctx['sign_list']); ?>' />
 605    <input type='submit' name='form_sign' value='<?php echo xla('Sign Results'); ?>'
 606     title='<?php echo xla('Mark these reports as reviewed'); ?>' />
 607 <?php
 608   // If this is a portal patient, sending them a copy is an option.
 609   if ($GLOBALS['gbl_portal_cms_enable'] && $orow['cmsportal_login'] !== '') {
 610     echo "&nbsp;";
 611     echo "<input type='checkbox' name='form_send_to_portal' value='" .
 612          attr($orow['cmsportal_login']) . "' checked />\n";
 613     echo xlt('Send to portal');
 614   }
 615 ?>
 616 <?php } ?>
 617 <?php if ($input_form) { ?>
 618    &nbsp;
 619    <input type='button' value='<?php echo xla('Close'); ?>' onclick='window.close()' />
 620 <?php } ?>
 621   </td>
 622  </tr>
 623 </table>
 624
 625 </div>
 626
 627 <?php if ($input_form) { ?>
 628 </form>
 629 <?php } // end if input form ?>
 630
 631 <?php
 632 } // end function generate_order_report
 633 ?>