<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']);
?>

	<TABLE cellSpacing=0 cellPadding=0 width="100%"  height=345 border=0>
      <TBODY>
        <TR>
          <TD vAlign=top>	  
		  <?
if($_GET[op] == "tkk6_read"){
	//////////////////////////////////////////// กรณีแก้ไข Form
	if(CheckLevelUser($_SESSION['user_user'], $_GET[op])){
{

//ดึงค่า
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
		$res[yearla] = $db->select_query("SELECT * FROM ".TB_YEARLA_CAT." ORDER BY id ");
		$arr[yearla] = $db->fetch($res[yearla]);		
?>
		
				<TABLE width="100%" align=center cellSpacing=0 cellPadding=0 border=0 >
<form action="?name=admin&file=tkk6&op=tkk6_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="350"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
   <td width="250"  align=center ><font color="#FFFFFF"><B>ว/ด/ป ที่ลา</B></font></td>
   <td width="200" align=center ><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
   <td width="150" align=center ><font color="#FFFFFF"><B>สถานะ</B></font></td>
   <td width="60" align=center ><font color="#FFFFFF"><B>จัดเก็บ</B></font></td>
  </tr>  
<?
//แสดงข่าวสาร/ประชาสัมพันธ์ 
if($_GET[category]){
	$SQLwhere = " category='".$_GET[category]."' ";
	$SQLwhere2 = " WHERE category='".$_GET[category]."' ";
}
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 15 ;
$SUMPAGE = $db->num_rows(TB_TKK6,"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[tkk6] = $db->select_query("SELECT * FROM ".TB_TKK6."  $SQLwhere2 and yearla='".$arr[yearla][name]."'  ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk6] = $db->fetch($res[tkk6])){
	if ($count==0) { echo "<TR>"; }

  if ($i%2==0) 
{
	?><tr bgcolor="#C9FBC8" class="unnamed1"><?
} else {
	?><tr bgcolor="#E6FE99" class="unnamed2"><?
} ?>
     <td align="center" >
      <IMG SRC="myoffice/100.png">
     </td> 
     <td valign="top"><A HREF="?name=tkk6&file=readtkk6&id=<?echo $arr[tkk6][id];?> "target="_blank"><?echo $arr[tkk6][topic];?></A></td>
   <td align="center"  ><?echo ("".thai_date_short(strtotime($arr[tkk6][date1]))."" );?> - <?echo ("".thai_date_short(strtotime($arr[tkk6][date2]))."" );?></td>
 <td align="center"  ><? echo $arr[tkk6][posted];?></td>
<td align="center"  >
<?=$arr[tkk6][comment1];?>
<?=$arr[tkk6][comment3];?>
	
	 </td>
<td  align="center"  >
	
 <?
					 if($arr[tkk6][rabob]){ 	  
?>
<A HREF="?name=tkk6&file=tabain2&op=tkk6_edit&id=<? echo $arr[tkk6][id];?>"><IMG SRC="myoffice/<?=$arr[tkk6][rabob];?>.gif"></A>
		  <? } else {
		 echo "";
	 }?>

	 </td></TR>
<?
	$i++;

?>
	<?
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 				
			<!-- End tkk3 -->

				</table>

 </form>		</TR></TD></TABLE>
				<BR>
				<table border="0" cellpadding="0" cellspacing="1" width="100%" align=right>
					<tr>
						<td>แสดงหน้า
				<?
				SplitPage($page,$totalpage,"?name=tkk6&op=tkk6_read&category=".$_GET[category]."");
			echo $ShowPages ;
				?> 

					
			<!-- End tkk3 -->
<?
	}
?>	

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

			@unlink("tkk6data/".$arr[tkk6][post_date].".txt");
			@unlink("tkk6icon/".$arr[tkk6][post_date].".jpg");
			@unlink("tkk6/".$arr[tkk6][full_text]);
			$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=user&file=tkk3\"><B>กลับหน้า จัดการ</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "tkk6_del"){
	//////////////////////////////////////////// กรณีลบ Form
	if(CheckLevel($_SESSION['user_user'],$_GET[op])){
		$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
//	$db->del(TB_TKK3," id='".$_GET[id]."' ");
			$res[tkk6] = $db->select_query("SELECT * FROM ".TB_TKK6." WHERE id='".$_GET[id]."' ");
			$arr[tkk6] = $db->fetch($res[tkk6]);
			$db->del(TB_TKK6," id='".$_GET[id]."' "); 

			@unlink("tkk6data/".$arr[tkk6][post_date].".txt");
			@unlink("tkk6icon/".$arr[tkk6][post_date].".jpg");
			@unlink("tkk6/".$arr[tkk6][full_text]);
		$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=tkk6&file=index\"><B>กลับหน้าู้</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
?>

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