interface/reports/custom_report_range.php

   1 <?php
   2 // This program is free software; you can redistribute it and/or
   3 // modify it under the terms of the GNU General Public License
   4 // as published by the Free Software Foundation; either version 2
   5 // of the License, or (at your option) any later version.
   6
   7 require_once(dirname(__file__)."/../globals.php");
   8 require_once("$srcdir/forms.inc");
   9 require_once("$srcdir/billing.inc");
  10 require_once("$srcdir/pnotes.inc");
  11 require_once("$srcdir/patient.inc");
  12 require_once("$srcdir/report.inc");
  13 require_once("$srcdir/classes/Document.class.php");
  14 require_once("$srcdir/classes/Note.class.php");
  15 require_once("$srcdir/formatting.inc.php");
  16
  17 $startdate = $enddate = "";
  18 if(empty($_POST['start']) || empty($_POST['end'])) {
  19     // set some default dates
  20     $startdate = date('Y-m-d', (time() - 30*24*60*60));
  21     $enddate = date('Y-m-d', time());
  22 }
  23 else {
  24     // set dates
  25     $startdate = $_POST['start'];
  26     $enddate = $_POST['end'];
  27 }
  28 ?>
  29 <html>
  30
  31 <head>
  32 <?php html_header_show();?>
  33
  34 <link rel="stylesheet" href="<?php echo $css_header;?>" type="text/css">
  35 <style>
  36
  37 @media print {
  38         .title {
  39                 visibility: hidden;
  40         }
  41     .pagebreak {
  42         page-break-after: always;
  43         border: none;
  44         visibility: hidden;
  45     }
  46
  47         #superbill_description {
  48                 visibility: hidden;
  49         }
  50
  51         #report_parameters {
  52                 visibility: hidden;
  53         }
  54     #superbill_results {
  55        margin-top: -30px;
  56     }
  57 }
  58
  59 @media screen {
  60         .title {
  61                 visibility: visible;
  62         }
  63         #superbill_description {
  64                 visibility: visible;
  65         }
  66     .pagebreak {
  67         width: 100%;
  68         border: 2px dashed black;
  69     }
  70         #report_parameters {
  71                 visibility: visible;
  72         }
  73 }
  74 #superbill_description {
  75    margin: 10px;
  76 }
  77 #superbill_startingdate {
  78     margin: 10px;
  79 }
  80 #superbill_endingdate {
  81     margin: 10px;
  82 }
  83
  84 #superbill_patientdata {
  85 }
  86 #superbill_patientdata h1 {
  87     font-weight: bold;
  88     font-size: 1.2em;
  89     margin: 0px;
  90     padding: 5px;
  91     width: 100%;
  92     background-color: #eee;
  93     border: 1px solid black;
  94 }
  95 #superbill_insurancedata {
  96     margin-top: 10px;
  97 }
  98 #superbill_insurancedata h1 {
  99     font-weight: bold;
 100     font-size: 1.2em;
 101     margin: 0px;
 102     padding: 5px;
 103     width: 100%;
 104     background-color: #eee;
 105     border: 1px solid black;
 106 }
 107 #superbill_insurancedata h2 {
 108     font-weight: bold;
 109     font-size: 1.0em;
 110     margin: 0px;
 111     padding: 0px;
 112     width: 100%;
 113     background-color: #eee;
 114 }
 115 #superbill_billingdata {
 116     margin-top: 10px;
 117 }
 118 #superbill_billingdata h1 {
 119     font-weight: bold;
 120     font-size: 1.2em;
 121     margin: 0px;
 122     padding: 5px;
 123     width: 100%;
 124     background-color: #eee;
 125     border: 1px solid black;
 126 }
 127 #superbill_signature {
 128 }
 129 #superbill_logo {
 130 }
 131 </style>
 132
 133 </head>
 134
 135 <body class="body_top">
 136
 137 <span class='title'><?php xl('Reports','e'); ?> - <?php xl('Superbill','e'); ?></span>
 138
 139 <div id="superbill_description" class='text'>
 140 <?php xl('Superbills, sometimes referred to as Encounter Forms or Routing Slips, are an essential part of most medical practices.','e'); ?>
 141 </div>
 142
 143 <div id="report_parameters">
 144
 145 <form method="post" id='theform' action="custom_report_range.php">
 146 <input type='hidden' name='form_refresh' id='form_refresh' value=''/>
 147 <table>
 148  <tr>
 149   <td width='450px'>
 150         <div style='float:left'>
 151
 152         <table class='text'>
 153                 <tr>
 154                         <td class='label'>
 155                            <?php xl('Start Date','e'); ?>:
 156                         </td>
 157                         <td>
 158                            <input type='text' name='start' id="form_from_date" size='10' value='<?php echo $startdate ?>'
 159                                 onkeyup='datekeyup(this,mypcc)' onblur='dateblur(this,mypcc)' title='yyyy-mm-dd'>
 160                            <img src='../pic/show_calendar.gif' align='absbottom' width='24' height='22'
 161                                 id='img_from_date' border='0' alt='[?]' style='cursor:pointer'
 162                                 title='<?php xl('Click here to choose a date','e'); ?>'>
 163                         </td>
 164                         <td class='label'>
 165                            <?php xl('End Date','e'); ?>:
 166                         </td>
 167                         <td>
 168                            <input type='text' name='end' id="form_to_date" size='10' value='<?php echo $enddate ?>'
 169                                 onkeyup='datekeyup(this,mypcc)' onblur='dateblur(this,mypcc)' title='yyyy-mm-dd'>
 170                            <img src='../pic/show_calendar.gif' align='absbottom' width='24' height='22'
 171                                 id='img_to_date' border='0' alt='[?]' style='cursor:pointer'
 172                                 title='<?php xl('Click here to choose a date','e'); ?>'>
 173                         </td>
 174                 </tr>
 175         </table>
 176
 177         </div>
 178
 179   </td>
 180   <td align='left' valign='middle' height="100%">
 181         <table style='border-left:1px solid; width:100%; height:100%' >
 182                 <tr>
 183                         <td>
 184                                 <div style='margin-left:15px'>
 185                                         <a href='#' class='css_button' onclick='$("#form_refresh").attr("value","true"); $("#theform").submit();'>
 186                                         <span>
 187                                                 <?php xl('Submit','e'); ?>
 188                                         </span>
 189                                         </a>
 190
 191                                         <?php if ($_POST['form_refresh']) { ?>
 192                                         <a href='#' class='css_button' onclick='window.print()'>
 193                                                 <span>
 194                                                         <?php xl('Print','e'); ?>
 195                                                 </span>
 196                                         </a>
 197                                         <?php } ?>
 198                                 </div>
 199                         </td>
 200                 </tr>
 201         </table>
 202   </td>
 203  </tr>
 204 </table>
 205 </div> <!-- end of parameters -->
 206
 207 </form>
 208
 209 <div id="superbill_results">
 210
 211 <?php
 212 if( !(empty($_POST['start']) || empty($_POST['end']))) {
 213     $sql = "select * from facility where billing_location = 1";
 214     $db = $GLOBALS['adodb']['db'];
 215     $results = $db->Execute($sql);
 216     $facility = array();
 217     if (!$results->EOF) {
 218         $facility = $results->fields;
 219 ?>
 220 <p>
 221 <h2><?php $facility['name']?></h2>
 222 <?php $facility['street']?><br>
 223 <?php $facility['city']?>, <?php $facility['state']?> <?php $facility['postal_code']?><br>
 224
 225 </p>
 226 <?php
 227     }
 228
 229     $res = sqlStatement("select * from forms where " .
 230                         "form_name = 'New Patient Encounter' and " .
 231                         "date between '$startdate' and '$enddate' " .
 232                         "order by date DESC");
 233     while($result = sqlFetchArray($res)) {
 234         if ($result{"form_name"} == "New Patient Encounter") {
 235             $newpatient[] = $result{"form_id"}.":".$result{"encounter"};
 236             $pids[] = $result{"pid"};
 237         }
 238     }
 239     $N = 6;
 240
 241     function postToGet($newpatient, $pids) {
 242         $getstring="";
 243         $serialnewpatient = serialize($newpatient);
 244         $serialpids = serialize($pids);
 245         $getstring = "newpatient=".urlencode($serialnewpatient)."&pids=".urlencode($serialpids);
 246
 247         return $getstring;
 248     }
 249
 250     $iCounter = 0;
 251     if(empty($newpatient)){ $newpatient = array(); }
 252     foreach($newpatient as $patient){
 253         /*
 254         $inclookupres = sqlStatement("select distinct formdir from forms where pid='".$pids[$iCounter]."'");
 255         while($result = sqlFetchArray($inclookupres)) {
 256             include_once("{$GLOBALS['incdir']}/forms/" . $result{"formdir"} . "/report.php");
 257         }
 258         */
 259
 260         print "<div id='superbill_patientdata'>";
 261         print "<h1>".xl('Patient Data').":</h1>";
 262         printRecDataOne($patient_data_array, getRecPatientData ($pids[$iCounter]), $N);
 263         print "</div>";
 264
 265         print "<div id='superbill_insurancedata'>";
 266         print "<h1>".xl('Insurance Data').":</h1>";
 267         print "<h2>".xl('Primary').":</h2>";
 268         printRecDataOne($insurance_data_array, getRecInsuranceData ($pids[$iCounter],"primary"), $N);
 269         print "<h2>".xl('Secondary').":</h2>";
 270         printRecDataOne($insurance_data_array, getRecInsuranceData ($pids[$iCounter],"secondary"), $N);
 271         print "<h2>".xl('Tertiary').":</h2>";
 272         printRecDataOne($insurance_data_array, getRecInsuranceData ($pids[$iCounter],"tertiary"), $N);
 273         print "</div>";
 274
 275         print "<div id='superbill_billingdata'>";
 276         print "<h1>".xl('Billing Information').":</h1>";
 277         if (count($patient) > 0) {
 278             $billings = array();
 279             echo "<table width='100%'>";
 280             echo "<tr>";
 281             echo "<td class='bold' width='10%'>".xl('Date')."</td>";
 282             echo "<td class='bold' width='20%'>".xl('Provider')."</td>";
 283             echo "<td class='bold' width='40%'>".xl('Code')."</td>";
 284             echo "<td class='bold' width='10%'>".xl('Fee')."</td></tr>\n";
 285             $total = 0.00;
 286             $copays = 0.00;
 287             //foreach ($patient as $be) {
 288
 289                 $ta = split(":",$patient);
 290                 $billing = getPatientBillingEncounter($pids[$iCounter],$ta[1]);
 291
 292                 $billings[] = $billing;
 293                 foreach ($billing as $b) {
 294                     // grab the date to reformat it in the output
 295                     $bdate = strtotime($b['date']);
 296
 297                     echo "<tr>\n";
 298                     echo "<td class='text' style='font-size: 0.8em'>" . oeFormatShortDate(date("Y-m-d",$bdate)) . "<BR>" . date("h:i a", $bdate) . "</td>";
 299                     echo "<td class='text'>" . $b['provider_name'] . "</td>";
 300                     echo "<td class='text'>";
 301                     echo $b['code_type'] . ":\t" . $b['code'] . "&nbsp;". $b['modifier'] . "&nbsp;&nbsp;&nbsp;" . $b['code_text'] . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
 302                     echo "</td>\n";
 303                     echo "<td class='text'>";
 304                     echo oeFormatMoney($b['fee']);
 305                     echo "</td>\n";
 306                     echo "</tr>\n";
 307                     $total += $b['fee'];
 308                     if ($b['code_type'] == "COPAY") {
 309                         $copays += $b['fee'];
 310                     }
 311                 }
 312             //}
 313             echo "<tr><td>&nbsp;</td></tr>";
 314             echo "<tr><td class='bold' colspan=3 style='text-align:right'>".xl('Sub-Total')."</td><td class='text'>" . oeFormatMoney($total + abs($copays)) . "</td></tr>";
 315             echo "<tr><td class='bold' colspan=3 style='text-align:right'>".xl('Paid')."</td><td class='text'>" . oeFormatMoney(abs($copays)) . "</td></tr>";
 316             echo "<tr><td class='bold' colspan=3 style='text-align:right'>".xl('Total')."</td><td class='text'>" . oeFormatMoney($total) . "</td></tr>";
 317             echo "</table>";
 318             echo "<pre>";
 319             //print_r($billings);
 320             echo "</pre>";
 321         }
 322         echo "</div>";
 323
 324         ++$iCounter;
 325         print "<br/><br/>".xl('Physician Signature').":  _______________________________________________";
 326         print "<hr class='pagebreak' />";
 327     }
 328 }
 329     ?>
 330 </div>
 331
 332     </body>
 333
 334 <!-- stuff for the popup calendar -->
 335 <style type="text/css">@import url(../../library/dynarch_calendar.css);</style>
 336 <script type="text/javascript" src="../../library/dynarch_calendar.js"></script>
 337 <?php include_once("{$GLOBALS['srcdir']}/dynarch_calendar_en.inc.php"); ?>
 338 <script type="text/javascript" src="../../library/dynarch_calendar_setup.js"></script>
 339 <script type="text/javascript" src="../../library/js/jquery.1.3.2.js"></script>
 340
 341 <script language="Javascript">
 342  Calendar.setup({inputField:"form_from_date", ifFormat:"%Y-%m-%d", button:"img_from_date"});
 343  Calendar.setup({inputField:"form_to_date", ifFormat:"%Y-%m-%d", button:"img_to_date"});
 344 </script>
 345 </html>