<?
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]);
		$res[category] = $db->select_query("SELECT * FROM ".TB_WORKGROUP_CAT." WHERE id='".$arr[user][workgroup]."'  ");
		$arr[category] = $db->fetch($res[category]);
?> 
<form name="form3" method="post" action="?name=kamsang&file=kamsanggroup">
  <table width=100%  border="0" align="left" cellpadding="0" cellspacing="0">
    <tr class="unnamed1">
<td align=left width="60%" class="unnamed2"><A HREF="?name=kamsang&file=kamsanggroup">&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<font color=red><B>ทะเบียนคำสั่ง ของ  <? echo $arr[category][category_name];?></font></B></td>
<td width="20%"align="right" ><B>ระบุชื่อหนังสือที่ต้องการค้นหา</B>&nbsp;&nbsp;</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>
<BR>
<table width="100%"  border="0" align="center" cellpadding="1" cellspacing="1" bordercolor="#ccdd3d" bordercolordark="#FFFFFF">
	<tr bgcolor="#6dbae0">
		<td  align=center width="5%"><font color="#FFFFFF"><B>แก้ไข </B></font></td>
		<td  align=center width="5%"><font color="#FFFFFF"><B>คำสั่งที่</B></font></td>
		<td  align=center width="40%"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="15%" align=center ><font color="#FFFFFF"><B>ตั้งแต่วันที่</B></font></td>
		<td width="15%"  align=center ><font color="#FFFFFF"><B>สั่ง ณ วันที่</B></font></td>
		<td width="20%"  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_WORKGROUP_CAT." WHERE id='".$arr[user][workgroup]."'  ");
		$arr[category] = $db->fetch($res[category]);
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_KAMSANG,"id","$SQLwhere topic like '%$search%' and kom='".$arr[category][category_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[kamsang] = $db->select_query("SELECT  id,  idtabain, year, topic, date, date1, kom,  full_text, full_texts, full_textu, full_texto, post_date, pageview , UNIX_TIMESTAMP(date) AS date2 , UNIX_TIMESTAMP(date1) AS date3  FROM ".TB_KAMSANG." WHERE topic like '%$search%' and kom='".$arr[category][category_name]."' ORDER BY id DESC LIMIT $goto, $limit   ");

while($arr[kamsang] = $db->fetch($res[kamsang]))
	{
 ?>
<tr bgcolor="#FFFFFF" >
	<td width="30" class="unnamed2"><div align="center"><A HREF="?name=kamsang&file=addedit&op=kamsang_edit&id=<?echo $arr[kamsang][id];?>"><B><img src=" images/admin/edit.gif" ></B></a> </div>
</td>
	<td width="70" class="unnamed2"><div align="center"><? echo $arr[kamsang][idtabain]; ?>/<? echo $arr[kamsang][year]; ?></div></td>
	<td class="unnamed2"><div align="left"><? echo $arr[kamsang][topic]; ?></div></td>
	<td valign="top"><div align="left">&nbsp;<?echo thai_date_fullmonth(strtotime($arr[kamsang][date]),'','');?></div></td>
	<td valign="top"><div align="left">&nbsp;<?echo thai_date_fullmonth(strtotime($arr[kamsang][date1]),'','');?></div></td>
	<td  valign="top" align="center">
<?
					 if($arr[kamsang][full_text]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_text];?>">ไฟล์ 1</A>,
<? } else {echo "ไม่มีไฟล์แนบ";}?>
 <?
					 if($arr[kamsang][full_texts]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_texts];?>">ไฟล์ 2</A>,
<? } ?>
 <?
					 if($arr[kamsang][full_textu]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_textu];?>">ไฟล์ 3</A>,
<? } ?>
 <?
					 if($arr[kamsang][full_texto]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_texto];?>">ไฟล์ 4</A>,
<? } ?>
</div>
</td>
</tr>
<tr>
<td colspan="6" height="1" class="dotline" color=FFFF00></td>
</tr>
<?
}
?>
</table>
				<?
				SplitPage($page,$totalpage,"?name=kamsang&file=kamsanggroup&op=kamsang_read");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
			</td>
			</tr>
			</table>