Gecko [ 122.154.134.11 ]

Name	Size	Permission
building_show.php	4.58 KB	-rw-r--r--
livesearch1.php	787 B	-rw-r--r--
livesearch_202.php	5.82 KB	-rw-r--r--
livesearch_2021.php	4.86 KB	-rw-r--r--
livesearch_204.php	11.9 KB	-rw-r--r--
livesearch_2041.php	9.97 KB	-rw-r--r--
livesearch_2044.php	11.8 KB	-rw-r--r--
livesearch_20441.php	9.83 KB	-rw-r--r--
livesearch_206.php	11.79 KB	-rw-r--r--
livesearch_2061.php	9.79 KB	-rw-r--r--
livesearch_301.php	3.16 KB	-rw-r--r--
livesearch_302.php	3.36 KB	-rw-r--r--
livesearch_ach.php	7.15 KB	-rw-r--r--
livesearch_ach_2.php	7.85 KB	-rw-r--r--
livesearch_allperson.php	1.59 KB	-rw-r--r--
livesearch_amphoe_school.php	1.53 KB	-rw-r--r--
livesearch_budget.php	10.99 KB	-rw-r--r--
livesearch_building.php	3.14 KB	-rw-r--r--
livesearch_chart2.php	625 B	-rw-r--r--
livesearch_chart3.php	872 B	-rw-r--r--
livesearch_chart3_2.php	987 B	-rw-r--r--
livesearch_chart3_3.php	1.37 KB	-rw-r--r--
livesearch_chart3_4.php	847 B	-rw-r--r--
livesearch_chart3_5.php	883 B	-rw-r--r--
livesearch_chart3_6.php	879 B	-rw-r--r--
livesearch_chart3_7.php	922 B	-rw-r--r--
livesearch_chart4.php	607 B	-rw-r--r--
livesearch_chart4_2.php	1.05 KB	-rw-r--r--
livesearch_computer.php	4.46 KB	-rw-r--r--
livesearch_g_ach_2.php	8.67 KB	-rw-r--r--
livesearch_health1.php	9.7 KB	-rw-r--r--
livesearch_health2.php	8.81 KB	-rw-r--r--
livesearch_khetopportunity.php	3.74 KB	-rw-r--r--
livesearch_khetopportunity2.ph...	3.8 KB	-rw-r--r--
livesearch_khetopportunity3.ph...	3.74 KB	-rw-r--r--
livesearch_khetperson.php	1.44 KB	-rw-r--r--
livesearch_nt.php	2.68 KB	-rw-r--r--
livesearch_nt2.php	3.05 KB	-rw-r--r--
livesearch_nt3.php	5.26 KB	-rw-r--r--
livesearch_opportunity.php	8 KB	-rw-r--r--
livesearch_opportunity2.php	8 KB	-rw-r--r--
livesearch_opportunity3.php	8.01 KB	-rw-r--r--
livesearch_plan.php	4.3 KB	-rw-r--r--
livesearch_plc.php	5.71 KB	-rw-r--r--
livesearch_plc2.php	3.15 KB	-rw-r--r--
livesearch_read.php	7.91 KB	-rw-r--r--
livesearch_sch_person.php	1.51 KB	-rw-r--r--
livesearch_school.php	2.19 KB	-rw-r--r--
livesearch_school_group.php	2.64 KB	-rw-r--r--
livesearch_school_group2.php	2.3 KB	-rw-r--r--
livesearch_small_school.php	1.95 KB	-rw-r--r--
livesearch_smss_std.php	5.28 KB	-rw-r--r--
livesearch_std.php	11.24 KB	-rw-r--r--
livesearch_std2.php	11.05 KB	-rw-r--r--
livesearch_std3.php	7.02 KB	-rw-r--r--
livesearch_std4.php	6.91 KB	-rw-r--r--
livesearch_std_check.php	3.31 KB	-rw-r--r--
livesearch_std_check2.php	3.28 KB	-rw-r--r--
livesearch_student.php	3.96 KB	-rw-r--r--
livesearch_student2.php	4.17 KB	-rw-r--r--
livesearch_student3.php	10.44 KB	-rw-r--r--
livesearch_student_list.php	5.22 KB	-rw-r--r--
livesearch_supervision.php	13.24 KB	-rw-r--r--
permission.php	11.13 KB	-rw-r--r--
school_report_1.php	52.88 KB	-rw-r--r--
school_report_2.php	36.59 KB	-rw-r--r--

Code Editor : livesearch_std2.php

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}
require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

$q=$_GET["q"];
$_REQUEST['year_index']=$_GET["val3"];
$section=$_GET["val4"];

if($_SESSION['user_os'] =="mobile"){
 $width_1="97%";
 }
 else{
  $width_1="70%";
 }

// เชื่อม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");
		}
/////////
//end

$_REQUEST['school_code']=$q;

/////////////////////////////////////////////////
echo " ";
echo "<div align='center'>ร้อยละของนักเรียนที่มีผลการทดสอบร้อยละ 50 ขึ้นไป</div>";
echo "<div align='center'>ตามเกณฑ์มาตรฐานชั้นปี ปีการศึกษา $_REQUEST[year_index]</div>";

$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";

$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' style='border-collapse: collapse' width='$width_1' align='center'>";
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='7'>ร้อยละของนักเรียนที่ได้คะแนนการทดสอบ 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><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>";
				
				$subject_inclass_num=0; //จำนวยวิชาในชั้น
				$total_avg_inclass=0; //รวมค่าเฉลี่ยแต่ละวิชาในชั้น
				$avg_class=0; //ค่าเฉลี่ยในชั้น 6 วิชา

for($y=1; $y<=6; $y++){
						
				$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]'";
				
				$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";
						}
						
				if($score_avg2!=""){
					$subject_inclass_num=$subject_inclass_num+1;
					$total_avg_inclass=$total_avg_inclass+$pass_percent;
						if($subject_inclass_num>0){
						$avg_class=$total_avg_inclass/$subject_inclass_num;
						$avg_class=number_format($avg_class,2);
						}
				}

$q="1234";
				$e_id=$y."_".$x; 
				$div_show="2044";
				$file_name="2044";
				echo "<td bgcolor='$bg'>$pass_percent";
						if(($score_avg2!="") and ($_REQUEST['school_code']=="")){
						echo " ($score_avg2)";
						}
						else if(($score_avg2!="") and ($_REQUEST['school_code']!="")){
						echo " ($score_avg2)";
						}
				echo "</td>";
				}
				
		// เฉลี่ยชั้น		
		if($subject_inclass_num!=0){		
			if($avg_class==0){
			$bg="#FF0000";
			}
			else if($avg_class<25){
			$bg="#F78181";
			}
			else if($avg_class<50){
			$bg="#FFCCFF";
			}
			else if($avg_class<75){
			$bg="#FFFFCC";
			}
			else{
			$bg="";
			}
		echo "<td bgcolor='$bg'>$avg_class</td>";		
		}
		else{
		echo "<td></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'>เฉลี่ย</td>";

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

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

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

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

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

if($english2_num>0){
echo "<td bgcolor='$bg6'>$english2_avg</td>";
}
else{
echo "<td></td>";
}
echo "<td></td>";
echo"<tr align='center'><td colspan='7'>$avg ";
			if($subject_num3>0){
			echo "(ประถม $avg2)";
			echo " (มัธยม $avg3)";
			}
echo "</td>";
echo "<tr><td colspan='10'>";
echo " &nbsp;&nbsp;หมายเหตุ ";
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>";
?>

${this.title}

Code Editor : livesearch_std2.php