interface/reports/encounters_report.php

   1 <?php
   2
   3 /**
   4  *  Encounters report.
   5  *
   6  *  This report shows past encounters with filtering and sorting,
   7  *  Added filtering to show encounters not e-signed, encounters e-signed and forms e-signed.
   8  *
   9  * @package   OpenEMR
  10  * @link      http://www.open-emr.org
  11  * @author    Rod Roark <rod@sunsetsystems.com>
  12  * @author    Terry Hill <terry@lilysystems.com>
  13  * @author    Brady Miller <brady.g.miller@gmail.com>
  14  * @copyright Copyright (c) 2007-2016 Rod Roark <rod@sunsetsystems.com>
  15  * @copyright Copyright (c) 2015 Terry Hill <terry@lillysystems.com>
  16  * @copyright Copyright (c) 2017-2018 Brady Miller <brady.g.miller@gmail.com>
  17  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  18  */
  19
  20 require_once("../globals.php");
  21 require_once("$srcdir/forms.inc");
  22 require_once("$srcdir/patient.inc");
  23 require_once "$srcdir/options.inc.php";
  24
  25 use OpenEMR\Billing\BillingUtilities;
  26 use OpenEMR\Common\Csrf\CsrfUtils;
  27 use OpenEMR\Core\Header;
  28
  29 if (!empty($_POST)) {
  30     if (!CsrfUtils::verifyCsrfToken($_POST["csrf_token_form"])) {
  31         CsrfUtils::csrfNotVerified();
  32     }
  33 }
  34
  35 $alertmsg = ''; // not used yet but maybe later
  36
  37 // For each sorting option, specify the ORDER BY argument.
  38 //
  39 $ORDERHASH = array(
  40   'doctor'  => 'lower(u.lname), lower(u.fname), fe.date',
  41   'patient' => 'lower(p.lname), lower(p.fname), fe.date',
  42   'pubpid'  => 'lower(p.pubpid), fe.date',
  43   'time'    => 'fe.date, lower(u.lname), lower(u.fname)',
  44   'encounter'    => 'fe.encounter, fe.date, lower(u.lname), lower(u.fname)',
  45 );
  46
  47 function show_doc_total($lastdocname, $doc_encounters)
  48 {
  49     if ($lastdocname) {
  50         echo " <tr>\n";
  51         echo "  <td class='detail'>" .  text($lastdocname) . "</td>\n";
  52         echo "  <td class='detail' align='right'>" . text($doc_encounters) . "</td>\n";
  53         echo " </tr>\n";
  54     }
  55 }
  56
  57 $form_from_date = (isset($_POST['form_from_date'])) ? DateToYYYYMMDD($_POST['form_from_date']) : date('Y-m-d');
  58 $form_to_date   = (isset($_POST['form_to_date'])) ? DateToYYYYMMDD($_POST['form_to_date']) : date('Y-m-d');
  59 $form_provider  = $_POST['form_provider'] ?? null;
  60 $form_facility  = $_POST['form_facility'] ?? null;
  61 $form_details   = (!empty($_POST['form_details'])) ? true : false;
  62 $form_new_patients = (!empty($_POST['form_new_patients'])) ? true : false;
  63 $form_esigned = (!empty($_POST['form_esigned'])) ? true : false;
  64 $form_not_esigned = (!empty($_POST['form_not_esigned'])) ? true : false;
  65 $form_encounter_esigned = (!empty($_POST['form_encounter_esigned'])) ? true : false;
  66
  67 $form_orderby = (!empty($_REQUEST['form_orderby']) && $ORDERHASH[$_REQUEST['form_orderby']]) ? $_REQUEST['form_orderby'] : 'doctor';
  68 $orderby = $ORDERHASH[$form_orderby];
  69
  70 // Get the info.
  71 //
  72 $esign_fields = '';
  73 $esign_joins = '';
  74 if ($form_encounter_esigned) {
  75     $esign_fields = ", es.table, es.tid ";
  76     $esign_joins = "LEFT OUTER JOIN esign_signatures AS es ON es.tid = fe.encounter ";
  77 }
  78
  79 if ($form_esigned) {
  80     $esign_fields = ", es.table, es.tid ";
  81     $esign_joins = "LEFT OUTER JOIN esign_signatures AS es ON es.tid = fe.encounter ";
  82 }
  83
  84 if ($form_not_esigned) {
  85     $esign_fields = ", es.table, es.tid ";
  86     $esign_joins = "LEFT JOIN esign_signatures AS es on es.tid = fe.encounter ";
  87 }
  88
  89 $sqlBindArray = array();
  90
  91 $query = "SELECT " .
  92   "fe.encounter, fe.date, fe.reason, " .
  93   "f.formdir, f.form_name, " .
  94   "p.fname, p.mname, p.lname, p.pid, p.pubpid, " .
  95   "u.lname AS ulname, u.fname AS ufname, u.mname AS umname " .
  96   "$esign_fields" .
  97   "FROM ( form_encounter AS fe, forms AS f ) " .
  98   "LEFT OUTER JOIN patient_data AS p ON p.pid = fe.pid " .
  99   "LEFT JOIN users AS u ON u.id = fe.provider_id " .
 100   "$esign_joins" .
 101   "WHERE f.pid = fe.pid AND f.encounter = fe.encounter AND f.formdir = 'newpatient' ";
 102 if ($form_to_date) {
 103     $query .= "AND fe.date >= ? AND fe.date <= ? ";
 104     array_push($sqlBindArray, $form_from_date . ' 00:00:00', $form_to_date . ' 23:59:59');
 105 } else {
 106     $query .= "AND fe.date >= ? AND fe.date <= ? ";
 107     array_push($sqlBindArray, $form_from_date . ' 00:00:00', $form_from_date . ' 23:59:59');
 108 }
 109
 110 if ($form_provider) {
 111     $query .= "AND fe.provider_id = ? ";
 112     array_push($sqlBindArray, $form_provider);
 113 }
 114
 115 if ($form_facility) {
 116     $query .= "AND fe.facility_id = ? ";
 117     array_push($sqlBindArray, $form_facility);
 118 }
 119
 120 if ($form_new_patients) {
 121     $query .= "AND fe.date = (SELECT MIN(fe2.date) FROM form_encounter AS fe2 WHERE fe2.pid = fe.pid) ";
 122 }
 123
 124 if ($form_encounter_esigned) {
 125     $query .= "AND es.tid = fe.encounter AND es.table = 'form_encounter' ";
 126 }
 127
 128 if ($form_esigned) {
 129     $query .= "AND es.tid = fe.encounter ";
 130 }
 131
 132 if ($form_not_esigned) {
 133     $query .= "AND es.tid IS NULL ";
 134 }
 135
 136 $query .= "ORDER BY $orderby";
 137
 138 $res = sqlStatement($query, $sqlBindArray);
 139 ?>
 140 <html>
 141 <head>
 142     <title><?php echo xlt('Encounters Report'); ?></title>
 143
 144     <?php Header::setupHeader(['datetime-picker', 'report-helper']); ?>
 145
 146     <style>
 147         /* specifically include & exclude from printing */
 148         @media print {
 149             #report_parameters {
 150                 visibility: hidden;
 151                 display: none;
 152             }
 153             #report_parameters_daterange {
 154                 visibility: visible;
 155                 display: inline;
 156             }
 157             #report_results table {
 158                margin-top: 0px;
 159             }
 160         }
 161
 162         /* specifically exclude some from the screen */
 163         @media screen {
 164             #report_parameters_daterange {
 165                 visibility: hidden;
 166                 display: none;
 167             }
 168         }
 169     </style>
 170
 171     <script>
 172         $(function () {
 173             oeFixedHeaderSetup(document.getElementById('mymaintable'));
 174             var win = top.printLogSetup ? top : opener.top;
 175             win.printLogSetup(document.getElementById('printbutton'));
 176
 177             $('.datepicker').datetimepicker({
 178                 <?php $datetimepicker_timepicker = false; ?>
 179                 <?php $datetimepicker_showseconds = false; ?>
 180                 <?php $datetimepicker_formatInput = true; ?>
 181                 <?php require($GLOBALS['srcdir'] . '/js/xl/jquery-datetimepicker-2-5-4.js.php'); ?>
 182                 <?php // can add any additional javascript settings to datetimepicker here; need to prepend first setting with a comma ?>
 183             });
 184         });
 185
 186         function dosort(orderby) {
 187             var f = document.forms[0];
 188             f.form_orderby.value = orderby;
 189             f.submit();
 190             return false;
 191         }
 192
 193         function refreshme() {
 194             document.forms[0].submit();
 195         }
 196     </script>
 197 </head>
 198 <body class="body_top">
 199 <!-- Required for the popup date selectors -->
 200 <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
 201
 202 <span class='title'><?php echo xlt('Report'); ?> - <?php echo xlt('Encounters'); ?></span>
 203
 204 <div id="report_parameters_daterange">
 205 <?php echo text(oeFormatShortDate($form_from_date)) . " &nbsp; " . xlt('to{{Range}}') . " &nbsp; " . text(oeFormatShortDate($form_to_date)); ?>
 206 </div>
 207
 208 <form method='post' name='theform' id='theform' action='encounters_report.php' onsubmit='return top.restoreSession()'>
 209 <input type="hidden" name="csrf_token_form" value="<?php echo attr(CsrfUtils::collectCsrfToken()); ?>" />
 210
 211 <div id="report_parameters">
 212 <table>
 213  <tr>
 214   <td width='550px'>
 215     <div style='float:left'>
 216
 217     <table class='text'>
 218         <tr>
 219             <td class='col-form-label'>
 220                 <?php echo xlt('Facility'); ?>:
 221             </td>
 222             <td>
 223             <?php dropdown_facility($form_facility, 'form_facility', true); ?>
 224             </td>
 225             <td class='col-form-label'>
 226                 <?php echo xlt('Provider'); ?>:
 227             </td>
 228             <td>
 229                 <?php
 230
 231                  // Build a drop-down list of providers.
 232                  //
 233
 234                  $query = "SELECT id, lname, fname FROM users WHERE " .
 235                   "authorized = 1 ORDER BY lname, fname"; //(CHEMED) facility filter
 236
 237                  $ures = sqlStatement($query);
 238
 239                  echo "   <select name='form_provider' class='form-control'>\n";
 240                  echo "    <option value=''>-- " . xlt('All') . " --\n";
 241
 242                 while ($urow = sqlFetchArray($ures)) {
 243                     $provid = $urow['id'];
 244                     echo "    <option value='" . attr($provid) . "'";
 245                     if (!empty($_POST['form_provider']) && ($provid == $_POST['form_provider'])) {
 246                         echo " selected";
 247                     }
 248
 249                     echo ">" . text($urow['lname']) . ", " . text($urow['fname']) . "\n";
 250                 }
 251
 252                  echo "   </select>\n";
 253
 254                 ?>
 255             </td>
 256         </tr>
 257         <tr>
 258             <td class='col-form-label'>
 259                 <?php echo xlt('From'); ?>:
 260             </td>
 261             <td>
 262                <input type='text' class='datepicker form-control' name='form_from_date' id="form_from_date" size='10' value='<?php echo attr(oeFormatShortDate($form_from_date)); ?>'>
 263             </td>
 264             <td class='col-form-label'>
 265                 <?php echo xlt('To{{Range}}'); ?>:
 266             </td>
 267             <td>
 268                <input type='text' class='datepicker form-control' name='form_to_date' id="form_to_date" size='10' value='<?php echo attr(oeFormatShortDate($form_to_date)); ?>'>
 269             </td>
 270         </tr>
 271     <tr>
 272       <td></td>
 273       <td>
 274         <div class="checkbox">
 275           <label><input type='checkbox' name='form_details'<?php echo ($form_details) ? ' checked' : ''; ?>>
 276             <?php echo xlt('Details'); ?></label>
 277         </div>
 278         <div class="checkbox">
 279           <label><input type='checkbox' name='form_new_patients' title='<?php echo xla('First-time visits only'); ?>'<?php echo ($form_new_patients) ? ' checked' : ''; ?>>
 280             <?php  echo xlt('New'); ?></label>
 281         </div>
 282       </td>
 283       <td></td>
 284       <td>
 285         <div class="checkbox">
 286           <label><input type='checkbox' name='form_esigned'<?php echo ($form_esigned) ? ' checked' : ''; ?>>
 287             <?php  echo xlt('Forms Esigned'); ?></label>
 288         </div>
 289         <div class="checkbox">
 290           <label><input type='checkbox' name='form_encounter_esigned'<?php echo ($form_encounter_esigned) ? ' checked' : ''; ?>>
 291             <?php  echo xlt('Encounter Esigned'); ?></label>
 292         </div>
 293         <div class="checkbox">
 294           <label><input type='checkbox' name='form_not_esigned'<?php echo ($form_not_esigned) ? ' checked' : ''; ?>>
 295             <?php echo xlt('Not Esigned'); ?></label>
 296         </div>
 297       </td>
 298     </tr>
 299   </table>
 300
 301     </div>
 302
 303   </td>
 304   <td class='h-100' align='left' valign='middle'>
 305     <table class='w-100 h-100' style='border-left:1px solid;'>
 306         <tr>
 307             <td>
 308                 <div class="text-center">
 309           <div class="btn-group" role="group">
 310                       <a href='#' class='btn btn-secondary btn-save' onclick='$("#form_refresh").attr("value","true"); $("#theform").submit();'>
 311                             <?php echo xlt('Submit'); ?>
 312                       </a>
 313                         <?php if (!empty($_POST['form_refresh']) || !empty($_POST['form_orderby'])) { ?>
 314               <a href='#' class='btn btn-secondary btn-print' id='printbutton'>
 315                                 <?php echo xlt('Print'); ?>
 316                         </a>
 317                         <?php } ?>
 318           </div>
 319                 </div>
 320             </td>
 321         </tr>
 322     </table>
 323   </td>
 324  </tr>
 325 </table>
 326
 327 </div> <!-- end report_parameters -->
 328
 329 <?php
 330 if (!empty($_POST['form_refresh']) || !empty($_POST['form_orderby'])) {
 331     ?>
 332 <div id="report_results">
 333 <table class='table' id='mymaintable'>
 334 <thead class='thead-light'>
 335     <?php if ($form_details) { ?>
 336   <th>
 337    <a href="nojs.php" onclick="return dosort('doctor')"
 338         <?php echo ($form_orderby == "doctor") ? " style=\"color: var(--success)\"" : ""; ?>><?php echo xlt('Provider'); ?> </a>
 339   </th>
 340   <th>
 341    <a href="nojs.php" onclick="return dosort('time')"
 342         <?php echo ($form_orderby == "time") ? " style=\"color: var(--success)\"" : ""; ?>><?php echo xlt('Date'); ?></a>
 343   </th>
 344   <th>
 345    <a href="nojs.php" onclick="return dosort('patient')"
 346         <?php echo ($form_orderby == "patient") ? " style=\"color: var(--success)\"" : ""; ?>><?php echo xlt('Patient'); ?></a>
 347   </th>
 348   <th>
 349    <a href="nojs.php" onclick="return dosort('pubpid')"
 350         <?php echo ($form_orderby == "pubpid") ? " style=\"color: var(--success)\"" : ""; ?>><?php echo xlt('ID'); ?></a>
 351   </th>
 352   <th>
 353         <?php echo xlt('Status'); ?>
 354   </th>
 355   <th>
 356         <?php echo xlt('Encounter'); ?>
 357   </th>
 358   <th>
 359    <a href="nojs.php" onclick="return dosort('encounter')"
 360         <?php echo ($form_orderby == "encounter") ? " style=\"color: var(--success)\"" : ""; ?>><?php echo xlt('Encounter Number'); ?></a>
 361   </th>
 362   <th>
 363         <?php echo xlt('Form'); ?>
 364   </th>
 365   <th>
 366         <?php echo xlt('Coding'); ?>
 367   </th>
 368 <?php } else { ?>
 369   <th><?php echo xlt('Provider'); ?></td>
 370   <th><?php echo xlt('Encounters'); ?></td>
 371 <?php } ?>
 372 </thead>
 373 <tbody>
 374     <?php
 375     if ($res) {
 376         $lastdocname = "";
 377         $doc_encounters = 0;
 378         while ($row = sqlFetchArray($res)) {
 379             $patient_id = $row['pid'];
 380
 381             $docname = '';
 382             if (!empty($row['ulname']) || !empty($row['ufname'])) {
 383                 $docname = $row['ulname'];
 384                 if (!empty($row['ufname']) || !empty($row['umname'])) {
 385                     $docname .= ', ' . $row['ufname'] . ' ' . $row['umname'];
 386                 }
 387             }
 388
 389             $errmsg  = "";
 390             if ($form_details) {
 391                 // Fetch all other forms for this encounter.
 392                 $encnames = '';
 393                 $encarr = getFormByEncounter(
 394                     $patient_id,
 395                     $row['encounter'],
 396                     "formdir, user, form_name, form_id"
 397                 );
 398                 if ($encarr != '') {
 399                     foreach ($encarr as $enc) {
 400                         if ($enc['formdir'] == 'newpatient') {
 401                             continue;
 402                         }
 403
 404                         if ($encnames) {
 405                             $encnames .= '<br />';
 406                         }
 407
 408                         $encnames .= text($enc['form_name']); // need to html escape it here for output below
 409                     }
 410                 }
 411
 412                 // Fetch coding and compute billing status.
 413                 $coded = "";
 414                 $billed_count = 0;
 415                 $unbilled_count = 0;
 416                 if (
 417                     $billres = BillingUtilities::getBillingByEncounter(
 418                         $row['pid'],
 419                         $row['encounter'],
 420                         "code_type, code, code_text, billed"
 421                     )
 422                 ) {
 423                     foreach ($billres as $billrow) {
 424                         // $title = addslashes($billrow['code_text']);
 425                         if ($billrow['code_type'] != 'COPAY' && $billrow['code_type'] != 'TAX') {
 426                             $coded .= $billrow['code'] . ', ';
 427                             if ($billrow['billed']) {
 428                                 ++$billed_count;
 429                             } else {
 430                                 ++$unbilled_count;
 431                             }
 432                         }
 433                     }
 434
 435                     $coded = substr($coded, 0, strlen($coded) - 2);
 436                 }
 437
 438                 // Figure product sales into billing status.
 439                 $sres = sqlStatement("SELECT billed FROM drug_sales " .
 440                 "WHERE pid = ? AND encounter = ?", array($row['pid'], $row['encounter']));
 441                 while ($srow = sqlFetchArray($sres)) {
 442                     if ($srow['billed']) {
 443                         ++$billed_count;
 444                     } else {
 445                         ++$unbilled_count;
 446                     }
 447                 }
 448
 449                 // Compute billing status.
 450                 if ($billed_count && $unbilled_count) {
 451                     $status = xl('Mixed');
 452                 } elseif ($billed_count) {
 453                     $status = xl('Closed');
 454                 } elseif ($unbilled_count) {
 455                     $status = xl('Open');
 456                 } else {
 457                     $status = xl('Empty');
 458                 }
 459                 ?>
 460        <tr bgcolor='<?php echo attr($bgcolor ?? ''); ?>'>
 461   <td>
 462                 <?php echo ($docname == $lastdocname) ? "" : text($docname) ?>&nbsp;
 463   </td>
 464   <td>
 465                 <?php echo text(oeFormatShortDate(substr($row['date'], 0, 10))) ?>&nbsp;
 466   </td>
 467   <td>
 468                 <?php echo text($row['lname'] . ', ' . $row['fname'] . ' ' . $row['mname']); ?>&nbsp;
 469   </td>
 470   <td>
 471                 <?php echo text($row['pubpid']); ?>&nbsp;
 472   </td>
 473   <td>
 474                 <?php echo text($status); ?>&nbsp;
 475   </td>
 476   <td>
 477                 <?php echo text($row['reason']); ?>&nbsp;
 478   </td>
 479    <td>
 480                 <?php echo text($row['encounter']); ?>&nbsp;
 481   </td>
 482   <td>
 483                 <?php echo $encnames; //since this variable contains html, have already html escaped it above ?>&nbsp;
 484   </td>
 485   <td>
 486                 <?php echo text($coded); ?>
 487   </td>
 488  </tr>
 489                 <?php
 490             } else {
 491                 if ($docname != $lastdocname) {
 492                     show_doc_total($lastdocname, $doc_encounters);
 493                     $doc_encounters = 0;
 494                 }
 495
 496                   ++$doc_encounters;
 497             }
 498
 499             $lastdocname = $docname;
 500         }
 501
 502         if (!$form_details) {
 503             show_doc_total($lastdocname, $doc_encounters);
 504         }
 505     }
 506     ?>
 507 </tbody>
 508 </table>
 509 </div>  <!-- end encresults -->
 510 <?php } else { ?>
 511 <div class='text'>
 512     <?php echo xlt('Please input search criteria above, and click Submit to view results.'); ?>
 513 </div>
 514 <?php } ?>
 515
 516 <input type="hidden" name="form_orderby" value="<?php echo attr($form_orderby) ?>" />
 517 <input type='hidden' name='form_refresh' id='form_refresh' value=''/>
 518
 519 </form>
 520 </body>
 521
 522 <script>
 523 <?php if ($alertmsg) {
 524     echo " alert(" . js_escape($alertmsg) . ");\n";
 525 } ?>
 526 </script>
 527 </html>