1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com / demo /
Filename : orders_print.php
back
<style type="text/css">
	th,td{
		padding: 2px;
	}
</style>
<?php
include 'main.php';
if(isset($_GET['oid']))
$oid=$_GET['oid'];
$sql="SELECT p.partyname,p.gst,o.order_date,pt.productname,pt.size,op.quantity,op.amount,o.transportation,op.unitprice,op.amount,o.order_date,o.due_date,o.delivery_date,o.agent_id,o.message FROM `orders` o, order_products op, party p,product pt where o.oid='$oid' and o.party_id=p.pid and o.oid=op.oid and op.pid=pt.pid";
$sql1="SELECT p.partyname,p.gst,o.order_date,pt.productname,pt.size,op.quantity,op.amount,o.transportation,op.unitprice,op.amount,o.order_date,o.due_date,p.mobileno,o.delivery_date,o.agent_id,o.message,o.due_days,o.serial,o.transportation  FROM `orders` o, order_products op, party p,product pt where o.oid='$oid' and o.party_id=p.pid and o.oid=op.oid and op.pid=pt.pid";


$result1=$conn->query($sql1);
$row1=$result1->fetch_assoc();

$result=$conn->query($sql);

$order_date = strtotime($row1['order_date']);
$delivery_date = strtotime($row1['delivery_date']);
$datediff = $delivery_date - $order_date;

$Payment_date= round($datediff / (60 * 60 * 24));

//Agent code
$agent_id=$row1['agent_id'];
$agent="SELECT * FROM `agent_details` WHERE aid ='$agent_id'";
$agentres=$conn->query($agent);
$agentrow=$agentres->fetch_assoc();
$agent_code=$agentrow['agent_code'];
?>

<!DOCTYPE html>
<html>
<head>
<title>SHANKARA TRADING CO</title>

<link rel="icon" type="image/x-icon" href="img/eltoro.png">
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script> -->
<script src="vendor/jquery-3.2.1.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
</head>
<br>
<br>
<body onload="myFunction()">
<div class="container">
<div class="row">
<h6 style="text-align: center"></h6>	
<div class="table-responsive">
<div class="table-responsive custom_datatable">						
<table border="1" style="width:100%; text-align:left;"><tbody>

<tr>
<td rowspan="2" colspan="5">
<div class="mx-auto bg-light" style="width:140px; border:0.7px solid black; padding: 9px; font-weight: 600;">
ORDER FORM</div>

<h3 style="text-align: center;"><img src="images/sankara.png" alt="eltoro" width="50px" height="50px"><u>SHANKARA TRADING CO</u><br></h3>
<p style="text-align: center;"><i><b>Eltoro Branded Shirt / T-Shirt</b></i></p>
<p style="text-align:center;">
No.284,Sakthi Avenue,2nd Street,<br>Gerugambakkam, Chennai-600128.</p>
<p style="text-align: center;"><b>GSTIN: 33AACPN6783F1ZN.</b></p>
</td>

<td colspan="3" style='width: 25%;'><br><br><u><b>Woven Factory:</b></u></td>
<td colspan="4"><br>Chennai - 600 116.<br>Mob: +91-99524 25491.<br>Email: nagarajan@arvindintl.com.</td>
</tr>
<tr>
<td colspan="3"><br><br><u><b>Knit Factory:</b></u></td>  
<td colspan="4"><br>Tirupur - 641 606.<br>Mob: +91-99944 62720.<br>Email: team2@saratogatex.com.</td>	
</tr>

<tr>
<td rowspan="2" colspan="5">To,M/s.:  <?php echo $row1['partyname'];?></td>
<td colspan="2">S.NO : <?=$row1['serial']?></td>
<td colspan="5">Transport : <?=$row1['transportation']?></td>

</tr>
<tr>
<td colspan="3">Agent: <?=$agent_code?></td>
<td colspan="4">Order No.: <?php echo "OST".$oid; ?></td>
</tr>

<tr>
<td colspan="5">Party's GSTIN.: <?php echo $row1['gst']; ?></td>

<td colspan="3">Date.:<br><?php echo date('d-M-Y') ;?>
	<br><br>
	Order Date: <br><?=date('d-M-Y',strtotime($row1['order_date']))?>
	<br> <br>
	Delivery Date:<br> <?=date('d-M-Y',strtotime($row1['delivery_date']))?>
</td>

<td colspan="4">
	Payment days: <?php echo $row1['due_days'];?>
	<br><br>
	Payment Due Date:<br> <?=date('d-M-Y',strtotime($row1['due_date']))?>
	<br><br>
	Mobile no: <?php echo $row1['mobileno'];?>
</td>
</tr>

</tbody>
</table>
<br>
<table width="100%" border="1">

<tr style="text-align: center">
<th colspan="1">S.NO</th>
<th colspan="1">Style</th>
<th colspan="1">Image</th>
<th colspan="1">Color</th>
<th colspan="1">Print</th>

	
		<?php 
		$size="SELECT DISTINCT(s.sid),s.* FROM `order_products` op, product p, size s WHERE op.oid  = '$oid' and op.pid = p.pid and p.size = s.sid GROUP BY p.pid , s.sid";
		$size_res=$conn->query($size);


		while ($size_row=$size_res->fetch_assoc()) {
			echo "<th>".$size_row['size']."</th>";
		}
		?>
	

<th colspan="1">QUANTITY</th>
<th colspan="1">TOTAL AMOUNT</th>
</tr>

	<?php 
		$prod_sql="select p.product_image,s.style, c.colourtext, s.sid, c.cid,p.print from order_products op, product p, style s, colour c where p.pid = op.pid and p.style = s.sid and c.cid = p.colour and op.oid='$oid' group by s.sid, c.cid,p.print";
		$prod_result1=$conn->query($prod_sql);

		$tot1=0;
		$sno=1;
		while($row=$prod_result1->fetch_assoc()){
				
				 $style_id=$row['sid'];
				 $colour_id=$row['cid'];
				
				echo "<tr>
				<td>".$sno."</td>
				<td rowspan=''>".$row['style']."</td>";
				
				$pimg = $row['product_image'];
				if($pimg == "no_image.png"){
					echo "<td>----</td>";
				}else{
				?>

				<td> <img src="images/products/<?php echo $pimg;?>" width="100" height="100"></td>

				<?php }
				echo "<td><center>".$row['colourtext']."</center></td>";
				?>

			<!-- Print description -->
			<?php

				$print_id = $row['print'];
				$printSql = "select print_description FROM `print_description` where pd_id='$print_id'";
				$printRes = $conn->query($printSql);
				$printRow = $printRes->fetch_assoc();
				
				echo "<td><center>".$printRow['print_description']."</center></td>";

			?>

				

				<?php 
				$size_id="SELECT DISTINCT(s.sid),s.* FROM `order_products` op, product p, size s WHERE op.oid  = '$oid' and op.pid = p.pid and p.size = s.sid GROUP BY p.pid , s.sid";

				$size_id_res=$conn->query($size_id);
				$size_cou = mysqli_num_rows($size_id_res);
				$size_cou = $size_cou + 4;

				

				$qnty=0;
				$tot=0;
				while ($size_id_row=$size_id_res->fetch_assoc()) {
					$size_ids=$size_id_row['sid'];

				$sql3="select op.quantity, op.unitprice, op.amount from product p, order_products op where p.style = '$style_id' and p.colour = '$colour_id' and p.size = '$size_ids' and p.print = '$print_id' and p.pid = op.pid and op.oid = '$oid'";
				$result3=$conn->query($sql3);
				$row3=$result3->fetch_assoc();
				if(mysqli_num_rows($result3)>0){
				echo "<td>".$row3['quantity']." (".$row3['unitprice'].") "."</td>";

				$qnty += $row3['quantity'];
				$tot += $row3['amount'];
				

				}else echo "<td><center>-</center></td>";
				
				}
				echo "<td><center>".$qnty."</center></td>";
				echo "<td><center>".$tot."</center></td>";

				$tot1+=$tot;
				$sno++;
				echo "</tr>";
			
			}
			echo "<tr><td colspan=".$size_cou."></td><td colspan='2'> Sub Total  :</td><td><center>".ceil($tot1).".00</center></td></tr>";

			$gst=(0.05*$tot1);
			echo "<tr><td colspan=".$size_cou."></td><td colspan='2'>5% Gst :</td><td><center>".ceil($gst).".00</center></td></tr>";

			$total_amt=$tot1+$gst;
			echo "<tr><td colspan=".$size_cou."></td><td colspan='2'>TOTAL AMOUNT :</td><td><center>".ceil($total_amt).".00</center></td></tr>";
	?>

<tr>
<td colspan="<?php echo  $size_cou; ?>">Customer Sign</td>
<td colspan="<?php echo  $size_cou; ?>">For SHANKARA TRADING CO<br><br></td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
	<h4>Note for Order:</h4>
	<div id='message'><?=$row1['message']?></div>
	</div>
</div>

</body>

</html>
 <script>
function myFunction() {
  // window.print();
}</script>
 
<style type="text/css">
div#message{
  width: 98%;
  border: 1px solid #dee2e6;
  padding: 3%;
  margin: 20px;
}


</style>