<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<SCRIPT LANGUAGE='JAVASCRIPT' TYPE='TEXT/JAVASCRIPT'>
 <!--
var win=null;
function NewWindow(mypage,myname,w,h,pos,infocus){
if(pos=="random"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}
else if((pos!='center' && pos!="random") || pos==null){myleft=0;mytop=20}
settings="width=" + w + ",height=" + h + ",top=" + mytop + ",left=" + myleft + ",scrollbars=yes,location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no";win=window.open(mypage,myname,settings);
win.focus();}
// -->
</script>
<TABLE cellSpacing=0 cellPadding=0 width=1005 height="500" border=0>
      <TBODY>
        <TR>
          <TD width="100%" 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]);
?>
		  <?
if($_GET[op] == "tkk1_group"){
	//////////////////////////////////////////// กรณีแก้ไข Form
	if(CheckLevelUser($_SESSION['user_user'], $_GET[op])){
{
	
?>	<!-- tkk4 -->
<form action="?name=admin&file=tkk1&op=tkk1_del&action=multidel" name="myform" method="post">
 <table width="100%" cellspacing="1" cellpadding="1" >
  <tr bgcolor="#336633" height=25>
   <td width="40"  align=center ><font color="#FFFFFF"><B>ประเภท</B></font></td>
   <td  width="450"align=center ><font color="#FFFFFF"><B>เรื่อง</B></font></td>
   <td width="170"  align=center ><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
   <td width="170" align=center ><font color="#FFFFFF"><B>ผู้ผ่านแฟ้ม</B></font></td>
   <td width="170" 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[kom]){
	$SQLwhere = " kom='".$_GET[kom]."' ";
	$SQLwhere2 = " WHERE kom='".$_GET[kom]."' ";
}
	$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 8 ;
$SUMPAGE = $db->num_rows(TB_TKK1,"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[tkk1] = $db->select_query("SELECT * FROM ".TB_TKK1." $SQLwhere2  ORDER BY id DESC LIMIT $goto, $limit   ");
$count=0;
while($arr[tkk1] = $db->fetch($res[tkk1]))
	{
	if ($count==0) { echo "<TR>"; }

	if ($i%2==0) 
			{
				?><tr bgcolor="#C9FBC8"><?
			} else {
				?><tr bgcolor="#E6FE99" ><?
			} 

?>

     <td align="center" >
      <IMG SRC="myoffice/<? echo $arr[tkk1][praphet];?>.png">
     </td> 
     <td valign="top"><A HREF="javascript:NewWindow('popup2.php?name=tkk1&file=readtkk1&id=<?echo $arr[tkk1][id];?>','acepopup','1024','720','center','front');"><?echo $arr[tkk1][topic];?></A><?=$CommentIcon;?><?=NewsIcon(TIMESTAMP, $arr[tkk1][post_date], "images/icon_new.gif");?>
	 <?
					 if($arr[tkk1][postedit]){ 	  
?>
<A HREF="?name=tkk1&file=add&op=tkk1_edit&id=<? echo $arr[tkk1][id];?>"><IMG SRC="myoffice/<?=$arr[tkk1][postedit];?>.jpg"></A>
		  <? } else {
		 echo "";
	 }?>
<?
 if($arr[tkk1][postedit_2]){ 	  
?>
<IMG SRC="myoffice/<?=$arr[tkk1][postedit_2];?>.jpg"></A>
		  <? } else {
		 echo "";
	 }?><?=$CommentIcon;?></td>
     <td > <CENTER><? echo $arr[tkk1][posted];?><br><?echo ThaiTimeConvert($arr[tkk1][post_date],'','2');?></CENTER></td>
	 <td align="center"  >
	 <?
					 if($arr[tkk1][comment]){ 	  
?>
<IMG SRC="myoffice/<?=$arr[tkk1][comment];?>.jpg">
		  <? } else {
		 echo "";
	 }?> 
	
	
 <?=$arr[tkk1][namecom];?><br>
	<?
					 if($arr[tkk1][update_date]){ 	  
?>
  <?echo ThaiTimeConvert($arr[tkk1][update_date],'','2');?>
		  <? } else {
		 echo "-";
	 }?>
	 </td>
<td align="center" Valign="top" >
<? echo $arr[tkk1][comment1];?> 
	 </td>
</tr>
	<?
$count++;
$i++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?> 				
				</table>
 </form>	
				
			</TD>
        </TR>
    </TABLE>	
<table border="0" cellpadding="0" cellspacing="1" width="100%" align=center>
					<tr>
						<td align=right>
				<?
				SplitPage($page,$totalpage,"?name=tkk1&file=bantokgroup&op=tkk1_group&category=".$_GET[category]."");
				echo $ShowSumPages ;
				echo "<BR>";
				echo $ShowPages ;
				?>
<?
	}
?>	
<?
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
else if($_GET[op] == "tkk1_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[tkk3] = $db->select_query("SELECT * FROM ".TB_TKK3." WHERE id='".$value."' ");
			$arr[tkk3] = $db->fetch($res[tkk3]);
			$db->del(TB_TKK3," id='".$value."' "); 

			@unlink("tkk3data/".$arr[tkk3][post_date].".txt");
			@unlink("tkk3icon/".$arr[tkk3][post_date].".jpg");
			@unlink("tkk3/".$arr[tkk3][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] == "tkk1_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[tkk3] = $db->select_query("SELECT * FROM ".TB_TKK3." WHERE id='".$_GET[id]."' ");
			$arr[tkk3] = $db->fetch($res[tkk3]);
			$db->del(TB_TKK3," id='".$_GET[id]."' "); 

			@unlink("tkk3data/".$arr[tkk3][post_date].".txt");
			@unlink("tkk3icon/".$arr[tkk3][post_date].".jpg");
			@unlink("tkk3/".$arr[tkk3][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=admin&file=tkk3\"><B>กลับหน้า จัดการขุมความรู้</B></A>";
		$ProcessOutput .= "</CENTER>";
		$ProcessOutput .= "<BR><BR>";
	}else{
		//กรณีไม่ผ่าน
		$ProcessOutput = $PermissionFalse ;
	}
	echo $ProcessOutput ;
}
?>
			</TD>
        </TR>
    </TABLE>	
		  </TD>
        </TR>
      </TBODY>
    </TABLE>