<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<?
$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[tkk1] = $db->select_query("SELECT * FROM ".TB_TKK1." $SQLwhere2  ");
$arr[tkk1] = $db->fetch($res[tkk1]);

$res[year] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." WHERE name='".$arr[tkk1][year]."' ");
$arr[year] = $db->fetch($res[year]);
?>
<form name="form3" method="post" action="?name=search&&file=tabainban&year=<?=$_GET[year];?> ">
  <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><B>&nbsp;&nbsp;<B>&nbsp;&nbsp;<B>ทะเบียนบันทึก ปี <? echo $arr[year][name]; ?></B></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>
<TABLE align=center cellSpacing=0 cellPadding=0 width=100% height="500"  border=0>
      <TBODY>
        <TR>
			<TD valign="top">
<TABLE width="100%" align=center cellSpacing=1 cellPadding=1 border=0>
  <tr bgcolor="#6dbae0" height=25>
   <td width="10%"  align=center ><font color="#FFFFFF"><B>เลขทะเบียน</B></font></td>
   <td  width="40%" align=center><font color="#FFFFFF"><B>เรื่อง</B></font></td>
   <td width="17%"  align=center ><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
   <td width="18%" align=center ><font color="#FFFFFF"><B>ผู้ผ่านแฟ้ม</B></font></td>
   <td width="10%" align=center ><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[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 = 15 ;
$SUMPAGE = $db->num_rows(TB_TKK1,"id","$SQLwhere  and  topic like '%$search%'   ");
$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[tkk1] = $db->select_query("SELECT * FROM ".TB_TKK1." $SQLwhere2 and  topic like '%$search%' ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk1] = $db->fetch($res[tkk1])){
 ?>
<tr bgcolor="#FFFFFF" >
     <td align="center" ><? echo $arr[tkk1][id];?></td> 
     <td align="left"valign="top"><IMG SRC="myoffice/<? echo $arr[tkk1][praphet];?>.png">&nbsp;&nbsp;<A HREF="javascript:NewWindow('popup2.php?name=tkk1&file=readtkk1&op=tkk1_read&id=<?echo $arr[tkk1][id];?>','acepopup','1024','720','center','front');"><?echo $arr[tkk1][topic];?></A>
<?
					 if($arr[tkk1][postedit]){ 	  
?>
<A HREF="?name=tkk1&file=add&op=tkk1_edit&id=<? echo $arr[tkk1][id];?>"><IMG SRC="myoffice/<?=$arr[tkk1][postedit];?>.jpg"></A>
<? } else {echo ""; }?>
</td>
 	 <td align="center"  >
	<?
	//ทำการเพิ่มจำนวนคนเข้าชม
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[tkk1][posted]."'  ");
	$arr[user] = $db->fetch($res[user]);
?>
	<? echo $arr[user][category_name];?><br><?echo ThaiTimeConvert($arr[tkk1][post_date],'','2');?>
	 </td>
	 <td align="center"  > 
 <?=$arr[tkk1][namecom];?>
 <br>
 <?
					 if($arr[tkk1][update_date]){ 	  
?>
  <?echo ThaiTimeConvert($arr[tkk1][update_date],'','2');?>
<? } else {echo "-";}?>
	 </td>
<td align="center"  >
<?=$arr[tkk1][comment1];?> 
<?=$arr[tkk1][comment3];?> 
<?
					 if($arr[tkk1][comment_b]){ 	  
?>
<IMG SRC="myoffice/<?=($arr[tkk1][comment_b]);?>.png">
<? } else {echo "";}?>
	 </td>
	 </tr>
<tr>
<td colspan="5" height="1" class="dotline" color=FFFF00></td>
</tr>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 			
</table>
				<?
				SplitPage($page,$totalpage,"?name=search&file=tabainban&year=".$arr[category][name]."&search=$search");
				echo $ShowSumPages ;	
				echo $ShowPages ;
				?> 	
		  </TD>
        </TR>
      </TBODY>
    </TABLE>