<?
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="100"><font color="#FFFFFF"><B>คำสั่งที่</B></font></td>
	<td  align=center width="500"><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="80"  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]);
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$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 catamp='".$arr[usersch][id]."' and full_text='' ORDER BY id DESC ");
$count=0;
while($arr[kamsang] = $db->fetch($res[kamsang]))
	{
 ?>
<tr bgcolor="#FFFFFF">
<td align="center" ><img src="images/krut.png" width="20"></td> 
<td align="left" ><?echo $arr[kamsang][idtabain];?>/<?echo $arr[kamsang][year];?></td> 
<td valign="top">&nbsp;&nbsp;<?echo $arr[kamsang][topic];?></a>
</td>
<td >  
<?
					 if($arr[kamsang][date2]){ 	  
?>
<div align="center"><?= ThaiTimeConvert($arr[kamsang][date2]);?></div>
<? } else {echo "-";}?>
</td>
<td > 
<?
					 if($arr[kamsang][date3]){ 	  
?>
<div align="center"><?= ThaiTimeConvert($arr[kamsang][date3]);?></div>
<? } else {echo "-";}?> 
</td>
<td valign="top"><CENTER> 
 <?
					 if($arr[kamsang][full_text]){ 	  
?>
<img src=" images/10.png" >
<? } else {
		 echo "<A HREF=\"?name=kamsang&file=addschool&op=kamsang_edit&id=" .$arr[kamsang][id]."\"><B><img src=\" images/sent.png\" width=30></B></a>";
}?>
</CENTER>
</td>
</tr>
<tr>
<td colspan="6" height="1" class="dotline" color=FFFF00></td>
</tr>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
</table>
</form>	
			</TD>
        </TR>
    </TABLE>	

		  </TD>
        </TR>
      </TBODY>
    </TABLE>