| Server IP : 172.67.187.206 / 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/chongphran/modules/admin/ |
Upload File : |
<?
CheckAdmin($_SESSION['admin_user'], $_SESSION['admin_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height=500 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<B><IMG SRC="images/icon/plus.gif" BORDER="0" ALIGN="absmiddle"> <A HREF="?name=admin&file=main">หน้าหลักผู้ดูแลระบบ</A>
<A HREF="?name=admin&file=meeting"><IMG SRC="images/admin/folders.gif" BORDER="0" align="absmiddle"> รายการ</A> <A HREF="?name=admin&file=meeting&op=workcat_add"><IMG SRC="images/admin/opendir.gif" BORDER="0" align="absmiddle"> เพิ่มห้องประชุม</A>
<TABLE width="98%" align=center cellSpacing=0 cellPadding=0 border=0>
<TR>
<TD>
<?
//////////////////////////////////////////// แสดงรายการ
if($_GET[op] == ""){
?>
<form action="?name=admin&file=meeting&op=workcat_del&action=multidel" name="myform1" method="post">
<table width="100%" cellspacing="2" cellpadding="1" >
<tr bgcolor="#990000" height=25>
<td width="20"><font color="#FFFFFF"><B><CENTER>แก้ไข</CENTER></B></font></td>
<td width="500"><font color="#FFFFFF"><B>ฝ่าย/งาน</B></font></td>
<td align="center" width="100"><font color="#FFFFFF"><B>ห้อง</B></font></td>
<td align="center" width="100"><font color="#FFFFFF"><B>ลำดับ</B></font></td>
</tr>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[meeting] = $db->select_query("SELECT * FROM ".TB_MEETING." WHERE status='1' ORDER BY sort ");
$rows[meeting] = $db->rows($res[meeting]);
$CATCOUNT = 0 ;
while ($arr[meeting] = mysql_fetch_array($res[meeting])){
$row[summeeting] = $db->num_rows(TB_MEETING,"id"," category=".$arr[meeting][id]." ");
$CATCOUNT ++ ;
//กำหนดการเปลี่ยนลำดับขึ้น
$SETSORT_UP = $arr[meeting][sort]-1;
if($CATCOUNT == "1"){
$SETSORT_UP = "1" ;
}
//กำหนดการเปลี่ยนลำดับลง
$SETSORT_DOWN = $arr[meeting][sort]+1;
if($CATCOUNT == $rows[meeting]){
$SETSORT_DOWN = $arr[meeting][sort] ;
}
?>
<tr>
<td>
<a href="?name=admin&file=meeting&op=workcat_edit&id=<? echo $arr[meeting][id];?>"><img src="images/admin/edit.gif" border="0" alt="แก้ไข" ></a>
</td>
<td width="550"><?echo $arr[meeting][name];?></td>
<td align="center"><?echo $arr[meeting][id];?></td>
<td align="center">
<a href="?name=admin&file=delmeeting&id=<? echo $arr[meeting][id];?>"><img src="images/delete.gif" border="0" alt="ลบ" ></a>
<A HREF="?name=admin&file=meeting&op=workcat_edit&action=sort&setsort=<?echo $SETSORT_UP ;?>&move=up&id=<? echo $arr[meeting][id];?>"><IMG SRC="images/icon/arrow_up.gif" BORDER="0" ALT="เลื่อนขึ้น"></A> <A HREF="?name=admin&file=meeting&op=workcat_edit&action=sort&setsort=<?echo $SETSORT_DOWN ;?>&move=down&id=<? echo $arr[meeting][id];?>"><IMG SRC="images/icon/arrow_down.gif" BORDER="0" ALT="เลื่อนลง"></A></td>
</tr>
<tr>
<td colspan="5" height="1" class="dotline"></td>
</tr>
<?
}
$db->closedb ();
?>
</table>
</form>
<?
}
else if($_GET[op] == "workcat_add" AND $_GET[action] == "add"){
//////////////////////////////////////////// กรณีเพิ่ม Database
if($_GET[op]){
//เช็คว่า id ตอนนี้เป็นอะไร
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[meeting] = $db->select_query("SELECT sort FROM ".TB_MEETING." ORDER BY sort DESC ");
$arr[meeting] = mysql_fetch_array($res[meeting]);
$SORTID = $arr[meeting][sort]+1 ;
//เพิ่มข้อมูลลงดาต้าเบส
$db->add_db(TB_MEETING,array(
"name"=>"".(htmlspecialchars($_POST[NAME]))."",
"status"=>"1",
"sort"=>"$SORTID"
));
$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=meeting\"><B>กลับหน้าจัดการ </B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
else if($_GET[op] == "workcat_add"){
//////////////////////////////////////////// กรณีเพิ่ม Form
if($_GET[op]){
?>
<BR><BR>
<FORM METHOD=POST ACTION="?name=admin&file=meeting&op=workcat_add&action=add">
<div align=center><B>ชื่อห้องประชุม :</B><INPUT TYPE="text" NAME="NAME" size="40">
<INPUT TYPE="submit" value="บันทึกรายการ"></div>
</FORM>
<?
}else{
//กรณีไม่ผ่าน
echo $PermissionFalse ;
}
}
else if($_GET[op] == "workcat_edit" AND $_GET[action] == "edit"){
//////////////////////////////////////////// กรณีแก้ไข Database
if($_GET[op]){
//แก้ไขข้อมูลลงดาต้าเบส
$db->update_db(TB_MEETING,array(
"name"=>"".addslashes(htmlspecialchars($_POST[NAME])).""
)," id=".$_GET[id]." ");
$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=meeting\"><B>กลับหน้าจัดการ</B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
else if($_GET[op] == "workcat_edit" AND $_GET[action] == "sort"){
//////////////////////////////////////////// Set Sort
if($_GET[op]){
//กรณีเลื่อนขึ้น
if($_GET[move] == "up"){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$q[SETD] = "UPDATE ".TB_MEETING." SET sort = sort+1 WHERE sort = '".$_GET[setsort]."' ";
$sql[SETD] = mysql_query ( $q[SETD] ) or sql_error ( "db-query",mysql_error() );
$db->closedb ();
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$q[SETU] = "UPDATE ".TB_MEETING." SET sort = '".$_GET[setsort]."' WHERE id = '".$_GET[id]."' ";
$sql[SETU] = mysql_query ( $q[SETU] ) or sql_error ( "db-query",mysql_error() );
$db->closedb ();
}
if($_GET[move] == "down"){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$q[SETD] = "UPDATE ".TB_MEETING." SET sort = sort-1 WHERE sort = '".$_GET[setsort]."' ";
$sql[SETD] = mysql_query ( $q[SETD] ) or sql_error ( "db-query",mysql_error() );
$db->closedb ();
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$q[SETU] = "UPDATE ".TB_MEETING." SET sort = '".$_GET[setsort]."' WHERE id = '".$_GET[id]."' ";
$sql[SETU] = mysql_query ( $q[SETU] ) or sql_error ( "db-query",mysql_error() );
$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=meeting\"><B>กลับหน้าจัดการ</B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
else if($_GET[op] == "workcat_edit"){
//////////////////////////////////////////// กรณีแก้ไข Form
if($_GET[op]){
//ดึงค่า
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[meeting] = $db->select_query("SELECT * FROM ".TB_MEETING." WHERE id='".$_GET[id]."' ");
$arr[meeting] = $db->fetch($res[meeting]);
$db->closedb ();
?>
<br><br>
<FORM METHOD=POST ACTION="?name=admin&file=meeting&op=workcat_edit&action=edit&id=<?=$_GET[id];?>">
<div align=center><B>ชื่อห้องประชุม :</B> <INPUT TYPE="text" NAME="NAME" size="40" value="<?=$arr[meeting][name];?>">
<INPUT TYPE="submit" value="บันทึกแก้ไข"></div>
</FORM>
<?
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
else if($_GET[op] == "workcat_del" AND $_GET[action] == "multidel"){
//////////////////////////////////////////// กรณีลบ Multi
if(CheckLevel($_SESSION['admin_user'],$_GET[op])){
while(list($key, $value) = each ($_POST['list'])){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$db->del(TB_MEETING," id='".$value."' ");
$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=meeting\"><B>กลับหน้า รายการห้องประชุม</B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
else if($_GET[op] == "workcat_del"){
//////////////////////////////////////////// กรณีลบ Form
if(CheckLevel($_SESSION['admin_user'],$_GET[op])){
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$db->del(TB_MEETING," id='".$_GET[id]."' ");
$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=meeting\"><B>กลับหน้า รายการห้องประชุม</B></A>";
$ProcessOutput .= "</CENTER>";
$ProcessOutput .= "<BR><BR>";
}else{
//กรณีไม่ผ่าน
$ProcessOutput = $PermissionFalse ;
}
echo $ProcessOutput ;
}
?>
</FORM> <BR><BR>
</TD>
</TR>
</TABLE>
<BR><BR>
<!-- Admin -->
</TD>
</TR>
</TBODY>
</TABLE>