rpt_stk_blance1.php

warehouse management system

<?
include("../application.php"); 
$username=$SESSION["user"]["user_name"];
$unit_set=$SESSION["user"]["unit_set"];
include("rptheader.php");
list($op_year,$op_month,$op_day)= split ("-", $to_date, 3); 
$loop=$op_day+0;
$start=substr($op_date,-2)+0;
//echo $start;
$sql_list="SELECT  ".$data_style."stock_detail.product_id , stock_product.model,stock_product.color,stock_product_group.group_name,SUM(if(".$data_style."stock_detail.op_date<'$op_date',concat(".$data_style."stock_detail.type , ".$data_style."stock_detail.qty),0)) as last_qty ";

 ?>
<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  BLANCE :&nbsp;<?echo $group_id;?></td>
		<td  align ="center" class="txtThai">DATE BLANCE :&nbsp;<b><?
			list($op_year,$op_month,$op_day)= split ("-", $op_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="middle" align="center" width="5%" rowspan="2" class="txtThaiB">Item</td> 
	<td   align="center"  valign="middle"  width="140" class="txtThaiLB" rowspan="2"><font color="#000000">Part</font>	</td> 
	<td   align="center"  width="240" valign="middle" class="txtThaiLB" rowspan="2" ><font color="#000000">Model </font></td> 
	<td   align="center"  valign="middle" class="txtThaiLB" rowspan="2" width="40"><font color="#000000">BAL</font></td> 
<?
for($i=$start;$i<=$loop;$i++){?>
	<td   align="center"  valign="middle" class="txtThaiLB" colspan="3" >&nbsp;<font color="#000000"><?echo $i;?></font></td> 
<?
	$sql_list.=" ,SUM(if(".$data_style."stock_detail.type='+' && ".$data_style."stock_detail.op_date='$op_year-$op_month-$i',".$data_style."stock_detail.qty,0 )) as qty_in$i, SUM(if(".$data_style."stock_detail.type='-' ,if(".$data_style."stock_detail.op_date='$op_year-$op_month-$i',".$data_style."stock_detail.qty,0 ),0) ) as qty_out$i,	SUM(concat(".$data_style."stock_detail.type ,if(".$data_style."stock_detail.op_date<='$op_year-$op_month-$i',(".$data_style."stock_detail.qty),0))) as bf_qty$i";
	
}$target=(($loop-$start+1)*3)+5;?>
</tr>
<?
$sql_list.="   FROM ".$data_style."stock_detail ,stock_product_group,stock_product WHERE  stock_product_group.group_id=stock_product.group_id AND stock_product.product_id=".$data_style."stock_detail.product_id  AND  ".$data_style."stock_detail.log_status='1' AND  ".$data_style."stock_detail.site_id='$site_id' ";
$sql_list.=" AND  ".$data_style."stock_detail.doc_type NOT IN ('".get_not_inven()."')"; 
if($group_id<>"")$sql_list.=" AND stock_product_group.group_id='$group_id'";
if($product_id<>"")$sql_list.=" AND ".$data_style."stock_detail.product_id='$product_id'";
$sql_list.=" GROUP BY stock_product_group.group_id,stock_product.product_id";
if($show_zero=="1")$sql_list.=" HAVING bf_qty$loop > 0";
//echo $sql_list;

for($i=$start;$i<=$loop;$i++){?>
	 <td   align="center"  valign="middle"  class="txtThaiLB" width="40"><font color="#000000">IN</font></td> 
	<td   align="center"  valign="middle"  class="txtThaiLB" width="40"><font color="#000000">OUT</font></td>
	<td   align="center"  valign="middle" class="txtThaiLB" width="40"><font color="#000000">BAL</font></td> 
<?}
echo "</tr>";
$qid= db_query($sql_list);
$group_name="";
?>
 </THEAD>
</DIV>
<DIV class=innerframe>
<?
echo "</tr>";
$row=0;
$qid = db_query($sql_list);
$group_name="";
for($i=5;$i<$target;$i++){
		$sum_qty[$i]=0; //INIT value=0;
}
while ($frm = db_fetch_array($qid)) { 
$row++;
if($group_name<>$frm["group_name"]){
?>
<tr bgcolor="#ffffff" >
<td  align="left" colspan="<?echo $target;?>" class="txtThaiB">&nbsp;<?echo $frm["group_name"];?></font></a></td> 
</tr>
<?
}
$group_name=$frm["group_name"];
?>
<tr bgcolor="#ffffff">
	<td  align="center" class="txtThaiB"  ><?echo $row;?>	</td> 
	<td  align="left" class="txtThaiLB" ><?echo $frm["product_id"];?></font></a></td> 
	<td  align="left" class="txtThaiLB" >&nbsp;<?echo $frm["model"]."  ".$frm["color"];?></td> 
	<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format($frm["last_qty"],$unit_set,'.',',');?></td>
	<?
	
	for($i=5;$i<$target;$i++){
	$sum_qty[$i]+=$frm[$i];
	?>
		<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format($frm[$i],$unit_set,'.',',');?></td>
	<?}?>
</tr>
<?}?>
<tr bgcolor="#ffffff">
	<td colspan="4" align="center" class="txtThai">TOTAL</td>
		<?for($i=5;$i<$target;$i++){
		echo "<td  align='right' class='txtThaiL'>".number_format($sum_qty[$i],$unit_set,'.',',')."</td>";
	}
	?>
</tr> 
</DIV>
</table>
 <script language="javascript">
	print_pv(7);
	this.window.close();
</script>