Fix cancel front payment.
[openemr.git] / interface / reports / front_receipts_report.php
blobea98a88b92fcee0848ad68b27cc39f8c22acbc29
1 <?php
2 /**
3 * This report lists front office receipts for a given date range.
5 * Copyright (C) 2006-2015 Rod Roark <rod@sunsetsystems.com>
6 * Copyright (C) 2017 Brady Miller <brady.g.miller@gmail.com>
8 * LICENSE: This program is free software; you can redistribute it and/or
9 * modify it under the terms of the GNU General Public License
10 * as published by the Free Software Foundation; either version 2
11 * of the License, or (at your option) any later version.
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 * You should have received a copy of the GNU General Public License
17 * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
19 * @package OpenEMR
20 * @author Rod Roark <rod@sunsetsystems.com>
21 * @author Brady Miller <brady.g.miller@gmail.com>
22 * @link http://www.open-emr.org
25 use OpenEMR\Core\Header;
27 require_once("../globals.php");
28 require_once("$srcdir/patient.inc");
30 $from_date = fixDate($_POST['form_from_date'], date('Y-m-d'));
31 $to_date = fixDate($_POST['form_to_date'], date('Y-m-d'));
33 function bucks($amt)
35 return ($amt != 0.00) ? oeFormatMoney($amt) : '';
38 <html>
39 <head>
41 <title><?php xl('Front Office Receipts', 'e'); ?></title>
43 <?php Header::setupHeader('datetime-picker'); ?>
45 <script language="JavaScript">
47 <?php require($GLOBALS['srcdir'] . "/restoreSession.php"); ?>
49 var mypcc = '<?php echo $GLOBALS['phone_country_code'] ?>';
51 $(document).ready(function() {
52 var win = top.printLogSetup ? top : opener.top;
53 win.printLogSetup(document.getElementById('printbutton'));
55 $('.datepicker').datetimepicker({
56 <?php $datetimepicker_timepicker = false; ?>
57 <?php $datetimepicker_showseconds = false; ?>
58 <?php $datetimepicker_formatInput = false; ?>
59 <?php require($GLOBALS['srcdir'] . '/js/xl/jquery-datetimepicker-2-5-4.js.php'); ?>
60 <?php // can add any additional javascript settings to datetimepicker here; need to prepend first setting with a comma ?>
61 });
62 });
64 // The OnClick handler for receipt display.
65 function show_receipt(pid,timestamp) {
66 dlgopen('../patient_file/front_payment.php?receipt=1&patient=' + pid +
67 '&time=' + timestamp, '_blank', 550, 400, '', '', {
68 onClosed: 'reload'
69 });
72 </script>
74 <style type="text/css">
75 /* specifically include & exclude from printing */
76 @media print {
77 #report_parameters {
78 visibility: hidden;
79 display: none;
81 #report_parameters_daterange {
82 visibility: visible;
83 display: inline;
85 #report_results {
86 margin-top: 30px;
90 /* specifically exclude some from the screen */
91 @media screen {
92 #report_parameters_daterange {
93 visibility: hidden;
94 display: none;
97 </style>
98 </head>
100 <body class="body_top">
102 <!-- Required for the popup date selectors -->
103 <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
105 <span class='title'><?php xl('Report', 'e'); ?> - <?php xl('Front Office Receipts', 'e'); ?></span>
107 <div id="report_parameters_daterange">
108 <?php echo date("d F Y", strtotime($form_from_date)) ." &nbsp; to &nbsp; ". date("d F Y", strtotime($form_to_date)); ?>
109 </div>
111 <form name='theform' method='post' action='front_receipts_report.php' id='theform'>
113 <div id="report_parameters">
115 <input type='hidden' name='form_refresh' id='form_refresh' value=''/>
117 <table>
118 <tr>
119 <td width='410px'>
120 <div style='float:left'>
122 <table class='text'>
123 <tr>
124 <td class='control-label'>
125 <?php xl('From', 'e'); ?>:
126 </td>
127 <td>
128 <input type='text' class='datepicker form-control' name='form_from_date' id="form_from_date" size='10' value='<?php echo attr($form_from_date) ?>'
129 title='yyyy-mm-dd'>
130 </td>
131 <td class='control-label'>
132 <?php xl('To', 'e'); ?>:
133 </td>
134 <td>
135 <input type='text' class='datepicker form-control' name='form_to_date' id="form_to_date" size='10' value='<?php echo attr($form_to_date) ?>'
136 title='yyyy-mm-dd'>
137 </td>
138 </tr>
139 </table>
141 </div>
143 </td>
144 <td align='left' valign='middle' height="100%">
145 <table style='border-left:1px solid; width:100%; height:100%' >
146 <tr>
147 <td>
148 <div class="text-center">
149 <div class="btn-group" role="group">
150 <a href='#' class='btn btn-default btn-save' onclick='$("#form_refresh").attr("value","true"); $("#theform").submit();'>
151 <?php echo xlt('Submit'); ?>
152 </a>
153 <?php if ($_POST['form_refresh']) { ?>
154 <a href='#' class='btn btn-default btn-print' id='printbutton'>
155 <?php echo xlt('Print'); ?>
156 </a>
157 <?php } ?>
158 </div>
159 </div>
160 </td>
161 </tr>
162 </table>
163 </td>
164 </tr>
165 </table>
166 </div> <!-- end of parameters -->
168 <?php
169 if ($_POST['form_refresh'] || $_POST['form_orderby']) {
171 <div id="report_results">
172 <table>
173 <thead>
174 <th> <?php xl('Time', 'e'); ?> </th>
175 <th> <?php xl('Patient', 'e'); ?> </th>
176 <th> <?php xl('ID', 'e'); ?> </th>
177 <th> <?php xl('Method', 'e'); ?> </th>
178 <th> <?php xl('Source', 'e'); ?> </th>
179 <th align='right'> <?php xl('Today', 'e'); ?> </th>
180 <th align='right'> <?php xl('Previous', 'e'); ?> </th>
181 <th align='right'> <?php xl('Total', 'e'); ?> </th>
182 </thead>
183 <tbody>
184 <?php
185 if (true || $_POST['form_refresh']) {
186 $total1 = 0.00;
187 $total2 = 0.00;
189 $query = "SELECT r.pid, r.dtime, " .
190 "SUM(r.amount1) AS amount1, " .
191 "SUM(r.amount2) AS amount2, " .
192 "MAX(r.method) AS method, " .
193 "MAX(r.source) AS source, " .
194 "MAX(r.user) AS user, " .
195 "p.fname, p.mname, p.lname, p.pubpid " .
196 "FROM payments AS r " .
197 "LEFT OUTER JOIN patient_data AS p ON " .
198 "p.pid = r.pid " .
199 "WHERE " .
200 "r.dtime >= '$from_date 00:00:00' AND " .
201 "r.dtime <= '$to_date 23:59:59' " .
202 "GROUP BY r.dtime, r.pid ORDER BY r.dtime, r.pid";
204 // echo "<!-- $query -->\n"; // debugging
205 $res = sqlStatement($query);
207 while ($row = sqlFetchArray($res)) {
208 // Make the timestamp URL-friendly.
209 $timestamp = preg_replace('/[^0-9]/', '', $row['dtime']);
211 <tr>
212 <td nowrap>
213 <a href="javascript:show_receipt(<?php echo $row['pid'] . ",'$timestamp'"; ?>)">
214 <?php echo text(oeFormatShortDate(substr($row['dtime'], 0, 10))) . substr($row['dtime'], 10, 6); ?>
215 </a>
216 </td>
217 <td>
218 <?php echo $row['lname'] . ', ' . $row['fname'] . ' ' . $row['mname'] ?>
219 </td>
220 <td>
221 <?php echo $row['pubpid'] ?>
222 </td>
223 <td>
224 <?php echo $row['method'] ?>
225 </td>
226 <td>
227 <?php echo $row['source'] ?>
228 </td>
229 <td align='right'>
230 <?php echo bucks($row['amount1']) ?>
231 </td>
232 <td align='right'>
233 <?php echo bucks($row['amount2']) ?>
234 </td>
235 <td align='right'>
236 <?php echo bucks($row['amount1'] + $row['amount2']) ?>
237 </td>
238 </tr>
239 <?php
240 $total1 += $row['amount1'];
241 $total2 += $row['amount2'];
245 <tr>
246 <td colspan='8'>
247 &nbsp;
248 </td>
249 </tr>
251 <tr class="report_totals">
252 <td colspan='5'>
253 <?php xl('Totals', 'e'); ?>
254 </td>
255 <td align='right'>
256 <?php echo bucks($total1) ?>
257 </td>
258 <td align='right'>
259 <?php echo bucks($total2) ?>
260 </td>
261 <td align='right'>
262 <?php echo bucks($total1 + $total2) ?>
263 </td>
264 </tr>
266 <?php
269 </tbody>
270 </table>
271 </div> <!-- end of results -->
272 <?php } else { ?>
273 <div class='text'>
274 <?php echo xl('Please input search criteria above, and click Submit to view results.', 'e'); ?>
275 </div>
276 <?php } ?>
278 </form>
279 </body>
280 </html>