pageHeading("PROFIT/LOSS REPORT");
$debit_accounts_res = $db->exec_query('accounts', ['*'], '', '', '', '', "account_type_id = 1");
$expence_acc_data = '';
$expence_total = 0;
while ($debit_account = $debit_accounts_res->fetch_assoc()) {
$a = $db->exec_query('expenses', ['*'], '', '', '', '', "accounts_id = {$debit_account['record_id']}");
$sub_total = 0;
while ($amounts = $a->fetch_assoc()) {
$sub_total = $sub_total + $amounts['amount'];
}
$expence_total = $expence_total + $sub_total;
$expence_acc_data = $expence_acc_data . "| ".strtoupper($debit_account['accounts_name'])." | ".number_format($sub_total,2,'.',',')." |
";
}
$income_total = 0;
$credit_accounts_res = $db->exec_query('accounts', ['*'], '', '', '', '', "account_type_id = 2");
$income_acc_data = '';
while ($credit_account = $credit_accounts_res->fetch_assoc()) {
$a = $db->exec_query('income', ['*'], '', '', '', '', "accounts_id = {$credit_account['record_id']}");
$sub_total = 0;
while ($amounts = $a->fetch_assoc()) {
$sub_total = $sub_total + $amounts['amount'];
}
$income_total = $income_total + $sub_total;
$income_acc_data = $income_acc_data . "| ".strtoupper($credit_account['accounts_name'])." | | ".number_format($sub_total,2,'.',',')." |
";
}
$html = "
| ACCOUNTS | DEBIT (EXPENSES) | CREDIT (INCOME) |
|---|
$expence_acc_data
$income_acc_data
| TOTAL | $expence_total | $income_total |
| NET | R ".number_format(($income_total - $expence_total),2,'.',',')." |
";
$pdf->inject_html($html);
$pdf->report_on_table('expenses', [], ['amount']);
$pdf->report_on_table('income', [], ['amount']);