<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=395 border=0 >
      <TBODY>
        <TR>
          <TD  vAlign=top>
		<form name="form3" method="post" action="?name=number&file=index">
		<table width=100% border="0" align="left" cellpadding="0" cellspacing="0">
			<tr class="unnamed1">
				<td width="60%" class="unnamed2"><A HREF="?name=number&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"><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>
<br>
<table width="100%"   border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#999999" bordercolordark="#000000">
	<tr bgcolor="#6fd1dc">
		<td width="20" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">ปี</div></font></td>
		<td width="120" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">ฉบับที่</div></font></td>
		<td class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">เรื่อง</div></font></td>
		<td width="150" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">วัน-เดือน-ปี</div></font></td>
		<td width="200"  align=center ><font color="#FFFFFF"><B>กลุ่ม</B></font></td>
		<td width="100" class="unnamed2"><font color="#FFFFFF"><div align="center" class="style3">ไฟล์แนบ</div></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]);

		$res[year] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id DESC LIMIT 1 ");
		$arr[year] = $db->fetch($res[year]);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_NUMBER,"id","$SQLwhere  year>0 and year like '%$search%' and year='".$arr[year][name]."' or year>0 and topic like '%$search%' and year='".$arr[year][name]."' ");
$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[number] = $db->select_query("SELECT * FROM ".TB_NUMBER." WHERE  year>0 and year like '%$search%' and year='".$arr[year][name]."' or year>0 and topic like '%$search%' and year='".$arr[year][name]."' ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[number] = $db->fetch($res[number])){
 ?>
<tr bgcolor="FFFFFF" >
<td width="70" class="unnamed2"><div align="center"><? echo $arr[number][year]; ?></div></td>
    <td width="70" class="unnamed2"><div align="center"><?echo $arr[number][number1];?> - <?echo $arr[number][number2];?></div></td>
	<td class="unnamed2"><div align="left"><? echo $arr[number][topic]; ?></td>
	<td width="150"class="unnamed2">
	<div align="center"><?echo ThaiTimeConvert($arr[number][post_date],'','');?></div></td>
	<td valign="top"><CENTER><? echo $arr[number][kom]; ?></CENTER></td>
	<td class="unnamed2"><div align="left">&nbsp;
<?
					 if($arr[number][full_text]){ 	  
?>
<a href="data/number/<? echo $arr[number][full_text]; ?> " target="_blank"><b>ไฟล์ที่ 1</b></A> , 
		  <? } else {
		 echo "ไม่มีไฟล์แนบ";
	 }?>
	</div>
	</td>
  </tr>
                                          <tr>
                                            <td colspan="6" height="1" class="dotline" color=FFFF00></td>
                                          </tr>
<?
}
?>

<tr>
	<td colspan="6">
				<?
				SplitPage($page,$totalpage,"?name=number&search=$search");
				echo $ShowSumPages ;	
				echo $ShowPages ;
				?> 
			<br><font color="#FFFFFF">.</font>
		</td>
	</tr>
</table>