Tiny File Manager | print.php

Back Back Up Advanced Editor

<?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: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>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>

</div>
                        </div>
                    </div>
                  
                </div>

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