}
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);
