monthReport.prg

<?php
/* File: monthReport.html
 * Purpose: provides a simple report for a month without any fluff introduced by Kendo.  You cannot do anything with this besides view it.
 */

$returnArray = MonthReport($dbh, $SYSENV, false);

if (!isset($returnArray)) { ?>
    <h1>No data available</h1>
<?php } else {
    $monthRecord = $returnArray["record"][0];

    try {
        $dateTime = new DateTime($monthRecord["month"]);
        $month = $dateTime->format("F Y");
    } catch (exception $e) {
        $month = "(No Month)";
    }
?>

<div class="container_12">
    <div class="grid_12">
        <div id="formValidateMainDiv" class="k-block k-error-colored" style="display:none;">
            <?php if ($returnArray["status"] !== "000") { ?>
                <p>The following errors were detected:</p>
                <ul>
                    <li><?php echo $returnArray["error"]; ?></li>
                </ul>
      <?php } ?>
        </div>
    </div>

    <table class="plainGrid">
          <tr class="monthHeader">
            <th colspan="6"><?php echo $month; ?></th>
        </tr>
        <tr>
            <td colspan="6">&nbsp;</td>
        </tr>
    <?php $outerIndex = 1;
    $grandTotal = 0;

    if (isset($monthRecord["cus"])) {
      foreach($monthRecord["cus"] as $cuRecord) {
          $grandTotal += $cuRecord["totalAmount"];
                $totalFormatted = $cuRecord["totalAmount"] < 0 ? "$(" . number_format(abs($cuRecord["totalAmount"]), 2) . ")"
                                                               : "$" . number_format($cuRecord["totalAmount"], 2);
                ?>
              <tr class="cuHeader">
                  <td colspan="6"><?php echo $cuRecord["cuName"]; ?> (<?php echo $cuRecord["cu"]; ?>)</td>
              </tr>
                <tr class="invoiceHeader">
                    <td></td>
                    <td>Product</td>
                    <td>Feature</td>
                    <td style="text-align:right;">Quantity</td>
                    <td></td>
                    <td style="text-align:right;">Amount</td>
                </tr>
                <?php $innerIndex = 1;
                foreach($cuRecord["invoices"] as $invoiceRecord) {
                          $innerClass = $innerIndex++ % 2 == 0 ? "innerEven" : "innerOdd";
                          $amountFormatted = $invoiceRecord["amount"] < 0 ? "$(" . number_format(abs($invoiceRecord["amount"]), 2) . ")"
                                                                          : "$" . number_format($invoiceRecord["amount"], 2);
                          ?>
                      <tr class="<?php echo "$innerClass"; ?>">
                          <td></td>
                          <td><?php echo $invoiceRecord["productDescription"]; ?></td>
                          <td><?php echo $invoiceRecord["featureDescription"]; ?></td>
                          <td style="text-align:right;"><?php echo $invoiceRecord["quantity"]; ?></td>
                          <td></td>
                          <td style="text-align:right;"><?php echo $amountFormatted; ?></td>
                      </tr>
                <?php } ?>
                    <tr class="cuFooter">
                        <td colspan="4"></td>
                        <td style="text-align:right;">Total: </td>
                        <td style="text-align:right;"><?php echo $totalFormatted; ?></td>
                    </tr>
                    <tr>
                        <td colspan="6">&nbsp;</td>
                    </tr>
       <?php }
     }
     $grandTotalFormatted = $grandTotal < 0 ? "$(" . number_format(abs($grandTotal), 2) . ")" : "$" . number_format($grandTotal, 2);
     ?>
     <tr>
         <td colspan="6">&nbsp;</td>
     </tr>
     <tr class="grandTotalFooter">
         <td colspan="4"></td>
        <td style="text-align:right;">Grand Total: </td>
        <td style="text-align:right;"><?php echo $grandTotalFormatted; ?></td>
     </tr>
     </table>
</div>

<?php }