Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
index.php	1.01 KB	-rw-r--r--
level_report_1.php	40.3 KB	-rw-r--r--
level_report_2.php	33.4 KB	-rw-r--r--
level_report_3.php	22.45 KB	-rw-r--r--
level_report_4.php	14.48 KB	-rw-r--r--
sch_paper_report_1.php	63.51 KB	-rw-r--r--
sch_report_1.php	66.17 KB	-rw-r--r--
student_paper_report_1.php	17.79 KB	-rw-r--r--
student_report_1.php	25.36 KB	-rw-r--r--
test_admin3.php	12.46 KB	-rw-r--r--
test_admin_book2.php	20.8 KB	-rw-r--r--
test_sch.php	6.34 KB	-rw-r--r--
test_sch_2.php	30.45 KB	-rw-r--r--
test_student.php	36.36 KB	-rw-r--r--

Code Editor : level_report_4.php

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

<?php
// เชื่อมdatabase ชื่อ amssplus_bets

/////////
$user_db=$user;
if(isset($amssplus_bets)){   
$amssplus_bets=$amssplus_bets;
}
else{
$amssplus_bets="amssplus_bets"; 
}
$connect_bets=@mysqli_connect($hostname,$user_db,$password,$amssplus_bets);
		if($connect_bets){
		mysqli_query($connect_bets,"SET NAMES utf8");
		}
/////////

$subject="thai";

if(!(isset($_REQUEST['year_index']))){
$_REQUEST['year_index']="";
$year_all=0;
}
else{
$year_all=1;
}

if(!(isset($_REQUEST['school_code']))){
		$_REQUEST['school_code']=$remote_user_office;
}

if(!(isset($_REQUEST['section']))){
$section=1;
}
else{
$section=$_REQUEST['section'];
}

/////////////////////////////////////////////////
echo "<br>";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ร้อยละของนักเรียนที่มีผลการทดสอบร้อยละ 50 ขึ้นไป</strong></font></td></tr>";
echo "<tr align='center'><td><font color='#006666' size='2'><strong>ตามเกณฑ์มาตรฐานชั้นปี</strong></font></td></tr>";
echo "</table>";

$sql = "select distinct ed_year from $subject order by ed_year desc";
				$dbquery = mysqli_query($connect_bets,$sql);
				$row_number=1;
				While ($result = mysqli_fetch_array($dbquery))	{
						if($result['ed_year']==$_REQUEST['year_index']){
						$_REQUEST['year_index']=$result['ed_year'];
						}
						else if($row_number==1 and $year_all==0){
						$_REQUEST['year_index']=$result['ed_year'];
						}
				$row_number++;	
				}

$level[1]="ป.1";
$level[2]="ป.1";
$level[3]="ป.2";
$level[4]="ป.2";
$level[5]="ป.3";
$level[6]="ป.3";
$level[7]="ป.4";
$level[8]="ป.4";
$level[9]="ป.5";
$level[10]="ป.5";
$level[11]="ป.6";
$level[12]="ป.6";
$level[13]="ม.1";
$level[14]="ม.1";
$level[15]="ม.2";
$level[16]="ม.2";
$level[17]="ม.3";
$level[18]="ม.3";
$level[19]="ม.4";
$level[20]="ม.4";
$level[21]="ม.5";
$level[22]="ม.5";
$level[23]="ม.6";
$level[24]="ม.6";

echo "<br>";
				echo "<form id='frm1' name='frm1'>";
				echo "<table width='80%' align='center'>";
				echo "<Tr>";
				echo "<td align='center'>";
				echo "<Select  name='school_code' size='1'>";
				echo  '<option value ="" >ทุกโรงเรียน</option>' ;
				$sql = "select school_code,school_name from system_school order by school_type,school_code";
				$dbquery = mysqli_query($connect,$sql);
				While ($result = mysqli_fetch_array($dbquery)){
				
								if(($_REQUEST['school_code']==$remote_user_office) and ($remote_user_office==$result['school_code'])){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
								}
								else if($remote_user_office==$result['school_code']){
								echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
								}
				}
				echo "</select>";
				
				echo "<Select  name='year_index' size='1'>";
				$sql = "select distinct ed_year from $subject order by ed_year desc";
				$dbquery = mysqli_query($connect_bets,$sql);
				echo  '<option value ="" >ทุกปีการศึกษา</option>' ;
				$row_number=1;
				While ($result = mysqli_fetch_array($dbquery))	{
						if($result['ed_year']==$_REQUEST['year_index']){
						echo  "<option value = $result[ed_year] selected>ปีการศึกษา $result[ed_year]</option>";
						}
						else if($row_number==1 and $year_all==0){
						echo  "<option value = $result[ed_year] selected>ปีการศึกษา $result[ed_year]</option>";
						$_REQUEST['year_index']=$result['ed_year'];
						}
						else{
						echo  "<option value = $result[ed_year]>ปีการศึกษา $result[ed_year]</option>";
						}
				$row_number++;	
				}
				echo "</select>";		
				
				if(!(isset($_REQUEST['section']))){
				$sql_section = "select id from $subject where ed_year='$_REQUEST[year_index]' and (level='2' or level='4' or level='6')";
				$dbquery_section = mysqli_query($connect_bets,$sql_section);
						if($result_section = mysqli_fetch_array($dbquery_section)){
						$section=2;
						}
				}
				
				echo "<Select  name='section' size='1'>";
				echo  '<option value =1 >ภาคเรียนที่ 1</option>' ;
				if($section==2){
				echo  '<option value =2 selected>ภาคเรียนที่ 2</option>' ;
				}
				else{
				echo  '<option value =2>ภาคเรียนที่ 2</option>' ;
				}
				echo "</select>";

echo "<INPUT TYPE='hidden' name='subject' value='$subject'>";		
				echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_display(1)'>";
				echo "</td>";
				echo "<td align='left' width='20%'>";
				echo "</td>";				
				echo "</tr></table>";
				echo "<input type='hidden' name='remote_user_office' value='$remote_user_office'>";
				echo "<input type='hidden' name='remote_user_id' value='$remote_user_id'>";
				echo "<input type='hidden' name='remote_login_status' value='$remote_login_status'>";
				echo "<input type='hidden' name='remote_sync' value='$remote_sync'>";
				echo "</form>";

echo "<br>";

////////////////////////////

$subject_ar[1]="thai";
$subject_ar[2]="math";
$subject_ar[3]="science";
$subject_ar[4]="social";
$subject_ar[5]="english";
$subject_ar[6]="english2";

echo "<table  border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo"<tr bgcolor='#ddd' align='center'><td width='70' rowspan='2'>ระดับ</td><td width='100' rowspan='2'>ชั้น</td><td rowspan='2' width='150'>ภาคเรียน</td><td colspan='6'>ร้อยละของนักเรียนที่ได้คะแนนการทดสอบ 50% ขึ้นไป</td></tr>";
echo"<tr align='center'><td width='80'>ภาษาไทย</td><td width='80'>คณิต</td><td width='80'>วิทย์</td><td width='80'>สังคม</td><td width='80'>ภาษาอังกฤษ</td><td width='80'>ภาษาอังกฤษสื่อสาร</td></tr>";

$avg="0";   $avg2="0"; $avg3="0";
$subject_num=0;  $subject_num2=0; $subject_num3=0;

$thai_num=0;  $thai_avg="0";
$math_num=0;  $math_avg="0";
$science_num=0;  $science_avg="0";
$social_num=0;  $social_avg="0";
$english_num=0;  $english_avg="0";
$english2_num=0;  $english2_avg="0";

for($x=1; $x<=18; $x++){
		if($x%2 == 0){
		$section_thai="ภาคเรียนที่ 2";
		}
		else{
		$section_thai="ภาคเรียนที่ 1";
		}

if($section==1){
				if($x%2==0){
				continue;
				}
		}
		else{
				if($x%2!=0){
				continue;
				}
		}
		
		echo"<tr align='center'><td>$x</td><td>$level[$x]</td><td>$section_thai</td>";
				for($y=1; $y<=6; $y++){
						
				if($_REQUEST['school_code']==""){
				$sql_num = "select id from $subject_ar[$y] where level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_pass = "select id from $subject_ar[$y] where score>='50' and level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_avg = "select avg(score) as score_avg from $subject_ar[$y] where level='$x' and ed_year='$_REQUEST[year_index]'";
				}
				else{
				$sql_num = "select id from $subject_ar[$y] where school_code='$_REQUEST[school_code]' and level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_pass = "select id from $subject_ar[$y] where score>='50'  and school_code='$_REQUEST[school_code]' and level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_avg = "select avg(score) as score_avg from $subject_ar[$y] where school_code='$_REQUEST[school_code]' and level='$x' and ed_year='$_REQUEST[year_index]'";
				}
				
				$dbquery_num = mysqli_query($connect_bets,$sql_num);
				$std_number=mysqli_num_rows($dbquery_num);

$dbquery_pass = mysqli_query($connect_bets,$sql_pass);
				$std_pass=mysqli_num_rows($dbquery_pass);
				
				$dbquery_avg = mysqli_query($connect_bets,$sql_avg);
				$result_avg = mysqli_fetch_array($dbquery_avg);
				$score_avg=$result_avg['score_avg'];
				if($score_avg>0){
				$score_avg2=number_format($score_avg,2);
				}
				else{
				$score_avg2="";
				}
				
				$pass_percent="";
				if($std_number!=0){
				$pass_percent=$std_pass/$std_number*100;
				$pass_percent=number_format($pass_percent,2);
				$subject_num++;
				$avg=$avg+$pass_percent;
							//เฉลี่ยประถม
							if($x<=12){
							$subject_num2++;
							$avg2=$avg2+$pass_percent;
							}
							//เฉลียมัธยม
							if($x>12 and $x<=18){
							$subject_num3++;
							$avg3=$avg3+$pass_percent;
							}
				
							if($y==1){
							$thai_num++;
							$thai_avg=$thai_avg+$pass_percent;;
							}
							else if($y==2){
							$math_num++;
							$math_avg=$math_avg+$pass_percent;;
							}
							else if($y==3){
							$science_num++;
							$science_avg=$science_avg+$pass_percent;;
							}
							else if($y==4){
							$social_num++;
							$social_avg=$social_avg+$pass_percent;;
							}
							else if($y==5){
							$english_num++;
							$english_avg=$english_avg+$pass_percent;;
							}
							else if($y==6){
							$english2_num++;
							$english2_avg=$english2_avg+$pass_percent;;
							}
				}
				
						$bg="";
						if($std_number!=0 and $pass_percent==0){
						$bg="#FF0000";
						}
						else if($pass_percent>0 and $pass_percent<25){
						$bg="#F78181";
						}
						else if($pass_percent>=25 and $pass_percent<50){
						$bg="#FFCCFF";
						}
						else if($pass_percent>=50 and $pass_percent<75){
						$bg="#FFFFCC";
						}

echo "<td bgcolor='$bg'>$pass_percent";
						if(($score_avg2!="") and ($_REQUEST['school_code']=="")){
						echo "<br><font size='1'>($score_avg2)</font>";
						}
						else if(($score_avg2!="") and ($_REQUEST['school_code']!="")){
						echo "<a href=?file=level_report_1&index=8&school_code=$_REQUEST[school_code]&ed_year=$_REQUEST[year_index]&subject=$subject_ar[$y]&level=$x&section=$section&back_report_4=1&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><br><font size='1'>($score_avg2)</font></a>";
						}
				echo "</td>";
				}
		echo "</tr>";
}
		if($avg!=0){
		$avg=$avg/$subject_num;
		$avg=number_format($avg,2);
		}
		if($avg2!=0){
		$avg2=$avg2/$subject_num2;
		$avg2=number_format($avg2,2);
		}
		if($avg3!=0){
		$avg3=$avg3/$subject_num3;
		$avg3=number_format($avg3,2);
		}
		if($thai_avg!=0){
		$thai_avg=$thai_avg/$thai_num;
		$thai_avg=number_format($thai_avg,2);
		}
		if($math_avg!=0){
		$math_avg=$math_avg/$math_num;
		$math_avg=number_format($math_avg,2);
		}
		if($science_avg!=0){
		$science_avg=$science_avg/$science_num;
		$science_avg=number_format($science_avg,2);
		}
		if($social_avg!=0){
		$social_avg=$social_avg/$social_num;
		$social_avg=number_format($social_avg,2);
		}
		if($english_avg!=0){
		$english_avg=$english_avg/$english_num;
		$english_avg=number_format($english_avg,2);
		}
		if($english2_avg!=0){
		$english2_avg=$english2_avg/$english2_num;
		$english2_avg=number_format($english2_avg,2);
		}
		
		$bg1=""; $bg2=""; $bg3=""; $bg4=""; $bg5=""; $bg6="";
						if($thai_avg>=0 and $thai_avg<25){
						$bg1="#F78181";
						}
						else if($thai_avg>=25 and $thai_avg<50){
						$bg1="#FFCCFF";
						}
						else if($thai_avg>=50 and $thai_avg<75){
						$bg1="#FFFFCC";
						}
						
						if($math_avg>=0 and $math_avg<25){
						$bg2="#F78181";
						}
						else if($math_avg>=25 and $math_avg<50){
						$bg2="#FFCCFF";
						}
						else if($math_avg>=50 and $math_avg<75){
						$bg2="#FFFFCC";
						}
						
						if($science_avg>=0 and $science_avg<25){
						$bg3="#F78181";
						}
						else if($science_avg>=25 and $science_avg<50){
						$bg3="#FFCCFF";
						}
						else if($science_avg>=50 and $science_avg<75){
						$bg3="#FFFFCC";
						}
						
						if($social_avg>=0 and $social_avg<25){
						$bg4="#F78181";
						}
						else if($social_avg>=25 and $social_avg<50){
						$bg4="#FFCCFF";
						}
						else if($social_avg>=50 and $social_avg<75){
						$bg4="#FFFFCC";
						}
						
						if($english_avg>=0 and $english_avg<25){
						$bg5="#F78181";
						}
						else if($english_avg>=25 and $english_avg<50){
						$bg5="#FFCCFF";
						}
						else if($english_avg>=50 and $english_avg<75){
						$bg5="#FFFFCC";
						}
						
						if($english2_avg>=0 and $english2_avg<25){
						$bg6="#F78181";
						}
						else if($english2_avg>=25 and $english2_avg<50){
						$bg6="#FFCCFF";
						}
						else if($english2_avg>=50 and $english2_avg<75){
						$bg6="#FFFFCC";
						}
		
echo"<tr align='center'><td colspan='3' rowspan='2'><b>เฉลี่ย</b></td>";

if($thai_num>0){
echo "<td bgcolor='$bg1'><b>$thai_avg</b></td>";
}
else{
echo "<td></td>";
}

if($math_num>0){
echo "<td bgcolor='$bg2'><b>$math_avg</b></td>";
}
else{
echo "<td></td>";
}

if($science_num>0){
echo "<td bgcolor='$bg3'><b>$science_avg</b></td>";
}
else{
echo "<td></td>";
}

if($social_num>0){
echo "<td bgcolor='$bg4'><b>$social_avg</b></td>";
}
else{
echo "<td></td>";
}

if($english_num>0){
echo "<td bgcolor='$bg5'><b>$english_avg</b></td>";
}
else{
echo "<td></td>";
}

if($english2_num>0){
echo "<td bgcolor='$bg6'><b>$english2_avg</b></td>";
}
else{
echo "<td></td>";
}

echo"<tr align='center'><td colspan='6'><b>$avg</b> ";
			if($subject_num3>0){
			echo "(ประถม <b>$avg2</b>)";
			echo " (มัธยม <b>$avg3</b>)";
			}
echo "</td>";
echo "<tr><td colspan='9'>";
echo " <b>&nbsp;&nbsp;หมายเหตุ </b>";
echo "&nbsp;&nbsp;พื้นสีแดง  0%";
echo "&nbsp;&nbsp;พื้นสีแสดน้อยกว่า  25%";
echo "&nbsp;&nbsp;พื้นสีม่วงน้อยกว่า 50%";
echo "&nbsp;&nbsp;พื้นสีเหลืองน้อยกว่า 75%";
echo "&nbsp;&nbsp;&nbsp;&nbsp;ในวงเล็บคือคะแนนเฉลี่ย";

echo "</td></tr>";
echo "</table>";

mysqli_close($connect_bets);
?>

</script>

${this.title}

Code Editor : level_report_4.php