rpt_stk_out.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 OUT 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 Out 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>Group</b></td> 
	<td   align="center"  class="txtThai" ><b>Supiler</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_out.doc_no,stock_head_out.doc_type,stock_head_out.op_date,stock_head_out.sender_id as supplier_id,  stock_detail.product_id,SUM(stock_detail.qty) AS qty,stock_head_out.comment  FROM stock_head_out, stock_detail WHERE   stock_head_out.head_id=stock_detail.head_id  AND stock_head_out.log_status='1' AND stock_detail.log_status='1' AND stock_detail.type='-' AND stock_head_out.site_id='$site_id'";
$sql="SELECT stock_head_out.sender_id as customer,stock_head_out.sender_id as supplier_id  ,stock_product.group_id as group_name, stock_head_out.head_id as stock_id,stock_head_out.doc_no,stock_head_out.doc_type,stock_head_out.op_date,stock_head_out.sender_id,stock_head_out.comment,SUM(if (type='-',stock_detail.qty,0)) as qty  , stock_head_out.print_status FROM stock_head_out , stock_detail ,stock_product WHERE  stock_head_out.head_id=stock_detail.head_id  AND stock_detail.product_id=stock_product.product_id  AND  stock_detail.log_status='1' AND stock_head_out.site_id='$site_id' ";
	
if($op_date<>"" AND $to_date<>"")$sql.=" AND stock_head_out.op_date>='$op_date' AND stock_head_out.op_date<='$to_date' ";
if($group_id<>"")$sql.=" AND stock_head_out.group_id ='$group_id'";
if($doc_type<>"")$sql.=" AND stock_head_out.doc_type='$doc_type'";
if($customer_id<>"")$sql.=" AND stock_head_out.sender_id='$customer_id'";
$sql.=" GROUP BY stock_head_out.head_id ORDER BY stock_head_out.op_date,stock_head_out.doc_no,stock_detail.product_id";
//echo $sql;
$s_qty=0;
$qid = db_query($sql);
$row=0;
while ($r = db_fetch_object($qid)) { 
$row++;
$sql_up="UPDATE stock_head_out SET group_id='$r->group_name' WHERE head_id='$r->stock_id'";
db_query($sql_up);
?>
<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->group_name;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->supplier_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,'.',',');?></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>