Ele57885fddfgdfgfghgقفغفغفقhfg555434536

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

<?php

require_once 'db.php';

$orderId=intval($_GET['cid']);   
//$orderId = $_POST['orderId'];

$sql = "SELECT * FROM cust WHERE order_id = $orderId";

$orderResult = $db->query($sql);
$orderData = $orderResult->fetch_array();

$orderDate = $orderData[1];

$clientName = $orderData[12];

$clientContact = $orderData[3];

$subTotal = $orderData[5];

$totaloffer = $orderData[6];

$totaldiscounts = $orderData[9];

$cnt = $orderData[10];

$phonenumr = $orderData[14];
$address = $orderData[15];

$gstnumber = $orderData[19];

$dantime = $orderData[24];

$approve = $orderData[26];

$orderItemSql = "SELECT customer_order.id, customer_order.p_name, customer_order.p_qty,customer_order.p_price, customer_order.total FROM customer_order	 WHERE customer_order.tr_id = $orderId";
$orderItemResult = $db->query($orderItemSql);

$table = '
 <!DOCTYPE html>
 <html>
 <head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
 	<title></title>

@page{
    size: 8 x 6 in;
    margin: mm;
}

.invoice {
    position: relative;
    background-color: #FFF;
    min-height: 680px;
    padding: 15px
}

.invoice header {
    padding: 10px 0;
    margin-bottom: 20px;
    border-bottom: 1px solid #3989c6
}

.invoice .company-details {
    text-align: right
}

.invoice .company-details .name {
    margin-top: 0;
    margin-bottom: 0
}

.invoice .contacts {
    margin-bottom: 20px
}

.invoice .invoice-to {
    text-align: left
}

.invoice .invoice-to .to {
    margin-top: 0;
    margin-bottom: 0
}

.invoice .invoice-details {
    text-align: right
}

.invoice .invoice-details .invoice-id {
    margin-top: 0;
    color: #3989c6
}

.invoice main {
    padding-bottom: 50px
}

.invoice main .thanks {
    margin-top: -100px;
    font-size: 2em;
    margin-bottom: 50px
}

.invoice main .notices {
    padding-left: 6px;
    border-left: 6px solid #3989c6
}

.invoice main .notices .notice {
    font-size: 1.2em
}

table,thead,tbody ,tr ,th, td,tfoot {
  border: 1px solid black;
  border-collapse: collapse;
}
th, td {
  padding: 10px;
</style>

/* Create two equal columns that floats next to each other */
.column {
  float: left;
  width: 50%;
  padding: 10px;
  padding-bottom: 0px;
  padding-top: 0px;
  line-height: 50%;
  height: 100%; /* Should be removed. Only for demonstration */
}

</style>
 </head>
 <body onload="window.print()">
 
 <div id="invoice">

<div class="row">
<center><h2>'.$address.'</h2></center>

<div class="column">
    <h5 style="text-align: left;">GST :- '.$gstnumber.'</h5>
    <h5 style="text-align: left;">Ph Number : '.$phonenumr.'</h5>
    
  </div>
  <div class="column">
    <h5 style="text-align: right;">Order No : '.$orderId.'</h5>
    <h5 style="text-align: right;">Date :'.$dantime.'</h5>
    
                 
            
<h5 style="text-align: right;">Customer Name :'.$clientName.' </h5>
    <h5 style="text-align: right;">Status :'.$approve.'</h5>
    
  </div>
</div>
    
    </th>
    
    
    
    
    
    
    
    
  </tr>
	</thead>
</table></center>
<center><table border="1" cellspacing="0" cellpadding="0" style="width:60%;">
 <thead>
		<tr>
		   <th>S.No</th>
			<th >Product Name</th>
			<th style="width:30px;">Qty</th>
			<th style="width:30px;">Unit</th>
			
		<th style="width:30px;">Rate</th>
			<th style="width:30px;">Amount</th>
			
		</tr>

</thead></center>
  <tbody>
		<tr>';
		
		$x = 1;
		while($row = $orderItemResult->fetch_array()) {			
						
			$table .= '<tr>
				<th>'.$x.'</th>
				
				
				
				
				
				<th>'.$row[1].'</th>
					<th>'.$row[2].'</th>
					<th>Pcs</th>
			
				<th>'.$row[3].'</th>
				
				
				<th>'.$row[4].'</th>
				
			</tr>
			';
		$x++;
		}
		$table .= '
		</tr>
 <tbody>
		<tr>
			<td colspan="5"><center>Sub Total</center></td>
			<td><center>'.$subTotal.'</center></td>
		</tr>
	
		
	
	
	
	
		<tr>
			<td colspan="5"><center>Approx. Order Value
			
</center></td>
			<td><center>'.$totaloffer.'</center></td>
			
		</tr>

<tr>
			<td colspan="5"><center>Discount</center></td>
			<td><center>'.$totaldiscounts.'</center></td>
		</tr>
		
			<tr>
			<td colspan="5"><center>Total Amount</center></td>
			<td><center>'.$cnt.'</center></td>
		</tr>
	</table>
	<table border="1" cellspacing="0" cellpadding="20" width="100%">
	
	
	
	
	
	
	
	
	
	
	
	
	
</table>

<br>

window.history.back();
}
</script>
<script>
function myFunction() {
	
var printButton = document.getElementById("printpagebutton");
      
       var printButton1 = document.getElementById("printpagebutton1"); 
        printButton.style.visibility = "hidden";
        printButton1.style.visibility = "hidden";
        window.print()

printButton.style.visibility = "visible";
        printButton1.style.visibility = "visible";
}
</script>

</main>

</div>
        
    </div>
    
</div>
</body>
 </html>
 ';

$db->close();

echo $table;