} 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);
$open_amount_prev1 = ReportBookkeeping::getOpenInvoiceTotalAmount($period, ReportBookkeeping::OPEN_INVOICE_MODE_CURRENT_PREV_PERIOD1);
$open_amount_prev2 = ReportBookkeeping::getOpenInvoiceTotalAmount($period, ReportBookkeeping::OPEN_INVOICE_MODE_CURRENT_PREV_PERIOD2);
$logger->write('Query Stock Total');
$stock_total_qty = ReportBookkeeping::getStockQuantityTotal(WAREHOUSE_ID_FOR_HANDLING_ORDERS);
$stock_total_value = ReportBookkeeping::getStockValueTotal(WAREHOUSE_ID_FOR_HANDLING_ORDERS);
$logger->write('Query Stock Incoming');
$stock_incoming_qty = ReportBookkeeping::getStockIncomingQuantityTotal();
$stock_incoming_value = ReportBookkeeping::getStockIncomingValueTotal();
$logger->write('Save bookkeeping data for period ' . $period);
$bkdata_prev = ReportBookkeeping::retrieveDetail($period_prev);
$result = '<div id="period-' . $period . '" class="period" style="float:left;margin:0 30px 30px 0;">';
if (is_array($bkdata)) {
$current_open_amount = ReportBookkeeping::getOpenInvoiceTotalAmount($period, ReportBookkeeping::OPEN_INVOICE_MODE_CURRENT);
$period_date = substr($period, 0, 4) . '-' . substr($period, 4, 2) . '-01';
$period_text = date('F Y', strtotime($period_date));
$period_prev_1_text = date('F Y', strtotime($period_date . ' -1 month'));
$period_prev_2_text = date('F Y', strtotime($period_date . ' -2 month'));
$open_amount = ReportBookkeeping::calculateOpenAmount($bkdata_prev['open_amount'], $bkdata['manual_input_paid_amount'], $bkdata['manual_input_refund_amount'], $bkdata['invoice_amount'], $bkdata['returns_amount']);
$open_amount_diff = $open_amount - $bkdata['open_amount'];
$edit_icon_paid = '<span class="ui-icon ui-icon-pencil pointer manual_input" title="Click to update this amount"><input type="hidden" id="paid-period-' . $period . '" value="' . $bkdata['manual_input_paid_amount'] . '" /></span>';
$edit_icon_refund = '<span class="ui-icon ui-icon-pencil pointer manual_input" title="Click to update this amount"><input type="hidden" id="refund-period-' . $period . '" value="' . $bkdata['manual_input_refund_amount'] . '" /></span>';
if ($bkdata['paid_amount_late'] > 0) {
$confirmed_payment_from_prev_period = $bkdata['paid_amount_late'];
} else {
$confirmed_payment_from_prev_period = ReportBookkeeping::getReceiptTotalLateFromPreviousPeriod($period);
}
$sent_to_atriga = ReportBookkeeping::getTotalAtriga($period);
$total_after_returns = ReportBookkeeping::getTotalAfterReturns($period);
$detail_icon_returns_amount = '<span class="ui-icon ui-icon-triangle-1-s pointer returns-amount-trigger" title="Click to show/hide detail of total returns amount"></span>';
$detail_icon_open_amount = '<span class="ui-icon ui-icon-triangle-1-s pointer open-amount-prev-trigger" title="Click to show/hide detail open amount per invoice period"></span>';
$archive_icon = '<span class="ui-icon ui-icon-disk pointer" title="Click here to download detail data of this value"></span>';
$archive_icon_atriga = '<a target="_blank" href="?open=report-bookkeeping&download=atriga-detail-list&period=' . $period . '">' . $archive_icon . '</a>';
if (is_file(DIR_FS_ARCHIVES . ReportBookkeeping::ARCHIVE_PATH . $bkdata['archive_invoice_in_period'])) {
$archive_icon_invoice_in_period = ReportBookkeeping::displayArchiveDownloadLinkAsHTML($bkdata['archive_invoice_in_period'], $archive_icon);
$archive_icon_invoice_open = ReportBookkeeping::displayArchiveDownloadLinkAsHTML($bkdata['archive_invoice_open'], $archive_icon);
$archive_icon_receipt_in_period = ReportBookkeeping::displayArchiveDownloadLinkAsHTML($bkdata['archive_receipt_late_in_period'], $archive_icon);
$archive_icon_return_in_period = ReportBookkeeping::displayArchiveDownloadLinkAsHTML($bkdata['archive_return_in_period'], $archive_icon);
$archive_icon_stock_end_of_period = ReportBookkeeping::displayArchiveDownloadLinkAsHTML($bkdata['archive_stock_end_of_period'], $archive_icon);
$archive_icon_stock_incoming_end_of_period = ReportBookkeeping::displayArchiveDownloadLinkAsHTML($bkdata['archive_stock_incoming_end_of_period'], $archive_icon);
} else {
