Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php 
require_once 'db.php'; 
 $orderId=intval($_GET['cid']);     
//$orderId = $_POST['orderId'];

$sql = "SELECT order_id,name,phonenumr,dantime,subtotalamount,totaldiscounts,cnt,qt,address FROM cust WHERE order_id = $orderId";

$orderResult = $db->query($sql);
$orderData = $orderResult->fetch_array();
$originalDate = $orderData[2];
$orderDate = date("d-m-Y", strtotime($originalDate));
$name = $orderData[1];
$phonenumr = $orderData[2];
$dantime = $orderData[3];
$subtotalamount = $orderData[4];
$totaldiscounts = $orderData[5];
$cnt = $orderData[6];
$qt = $orderData[7];
$address = $orderData[8];

<!DOCTYPE html>
<html>

<head>

#invoice-POS {
  box-shadow: 0 0 1in -0.25in rgba(0, 0, 0, 0.5);
  padding: 2mm;
  margin: 0 auto;
  width: 100mm;
  background: #FFF;
   /*border-style: dotted ;*/
}

#invoice-POS ::selection {
  background: #f31544;
  color: #FFF;
}
#invoice-POS ::moz-selection {
  background: #f31544;
  color: #FFF;
}
#invoice-POS h1 {
  font-size: 1.5em;
  color: #222;
}
#invoice-POS h2 {
  font-size: .9em;
}
#invoice-POS h3 {
  font-size: 1.2em;
  font-weight: 300;
  line-height: 2em;
}
#invoice-POS p {
  font-size: .7em;
  color: #666;
  line-height: 1.2em;
}
#invoice-POS #top, #invoice-POS #mid, #invoice-POS #bot {
  /* Targets all id with 'col-' */
  border-bottom: 1px solid #EEE;
}
#invoice-POS #top {
  min-height: 100px;
}
#invoice-POS #mid {
  min-height: 80px;
}
#invoice-POS #bot {
  min-height: 50px;
}
#invoice-POS #top .logo {
  height: 60px;
  width: 60px;
  background: url(http://michaeltruong.ca/images/logo1.png) no-repeat;
  background-size: 60px 60px;
}
#invoice-POS .clientlogo {
  float: left;
  height: 60px;
  width: 60px;
  background: url(http://michaeltruong.ca/images/client.jpg) no-repeat;
  background-size: 60px 60px;
  border-radius: 50px;
}
#invoice-POS .info {
  display: block;
  margin-left: 0;
}
#invoice-POS .title {
  float: right;
}
#invoice-POS .title p {
  text-align: right;
}
#invoice-POS table {
  width: 100%;
  border-collapse: collapse;
}
#invoice-POS .tabletitle {
  font-size: .5em;
  background: #EEE;
}
#invoice-POS .service {
  border-bottom: 1px solid #EEE;
}
#invoice-POS .item {
  width: 24mm;
}
#invoice-POS .itemtext {
  font-size: .5em;
}
#invoice-POS #legalcopy {
  margin-top: 5mm;
  
}

</style>
    
    <style>
* {
  box-sizing: border-box;
}

/* Create two equal columns that floats next to each other */
.column {
  float: left;
  width: 50%;
  height: auto; 
  /* Should be removed. Only for demonstration */
}

</style>

</head>

<center id="top">
      <img src="Logo/Logoo.png" alt="Logo" width="200" height="101">
      <div class="info"> 
        
        
        <h2>GSTIN : 29GNAPS5305F1ZW</h2>
        <h2>Fssai : 11222333001032</h2>
      </div>
    </center>

<div id="mid">
      <div class="info">
       
        <p align="center"> 
            <font size="2"><strong><font color="black">
                Customer Name : <?php echo $name;?> <br>
                
                Mobile No: <?php echo $phonenumr;?> <br>
                
                Address: <?php echo $address;?>
                
            </font></strong></font>

</p>
        
        
        
      </div>
    </div>
    
    <p class="column row"><font size="2"><strong><font color="black">Date : <?php echo $dantime;?> </font></strong></font>
</p>

<p class="column row" align="right"><font size="2">
<strong><font color="black">Order No : <?php echo $orderId;?></font></strong></font></p>

<div id="table">
                        <table>
                            <tr class="tabletitle">
                                <td class="item" style="width:5%;"><h1><font size="3">S.no</font></h1></td>
                                <td class="Hours" style="width:30%;"><h1><font size="3">Menu</font></h1></td>
                                <td class="Rate" style="width:10%;"><h1><font size="3">Qty</font></h1></td>
                                <td class="Rate" style="width:10%;"><h1><font size="3">Unit</font></h1></td>
                                <td class="Rate" style="width:8%;"><h1><font size="3">Rate</font></h1></td>
                                <td class="Rate" style="width:10%;"><h1><font size="3">Amount</font></h1></td>
                            </tr>
                            
                            
                            <?php
 $i = 1;
$ret=mysqli_query($db,"select * from customer_order WHERE tr_id = $orderId");
while($row=mysqli_fetch_array($ret))
{
    $id =$row['pid'];
    $orderItemSqlamwtnt = "SELECT id,name8,name10 FROM p15 WHERE id = $id ";
$orderItemResultamwtnt = $db->query($orderItemSqlamwtnt);
$orderResultamwtnt = $db->query($orderItemSqlamwtnt);
$orderDataamwtnt = $orderResultamwtnt->fetch_array();
$qty= $orderDataamwtnt[1]; 
$unit= $orderDataamwtnt[2];  
 
?>

<tr class="service">
                                
                                <td class="tableitem">
                                    <p class="itemtext" style="font-weight: 600;"><strong><font size="3"><strong><font color="black"><?php echo $i;?>.</font></strong></font></p>
                                    
                               </td>
                                
                                
                                <td class="tableitem"><p class="itemtext" style="font-weight: 600;"><font size="3"><strong><font color="black"><?php echo $row['p_name'];?></font></strong></font></p></td>
                                
                                
                                <td class="tableitem"><p class="itemtext" style="font-weight: 600;"><font size="3"><strong><font color="black"><?php echo $row['p_qty'];?></font></strong></font></p></td>
                                
                                 <td class="tableitem"><p class="itemtext" style="font-weight: 600;"><font size="3"><strong><font color="black"><?php echo $qty;?><?php echo $unit;?></font></strong></font></p></td>
                                
                                
                                
                                <td class="tableitem"><p class="itemtext" style="font-weight: 600;"><font size="3"><strong><font color="black"><?php echo $row['p_price'];?></font></strong></font></p></td>
                                
                                
                                
                                <td class="tableitem" style="text-align: center;"><p class="itemtext" style="font-weight: 600;"><font size="3"><strong><font color="black"><?php echo $row['total'];?></font></strong></font></p></td>
                            </tr>
                            <?php $i++;} ?>
                            
                            
                             <tr class="tabletitle">
                                <td></td>
                                <td class="Rate" ><h2><font size="3">Total Products &nbsp; <?php echo $qt;?></font></h2></td>
                                
                            </tr>
                            
                            
                           
                            	
                                	<?php	if ($row['totaldiscounts']== '') { ?>
                                               
                                                <?php   } else {   ?>

<tr class="tabletitle">
                                <td></td>
                                <td class="Rate" colspan="4"><h2><font size="2">Delivery Charges</font></h2></td>
                                <td class="payment" style="text-align: center;"><h2><font size="3"><?php echo $totaldiscounts;?></font></h2></td>
                            </tr>
                            
                            <?php   }   ?>

<tr class="tabletitle">
                                <td></td>
                                <td class="Rate"colspan="4"><h2><font size="2">Total</font></h2></td>
                                <td class="payment" style="text-align: center;font-weight: 600;"><h2><font size="3"><strong><?php echo $cnt;?> /-</strong></font></h2></td>
                            </tr>

</table>
                    </div>

<div id="legalcopy">
                        <p class="legal"><strong><center>Thank you & Visit Again </strong></center>
                        </p>
                    </div>

</div>
  </div>

</body>
</html>