Gecko [ 122.154.134.11 ]

Name	Size	Permission
add_score.php	1.58 KB	-rw-r--r--
add_test.php	9.11 KB	-rwxr-xr-x
curriculum.php	7.97 KB	-rwxr-xr-x
curriculum_view.php	25.22 KB	-rwxr-xr-x
examination_set.php	320 B	-rwxr-xr-x
export_to_excel.php	4.24 KB	-rw-r--r--
frm_add_test.php	1.77 KB	-rwxr-xr-x
indicator.php	37.07 KB	-rwxr-xr-x
item_display.php	6.68 KB	-rw-r--r--
khet_paper_report_1.php	61.73 KB	-rw-r--r--
khet_paper_report_2.php	65.56 KB	-rw-r--r--
khet_report_1.php	27.49 KB	-rwxr-xr-x
khet_report_1_mobile.php	8.38 KB	-rwxr-xr-x
khet_report_2.php	68.18 KB	-rwxr-xr-x
level_log.php	1.6 KB	-rw-r--r--
level_record.php	17.37 KB	-rw-r--r--
level_report_1.php	38.07 KB	-rw-r--r--
level_report_2.php	35.32 KB	-rw-r--r--
level_report_3.php	22.22 KB	-rw-r--r--
level_report_4.php	16.65 KB	-rw-r--r--
level_test.php	22.99 KB	-rw-r--r--
livesearch.php	721 B	-rwxr-xr-x
livesearch2.php	729 B	-rw-r--r--
livesearch3.php	756 B	-rw-r--r--
livesearch4.php	727 B	-rw-r--r--
livesearch5.php	1.16 KB	-rw-r--r--
livesearch6.php	1.41 KB	-rw-r--r--
master_test_report.php	16.2 KB	-rw-r--r--
permission.php	11.69 KB	-rwxr-xr-x
print_check.php	3.52 KB	-rw-r--r--
return_ajax_indicator.php	1.64 KB	-rwxr-xr-x
return_ajax_standard.php	805 B	-rwxr-xr-x
return_ajax_substance.php	1.36 KB	-rwxr-xr-x
sch_paper_report_1.php	62.36 KB	-rw-r--r--
sch_report_1.php	65.87 KB	-rwxr-xr-x
sch_report_1_mobile.php	10.62 KB	-rwxr-xr-x
school_limit.php	13.09 KB	-rw-r--r--
standard.php	19.24 KB	-rwxr-xr-x
student_paper_report_1.php	17.6 KB	-rw-r--r--
student_report_1.php	25.54 KB	-rwxr-xr-x
student_report_1_mobile.php	5.51 KB	-rwxr-xr-x
substance.php	16.58 KB	-rwxr-xr-x
test_admin.php	46.87 KB	-rwxr-xr-x
test_admin2.php	6.86 KB	-rw-r--r--
test_admin3.php	11.27 KB	-rw-r--r--
test_admin_book.php	75.57 KB	-rw-r--r--
test_admin_book2.php	19.74 KB	-rw-r--r--
test_import.php	7.86 KB	-rw-r--r--
test_item.php	93.56 KB	-rwxr-xr-x
test_master.php	46.2 KB	-rwxr-xr-x
test_qc.php	15.46 KB	-rw-r--r--
test_qc_person.php	8.05 KB	-rw-r--r--
test_sch.php	6.1 KB	-rwxr-xr-x
test_sch_2.php	26.76 KB	-rwxr-xr-x
test_student.php	34.71 KB	-rwxr-xr-x

Code Editor : level_report_1.php

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

/* Style the buttons inside the tab */
div.tab button {
    background-color: inherit;
    float: center;
    border: none;
    outline: none;
    cursor: pointer;
    padding: 14px 16px;
    transition: 0.3s;
}

/* Change background color of buttons on hover */
div.tab button:hover {
    background-color: #ddd;
}

/* Create an active/current tablink class */
div.tab button.active {
    background-color: #ccc;
}

</style>
<?php
// เชื่อมdatabase ชื่อ amssplus_bets
/////////
$user_db=$user;
if(isset($amssplus_bets)){   
$amssplus_bets=$amssplus_bets;
}
else{
$amssplus_bets="amssplus_bets"; 
}
$connect_bets=@mysqli_connect($hostname,$user_db,$password,$amssplus_bets);
		if($connect_bets){
		mysqli_query($connect_bets,"SET NAMES utf8");
		}
/////////
//end

if(!(isset($_REQUEST['subject']))){
$subject="thai";
}
else{
$subject=$_REQUEST['subject'];
}

if(!(isset($_REQUEST['year_index']))){
$_REQUEST['year_index']="";
$year_all=0;
}
else{
$year_all=1;
}

if(!(isset($_REQUEST['school_code']))){
		if($_SESSION['login_status']>=12){
		$_REQUEST['school_code']=$_SESSION['user_school'];
		}
		else{
		$_REQUEST['school_code']="";
		}
}

$thai_level[1]="ป.1 ภาคเรียนที่ 1";
$thai_level[2]="ป.1 ภาคเรียนที่ 2";
$thai_level[3]="ป.2 ภาคเรียนที่ 1";
$thai_level[4]="ป.2 ภาคเรียนที่ 2";
$thai_level[5]="ป.3 ภาคเรียนที่ 1";
$thai_level[6]="ป.3 ภาคเรียนที่ 2";
$thai_level[7]="ป.4 ภาคเรียนที่ 1";
$thai_level[8]="ป.4 ภาคเรียนที่ 2";
$thai_level[9]="ป.5 ภาคเรียนที่ 1";
$thai_level[10]="ป.5 ภาคเรียนที่ 2";
$thai_level[11]="ป.6 ภาคเรียนที่ 1";
$thai_level[12]="ป.6 ภาคเรียนที่ 2";
$thai_level[13]="ม.1 ภาคเรียนที่ 1";
$thai_level[14]="ม.1 ภาคเรียนที่ 2";
$thai_level[15]="ม.2 ภาคเรียนที่ 1";
$thai_level[16]="ม.2 ภาคเรียนที่ 2";
$thai_level[17]="ม.3 ภาคเรียนที่ 1";
$thai_level[18]="ม.3 ภาคเรียนที่ 2";
$thai_level[19]="ม.4ภาคเรียนที่ 1";
$thai_level[20]="ม.4 ภาคเรียนที่ 2";
$thai_level[21]="ม.5 ภาคเรียนที่ 1";
$thai_level[22]="ม.5 ภาคเรียนที่ 2";
$thai_level[23]="ม.6 ภาคเรียนที่ 1";
$thai_level[24]="ม.6 ภาคเรียนที่ 2";

if($index==7){
echo "<br>";

// ปรับปรุง 16 พย 61
if(isset($_GET['group_code'])){
$group_code=$_GET['group_code'];   
}
else{
			if($_GET['school_code']==''){
			$sql = "select  group_code from $_GET[subject] where  ed_year='$_GET[ed_year]' and level='$_GET[level]' order by id desc limit 1";
			}
			else{
			$sql = "select  group_code from $_GET[subject] where  ed_year='$_GET[ed_year]' and level='$_GET[level]' and school_code='$_GET[school_code]' order by id desc limit 1";
			}
$query = mysqli_query($connect_bets,$sql);
$result=mysqli_fetch_array($query);
$group_code=$result['group_code'];  
}
//

if($_GET['subject']=='thai'){
$thai_subject="ภาษาไทย";
}
else if($_GET['subject']=='math'){
$thai_subject="คณิตศาสตร์";
}
else if($_GET['subject']=='science'){
$thai_subject="วิทยาศาสตร์";
}
else if($_GET['subject']=='social'){
$thai_subject="สังคมศึกษา";
}
else if($_GET['subject']=='english'){
$thai_subject="มาตรฐานภาษาอังกฤษ";
}
else if($_GET['subject']=='english2'){
$thai_subject="ภาษาอังกฤษ(เพื่อการสื่อสาร)";
}

$subject=$_REQUEST['subject'];
$level=$_GET['level'];
$ed_year=$_REQUEST['ed_year'];
$school_code=$_REQUEST['school_code'];
$table_main=$_REQUEST['subject'];
$table_expand=$table_main."_expand_".$_GET['level'];

if($level==1 or $level==2){
$class_room=1;
}
else if($level==3 or $level==4){
$class_room=2;
}
else if($level==5 or $level==6){
$class_room=3;
}
else if($level==7 or $level==8){
$class_room=4;
}
else if($level==9 or $level==10){
$class_room=5;
}
else if($level==11 or $level==12){
$class_room=6;
}
else if($level==13 or $level==14){
$class_room=7;
}
else if($level==15 or $level==16){
$class_room=8;
}
else if($level==17 or $level==18){
$class_room=9;
}
else if($level==19 or $level==20){
$class_room=10;
}
else if($level==21 or $level==22){
$class_room=11;
}
else if($level==23 or $level==24){
$class_room=12;
}

echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>$thai_subject $thai_level[$level] (ระดับ $level)";
if(!($ed_year=="")){
echo " ปีการศึกษา $ed_year";
}
echo "</strong></font></td></tr>";
if(!($school_code=="")){
$sql = "select  school_name from system_school where school_code='$school_code'";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
echo "<tr align='center'><td><font color='#006666' size='2'><strong>$result[school_name]</strong></font></td></tr>";
}

$person_index=0;
if(isset($_GET['person_id'])){
			$sql_name = "select prename,name,surname from student_main_main where person_id='$_GET[person_id]'";
			$dbquery_name = mysqli_query($connect,$sql_name);
			$result_name = mysqli_fetch_array($dbquery_name);
echo "<tr align='center'><td><font color='#006666' size='2'><strong>$result_name[prename]$result_name[name] $result_name[surname]</strong></font></td></tr>";
$person_index=1;
}
echo "</table>";

//หาจำนวนผู้สอบ
		if($school_code==""){
					if($ed_year===""){
					$sql = "select id from $table_main where level='$level'";
					}
					else{
					$sql = "select id from $table_main where level='$level' and ed_year='$ed_year'";
					}
		}
		else{
					if($ed_year===""){
					$sql = "select id from $table_main where school_code='$school_code' and level='$level'";
					}
					else{
					$sql = "select id from $table_main where school_code='$school_code' and level='$level' and ed_year='$ed_year'";
					}
		}
		$dbquery = mysqli_query($connect_bets,$sql);
		$row_num = mysqli_num_rows($dbquery);
		
		//หาผลสอบรวม
		if($person_index==1){
		//รายบุคคล
					if($ed_year===""){
					$sql = "select avg(score) as avg_score from $table_main where person_id='$_GET[person_id]' and level='$level'";
					}
					else{
					$sql = "select avg(score) as avg_score from $table_main where person_id='$_GET[person_id]' and level='$level' and ed_year='$ed_year'";
					}
		}
		else{
		//ภาพรวมเขตและโรงเรียน
						if($school_code==""){
									if($ed_year===""){
									$sql = "select avg(score) as avg_score from $table_main where level='$level'";
									}
									else{
									$sql = "select avg(score) as avg_score from $table_main where level='$level' and ed_year ='$ed_year'";
									}
						}
						else{
									if($ed_year===""){
									$sql = "select avg(score) as avg_score from $table_main where school_code='$school_code' and level='$level'";
									}
									else{
									$sql = "select avg(score) as avg_score from $table_main where school_code='$school_code' and level='$level' and ed_year='$ed_year'";
									}
						}
		}				
		$dbquery = mysqli_query($connect_bets,$sql);
		$result = mysqli_fetch_array($dbquery);
		$avg_score=$result ['avg_score'];
		$total_percent=number_format($avg_score,2);
		
echo "<Table width='90%' Border='0' align='center'>";		
if($person_index==1){
echo "<tr><td align='left'><td align='right'>[<a href=?option=bets&task=main/level_report_1&school_code=$school_code&subject=$subject&ed_year=$ed_year&level=$level&index=8><<กลับ</a>]</td></tr>";	
}
else{
echo "<tr><td align='left'>จำนวนผู้สอบ : $row_num  คน</td><td align='right'>[<a href=?option=bets&task=main/level_report_1&school_code=$school_code&subject=$subject&year_index=$ed_year><<กลับ</a>]</td></tr>";	
}
echo "</table>";

/////////////////////////////////////
//กลุ่มสาระ
$sql_2 = "select * from bets_substance where group_code='$group_code' order by id ";
$dbquery_2 = mysqli_query($connect,$sql_2);
while($result_2 = mysqli_fetch_array($dbquery_2)){
			//สาระ
			$sql_2 = "select * from bets_substance where group_code='$group_code' order by id ";
			$dbquery_2 = mysqli_query($connect,$sql_2);
			while($result_2 = mysqli_fetch_array($dbquery_2)){
			$substance_code=$result_2['substance_code'];
			$substance_sum[$substance_code]="";  //ตัวแปรอาเรย์สาระ
			$substance_x[$substance_code]=0;  //ตัวแปรอาเรย์สาระ
					//มาตรฐาน
					$sql_3 = "select * from bets_standard where substance_code='$result_2[substance_code]' order by id ";
					$dbquery_3 = mysqli_query($connect,$sql_3);
					while($result_3 = mysqli_fetch_array($dbquery_3)){
					$standard_code=$result_3['standard_code'];
					$standard_sum[$standard_code]="";  //ตัวแปรอาเรย์มาตรฐาน
					$standard_x[$standard_code]=0;  //ตัวแปรอาเรย์มาตรฐาน
								//ตัวชี้วัด
								$sql_4 = "select * from bets_indicator where standard_code='$result_3[standard_code]' and class_code='$class_room' order by id ";
								$dbquery_4 = mysqli_query($connect,$sql_4);
								$M=1;
								while($result_4 = mysqli_fetch_array($dbquery_4)){
								$indicator_code=$result_4['indicator_code'];
								$indicator_sum[$indicator_code]="";
								$indicator_x[$indicator_code]=0;  //ตัวแปรอาเรย์ตัวชี้วัด

//คะแนนตัวชี้วัด
								if($person_index==1){
								//รายบุคคล
										   if($ed_year===""){
											$sql_4_1 = "select  $table_expand.score from $table_expand,$table_main where $table_expand.person_id=$table_main.person_id and indicator='$result_4[indicator_code]' and $table_main.level='$level' and $table_main.person_id='$_GET[person_id]' ";	
											}
											else{
											$sql_4_1 = "select  $table_expand.score from $table_expand,$table_main where $table_expand.person_id=$table_main.person_id and indicator='$result_4[indicator_code]' and $table_main.level='$level' and $table_main.person_id='$_GET[person_id]' and $table_main.ed_year='$ed_year' ";		
											}
								}
								else{
								//ภาพรวมเขตและโรงเรียน
											if($school_code==""){
														if($ed_year===""){
														$sql_4_1 = "select avg($table_expand.score) as score from $table_expand,$table_main where $table_expand.person_id=$table_main.person_id and indicator='$result_4[indicator_code]' and $table_main.level='$level' ";	
														}
														else{
														$sql_4_1 = "select avg($table_expand.score) as score from $table_expand,$table_main where $table_expand.person_id=$table_main.person_id and indicator='$result_4[indicator_code]' and $table_main.level='$level' and $table_main.ed_year='$ed_year' ";		
														}
											}
											else{
														if($ed_year===""){
														$sql_4_1 = "select avg($table_expand.score) as score from $table_expand,$table_main where $table_expand.person_id=$table_main.person_id and indicator='$result_4[indicator_code]' and $table_main.level='$level' and $table_main.school_code='$school_code' ";	
														}
														else{
														$sql_4_1 = "select avg($table_expand.score) as score from $table_expand,$table_main where $table_expand.person_id=$table_main.person_id and indicator='$result_4[indicator_code]' and $table_main.level='$level' and $table_main.school_code='$school_code' and $table_main.ed_year='$ed_year' ";		
														}
											}
								}		
								
											$dbquery_4_1 = mysqli_query($connect_bets,$sql_4_1);
											$result_4_1 = mysqli_fetch_array($dbquery_4_1);
											if($result_4_1['score']!=""){
											@$substance_sum[$substance_code]=$substance_sum[$substance_code]+$result_4_1['score'];
											$substance_x[$substance_code]=$substance_x[$substance_code]+1;
											
											@$standard_sum[$standard_code]=$standard_sum[$standard_code]+$result_4_1['score'];
											$standard_x[$standard_code]=$standard_x[$standard_code]+1;
											
											@$indicator_sum[$indicator_code]=$indicator_sum[$indicator_code]+$result_4_1['score'];
											$indicator_x[$indicator_code]=$indicator_x[$indicator_code]+1;
											}
			                    } // ตัวชี้วัด
					} //มาตรฐาน		
			} //สาระ
} //กลุ่มสาระ		
//////////////////////////////

echo "<Table width='90%' Border='0' align='center'>";
echo "<tr align='center' bgcolor='#FBD562'><td width='150'><b>กลุ่มสาระ</b></td><td width='150'><b>สาระ</b></td><td width='70'><b>มาตรฐาน</b></td><td width='350'><b>ตัวชี้วัด</b></td><td width='80'><b>ร้อยละ</b></td><td width='80'><b>ประเมินผล</b></td></tr>";
echo "<tr bgcolor='#CCFF66'><td colspan='4'><b>กลุ่มสาระ$thai_subject</b> [ผลรวมทั้งฉบับ]</td><td width='100' align='center'>$total_percent</td><td width='100' align='center'>";

$g1=50;
if($total_percent<$g1){
$bgcolor="#FF0000";
}
else {
$bgcolor="#66FF00";
}

echo "<table  border='0' cellspacing='0' cellpadding='0' width='25' height='15'>";
echo "<tr><td bgcolor='$bgcolor'></td></tr>";
 echo "</table>";

echo "</td></tr>";
		//คะแนนสาระ
		$sql_2 = "select * from bets_substance where group_code='$group_code' order by id ";
		$dbquery_2 = mysqli_query($connect,$sql_2);
		while($result_2 = mysqli_fetch_array($dbquery_2)){
		$substance_percent="";

$substance_code=$result_2['substance_code'];
		if($substance_x[$substance_code]!=0){
		$substance_percent=$substance_sum[$substance_code]/$substance_x[$substance_code];
		$substance_percent=number_format($substance_percent,2);
		}
		echo "<tr bgcolor='#66FFFF'><td></td><td colspan='3'><b>สาระ$result_2[substance_name]</b></td><td align='center'>$substance_percent ";
		echo "</td><td align='center'>";
if($substance_percent<$g1){
$bgcolor="#FF0000";
}
else {
$bgcolor="#66FF00";
}

if($substance_percent!=""){
 echo "<table  border='0' cellspacing='0' cellpadding='0' width='20' height='15'>";
echo "<tr><td bgcolor='$bgcolor'></td></tr>";
 echo "</table>";
 }
		echo "</td></tr>";
		
					//คะแนนมาตรฐาน
					$sql_3 = "select * from bets_standard where substance_code='$result_2[substance_code]' order by id ";
					$dbquery_3 = mysqli_query($connect,$sql_3);
					while($result_3 = mysqli_fetch_array($dbquery_3)){
					$standard_percent="";
					$standard_code=$result_3['standard_code'];				
					if($standard_x[$standard_code]!=0){
					$standard_percent=$standard_sum[$standard_code]/$standard_x[$standard_code];
					$standard_percent=number_format($standard_percent,2);
					}
					echo "<tr bgcolor='#FFCCCC'><td></td><td></td><td colspan='2'><b>มาตรฐาน $result_3[short_name]</b>$result_3[standard_text]</td><td align='center'>$standard_percent ";
					echo "</td><td align='center'>";
if($standard_percent<$g1){
$bgcolor="#FF0000";
}
else{
$bgcolor="#66FF00";
}

if($standard_percent!=""){
 echo "<table  border='0' cellspacing='0' cellpadding='0' width='13' height='13'>";
echo "<tr><td bgcolor='$bgcolor'></td></tr>";
 echo "</table>";
 }
					echo "</td></tr>";
					
								//หาคะแนนตัวชี้วัด
								$sql_4 = "select * from bets_indicator where standard_code='$result_3[standard_code]' and class_code='$class_room' order by id ";
								$dbquery_4 = mysqli_query($connect,$sql_4);
								$M=1;
								while($result_4 = mysqli_fetch_array($dbquery_4)){
								$indicator_percent="";
								$indicator_code=$result_4['indicator_code'];
								
								$indicator_percent=$indicator_sum[$indicator_code];
								if($indicator_x[$indicator_code]!=0){
								$indicator_percent=number_format($indicator_percent,2);
								}
								if(($M%2) == 0)
								$color="#FFFFC";
								else $color="#FFFFFF";
								$indicator_text=substr($result_4['indicator_text'],0,150);
								echo "<tr><td></td><td></td><td></td><td bgcolor=$color><b>ตัวชี้วัด</b>$result_4[indicator_text]</td><td bgcolor='$color' align='center'>$indicator_percent ";
								echo "</td><td bgcolor=$color align='center'>";
								
if($indicator_percent<$g1){
$bgcolor="#FF0000";
}
else{
$bgcolor="#66FF00";
}

if($indicator_percent!=""){
 echo "<table  border='0' cellspacing='0' cellpadding='0' width='13' height='13'>";
echo "<tr><td bgcolor='$bgcolor'></td></tr>";
 echo "</table>";
 }
								echo "</td></tr>";
								$M++;
								}
					}
		}

echo "</table>";

echo "<hr>";
echo "<div align='left'>";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>คำอธิบาย</b> สีแดงค่าคะแนนน้อยกว่าร้อยละ $g1 สีเขียวค่าคะแนนตั้งแต่ร้อยละ $g1 ขึ้นไป";
echo "</div>";

} //end if index==7

if($index==8){
?>
<br />
<div class="tab" align="left">
  &nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=thai&school_code=<?php echo $_REQUEST['school_code'];?>&ed_year=<?php echo $_REQUEST['ed_year'];?>&index=8&level=<?php echo $_REQUEST['level'];?>'>
<?php
if($subject=="thai"){
echo "<font size='3'>ภาษาไทย</font>";
}
else{
echo "<b>ภาษาไทย</b>";
}
?>
  </a>
 &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=math&school_code=<?php echo $_REQUEST['school_code'];?>&ed_year=<?php echo $_REQUEST['ed_year'];?>&index=8&level=<?php echo $_REQUEST['level'];?>'>
<?php
if($subject=="math"){
echo "<font size='3'>คณิตศาสตร์</font>";
}
else{
echo "<b>คณิตศาสตร์</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=science&school_code=<?php echo $_REQUEST['school_code'];?>&ed_year=<?php echo $_REQUEST['ed_year'];?>&index=8&level=<?php echo $_REQUEST['level'];?>'>
<?php
if($subject=="science"){
echo "<font size='3'>วิทยาศาสตร์</font>";
}
else{
echo "<b>วิทยาศาสตร์</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=social&school_code=<?php echo $_REQUEST['school_code'];?>&ed_year=<?php echo $_REQUEST['ed_year'];?>&index=8&level=<?php echo $_REQUEST['level'];?>'>
<?php
if($subject=="social"){
echo "<font size='3'>สังคมศึกษา</font>";
}
else{
echo "<b>สังคมศึกษา</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=english&school_code=<?php echo $_REQUEST['school_code'];?>&ed_year=<?php echo $_REQUEST['ed_year'];?>&index=8&level=<?php echo $_REQUEST['level'];?>'>
<?php
if($subject=="english"){
echo "<font size='3'>ภาษาอังกฤษ</font>";
}
else{
echo "<b>ภาษาอังกฤษ</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=english2&school_code=<?php echo $_REQUEST['school_code'];?>&ed_year=<?php echo $_REQUEST['ed_year'];?>&index=8&level=<?php echo $_REQUEST['level'];?>'>
<?php
if($subject=="english2"){
echo "<font size='3'>ภาษาอังกฤษเพื่อการสื่อสาร</font>";
}
else{
echo "<b>ภาษาอังกฤษเพื่อการสื่อสาร</b>";
}
?>
  </a>
</div>
<?php

$class_ar[1]="อนุบาล1";
$class_ar[2]="อนุบาล 2";
$class_ar[3]="อนุบาล 3";
$class_ar[4]="ป.1";
$class_ar[5]="ป.2";
$class_ar[6]="ป.3";
$class_ar[7]="ป.4";
$class_ar[8]="ป.5";
$class_ar[9]="ป.6";
$class_ar[10]="ม.1";
$class_ar[11]="ม.2";
$class_ar[12]="ม.3";
$class_ar[13]="ม.4";
$class_ar[14]="ม.5";
$class_ar[15]="ม.6";

$subject=$_REQUEST['subject'];
$level=$_GET['level'];
$ed_year=$_REQUEST['ed_year'];
$school_code=$_REQUEST['school_code'];
$table_main=$_REQUEST['subject'];

//ปีการศึกษาปัจจุบัน
$sql = "select ed_year from student_main_edyear where year_active='1'";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
$active_year=$result['ed_year'];

echo "<br>";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>$thai_subject $thai_level[$level] (ระดับ $level)";
if(!($ed_year=="")){
echo " ปีการศึกษา $ed_year";
}
if(!($school_code=="")){
$sql = "select  school_name from system_school where school_code='$school_code'";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
echo "<tr align='center'><td><font color='#006666' size='2'><strong>$result[school_name]</strong></font></td></tr>";
}
echo "</strong></font></td></tr>";
echo "</table>";

echo "<Table width='75%' Border='0' align='center'>";		
echo "<tr><td align='right'>";
echo "[<a href=?option=bets&task=main/level_report_1&school_code=$school_code&subject=$subject&year_index=$ed_year><<กลับไปวิชา</a>]";
if(isset($_GET['back_report_4'])){
echo "&nbsp;[<a href=?option=bets&task=main/level_report_4&school_code=$_GET[school_code]&year_index=$_GET[ed_year]&section=$_GET[section]><<กลับไปมาตรฐานสถานศึกษา</a>]";
}
echo "</td></tr>";	
echo "</table>";

echo "<table width='75%' border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo"<tr bgcolor='#ddd' align='center'><td width='70'>ที่</td><td>ชื่อ</td><td width='100'>คะแนน(%)</td><td width='300'>กราฟ</td><td width='50'>ราย<br>ละเอียด</td></tr>";
$N=1;
if($ed_year==""){
$sql_1 = "select person_id,score,group_code from $table_main where school_code='$_REQUEST[school_code]' and level='$_REQUEST[level]' order by id desc";
}
else{
$sql_1 = "select person_id,score,group_code from $table_main where school_code='$_REQUEST[school_code]' and level='$_REQUEST[level]' and ed_year='$ed_year' order by id desc";
}
$dbquery_1 = mysqli_query($connect_bets,$sql_1);
$student_number=0; //จำนวนนักเรียนทั้งหมด
$pass_student_number=0; //จำนวนนักเรียนที่ประเมินผ่าน
while($result_1 = mysqli_fetch_array($dbquery_1)){
$person_id=$result_1['person_id'];
$score=$result_1['score'];
$group_code=$result_1['group_code'];
$score=number_format($score,2);
			$classlevel=""; $prename=""; $name=""; $surname="";
			$sql_2 = "select prename,name,surname,classlevel from student_main_main where school_code='$_REQUEST[school_code]' and status='0' and person_id='$person_id' order by id desc limit 1";
			$dbquery_2 = mysqli_query($connect,$sql_2);
			if($result_2 = mysqli_fetch_array($dbquery_2)){
			$classlevel=$result_2['classlevel'];
			$prename=$result_2['prename'];
			$name=$result_2['name'];
			$surname=$result_2['surname'];
			echo "<tr><td align='center'>$N</td><td align='left'>$prename$name $surname</td><td align='center'>$score</td><td>";
			
		$student_number++;
		if($score>=50){
		$pass_student_number++;
		}
			
        echo "<table  border='0' cellspacing='0' cellpadding='0'>";
        echo "<tr><td></td>";
				$score_ceil=$score/2;
				for($j=0;$j<=$score_ceil;$j++){
						 		if ($j<25){
	  							$cl='#FF0000';
						  		}
						   		else if ($j>=25){
						  		$cl='#00CC00';
						  		}
					if($score_ceil>0){					
				   echo "<td bgcolor='$cl' width='1' >&nbsp;</td>";
				   }
		  	 }
          echo "</tr>";
          echo "</table>";
			
echo "</td><td align='center'>";
echo "<a href=?option=bets&task=main/level_report_1&index=7&school_code=$school_code&ed_year=$ed_year&subject=$subject&level=$level&person_id=$person_id&group_code=$group_code><img src=images/browse.png border='0'></a>";
echo "</td></tr>";
$N++;	
			} //end if ($result_2	
}
echo "</table>";
			echo "<table width='75%' border='0' align='center'>";
			echo "<tr><td>";
			if($student_number>0){
			$pass_percent=($pass_student_number/$student_number)*100;
			$pass_percent=number_format($pass_percent,2);
			echo "<font color='#006666'><strong>ผู้เรียนที่มีคะแนน 50% ขึ้นไป คิดเป็น ร้อยละ</strong></font>  $pass_percent";
			}
			echo "</td></tr>";
			echo "</table>";
} //end if index==8

if($index==""){

$sql = "select distinct ed_year from $subject order by ed_year desc";
				$dbquery = mysqli_query($connect_bets,$sql);
				$row_number=1;
				While ($result = mysqli_fetch_array($dbquery))	{
						if($result['ed_year']==$_REQUEST['year_index']){
						$_REQUEST['year_index']=$result['ed_year'];
						}
						else if($row_number==1 and $year_all==0){
						$_REQUEST['year_index']=$result['ed_year'];
						}
				$row_number++;	
				}

?>
<br />
<div class="tab" align="left">
  &nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=thai&school_code=<?php echo $_REQUEST['school_code'];?>&year_index=<?php echo $_REQUEST['year_index'];?>'>
<?php
if($subject=="thai"){
echo "<font size='3'>ภาษาไทย</font>";
}
else{
echo "<b>ภาษาไทย</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=math&school_code=<?php echo $_REQUEST['school_code'];?>&year_index=<?php echo $_REQUEST['year_index'];?>'>
<?php
if($subject=="math"){
echo "<font size='3'>คณิตศาสตร์</font>";
}
else{
echo "<b>คณิตศาสตร์</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=science&school_code=<?php echo $_REQUEST['school_code'];?>&year_index=<?php echo $_REQUEST['year_index'];?>'>
<?php
if($subject=="science"){
echo "<font size='3'>วิทยาศาสตร์</font>";
}
else{
echo "<b>วิทยาศาสตร์</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=social&school_code=<?php echo $_REQUEST['school_code'];?>&year_index=<?php echo $_REQUEST['year_index'];?>'>
<?php
if($subject=="social"){
echo "<font size='3'>สังคมศึกษา</font>";
}
else{
echo "<b>สังคมศึกษา</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=english&school_code=<?php echo $_REQUEST['school_code'];?>&year_index=<?php echo $_REQUEST['year_index'];?>'>
<?php
if($subject=="english"){
echo "<font size='3'>ภาษาอังกฤษ</font>";
}
else{
echo "<b>ภาษาอังกฤษ</b>";
}
?>
  </a>
  &nbsp;&nbsp;&nbsp;&nbsp;<a href='?option=bets&task=main/level_report_1&subject=english2&school_code=<?php echo $_REQUEST['school_code'];?>&year_index=<?php echo $_REQUEST['year_index'];?>'>
<?php
if($subject=="english2"){
echo "<font size='3'>ภาษาอังกฤษเพื่อการสื่อสาร</font>";
}
else{
echo "<b>ภาษาอังกฤษเพื่อการสื่อสาร</b>";
}
?>
  </a>
</div>
<?php

$english2[1]="";
$english2[2]="";
$english2[3]="";
$english2[4]="";
$english2[5]="";
$english2[6]="";
$english2[7]="";
$english2[8]="";
$english2[9]="";
$english2[10]="";
$english2[11]="";
$english2[12]="";
$english2[13]="";
$english2[14]="";
$english2[15]="";
$english2[16]="";
$english2[17]="";
$english2[18]="";
$english2[19]="";
$english2[20]="";
$english2[21]="";
$english2[22]="";
$english2[23]="";
$english2[24]="";

$level[1]="ป.1";
$level[2]="ป.1";
$level[3]="ป.2";
$level[4]="ป.2";
$level[5]="ป.3";
$level[6]="ป.3";
$level[7]="ป.4";
$level[8]="ป.4";
$level[9]="ป.5";
$level[10]="ป.5";
$level[11]="ป.6";
$level[12]="ป.6";
$level[13]="ม.1";
$level[14]="ม.1";
$level[15]="ม.2";
$level[16]="ม.2";
$level[17]="ม.3";
$level[18]="ม.3";
$level[19]="ม.4";
$level[20]="ม.4";
$level[21]="ม.5";
$level[22]="ม.5";
$level[23]="ม.6";
$level[24]="ม.6";

if($subject=='thai'){
$thai_subject="ภาษาไทย";
}
else if($subject=='math'){
$thai_subject="คณิตศาสตร์";
}
else if($subject=='science'){
$thai_subject="วิทยาศาสตร์";
}
else if($subject=='social'){
$thai_subject="สังคมศึกษา";
}
else if($subject=='english'){
$thai_subject="ภาษาอังกฤษ";
}
else if($subject=='english2'){
$thai_subject="ภาษาอังกฤษเพื่อการสื่อสาร";
}

echo "<br>";
				echo "<form id='frm1' name='frm1'>";
				echo "<table width='98%' align='center'>";
				echo "<Tr><td align='left' width='20%'><font color='#006666' size='3'><strong>มาตรฐาน $thai_subject</strong></font></td>";
				echo "<td align='center'>";
				echo "<Select  name='school_code' size='1'>";
				echo  '<option value ="" >ทุกโรงเรียน</option>' ;
				$sql = "select school_code,school_name from system_school order by school_type,school_code";
				$dbquery = mysqli_query($connect,$sql);
				While ($result = mysqli_fetch_array($dbquery)){
				
						if(($_SESSION['login_status']>10) and ($_SESSION['login_status']<=14)){
								if(($_REQUEST['school_code']==$_SESSION['user_school']) and ($_SESSION['user_school']==$result['school_code'])){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
								}
								else if($_SESSION['user_school']==$result['school_code']){
								echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
								}
						}
						else{
								if($_REQUEST['school_code']==$result['school_code']){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
								}
								else{
								echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
								}
						}	
							
				}
				echo "</select>";
				
				echo "<Select  name='year_index' size='1'>";
				$sql = "select distinct ed_year from $subject order by ed_year desc";
				$dbquery = mysqli_query($connect_bets,$sql);
				echo  '<option value ="" >ทุกปีการศึกษา</option>' ;
				$row_number=1;
				While ($result = mysqli_fetch_array($dbquery))	{
						if($result['ed_year']==$_REQUEST['year_index']){
						echo  "<option value = $result[ed_year] selected>ปีการศึกษา $result[ed_year]</option>";
						}
						else if($row_number==1 and $year_all==0){
						echo  "<option value = $result[ed_year] selected>ปีการศึกษา $result[ed_year]</option>";
						$_REQUEST['year_index']=$result['ed_year'];
						}
						else{
						echo  "<option value = $result[ed_year]>ปีการศึกษา $result[ed_year]</option>";
						}
				$row_number++;	
				}
				echo "</select>";				
				echo "<INPUT TYPE='hidden' name='subject' value='$subject'>";		
				echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_display(1)'>";
				echo "</td>";
				echo "<td align='right' width='20%'>";
				 if($_SESSION['login_status']<=4){
						?>
						ค้นหาโรงเรียน <input type="text" size="15" onkeyup="showResult(this.value)">
						<div id="livesearch"></div>
						<?php
				}		
				echo "</td>";				
				echo "</tr></table>";
				echo "</form>";

echo "<br>";
echo "<table width='70%' border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo"<tr bgcolor='#ddd' align='center'><td width='70'>ระดับ</td><td width='100'>ชั้น</td><td width='150'>ภาคเรียน</td><td width='100'>ร้อยละนักเรียนผ่าน50%</td><td width='100'>คะแนน(%)</td><td>กราฟ</td><td width='70'>รายละเอียด<br>ภาพรวม</td>";
if($_REQUEST['school_code']!=""){
		echo "<td width='70'>รายละเอียด<br>รายคน</td>";
}
echo "</tr>";
for ($i = 1; $i <= 24; $i++) {
		if(!($_REQUEST['school_code']=="") and !($_REQUEST['year_index']=="")){
		$sql = "select  avg(score) as score_avg$i from $subject where level='$i' and school_code='$_REQUEST[school_code]' and ed_year='$_REQUEST[year_index]' ";
		}
		else if(!($_REQUEST['school_code']=="") and ($_REQUEST['year_index']=="")){
		$sql = "select  avg(score) as score_avg$i from $subject where level='$i' and school_code='$_REQUEST[school_code]' ";
		}
		else if(($_REQUEST['school_code']=="") and !($_REQUEST['year_index']=="")){
		$sql = "select  avg(score) as score_avg$i from $subject where level='$i' and ed_year='$_REQUEST[year_index]' ";
		}
		else{
		$sql = "select  avg(score) as score_avg$i from $subject where level='$i' ";
		}
$query = mysqli_query($connect_bets,$sql);
$result=mysqli_fetch_array($query);
$score_avg[$i]= $result["score_avg$i"];
		if($score_avg[$i]>0){
		$score_avg[$i]= number_format($result["score_avg$i"],2);
		}
		
		if($i%2 == 0){
		$part="ภาคเรียนที่ 2";
		}
		else{
		$part="ภาคเรียนที่ 1";
		}
		
		if($i==3 or $i==4 or $i==7 or $i==8 or $i==11 or $i==12 or $i==15 or $i==16 or $i==19 or $i==20 or $i==23 or $i==24){
		$bg="#CCFFFF";
		}
		else{
		$bg="";
		}
		
echo"<tr align='center' bgcolor='$bg'><td>$i</td><td>$level[$i]</td><td>$part</td>";

//คำนวนร้อยละนักเรียนผ่าน50%
$std_number="0";
$std_pass="0";
$pass_percent="";
if($_REQUEST['year_index']!=""){
			if($_REQUEST['school_code']==""){
			$sql_num = "select id from $subject where level='$i' and ed_year='$_REQUEST[year_index]'";
			$sql_pass = "select count(id) as pass_id from $subject where score>='50' and level='$i' and ed_year='$_REQUEST[year_index]'";
			}
			else{
			$sql_num = "select id from $subject where school_code='$_REQUEST[school_code]' and level='$i' and ed_year='$_REQUEST[year_index]'";
			$sql_pass = "select count(id) as pass_id from $subject where score>='50'  and school_code='$_REQUEST[school_code]' and level='$i' and ed_year='$_REQUEST[year_index]'";
			}
			$dbquery_num = mysqli_query($connect_bets,$sql_num);
			$std_number=mysqli_num_rows($dbquery_num );

$dbquery_pass = mysqli_query($connect_bets,$sql_pass);
			$result_pass=mysqli_fetch_array($dbquery_pass);
			$std_pass=$result_pass['pass_id'];
			if($std_number!=0){
			$pass_percent=$std_pass/$std_number*100;
			$pass_percent=number_format($pass_percent,2);
			}
}
echo "<td>$pass_percent</td>";
///////////////////////

echo "<td>$score_avg[$i]</td><td align='left'>";

echo "<table  border='0' cellspacing='0' cellpadding='0'>";
        echo "<tr><td></td>";
				$score=$score_avg[$i];
				$score_ceil=$score/2;
				for($j=0;$j<=$score_ceil;$j++){
						 		if ($j<25){
	  							$cl='#FF0000';
						  		}
						   		else if ($j>=25){
						  		$cl='#00CC00';
						  		}
					if($score_ceil>0){					
				   echo "<td bgcolor='$cl' width='1' >&nbsp;</td>";
				   }
		  	 }
          echo "</tr>";
          echo "</table>";

echo "</td><td>";
if($score_avg[$i]>0){
echo "<a href=?option=bets&task=main/level_report_1&index=7&school_code=$_REQUEST[school_code]&ed_year=$_REQUEST[year_index]&subject=$subject&level=$i><img src=images/browse.png border='0'></a>";
}
echo "</td>";
if($_REQUEST['school_code']!=""){
			echo "<td>";
			if($score_avg[$i]>0){
			echo "<a href=?option=bets&task=main/level_report_1&index=8&school_code=$_REQUEST[school_code]&ed_year=$_REQUEST[year_index]&subject=$subject&level=$i><img src=images/admin/user.GIF border='0'></a>";
			}
			echo "</td>";
}		
echo "</tr>";
}
echo "</table>";
} //end if index==""

mysqli_close($connect_bets);
?>

function showResult(str) {
   var return_file="level_report_1";

if (str.length==0) { 
    document.getElementById("livesearch").innerHTML="";
    document.getElementById("livesearch").style.border="0px";
    return;
  }
  if (window.XMLHttpRequest) {
    // code for IE7+, Firefox, Chrome, Opera, Safari
    xmlhttp=new XMLHttpRequest();
  } else {  // code for IE6, IE5
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
  xmlhttp.onreadystatechange=function() {
    if (this.readyState==4 && this.status==200) {
      document.getElementById("livesearch").innerHTML=this.responseText;
      document.getElementById("livesearch").style.border="1px solid #A5ACB2";
    }
  }
  xmlhttp.open("GET","modules/bets/main/livesearch3.php?q="+str+"&return_file="+return_file,true);
  xmlhttp.send();
}

</script>

${this.title}

Code Editor : level_report_1.php