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 = ' '; $x = 1; $cgst = 0; $igst = 0; if($payment_place == 2) { $igst = $subTotal*18/100; } else { $cgst = $subTotal*9/100; } $total = $subTotal+2*$cgst+$igst; while($row = $orderItemResult->fetch_array()) { $table .= ' '; $x++; } // /while $table.= '
TAX INVOICE
logo ORIGINAL
DUPLICATE
IMS
Nr. Your First Address,
Cityname,Pincode
Tele: 1234567890,1478523690.
Email: email0@email.co.in
email0@email.co.in
TO,  '.$clientName.'
 
 
G.S.T.IN :'.$gstn.' Mobile No: '.$clientContact.'
Bill No : .
Date: '.$orderDate.'
G.S.T.IN: lorem ipsum
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

'; $connect->close(); echo $table;