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

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}
 if($_SESSION['user_os'] =="mobile"){
 $width_1="80%";
 }
 else{
  $width_1="60%";
 }

require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

$sql = "select distinct ed_year from achievement_main where  test_type='2' and test_class='3' order by ed_year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$result_year = mysqli_fetch_array($dbquery);
$ed_year=$result_year['ed_year'];

echo "<Table width='$width_1' Border='0'>";
echo "<Tr><Td  align='center'><b>ผลสอบ NT ปีการศึกษา $ed_year</b></Td></Tr>";
echo  "</table>";

$sql_group = "select  * from system_school_group order by code";
$dbquery_group = mysqli_query($connect,$sql_group);

$group_no=1;
While ($result_group = mysqli_fetch_array($dbquery_group)){
$group_code=$result_group['code'];
$group_name=$result_group['name'];

echo "<Table width='$width_1' Border='0'>";
echo "<Tr><Td  align='left'><b>$group_no กลุ่ม$group_name</b></Td></Tr>";
echo  "</table>";

echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
  echo "<Tr bgcolor='#CED8F6'><Td  align='center' width='40'>ที่</Td><Td  align='center' width='180'>โรงเรียน</Td><Td  align='center'>ด้านภาษา</Td><td align='center'>ด้านคำนวณ</td><Td align='center'>ด้านเหตุผล</Td><Td align='center'>เฉลี่ย</Td><Td align='center' width='200'>การประเมิน</Td></Tr>";
		$sql2 = "select  * from system_school  where school_group='$group_code' order by school_code ";
		$dbquery2 = mysqli_query($connect,$sql2);
		
		$M=1; 
		$thai_g=0; $math_g=0; $science_g=0; $score_avg_g=0;
		$M_thai=0;
		$M_math=0;
		$M_science=0;
		$M_avg=0;

While ($result2 = mysqli_fetch_array($dbquery2)){
		$school_code=$result2['school_code'];
		$school_name=$result2['school_name'];
			if(($M%2) == 0)
			$color="#CCCCCC";
			else  $color="#FFFFFF";
							/////////////////	
							$sql3 = "select thai, math, science, score_avg from achievement_main where test_type='2' and test_class='3' and ed_year='$ed_year' and school='$school_code' ";
							$dbquery3 = mysqli_query($connect,$sql3);
							$result3 = mysqli_fetch_array($dbquery3);  
							
							$thai_g=	$thai_g+$result3['thai'];
							$math_g=$math_g+$result3['math'];
							$science_g=	$science_g+$result3['science'];
							$score_avg_g=	$score_avg_g+$result3['score_avg'];	
							
							if($result3['score_avg']>0){
							$M_avg++;
							}
							if($result3['thai']>0){
							$M_thai++;
							}
							if($result3['math']>0){
							$M_math++;
							}
							if($result3['science']>0){
							$M_science++;
							}

$thai=number_format($result3['thai'],2);
							$math=number_format($result3['math'],2);
							$science=number_format($result3['science'],2);
							$score_avg=number_format($result3['score_avg'],2);			
							
							if($thai=="0.00"){
							$thai="";
							}		
							if($math=="0.00"){
							$math="";
							}		
							if($science=="0.00"){
							$science="";
							}		
							if($score_avg=="0.00"){
							$score_avg="";
							}

///////////
  		echo "<Tr align='center' bgcolor=$color><Td>$M</Td><Td align='left'>$school_name</Td><Td>$thai</Td><td>$math</td><Td>$science</Td><Td>$score_avg</Td><Td align='left'>";
		
		//กราฟ
		if($score_avg>0){
				 //คะแนนจุดตัด
		$a=50;
		$b=30;
		$color[2]="#00CC00";
        echo "<table  border='0' cellspacing='0' cellpadding='0'>";
        echo "<tr><td></td>";
				$score_ceil=$score_avg/2;
				if($score_ceil>50){
				$score_ceil=0;   //error
				}
				for($j=0;$j<=$score_ceil;$j++){
						 		if ($j<=($b/2)){
	  							$cl='#FF0000';
						  		}
						 		else if (($j>($b/2)) and ($j<($a/2))){
						  		$cl='#FFFF00';
						  		}
						   		else if ($j>=($a/2)){
						  		$cl='#00CC00';
						  		}
          	 echo "<td bgcolor='$cl' width='1' >&nbsp;</td>";
			 }
          	echo "</tr>";
         	echo "</table>";
		}
		// end กราฟ
		
		echo "</Td></Tr>";
		$M++;
		}
		
		if($M_thai!=0){	 
		$thai_g=	$thai_g/$M_thai;
		}
		if($M_math!=0){	
		$math_g=$math_g/$M_math;
		}
		if($M_science!=0){	
		$science_g=	$science_g/$M_science;
		}
		if($M_avg!=0){	
		$score_avg_g=	$score_avg_g/$M_avg;
		}
		
		$thai_g=number_format($thai_g,2);
		$math_g=number_format($math_g,2);
		$science_g=number_format($science_g,2);
		$score_avg_g=	number_format($score_avg_g,2);
		
		if($thai_g=="0.00"){
		$thai_g="";
		}		
		if($math_g=="0.00"){
		$math_g="";
		}		
		if($science_g=="0.00"){
		$science_g="";
		}		
		
		
  		echo "<Tr align='center' bgcolor='#FFFFCC'><Td></Td><Td>เฉลี่ย</Td><Td>$thai_g</Td><td>$math_g</td><Td>$science_g</Td><Td>$score_avg_g</Td><Td></Td></Tr>";

echo  "</table>";
echo "<br>";

$group_no++;
} //group
echo "<div align='center'><b>หมายเหตุ</b> ค่าเฉลี่ยสพท.เป็นแบบไม่ถ่วงน้ำหนักด้วยจำนวนนักเรียนในแต่ละโรงเรียน</div>";
echo "<br>";
?>

${this.title}

Code Editor : livesearch_nt3.php