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 : report_onet.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
?>
 <script src="chart/Chart.js"></script>
<?php

if($_SESSION['user_os'] =="mobile"){
$w1="97%";
$w2="97%";
$w3="97%";
$w4="97%";
$w5="97%";
}
else{
$w1="100%";
$w2="80%";
$w3="70%";
$w4="60%";
$w5="50%";
}

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

if(!(isset($_REQUEST['school_code']))){
$_REQUEST['school_code']="";
}
$sql = "select distinct test_class from achievement_main where  test_type='1' 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'];
}

?>
<center>
<h2>ผลการสอบ O-NET</h2>
<h3><?php
if(isset($_REQUEST['class_index'])){
 echo $class_ar[$_REQUEST['class_index']];
} 
 ?></h3></center>
<?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']=='6'){
				$select_class_6="selected";
				}
				else if($_REQUEST['class_index']=='9'){
				$select_class_9="selected";
				}
				else if($_REQUEST['class_index']=='12'){
				$select_class_12="selected";
				}
	
echo  "<option value =6 $select_class_6>ชั้น ป.6</option>";
echo  "<option value =9 $select_class_9>ชั้น ม.3</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='1' and achievement_main.test_class='$_REQUEST[class_index]' and system_school.school_type='1' GROUP BY achievement_main.school 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)'>";
echo "</td></tr></table>";
echo "</form>";

$sql = "select distinct ed_year from achievement_main where  test_type='1' and test_class='$_REQUEST[class_index]' order by ed_year";
$qury = mysqli_query($connect,$sql);
while($result=mysqli_fetch_array($qury)){
			if($_REQUEST['school_code']==""){
			$strQuery = "select  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='$_REQUEST[class_index]' and ed_year='$result[ed_year]' ";
			}
			else{
			$strQuery = "select  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='$_REQUEST[class_index]' and ed_year='$result[ed_year]' and school='$_REQUEST[school_code]' ";
			}
			$dbquery = mysqli_query($connect,$strQuery);
			while($result_ach = mysqli_fetch_array($dbquery)){
			 $data[] = $result_ach['score_avg'];
			 $labels[] =$result['ed_year'];
			 }
}

echo "<table align='center'  border='1' style='border-collapse: collapse' width='$w4'><tr><td>";
?>
<canvas id="myChart" width="600" height="300"></canvas>
<script>
        var ctx = document.getElementById("myChart");
        var myChart = new Chart(ctx, {
            type: 'line',
            data: {
                labels: <?php echo json_encode($labels)?>,
                datasets: [{
                    label: 'คะแนนเฉลี่ยรายวิชา O-NET <?php echo $class_ar[$_REQUEST['class_index']] ?>',
                	data: <?php echo json_encode($data, JSON_NUMERIC_CHECK);?>,
                    backgroundColor: [
                        'rgba(255, 99, 132, 0.2)',
                        'rgba(54, 162, 235, 0.2)',
                        'rgba(255, 206, 86, 0.2)',
                        'rgba(75, 192, 192, 0.2)',
                        'rgba(153, 102, 255, 0.2)',
                        'rgba(255, 159, 64, 0.2)'
                    ],
                    borderColor: [
                        'rgba(255,99,132,1)',
                        'rgba(54, 162, 235, 1)',
                        'rgba(255, 206, 86, 1)',
                        'rgba(75, 192, 192, 1)',
                        'rgba(153, 102, 255, 1)',
                        'rgba(255, 159, 64, 1)'
                    ],
                    borderWidth: 1
                }]
            },
            options: {
                scales: {
                    yAxes: [{
                        ticks: {
                            beginAtZero:true
                        }
                    }]
                }
            }
        });
        </script>    
		
		<?php

echo "</td></tr></table>";

//ส่วนของตารางข้อมูล
if($_SESSION['user_os'] =="desktop"){
  //ส่วนของปีการศึกษา 
 	$strQuery = "select distinct ed_year from achievement_main where  test_type='1' and test_class='$_REQUEST[class_index]' 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;  //จำนวนปีที่แสดง

echo "<br>";
echo "<Table width='90%' Border='0' Bgcolor='#Fcf9d8' 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++){
  			if($_REQUEST['school_code']==""){
  			$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  achievement_main.test_type='1' and achievement_main.test_class='$_REQUEST[class_index]' and achievement_main.ed_year='$ed_year_ar[$x]' and achievement_main.score_avg>'0'  and system_school.school_type='1' ";
			}
			else{
	$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='1' and test_class='$_REQUEST[class_index]' and ed_year='$ed_year_ar[$x]' and school='$_REQUEST[school_code]' ";
			}
			$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);
		$english=number_format($ors['english'],2);
		$health=number_format($ors['health'],2);
		$art=number_format($ors['art'],2);
		$vocation=number_format($ors['vocation'],2);
		$score_avg=number_format($ors['score_avg'],2);		
		
		if($thai==0.00){
		$thai="";
		}
		if($math==0.00){
		$math="";
		}
		if($science==0.00){
		$science="";
		}
		if($social==0.00){
		$social="";
		}
		if($english==0.00){
		$english="";
		}
		if($health==0.00){
		$health="";
		}
		if($art==0.00){
		$art="";
		}
		if($vocation==0.00){
		$vocation="";
		}

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

${this.title}

Code Editor : report_onet.php