<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE align=center cellSpacing=0 cellPadding=0 width=100% height="390"border=0>
		<TBODY>
		<TR>
		<TD width="100%" vAlign=top>
<?
		$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=tkk7&file=tabainod">
  <table width=100%   border="0" align="right" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td width="700"  class="unnamed2"><div align="left"><A HREF="?name=tkk7&file=tabainod&category=<?echo $arr[user][sangkad];?>">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนส่งหนังสือราชการ ของ<?echo $arr[user][school];?></B></div></td>
		<td width="230"  align="right" ><div align="right"><strong>ระบุคำที่ต้องค้นหา</strong>&nbsp;&nbsp;</div></td>
		<td width="100"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
      <td width="70"><div align="left">&nbsp;&nbsp;<input type="submit" name="Submit2" value="ค้นหา"></div></td>
    </tr>
  </table>
  </form>
 </TD>
  </TR>
  <TR>
  <TD vAlign=top>
<TABLE align=center  cellSpacing=0 cellPadding=0 width=100% height="450"border=0>
      <TBODY>
        <TR>
          <TD vAlign=top >
<TABLE width="100%" align=center cellSpacing=0 cellPadding=0 border=0>
<form action="?name=admin&file=tkk7&op=tkk7_del&action=multidel" name="myform" method="post">
 <TABLE width="100%" cellspacing="2" cellpadding="1" >
		<TR bgcolor="#336633" height=25>
			<TD   align=center width="10"><font color="#FFFFFF"><B>ที่</B></font></TD>
			<TD   align=center width="140"><font color="#FFFFFF"><B>เลขหนังสือ</B></font></TD>
			<TD  align=center width="550"><font color="#FFFFFF"><B>เรื่อง</B></font></TD>
			<TD   width="120"  align=center ><font color="#FFFFFF"><B>วัน เดือน ปี</B></font></TD>
			<TD  align=center width="120"><font color="#FFFFFF"><B>ตรวจสอบการรับ</B></font></TD>
		</TR>  
 <?
		$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]);
		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[user][sangkad]."' ");
		$arr[usersch] = $db->fetch($res[usersch]);
//แสดงบทความ
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK7,"id","$SQLwhere topic like '%$search%' and posted='".$arr[usersch][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[tkk7] = $db->select_query("SELECT * FROM ".TB_TKK7." WHERE topic like '%$search%' and posted='".$arr[usersch][id]."'  ORDER BY post_date DESC LIMIT $goto, $limit   ");
$count=0;
$i=1;
while($arr[tkk7] = $db->fetch($res[tkk7]))
	{
	if ($count==0) { echo "<TR>"; }
	
?>
			<TR bgcolor="#E6FEDE">
			<TD align="center" ><?echo $arr[tkk7][id];?></TD> 
			<TD align="left" ><?echo $arr[tkk7][tabain];?></TD> 
			<TD valign="top"><?echo $arr[tkk7][topic];?></TD>    
			<TD align="center" > <?echo ("".thai_date_fullmonth(strtotime($arr[tkk7][date]))."" );?></TD> 
			<TD><CENTER><B><A HREF="?name=tkk7&file=readtkk7_od&id=<?echo $arr[tkk7][id];?>"><FONT COLOR="#FF0000" ><img src="images/View.png" /></FONT></a></CENTER></TD>
		</TR>
	<?
$count++;
$i++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
</TABLE>
		</TR>
		</TD>
		</TABLE>
		</FORM>	
<TABLE border="0" cellpadding="0" cellspacing="1" width="100%" align=center>
				<TR>
						<TD align=right>
<?
				SplitPage($page,$totalpage,"?name=tkk7&file=tabainod&search=$search");
				echo $ShowSumPages ;
				echo "<BR>";
				echo $ShowPages ;
?>
					</TD>
			</TR>
			</TBODY>
</TABLE>				
					</TD>
			</TR>
			</TBODY>
</TABLE>