rpt_charge_item.php

warehouse management system

<?
include("../application.php"); 
$username=$SESSION["user"]["user_name"];
$username=$SESSION["user"]["user_name"];
$work_type=$SESSION["user"]["work_type"];
$unit_set=$SESSION["user"]["unit_set"];
include("rptheader.php");

$bal_sql="SELECT  bak_date as op_bal  FROM bak_info WHERE  work_type='$work_type' AND bak_date <='$in_date' ORDER BY bak_id DESC Limit 0,1";
$qid=db_query($bal_sql);
$frm=db_fetch_array($qid);
$op_bal=$frm[0];
if($mode=="list_out_charge")$tmp="out_charge";
else if($mode=="list_in_charge")$tmp="in_charge";
else if($mode=="list_storage_charge")$tmp="storage_charge";
$sql_rate="SELECT $tmp FROM stock_product_group  WHERE group_id IN ('$group_val') AND (in_date<='$in_date' OR in_date='0000-00-00') AND to_date>='$to_date' ";
$qid=db_query($sql_rate);
$frm=db_fetch_array($qid);
if($frm[0]>0)$rate=$frm[0];
else $rate=0;
//echo "Opbal= ".$op_bal;
//echo "<br>$sql_rate";

?>
<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" >Site   : <?echo site_info($site_id);?></td>
		<td  align ="center" class="txtThai" >Group   : <b><?echo $group_val;?></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" >REPORT  &nbsp;:&nbsp;<b><?echo strtoupper($mode);?></b></td>
		<td  align ="center"  class="txtThai" ><?
		list($op_year,$op_month,$op_day)= split ("-", $in_date, 3); 
		echo $op_day." ".engmonth($op_month)."  ".$op_year;
		echo "  to  ";
		list($op_year,$op_month,$op_day)= split ("-", $to_date, 3); 
		echo $op_day." ".engmonth($op_month)."  ".$op_year;
		?></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="#000000" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000" >
<THEAD>
<tr  bgcolor="#ffffff" >
	<td  valign="top" align="center" width="5%" class="txtThaiB" >&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB" ><font color="#000000">Part</font>&nbsp;
	</td> 
	<td   align="center"  valign="middle" class="txtThaiLB" ><font color="#000000">Model </font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB" ><font color="#000000">Color </font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"  width="8%"><font color="#000000">B/F</font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"  width="8%"><font color="#000000">IN</font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"  width="8%"><font color="#000000">OUT</font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"  width="8%"><font color="#000000">BAL</font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"  width="8%"><font color="#000000">RATE</font>&nbsp;</td> 
	<td   align="center"  valign="middle" class="txtThaiLB"  width="8%"><font color="#000000">TTL</font>&nbsp;</td> 
</tr>
</THEAD>
</DIV>
<DIV class=innerframe>
<?
$sql="SELECT stock_detail.stock_id,stock_detail.site_id,stock_product.group_id, stock_detail.product_id,SUM(if(stock_detail.op_date<='$op_bal',concat(stock_detail.type , stock_detail.qty),0)) as last_qty,stock_product.model,stock_product.model,stock_product.color,SUM(if(stock_detail.type='+' ,if(stock_detail.op_date>'$op_bal',stock_detail.qty,0 ),0) ) as qty_in,SUM(if(stock_detail.type='-' ,if(stock_detail.op_date>'$op_bal',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'";
if($group_val<>""){
	$group_val=str_replace("\\","",$group_val);
	$sql.=" AND stock_product_group.group_id IN('$group_val')";
}
if($pro_now<>""){
	$pro_now=str_replace("\\","",$pro_now);
	$sql.=" AND stock_detail.product_id IN('$pro_now')";
}
$sql.=" GROUP BY stock_product.product_id ORDER BY stock_product_group.group_id,stock_product.product_id";
$qid= db_query($sql);
$row=0;
$sum_in=0;
$sum_out=0;
$sum_bal=0;
$sum_ttl=0;
while ($r = db_fetch_object($qid)) { 
$row++;
		?>
	<tr bgcolor="#ffffff">
	<td  align="center"  class="txtThaiB"><?echo $row;?>	</td> 
	<td  align="left" class="txtThaiLB" >&nbsp;<?echo $r->product_id;?></a></td> 
	<td  align="left" class="txtThaiLB"   valign="middle">&nbsp;<?echo $r->model;?>	</td>
	<td  align="left" class="txtThaiLB"   valign="middle">&nbsp;<?echo $r->color;?>	</td>
	<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format($r->last_qty,$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,'.',',');?>&nbsp;
	</td>
	<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format($r->bf_qty,$unit_set,'.',',');?>&nbsp;
	</td>
	<td  align="right" class="txtThaiLB" valign="middle"><?echo number_format($rate,2,'.',',');?>&nbsp;
	</td>
	<td  align="right" class="txtThaiLB" valign="middle">
	<?
	if($mode=="list_in_charge"){
		echo number_format($r->qty_in*$rate,2,'.',',');
		$sum_ttl+=$r->qty_in*$rate;
	}else if($mode=="list_out_charge"){
		echo number_format($r->qty_out*$rate,2,'.',',');
		$sum_ttl+=$r->qty_out*$rate;
	}else	if($mode=="list_storage_charge"){
		echo number_format($r->bf_qty*$rate,2,'.',',');
		$sum_ttl+=$r->bf_qty*$rate;
	}
	$sum_in+=$r->qty_in;
	$sum_out+=$r->qty_out;
	$sum_bal+=$r->bf_qty;
	?>&nbsp;
	</td>
	</tr>
</DIV>
<?}?>
<tr bgcolor="#ffffff">
	<td  align="center" class="txtThai" valign="middle" colspan="5">TOTAL</td>
	<td  align="right" class="txtThaiL" valign="middle" ><?echo number_format($sum_in,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="right" class="txtThaiL" valign="middle" ><?echo number_format($sum_out,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="right" class="txtThaiL" valign="middle" ><?echo number_format($sum_bal,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="right" class="txtThaiL" valign="middle" >&nbsp;</td>
	<td  align="right" class="txtThaiL" valign="middle" ><?echo number_format($sum_ttl,2,'.',',');?>&nbsp;</td>
</tr>

</table>
<br><b>TOTAL CHARGE