* @author Brady Miller * @copyright Copyright (c) 2006-2015 Rod Roark * @copyright Copyright (c) 2017-2018 Brady Miller * @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3 */ require_once("../globals.php"); require_once("$srcdir/patient.inc"); require_once "$srcdir/options.inc.php"; use OpenEMR\Common\Acl\AclMain; use OpenEMR\Common\Csrf\CsrfUtils; use OpenEMR\Common\Twig\TwigContainer; use OpenEMR\Core\Header; if (!AclMain::aclCheckCore('acct', 'rep_a')) { echo (new TwigContainer(null, $GLOBALS['kernel']))->getTwig()->render('core/unauthorized.html.twig', ['pageTitle' => xl("Front Office Receipts")]); exit; } if (!empty($_POST)) { if (!CsrfUtils::verifyCsrfToken($_POST["csrf_token_form"])) { CsrfUtils::csrfNotVerified(); } } $from_date = (isset($_POST['form_from_date'])) ? DateToYYYYMMDD($_POST['form_from_date']) : date('Y-m-d'); $to_date = (isset($_POST['form_to_date'])) ? DateToYYYYMMDD($_POST['form_to_date']) : date('Y-m-d'); function bucks($amt) { return ($amt != 0.00) ? oeFormatMoney($amt) : ''; } ?> <?php echo xlt('Front Office Receipts'); ?> -
: : \n"; echo "
: :
= ? AND " . "r.dtime <= ? AND "; if ($_POST['form_facility'] != "") { $inputArray[] = $_POST['form_facility']; $query .= "fe.facility_id = ? AND "; } if ($_POST['form_provider'] != "") { $inputArray[] = $_POST['form_provider']; $query .= "fe.provider_id = ? AND "; } $query .= "1 GROUP BY r.dtime, r.pid ORDER BY r.dtime, r.pid"; // echo " $query \n"; // debugging $res = sqlStatement($query, $inputArray); while ($row = sqlFetchArray($res)) { // Make the timestamp URL-friendly. $timestamp = preg_replace('/[^0-9]/', '', $row['dtime']); ?>