<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=500 align=center  border=0>
      <TBODY>
		<TR>
          <TD vAlign=top>
<form name="form3" method="post" action="?name=approval&file=tabainratchakan">
  <table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
<td align=left width="70" class="unnamed2"><A HREF="?name=approval&file=tabainratchakan">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<font color=red><B>ทะเบียนหนังสือขอไปราชการของ <?=WEB_AREA;?></font></B></td>
<td width="15%"><B>ระบุชื่อหนังสือที่ต้องการค้นหา</B></td>
<td width="10%"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
 <td width="5%"><div align="left">&nbsp;&nbsp;<input type="submit" name="Submit2" value="ค้นหา"></div></td>
    </tr>
  </table>
  </form>
  </TD>
  </TR>
  <TR>
  <TD>
<TABLE cellSpacing=0 cellPadding=0 width=100%  height=500 align=center  border=0>
      <TBODY>
		<TR>
          <TD vAlign=top>
<table width="100%"  border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#ccdd3d" bordercolordark="#FFFFFF">
	<tr bgcolor="#336633">
   <td width="5%"  align=center ><font color="#FFFFFF"><B>ที่</B></font></td>
   <td  align=center width="45%"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
   <td width="15%"  align=center ><font color="#FFFFFF"><B>เริ่ม</B></font></td>
   <td width="15%"  align=center ><font color="#FFFFFF"><B>สิ้นสุด</B></font></td>
   <td width="15%" align=center ><font color="#FFFFFF"><B>ผู้ขออนุญาต</B></font></td>
   <td width="5%" align=center ><font color="#FFFFFF"><B>ดู</B></font></td>
	</tr>
<?
//	CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);
//แสดงข่าวสาร/ประชาสัมพันธ์ 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_APPROVAL,"id","$SQLwhere status='1' and  rachakan like '%$search%' and comment='อนุมัติ'  ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$rt = $SUMPAGE%$limit ;
$totalpage = ($rt!=0) ? floor($SUMPAGE/$limit)+1 : floor($SUMPAGE/$limit); 
$goto = ($page-1)*$limit ;

$res[approval] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE  status='1' and  rachakan like '%$search%' and comment='อนุมัติ'  ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[approval] = $db->fetch($res[approval])){

$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[approval][category]."'  ");
$arr[user] = $db->fetch($res[user]);

if ($i%2==0) 
{
				?><tr bgcolor="#F0FFFF"><?
			} else {
				?><tr bgcolor="#FFFFFF"><?
} ?>  

	      <td align="center"><IMG SRC="images/crut.png" width="20"></td> 
		  <td align="left"valign="top"><A HREF="javascript:NewWindow('popup2.php?name=approval&file=readapproval&id=<? echo $arr[approval][id]; ?>','acepopup','1024','720','center','front');"><? echo $arr[approval][rachakan]; ?></A></td>
		<td align="center"><?echo ("".thai_date_short(strtotime($arr[approval][date]))."" );?></td>
		<td align="center"><?echo ("".thai_date_short(strtotime($arr[approval][date1]))."" );?></td>
		<td align="center"><? echo $arr[approval][name]; ?><br></td>
		<td align="center"valign="top"><A HREF="javascript:NewWindow('popup2.php?name=approval&file=readapproval&id=<? echo $arr[approval][id]; ?>','acepopup','1024','720','center','front');"><img src="images/read.png"  width="20" align="middle" border="0" /></A></td>
  </tr>
<?
	$i++;
}
?>
</table>

				<?
				SplitPage($page,$totalpage,"?name=approval&file=tabainratchakan&search=$search");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
		  </TD>
        </TR>
    </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>