<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
  <table width=100%  height=450 border="0" align="left" cellpadding="0" cellspacing="0">
    <tr >
		<td Valign="top" >
<form name="form3" method="post" action="?name=numbook&file=index">
  <table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
	<td align="left" width="60%" class="unnamed2"><A HREF="?name=numbook&file=index">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนเอกสาร <?=WEB_AREA;?></B></td>
	<td width="20%" class="unnamed2"><div align="right"><B>ระบุชื่อหนังสือที่ต้องการคันหา&nbsp;&nbsp;</B> </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>
<br>
<table width="100%"   border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#999999" bordercolordark="#FFFFFF">
	<tr height=25 bgcolor="#009900">
		<td  align=center width="50"><font color="#FFFFFF"><B>ลำดับที่</B></font></td>
		<td  align=center width="60"><font color="#FFFFFF"><B>ปี</B></font></td>
		<td  align=center width="450"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="100" align=center ><font color="#FFFFFF"><B>ว/ด/ป/</B></font></td>
		<td width="200"  align=center ><font color="#FFFFFF"><B>กลุ่ม</B></font></td>
		<td width="100"  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]);
		$res[category] = $db->select_query("SELECT * FROM ".TB_WORKING_CAT." WHERE id='".$arr[user][working]."'  ");
		$arr[category] = $db->fetch($res[category]);

$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_NUMBOOK,"id","$SQLwhere  year>0 and year like '%$search%' or year>0 and topic 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[numbook] = $db->select_query("SELECT * FROM ".TB_NUMBOOK." WHERE   year>0 and year like '%$search%' or year>0 and topic like '%$search%'  ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[numbook] = $db->fetch($res[numbook])){
 ?>
<tr bgcolor="FFFFFF" >
<td valign="top"align="center" ><? echo $arr[numbook][idtabain]; ?></td> 
			<td valign="top"align="center" ><? echo $arr[numbook][year]; ?></td> 
			<td valign="top"><? echo $arr[numbook][topic]; ?></td>
			<td valign="top"><CENTER><?echo ThaiTimeConvert($arr[numbook][post_date],'','');?></CENTER></td>
			<td valign="top"><CENTER><? echo $arr[numbook][kom]; ?></CENTER></td>
			<td valign="top"><CENTER>
			<?
					 if($arr[numbook][full_text]){ 	  
			?>
			<a href="data/numbook/<? echo $arr[numbook][full_text]; ?>" target="_blank"><b><img src="images/iconfile/pdf.gif" /></b> </a>
			<? } else {echo "";}?>
			</CENTER></td>
</td>
  </tr>
                                          <tr>
                                            <td colspan="6" height="1" class="dotline" color=FFFF00></td>
                                          </tr>

<?
}
?>
</table>	
				<?
				SplitPage($page,$totalpage,"?name=numbook&search=$search");
				echo $ShowSumPages ;	
				echo $ShowPages ;
				?> 
			</td>
			</tr>
			</table>