<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE width=100%  align=center   cellSpacing=0 cellPadding=0 border=0>
 <TBODY> 
<TR>
<TD vAlign=top>
<?
//	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]);
?> 
<form name="form3" method="post" action="?name=tkk2&file=indexperson">
  <table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
	<td align=left width="60%" class="unnamed2"><A HREF="?name=tkk2&file=indexperson">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle"></A>&nbsp;&nbsp;<font color=red>ทะเบียนหนังสือราชการของ  <? echo $arr[user][category_name];?></font>
	</td>
	<td width="20%" align="right"><B>ระบุชื่อหนังสือ หรือ เลขทะเบียน&nbsp;&nbsp;</B></td>
	<td width="15%"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
	<td width="5%"align="left">&nbsp;&nbsp;<input type="submit" name="Submit2" value="ค้นหา"></td>
    </tr>
 </table>
  </form>
</TD>
</TR>
<TR>
<TD>
<TABLE width=100%   align=center  height=500 cellSpacing=0 cellPadding=0 border=0>
 <TBODY> 
<TR>
<TD vAlign=top>
<table width="100%"  border="0" align="center" cellpadding="0" cellspacing="1" >
	<tr bgcolor="#009900">
	<td  align=center width="5%"><font color="#FFFFFF"><B>เลขรับ</B></font></td>
	<td  align=center width="10%"><font color="#FFFFFF"><B>เลขทะเบียน</B></font></td>
	<td  align=center width="50%"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
	<td width="20%" align=center ><font color="#FFFFFF"><B>จาก</B></font></td>
    <td width="15%" align=center ><font color="#FFFFFF"><B>สั่งการ</B></font></td>
	<td width="5%" align=center ><font color="#FFFFFF"><B>อ่าน</B></font></td>
</tr>
<?
//แสดงข่าวสาร/ประชาสัมพันธ์ 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK2,"id","$SQLwhere tabain like '%$search%'  and cat='".$arr[user][id]."' or topic like '%$search%' and cat='".$arr[user][id]."' ");
$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[tkk2] = $db->select_query("SELECT * FROM ".TB_TKK2." WHERE tabain like '%$search%'  and cat='".$arr[user][id]."' or topic like '%$search%' and cat='".$arr[user][id]."'  ORDER BY id DESC LIMIT $goto, $limit ");
while($arr[tkk2] = $db->fetch($res[tkk2])){

$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK2_COMMENT." WHERE tkk2_id='".$arr[tkk2][id]."' ");
$arr[comment] = $db->fetch($res[comment]);
 ?>
<tr bgcolor="#FFFFFF">
		<td valign="top"><div align="left">&nbsp;<? echo $arr[tkk2][id]; ?></div></td>
		<td valign="top"><div align="left">&nbsp;<? echo $arr[tkk2][tabain]; ?></div></td>
		<td valign="top"><IMG SRC="myoffice/<? echo $arr[tkk2][praphet];?>.png" Width=10 Height=10 align="absmiddle">&nbsp;&nbsp;<? echo $arr[tkk2][topic]; ?></td>
		<td valign="top"><div align="left">&nbsp;<? echo $arr[tkk2][school]; ?></div></td>
		<td valign="top"align="center">	
<?
					 if(($arr[comment][edit]==ทราบ) OR ($arr[comment][edit]==ชอบ)  OR ($arr[comment][edit]==เอกสารมอบ) OR ($arr[comment][edit]==ลงนัด)OR($arr[comment][edit]==แจ้ง) OR ($arr[comment][edit]==มอบ)){ 	  
?>
<A HREF="javascript:NewWindow('popup2.php?name=tkk2&file=readsang&op=tkk2_edit&id=<? echo $arr[tkk2][id];?>','acepopup','1024','720','center','front');"><font color="blue">ดูรายละเอียด</FONT></A>
<? } else { echo "";}?>
</td>
	<td  valign="top" align="center"><A HREF="popup.php?name=tkk2&file=readtkk2_2&id=<? echo $arr[tkk2][id]; ?>" onclick="return hs.htmlExpand(this, { contentId: 'highslide-html', objectType: 'iframe', objectWidth: 800, objectHeight: 600} )" class="highslide"><img src="images/read.png" width="20"></A></div>
	</td>
  </tr>
                                          <tr>
                                            <td colspan="6" height="1" class="dotline"></td>
                                          </tr>
<?
}
?>
</table>
&nbsp;
				<?
				SplitPage($page,$totalpage,"?name=tkk2&file=indexperson&op=tkk2_read&search=$search&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
		  </TD>
        </TR>
    </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>