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

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
include("FusionCharts/FusionCharts.php");
include("FusionCharts/Fc_Colors.php");
?>
	<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/FusionCharts.js"></SCRIPT>
	<style type="text/css">
	
	</style>

<CENTER>
<h2>คะแนนสอบ O-NET และผลการประเมิน</h2>
<h3>ชั้นมัธยมศึกษาปีที่ 3</h3>
<?php
echo "<form id='frm1' name='frm1'>";
echo "<table width='95%' align='center'><tr><td align='right'>";
echo "<Select  name='ed_year' size='1'>";
$sql = "select distinct ed_year from achievement_main where  test_type='1' and test_class='9' order by ed_year desc ";
$dbquery = mysql_db_query($dbname, $sql);
$year=1;
While ($result_year = mysql_fetch_array($dbquery)){
			$year_ar[$year]=$result_year[ed_year];
			if($_REQUEST[ed_year]==""){
			echo "<option value=$result_year[ed_year]>ปีการศึกษา $result_year[ed_year]</option>"; 
			}
			else{
					if($_REQUEST[ed_year]==$result_year[ed_year]){
					echo "<option value=$result_year[ed_year] selected>ปีการศึกษา $result_year[ed_year]</option>"; 
					}
					else{
					echo "<option value=$result_year[ed_year]>ปีการศึกษา $result_year[ed_year]</option>"; 
					}
			}		
$year++;			
}
	echo "</select>";
	echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_display(1)' class='entrybutton'>";
echo "</td></tr></table>";
echo "</form>";

echo "<Table width='95%' Border='0' Bgcolor='#Fcf9d8'>";
  echo "<Tr bgcolor='#FFCCCC'><Td  align='center' width='4%'>ที่</Td><Td  align='center' width='17%'>โรงเรียน</Td><Td  align='center' width='7%'>ภาษาไทย</Td><td align='center' width='7%' >คณิตศาสตร์</td><Td align='center'  width='7%'>วิทยาศาสตร์</Td><Td align='center' width='7%' >สังคมศึกษา</Td><Td align='center'  width='7%'>ภาษาอังกฤษ</Td><Td align='center' width='7%' >สุขศึกษา</Td><Td align='center'  width='7%'>ศิลปะ</Td><Td align='center' width='7%' >การงาน</Td><Td align='center' width='7%' >เฉลี่ย</Td><Td align='center' >ผลการประเมิน</Td></Tr>";
  
$sql = "select distinct 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='9' order by system_school.school_type, system_school.school_code ";
$dbquery = mysql_db_query($dbname, $sql);
$M=1;
While ($result_1 = mysql_fetch_array($dbquery)){
			if($_REQUEST[ed_year]==""){
			$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='1' and test_class='9' and ed_year='$year_ar[1]' and school='$result_1[school]' ";
			}
			else{
			$strQuery = "select thai, math, science, social, english, health, art, vocation, score_avg from achievement_main where test_type='1' and test_class='9' and ed_year='$_REQUEST[ed_year]' and school='$result_1[school]' ";
			}
			$result = mysql_query($strQuery);
			$ors = mysql_fetch_array($result);  
			if(($M%2) == 0)
			$color="#FFFFC";
			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($score_avg>0){
		 echo "<Tr bgcolor=$color><Td  align='center' >$M</Td><Td  align='left' >$result_1[school] $result_1[school_name]</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=60;
		$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>";		
?>
</CENTER>

${this.title}

Code Editor : report2_2.php