| Date |
Amount |
query("payments", "SELECT * FROM payments WHERE invoice_id = {$_GET['invoice_id']}");
$payments_total = 0;
if ($payment_history_res->num_rows > 0) {
while ($payment_his = $payment_history_res->fetch_assoc()) {
echo "";
echo "| {$payment_his['date_time']} | ";
echo "R " . number_format($payment_his['amount'],2) . " | ";
echo "
";
$payments_total += $payment_his['amount'];
}
echo "";
echo "| PAYMENTS TOTAL | ";
echo "R " . number_format($payments_total, 2) . " | ";
echo "
";
$invoice_details_res = $db->query("invoice_list", "SELECT * FROM invoice_list WHERE invoice_id = {$_GET['invoice_id']}");
$invoice_total = 0;
if ($invoice_details_res->num_rows > 0) {
while ($invoice_list = $invoice_details_res->fetch_assoc()) {
$invoice_total += (float) $invoice_list['price'] * (float) $invoice_list['qty'] * 1.15;
}
}
echo "";
echo "| INVOICE TOTAL | ";
echo "R " . number_format($invoice_total, 2) . " | ";
echo "
";
echo "";
echo "| NETT | ";
echo "R " . number_format($invoice_total - $payments_total, 2) . " | ";
echo "
";
} else {
?>
| NO PAYMENTS YET |
query("invoice_list", "SELECT * FROM invoice_list WHERE invoice_id = {$_GET['invoice_id']}");
$invoice_total = 0;
if ($invoice_details_res->num_rows > 0) {
while ($invoice_list = $invoice_details_res->fetch_assoc()) {
$invoice_total += (float) $invoice_list['price'] * (float) $invoice_list['qty'] * 1.15;
}
}
echo "";
echo "| INVOICE TOTAL | ";
echo "R " . number_format($invoice_total, 2) . " | ";
echo "
";
echo "";
echo "| NETT | ";
echo "R " . number_format($invoice_total - $payments_total, 2) . " | ";
echo "
";
}
?>