prepare($sql); $stmt->bind_param("i", $invoiceId); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows === 0) { die("Invoice not found"); } $invoice = $result->fetch_assoc(); // // Get invoice items // $sql = "SELECT * FROM invoice_items WHERE invoice_id = ? ORDER BY id ASC"; // $stmt = $conn->prepare($sql); // $stmt->bind_param("i", $invoiceId); // $stmt->execute(); // $itemsResult = $stmt->get_result(); // $items = []; // while ($row = $itemsResult->fetch_assoc()) { // $items[] = $row; // } ?>
Pincode - Mob: |
Invoice No: |
Dated: |
|||
Delivery Note: N/A |
Terms of Payment: As Per Work Order |
||||
Consignee (Ship to): |
Buyer's Order No: |
Order Dated: |
|||
Vehicle No: |
Dispatch Vehicle Date: |
||||
Buyer (Bill to): |
|||||
Dispatched through: ROAD TRANSPORT |
Destination: |
Description of Goods | HSN | Quantity Shipped | Quantity Billed | Rate | Per | Amount (₹) |
---|---|---|---|---|---|---|
KG | ₹ | |||||
CGST (9%) | ₹= !empty($invoice['cgst']) ? $invoice['cgst'] : '0'; ?> | |||||
SGST (9%) | ₹= !empty($invoice['sgst']) ? $invoice['sgst'] : '0'; ?> | |||||
IGST (18%) | ₹= !empty($invoice['igst']) ? $invoice['igst'] : '0'; ?> | |||||
TOTAL | ₹= $invoice['finalAmount']; ?> |
Amount Chargeable (in words):
Only
Declaration:
We declare that this invoice shows the actual price of the goods described and that all particulars are true and correct.