rpt_stk_blance_group.php

warehouse management system

<?
include("../application.php"); 
$username=$SESSION["user"]["user_name"];
$unit_set=$SESSION["user"]["unit_set"];
include("rptheader.php");
$sql_list="SELECT  stock_product_group.group_id,stock_product_group.group_name, SUM(if(stock_detail.type='+' ,if(stock_detail.op_date>'$op_date'&&stock_detail.op_date<='$to_date',stock_detail.qty,0 ),0) ) as qty_in,SUM(if(stock_detail.type='-',if(stock_detail.op_date>'$op_date'&&stock_detail.op_date<='$to_date',stock_detail.qty,0 ),0) ) as qty_out ,SUM(concat(stock_detail.type , stock_detail.qty)) as bf_qty 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<='$to_date'";
//$sql_list.=" AND  stock_detail.doc_type NOT IN ('".get_not_inven()."')"; 
if($group_id<>"")$sql_list.=" AND stock_product_group.group_id='$group_id'";
$sql_list.=" GROUP BY stock_product_group.group_id";
if($show_zero=="1")$sql_list.=" HAVING bf_qty > 0";
 ?>
<table width="100%"  border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" >
  <tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai" colspan="2">Hitachi Transport  System (Thailand ) Co.,Ltd.<br></td>
		<td  align ="right" class="txtThai" height='20'>User Print : <?echo $username;?></td>
</tr>
 <tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai">STOCK  GROUP BLANCE :&nbsp;<?echo $group_id;?></td>
		<td  align ="center" class="txtThai">DATE BLANCE :&nbsp;<b><?
			list($op_year,$op_month,$op_day)= split ("-", $to_date, 3); 
			echo $op_day." ".engmonth($op_month)."  ".$op_year;
	?></b></td>
		<td  align ="right" class="txtThai" height='20'>Date Print : <?echo date('y-m-d');?></td>
</tr>
 <tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai" colspan="2">CUSTOMMER  : <?echo site_info($site_id);?></td>
		<td  align ="right" class="txtThai" height='20'>Time Print : <?echo date('h:i:s');?></td>
</tr>
</table>
<br>
 <DIV class=outerframe>
<table  border="1" bgcolor="#ffffff" bordercolor="#000000" cellspacing="0" cellpadding="1" width="100%">
 <THEAD>
<tr>
	<td  valign="top" align="center" width="5%" class="txtThaiB">ITEM</td> 
	<td   align="center"  valign="middle" class="txtThailB"><font color="#000000">GROUP ID</font>&nbsp;
	</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"><font color="#000000">Desctions </font>&nbsp;
	</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"><font color="#000000">Last Balance</font>&nbsp;
	</td> 
	<td   align="center"  valign="middle"  class="txtThaiLB"><font color="#000000">Stock IN</font>
	</td> 
	<td   align="center"  valign="middle"  class="txtThaiLB"><font color="#000000">Stock OUT</font>&nbsp;
	</td> 
	 <td   align="center"  valign="middle" class="txtThaiLB"><font color="#000000">This Balance</font>
	</td> 
</tr>

 </THEAD>
</DIV>
<DIV class=innerframe>
<?
$row=0;
$last_qty=0;
$qty_in=0;
$qty_out=0;
$bf_qty=0;
$qid = db_query($sql_list);
while ($r = db_fetch_object($qid)) { 
$row++;
$last_qty+=($r->bf_qty+$r->qty_out)-$r->qty_in;
$qty_in+=$r->qty_in;
$qty_out+=$r->qty_out;
$bf_qty+=$r->bf_qty;
?>
<tr bgcolor="#ffffff">
	<td  align="center"  class="txtThaiB" ><?echo $row;?>	</td> 
	<td  align="left" class="txtThaiLB" >&nbsp;<?echo $r->group_id;?></td> 
	<td  align="left" class="txtThaiLB"   valign="middle">&nbsp;<?echo $r->group_name;?></td> 
	<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format(($r->bf_qty+$r->qty_out)-$r->qty_in,$unit_set,'.',',');?>&nbsp;
	</td>
	<td  align="right" class="txtThaiLB"  valign="middle"><?echo number_format($r->qty_in,$unit_set,'.',',');?>&nbsp;
	</td>
	 <td  align="right" class="txtThaiLB"  valign="middle"><?echo number_format($r->qty_out,$unit_set,'.',',');?></td>
	<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format($r->bf_qty,$unit_set,'.',',');?>&nbsp;</td>

</tr>
<?}?>
<tr>
	<td colspan="3" align="center" class="txtThai">TOTAL</td>
	<td  align="right" class="txtThaiL"><?echo number_format($last_qty,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="right" class="txtThaiL"><?echo number_format($qty_in,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="right" class="txtThaiL"><?echo number_format($qty_out,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="right" class="txtThaiL"><?echo number_format($bf_qty,$unit_set,'.',',');?>&nbsp;</td>
</tr>
</DIV>
</table>
 <script language="javascript">
	print_pv(7);
	this.window.close();
</script>