query("invoice_list", "
SELECT il.size_m, il.pannels, s.code, s.name AS stock_name
FROM invoice_list il
JOIN stock s ON s.record_id = il.stock_id
WHERE il.invoice_id = '$invoice_id'
");
$rows = [];
while ($row = $res->fetch_assoc()) {
$rows[] = $row;
}
header('Content-Type: application/json');
echo json_encode($rows);
exit;
}
$html = new html("EDIT DELIVERY NOTE");
$app = new inner_app();
$app->quick_bar("/app/delivery_note/");
$app->app_start();
// ── Fetch existing delivery note ──────────────────────────────────────────────
$record_id = (int) ($_GET['record_id'] ?? 0);
$dn = $db->query("delivery_note", "SELECT * FROM delivery_note WHERE record_id = '$record_id'")->fetch_assoc();
// ── Fetch existing line items ─────────────────────────────────────────────────
$existing_items = [];
if ($dn) {
$list_res = $db->query("delivery_note_list", "SELECT * FROM delivery_note_list WHERE delivery_note_id = '$record_id'");
while ($row = $list_res->fetch_assoc()) {
$existing_items[] = $row;
}
}
// ── Fetch invoice number for display ─────────────────────────────────────────
$invoice_number = '';
if ($dn) {
$inv = $db->query("invoices", "SELECT invoice_number FROM invoices WHERE record_id = '{$dn['quote_id']}'")->fetch_assoc();
$invoice_number = $inv['invoice_number'] ?? '';
}
$function->get_invoices_list_as_record_id('invoice_list');
?>
EDIT DELIVERY NOTE
| Code |
Description |
Size (m) |
Panels |
|
| Loading... |