<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE width=100%   border="0" align="left" cellpadding="0" cellspacing="0">
    <TR>
		<TD 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]);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
if($_GET[year]){
	$SQLwhere = " year='".$_GET[year]."' ";
	$SQLwhere2 = " WHERE year='".$_GET[year]."' ";
}

$res[tkk4] = $db->select_query("SELECT * FROM ".TB_TKK4." $SQLwhere2  ");
$arr[tkk4] = $db->fetch($res[tkk4]);

$res[category] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." WHERE name='".$arr[tkk4][year]."' ");
$arr[category] = $db->fetch($res[category]);
?>
<form name="form3" method="post" action="?name=search&&file=tabainsentsema&op=read&year=<? echo $arr[category][name]; ?> ">
  <table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td  width="60%" class="unnamed2"><A HREF="?name=search&file=from">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>&nbsp;&nbsp;<B>ทะเบียนส่งหนังสือราชการ ปี <? echo $arr[category][name]; ?></B></td>
		<td width="20%" class="unnamed2"><div align="right"><strong>ระบุชื่อหนังสือที่ต้องการค้นหา&nbsp;&nbsp;</strong></div></td>
		<td align="right" width="15%"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
      <td width="5%"><div align="right"><input type="submit" name="Submit2" value="ค้นหา">&nbsp;&nbsp;</div></td>
    </tr>
  </table>
  </form>
  </TD>
  </TR>
  <TR>
  <TD>
<table width=100%  height=500 border="0" align="left" cellpadding="0" cellspacing="0">
    <tr>
		<td Valign="top" >
<table width="100%"  border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#000000" >
	<tr bgcolor="#6dbae0">
		<td width="10%" align="center"><font color="#FFFFFF">เลขหนังสือ</font></td>
		<td width="40%" align="center"><font color="#FFFFFF">เรื่อง</font></td>
		<td width="15%" align="center"><font color="#FFFFFF">วัน เดือน ปี</font></td>
		<td width="15%" align="center"><font color="#FFFFFF">จาก</font></td>
		<td width="20%"align="center"><font color="#FFFFFF">ถึง</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[category] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id ");
		$arr[category] = $db->fetch($res[category]);
?>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
if($_GET[year]){
	$SQLwhere = " year='".$_GET[year]."' ";
	$SQLwhere2 = " WHERE year='".$_GET[year]."' ";
}
//แสดงบทความ
$limit = 20 ;
$SUMPAGE = $db->num_rows(TB_TKK4,"id","$SQLwhere (topic like '%$search%' or tabain like '%$search%')   ");
$page=$_GET[page];
if (empty($page)){
	$page=1;
}
$search=$_POST[search];
$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." $SQLwhere2 and  (topic like '%$search%' or tabain like '%$search%')  ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
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"><div align="left">&nbsp;&nbsp;<A HREF="?name=tkk4&file=readtkk4_3&id=<? echo $arr[tkk4][id]; ?>">&nbsp;<?echo $arr[tkk4][topic]; ?></A></div></td>
	<td align="center" valign="top"><?echo thai_date_fullmonth(strtotime($arr[tkk4][date]),'','');?></td>
	<td valign="top"><div align="left">&nbsp;<?=WEB_AREA;?></div></td>
	<td valign="top"><div align="left">&nbsp;<?echo $arr[tkk4][group_ska]; ?></div></td>
  </tr>
            <tr>
             <td colspan="5" height="1" class="dotline" color=FFFF00></td>
            </tr>
<?
}
?>
</table>
&nbsp;&nbsp;
				<?
				SplitPage($page,$totalpage,"?name=search&file=tabainsentsema&op=tkk4_read&year=".$arr[category][name]."&search=$search");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
		  </TD>
        </TR>
    </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>