<?php
require_once 'core.php';
$orderId = $_POST['orderId'];
$sql = "SELECT order_date, client_name, client_contact, sub_total, vat, total_amount, discount, grand_total, paid, due, payment_place,gstn FROM orders WHERE order_id = $orderId";
$orderResult = $connect->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 = '<style>
.star img {
visibility: visible;
}</style>
<table align="center" cellpadding="0" cellspacing="0" style="width: 100%;border:1px solid black;margin-bottom: 10px;">
<tbody>
<tr>
<td colspan="5" style="text-align:center;color: red;text-decoration: underline; font-size: 25px;">TAX INVOICE</td>
</tr>
<tr>
<td rowspan="8" colspan="2" style="border-left:1px solid black;" background-image="logo.jpg"><img src="/logo.jpg" alt="logo" width="250px;"></td>
<td colspan="3" style=" text-align: right;">ORIGINAL</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;">DUPLICATE</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;color: red;font-style: italic;font-weight: 600;text-decoration: underline;font-size: 25px;">IMS</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;">Nr. Your First Address,</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;">Cityname,Pincode</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;">Tele: 1234567890,1478523690.</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;">Email: email0@email.co.in</td>
</tr>
<tr>
<td colspan="3" style=" text-align: right;color: blue;text-decoration: underline;">email0@email.co.in</td>
</tr>
<tr>
<td colspan="2" style="padding: 0px;vertical-align: top;border-right:1px solid black;">
<table align="left" cellpadding="0" cellspacing="0" style="border: thin solid black; width: 100%">
<tbody>
<tr>
<td style="width: 74px;vertical-align: top;color: red;" rowspan="3">TO, </td>
<td style="border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: red"> '.$clientName.'</td>
</tr>
<tr>
<td style="border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: black"> </td>
</tr>
<tr>
<td style="border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: black"> </td>
</tr>
</tbody>
</table>
<table align="left" cellspacing="0" style="width: 100%; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-right-width: thin; border-bottom-width: thin; border-left-width: thin; border-right-color: black; border-bottom-color: black; border-left-color: black;">
<tbody>
<tr>
<td style=" border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: red;color: red;">G.S.T.IN :'.$gstn.'</td>
<td style="border-left-style: solid; border-left-width: thin; border-left-color: black; border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: red;color: red;">Mobile No: '.$clientContact.'</td>
</tr>
</tbody>
</table>
</td>
<td style="padding: 0px;vertical-align: top;" colspan="3">
<table align="left" cellpadding="0" cellspacing="0" style="width: 100%">
<tbody>
<tr>
<td style="border-bottom-style: solid;border-bottom-width: thin;border-bottom-color: black;border-top: 1px solid black;border-right: 1px solid black;color: red;">Bill No : .</td>
</tr>
<tr>
<td style="border-bottom-style: solid;border-bottom-width: thin;border-bottom-color: black;border-right: 1px solid black; color: red;">Date: '.$orderDate.'</td>
</tr>
<tr>
<td style="border-bottom-style: solid;border-bottom-width: thin;border-bottom-color: black;height: 52px;border-right: 1px solid black; color: red;">G.S.T.IN: lorem ipsum</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="width: 123px;text-align: center;background-color: black;color: white;border-right: 1px solid white;border-left: 1px solid black;border-bottom: 1px solid black;-webkit-print-color-adjust: exact;">D.C.NO<br>
&DATE
</td>
<td style="width: 50%;text-align: center;border-top-style: solid;border-right-style: solid;border-bottom-style: solid;border-top-width: thin;border-right-width: thin;border-bottom-width: thin;border-top-color: black;border-right-color: white;border-bottom-color: black;color: white;background-color: black;-webkit-print-color-adjust: exact;">Description Of Goods</td>
<td style="width: 150px;text-align: center;border-top-style: solid;border-right-style: solid;border-bottom-style: solid;border-top-width: thin;border-right-width: thin;border-bottom-width: thin;border-top-color: black;border-right-color: #fff;border-bottom-color: black;background-color: black;color: white;-webkit-print-color-adjust: exact;">Qty.</td>
<td style="width: 150px;text-align: center;border-top-style: solid;border-right-style: solid;border-bottom-style: solid;border-top-width: thin;border-right-width: thin;border-bottom-width: thin;border-top-color: black;border-right-color: #fff;border-bottom-color: black;background-color: black;color: white;-webkit-print-color-adjust: exact;">Rate Rs.<br>
Ps
</td>
<td style="width: 150px;text-align: center;border-top-style: solid;border-right-style: solid;border-bottom-style: solid;border-top-width: thin;border-right-width: thin;border-bottom-width: thin;border-top-color: black;border-right-color: black;border-bottom-color: black;color: white;background-color: black;-webkit-print-color-adjust: exact;">Amount Rs.<br>
Ps
</td>
</tr>';
$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 .= '<tr>
<td style="border-left: 1px solid black;border-right: 1px solid black;height: 27px;">'.$x.'</td>
<td style="border-left: 1px solid black;height: 27px;">'.$row[4].'</td>
<td style="border-left: 1px solid black;height: 27px;">'.$row[2].'</td>
<td style="border-left: 1px solid black;height: 27px;">'.$row[1].'</td>
<td style="border-left: 1px solid black;border-right: 1px solid black;height: 27px;">'.$row[3].'</td>
</tr>
';
$x++;
} // /while
$table.= '
<tr style="border-bottom: 1px solid black;">
<td style="border-left: 1px solid black;border-right: 1px solid black;height: 27px;"></td>
<td style="border-left: 1px solid black;height: 27px;"></td>
<td style="border-left: 1px solid black;height: 27px;"></td>
<td style="width: 149px;border-right-style: solid;border-bottom-style: solid;border-right-width: thin;border-bottom-width: thin;border-right-color: black;border-bottom-color: #000;background-color: black;color: white;padding-left: 5px;-webkit-print-color-adjust: exact;">Total</td>
<td style="width: 218px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-top-width: thin; border-right-width: thin; border-bottom-width: thin; border-top-color: black; border-right-color: black; border-bottom-color: black;">'.$subTotal.'</td>
</tr>
<tr>
<td colspan="3" style="border-top: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;padding: 5px;">Neft For:- Bank Name</td>
<td rowspan="2" style="border-bottom: 1px solid black;width: 199px;color: white;background-color: black;padding-left: 5px;-webkit-print-color-adjust: exact;">S.G.S.T. 9%</td>
<td rowspan="2" style="border-bottom: 1px solid black;width: 288px;border-right: 1px solid black;">'.$cgst.'</td>
</tr>
<tr>
<td colspan="3" style="border-bottom: 1px solid black;width: 859px;border-left: 1px solid black;padding: 5px;">Branch:- branch Address</td>
</tr>
<tr>
<td colspan="3" style="border-bottom: 1px solid black;border-left: 1px solid black;padding: 5px;">Bank IFSC CODE:- 9423979339</td>
<td rowspan="2" style="border-bottom: 1px solid black;width: 149px;background-color: black;color: white;padding-left: 5px;-webkit-print-color-adjust: exact;">C.G.S.T. 9%</td>
<td rowspan="2" style="width:218px;border-bottom: 1px solid black;border-right: 1px solid black;">'.$cgst.'
</td>
</tr>
<tr>
<td colspan="3" style="border-bottom: 1px solid black;border-left: 1px solid black;padding: 5px;">AC. HO. Name:- Comapany Name</td>
</tr>
<tr>
<td colspan="3" style="border-bottom: 1px solid black;border-left: 1px solid black;padding: 5px;">AC.NO. :- lorem ipsum</td>
<td style="border-bottom: 1px solid black;background-color: black;color: white;padding: 5px;-webkit-print-color-adjust: exact;">I.G.S.T. 18%</td>
<td style="border-bottom: 1px solid black;border-right: 1px solid black;">'.$igst.'</td>
</tr>
<tr>
<td colspan="3" style="border-left: 1px solid black;border-bottom: 1px solid black;color: red;padding: 5px;">Amount in words</td>
<td style="border-bottom: 1px solid #fff;background-color: black;color: white;padding: 5px;-webkit-print-color-adjust: exact;">G. Total</td>
<td style="border-bottom: 1px solid black;border-right: 1px solid;">'.$total.'</td>
</tr>
<tr>
<td colspan="3" style="border-left: 1px solid black;border-bottom: 1px solid black;padding: 5px;border-right: 1px solid black;">* Subject to lorem ipsum <span style="float: right;"> E.&.O.E.</span></td>
<td rowspan="2" colspan="2" style="vertical-align: bottom;padding: 5px;color: red;border-right: 1px solid black;text-align: center;">for, Company Name</td>
</tr>
<tr>
<td colspan="3" style="border-left: 1px solid black;padding-left: 5px;border-right: 1px solid black;">
* Intrest will be charged upon all acounts
<p style="margin: 0px;">remaning unpaid after due date</p>
</td>
</tr>
</tbody>
</table>';
$connect->close();
echo $table;