<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100%  height=500 align=center  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=tkk1&file=indexsent">

  <table width=100%  bgcolor=FFFFCC border="0" align="left" cellpadding="0" cellspacing="0">
    <tr>
		<td align=left width="60%" class="unnamed2"><A HREF="?name=tkk1&file=indexsent">&nbsp;&nbsp;<img src="images/top.png"width=32 align="absmiddle" ></A>&nbsp;&nbsp;<B>ทะเบียนบันทึกเสนอแฟ้มของ  <? echo $arr[user][category_name];?></font></B></td>
		<td width="20%"><B>ระบุชื่อหนังสือที่ต้องการค้นหา</B></td>
		<td width="15%"><input name="search" type="text" id="search" value="<?=$_GET["search"];?>"></td>
		 <td width="5%"><div align="left">&nbsp;&nbsp;<input type="submit" name="Submit2" value="ค้นหา"></div></td>
    </tr>
  </table>

  </form>
<?
$strSQL = "SELECT * FROM ".TB_TKK1." where posted='".$arr[user][id]."' and topic like '%$search%'  ";
?>
<BR>
<table width="100%"  border="0" align="center" cellpadding="1" cellspacing="1" >
	<tr bgcolor="#009900">
     <td width="5%"  align=center ><font color="#FFFFFF"><B>ประเภท</B></font></td>
   <td  width="55%"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>
	<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>  
<tr>
<td>


<?
//แสดงข่าวสาร/ประชาสัมพันธ์ 
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK1,"id","$SQLwhere  posted='".$arr[user][id]."' 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." WHERE posted='".$arr[user][id]."' and topic like '%$search%'  ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk1] = $db->fetch($res[tkk1])){
	//Check Comment
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
	$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK1_COMMENT." WHERE tkk1_id='".$arr[tkk1][id]."' ORDER BY id ");
	$arr[comment] = $db->fetch($res[comment]);
 ?>

<tr bgcolor="#FFFFFF">
	<td align="center" ><IMG SRC="myoffice/<? echo $arr[tkk1][praphet]; ?>.png"></td> 
	<td valign="top"align="left">&nbsp;<? echo $arr[tkk1][topic]; ?></td>
	<td align="center">&nbsp;
<?
					 if($arr[tkk1][comment]){ 	  
?>
<A HREF="?name=tkk1&file=sent&op=tkk1_edit&id=<? echo $arr[tkk1][id]; ?>"><IMG SRC="myoffice/<? echo $arr[tkk1][comment]; ?>.gif"></A>
<? } else {echo "";}?>
<?
					 if($arr[tkk1][comment1]){ 	  
?>
<? echo $arr[tkk1][comment1]; ?>
<? } else {echo "";}?>
<?
					 if($arr[tkk1][comment2]){ 	  
?>
<? echo $arr[tkk1][comment2]; ?>
<? } else {echo "";}?>
<?
					 if($arr[tkk1][comment3]){ 	  
?>
<? echo $arr[tkk1][comment3]; ?>
<? } else {echo "";}?>
<?
					 if($arr[tkk1][comment_b]){ 	  
?>
<A HREF="?name=tkk1&file=sent&op=tkk1_edit&id=<? echo $arr[tkk1][id];?>"><IMG SRC="myoffice/<? echo $arr[tkk1][comment_b]; ?>.png"></A>
<? } else {echo "";}?>
<?
					 if($arr[tkk1][postedit]){ 	  
?>
<IMG SRC="myoffice/<? echo $arr[tkk1][postedit]; ?>.gif">
<? } else {echo ""; }?>
	 </td>
     <td align="center" >&nbsp;
	 <A HREF="javascript:NewWindow('popup2.php?name=tkk1&file=readtkk1&id=<? echo $arr[tkk1][id]; ?>','acepopup','1024','760','center','front');"><img src="images/read.png" width=20/></A>
	 </td>
	<td  align="center">&nbsp;
<?
					 if($arr[tkk1][comment1]=='แก้ไข'){ 	  
?>
<A HREF="?name=tkk1&file=bookperson&op=tkk1_edit&id=<? echo $arr[tkk1][id]; ?>">จัดการแก้ไข</A>
<? } else {echo "";}?>	
 <?
					 if($arr[tkk1][rabob]){ 	  
?>
<A HREF="?name=tkk1&file=tabain2&op=tkk1_edit&id=<? echo $arr[tkk1][id];?>"><IMG SRC="myoffice/<? echo $arr[tkk1][rabob]; ?>.gif"></A>
<? } else {echo "";}?>
<?
	if  (($arr[tkk1][category]!=$arr[user][id])and($arr[tkk1][rabob]!=30)){
 ?>
<A HREF="?name=tkk1&file=readback&op=tkk1_edit&id=<? echo $arr[tkk1][id]; ?>">ดึงกลับ</A>		
<? } ?>	
<?
					 if($arr[tkk1][comment_b]){ 	  
?>
<A HREF="?name=tkk1&file=tabain&op=tkk1_edit&id=<? echo $arr[tkk1][id]; ?>">ดำเนินการต่อ</A>
<? } else {echo ""; }?>
<?
					 if($arr[tkk1][comment3]){ 	  
?>
<A HREF="?name=tkk1&file=tabain&op=tkk1_edit&id=<? echo $arr[tkk1][id]; ?>">จัดเก็บ</A>
<? } else {echo "";}?>
</td>
 <td align="center" >
<?if($_SESSION['user_user']){echo " <A HREF=\"?name=tkk1&file=index&op=tkk1_del&id=".$arr[tkk1][id]."\"><IMG SRC=\"images/delete.png\"   BORDER=\"0\" ALIGN=\"absmiddle\"></A>";};?>
     </td>
  </tr>
<?
}
?>
</table>
				<?
				SplitPage($page,$totalpage,"?name=tkk1&file=indexsent&op=tkk1_read&category=".$_GET[category]."");
				echo $ShowSumPages ;	
				echo $ShowPages ;
				?> 
		  </TD>
        </TR>
      </TBODY>
    </TABLE>
</html>