| Server IP : 104.21.80.248 / Your IP : 172.71.28.156 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myschool/laokhwan/modules/tkk1/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE align=center cellSpacing=0 cellPadding=0 width=100% height="500" border=0>
<TBODY>
<TR>
<TD valign="top">
<?
if($_GET[op] == "tkk1_read"){
//////////////////////////////////////////// กรณีแก้ไข Form
if(CheckLevelUser($_SESSION['user_user'], $_GET[op])){
{
?><!-- user -->
<TABLE width="100%" align=center cellSpacing=0 cellPadding=0 border=0>
<table width="100%" cellspacing="2" cellpadding="1" >
<tr bgcolor="#336633" height=25>
<td width="5%" align=center ><font color="#FFFFFF"><B>ประเภท</B></font></td>
<td width="35%" align=center><font color="#FFFFFF"><B>เรื่อง</B></font></td>
<td width="17%" align=center ><font color="#FFFFFF"><B>เจ้าของเรื่อง</B></font></td>
<td width="18%" align=center ><font color="#FFFFFF"><B>ผู้ผ่านแฟ้ม</B></font></td>
<td width="15%" 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]);
$res[category] = $db->select_query("SELECT * FROM ".TB_WORKING_CAT." WHERE id='".$arr[user][working]."' ");
$arr[category] = $db->fetch($res[category]);
//ดึงค่า
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[year] = $db->select_query("SELECT * FROM ".TB_YEARS_CAT." ORDER BY id DESC LIMIT 1 ");
$arr[year] = $db->fetch($res[year]);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 10 ;
$SUMPAGE = $db->num_rows(TB_TKK1,"id","$SQLwhere kom='".$arr[category][category_name]."' and year='".$arr[year][name]."' ");
$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." WHERE kom='".$arr[category][category_name]."' and year='".$arr[year][name]."' ORDER BY id DESC LIMIT $goto, $limit ");
$count=0;
while($arr[tkk1] = $db->fetch($res[tkk1])){
if ($count==0) { echo "<TR>"; }
//Check Comment
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK1_COMMENT." WHERE tkk1_id='".$arr[tkk1][id]."' ORDER BY id ");
$arr[comment] = $db->fetch($res[comment]);
if ($i%2==0)
{
?><tr bgcolor="#FFFFCC" class="unnamed1"><?
} else {
?><tr bgcolor="#FFFFFF" class="unnamed2"><?
} ?>
<td align="center" valign="top">
<IMG SRC="myoffice/<? echo $arr[tkk1][praphet];?>.png">
</td>
<td align="left"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>
<?
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 "";
}?>
</td>
<td align="center" >
<?
//ทำการเพิ่มจำนวนคนเข้าชม
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[tkk1][posted]."' ");
$arr[user] = $db->fetch($res[user]);
?>
<? echo $arr[user][category_name];?><br><?echo ThaiTimeConvert($arr[tkk1][post_date],'','2');?>
</td>
<td align="center" >
<?
//ทำการเพิ่มจำนวนคนเข้าชม
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$arr[tkk1][namecom]."' ");
$arr[user] = $db->fetch($res[user]);
?>
<?=$arr[user][category_name];?>
<br>
<?
if($arr[tkk1][update_date]){
?>
<?echo ThaiTimeConvert($arr[tkk1][update_date],'','2');?>
<? } else {echo "-";}?>
</td>
<td align="center" >
<?=$arr[tkk1][comment1];?>
<?=$arr[tkk1][comment3];?>
<?
if($arr[tkk1][comment_b]){
?>
<IMG SRC="myoffice/<?=($arr[tkk1][comment_b]);?>.png">
<? } else {
echo "";
}?>
</td>
</TR>
<?
$i++;
?>
<?
$count++;
if (($count%1) == 0) { echo ""; $count=0; }
}
$db->closedb ();
//จบการแสดงข่าวสาร
?>
<!-- End tkk3 -->
</table>
</form>
</TR>
</TD>
</TABLE>
<table border="0" cellpadding="0" cellspacing="1" width="100%" align=center>
<tr>
<td>
<?
SplitPage($page,$totalpage,"?name=tkk1&file=tabaingroup&op=tkk1_read&&category=".$_GET[category]."");
echo $ShowSumPages ;
echo $ShowPages ;
?>
</td>
<td align=right>
<!-- End tkk3 -->
<?
}
?>
<?
}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[tkk1] = $db->select_query("SELECT * FROM ".TB_TKK1." WHERE id='".$value."' ");
$arr[tkk1] = $db->fetch($res[tkk1]);
$db->del(TB_TKK1," id='".$value."' ");
@unlink("tkk1data/".$arr[tkk1][post_date].".txt");
@unlink("tkk1/".$arr[tkk1][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=tkk1&file=indexsent\"><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[tkk1] = $db->select_query("SELECT * FROM ".TB_TKK1." WHERE id='".$_GET[id]."' ");
$arr[tkk1] = $db->fetch($res[tkk1]);
$db->del(TB_TKK1," id='".$_GET[id]."' ");
@unlink("tkk1data/".$arr[tkk1][post_date].".txt");
@unlink("tkk1/".$arr[tkk1][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=tkk1&file=indexsent\"><B>กลับหน้าบันทึกของฉัน</B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
?>
</TD>
</TR>
</TABLE>
<!-- Admin -->
</TD>
</TR>
</TBODY>
</TABLE>