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

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

<?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

$subject="thai";

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']="";
		}
}

if(!(isset($_REQUEST['section']))){
$section=1;
}
else{
$section=$_REQUEST['section'];
}

/////////////////////////////////////////////////
echo "<br>";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ร้อยละของนักเรียนที่มีผลการทดสอบร้อยละ 50 ขึ้นไป</strong></font></td></tr>";
echo "<tr align='center'><td><font color='#006666' size='2'><strong>ตามเกณฑ์มาตรฐานชั้นปี</strong></font></td></tr>";
echo "</table>";

$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++;	
				}

$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";

echo "<br>";
				echo "<form id='frm1' name='frm1'>";
				echo "<table width='80%' align='center'>";
				echo "<Tr>";
				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>";		
				
				if(!(isset($_REQUEST['section']))){
				$sql_section = "select id from $subject where ed_year='$_REQUEST[year_index]' and (level='2' or level='4' or level='6')";
				$dbquery_section = mysqli_query($connect_bets,$sql_section);
						if($result_section = mysqli_fetch_array($dbquery_section)){
						$section=2;
						}
				}
				
				echo "<Select  name='section' size='1'>";
				echo  '<option value =1 >ภาคเรียนที่ 1</option>' ;
				if($section==2){
				echo  '<option value =2 selected>ภาคเรียนที่ 2</option>' ;
				}
				else{
				echo  '<option value =2>ภาคเรียนที่ 2</option>' ;
				}
				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='left' 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>";

////////////////////////////

$subject_ar[1]="thai";
$subject_ar[2]="math";
$subject_ar[3]="science";
$subject_ar[4]="social";
$subject_ar[5]="english";
$subject_ar[6]="english2";

echo "<table  border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo"<tr bgcolor='#ddd' align='center'><td width='70' rowspan='2'>ระดับ</td><td width='100' rowspan='2'>ชั้น</td><td rowspan='2' width='150'>ภาคเรียน</td><td colspan='7'>ร้อยละของนักเรียนที่ได้คะแนนการทดสอบ 50% ขึ้นไป</td></tr>";
echo"<tr align='center'><td width='80'>ภาษาไทย</td><td width='80'>คณิต</td><td width='80'>วิทย์</td><td width='80'>สังคม</td><td width='80'>ภาษาอังกฤษ</td><td width='80'>ภาษาอังกฤษสื่อสาร</td><td width='80'><b>เฉลี่ยชั้น</b></td></tr>";

$avg="0";   $avg2="0"; $avg3="0";
$subject_num=0;  $subject_num2=0; $subject_num3=0;

$thai_num=0;  $thai_avg="0";
$math_num=0;  $math_avg="0";
$science_num=0;  $science_avg="0";
$social_num=0;  $social_avg="0";
$english_num=0;  $english_avg="0";
$english2_num=0;  $english2_avg="0";

for($x=1; $x<=18; $x++){
		if($x%2 == 0){
		$section_thai="ภาคเรียนที่ 2";
		}
		else{
		$section_thai="ภาคเรียนที่ 1";
		}

if($section==1){
				if($x%2==0){
				continue;
				}
		}
		else{
				if($x%2!=0){
				continue;
				}
		}
		
		echo"<tr align='center'><td>$x</td><td>$level[$x]</td><td>$section_thai</td>";
		
				$subject_inclass_num=0;  //จำนวยวิชาในชั้น
				$total_avg_inclass=0; //รวมค่าเฉลี่ยแต่ละวิชาในชั้น
				$avg_class=0; //ค่าเฉลี่ยในชั้น 6 วิชา		
		
				for($y=1; $y<=6; $y++){
				if($_REQUEST['school_code']==""){
				$sql_num = "select id from $subject_ar[$y] where level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_pass = "select id from $subject_ar[$y] where score>='50' and level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_avg = "select avg(score) as score_avg from $subject_ar[$y] where level='$x' and ed_year='$_REQUEST[year_index]'";
				}
				else{
				$sql_num = "select id from $subject_ar[$y] where school_code='$_REQUEST[school_code]' and level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_pass = "select id from $subject_ar[$y] where score>='50'  and school_code='$_REQUEST[school_code]' and level='$x' and ed_year='$_REQUEST[year_index]'";
				$sql_avg = "select avg(score) as score_avg from $subject_ar[$y] where school_code='$_REQUEST[school_code]' and level='$x' 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);
				$std_pass=mysqli_num_rows($dbquery_pass);
				
				$dbquery_avg = mysqli_query($connect_bets,$sql_avg);
				$result_avg = mysqli_fetch_array($dbquery_avg);
				$score_avg=$result_avg['score_avg'];
				if($score_avg>0){
				$score_avg2=number_format($score_avg,2);
				}
				else{
				$score_avg2="";
				}
				
				$pass_percent="";
				if($std_number!=0){
				$pass_percent=$std_pass/$std_number*100;
				$pass_percent=number_format($pass_percent,2);
				$subject_num++;
				$avg=$avg+$pass_percent;
							//เฉลี่ยประถม
							if($x<=12){
							$subject_num2++;
							$avg2=$avg2+$pass_percent;
							}
							//เฉลียมัธยม
							if($x>12 and $x<=18){
							$subject_num3++;
							$avg3=$avg3+$pass_percent;
							}
							
							if($y==1){
							$thai_num++;
							$thai_avg=$thai_avg+$pass_percent;;
							}
							else if($y==2){
							$math_num++;
							$math_avg=$math_avg+$pass_percent;;
							}
							else if($y==3){
							$science_num++;
							$science_avg=$science_avg+$pass_percent;;
							}
							else if($y==4){
							$social_num++;
							$social_avg=$social_avg+$pass_percent;;
							}
							else if($y==5){
							$english_num++;
							$english_avg=$english_avg+$pass_percent;;
							}
							else if($y==6){
							$english2_num++;
							$english2_avg=$english2_avg+$pass_percent;;
							}
				}
				
						$bg="";
						if($std_number!=0 and $pass_percent==0){
						$bg="#FF0000";
						}
						else if($pass_percent>0 and $pass_percent<25){
						$bg="#F78181";
						}
						else if($pass_percent>=25 and $pass_percent<50){
						$bg="#FFCCFF";
						}
						else if($pass_percent>=50 and $pass_percent<75){
						$bg="#FFFFCC";
						}
				
				if($score_avg2!=""){
					$subject_inclass_num=$subject_inclass_num+1;
					$total_avg_inclass=$total_avg_inclass+$pass_percent;
						if($subject_inclass_num>0){
						$avg_class=$total_avg_inclass/$subject_inclass_num;
						$avg_class=number_format($avg_class,2);
						}
				}
			
				echo "<td bgcolor='$bg'>$pass_percent";
						if(($score_avg2!="") and ($_REQUEST['school_code']=="")){
						echo "<br><font size='1'>($score_avg2)</font>";
						}
						else if(($score_avg2!="") and ($_REQUEST['school_code']!="")){
						echo "<a href=?option=bets&task=main/level_report_1&index=8&school_code=$_REQUEST[school_code]&ed_year=$_REQUEST[year_index]&subject=$subject_ar[$y]&level=$x&section=$section&back_report_4=1><br><font size='1'>($score_avg2)</font></a>";
						}
				echo "</td>";
				}
		// เฉลี่ยชั้น		
		if($subject_inclass_num!=0){		
			if($avg_class==0){
			$bg="#FF0000";
			}
			else if($avg_class<25){
			$bg="#F78181";
			}
			else if($avg_class<50){
			$bg="#FFCCFF";
			}
			else if($avg_class<75){
			$bg="#FFFFCC";
			}
			else{
			$bg="";
			}
		echo "<td bgcolor='$bg'><b>$avg_class</b></td>";		
		}
		else{
		echo "<td></td>";		
		}
		//
		echo "</tr>";
}
		if($avg!=0){
		$avg=$avg/$subject_num;
		$avg=number_format($avg,2);
		}
		if($avg2!=0){
		$avg2=$avg2/$subject_num2;
		$avg2=number_format($avg2,2);
		}
		if($avg3!=0){
		$avg3=$avg3/$subject_num3;
		$avg3=number_format($avg3,2);
		}
		if($thai_avg!=0){
		$thai_avg=$thai_avg/$thai_num;
		$thai_avg=number_format($thai_avg,2);
		}
		if($math_avg!=0){
		$math_avg=$math_avg/$math_num;
		$math_avg=number_format($math_avg,2);
		}
		if($science_avg!=0){
		$science_avg=$science_avg/$science_num;
		$science_avg=number_format($science_avg,2);
		}
		if($social_avg!=0){
		$social_avg=$social_avg/$social_num;
		$social_avg=number_format($social_avg,2);
		}
		if($english_avg!=0){
		$english_avg=$english_avg/$english_num;
		$english_avg=number_format($english_avg,2);
		}
		if($english2_avg!=0){
		$english2_avg=$english2_avg/$english2_num;
		$english2_avg=number_format($english2_avg,2);
		}
		
		$bg1=""; $bg2=""; $bg3=""; $bg4=""; $bg5=""; $bg6="";
						if($thai_avg>=0 and $thai_avg<25){
						$bg1="#F78181";
						}
						else if($thai_avg>=25 and $thai_avg<50){
						$bg1="#FFCCFF";
						}
						else if($thai_avg>=50 and $thai_avg<75){
						$bg1="#FFFFCC";
						}
						
						if($math_avg>=0 and $math_avg<25){
						$bg2="#F78181";
						}
						else if($math_avg>=25 and $math_avg<50){
						$bg2="#FFCCFF";
						}
						else if($math_avg>=50 and $math_avg<75){
						$bg2="#FFFFCC";
						}
						
						if($science_avg>=0 and $science_avg<25){
						$bg3="#F78181";
						}
						else if($science_avg>=25 and $science_avg<50){
						$bg3="#FFCCFF";
						}
						else if($science_avg>=50 and $science_avg<75){
						$bg3="#FFFFCC";
						}
						
						if($social_avg>=0 and $social_avg<25){
						$bg4="#F78181";
						}
						else if($social_avg>=25 and $social_avg<50){
						$bg4="#FFCCFF";
						}
						else if($social_avg>=50 and $social_avg<75){
						$bg4="#FFFFCC";
						}
						
						if($english_avg>=0 and $english_avg<25){
						$bg5="#F78181";
						}
						else if($english_avg>=25 and $english_avg<50){
						$bg5="#FFCCFF";
						}
						else if($english_avg>=50 and $english_avg<75){
						$bg5="#FFFFCC";
						}
						
						if($english2_avg>=0 and $english2_avg<25){
						$bg6="#F78181";
						}
						else if($english2_avg>=25 and $english2_avg<50){
						$bg6="#FFCCFF";
						}
						else if($english2_avg>=50 and $english2_avg<75){
						$bg6="#FFFFCC";
						}
		
echo"<tr align='center'><td colspan='3' rowspan='2'><b>เฉลี่ย</b></td>";

if($thai_num>0){
echo "<td bgcolor='$bg1'><b>$thai_avg</b></td>";
}
else{
echo "<td></td>";
}

if($math_num>0){
echo "<td bgcolor='$bg2'><b>$math_avg</b></td>";
}
else{
echo "<td></td>";
}

if($science_num>0){
echo "<td bgcolor='$bg3'><b>$science_avg</b></td>";
}
else{
echo "<td></td>";
}

if($social_num>0){
echo "<td bgcolor='$bg4'><b>$social_avg</b></td>";
}
else{
echo "<td></td>";
}

if($english_num>0){
echo "<td bgcolor='$bg5'><b>$english_avg</b></td>";
}
else{
echo "<td></td>";
}

if($english2_num>0){
echo "<td bgcolor='$bg6'><b>$english2_avg</b></td>";
}
else{
echo "<td></td>";
}
echo "<td></td>";
echo"<tr align='center'><td colspan='7'><b>$avg</b> ";
			if($subject_num3>0){
			echo "(ประถม <b>$avg2</b>)";
			echo " (มัธยม <b>$avg3</b>)";
			}
echo "</td>";
echo "<tr><td colspan='10'>";
echo " <b>&nbsp;&nbsp;หมายเหตุ </b>";
echo "&nbsp;&nbsp;พื้นสีแดง  0%";
echo "&nbsp;&nbsp;พื้นสีแสดน้อยกว่า  25%";
echo "&nbsp;&nbsp;พื้นสีม่วงน้อยกว่า 50%";
echo "&nbsp;&nbsp;พื้นสีเหลืองน้อยกว่า 75%";
echo "&nbsp;&nbsp;&nbsp;&nbsp;ในวงเล็บคือคะแนนเฉลี่ย";

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

mysqli_close($connect_bets);
?>

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

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