rpt_stock_actual.php

warehouse management system

<?
include("../application.php"); 
$username=$SESSION["user"]["user_name"];
$site_id=$SESSION["user"]["site_id"];
include("rptheader.php");
$sql_list="SELECT stock_detail.stock_id,stock_detail.site_id,stock_product.group_id, stock_detail.product_id,stock_product.color,SUM(if(stock_detail.op_date<='$op_date',concat(stock_detail.type , stock_detail.qty),0)) as last_qty,stock_product.model FROM stock_detail ,stock_product_group,stock_product WHERE  stock_product_group.group_id=stock_product.group_id AND stock_product.product_id=stock_detail.product_id  AND  stock_detail.log_status='1' AND  stock_detail.site_id='$site_id' AND stock_detail.op_date<='$op_date' AND stock_product.group_id='$group_id' ";
		if($product_id<>"")$sql_list.=" AND stock_detail.product_id='$product_id'";
		$sql_list.=" GROUP BY stock_product.product_id";
 ?>
<table width="100%"  border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" >
  <tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai" colspan="3" height="35"><font size="+2">Hitachi Transport  System (Thailand ) Co.,Ltd.</font></td>
</tr>
 <tr bgcolor="#ffffff">
		<td valign ="top" align ="left" class="txtThai" colspan="2">SITE INFOMATION  : <?echo site_info($site_id);?></td>
		<td  align ="right" class="txtThai" height='20'>User Print : <?echo $username;?></td>
</tr>
 <tr bgcolor="#ffffff">
		<td valign ="top" align ="left" class="txtThai" colspan="2">PRODUCT GROUP  : <?echo $group_id;?></td>
		<td  align ="right" class="txtThai" height='20'>Date Print : <?echo date('y-m-d');?></td>
</tr>
 <tr bgcolor="#ffffff">
		<td valign ="top" align ="left" class="txtThai">STOCK CHECK REPORT (ACTUAL)</td>
		<td valign ="top" align ="left" class="txtThai">DATE CHECK :&nbsp;<?echo $op_date;?></td>
		<td  align ="right" class="txtThai" height='20'>Time Print : <?echo date('h:m:d');?></td>
</tr>
</table>
<br>
<table  border="1" bgcolor="#ffffff" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000">
<tr >
	<td   align="center" width="5%" class="txtThai" rowspan="2">Item</td> 
	<td   align="center"  valign="middle" class="txtThai" rowspan="2">Part</td> 
	<td   align="center"  valign="middle" class="txtThai" rowspan="2">Model</td> 
	<td   align="center"  valign="middle" class="txtThai" rowspan="2" width="8%"><font color="#000000">B/L</font>&nbsp;
	</td> 
	<?
	$adj_diff=""; // 淝槭铀醚亨＄氦枰 stock diff
	$old_val="";//淝榇帧㈤土倥 diff 啻粤
	$xcount=0; // よ曳砧琳∫没橥耿橥临培丛