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

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}

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

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

$class_ar[6]="ชั้นประถมศึกษาปีที่ 6";
$class_ar[9]="ชั้นมัธยมศึกษาปีที่ 3";

//ส่วนของปีการศึกษา 
 	$strQuery = "select distinct ed_year from achievement_main where  test_type='1' and test_class='6' order by ed_year ";
	$result = mysqli_query($connect,$strQuery);
	$year_num=1;
	while($ors = mysqli_fetch_array($result)) {
	$ed_year_ar[$year_num]=$ors['ed_year'];
	$year_num++;
	}
$year_num=$year_num-1;  //จำนวนปีที่แสดง
if($year_num>=2){
echo "<br>";
echo "<div align='center'><b>ชั้น ป.6</b></div>";
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
  echo "<Tr bgcolor='#FFCCCC'><Td  align='center' width='8%'>ปีการศึกษา</Td><Td  align='center' width='8%'>ภาษาไทย</Td><td align='center' width='8%' >คณิตศาสตร์</td><Td align='center'  width='8%'>วิทยาศาสตร์</Td><Td align='center' width='8%' >สังคมศึกษา</Td><Td align='center'  width='8%'>ภาษาอังกฤษ</Td><Td align='center' width='8%' >สุขศึกษา</Td><Td align='center'  width='8%'>ศิลปะ</Td><Td align='center' width='8%' >การงาน</Td><Td align='center' width='8%' >เฉลี่ย</Td><Td align='center' >การประเมิน</Td></Tr>";
$M=1;
  for($x=1;$x<=$year_num;$x++){
	$strQuery = "select  avg(thai)  as thai, avg(math) as math, avg(science) as science , avg(social) as social , avg(english) as english , avg(health) as health , avg(art) as art, avg(vocation) as vocation, avg(score_avg) as score_avg from achievement_main left join system_school on achievement_main.school=system_school.school_code where system_school.school_type='1' and test_type='1' and test_class='6' and ed_year='$ed_year_ar[$x]' ";
			$result = mysqli_query($connect,$strQuery);
			$ors = mysqli_fetch_array($result);  
		if(($M%2) == 0)
		$color="#CCCCCC";
		else  $color="#FFFFFF";
		
		$thai=number_format($ors['thai'],2);
		$math=number_format($ors['math'],2);
		$science=number_format($ors['science'],2);
		$social=number_format($ors['social'],2);
		if($social==0.00){
		$social="";
		}
		$english=number_format($ors['english'],2);
		$health=number_format($ors['health'],2);
		if($health==0.00){
		$health="";
		}
		$art=number_format($ors['art'],2);
		if($art==0.00){
		$art="";
		}
		$vocation=number_format($ors['vocation'],2);
		if($vocation==0.00){
		$vocation="";
		}
		$score_avg=number_format($ors['score_avg'],2);							
		if($score_avg>0){
		 echo "<Tr bgcolor=$color><Td  align='center' >$ed_year_ar[$x]</Td><Td  align='center'>$thai</Td><td align='center' >$math</td><Td align='center'>$science</Td><Td align='center'>$social</Td><Td align='center'>$english</Td><Td align='center' >$health</Td><Td align='center'>$art</Td><Td align='center'>$vocation</Td><Td align='center' >$score_avg</Td><Td align='left' >";
		 //คะแนนจุดตัด
		$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>";
		echo "</Td></Tr>";
$M++;	
	 }
  }
echo "</table>";	 
} //end if display ป.6 
 //ม.3 
    //ส่วนของปีการศึกษา 
 	$strQuery = "select distinct ed_year from achievement_main where  test_type='1' and test_class='9'  order by ed_year ";
	$result = mysqli_query($connect,$strQuery);
	$year_num=1;
	while($ors = mysqli_fetch_array($result)) {
	$ed_year_ar[$year_num]=$ors['ed_year'];
	$year_num++;
	}
$year_num=$year_num-1;  //จำนวนปีที่แสดง
if($year_num>=2){
echo "<br>";
echo "<div align='center'><b>ชั้น ม.3</b></div>";
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
  echo "<Tr bgcolor='#FFCCCC'><Td  align='center' width='8%'>ปีการศึกษา</Td><Td  align='center' width='8%'>ภาษาไทย</Td><td align='center' width='8%' >คณิตศาสตร์</td><Td align='center'  width='8%'>วิทยาศาสตร์</Td><Td align='center' width='8%' >สังคมศึกษา</Td><Td align='center'  width='8%'>ภาษาอังกฤษ</Td><Td align='center' width='8%' >สุขศึกษา</Td><Td align='center'  width='8%'>ศิลปะ</Td><Td align='center' width='8%' >การงาน</Td><Td align='center' width='8%' >เฉลี่ย</Td><Td align='center' >การประเมิน</Td></Tr>";
$M=1;
  for($x=1;$x<=$year_num;$x++){
	$strQuery = "select avg(thai)  as thai, avg(math) as math, avg(science) as science , avg(social) as social , avg(english) as english , avg(health) as health , avg(art) as art, avg(vocation) as vocation, avg(score_avg) as score_avg from achievement_main left join system_school on achievement_main.school=system_school.school_code where system_school.school_type='1' and test_type='1' and test_class='9' and ed_year='$ed_year_ar[$x]'  ";
			$result = mysqli_query($connect,$strQuery);
			$ors = mysqli_fetch_array($result);  
		if(($M%2) == 0)
		$color="#CCCCCC";
		else  	$color="#FFFFFF";
		
		$thai=number_format($ors['thai'],2);
		$math=number_format($ors['math'],2);
		$science=number_format($ors['science'],2);
		$social=number_format($ors['social'],2);
		if($social==0.00){
		$social="";
		}
		$english=number_format($ors['english'],2);
		$health=number_format($ors['health'],2);
		if($health==0.00){
		$health="";
		}
		$art=number_format($ors['art'],2);
		if($art==0.00){
		$art="";
		}
		$vocation=number_format($ors['vocation'],2);
		if($vocation==0.00){
		$vocation="";
		}
		$score_avg=number_format($ors['score_avg'],2);							
		if($score_avg>0){
		 echo "<Tr bgcolor=$color><Td  align='center' >$ed_year_ar[$x]</Td><Td  align='center'>$thai</Td><td align='center' >$math</td><Td align='center'>$science</Td><Td align='center'>$social</Td><Td align='center'>$english</Td><Td align='center' >$health</Td><Td align='center'>$art</Td><Td align='center'>$vocation</Td><Td align='center' >$score_avg</Td><Td align='left' >";
		 //คะแนนจุดตัด
		$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>";
		echo "</Td></Tr>";
$M++;	
	 }
  }
echo "</table>";	 
} //end if display ม.3
echo "<div align='center'><b>หมายเหตุ</b> ค่าเฉลี่ยสพท.เป็นแบบไม่ถ่วงน้ำหนักด้วยจำนวนนักเรียนในแต่ละโรงเรียน</div>";

${this.title}

Code Editor : livesearch_ach_2.php