add_styles_page(); $db = new db_safeguard(); $record_id = (int) ($_GET['record_id'] ?? 0); $inv_res = $db->query("invoices", "SELECT * FROM invoices WHERE record_id = $record_id"); $invoice = $inv_res->fetch_assoc(); if (!$invoice) { echo ""; exit; } $items_res = $db->query("invoice_items", "SELECT * FROM invoice_items WHERE invoice_no = '{$invoice['invoice_no']}'" ); $items = []; while ($item = $items_res->fetch_assoc()) { $items[] = $item; } if (empty($items)) { $items[] = ['description' => '', 'quantity' => 1, 'unit_price' => 0, 'total' => 0]; } /* Fetch stock items for datalist */ $stock_res = $db->query("stock", "SELECT item_name, item_price FROM stock ORDER BY item_name ASC"); $stock_items = []; $datalist_options = ""; while ($stock = $stock_res->fetch_assoc()) { $name = htmlspecialchars($stock['item_name'], ENT_QUOTES); $price = (float) ($stock['item_price'] ?? 0); $stock_items[] = ['name' => $name, 'price' => $price]; $datalist_options .= "