| 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/ratrard/modules123456/approval/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<link href="style_web.css" rel="stylesheet" type="text/css">
<TABLE cellSpacing=0 cellPadding=0 width=100% height=500 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<table width="100%">
<tr>
<td align="left"width="20%">
<br>
<?
if (($arr[user][work]=='11')AND($arr[user][status]==1)){ // ตรวจสิทธิ์และผอ.กลุ่ม============================
?>
<a href="?name=approval&file=report"><font color=red><b>กลับหน้าทะเบียน</b></font></A>
<?
}
?>
<?
if (($arr[user][level]=='3')AND($arr[user][status]==4)){ // ตรวจสิทธิ์และผอ.กลุ่ม============================
?>
<a href="?name=approval&file=reportyear&op=approval_read&sangkad=<?echo $arr[user][sangkad];?>"><font color=red><b>กลับหน้าทะเบียน</b></font></A>
<?
}
?>
</td>
<?
if($_GET[id]){
$SQLwhere = "id ='".$_GET[id]."' ";
$SQLwhere3 = " WHERE id='".$_GET[id]."' ";
}
$res[user] = $db->select_query("SELECT * FROM ".TB_user." $SQLwhere3 ORDER BY id DESC LIMIT 1 ");
while($arr[user] = $db->fetch($res[user]))
{
?>
<td align="left""width="80%"><br> ทะเบียนไปราชการ เดือนธันวาคม ของ<?echo $arr[user][category_name];?></td>
</tr>
</table>
<?
}
?>
<?
if($_GET[op] == "approval_read"){
//////////////////////////////////////////// กรณีแก้ไข Form
if(CheckLevelUser($_SESSION['user_user'], $_GET[op])){
{
?><!-- user -->
<TABLE width="100%" 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="5%" align=center ><font color="#FFFFFF"><B>ที่</B></font></td>
<td align=center width="45%"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
<td width="20%" align=center ><font color="#FFFFFF"><B>วัน/เดือน/ปี</B></font></td>
<td width="20%" align=center ><font color="#FFFFFF"><B>ผู้ขออนุญาต</B></font></td>
<td width="10%" 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]."' and date LIKE '____-12-__' and comment='อนุมัติ' or person like '%,".$arr[user][id].",%' and comment='อนุมัติ' 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>