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_std3.php

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

$q=$_GET["q"];

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

require_once("../../../amssplus_connect.php");
$q=$_GET["q"];
$_REQUEST['year_index']=$_GET["val3"];
$section=$_GET["val4"];

// เชื่อม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 "<br>";
echo "<div align='center'><font color='#006666' size='3'><strong>ร้อยละของนักเรียนที่มีผลการประเมินพัฒนาการร้อยละ 80 ขึ้นไป</strong></font></div>";
echo "<div align='center'><font color='#006666' size='2'><strong>ตามเกณฑ์มาตรฐานชั้นปี ปีการศึกษา $_REQUEST[year_index]</strong></font></div>";

$level[-5]="อนุบาล 1";
$level[-6]="อนุบาล 1";
$level[-3]="อนุบาล  2";
$level[-4]="อนุบาล 2";
$level[-1]="อนุบาล 3";
$level[-2]="อนุบาล 3";

$subject_ar[1]="kindergarten";

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>ร้อยละของนักเรียนที่ได้คะแนน<br>การประเมินพัฒนาการ 80% ขึ้นไป</td></tr>";
echo"<tr align='center'><td>การศึกษาปฐมวัย</td></tr>";

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

$thai_num=0;  $thai_avg="0";

if($section==1){
		$section_thai="ภาคเรียนที่ 1";
}
else{
$section_thai="ภาคเรียนที่ 2";
}

for($x=-6; $x<0; $x++){
		$y=abs($x);  
		if($section==1){
				if($y%2!=0){
				continue;
				}
		}
		else{
				if($y%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<=1; $y++){
						
				$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>='80'  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;;
							}
				}
				
						$bg="";
						if($std_number!=0 and $pass_percent==0){
						$bg="#FF0000";
						}
						else if($pass_percent>0 and $pass_percent<50){
						$bg="#F78181";
						}
						else if($pass_percent>=50 and $pass_percent<80){
						$bg="#FFCCFF";
						}
						else if($pass_percent>=80 and $pass_percent<95){
						$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);
						}
				}
				
				$e_id=$y."_".$x;    
				$div_show="2021";
				$file_name="2021";
				echo "<td bgcolor='$bg'><span id='$e_id' onclick='displayFunction($y,$x,$q,$_REQUEST[year_index],$file_name,$div_show)' onmouseover='OverFunction($y,$x)'  onmouseout='OutFunction($y,$x)'>$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 "<br><font size='1'>($score_avg2)</font>";
						}
				echo "</span></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);
		}
		
		$bg1=""; $bg2=""; $bg3=""; $bg4=""; $bg5=""; $bg6="";
						if($thai_avg>=0 and $thai_avg<50){
						$bg1="#F78181";
						}
						else if($thai_avg>=50 and $thai_avg<80){
						$bg1="#FFCCFF";
						}
						else if($thai_avg>=80 and $thai_avg<95){
						$bg1="#FFFFCC";
						}
						
		
echo"<tr align='center'><td colspan='3'><b>เฉลี่ย</b></td>";

if($thai_num>0){
echo "<td bgcolor='$bg1'><b>$thai_avg</b></td>";
}
else{
echo "<td></td>";
}
echo "</tr>";
echo "<tr><td colspan='4'>";
echo " <b>&nbsp;&nbsp;หมายเหตุ </b>";
echo "&nbsp;&nbsp;พื้นสีแดง  0%";
echo "&nbsp;&nbsp;พื้นสีแสดน้อยกว่า  50%";
echo "&nbsp;&nbsp;พื้นสีม่วงน้อยกว่า 80%";
echo "&nbsp;&nbsp;พื้นสีเหลืองน้อยกว่า 95%";
echo "&nbsp;&nbsp;&nbsp;&nbsp;ในวงเล็บคือคะแนนเฉลี่ย";
echo "</td></tr>";
echo "</table>";
?>

${this.title}

Code Editor : livesearch_std3.php