$row16_open_amount_prev_2 = array('Open Amount (invoices from previous month 2)');
$row17_blank_line = array('');
$row18_returns_same_period = array('Total Returns Amount from same period');
$row19_returns_previous_period = array('Total Returns Amount from previous period');
$row20_blank_line = array('');
$row21_confirmed_payment_prev = array('Confirmed Payment from Previous Month');
$row22_sent_to_atriga = array('Total Invoice Amount sent to Atriga');
$row23_total_after_returns = array('Total Invoice Amount after Returns');
for ($m = 1; $m <= 12; $m++) {
$period_prev = $m == 1 ? $period_lastyear : $period;
$period = $year . str_pad($m, 2, '0', STR_PAD_LEFT);
if (is_array($bkdata[$period])) {
$period_text = date('F Y', strtotime(substr($period, 0, 4) . '-' . substr($period, 4, 2) . '-01'));
$open_amount = ReportBookkeeping::calculateOpenAmount($bkdata[$period_prev]['open_amount'], $bkdata[$period]['manual_input_paid_amount'], $bkdata[$period]['manual_input_refund_amount'], $bkdata[$period]['invoice_amount'], $bkdata[$period]['returns_amount']);
$sent_to_atriga = ReportBookkeeping::getTotalAtriga($period);
$total_after_returns = ReportBookkeeping::getTotalAfterReturns($period);
$open_amount_diff = $open_amount - $bkdata[$period]['open_amount'];
$row1_period[] = $period_text;
$row2_blank_line[] = '';
$row3_previous_open_amount[] = $bkdata[$period_prev]['open_amount'];
$row4_incoming_amount_real[] = $bkdata[$period]['manual_input_paid_amount'];
$row5_outgoing_amount_real[] = $bkdata[$period]['manual_input_refund_amount'];
$row6_total_invoice_amount[] = $bkdata[$period]['invoice_amount'];
$row7_total_returns_amount[] = $bkdata[$period]['returns_amount'];
$row8_blank_line[] = '';
$row9_calculated_open_amount[] = $open_amount;
$row10_open_amount[] = $bkdata[$period]['open_amount'];
$row11_blank_line[] = '';
$row12_open_amount_diff[] = $open_amount_diff;
$row13_blank_line[] = '';
$row14_open_amount_prev_0[] = $bkdata[$period]['open_amount_prev_0'];
}
echo '<tr>';
foreach ($row as $cn => $cv) {
echo '<td>' . $cv . '</td>';
}
echo '</tr>';
}
}
if ($display_table) {
echo '</table>';
}
$result = array();
$result['invoice_qty_queried'] = $invoice_qty_queried;
$result['invoice_qty_in_period'] = $invoice_qty_in_period;
$result['invoice_amount_in_period'] = $invoice_amount_in_period;
return $result;
}
}
$year = isset($_GET['y']) && $_GET['y'] != '' ? tep_db_prepare_input($_GET['y']) : date('Y');
$periods = array();
for ($m = 1; $m <= 12; $m++) {
$periods[] = $year . str_pad($m, 2, '0', STR_PAD_LEFT);
}
echo '<h1>Total Invoice after Returns (OTTO only)</h1>';
foreach ($periods as $p) {
$after_returns = ReportBookkeeping::getTotalAfterReturns($p);
echo '<h3>';
echo 'Period ' . $p . ': ' . displayCurrency('EUR', $after_returns['invoice_amount_in_period']);
echo '</h3>';
}
tep_db_close();
