<?
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>
<?
//	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]);
?> 
<form name="form3" method="post" action="?name=tkk4&file=sentschool">
  <table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
<td align=left width="60%" class="unnamed2"><A HREF="?name=tkk4&file=sentschool">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<font color=red><B>ทะเบียนหนังสือราชการของ  <? echo $arr[user][category_name];?></font></B></td>
<td width="20%"><B>ระบุชื่อหนังสือหรือเลขทะเบียน</B></td>
<td width="15%"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
 <td width="5%"><div align="left"><input type="submit" name="Submit2" value="ค้นหา"></div></td>
    </tr>
  </table>
  </form>
<BR>
<table width="100%"  border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#ccdd3d" bordercolordark="#FFFFFF">
	<tr bgcolor="#009900">
   <td  align=center width="10%"><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="20%" align=center ><font color="#FFFFFF"><B>ถึง</B></font></td>
   <td width="5%"  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]);
//แสดง
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK4,"id","$SQLwhere  tabain like '%$search%'  and cat='".$arr[user][id]."' or tabain like '%$search%'  and posted='".$arr[user][category_name]."' or topic like '%$search%' and cat='".$arr[user][id]."' or topic like '%$search%' and posted='".$arr[user][category_name]."' ");
$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[tkk4] = $db->select_query("SELECT * FROM ".TB_TKK4." WHERE  tabain like '%$search%'  and cat='".$arr[user][id]."' or tabain like '%$search%'  and posted='".$arr[user][category_name]."' or topic like '%$search%' and cat='".$arr[user][id]."' or topic like '%$search%' and posted='".$arr[user][category_name]."' ORDER BY id DESC LIMIT $goto, $limit   ");

while($arr[tkk4] = $db->fetch($res[tkk4]))
	{
?>
<tr bgcolor="#FFFFFF">
	<td valign="top"><div align="left">&nbsp; <? echo $arr[tkk4][tabain]; ?></div></td>
    <td valign="top"><img src="images/krut.png" width=15 align="absmidd">&nbsp;&nbsp;<? echo $arr[tkk4][topic]; ?></td>
    <td valign="top"><CENTER><?echo ThaiTimeConvert($arr[tkk4][post_date],'','');?></CENTER></td>
	<td valign="top" ><? echo $arr[tkk4][group_ska];?></td>
	 <td valign="top">
	 <CENTER>
	<A HREF="popup.php?name=tkk4&file=readtkk4_1&id=<? echo $arr[tkk4][id];?>" onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 1024, objectHeight: 720} )" class="highslide"><IMG SRC="images/read.png" width="20"></A></CENTER></td>
	<td valign="top" align="center"><a href="?name=tkk4&file=editbackschool&op=tkk4_edit&id=<? echo $arr[tkk4][id];?>"><FONT COLOR=blue>ดึงกลับ<FONT></a></td>
  </tr>
<?
}
?>
</table>
&nbsp;&nbsp;
				<?
				SplitPage($page,$totalpage,"?name=tkk4&file=sentschool&search=$search");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>