} echo '<div>' . ucwords(str_replace('_', ' ', $key)) . ' = ' . $value_used . '</div>'; } $receipts = ReportBookkeeping::getTotalReceipts($period); $returns = ReportBookkeeping::getTotalReturns($period); echo '<div>Total Amount Received = ' . number_format($receipts, 2) . '</div>' . '<div>Total Returns (including refund & non refund, ' . 'shipping cost and small amount adjustment) = ' . number_format($returns, 2) . '</div>' . '<div> <br /> </div>'; } } } } else { //WHEN CALLED WITHOUT SPECIFIC PERIOD (BY CRON) //NO NEED TO DISPLAY RESULT AND SAVE QUERIED DATA OF CURRENT PERIOD //set timetamp based on when cron is called, //if >=23 then consider grabbing today as period //else then always use previous day as period ReportBookkeeping::setOptionArchiveQueryAsExcel(true); $logger->write('Generating Period'); $period_timestamp = date('G') >= 23 ? time() : strtotime('-1 day'); $period = date(ReportBookkeeping::PERIOD_DATE_FORMAT, $period_timestamp); $logger->write('Query Invoices in Period'); $invoice_quantity = ReportBookkeeping::getInvoiceTotalQuantity($period); $invoice_amount = ReportBookkeeping::getInvoiceTotalAmount($period); $logger->write('Query Receipts in Period'); $receipts = ReportBookkeeping::getReceiptTotal($period); $receipts_late_from_prev_month = ReportBookkeeping::getReceiptTotalLateFromPreviousPeriod($period); $logger->write('Query Returns'); $returns = ReportBookkeeping::getReturnTotal($period); $returns_same_period = ReportBookkeeping::getTotalReturnsSamePeriod($period); $logger->write('Query Open Amount'); $open_amount = ReportBookkeeping::getOpenInvoiceTotalAmount($period, ReportBookkeeping::OPEN_INVOICE_MODE_CURRENT); $open_amount_prev0 = ReportBookkeeping::getOpenInvoiceTotalAmount($period, ReportBookkeeping::OPEN_INVOICE_MODE_CURRENT_PREV_PERIOD0);