<?php include'loginQuery/session_start.php';
include'dbc.php'; ?>
<style>
  .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th {
    padding: 8px;
    line-height: 1.42857143;
    vertical-align: top;
    border-top: 1px solid #ddd;
    font-size: 13px;
}
@media print {
  .top {
   background: #286090 !important;
   padding: 8px !important; 
  }
}

@media print {
  .whitetop {
   color: white !important;
  }
}

@media print {
  
  #orderdetails {
  background-color: #f9f9f9 !important;
}
}
</style>
 
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">




<?php
 date_default_timezone_set("Asia/Kolkata");
$dt= date('d/m/Y', time());
$tempinvoiceid=$_GET['tempinvoiceid'];
$q1=mysqli_query($conn,"select * from tbl_invoice where temp_invoiceid='$tempinvoiceid'");
$pl=mysqli_fetch_array($q1);

$q2=mysqli_query($conn,"select * from tbl_invoice_product where invoice_id='$tempinvoiceid'");
$p2=mysqli_fetch_array($q2);
?>
 <?php
                       $i=1;
                       $saving=0;
                       $price=0;
                       $tempinvoiceid=$_GET['tempinvoiceid'];
                       $sql=mysqli_query($conn,"select *from tbl_invoice_product where invoice_id='$tempinvoiceid'")or die(mysqli_error());
                while($data=mysqli_fetch_assoc($sql))
                {
              
                    extract($data);
                    $saving+=$mrp;
                    $price1=$unit_price*$qty;
                    $price+=$price1;
                    $totalsaving=$saving-$price;
                   } 
                           if($price>399){
                              $shipping =0;
                            }else if($price<399 && $price>1 ){
                              $shipping =29; //29
                            }else {
                              $shipping =0;
                            }    
                ?>

<div class="container-fluid" style="padding:30px 30px 0px 20px;">
<div class="row">
  <div class="top" style="background: #286090;padding: 8px">
<h4 style="color: white"><strong class="whitetop">TAX INVOICE &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<span style="float: right;" class="whitetop">ORDER ID : <?php echo $pl['invoice_number']; ?>&nbsp&nbsp ₹ <?php echo $price+$shipping; ?></span></strong></h4>
</div>

    <div style="width:50%;float:left;">
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../img/kiranajee.png" style="height: 126px !important;margin-top: 7px;background-color: #105A81 !important;padding: 21px;border-radius: 8px;">
    </div>
    <div style="width:50%;float:right;text-align:right;padding-right: 20px;">
        <h3 style="font-weight: 600;"><small><b>Futuristic</b></small><br> KIRANAJEE<br> <small><b>optimum e-commerce llp</b></small></h3>
          Agra, Uttar Pradesh<br>
        Email : support@kiranajee.com<br>
        Contact : (+91) 9383240640<br>
        GST No  : 09AAHFF2102M1ZI<br>
    </div>
    </div><hr>
    <div class="row">
    <div style="width:50%;float:left;padding-left:20px;">
        <h3 style="font-weight: 600;">Shipping Details</h3>
        <b>Name :</b> <?php echo $pl['name']; ?><br>
        <b>Address :</b> <?php echo $pl['address']; ?><br>
        <b>Email : </b> <?php echo $pl['email']; ?><br>
        <b>Moible :</b> <?php echo $pl['mobile']; ?><br>
    </div>
    <div style="width:50%;float:right;text-align:right;padding-top: 55px;">
        <b>Invoice Number : </b> <?php echo $pl['invoice_number']; ?><br>
        <b> Order Date : </b> <?php  
                            $date = DateTime::createFromFormat("Y-m-d" ,$pl['order_date']);
                            echo $date->format('d-m-Y');
                        ?><br>
        <b> Payment Method :</b> <?php echo $pl['payment_method']; ?>
    </div>
    </div>
    
    <div>
    <div class="row" style="margin-top:30px;padding:20px;" id="orderdetails" >
         <table class="table table-striped"  >
                    <tr >
                      <th colspan="10" >
                        <center>
                          <h3><strong >Order Detail</strong></h3>
                        </center>
                      </th>
                    </tr>
                    <tr>
                      <th>Sr.No.</th>
                      <th colspan="5">Product</th>
                      <th>Unit</th>
                      <th>Price</th>
                      <th>Qty</th>
                      <th >Total</th>
                    </tr>
              
                    <?php
                       $i=1;
                       $tempinvoiceid=$_GET['tempinvoiceid'];
                       $sql=mysqli_query($conn,"select *from tbl_invoice_product where invoice_id='$tempinvoiceid'")or die(mysqli_error());
                while($data=mysqli_fetch_assoc($sql))
                {
              
                    extract($data);
                
                ?>
                    <tr>
                      <td><?php echo $i++; ?></td>
                     <td colspan="5"><?php echo $product_name; ?></td>
                      <td><?php echo $size; ?></td>
                      <td>₹ <?php echo $unit_price; ?></td>
                      <td><?php echo $qty; ?></td>
                      <td >₹ <?php echo $qty *$unit_price;?></td>
              
                      
                    </tr>
                    <?php
                      }
                    ?>
              <tr>
                      <th colspan="9">Payment Method</th>
                      <th><?php echo $pl['payment_method']; ?></th>
                    </tr>
                    <tr>
                      <th colspan="9">Sub Total</th>
                      <th>₹ <?php echo $price; ?></th>
                    </tr>
                    <tr>
                      <th colspan="9">Shipping Charge</th>
                      <th><?php 
                            if($price>399){
                              $shipping =0;
                            }else if($price<399 && $price>1 ){
                              $shipping =29; //29
                            }else {
                              $shipping =0;
                            }
                            echo "₹ ".$shipping;
                    ?> </th>
                    </tr>
                    <tr>
                      <th colspan="9">You Save</th>
                      <th>₹ <?php echo $totalsaving; ?></th>
                    </tr>
                    <tr>
                      <th colspan="9">Grand Total</th>
                      <th>₹ <?php echo $price+$shipping; ?> /-</th>
                    </tr>  
                  </table>
    </div> 
    <center><p>Thank you for your order contact us on helpline +91-9383240640 for any issues.</p></center>
</div>
<!-- <script type="text/javascript">
window.print();
</script> -->