<?php include('./constant/layout/head.php');?>
<?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:100px;width:auto;">
                                                
                                        </div>
                                        <div class="col-sm-4">
                                            <br>
                                            <h5 class="mb-3" style="color: black;">From:</h5>                                            
                                            <h3 class="text-dark mb-1"><?=$row1['username'];?></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>Canal Winchester, OH 43110</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>Test Name</th>
                                                    <th class="right">Rate</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-8 col-sm-5 p-2 ">
                                            <img src="https://www.ijournalhs.org/articles/2019/12/2/images/indianjhealthsci_2019_12_2_174_259633_t2.jpg" width="500px">
                                            <img src="assets/myimages/stamp.png" width="200px" class="ml-3">
                                        </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">
                                    <p class="mb-0">Thank you for your business !</p>
                                </div>
                        </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>
                
               


<?php include('./constant/layout/footer.php');?>
 <script>
function goBack() {
  window.history.back();
}
</script>

