interface/reports/front_receipts_report.php

   1 <?php
   2
   3 /**
   4  * This report lists front office receipts for a given date range.
   5  *
   6  * @package   OpenEMR
   7  * @link      http://www.open-emr.org
   8  * @author    Rod Roark <rod@sunsetsystems.com>
   9  * @author    Brady Miller <brady.g.miller@gmail.com>
  10  * @copyright Copyright (c) 2006-2015 Rod Roark <rod@sunsetsystems.com>
  11  * @copyright Copyright (c) 2017-2018 Brady Miller <brady.g.miller@gmail.com>
  12  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  13  */
  14
  15 require_once("../globals.php");
  16 require_once("$srcdir/patient.inc.php");
  17 require_once "$srcdir/options.inc.php";
  18
  19 use OpenEMR\Common\Acl\AclMain;
  20 use OpenEMR\Common\Csrf\CsrfUtils;
  21 use OpenEMR\Common\Twig\TwigContainer;
  22 use OpenEMR\Common\Utils\FormatMoney;
  23 use OpenEMR\Core\Header;
  24
  25 if (!AclMain::aclCheckCore('acct', 'rep_a')) {
  26     echo (new TwigContainer(null, $GLOBALS['kernel']))->getTwig()->render('core/unauthorized.html.twig', ['pageTitle' => xl("Front Office Receipts")]);
  27     exit;
  28 }
  29
  30 if (!empty($_POST)) {
  31     if (!CsrfUtils::verifyCsrfToken($_POST["csrf_token_form"])) {
  32         CsrfUtils::csrfNotVerified();
  33     }
  34 }
  35
  36 $from_date = (isset($_POST['form_from_date'])) ? DateToYYYYMMDD($_POST['form_from_date']) : date('Y-m-d');
  37 $to_date   = (isset($_POST['form_to_date'])) ? DateToYYYYMMDD($_POST['form_to_date']) : date('Y-m-d');
  38
  39 ?>
  40 <html>
  41 <head>
  42
  43     <title><?php echo xlt('Front Office Receipts'); ?></title>
  44
  45     <?php Header::setupHeader('datetime-picker'); ?>
  46
  47     <script>
  48         <?php require($GLOBALS['srcdir'] . "/restoreSession.php"); ?>
  49
  50         $(function () {
  51             var win = top.printLogSetup ? top : opener.top;
  52             win.printLogSetup(document.getElementById('printbutton'));
  53
  54             $('.datepicker').datetimepicker({
  55                 <?php $datetimepicker_timepicker = false; ?>
  56                 <?php $datetimepicker_showseconds = false; ?>
  57                 <?php $datetimepicker_formatInput = true; ?>
  58                 <?php require($GLOBALS['srcdir'] . '/js/xl/jquery-datetimepicker-2-5-4.js.php'); ?>
  59                 <?php // can add any additional javascript settings to datetimepicker here; need to prepend first setting with a comma ?>
  60             });
  61         });
  62
  63         // The OnClick handler for receipt display.
  64         function show_receipt(pid,timestamp) {
  65             dlgopen('../patient_file/front_payment.php?receipt=1&patient=' + encodeURIComponent(pid) +
  66                 '&time=' + encodeURIComponent(timestamp), '_blank', 850, 550, '', '', {
  67                 onClosed: 'reload'
  68             });
  69          }
  70     </script>
  71
  72     <style>
  73     /* specifically include & exclude from printing */
  74     @media print {
  75         #report_parameters {
  76             visibility: hidden;
  77             display: none;
  78         }
  79         #report_parameters_daterange {
  80             visibility: visible;
  81             display: inline;
  82         }
  83         #report_results {
  84            margin-top: 30px;
  85         }
  86     }
  87
  88     /* specifically exclude some from the screen */
  89     @media screen {
  90         #report_parameters_daterange {
  91             visibility: hidden;
  92             display: none;
  93         }
  94     }
  95     </style>
  96 </head>
  97
  98 <body class="body_top">
  99
 100 <!-- Required for the popup date selectors -->
 101 <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
 102
 103 <span class='title'><?php echo xlt('Report'); ?> - <?php echo xlt('Front Office Receipts'); ?></span>
 104
 105 <div id="report_parameters_daterange">
 106 <?php echo text(oeFormatShortDate($from_date)) . " &nbsp; " . xlt("to{{Range}}") . " &nbsp; " . text(oeFormatShortDate($to_date)); ?>
 107 </div>
 108
 109 <form name='theform' method='post' action='front_receipts_report.php' id='theform' onsubmit='return top.restoreSession()'>
 110 <input type="hidden" name="csrf_token_form" value="<?php echo attr(CsrfUtils::collectCsrfToken()); ?>" />
 111
 112 <div id="report_parameters">
 113
 114 <input type='hidden' name='form_refresh' id='form_refresh' value=''/>
 115
 116 <table>
 117  <tr>
 118   <td width='410px'>
 119     <div style='float:left'>
 120
 121     <table class='text'>
 122         <tr>
 123             <td class='col-form-label'>
 124                 <?php echo xlt('Facility'); ?>:
 125             </td>
 126             <td>
 127                 <?php
 128                 $form_facility = $_POST['form_facility'] ?? null;
 129                 dropdown_facility($form_facility, 'form_facility', false);
 130                 ?>
 131             </td>
 132             <td class='col-form-label'>
 133                 <?php echo xlt('Provider') ?>:
 134             </td>
 135             <td>
 136             <?php  # Build a drop-down list of providers.
 137                     # Added (TLH)
 138
 139                     $query = "SELECT id, lname, fname FROM users WHERE " .
 140                     "authorized = 1  ORDER BY lname, fname"; #(CHEMED) facility filter
 141
 142                     $ures = sqlStatement($query);
 143
 144                     echo "   <select name='form_provider' class='form-control'>\n";
 145                     echo "    <option value=''>-- " . xlt('All') . " --\n";
 146
 147             while ($urow = sqlFetchArray($ures)) {
 148                 $provid = $urow['id'];
 149                 echo "    <option value='" . attr($provid) . "'";
 150                 if (!empty($_POST['form_provider']) && ($provid == $_POST['form_provider'])) {
 151                     echo " selected";
 152                 }
 153
 154                 echo ">" . text($urow['lname']) . ", " . text($urow['fname']) . "\n";
 155                 if (!empty($_POST['form_provider']) && ($provid == $_POST['form_provider'])) {
 156                     $provider_name = $urow['lname'] . ", " . $urow['fname'];
 157                 }
 158             }
 159
 160                     echo "   </select>\n";
 161             ?>
 162             </td>
 163             </tr>
 164             <tr>
 165             <td class='col-form-label'>
 166                 <?php echo xlt('From'); ?>:
 167             </td>
 168             <td>
 169                <input type='text' class='datepicker form-control' name='form_from_date' id="form_from_date" size='10' value='<?php echo attr(oeFormatShortDate($from_date)); ?>'>
 170             </td>
 171             <td class='col-form-label'>
 172                 <?php xl('To{{Range}}', 'e'); ?>:
 173             </td>
 174             <td>
 175                <input type='text' class='datepicker form-control' name='form_to_date' id="form_to_date" size='10' value='<?php echo attr(oeFormatShortDate($to_date)); ?>'>
 176             </td>
 177         </tr>
 178     </table>
 179
 180     </div>
 181
 182   </td>
 183   <td class='h-100' align='left' valign='middle'>
 184     <table class='w-100 h-100' style='border-left:1px solid;'>
 185         <tr>
 186             <td>
 187                 <div class="text-center">
 188           <div class="btn-group" role="group">
 189                       <a href='#' class='btn btn-secondary btn-save' onclick='$("#form_refresh").attr("value","true"); $("#theform").submit();'>
 190                             <?php echo xlt('Submit'); ?>
 191                       </a>
 192                         <?php if (!empty($_POST['form_refresh'])) { ?>
 193                         <a href='#' class='btn btn-secondary btn-print' id='printbutton'>
 194                                 <?php echo xlt('Print'); ?>
 195                         </a>
 196                         <?php } ?>
 197           </div>
 198                 </div>
 199             </td>
 200         </tr>
 201     </table>
 202   </td>
 203  </tr>
 204 </table>
 205 </div> <!-- end of parameters -->
 206
 207 <?php
 208 if (!empty($_POST['form_refresh']) || !empty($_POST['form_orderby'])) {
 209     ?>
 210 <div id="report_results">
 211 <table class='table table-striped'>
 212 <thead class='thead-light'>
 213 <th> <?php echo xlt('Time'); ?> </th>
 214 <th> <?php echo xlt('Patient'); ?> </th>
 215 <th> <?php echo xlt('ID'); ?> </th>
 216 <th> <?php echo xlt('Method'); ?> </th>
 217 <th> <?php echo xlt('Source'); ?> </th>
 218 <th align='right'> <?php echo xlt('Today'); ?> </th>
 219 <th align='right'> <?php echo xlt('Previous'); ?> </th>
 220 <th align='right'> <?php echo xlt('Total'); ?> </th>
 221 </thead>
 222 <tbody>
 223     <?php
 224     if (true || $_POST['form_refresh']) {
 225         $total1 = 0.00;
 226         $total2 = 0.00;
 227
 228         $inputArray = array($from_date . ' 00:00:00', $to_date . ' 23:59:59');
 229         $query = "SELECT r.pid, r.dtime, " .
 230         "SUM(r.amount1) AS amount1, " .
 231         "SUM(r.amount2) AS amount2, " .
 232         "MAX(r.method) AS method, " .
 233         "MAX(r.source) AS source, " .
 234         "MAX(r.user) AS user, " .
 235         "p.fname, p.mname, p.lname, p.pubpid " .
 236         "FROM payments AS r " .
 237         "JOIN form_encounter AS fe ON fe.encounter=r.encounter " .
 238         "LEFT OUTER JOIN patient_data AS p ON " .
 239         "p.pid = r.pid " .
 240         "WHERE " .
 241         "r.dtime >= ? AND " .
 242         "r.dtime <= ? AND ";
 243         if ($_POST['form_facility'] != "") {
 244             $inputArray[] = $_POST['form_facility'];
 245             $query .= "fe.facility_id = ? AND ";
 246         }
 247         if ($_POST['form_provider'] != "") {
 248             $inputArray[] = $_POST['form_provider'];
 249             $query .= "fe.provider_id = ? AND ";
 250         }
 251         $query .= "1 GROUP BY r.dtime, r.pid ORDER BY r.dtime, r.pid";
 252
 253         // echo " $query \n"; // debugging
 254         $res = sqlStatement($query, $inputArray);
 255
 256         while ($row = sqlFetchArray($res)) {
 257             // Make the timestamp URL-friendly.
 258             $timestamp = preg_replace('/[^0-9]/', '', $row['dtime']);
 259             ?>
 260    <tr>
 261     <td nowrap>
 262      <a href="javascript:show_receipt(<?php echo attr_js($row['pid']); ?>, <?php echo attr_js($timestamp); ?>)">
 263             <?php echo text(oeFormatShortDate(substr($row['dtime'], 0, 10))) . text(substr($row['dtime'], 10, 6)); ?>
 264    </a>
 265   </td>
 266   <td>
 267             <?php echo text($row['lname']) . ', ' . text($row['fname']) . ' ' . text($row['mname']); ?>
 268   </td>
 269   <td>
 270             <?php echo text($row['pubpid']); ?>
 271   </td>
 272   <td>
 273             <?php echo text($row['method']); ?>
 274   </td>
 275   <td>
 276             <?php echo text($row['source']); ?>
 277   </td>
 278   <td align='right'>
 279             <?php echo text(FormatMoney::getBucks($row['amount1'])); ?>
 280   </td>
 281   <td align='right'>
 282             <?php echo text(FormatMoney::getBucks($row['amount2'])); ?>
 283   </td>
 284   <td align='right'>
 285             <?php echo text(FormatMoney::getBucks($row['amount1'] + $row['amount2'])); ?>
 286   </td>
 287  </tr>
 288             <?php
 289             $total1 += $row['amount1'];
 290             $total2 += $row['amount2'];
 291             $method = $row['method'];
 292             if (empty($total1_by_method[$method])) {
 293                 $total1_by_method[$method] = 0;
 294             }
 295             $total1_by_method[$method] += $row['amount1'];
 296             if (empty($total2_by_method[$method])) {
 297                 $total2_by_method[$method] = 0;
 298             }
 299             $total2_by_method[$method] += $row['amount2'];
 300         }
 301         ?>
 302
 303 <tr>
 304  <td colspan='8'>
 305   &nbsp;
 306  </td>
 307 </tr>
 308
 309         <?php
 310         $method_keys = array_keys(array_unique(array_merge($total1_by_method, $total2_by_method)));
 311         foreach ($method_keys as $method_key) { ?>
 312             <tr class="report_totals_by_method">
 313                 <td colspan='5'>
 314                     <?php echo xlt('Totals by Method') . ' ' . text($method_key); ?>
 315                 <td align='right'>
 316                         <?php echo text(FormatMoney::getBucks($total1_by_method[$method_key])); ?>
 317                 </td>
 318                 <td align='right'>
 319                         <?php echo text(FormatMoney::getBucks($total2_by_method[$method_key])); ?>
 320                 </td>
 321                 <td align='right'>
 322                         <?php echo text(FormatMoney::getBucks($total1_by_method[$method_key] + $total2_by_method[$method_key])); ?>
 323                 </td>
 324             </tr>
 325         <?php } ?>
 326
 327 <tr class="report_totals">
 328  <td colspan='5'>
 329         <?php echo xlt('Totals'); ?>
 330  </td>
 331  <td align='right'>
 332         <?php echo text(FormatMoney::getBucks($total1)); ?>
 333  </td>
 334  <td align='right'>
 335         <?php echo text(FormatMoney::getBucks($total2)); ?>
 336  </td>
 337  <td align='right'>
 338         <?php echo text(FormatMoney::getBucks($total1 + $total2)); ?>
 339  </td>
 340 </tr>
 341
 342         <?php
 343     }
 344     ?>
 345 </tbody>
 346 </table>
 347 </div> <!-- end of results -->
 348 <?php } else { ?>
 349 <div class='text'>
 350     <?php echo xlt('Please input search criteria above, and click Submit to view results.'); ?>
 351 </div>
 352 <?php } ?>
 353
 354 </form>
 355 </body>
 356 </html>