rpt_stk_in.php

warehouse management system

<?
include("../application.php"); 
$username=$SESSION["user"]["user_name"];
$unit_set=$SESSION["user"]["unit_set"];
$work_type=$SESSION["user"]["work_type"];
include("rptheader.php");
 ?>
 <title>Stock IN Report</title>
<table width="100%"  border="0" cellspacing="0" cellpadding="1" bordercolor="#000000" bgcolor="#ffffff" >
  <tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai" colspan="2" height='20'>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"  height='20'>Report : Stock In List </td>
		<td  align ="center" class="txtThai"   height='20'>Receive Date  : <?echo $op_date;?> to <?echo $to_date;?></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" height='20'>CUSTOMMER  : <?echo site_info($site_id);?></td>
		<td  align ="right" class="txtThai" height='20'>Time Print : <?echo date('h:i:s');?></td>
</tr>
<tr bgcolor="#ffffff">
		<td  align ="left" class="txtThai" height='20'>Group Product  : <?echo $group_id;?></td>
		<td  align ="center" class="txtThai" height='20'>Document Type  : <?echo $doc_type;?></td>
		<td  align ="left" class="txtThai" height='20'>Supplier  : <?echo $customer_id;?></td>
</tr>
</table>
<br>

<table  border="1" bgcolor="#ffffff" cellspacing="0" cellpadding="1" width="100%" bordercolor="#000000">
<tr>
	<td   align="center"  class="txtThai" width="5%"><b>Order</b></td>
	<td   align="center"  class="txtThai" ><b>Date</b></td> 
	<td   align="center"  class="txtThai" ><b>Doc No</b></td> 
	<td   align="center"  class="txtThai" ><b>Type</b></td> 
	<td   align="center"  class="txtThai" ><b>Supiler</b></td> 
	<td   align="center"  class="txtThai" ><b>Group</b></td> 
	<td   align="center"  class="txtThai" ><b>Quantity</b></td> 
	<td   align="center"  class="txtThai" width="20%"><b>Remark</b></td> 

</tr>
<?
$sql="SELECT stock_head_in.doc_no,stock_head_in.doc_type,stock_head_in.op_date,stock_head_in.supplier_id,  stock_detail.product_id,SUM(stock_detail.qty) AS qty,stock_head_in.comment,stock_head_in.group_id FROM stock_head_in, stock_detail WHERE   stock_head_in.head_id=stock_detail.head_id  AND stock_head_in.log_status='1' AND stock_detail.log_status='1' AND stock_detail.type='+' AND stock_head_in.site_id='$site_id'";
if($op_date<>"" AND $to_date<>"")$sql.=" AND stock_head_in.op_date>='$op_date' AND stock_head_in.op_date<='$to_date' ";
if($group_id<>"")$sql.=" AND stock_head_in.group_id='$group_id'";
if($doc_type<>"")$sql.=" AND stock_head_in.doc_type='$doc_type'";
if($customer_id<>"")$sql.=" AND stock_head_in.supplier_id='$customer_id'";
$sql.=" GROUP BY stock_head_in.head_id ORDER BY stock_head_in.op_date,stock_head_in.doc_no,stock_detail.product_id";
$s_qty=0;
$qid = db_query($sql);
$row=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->op_date;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->doc_no;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->doc_type;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->supplier_id;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->group_id;?></td>
	<td  align="right"  class="txtThaiLB" ><?echo number_format($r->qty,$unit_set,'.',',');?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->comment;?></td>
</tr>
<?
$s_qty+=$r->qty;	
}?>
<tr bgcolor="#ffffff">
	<td  align="center"  class="txtThai" colspan="6"><b>Total</b></td>
	<td  align="right"  class="txtThaiL" >&nbsp;<?echo number_format($s_qty,$unit_set,'.',',');?>&nbsp;</td>
	<td  align="center"  class="txtThaiL" >&nbsp;</td>
</tr>
</table>
<br>
<div align="right">
<?
	 echo "<table  border='1' bordercolor='#000000' cellspacing='0' cellpadding='1' width='350'>";
		echo "<tr bgcolor='#ffffff'>";
		echo "<td class='txtThaiB' height='40' align='center' width='110'>$username</td>";
		echo "<td  class='txtThaiLB' width='110'>&nbsp;</td>";
		echo "<td  class='txtThaiLB' width='110'>&nbsp;</td>";
		echo "</tr>";
		echo "<tr bgcolor='#ffffff'>";
		echo "<td class='txtThai' align='center'  height='20'>REPORTD BY</td>";
		echo "<td class='txtThaiL' align='center' >CHECKED  BY</td>";
		echo "<td class='txtThaiL' align='center' >APPROVED BY</td>";
		echo "</tr>";
		echo "</table>"
?>
</div>
 <script language="javascript">
 	//print_pv(7);
	//this.window.close();
</script>