rpt_group_product.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>Report : Product Master List</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 : Group Product Master List </td>
		<td  align ="center" class="txtThai"   height='20'></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" height='20' colspan="2">Group Product  : <?echo $group_id;?></td>
		<td  align ="right" class="txtThai" height='20'>Time Print : <?echo date('h:i:s');?></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>GROUP ID</b></td> 
	<td   align="center"  class="txtThai" ><b>Description</b></td> 
	<td   align="center"  class="txtThai" ><b>Storage Charge</b></td> 
	<td   align="center"  class="txtThai" ><b>Charge  IN</b></td> 
	<td   align="center"  class="txtThai" ><b>OUT Charge</b></td> 
	<td   align="center"  class="txtThai" ><b> In Date</b></td> 
	<td   align="center"  class="txtThai" ><b>To Date </b></td> 
	<td   align="center"  class="txtThai" width="20%"><b>Remark</b></td>    
</tr>
<?
$sql="SELECT  group_id,site_id,group_name,group_desc,group_type,storage_charge,in_charge,out_charge,in_date,to_date   FROM stock_product_group  WHERE  work_type='$work_type' AND log_status='1'";
if($group_id<>"")$mysql.=" AND stock_product_group.group_id='$group_id'";
		if($group_name<>"")$mysql.=" AND stock_product_group.group_name LIKE '$group_name'";
$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->group_id;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->group_name;?></td>
	<td  align="right"  class="txtThaiLB" ><?echo $r->storage_charge;?>&nbsp;</td>
	<td  align="right"  class="txtThaiLB" ><?echo $r->in_charge;?>&nbsp;</td>
	<td  align="right"  class="txtThaiLB" ><?echo $r->out_charge;?>&nbsp;</td>
	<td  align="center"  class="txtThaiLB" ><?echo $r->in_date;?>&nbsp;</td>
	<td  align="center"  class="txtThaiLB" ><?echo $r->to_date;?>&nbsp;</td>
	<td  align="left"  class="txtThaiLB" >&nbsp;</td>
</tr>
<?
}?>
<tr>
<td colspan="9" class="txtThai">&nbsp;</td>
</tr>
</table>


 <script language="javascript">
 	print_pv(7);
	this.window.close();
</script>