| Server IP : 104.21.80.248 / Your IP : 172.71.28.155 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/chongphran/modules/user/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<table cellspacing="0" cellpadding="0" width="100%" height=420 border="0">
<tbody>
<tr>
<td align="left"Valign="top">
<br>
<b><img src="images/icon/plus.gif" border="0" align="absmiddle" />จัดการผู้อนุญาตการลา
<br >
<!-- แสดงผลรายการ -->
<?
//////////////////////////////////////////// แสดงรายชื่อ
if($_GET[op] == ""){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$limit = 200 ;
$SUMPAGE = $db->num_rows(TB_user,"id","level ='4' and status='1' ");
$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 ;
?>
<form action="?name=admin&file=user_cp&op=user_del&action=multidel" method="post" name="myform" id="myform">
<table width="100%" align="center" cellspacing="2" cellpadding="1" >
<tr bgcolor="#990000" height="25">
<td><div align="center"><font color="#FFFFFF"><b>ชื่อผู้ใช้</b></font></div></td>
<td><div align="center"><font color="#FFFFFF"><b>ชื่อ - นามสกุล</b></font></div></td>
<td><div align="center"><font color="#FFFFFF"><b>ตำแหน่ง</b></font></div></td>
<td><div align="center"><font color="#FFFFFF"><b>สถานะ</b></font></div></td>
<td><div align="center"><font color="#FFFFFF"><b>แก้ไข</b></font></div></td>
</tr>
<?
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE work between 3 and 4 and status='1' or work ='0' and status='4' ORDER BY status,work ASC LIMIT $goto, $limit ");
while($arr[user] = $db->fetch($res[user])){
$res[working] = $db->select_query("SELECT * FROM ".TB_WORKING_CAT." WHERE id='".$arr[user][work]."' ");
$arr[working] = $db->fetch($res[working]);
?>
<tr>
<td width="70"><?echo $arr[user][username];?></td>
<td width="150" ><? echo $arr[user][category_name];?></td>
<td width="350" ><? echo $arr[user][posit];?><? echo $arr[user][school];?></td>
<?
if($arr[user][turakan]==2){
?>
<td align="center" width="100" ><font color=red>ปฏิบัติ(ร)</font></td>
<?}?>
<?
if($arr[user][turakan]==3){
?>
<td align="center" width="100" ><font color=red>ปฏิบัติ(ป)</font></td>
<?}?>
<?
if($arr[user][turakan]==1){
?>
<td align="center" width="100" >ไม่แสดง</td>
<?}?>
<td align="center" width="60" ><a href="?name=user&file=user_laod&op=minepass_edit&id=<? echo $arr[user][id];?>">ดำเนินการ</a></td>
</tr>
<tr>
<td colspan="6" height="1" class="dotline"></td>
</tr>
<?
}
?>
</table>
</form>
<?
SplitPage($page,$totalpage,"?name=user&file=user_laod");
echo $ShowSumPages ;
echo "<BR>";
echo $ShowPages ;
echo "<BR><BR>";
}
else if($_GET[op] == "minepass_edit" AND $_GET[action] == "edit"){
//////////////////////////////////////////// กรณีแก้ไขข้อมูลส่วนตัว
if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
// $res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$_GET[id]."' ");
$arr[user] = $db->fetch($res[user]);
$db->closedb ();
if(!$_POST[TURAKAN] ){
$ProcessOutput .= "<BR><BR>";
$ProcessOutput .= "<CENTER><IMG SRC=\"images/icon/notview.gif\" BORDER=\"0\"><BR><BR>";
$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>กรุณากรอกข้อมูลต่างๆให้ครบถ้วน</B></FONT><BR><BR>";
$ProcessOutput .= "<A HREF=\"javascript:history.go(-1);\"><B>กลับไปแก้ไข</B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}
//ทำการแก้ไขข้อมูลลงดาต้าเบส
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$db->update_db(TB_user,array(
"turakan"=>"$_POST[TURAKAN]",
"update_date"=>"".TIMESTAMP.""
)," id='$_GET[id]' ");
$db->closedb ();
$ProcessOutput .= "<BR><BR>";
$ProcessOutput .= "<CENTER><A HREF=\"".$URLre."\"><IMG SRC=\"images/icon/login-welcome.gif\" BORDER=\"0\"></A><BR><BR>";
$ProcessOutput .= "<FONT COLOR=\"#336600\"><B>ได้ทำการแก้ไขข้อมูลเรียบร้อยแล้ว</B></FONT><BR><BR>";
$ProcessOutput .= "<meta http-equiv=\"refresh\" content=\"1 ;url=?name=user&file=user_laod\">";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}
echo $ProcessOutput ;
}
else if($_GET[op] == "minepass_edit"){
//////////////////////////////////////////// กรณีแก้ไขข้อมูลส่วนตัว
if(CheckLevelUser($_SESSION['user_user'],$_GET[op])){
//ดึงค่าของสมาชิกเวปออกมา
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE id='".$_GET[id]."' ");
$arr[user] = $db->fetch($res[user]);
$db->closedb ();
?>
<FORM method="post" action="?name=user&file=user_laod&op=minepass_edit&action=edit&id=<? echo $arr[user][id];?>" enctype="multipart/form-data">
<TABLE width="100%" cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD valign=top align="center">
<b><FONT COLOR=blue size=3><?=$arr[user][category_name];?></FONT></b>
<BR>
<FONT COLOR=RED><B><?=$arr[user][posit];?></B></FONT>
<?
if(($arr[user][work]==3)OR($arr[user][work]==4)OR($arr[user][work]==0)){
?>
<BR>มีหน้าที่อนุญาตการลา
<INPUT TYPE="radio" NAME="TURAKAN" VALUE="3" >ปฏิบัติราชการแทน
<?}?>
<INPUT TYPE="radio" NAME="TURAKAN" VALUE="1" >เลิกปฏิบัติหน้าที่<BR>
<BR>
<input type="submit" value="บันทึกเอกสาร" >
</TD>
</TR>
</TABLE>
</FORM>
<?
}else{
//กรณีไม่ผ่าน
echo $PermissionFalse ;
}
}
?>
<br />
<br />
</td>
</tr>
</table>
<br /></td>
</tr>
</table></td>
</tr>
</tbody>
</table>
</div></td>
</tr>
</tbody>
</table>
</div>