$row15_open_amount_prev_1 = array('Open Amount (invoices from previous month)'); $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[] = '';