rpt_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 : 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>GROUP NAME</b></td> 
	<td   align="center"  class="txtThai" ><b>PRODUCT NAME</b></td> 
	<td   align="center"  class="txtThai" ><b>MODEL</b></td> 
	<td   align="center"  class="txtThai" ><b>COLOR</b></td> 
	<td   align="center"  class="txtThai" ><b>STATUS</b></td> 
	<td   align="center"  class="txtThai" width="20%"><b>Remark</b></td> 

</tr>
<?
$mysql="SELECT stock_product.product_status,stock_product.product_id,stock_product.model,stock_product.group_id,stock_product.color,stock_product.remarks ,stock_product.group_id,stock_product.group_id as group_name FROM stock_product  WHERE  stock_product.work_type='$work_type'  ";
if($group_id<>"")$mysql.=" AND stock_product.group_id='$group_id'";
if($product_id<>"")$mysql.=" AND stock_product.product_id LIKE '%$product_id%'";
if($model<>"")$mysql.=" AND stock_product.model LIKE '%$model%'";
if($color<>"")$mysql.=" AND stock_product.color LIKE '%$color%'";
if($log_status<>"1") {$mysql .=" AND stock_product.product_status='1'";} 
if(!isset ($myorder)) {$myorder ="stock_product.group_id,stock_product.product_id";} 
$sql=$mysql." ORDER BY ".$myorder." ".$order_type ;
//echo $sql;
$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="left"  class="txtThaiLB" >&nbsp;<?echo $r->product_id;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->model;?></td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->color;?></td>
	<td  align ="center" width="50" class="txtThaiLB">
		<?if($r->product_status=="1"){?>
		<a href="sql_master.php?mode=list_product&act=cancel&group_id=<?echo $group_id;?>&myorder=<?echo $myorder;?>&product_id=<?echo $r->product_id;?>&sql=<?echo $sql;?>"><img src="<?echo $CFG->imagedir?>status_ok.gif" alt="Use Product" border="0"></a>
		<?}else if($r->product_status=="0"){?>
		<a href="sql_master.php?mode=list_product&act=undo&group_id=<?echo $group_id;?>&myorder=<?echo $myorder;?>&product_id=<?echo $r->product_id;?>&sql=<?echo $sql;?>">
		<img src="<?echo $CFG->imagedir?>status_cancel.gif" alt="None Use Product" border="0"></a>
		<?}?>
		</td>
	<td  align="left"  class="txtThaiLB" >&nbsp;<?echo $r->remarks;?></td>
</tr>
<?
}?>
</table>


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