exec_query('invoices', ['*'], '', '', '', '', '1', "ORDER BY record_id DESC");
$invoice_info_no = $invoice_res_no->fetch_assoc();
$invoice_no = $invoice_info_no['invoice_no'] + 1;
// Client dropdown options + map of id->details for PDF
$client_res = $db->exec_query('clients', ['*']);
$options_client = '';
$clients_map = [];
while ($client = $client_res->fetch_assoc()) {
$options_client .= "";
$clients_map[$client['record_id']] = [
'name' => $client['clients_name'],
'email' => $client['email'],
'phone' => $client['cell'],
'address' => $client['address'],
];
}
// Quote dropdown
$quote_res = $db->exec_query('quotes', ['*']);
$quoto_nos = '';
while ($q = $quote_res->fetch_assoc()) {
$quoto_nos .= "";
}
// Company details — embedded for use in client-side PDF
$company_res = $db->exec_query('company', ['*']);
$company_info = $company_res->fetch_assoc();
$WebApp->pageHeading("NEW INVOICE");
?>