/* Decoded by unphp.net */

 include("../config/Connection.php");
	   $we=$_REQUEST['we'];
 if ($we==1){
header('Content-type: application/word');
header('Content-Disposition: attachment; filename="Inventory.doc"');
} else if ($we==2){ 
header('Content-type: application/excel');
header('Content-Disposition: attachment; filename="Inventory.xls"');

}
	   include("Rhead.php");
?>
<table width="100%" style="font-family:Calibri">
 		<tr>
			<th width="6%" style="border-bottom:solid; border-width:1px;">Sr#</th>
			<th width="12%" style="border-bottom:solid; border-width:1px;">BarCode</th>
			<th width="27%" style="border-bottom:solid; border-width:1px;">Name</th>
		
			<th width="14%" style="border-bottom:solid; border-width:1px;">BP</th>
			<th width="9%" style="border-bottom:solid; border-width:1px;">TP</th>
			<th width="11%" style="border-bottom:solid; border-width:1px;">STORE</th>
			<th width="10%" style="border-bottom:solid; border-width:1px;">SHOP</th>
			
			<th width="11%" style="border-bottom:solid; border-width:1px;">Store AMT</th>
			<th width="11%" style="border-bottom:solid; border-width:1px;">Shop AMT</th>
		</tr>
		 
	 <?php $gtps=0;
		$rsc=mysql_query("select * from  accounts where account_type_Id=41");				
	 while($newArray=mysql_fetch_array($rsc)) {	
	 $Customer_Id=$newArray['account_Id'];
	  $Name=$newArray['account_Name'];
	  $TQ=0;
	  $TA=0; $TAs=0; 
	  $STQ=0;
	  echo '<tr><td colspan="9"> '. $Name.'</td></tr>';
		 $rsp=mysql_query("select * from  product where Company_Id='$Customer_Id' and del=0 order by Name");				
	 while($newArray=mysql_fetch_array($rsp)) {	
	 	 
	 $P_Name= $newArray['Name'];

	 $S_Price= $newArray['TP'];
	 $ProductId= $newArray['ProductId'];
	
			$shQTY= $newArray['Shop'];
		 $ProductId= $newArray['Product_Id'];
	   
  $QTY= $newArray['QTY'];
		  $P_Price=$newArray['ORate']

		 ?>
		 <tr  >
		 	<td align="center" width="6%" style="border-bottom:dotted; border-width:1px;"><?php echo $sr; ?></td>
			<td align="center" width="12%" style="border-bottom:dotted; border-width:1px;"><?php  echo $ProductId;  ?></td>
			<td width="27%" style="border-bottom:dotted; border-width:1px;"><a href="Inventory.php?Expenxe_ID=<?php echo $Expenxe_ID; ?>" style="text-decoration:none; color:#000000;"><?php echo $P_Name; ?></a></td>
	
			<td align="right" width="14%" style="border-bottom:dotted; border-width:1px;"><?php  echo $P_Price;  ?></td>
			<td align="right" width="9%" style="border-bottom:dotted; border-width:1px;"><?php  echo $S_Price;  ?></td>
			<td align="CENTER" width="11%" style="border-bottom:dotted; border-width:1px;"><?php  echo $QTY;  ?></td>
			<td align="CENTER" width="10%" style="border-bottom:dotted; border-width:1px;"><?php  echo $shQTY;  ?></td>
			<td align="right" width="11%" style="border-bottom:dotted; border-width:1px;"><?php  echo number_format($QTY*$P_Price);  ?></td><td align="right" width="11%" style="border-bottom:dotted; border-width:1px;"><?php  echo number_format($shQTY*$P_Price);  ?></td>
		</tr>
<?php $sr=$sr+1; $TQ=$TQ+$QTY; $STQ=$STQ+$shQTY; $TA=$TA+($QTY*$P_Price); $TAs=$TAs+($shQTY*$P_Price); } ?>
<tr>
	<td>&nbsp;</td>
</tr>
	<tr >
			<th align="center" colspan="5" style="border:solid; border-width:1px;">TOTAL</th>
			<th align="center" style="border:solid; border-width:1px;"><?php echo $TQ; ?></th>
			<th align="center" style="border:solid; border-width:1px;"><?php echo $STQ; ?></th>
			<th align="right" style="border:solid; border-width:1px;"><?php echo number_format($TA); ?></th>
			<th align="right" style="border:solid; border-width:1px;"><?php echo number_format($TAs); ?></th>
	</tr>
	<?php  $gtr=$gtr+$TQ; $gtp=$gtp+$TA; $gtps=$gtps+$TAs;  $sgtp=$sgtp+$STQ;} ?>
	<tr>
	<td>&nbsp;</td>
</tr>
	<tr bgcolor="#7DFFE5" style="border-radius: 15px; ">
			<th colspan="5" style="border:solid; border-width:1px;">GRAND TOTAL</th>
			<th align="center" style="border:solid; border-width:1px;"><?php echo $gtr; ?></th>
			<th align="center" style="border:solid; border-width:1px;"><?php echo $sgtp; ?></th>
			<th align="right" style="border:solid; border-width:1px;"><?php echo number_format($gtp); ?></th>
			<th align="right" style="border:solid; border-width:1px;"><?php echo number_format($gtps); ?></th>
	</tr>
</table>
<?php 
include("Rfoot.php");