interface/reports/sales_by_item.php

   1 <?php
   2
   3 /**
   4  * This is a report of sales by item description.
   5  *
   6  * @package   OpenEMR
   7  * @link      https://www.open-emr.org
   8  * @author    Rod Roark <rod@sunsetsystems.com>
   9  * @author    Terry Hill <terry@lillysystems.com>
  10  * @author    Brady Miller <brady.g.miller@gmail.com>
  11  * @copyright Copyright (c) 2006-2016 Rod Roark <rod@sunsetsystems.com>
  12  * @copyright Copyright (c) 2015-2016 Terry Hill <terry@lillysystems.com>
  13  * @copyright Copyright (c) 2017-2018 Brady Miller <brady.g.miller@gmail.com>
  14  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  15  */
  16
  17 require_once("../globals.php");
  18 require_once("$srcdir/patient.inc");
  19 require_once "$srcdir/options.inc.php";
  20
  21 use OpenEMR\Common\Acl\AclMain;
  22 use OpenEMR\Common\Csrf\CsrfUtils;
  23 use OpenEMR\Core\Header;
  24
  25 if (!empty($_POST)) {
  26     if (!CsrfUtils::verifyCsrfToken($_POST["csrf_token_form"])) {
  27         CsrfUtils::csrfNotVerified();
  28     }
  29 }
  30
  31 $form_provider  = $_POST['form_provider'] ?? null;
  32 if (!empty($_POST['form_refresh']) || !empty($_POST['form_csvexport'])) {
  33     $form_details = (!empty($_POST['form_details'])) ? true : false;
  34 } else {
  35     $form_details = false;
  36 }
  37
  38 function bucks($amount)
  39 {
  40     if ($amount) {
  41         return oeFormatMoney($amount);
  42     }
  43 }
  44
  45 function display_desc($desc)
  46 {
  47     if (preg_match('/^\S*?:(.+)$/', $desc, $matches)) {
  48         $desc = $matches[1];
  49     }
  50
  51     return $desc;
  52 }
  53
  54 function thisLineItem($patient_id, $encounter_id, $rowcat, $description, $transdate, $qty, $amount, $irnumber = '')
  55 {
  56     global $product, $category, $producttotal, $productqty, $cattotal, $catqty, $grandtotal, $grandqty;
  57     global $productleft, $catleft;
  58
  59     $invnumber = $irnumber ? $irnumber : "$patient_id.$encounter_id";
  60     $rowamount = sprintf('%01.2f', $amount);
  61
  62     $patdata = sqlQuery("SELECT " .
  63     "p.fname, p.mname, p.lname, p.pubpid, p.DOB, " .
  64     "p.street, p.city, p.state, p.postal_code, " .
  65     "p.ss, p.sex, p.status, p.phone_home, " .
  66     "p.phone_biz, p.phone_cell, p.hipaa_notice " .
  67     "FROM patient_data AS p " .
  68     "WHERE p.pid = ? LIMIT 1", array($patient_id));
  69
  70     $pat_name = $patdata['fname'] . ' ' . $patdata['mname'] . ' ' . $patdata['lname'];
  71
  72     if (empty($rowcat)) {
  73         $rowcat = xl('None{{Sales}}');
  74     }
  75
  76     $rowproduct = $description;
  77     if (! $rowproduct) {
  78         $rowproduct = xl('Unknown');
  79     }
  80
  81     if ($product != $rowproduct || $category != $rowcat) {
  82         if ($product) {
  83             // Print product total.
  84             if ($_POST['form_csvexport']) {
  85                 if (! $_POST['form_details']) {
  86                     echo csvEscape(display_desc($category)) . ',';
  87                     echo csvEscape(display_desc($product))  . ',';
  88                     echo csvEscape($productqty)             . ',';
  89                     echo csvEscape(bucks($producttotal));
  90                     echo "\n";
  91                 }
  92             } else {
  93                 ?>
  94        <tr bgcolor="#ddddff">
  95         <td class="detail">
  96                 <?php echo text(display_desc($catleft));
  97                 $catleft = " "; ?>
  98   </td>
  99   <td class="detail" colspan="3">
 100                 <?php
 101                 if ($_POST['form_details']) {
 102                     echo xlt('Total for') . ' ';
 103                 }
 104
 105                 echo text(display_desc($product)); ?>
 106   </td>
 107                 <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {?>
 108   <td>
 109   &nbsp;
 110   </td>
 111     <?php } ?>
 112   <td align="right">
 113    &nbsp;
 114   </td>
 115   <td align="right">
 116                 <?php echo text($productqty); ?>
 117   </td>
 118   <td align="right">
 119                 <?php echo text(bucks($producttotal)); ?>
 120   </td>
 121  </tr>
 122                 <?php
 123             } // End not csv export
 124         }
 125
 126         $producttotal = 0;
 127         $productqty = 0;
 128         $product = $rowproduct;
 129         $productleft = $product;
 130     }
 131
 132     if ($category != $rowcat) {
 133         if ($category) {
 134             // Print category total.
 135             if (!$_POST['form_csvexport']) {
 136                 ?>
 137
 138        <tr bgcolor="#ffdddd">
 139         <td class="detail">
 140          &nbsp;
 141         </td>
 142         <td class="detail" colspan="3">
 143                 <?php echo xlt('Total for category') . ' ';
 144                 echo text(display_desc($category)); ?>
 145   </td>
 146                 <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {?>
 147   <td>
 148    &nbsp;
 149   </td>
 150     <?php } ?>
 151   <td align="right">
 152    &nbsp;
 153   </td>
 154   <td align="right">
 155                 <?php echo text($catqty); ?>
 156   </td>
 157   <td align="right">
 158                 <?php echo text(bucks($cattotal)); ?>
 159   </td>
 160  </tr>
 161                 <?php
 162             } // End not csv export
 163         }
 164
 165         $cattotal = 0;
 166         $catqty = 0;
 167         $category = $rowcat;
 168         $catleft = $category;
 169     }
 170
 171     if (!empty($_POST['form_details'])) {
 172         if ($_POST['form_csvexport']) {
 173             echo csvEscape(display_desc($category)) . ',';
 174             echo csvEscape(display_desc($product)) . ',';
 175             echo csvEscape(oeFormatShortDate(display_desc($transdate))) . ',';
 176             if ($GLOBALS['sales_report_invoice'] == 1 || $GLOBALS['sales_report_invoice'] == 2) {
 177                 echo csvEscape($pat_name) . ',';
 178             }
 179
 180             if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
 181                 echo csvEscape(display_desc($invnumber)) . ',';
 182             }
 183
 184             if ($GLOBALS['sales_report_invoice'] == 1) {
 185                 echo csvEscape($patient_id) . ',';
 186             }
 187
 188            // echo '"' . display_desc($invnumber) . '",';
 189             echo csvEscape(display_desc($qty)) . ',';
 190             echo csvEscape(bucks($rowamount));
 191             echo "\n";
 192         } else {
 193             ?>
 194
 195      <tr>
 196       <td class="detail">
 197             <?php echo text(display_desc($catleft));
 198             $catleft = " "; ?>
 199   </td>
 200   <td class="detail">
 201             <?php echo text(display_desc($productleft));
 202             $productleft = " "; ?>
 203   </td>
 204   <td>
 205             <?php echo text(oeFormatShortDate($transdate)); ?>
 206   </td>
 207             <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {?>
 208   <td>
 209    &nbsp;
 210   </td>
 211         <?php } ?>
 212             <?php if ($GLOBALS['sales_report_invoice'] == 1 || $GLOBALS['sales_report_invoice'] == 2) { ?>
 213   <td>
 214                 <?php echo text($pat_name); ?>
 215   </td>
 216         <?php } ?>
 217   <td class="detail">
 218             <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) { ?>
 219    <a href='../patient_file/pos_checkout.php?ptid=<?php echo attr_url($patient_id); ?>&enc=<?php echo attr_url($encounter_id); ?>'>
 220                 <?php echo text($invnumber); ?></a>
 221     <?php }
 222
 223             if ($GLOBALS['sales_report_invoice'] == 1) {
 224                 echo text($patient_id);
 225             }
 226             ?>
 227       </td>
 228             <?php if ($GLOBALS['sales_report_invoice'] == 0) {?>
 229   <td>
 230    &nbsp;
 231   </td>
 232         <?php } ?>
 233       <td align="right">
 234             <?php echo text($qty); ?>
 235       </td>
 236       <td align="right">
 237             <?php echo text(bucks($rowamount)); ?>
 238       </td>
 239      </tr>
 240             <?php
 241         } // End not csv export
 242     } // end details
 243     $producttotal += $rowamount;
 244     $cattotal     += $rowamount;
 245     $grandtotal   += $rowamount;
 246     $productqty   += $qty;
 247     $catqty       += $qty;
 248     $grandqty     += $qty;
 249 } // end function
 250
 251 if (! AclMain::aclCheckCore('acct', 'rep')) {
 252     die(xlt("Unauthorized access."));
 253 }
 254
 255 $form_from_date = (isset($_POST['form_from_date'])) ? DateToYYYYMMDD($_POST['form_from_date']) : date('Y-m-d');
 256 $form_to_date   = (isset($_POST['form_to_date'])) ? DateToYYYYMMDD($_POST['form_to_date']) : date('Y-m-d');
 257 $form_facility  = $_POST['form_facility'] ?? null;
 258
 259 if (!empty($_POST['form_csvexport'])) {
 260     header("Pragma: public");
 261     header("Expires: 0");
 262     header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
 263     header("Content-Type: application/force-download");
 264     header("Content-Disposition: attachment; filename=sales_by_item.csv");
 265     header("Content-Description: File Transfer");
 266     // CSV headers:
 267     if ($_POST['form_details']) {
 268         echo '"Category",';
 269         echo '"Item",';
 270         echo '"Date",';
 271         if ($GLOBALS['sales_report_invoice'] == 1 || $GLOBALS['sales_report_invoice'] == 2) {
 272             echo '"Name",';
 273         }
 274
 275         if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {
 276             echo '"Invoice",';
 277         }
 278
 279         if ($GLOBALS['sales_report_invoice'] == 1) {
 280             echo '"ID",';
 281         }
 282
 283         echo '"Qty",';
 284         echo '"Amount"' . "\n";
 285     } else {
 286         echo '"Category",';
 287         echo '"Item",';
 288         echo '"Qty",';
 289         echo '"Total"' . "\n";
 290     }
 291 } else { // end export
 292     ?>
 293 <html>
 294 <head>
 295
 296     <title><?php echo xlt('Sales by Item'); ?></title>
 297
 298     <?php Header::setupHeader(['datetime-picker', 'report-helper']); ?>
 299
 300     <style>
 301         /* specifically include & exclude from printing */
 302         @media print {
 303             #report_parameters {
 304                 visibility: hidden;
 305                display: none;
 306             }
 307             #report_parameters_daterange {
 308                 visibility: visible;
 309                 display: inline;
 310             }
 311             #report_results {
 312                margin-top: 30px;
 313             }
 314         }
 315
 316         /* specifically exclude some from the screen */
 317         @media screen {
 318             #report_parameters_daterange {
 319                 visibility: hidden;
 320               display: none;
 321             }
 322         }
 323
 324         table.mymaintable, table.mymaintable td {
 325             border-collapse: collapse;
 326         }
 327         table.mymaintable td {
 328             padding: 1px 5px 1px 5px;
 329         }
 330     </style>
 331
 332     <script>
 333         $(function () {
 334             oeFixedHeaderSetup(document.getElementById('mymaintable'));
 335             var win = top.printLogSetup ? top : opener.top;
 336             win.printLogSetup(document.getElementById('printbutton'));
 337
 338             $('.datepicker').datetimepicker({
 339                 <?php $datetimepicker_timepicker = false; ?>
 340                 <?php $datetimepicker_showseconds = false; ?>
 341                 <?php $datetimepicker_formatInput = true; ?>
 342                 <?php require($GLOBALS['srcdir'] . '/js/xl/jquery-datetimepicker-2-5-4.js.php'); ?>
 343                 <?php // can add any additional javascript settings to datetimepicker here; need to prepend first setting with a comma ?>
 344             });
 345         });
 346     </script>
 347 </head>
 348
 349 <title><?php echo xlt('Sales by Item') ?></title>
 350
 351 <body leftmargin='0' topmargin='0' marginwidth='0' marginheight='0' class="body_top">
 352
 353 <span class='title'><?php echo xlt('Report'); ?> - <?php echo xlt('Sales by Item'); ?></span>
 354
 355 <form method='post' action='sales_by_item.php' id='theform' onsubmit='return top.restoreSession()'>
 356 <input type="hidden" name="csrf_token_form" value="<?php echo attr(CsrfUtils::collectCsrfToken()); ?>" />
 357
 358 <div id="report_parameters">
 359 <input type='hidden' name='form_refresh' id='form_refresh' value=''/>
 360 <input type='hidden' name='form_csvexport' id='form_csvexport' value=''/>
 361 <table>
 362 <tr>
 363 <td width='630px'>
 364   <div style='float:left'>
 365   <table class='text'>
 366       <tr>
 367           <td class='col-form-label'>
 368             <?php echo xlt('Facility'); ?>:
 369           </td>
 370           <td>
 371         <?php dropdown_facility($form_facility, 'form_facility', true); ?>
 372           </td>
 373           <td class='col-form-label'>
 374             <?php echo xlt('From'); ?>:
 375           </td>
 376           <td>
 377             <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)); ?>'>
 378           </td>
 379           <td class='col-form-label'>
 380             <?php echo xlt('To{{Range}}'); ?>:
 381           </td>
 382           <td>
 383             <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)); ?>'>
 384           </td>
 385       </tr>
 386   </table>
 387   <table class='text'>
 388       <tr>
 389         <td class='col-form-label'>
 390         <?php echo xlt('Provider'); ?>:
 391         </td>
 392         <td>
 393         <?php
 394         if (AclMain::aclCheckCore('acct', 'rep_a')) {
 395           // Build a drop-down list of providers.
 396             $query = "select id, lname, fname from users where " .
 397               "authorized = 1 order by lname, fname";
 398             $res = sqlStatement($query);
 399             echo "   &nbsp;<select name='form_provider' class='form-control'>\n";
 400             echo "    <option value=''>-- " . xlt('All Providers') . " --\n";
 401             while ($row = sqlFetchArray($res)) {
 402                 $provid = $row['id'];
 403                 echo "    <option value='" . attr($provid) . "'";
 404                 if (!empty($_REQUEST['form_provider']) && ($provid == $_REQUEST['form_provider'])) {
 405                     echo " selected";
 406                 }
 407
 408                 echo ">" . text($row['lname']) . ", " . text($row['fname']) . "\n";
 409             }
 410
 411             echo "   </select>\n";
 412         } else {
 413             echo "<input type='hidden' name='form_provider' value='" . attr($_SESSION['authUserID']) . "'>";
 414         }
 415         ?>
 416             &nbsp;
 417           </td>
 418           <td>
 419             <div class='checkbox'>
 420            <label><input type='checkbox' name='form_details'<?php echo ($form_details) ? ' checked' : ''; ?>>
 421             <?php echo xlt('Details'); ?></label>
 422             </div>
 423           </td>
 424         </tr>
 425     </table>
 426   </div>
 427
 428   </td>
 429   <td class='h-100' align='left' valign='middle'>
 430     <table class='w-100 h-100' style='border-left:1px solid;'>
 431          <tr>
 432             <td>
 433               <div class="text-center">
 434                   <div class="btn-group" role="group">
 435                       <a href='#' class='btn btn-secondary btn-save' onclick='$("#form_refresh").attr("value","true"); $("#form_csvexport").attr("value",""); $("#theform").submit();'>
 436                         <?php echo xlt('Submit'); ?>
 437                       </a>
 438                     <?php if (!empty($_POST['form_refresh']) || !empty($_POST['form_csvexport'])) { ?>
 439                             <a href='#' class='btn btn-secondary btn-print' id='printbutton'>
 440                                 <?php echo xlt('Print'); ?>
 441                             </a>
 442                             <a href='#' class='btn btn-secondary btn-transmit' onclick='$("#form_refresh").attr("value",""); $("#form_csvexport").attr("value","true"); $("#theform").submit();'>
 443                                 <?php echo xlt('CSV Export'); ?>
 444                             </a>
 445                     <?php } ?>
 446                   </div>
 447               </div>
 448            </td>
 449         </tr>
 450     </table>
 451   </td>
 452  </tr>
 453 </table>
 454
 455 </div> <!-- end of parameters -->
 456
 457     <?php
 458     if (!empty($_POST['form_refresh']) || !empty($_POST['form_csvexport'])) {
 459         ?>
 460
 461 <div id="report_results">
 462 <table width='98%' id='mymaintable' class='table table-striped mymaintable'>
 463 <thead class='thead-light'>
 464  <th>
 465         <?php echo xlt('Category'); ?>
 466  </th>
 467  <th>
 468         <?php echo xlt('Item'); ?>
 469  </th>
 470  <th>
 471         <?php
 472         if ($form_details) {
 473             echo xlt('Date');
 474         } ?>
 475  </th>
 476         <?php if ($GLOBALS['sales_report_invoice'] == 2) {?>
 477   <th>
 478    &nbsp;
 479   </th>
 480     <?php } ?>
 481  <th>
 482         <?php
 483         if ($GLOBALS['sales_report_invoice'] == 0) {
 484             if ($form_details) {
 485                 echo ' ';
 486             }
 487             ?>
 488    </th>
 489    <th>
 490             <?php
 491             if ($form_details) {
 492                 echo xlt('Invoice');
 493             }
 494         }
 495
 496         if ($GLOBALS['sales_report_invoice'] == 1 || $GLOBALS['sales_report_invoice'] == 2) {
 497             if ($form_details) {
 498                 echo xlt('Name');
 499             }
 500         } ?>
 501   </th>
 502   <th>
 503         <?php
 504         if ($GLOBALS['sales_report_invoice'] == 2) {
 505             if ($form_details) {
 506                 echo xlt('Invoice');
 507             }
 508         }
 509
 510         if ($GLOBALS['sales_report_invoice'] == 1) {
 511             if ($form_details) {
 512                 echo xlt('ID');
 513             }
 514         }
 515         ?>
 516   </th>
 517   <th align="right">
 518         <?php echo xlt('Qty'); ?>
 519   </th>
 520   <th align="right">
 521         <?php echo xlt('Amount'); ?>
 522   </th>
 523  </thead>
 524  <tbody>
 525         <?php
 526     } // end not export
 527 }
 528
 529 if (!empty($_POST['form_refresh']) || !empty($_POST['form_csvexport'])) {
 530     $from_date = $form_from_date . ' 00:00:00';
 531     $to_date = $form_to_date . ' 23:59:59';
 532     $category = "";
 533     $catleft = "";
 534     $cattotal = 0;
 535     $catqty = 0;
 536     $product = "";
 537     $productleft = "";
 538     $producttotal = 0;
 539     $productqty = 0;
 540     $grandtotal = 0;
 541     $grandqty = 0;
 542
 543     $sqlBindArray = array();
 544     $query = "SELECT b.fee, b.pid, b.encounter, b.code_type, b.code, b.units, " .
 545     "b.code_text, fe.date, fe.facility_id, fe.provider_id, fe.invoice_refno, lo.title " .
 546     "FROM billing AS b " .
 547     "JOIN code_types AS ct ON ct.ct_key = b.code_type " .
 548     "JOIN form_encounter AS fe ON fe.pid = b.pid AND fe.encounter = b.encounter " .
 549     "LEFT JOIN codes AS c ON c.code_type = ct.ct_id AND c.code = b.code AND c.modifier = b.modifier " .
 550     "LEFT JOIN list_options AS lo ON lo.list_id = 'superbill' AND lo.option_id = c.superbill AND lo.activity = 1 " .
 551     "WHERE b.code_type != 'COPAY' AND b.activity = 1 AND b.fee != 0 AND " .
 552     "fe.date >= ? AND fe.date <= ?";
 553     array_push($sqlBindArray, $from_date, $to_date);
 554     // If a facility was specified.
 555     if ($form_facility) {
 556         $query .= " AND fe.facility_id = ?";
 557         array_push($sqlBindArray, $form_facility);
 558     }
 559
 560     if ($form_provider) {
 561         $query .= " AND fe.provider_id = ?";
 562         array_push($sqlBindArray, $form_provider);
 563     }
 564
 565     $query .= " ORDER BY lo.title, b.code, fe.date, fe.id";
 566     //
 567     $res = sqlStatement($query, $sqlBindArray);
 568     while ($row = sqlFetchArray($res)) {
 569         thisLineItem(
 570             $row['pid'],
 571             $row['encounter'],
 572             $row['title'],
 573             $row['code'] . ' ' . $row['code_text'],
 574             substr($row['date'], 0, 10),
 575             $row['units'],
 576             $row['fee'],
 577             $row['invoice_refno']
 578         );
 579     }
 580
 581     //
 582     $sqlBindArray = array();
 583     $query = "SELECT s.sale_date, s.fee, s.quantity, s.pid, s.encounter, " .
 584     "d.name, fe.date, fe.facility_id, fe.provider_id, fe.invoice_refno " .
 585     "FROM drug_sales AS s " .
 586     "JOIN drugs AS d ON d.drug_id = s.drug_id " .
 587     "JOIN form_encounter AS fe ON " .
 588     "fe.pid = s.pid AND fe.encounter = s.encounter AND " .
 589     "fe.date >= ? AND fe.date <= ? " .
 590     "WHERE s.fee != 0";
 591     array_push($sqlBindArray, $from_date, $to_date);
 592     // If a facility was specified.
 593     if ($form_facility) {
 594         $query .= " AND fe.facility_id = ?";
 595         array_push($sqlBindArray, $form_facility);
 596     }
 597
 598     if ($form_provider) {
 599         $query .= " AND fe.provider_id = ?";
 600         array_push($sqlBindArray, $form_provider);
 601     }
 602
 603     $query .= " ORDER BY d.name, fe.date, fe.id";
 604     //
 605     $res = sqlStatement($query, $sqlBindArray);
 606     while ($row = sqlFetchArray($res)) {
 607         thisLineItem(
 608             $row['pid'],
 609             $row['encounter'],
 610             xl('Products'),
 611             $row['name'],
 612             substr($row['date'], 0, 10),
 613             $row['quantity'],
 614             $row['fee'],
 615             $row['invoice_refno']
 616         );
 617     }
 618
 619     if ($_POST['form_csvexport']) {
 620         if (! $_POST['form_details']) {
 621             echo csvEscape(display_desc($product)) . ',';
 622             echo csvEscape($productqty)            . ',';
 623             echo csvEscape(bucks($producttotal));
 624             echo "\n";
 625         }
 626     } else {
 627         ?>
 628
 629  <tr bgcolor="#ddddff">
 630   <td class="detail">
 631         <?php echo text(display_desc($catleft));
 632         $catleft = " "; ?>
 633   </td>
 634   <td class="detail" colspan="3">
 635         <?php
 636         if (!empty($_POST['form_details'])) {
 637             echo xlt('Total for') . ' ';
 638         }
 639
 640         echo text(display_desc($product)); ?>
 641   </td>
 642         <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {?>
 643   <td>
 644    &nbsp;
 645   </td>
 646     <?php } ?>
 647   <td align="right">
 648    &nbsp;
 649   </td>
 650   <td align="right">
 651         <?php echo text($productqty); ?>
 652   </td>
 653   <td align="right">
 654         <?php echo text(bucks($producttotal)); ?>
 655   </td>
 656  </tr>
 657
 658  <tr bgcolor="#ffdddd">
 659   <td class="detail">
 660    &nbsp;
 661   </td>
 662   <td class="detail" colspan="3"><strong>
 663         <?php echo xlt('Total for category') . ' ';
 664         echo text(display_desc($category)); ?>
 665   </strong></td>
 666         <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {?>
 667   <td>
 668    &nbsp;
 669   </td>
 670     <?php } ?>
 671   <td align="right">
 672    &nbsp;
 673   </td>
 674   <td align="right"><strong>
 675         <?php echo text($catqty); ?>
 676   </strong></td>
 677   <td align="right"><strong>
 678         <?php echo text(bucks($cattotal)); ?>
 679   </strong></td>
 680  </tr>
 681
 682  <tr>
 683   <td class="detail" colspan="4"><strong>
 684         <?php echo xlt('Grand Total'); ?>
 685   </strong></td>
 686         <?php if ($GLOBALS['sales_report_invoice'] == 0 || $GLOBALS['sales_report_invoice'] == 2) {?>
 687   <td>
 688    &nbsp;
 689   </td>
 690     <?php } ?>
 691   <td align="right">
 692    &nbsp;
 693   </td>
 694   <td align="right"><strong>
 695         <?php echo text($grandqty); ?>
 696   </strong></td>
 697   <td align="right"><strong>
 698         <?php echo text(bucks($grandtotal)); ?>
 699   </strong></td>
 700  </tr>
 701         <?php $report_from_date = oeFormatShortDate($form_from_date)  ;
 702         $report_to_date = oeFormatShortDate($form_to_date)  ;
 703         ?>
 704 <div align='right'><span class='title' ><?php echo xlt('Report Date') . ' '; ?><?php echo text($report_from_date);?> - <?php echo text($report_to_date);?></span></div>
 705         <?php
 706     } // End not csv export
 707 }
 708
 709 if (empty($_POST['form_csvexport'])) {
 710     if (!empty($_POST['form_refresh'])) {
 711         ?>
 712
 713 </tbody>
 714 </table>
 715 </div> <!-- report results -->
 716         <?php
 717     } else { ?>
 718 <div class='text'>
 719         <?php echo xlt('Please input search criteria above, and click Submit to view results.'); ?>
 720 </div>
 721         <?php
 722     } ?>
 723
 724 </form>
 725
 726 </body>
 727
 728 </html>
 729     <?php
 730 } // End not csv export
 731 ?>