rpt_serial_d.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 : Serial Detail In Document </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 : Serial Detail In Document </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"></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="2" cellpadding="1" width="100%">
<?
$sql="SELECT  stock_head_in.doc_no  ,stock_head_in.doc_type,stock_head_in.op_date,stock_head_in.supplier_id,stock_head_in.comment ,stock_head_in.form_site FROM stock_head_in WHERE stock_head_in.head_id='$head_id'  ";
$qid = db_query($sql);
$frm=db_fetch_array($qid);
?>
<tr >
    <td   align="right" class="txtThai"  height='20'>Document No.&nbsp;
	</td>
		<td   class="txtThai" >&nbsp;	<?echo $frm["doc_no"];?>	</td>
    <td   align="right" class="txtThai" >Document Type&nbsp;
	</td>
		<td   class="txtThai">&nbsp;<?echo $frm["doc_type"];?></td>

</tr>
<tr >
    <td   align="right" class="txtThai" height='20'>Supplier&nbsp;
	</td>
		<td   class="txtThai">&nbsp;<?echo get_cust($frm["supplier_id"]);?></td>
    <td   align="right" class="txtThai" >Receive  Date&nbsp;
	</td> 
	<td class="txtThai">&nbsp;<?echo $frm["op_date"];?></td>
</tr>
<tr>
	<td align="right" class="txtThai" >From Site&nbsp;</td>
	<td >&nbsp;<?echo site_info($frm["form_site"]);?>	</td>
	<td   align="right" class="txtThai"  colspan='2'>&nbsp;<?echo nl2br($frm["comment"]);?>
	</td> 
</tr>
<?
$sql="SELECT  stock_product.model,stock_product.product_id,stock_detail.qty,stock_serial.serial FROM stock_detail,stock_product,stock_serial WHERE stock_product.product_id=stock_detail.product_id AND stock_detail.product_id=stock_serial.product_id AND stock_detail.head_id='$head_id' AND stock_serial.head_in='$head_id'";
echo $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>

	
</tr>
<?
//}?>
</table>


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