<?php include('./constant/layout/head.php');?>
<!-- Author Name: Mayuri K.
for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com
Visit website : www.mayurik.com -->
<?php
include('./constant/connect.php');?>
<div class="">
<div class="container-fluid" style="background-color: #ffffff;">
<?php
$productSql = "SELECT * FROM orders WHERE order_id = '".$_GET['id']."'";
$productData = $connect->query($productSql);
$row = $productData->fetch_array();
$productSql1 = "SELECT * FROM users WHERE user_id= '".$row['user_id']."'";
$productData1 = $connect->query($productSql1);
$row1 = $productData1->fetch_array();
$sql1 = "SELECT * FROM tbl_client
WHERE id = '".$row['client_name']."'";
$result1 = $connect->query($sql1);
$data1 = $result1->fetch_assoc();
?>
<div class="row">
<div class="col-lg-12" >
<div class="card">
<div class="card-title">
<div class="float-left">
<h2 class="mb-0" style="color: black;">Invoice #<?php echo$row['order_id']; ?></h2>
</div>
<div class="float-right">
Date: <?php echo$row['order_date']; ?></div>
</div>
<hr>
<div class="card-body">
<div class="row mb-4">
<div class="col-sm-4 mt-4">
<?php
$que="select * from manage_website";
$query=$connect->query($que);
$web=mysqli_fetch_array($query);
?>
<br>
<image class="profile-img" src="./assets/uploadImage/Logo/<?=$web['invoice_logo']?>" style="height:120px;width:auto;">
</div>
<div class="col-sm-4">
<br>
<h5 class="mb-3" style="color: black;">From:</h5>
<h3 class="text-dark mb-1">ORANGE STATION</h3>
<div><?php echo $web['currency_code']; ?></div>
<!-- <div><?=$result['address']?></div>
--> <div>Email: <?=$row1['email']?></div>
<div>Contact: <?php echo $web['short_title']; ?></div>
</div>
<div class="col-sm-4">
<br>
<h5 class="mb-3" style="color: black;">To:</h5>
<h3 class="text-dark mb-1"><?= $data1['name']; ?></h3>
<div><?= $data1['address']; ?></div>
<div>Phone: <?= $data1['mob_no']; ?></div>
</div>
</div>
<div class="table-responsive-sm">
<table class="table table-striped">
<thead>
<tr>
<th class="center">#</th>
<th>Product</th>
<th class="right">Unit Cost</th>
<th class="center">Qty</th>
<th class="right">Total</th>
</tr>
</thead>
<tbody>
<?php
$productSql11 = "SELECT * FROM order_item WHERE order_id = '".$_GET['id']."'";
$productData11 = $connect->query($productSql11);
while($row11 = $productData11->fetch_array()){
$productSql2 = "SELECT * FROM product WHERE product_id='".$row11['product_id']."'";
$productData2 = $connect->query($productSql2);
$row2 = $productData2->fetch_array();
$no +=1;
?>
<tr>
<td class="center"><?=$no?></td>
<td class="left strong"><?=$row2['product_name']?></td>
<td class="right"><?=$row11['rate']?></td>
<td class="center"><?=$row11['quantity']?></td>
<td class="right"><?=$row11['total']?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
<div class="row">
<div class="col-lg-4 col-sm-5">
<img style="height: 250px; padding-left: 316px;" src="https://thumbs.dreamstime.com/b/grunge-blue-signature-word-round-rubber-seal-stamp-white-background-171945013.jpg" >
</div>
<div class="col-lg-4 col-sm-5 ml-auto">
<table class="table table-clear">
<tbody>
<tr>
<td class="left">
<strong class="text-dark">Subtotal</strong>
</td>
<td class="right"><?=$row['sub_total']?></td>
</tr>
<tr>
<td class="left">
<strong class="text-dark">Discount (<?=$row['discount']?>%)</strong>
</td>
<td class="right"><?php
echo $discount=$row['sub_total']*($row['discount']/100);
?></td>
</tr>
<tr>
<td class="left">
<strong class="text-dark">GST (<?=$row['gst_rate']?>%)</strong>
</td>
<td class="right"><?php
$gst_rate=($row['sub_total']-$discount)*($row['gstn']/100);
echo number_format($gst_rate,2);
?></td>
</tr>
<tr>
<td class="left">
<strong class="text-dark">Total</strong>
</td>
<td class="right">
<strong class="text-dark"><?=$row['grand_total']?></strong>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<div class="card-footer bg-white">
<img style="height: 150px;" src="https://upload.wikimedia.org/wikipedia/commons/2/25/Ivory_Signature.png" >
<p class="mb-0">Thank you for your business !</p>
</div>
<br><br><br><br>
<p style="text-align:right;">Software Developed by Mayuri K. - www.mayurik.com</p>
</div>
<input id ="printbtn" type="button" class="btn btn-success btn-flat m-b-30 m-t-30" value="Print Invoice" onclick="window.print();" >
<input id ="printbtn" type="button" value="Go Back" class="btn btn-danger btn-flat m-b-30 m-t-30" onclick="goBack()" >
</div>
</div>
</div>
</div>
<!-- Author Name: Mayuri K.
for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com
Visit website : www.mayurik.com -->
<?php include('./constant/layout/footer.php');?>
<script>
function goBack() {
window.history.back();
}
</script>