<?
CheckUsersch($_SESSION['usersch_user'], $_SESSION['usersch_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height="500" 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]);
?> 
&nbsp;&nbsp;<img src="images/back.png" align="absmiddle" ></A>&nbsp;&nbsp;<font color=red><B>แฟ้มจัดทำคำสั่ง ของ <? echo $arr[user][category_name];?></font></B>
<form action="?name=admin&file=kamsang&op=kamsang_del&action=multidel" name="myform" method="post">
 <table width="100%" cellspacing="1" cellpadding="1" >
  <tr bgcolor="#6dbae0" height=25>
		<td  align=center width="20"><font color="#FFFFFF"><B>แก้ไข</B></font></td>
		<td  align=center width="80"><font color="#FFFFFF"><B>คำสั่งที่</B></font></td>
		<td  align=center width="450"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
		<td width="150" align=center ><font color="#FFFFFF"><B>ตั้งแต่วันที่</B></font></td>
		<td width="150"  align=center ><font color="#FFFFFF"><B>สั่ง ณ วันที่</B></font></td>
		<td width="150"  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]);
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_KAMSANG,"id","$SQLwhere cate='".$arr[user][id]."'");
$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 * FROM ".TB_KAMSANG." WHERE catamp='".$arr[usersch][id]."' ORDER BY id DESC LIMIT $goto, $limit   ");
$count=0;
while($arr[kamsang] = $db->fetch($res[kamsang]))
	{
?>
<tr bgcolor="#FFFFFF">
<td width="30" ><div align="center"><A HREF="?name=kamsang&file=addschool&op=kamsang_edit&id=<?echo $arr[kamsang][id];?>"><B><img src=" images/admin/edit.gif" ></B></a> </div>
</td>
<td align="left" ><?echo $arr[kamsang][idtabain];?>/<?echo $arr[kamsang][year];?></td> 
<td valign="top">&nbsp;&nbsp;<?echo $arr[kamsang][topic];?></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"><CENTER> 
 <?
					 if($arr[kamsang][full_text]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_text];?>" target="_blank">ไฟล์ 1</A>,
<? } else {echo "ไม่มีไฟล์แนบ";}?>
 <?
					 if($arr[kamsang][full_texts]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_texts];?>" target="_blank">ไฟล์ 2</A>,
<? } ?>
 <?
					 if($arr[kamsang][full_textu]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_textu];?>" target="_blank">ไฟล์ 3</A>
<? } ?>
 <?
					 if($arr[kamsang][full_texto]){ 	  
?>
<a href="data/kamsang/<?echo $arr[kamsang][full_texto];?>" target="_blank">ไฟล์ 4</A>,
<? } ?>
</CENTER>
</td>
</tr>
<tr>
<td colspan="6" height="1" class="dotline" color=FFFF00></td>
</tr>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
</table>
</form>				

				<?
				SplitPage($page,$totalpage,"?name=kamsang&file=tabainuser&op=kamsang_read&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?>
			</TD>
        </TR>
    </TABLE>	
		  </TD>
        </TR>
      </TBODY>
    </TABLE>