Gecko [ 122.154.134.11 ]

Name	Size	Permission
add_score_1.php	9.99 KB	-rwxr-xr-x
add_score_2.php	10.23 KB	-rwxr-xr-x
add_score_3.php	11.14 KB	-rwxr-xr-x
getxml_onet.php	6.86 KB	-rwxr-xr-x
livesearch.php	778 B	-rwxr-xr-x
permission.php	9.65 KB	-rwxr-xr-x
report1.php	9.17 KB	-rwxr-xr-x
report11.php	10.97 KB	-rwxr-xr-x
report1_1.php	8.89 KB	-rwxr-xr-x
report1_1_mobile.php	7.08 KB	-rw-r--r--
report1_2.php	12.3 KB	-rwxr-xr-x
report2.php	6.09 KB	-rwxr-xr-x
report21.php	8.62 KB	-rwxr-xr-x
report2_1.php	6.54 KB	-rwxr-xr-x
report2_2.php	5.26 KB	-rwxr-xr-x
report3.php	6.09 KB	-rwxr-xr-x
report31.php	8.63 KB	-rwxr-xr-x
report3_1.php	6.55 KB	-rwxr-xr-x
report3_2.php	5.26 KB	-rwxr-xr-x
report4.php	9.62 KB	-rwxr-xr-x
report41.php	11.64 KB	-rwxr-xr-x
report4_1.php	10.09 KB	-rw-r--r--
report4_1_mobile.php	8.61 KB	-rw-r--r--
report4_2.php	10.56 KB	-rw-r--r--
report5.php	6.09 KB	-rwxr-xr-x
report51.php	8.62 KB	-rwxr-xr-x
report5_1.php	6.54 KB	-rwxr-xr-x
report5_2.php	5.26 KB	-rwxr-xr-x
report6.php	18.25 KB	-rwxr-xr-x
report61.php	19.65 KB	-rwxr-xr-x
report6_1.php	18.52 KB	-rw-r--r--
report6_1_mobile.php	9.04 KB	-rw-r--r--
report6_2.php	13.14 KB	-rw-r--r--
report7.php	6.09 KB	-rwxr-xr-x
report71.php	8.62 KB	-rwxr-xr-x
report7_1.php	6.54 KB	-rwxr-xr-x
report7_2.php	5.26 KB	-rwxr-xr-x
report_nt.php	9.3 KB	-rw-r--r--
report_nt_group.php	7.84 KB	-rw-r--r--
report_onet.php	10.99 KB	-rw-r--r--
report_onet_group.php	12.21 KB	-rw-r--r--
report_onet_xx.php	7.88 KB	-rw-r--r--
test_import.php	6.71 KB	-rw-r--r--

Code Editor : report61.php

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

$class_ar[1]="ชั้นประถมศึกษาปีที่ 1";
$class_ar[2]="ชั้นประถมศึกษาปีที่ 2";
$class_ar[3]="ชั้นประถมศึกษาปีที่ 3";
$class_ar[4]="ชั้นประถมศึกษาปีที่ 4";
$class_ar[5]="ชั้นประถมศึกษาปีที่ 5";
$class_ar[6]="ชั้นประถมศึกษาปีที่ 6";
$class_ar[7]="ชั้นมัธยมศึกษาปีที่ 1";
$class_ar[8]="ชั้นมัธยมศึกษาปีที่ 2";
$class_ar[9]="ชั้นมัธยมศึกษาปีที่ 3";
$class_ar[10]="ชั้นมัธยมศึกษาปีที่ 4";
$class_ar[11]="ชั้นมัธยมศึกษาปีที่ 5";
$class_ar[12]="ชั้นมัธยมศึกษาปีที่ 6";

if(!(isset($_REQUEST['school_code']))){
$_REQUEST['school_code']="";
}
$sql = "select distinct test_class from achievement_main where  test_type='3' order by test_class limit 1";
$qury = mysqli_query($connect,$sql);
$result=mysqli_fetch_array($qury);
if(!(isset($_REQUEST['class_index']))){
$_REQUEST['class_index']=$result['test_class'];
}
?>
	<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/FusionCharts.js"></SCRIPT>
	<style type="text/css">
	
	</style>

<CENTER>
<h2>คะแนนสอบ LAST แบบที่ 2</h2>
<h3><?php
if(isset($_REQUEST['class_index'])){
 echo $class_ar[$_REQUEST['class_index']];
} 
 ?></h3>
<?php
echo "<form id='frm1' name='frm1'>";
echo "<table width='95%' align='center'>";
echo "<Tr><td align='right'>";
		?>
		ค้นหาโรงเรียน <input type="text" size="15" onkeyup="showResult(this.value)">
		<div id="livesearch"></div>
		<?php
echo "</td></tr>";
echo"<tr><td align='right'>";
echo "<Select  name='class_index' size='1'>";
				if($_REQUEST['class_index']=='1'){
				$select_class_1="selected";
				}
				else if($_REQUEST['class_index']=='2'){
				$select_class_2="selected";
				}
				else if($_REQUEST['class_index']=='3'){
				$select_class_3="selected";
				}
				else if($_REQUEST['class_index']=='4'){
				$select_class_4="selected";
				}
				else if($_REQUEST['class_index']=='5'){
				$select_class_5="selected";
				}
				else if($_REQUEST['class_index']=='6'){
				$select_class_6="selected";
				}

else if($_REQUEST['class_index']=='7'){
				$select_class_7="selected";
				}
				else if($_REQUEST['class_index']=='8'){
				$select_class_8="selected";
				}
				else if($_REQUEST['class_index']=='9'){
				$select_class_9="selected";
				}
				else if($_REQUEST['class_index']=='10'){
				$select_class_10="selected";
				}
				else if($_REQUEST['class_index']=='11'){
				$select_class_11="selected";
				}
				else if($_REQUEST['class_index']=='12'){
				$select_class_12="selected";
				}
				
echo  "<option value =1 $select_class_1>ชั้น ป.1</option>";
echo  "<option value =2 $select_class_2>ชั้น ป.2</option>";
echo  "<option value =3 $select_class_3>ชั้น ป.3</option>";
echo  "<option value =4 $select_class_4>ชั้น ป.4</option>";
echo  "<option value =5 $select_class_5>ชั้น ป.5</option>";
echo  "<option value =6 $select_class_6>ชั้น ป.6</option>";
echo  "<option value =7 $select_class_7>ชั้น ม.1</option>";
echo  "<option value =8 $select_class_8>ชั้น ม.2</option>";
echo  "<option value =9 $select_class_9>ชั้น ม.3</option>";
//echo  "<option value =10 $select_class_10>ชั้น ม.4</option>";
//echo  "<option value =11 $select_class_11>ชั้น ม.5</option>";
//echo  "<option value =12 $select_class_12>ชั้น ม.6</option>";
echo "</select>";

echo "<Select  name='school_code' size='1'>";
echo  '<option value ="" >ภาพรวมระดับ สพท. (รัฐและเอกชน)</option>' ;
$sql = "select  achievement_main.school ,system_school.school_name from achievement_main left join system_school on achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' order by system_school.school_type, system_school.school_code ";
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
			if($_REQUEST['school_code']==""){
			echo "<option value=$result[school]>$result[school] $result[school_name]</option>"; 
			}
			else{
					if($_REQUEST['school_code']==$result['school']){
					echo "<option value=$result[school] selected>$result[school] $result[school_name]</option>"; 
					}
					else{
					echo "<option value=$result[school]>$result[school] $result[school_name]</option>"; 
					}
			}		
}
	echo "</select>";
	echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_display(1)' class='entrybutton'>";
echo "</td></tr></table>";
echo "</form>";

//ส่วนของปีการศึกษา 
if($_REQUEST['school_code']==""){
$strQuery = "select distinct ed_year from achievement_main where  test_type='3' and test_class='$_REQUEST[class_index]' order by ed_year desc limit 4";
}
else{
$strQuery = "select distinct ed_year from achievement_main where  test_type='3' and test_class='$_REQUEST[class_index]' and school='$_REQUEST[school_code]' order by ed_year desc limit 1";
}
	$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(!(isset($ed_year_ar[1]))){
$ed_year_ar[1]="";
}

//ตั้งค่าสีกราฟ
   $color[1]='B3AA00';
   $color[2]='008ED6';
   $color[3]='9D080D';
   $color[4]='A186BE';

if($_REQUEST['school_code']==""){
$strXML = "<graph xaxisname='กลุ่มสาระ' yaxisname='Score' hovercapbg='DEDEBE' hovercapborder='889E6D' rotateNames='0' yAxisMaxValue='100' numdivlines='9' divLineColor='CCCCCC' divLineAlpha='80' decimalPrecision='0' showAlternateHGridColor='1' AlternateHGridAlpha='30' AlternateHGridColor='CCCCCC' caption='' subcaption='' >";
   $strXML .= "<categories font='Arial' fontSize='11' fontColor='000000'>";
      $strXML .= "<category name='ภาษาไทย' />";
      $strXML .= "<category name='คณิตศาสตร์' />";
      $strXML .= "<category name='วิทยาศาสตร์' />";
      $strXML .= "<category name='สังคมศึกษา' />";
      $strXML .= "<category name='ภาษาอังกฤษ' />";
      $strXML .= "<category name='สุขศึกษา' />";
	  $strXML .= "<category name='ศิลปะ' />";
      $strXML .= "<category name='การงาน' />";
      $strXML .= "<category name='เฉลี่ย' />";
   $strXML .= "</categories>";
   
  for($x=$year_num;$x>0;$x--){
  			$strQuery = "select avg(thai) as thai from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and thai>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors1 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(math) as math from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and math>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors2 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(science) as science from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and science>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors3 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(social) as social from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and social>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors4 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(english) as english from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and english>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors5 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(health) as health from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and health>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors6 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(art) as art from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and art>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors7 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(vocation) as vocation from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' and vocation>'0'";
			$result = mysqli_query($connect,$strQuery);
			$ors8 = mysqli_fetch_array($result);  
  			$strQuery = "select avg(score_avg) as score_avg from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0' ";
			$result = mysqli_query($connect,$strQuery);
			$ors9 = mysqli_fetch_array($result);  
			
			if($ors9['score_avg']>0){
		   	$strXML .= "<dataset seriesname='ปีการศึกษา $ed_year_ar[$x]' color='$color[$x]'>";
			$strXML .= "<set value='$ors1[thai]' />";
			$strXML .= "<set value='$ors2[math]' />";
			$strXML .= "<set value='$ors3[science]' />";
			$strXML .= "<set value='$ors4[social]' />";
			$strXML .= "<set value='$ors5[english]' />";
			$strXML .= "<set value='$ors6[health]' />";
			$strXML .= "<set value='$ors7[art]' />";
			$strXML .= "<set value='$ors8[vocation]' />";
			$strXML .= "<set value='$ors9[score_avg]' />";
		   	$strXML .= "</dataset>";
			}
  }
$strXML .= "</graph>";
	echo renderChart("FusionCharts/FCF_MSColumn3D.swf", "", $strXML, "Fc", 1000, 450);
}	
else{
		echo "ปีการศึกษา"." ".$ed_year_ar[1];
		$strXML = "<graph xaxisname='กลุ่มสาระ' yaxisname='Score' hovercapbg='DEDEBE' hovercapborder='889E6D' rotateNames='0' yAxisMaxValue='100' numdivlines='9' divLineColor='CCCCCC' divLineAlpha='80' decimalPrecision='0' showAlternateHGridColor='1' AlternateHGridAlpha='30' AlternateHGridColor='CCCCCC' caption='' subcaption='' >";
		   $strXML .= "<categories font='Arial' fontSize='11' fontColor='000000'>";
			  $strXML .= "<category name='ภาษาไทย' />";
			  $strXML .= "<category name='คณิตศาสตร์' />";
			  $strXML .= "<category name='วิทยาศาสตร์' />";
			  $strXML .= "<category name='สังคมศึกษา' />";
			  $strXML .= "<category name='ภาษาอังกฤษ' />";
			  $strXML .= "<category name='สุขศึกษา' />";
			  $strXML .= "<category name='ศิลปะ' />";
			  $strXML .= "<category name='การงาน' />";
			  $strXML .= "<category name='เฉลี่ย' />";
		  	  $strXML .= "</categories>";

//ค่าเฉลี่ยสพท			  
  			$strQuery_khet = "select avg(thai) as thai from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and thai>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet1  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(math) as math from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and math>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet2  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(science) as science from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and science>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet3  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(social) as social from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and social>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet4  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(english) as english from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and english>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet5  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(health) as health from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and health>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet6  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(art) as art from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and art>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet7  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(vocation) as vocation from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0' and vocation>'0'";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet8  = mysqli_fetch_array($result_khet );  
  			$strQuery_khet = "select avg(score_avg) as score_avg from achievement_main left join system_school on  achievement_main.school=system_school.school_code where  achievement_main.test_type='3' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[1]' and achievement_main.score_avg>'0'  ";
			$result_khet  = mysqli_query($connect,$strQuery_khet );
			$ors_khet9  = mysqli_fetch_array($result_khet );  
			if($ors_khet9['score_avg']>0){
		   	$strXML .= "<dataset seriesname='ค่าเฉลี่ย สพท. ปีการศึกษา $ed_year_ar[1]' color='$color[3]'>";
			$strXML .= "<set value='$ors_khet1[thai]' />";
			$strXML .= "<set value='$ors_khet2[math]' />";
			$strXML .= "<set value='$ors_khet3[science]' />";
			$strXML .= "<set value='$ors_khet4[social]' />";
			$strXML .= "<set value='$ors_khet5[english]' />";
			$strXML .= "<set value='$ors_khet6[health]' />";
			$strXML .= "<set value='$ors_khet7[art]' />";
			$strXML .= "<set value='$ors_khet8[vocation]' />";
			$strXML .= "<set value='$ors_khet9[score_avg]' />";
		   	$strXML .= "</dataset>";
			}
			  
//คะแนนสถานศึกษา			  
			$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='3' and test_class='$_REQUEST[class_index]' and ed_year='$ed_year_ar[1]' and school='$_REQUEST[school_code]' ";
			$result = mysqli_query($connect,$strQuery);
			$ors = mysqli_fetch_array($result);  
			if($ors['score_avg']>0){
		   	$strXML .= "<dataset seriesname=' คะแนนสถานศึกษา ปีการศึกษา $ed_year_ar[1]' color='$color[2]'>";
			$strXML .= "<set value='$ors[thai]' />";
			$strXML .= "<set value='$ors[math]' />";
			$strXML .= "<set value='$ors[science]' />";
			$strXML .= "<set value='$ors[social]' />";
			$strXML .= "<set value='$ors[english]' />";
			$strXML .= "<set value='$ors[health]' />";
			$strXML .= "<set value='$ors[art]' />";
			$strXML .= "<set value='$ors[vocation]' />";
			$strXML .= "<set value='$ors[score_avg]' />";
		   	$strXML .= "</dataset>";
			}
			$strXML .= "</graph>";
			echo renderChart("FusionCharts/FCF_MSColumn3D.swf", "", $strXML, "Fc", 1000, 450);
}

?>
</CENTER>

${this.title}

Code Editor : report61.php