<?
CheckUsersch($_SESSION['usersch_user'], $_SESSION['usersch_pwd']);
?>
<TABLE align=center  cellSpacing=0 cellPadding=0 width=100% border=0>
      <TBODY>
        <TR>
          <TD vAlign=top >
<?
//	CheckUser($_SESSION['user_user']);
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE username='".$_SESSION['usersch_user']."' ");
		$arr[usersch] = $db->fetch($res[usersch]);
?> 
<form name="form3" method="post" action="?name=tkk7&file=search">
  <table width=100%   border="0" align="right" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
		<td width="700"  class="unnamed2"><div align="left"><A HREF="?name=tkk7&file=rub7&category=<?echo $arr[usersch][id];?>">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนรับหนังสือราชการจากหน่วยงานในระบบ ของ<?echo $arr[usersch][name];?></B></div></td>
		<td width="230"  align="right" ><div align="right"><strong>ระบุคำที่ต้องค้นหา</strong>&nbsp;&nbsp;</div></td>
		<td width="100"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
      <td width="70"><div align="left">&nbsp;&nbsp;<input type="submit" name="Submit2" value="ค้นหา"></div></td>
    </tr>
  </table>
  </form>
</TD>
</TR>
<TR>
<TD>
<TABLE align=center  cellSpacing=0 cellPadding=0 width=100% height="450"border=0>
      <TBODY>
        <TR>
          <TD vAlign=top >
<TABLE width="100%" align=center cellSpacing=1 cellPadding=1 border=0>
  <tr bgcolor="6dbae0" height=25>
		<td  align=center width="15"><font color="#FFFFFF"><B></B></font></td>
		<td  align=center width="100"><font color="#FFFFFF"><B>ที่ ศธ</B></font></td>
		<td  align=center width="400"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="200"  align=center ><font color="#FFFFFF"><B>จาก</B></font></td>
		<td width="90" 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[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE username='".$_SESSION['usersch_user']."' ");
		$arr[usersch] = $db->fetch($res[usersch]);

//แสดงบทความ
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK7_COMMENT,"id","$SQLwhere catno ='".$arr[usersch][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[comment] = $db->select_query("SELECT * FROM ".TB_TKK7_COMMENT." WHERE catno ='".$arr[usersch][id]."'  ORDER BY tkk7_id DESC LIMIT $goto, $limit ");
$i=1;
while($arr[comment] = $db->fetch($res[comment]))
	{
		$res[tkk7] = $db->select_query("SELECT * FROM ".TB_TKK7." WHERE id ='".$arr[comment][tkk7_id]."' ");
		$arr[tkk7] = $db->fetch($res[tkk7]);

		$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[tkk7][posted]."' ");
		$arr[usersch] = $db->fetch($res[usersch]);
			if ($i%2==0) 
			{
					?><tr bgcolor="#F0FFFF"><?
			} else {
				?><tr bgcolor="#F8F8FF"><?
} ?>  		
			<td valign="top"align="center" ><IMG SRC="images/krut.png" width="15"></td> 
			<td valign="top"><?echo $arr[tkk7][tabain];?></td> 
			<td valign="top"><IMG SRC="myoffice/<? echo $arr[tkk7][praphet];?>.png" Width=10 Height=10>&nbsp;&nbsp;<?echo $arr[tkk7][topic];?></td>
			<td valign="top"><CENTER><? echo $arr[usersch][name];?></CENTER></td>
			<td valign="top"><CENTER><a href="?name=tkk7&file=readtkk7_2&id=<?echo $arr[tkk7][id];?>"><img src="images/read.png" width=20/></A></CENTER></td>
			<td valign="top"><CENTER> <font color="#339900"> รับแล้ว</font></CENTER></td>
		</tr>
<?
$i++;
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 																																
</table>
 </form>		
				<?
				SplitPage($page,$totalpage,"?name=tkk7&file=rub7&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
 </TR>
 </TD>
 </TABLE>
		  </TD>
        </TR>
      </TBODY>
    </TABLE>