/* Decoded by unphp.net */

if ($STInvoice != 0) { ?>
	<table align="center" width="100%">
		<tr>
			<td width="11%" rowspan="5">
				<img src="../imgs/logo.jpg" alt="" height="150" width="200">
			</td>
			<th width="89%" style="font-size:50px;" :>Publico Printers PVT LTD</th>
			<td width="11%" rowspan="4">&nbsp;</td>
		</tr>
		<tr>
			<th>12.5 KM Sheikhupura Road, Lahore</th>
		</tr>
		<tr>
			<th>Tel: 0092 42 37164026 Cell: 0092 321 8402473</th>
		</tr>
		<tr>
			<th>Email: publicoprinterspvtltd@gmail.com</th>
		</tr>
		<tr>
			<th>&nbsp;</th>
		</tr>
	</table>
<? } ?>
<br />
<h3 align="center">BILL</h3>
<div id="cusInfo">
	<table width="96%" align="center">
		<tr>
			<td width="2%">&nbsp;&nbsp;</td>
			<td width="12%"><b>M/S</b></td>
			<td width="86%"><? echo $DName.' '.$Mob; ?></td>
		</tr>
		<tr>
			<td>&nbsp;&nbsp;</td>
			<td></td>
			<td><?
				echo $Description;

				?></td>
		</tr>

	</table>
</div>
<div id="celspace">
	<!--2 Line Space-->
</div>
<div id="DI">
	<table width="90%" align="center">
		<tr>

			<td width="39%"><b>NO</b></td>
			<td width="61%"><? echo $Invoice; ?></td>
		</tr>
		<tr>

			<td><b>DATE</b></td>
			<td><? echo $Date; ?></td>
		</tr>

	</table>
</div>
<div id="celhight">
</div>
<table width="98%" class="table-style" style="border-style:solid; border-width:1px;margin-top:50px">
	<tr align="center" bgcolor="#548DD4">
	<th width="5%" style='border:none;border-bottom:solid 1.0pt; '>SR</th>

		<th width="41%" style='border:none;border-bottom:solid 1.0pt;letter-spacing:6px;'>Description</th>
		<th width="9%" style='border:none;border-bottom:solid 1.0pt; '>PACKING</th>
		<th width="9%" style='border:none;border-bottom:solid 1.0pt; '>QTY</th>
		<th width="9%" style='border:none;border-bottom:solid 1.0pt; '>Unit</th>
		<th width="9%" style='border:none;border-bottom:solid 1.0pt; '>Total QTY</th>
		<th width="9%" style='border:none;border-bottom:solid 1.0pt;'>Rate</th>
		<th width="11%" style='border:none;border-bottom:solid 1.0pt;'>Amount</th>

	</tr>
	<?php
$sr = 1;
$TQ = 0;
$TQP = 0;
$TQU = 0;
$GTQP = 0;
$AmountTotal = 0;
$rs = mysql_query("select * from ledger where Ref='$Invoice' and Type=5 and Cr='0.00'");
while ($newArray = mysql_fetch_array($rs)) {
    $Product = $newArray['Product_Id'];
    $Quantity = $newArray['Qty'];
    $Price = $newArray['Rate'];
    $Unit_Pack = $newArray['Unit'];
    $Cost = $newArray['Cost'];
  $Amount=$Cost*$Price;
    $rs1 = mysql_query("select * from inventory_level_4 where Id='$Product'");
    while ($newArray = mysql_fetch_array($rs1)) {
        $PName= $newArray['Name'];	
        $Unit= $newArray['Measurment_Unit'];	
    }
	$rsp=mysql_query("select * from packing where P_Id='$Unit'");
	while ($newArray = mysql_fetch_array($rsp)) 
										{
				   
				   $Pack_Name= $newArray['P_Name'];	
					   
							   }
?>
		<tr <?php if ($sr % 2) {
        echo 'bgcolor="#CCCCCC"';
    } ?>>
			<td align="center" style="border-bottom:dotted; border-width:1px;"><?php echo $sr;  ?></td>

			<td style="border-bottom:dotted; border-width:1px;"><?php echo $PName; ?></td>
			
			<td style="border-bottom:dotted; border-width:1px;"><?php echo $Pack_Name; ?></td>
			<td align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($Quantity, 2); ?></td>
			<td align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($Unit_Pack, 2); ?></td>
			<td align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($Cost, 2); ?></td>
			<td align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($Price, 2); ?></td>
			<td align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($Amount, 2); ?></td>
			
		</tr>
	<?php
    $GTQP = $GTQP + ($Quantity * $SPrice);
    $TQU = $TQU + $Quantity;
    $AmountTotal = $AmountTotal + $Amount;
    $TQP = $TQP + $Cost;
    $TQ = $TQ + ($SPrice - $Price) * $Quantity;
    $sr = $sr + 1;
}
$s = $sr;
for ($i = $sr;$i <= 18;$i++) {
?>
		<tr <?php if ($s % 2) {
        echo 'bgcolor="#CCCCCC"';
    } ?>>
			<td align="center">&nbsp;</td>


			<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>
			<td align="right">&nbsp;</td>

			
			
		</tr>
	<?php $s = $s + 1;
}