<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<link href="style_web.css" rel="stylesheet" type="text/css">

	<TABLE  align=center cellSpacing=0 cellPadding=0 width=100% height=500 border=0>
      <TBODY>
        <TR>
          <TD  vAlign=top>
<table width="100%">
                          <tr>
                            <td align="left"width="300">
							<br>
							<a href="userareaexcel.php" target="_blank"><img src="images/iconfile/excel.png"/></A> 
							</td>
						<td align="center""width="400">
							<br>
 <CENTER> ทะเบียนไปราชการของ<?echo $arr[user][category_name];?></CENTER>
</td>
							<td align="right""width="300">
							<br>
							<a href="?name=approval&file=sumarea&mount=1"><font color=red><b>กลับหน้าทะเบียน</b></font></A>
							</td>
							</tr>
							</table>

		  <?
if($_GET[op] == "approval_read"){
	//////////////////////////////////////////// กรณีแก้ไข Form
	if(CheckLevelUser($_SESSION['user_user'], $_GET[op])){
{
	
?><!-- user -->
				<TABLE width="1000" align=center cellSpacing=0 cellPadding=0 border=0>
<form action="?name=approval&file=mytabain&op=approval_del&action=multidel" name="myform" method="post">
 <table width="100%" cellspacing="2" cellpadding="1" >
  <tr bgcolor="#336633" height=25>
   <td width="20"  align=center ><font color="#FFFFFF"><B>ที่</B></font></td>
   <td  align=center width="450"><font color="#FFFFFF"><B>เรื่อง</B></font></td> 
   <td width="250"  align=center ><font color="#FFFFFF"><B>วัน/เดือน/ปี</B></font></td>
   <td width="220" align=center ><font color="#FFFFFF"><B>ผู้ขออนุญาต</B></font></td>
   <td width="120" 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]);
//แสดงบทความ
if($_GET[id]){
	$SQLwhere = "id  ='".$_GET[id]."' ";
	$SQLwhere2 = " WHERE id='".$_GET[id]."' ";
}
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_APPROVAL,"id","$SQLwhere");
$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[user] = $db->select_query("SELECT * FROM ".TB_user." $SQLwhere2 ORDER BY id DESC LIMIT $goto, $limit   ");
$count=0;
while($arr[user] = $db->fetch($res[user]))
	{

$res[approval] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE cat='".$arr[user][id]."'  or person like '%,".$arr[user][id].",%'  ORDER BY id DESC ");
while($arr[approval] = $db->fetch($res[approval]))
	{

		
	if ($count==0) { echo "<TR>"; }
?>	
			<tr bgcolor="#E6FEDE">
     <td align="center" ><? echo $arr[approval][id];?></td> 
     <td valign="top"><A HREF="javascript:NewWindow('popup2.php?name=approval&file=readapproval&id=<?echo $arr[approval][id];?>','acepopup','1024','720','center','front');"><?echo $arr[approval][topic];?></A></td> 
<td align="center" valign="top"><?echo ("".thai_date_short(strtotime($arr[approval][date]))."" );?> - <?echo ("".thai_date_short(strtotime($arr[approval][date1]))."" );?></td>

	 <td align="center"  ><?=$arr[approval][name];?><br>
	 </td>
<td align="center"  >
	
<?=$arr[approval][comment];?>
	
	 </td>
	 </TR>
	<?
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 
				</table>
		</TR>
		</TD>
		</TABLE>
				<table border="0" cellpadding="0" cellspacing="1" width="100%" align=center>
					<tr>
						<td>
				<?
				SplitPage($page,$totalpage,"?name=approval&file=checkperson&op=approval_read&cat=".$_GET[cat]."");
				echo $ShowSumPages ;
				echo $ShowPages ;
				?> 
					
			<!-- End tkk3 -->

<?
	}
?>	
<?
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "approval_del" AND $_GET[action] == "multidel"){
	//////////////////////////////////////////// กรณีลบ Multi
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
		while(list($key, $value) = each ($_POST['list'])){
			$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
			$res[approval] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE id='".$value."' ");
			$arr[approval] = $db->fetch($res[approval]);
			$db->del(TB_APPROVAL," id='".$value."' "); 

			@unlink("data/approval/".$arr[approval][full_text]);
			@unlink("data/approval/".$arr[approval][full_texts]);
			@unlink("data/approval/".$arr[approval][full_textu]);
			@unlink("data/approval/".$arr[approval][full_texto]);
			$db->closedb ();
		}
		$ProcessOutput .= "<BR><BR>";
		$ProcessOutput .= "<CENTER><A HREF=\"?name=user&file=main\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
		$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการลบเรียบร้อยแล้ว</B></FONT><BR><BR>";
		$ProcessOutput .= "<A HREF=\"?name=approval&file=mytabain&op=approval_read&category=<?=$arr[user][id];?> \"><B>กลับหน้า จัดการ</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "tkk3_del"){
	//////////////////////////////////////////// กรณีลบ Form
	if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
//		$db->del(TB_TKK3," id='".$_GET[id]."' ");
			$res[approval] = $db->select_query("SELECT * FROM ".TB_APPROVAL." WHERE id='".$_GET[id]."' ");
			$arr[approval] = $db->fetch($res[approval]);
			$db->del(TB_APPROVAL," id='".$_GET[id]."' "); 

			@unlink("data/approval/".$arr[approval][full_text]);
			@unlink("data/approval/".$arr[approval][full_texts]);
			@unlink("data/approval/".$arr[approval][full_textu]);
			@unlink("data/approval/".$arr[approval][full_texto]);
		$db->closedb ();
		$ProcessOutput .= "<BR><BR>";
		$ProcessOutput .= "<CENTER><A HREF=\"?name=admin&file=main\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
		$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการลบเรียบร้อยแล้ว</B></FONT><BR><BR>";
	$ProcessOutput .= "<A HREF=\"?name=approval&file=mytabain&op=approval_read&category=<?=$arr[user][id];?> \"><B>กลับหน้า จัดการ</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
?>

					</TD>
				</TR>
			</TABLE>
			<!-- Admin -->
		  </TD>
        </TR>
      </TBODY>
    </TABLE>