add_styles_page(); $db = new db_safeguard(); $invoices_res = $db->query("invoices", "SELECT * FROM invoices ORDER BY date_time DESC"); $table_data = ""; if ($invoices_res->num_rows > 0) { while ($invoice = $invoices_res->fetch_assoc()) { /* Calculate invoice total from items */ $total_res = $db->query("invoice_items", "SELECT SUM(total) as grand_total FROM invoice_items WHERE invoice_no = '{$invoice['invoice_no']}'" ); $total_row = $total_res->fetch_assoc(); $grand_total = number_format((float)($total_row['grand_total'] ?? 0), 2); $status_class = $invoice['status'] === 'PAID' ? 'badge-paid' : 'badge-unpaid'; $table_data .= " {$invoice['invoice_no']} {$invoice['client_name']} {$invoice['invoice_date']} {$invoice['due_date']} R {$grand_total} {$invoice['status']} "; } } else { $table_data = "NO INVOICES FOUND"; } ?>

Invoice No	Client	Invoice Date	Due Date	Total	Status