* @author IT TEAM BONOFACTUM
* @created Mar 17, 2014 6:09:14 PM
*/
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('ReportBookkeeping');
$year = tep_db_prepare_input($_GET['year']);
$period_lastyear = $year - 1 . '12';
$bkdata = array();
$bkdata[$period_lastyear] = ReportBookkeeping::retrieveDetail($period_lastyear);
for ($m = 1; $m <= 12; $m++) {
$period = $year . str_pad($m, 2, '0', STR_PAD_LEFT);
$bkdata[$period] = ReportBookkeeping::retrieveDetail($period);
}
$row1_period = array('Period');
$row2_blank_line = array('');
$row3_previous_open_amount = array('Previous Open Amount');
$row4_incoming_amount_real = array('Incoming Amount (real)');
$row5_outgoing_amount_real = array('Outgoing Amount (real)');
$row6_total_invoice_amount = array('Total Invoice Amount');
$row7_total_returns_amount = array('Total Returns Amount');
$row8_blank_line = array('');
$row9_calculated_open_amount = array('Calculated Open Amount');
$row10_open_amount = array('Open Amount');
$row11_blank_line = array('');
$row12_open_amount_diff = array('Open Amount Difference');
$row13_blank_line = array('');
$row14_open_amount_prev_0 = array('Open Amount (invoices from same period)');
$ajaxResult = array();
$ajaxResult['period'] = $period;
$ajaxResult['paid_amount'] = $bkdata['manual_input_paid_amount'];
$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);
