//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); ReportBookkeeping::add($period, $invoice_quantity, $invoice_amount, $receipts, $receipts_late_from_prev_month, $returns, $returns_same_period, $open_amount, $open_amount_prev0, $open_amount_prev1, $open_amount_prev2, $stock_total_qty, $stock_total_value, $stock_incoming_qty, $stock_incoming_value); } $logger->close(); echo 'Done!'; tep_db_close();
$ajaxResult['paid_amount_formatted'] = displayCurrency('EUR', $bkdata['manual_input_paid_amount'], false); $ajaxResult['refund_amount'] = $bkdata['manual_input_refund_amount']; $ajaxResult['refund_amount_formatted'] = displayCurrency('EUR', $bkdata['manual_input_refund_amount'], false); ajaxReturn($ajaxResult); } else { if ($_POST['me_action'] == 'LOADPERIOD') { $period = $_POST['period']; $period_year = substr($period, 0, 4); $period_month = intval(substr($period, -2)); $period_prev_month = $period_month - 1; $period_prev = $period_prev_month <= 0 ? $period_year - 1 . '12' : $period_year . str_pad($period_prev_month, 2, '0', STR_PAD_LEFT); $bkdata = ReportBookkeeping::retrieveDetail($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);