Gecko [ 122.154.134.11 ]

Name	Size	Permission
manual	[ DIR ]	drwxr-xr-x
add_user.php	14.38 KB	-rw-r--r--
add_user_sch.php	13.54 KB	-rw-r--r--
data_requester.php	17.74 KB	-rwxr-xr-x
data_requester_log.php	6.2 KB	-rw-r--r--
index.php	81 B	-rwxr-xr-x
menugroup.php	10.35 KB	-rw-r--r--
module.php	33.28 KB	-rw-r--r--
module_admin.php	11.9 KB	-rw-r--r--
office_name.php	2.91 KB	-rw-r--r--
register.php	1.53 KB	-rwxr-xr-x
reset_pwd.php	6.33 KB	-rw-r--r--
reset_pwd_sch.php	6.44 KB	-rw-r--r--
school.php	9.37 KB	-rw-r--r--
school_detail.php	8.51 KB	-rw-r--r--
school_group.php	8.97 KB	-rw-r--r--
show_name_th.php	514 B	-rwxr-xr-x
smss_permission.php	2.81 KB	-rw-r--r--
sync_code.php	2.85 KB	-rwxr-xr-x
sync_other_code.php	11.12 KB	-rw-r--r--
sync_smss_code.php	7.16 KB	-rwxr-xr-x
user_change_pwd.php	2.51 KB	-rwxr-xr-x
workgroup.php	10.37 KB	-rw-r--r--

Code Editor : smss_permission.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );

echo "<br/>";
echo "<Center>";
echo "<Font color='#006666' Size='3'><B>อนุญาตให้ SMSS เชื่อมระบบ</B></Font>";
echo "</Cener>";
echo "<br/>";

if($index==2){ 
$sql = "select * from system_school";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery)){
		$school_code = $result['school_code'];
			$sql2= "select * from  system_smss_permission where school='$school_code'"; 
			$dbquery2=mysqli_query($connect,$sql2);
			$member_num = mysqli_num_rows($dbquery2); 
			if($member_num<1){
					if(isset($_POST[$school_code])==1){ 
					$sql3="insert into system_smss_permission(school, status) values('$school_code','1')";	
					mysqli_query($connect,$sql3);
					}
			}
			if($member_num>=1){
					if(isset($_POST[$school_code])!=1){
					$sql4="delete from system_smss_permission where school='$school_code'"; 
					mysqli_query($connect,$sql4);
					}	
			}
		} //loop while
} //loopindex2

echo "<br/>";	
echo "<form id='frm1' name='frm1'>";
echo "<table width='50%' CELLSPACING=1 CELLPADDING=2 align='center'>";
	echo "<tr bgcolor='#000000' height='30'>";
	echo "<td align='center' width='80'><b><font color='#FFFFFF'>ที่</td>";
	echo "<td align='center' width='150'><b><font color='#FFFFFF'>รหัส</td>";
	echo "<td align='center'><b><font color='#FFFFFF'>โรงเรียน</td>";
	echo "<td align='center' width='80'><b><font color=#FFFFFF>อนุญาต</td>";
	echo "</tr>";
$sql = "select * from system_school  left join system_smss_permission on system_school.school_code=system_smss_permission.school  where school_type='1' order by system_school.school_type,system_school.school_code ";

$dbquery = mysqli_query($connect,$sql);
	$n=1;
	While ($result = mysqli_fetch_array($dbquery)){
	$id= $result['id'];
	$school_code = $result['school_code'];
	$school = $result['school'];  
	$school_name = $result['school_name'];
	$status = $result['status'];  
					
					if($status==1){
					$bgcolor="#FFFFB"; 
					}
					else{
					$bgcolor="#F5F5F5";
					}
					
		echo "<tr bgcolor=$bgcolor>";
		echo "<td align=center>$n</td>";
		echo "<td align='center'>$school_code</td>";
		echo "<td align='left'>$school_name</td>";
		if($status==1){
		echo "<td align='center'><INPUT TYPE='checkbox' NAME='$school_code' checked value='1' ></td>";
		}
		else{
		echo "<td align='center'><INPUT TYPE='checkbox' NAME='$school_code' value='1' ></td>";
		}
		echo "</tr>";
	$n++;	
	}	
echo "</table>";
echo "<br/>";
echo "<div align='center'>";
echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url()'>";
echo "</div>";
echo "</form>";
?>

${this.title}

Code Editor : smss_permission.php