query($sql); $orderData = $orderResult->fetch_array(); $orderDate = $orderData[0]; $clientName = $orderData[1]; $clientContact = $orderData[2]; $subTotal = $orderData[3]; $vat = $orderData[4]; $totalAmount = $orderData[5]; $discount = $orderData[6]; $grandTotal = $orderData[7]; $paid = $orderData[8]; $due = $orderData[9]; $payment_place = $orderData[10]; $gstn = $orderData[11]; $orderItemSql = "SELECT order_item.product_id, order_item.rate, order_item.quantity, order_item.total, product.product_name FROM order_item INNER JOIN product ON order_item.product_id = product.product_id WHERE order_item.order_id = $orderId"; $orderItemResult = $connect->query($orderItemSql); $table = '
| TAX INVOICE | |||||||||||||
![]() |
ORIGINAL | ||||||||||||
| DUPLICATE | |||||||||||||
| IMS | |||||||||||||
| Nr. Your First Address, | |||||||||||||
| Cityname,Pincode | |||||||||||||
| Tele: 1234567890,1478523690. | |||||||||||||
| Email: email0@email.co.in | |||||||||||||
| email0@email.co.in | |||||||||||||
|
|
||||||||||||
| D.C.NO &DATE |
Description Of Goods | Qty. | Rate Rs. Ps |
Amount Rs. Ps |
|||||||||
| '.$x.' | '.$row[4].' | '.$row[2].' | '.$row[1].' | '.$row[3].' | |||||||||
| Total | '.$subTotal.' | ||||||||||||
| Neft For:- Bank Name | S.G.S.T. 9% | '.$cgst.' | |||||||||||
| Branch:- branch Address | |||||||||||||
| Bank IFSC CODE:- 78945612301 | C.G.S.T. 9% | '.$cgst.' | |||||||||||
| AC. HO. Name:- Comapany Name | |||||||||||||
| AC.NO. :- lorem ipsum | I.G.S.T. 18% | '.$igst.' | |||||||||||
| Amount in words | G. Total | '.$total.' | |||||||||||
| * Subject to lorem ipsum E.&.O.E. | for, Company Name | ||||||||||||
|
* Intrest will be charged upon all acounts
remaning unpaid after due date |
|||||||||||||