Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
index.php	1.01 KB	-rw-r--r--
level_report_1.php	40.3 KB	-rw-r--r--
level_report_2.php	33.4 KB	-rw-r--r--
level_report_3.php	22.45 KB	-rw-r--r--
level_report_4.php	14.48 KB	-rw-r--r--
sch_paper_report_1.php	63.51 KB	-rw-r--r--
sch_report_1.php	66.17 KB	-rw-r--r--
student_paper_report_1.php	17.79 KB	-rw-r--r--
student_report_1.php	25.36 KB	-rw-r--r--
test_admin3.php	12.46 KB	-rw-r--r--
test_admin_book2.php	20.8 KB	-rw-r--r--
test_sch.php	6.34 KB	-rw-r--r--
test_sch_2.php	30.45 KB	-rw-r--r--
test_student.php	36.36 KB	-rw-r--r--

Code Editor : level_report_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.' );

// เชื่อม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['year_index']))){
$_REQUEST['year_index']="";
}

if(!(isset($_POST['year_index']))){
$_POST['year_index']="";
}

if(!(isset($_REQUEST['class_index']))){
$_REQUEST['class_index']="";
}

//ให้ผู้ใช้ระดับโรงเรียนเห็นข้อมูลโรงเรียนตนเองทันที
$_REQUEST['school_index']=$remote_user_office;

//ปีงบประมาณ
$sql = "select * from  student_main_edyear  where year_active='1' order by  ed_year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$year_active_result = mysqli_fetch_array($dbquery);
if($year_active_result['ed_year']==""){
echo "<br />";
echo "<div align='center'>ยังไม่ได้กำหนดทำงานในปีการศึกษาใด ๆ  กรุณาไปที่เมนูตั้งค่าระบบ เพื่อกำหนดปีการศึกษา</div>";
exit();
}

if($_REQUEST['year_index']!=""){
$year_active_result['ed_year']=$_REQUEST['year_index'];
}

//อาเรย์ชั้น
$school_class_ar[0]="ไม่ระบุชั้น";
$school_class_ar[1]="อ.1(3ปี)";
$school_class_ar[2]="อ.1";
$school_class_ar[3]="อ.2";
$school_class_ar[4]="ป.1";
$school_class_ar[5]="ป.2";
$school_class_ar[6]="ป.3";
$school_class_ar[7]="ป.4";
$school_class_ar[8]="ป.5";
$school_class_ar[9]="ป.6";
$school_class_ar[10]="ม.1";
$school_class_ar[11]="ม.2";
$school_class_ar[12]="ม.3";
$school_class_ar[13]="ม.4";
$school_class_ar[14]="ม.5";
$school_class_ar[15]="ม.6";

$school_class_ar_2[1]="ประถมศึกษาปีที่ 1";
$school_class_ar_2[2]="ประถมศึกษาปีที่ 1";
$school_class_ar_2[3]="ประถมศึกษาปีที่ 2";
$school_class_ar_2[4]="ประถมศึกษาปีที่ 2";
$school_class_ar_2[5]="ประถมศึกษาปีที่ 3";
$school_class_ar_2[6]="ประถมศึกษาปีที่ 3";
$school_class_ar_2[7]="ประถมศึกษาปีที่ 4";
$school_class_ar_2[8]="ประถมศึกษาปีที่ 4";
$school_class_ar_2[9]="ประถมศึกษาปีที่ 5";
$school_class_ar_2[10]="ประถมศึกษาปีที่ 5";
$school_class_ar_2[11]="ประถมศึกษาปีที่ 6";
$school_class_ar_2[12]="ประถมศึกษาปีที่ 6";
$school_class_ar_2[13]="มัธยมศึกษาปีที่ 1";
$school_class_ar_2[14]="มัธยมศึกษาปีที่ 1";
$school_class_ar_2[15]="มัธยมศึกษาปีที่ 2";
$school_class_ar_2[16]="มัธยมศึกษาปีที่ 2";
$school_class_ar_2[17]="มัธยมศึกษาปีที่ 3";
$school_class_ar_2[18]="มัธยมศึกษาปีที่ 3";
$school_class_ar_2[19]="มัธยมศึกษาปีที่ 4";
$school_class_ar_2[20]="มัธยมศึกษาปีที่ 4";
$school_class_ar_2[21]="มัธยมศึกษาปีที่ 5";
$school_class_ar_2[22]="มัธยมศึกษาปีที่ 5";
$school_class_ar_2[23]="มัธยมศึกษาปีที่ 6";
$school_class_ar_2[24]="มัธยมศึกษาปีที่ 6";

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

if($index!=8){
echo "<br />";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>มาตรฐานการเรียนรู้นักเรียนรายบุคคล</strong></font></td></tr>";
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>";
}
echo "</table>";
}

if($index==7){
echo "<br>";
$person_id=trim($_GET['person_id']);

echo "<Table width='85%' Border='0' align='center'>";		
echo "<tr><td align='left'><td align='right'>[<a href=?file=level_report_2&school_index=$_GET[school_index]&class_index=$_GET[class_index]&page=$_GET[page]&year_index=$_GET[year_index]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><<กลับ</a>]</td></tr>";	
echo "</table>";

echo "<table width='85%' border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo"<tr bgcolor='#ddd' align='center'><td width='70'>ระดับ</td><td>ชั้น</td><td>ภาคเรียน</td><td width='100'>ภาษาไทย</td><td width='100'>คณิตศาสตร์</td><td width='100'>วิทยาศาสตร์</td><td width='100'>สังคมศึกษา</td><td width='100'>ภาษาอังกฤษ</td><td width='100'>ภาษาอังกฤษ<br>เพื่อการสื่อสาร</td>";
echo "</tr>";
for ($i = 1; $i <= 24; $i++) {

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="";
}
if($i%2 == 0){
$part="ภาคเรียนที่ 2";
}
else{
$part="ภาคเรียนที่ 1";
}

echo"<tr align='center' bgcolor='$bg'><td>$i</td><td>$school_class_ar_2[$i]</td><td>$part</td>";

for ($x = 1; $x <= 6; $x++) {
		$score="";
		$sql = "select  score from $subject_ar[$x] where level='$i' and person_id='$person_id' ";
		$query = mysqli_query($connect_bets,$sql);
		$result=mysqli_fetch_array($query);
		$score= $result['score'];
		if($score>0){
		$score= number_format($result["score"],2);
		}
		
		echo "<td>";

if($score<50){
			$bgcolor="#FF0000";
			}
			else{
			$bgcolor="#66FF00";
			}
			
			if($score!=""){
			 echo "<table  border='0' cellspacing='0' cellpadding='0' width='13' height='13'>";
			echo "<tr><td bgcolor='$bgcolor'></td></tr>";
			 echo "</table>";
			 }
			echo "<a href=?file=level_report_2&index=8&school_code=$_GET[school_index]&class_index=$_GET[class_index]&person_id=$person_id&subject=$subject_ar[$x]&level=$i&year_index=$_GET[year_index]&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync>$score</a>"; 
			echo "</td>";
			} //for x
echo "</tr>";
} //for i
echo "</table>";
echo "<Table width='85%' Border='0' align='center'>";		
echo "<tr><td align='left'><b>หมายเหตุ</b> ดูรายละเอียดรายมาตรฐาน ตัวชี้วัด คลิกที่คะแนน</td></tr>";	
echo "</table>";	
}

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

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

// ปรับปรุง 16 พย 61
$sql = "select  group_code from $_GET[subject] where  ed_year='$_GET[year_index]' and level='$_GET[level]' and person_id='$_GET[person_id]' 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="";
$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)";
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'>";		
echo "<tr><td align='left'><td align='right'>[<a href=?file=level_report_2&school_index=$_GET[school_code]&class_index=$_GET[class_index]&person_id=$_GET[person_id]&year_index=$_GET[year_index]&index=7&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><<กลับ</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_expand.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_expand.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 where indicator='$result_4[indicator_code]' and level='$level' ";	
														}
														else{
														$sql_4_1 = "select avg(score) as score from $table_expand where indicator='$result_4[indicator_code]' and level='$level' and 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_expand.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_expand.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>";
} //index==8

if($index==""){
//ส่วนการแสดงผล
//ส่วนของการแยกหน้า
$pagelen=50;  // 1_กำหนดแถวต่อหน้า
$url_link="file=level_report_2&year_index=$_REQUEST[year_index]&school_index=$_REQUEST[school_index]&class_index=$_REQUEST[class_index]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync";  // 2_กำหนดลิงค์ฺ
$sql = "select  id  from  student_main_main ";
		
			if(($_REQUEST['school_index']=="") and ($_REQUEST['class_index']=="")){
			$sql .= "where ed_year='$year_active_result[ed_year]'  ";
			}
			else if(($_REQUEST['school_index']!="") and ($_REQUEST['class_index']!="")){
			$sql .= "where  ed_year='$year_active_result[ed_year]' and classlevel='$_REQUEST[class_index]' and  school_code='$_REQUEST[school_index]'  ";
			}
			else if($_REQUEST['school_index']!=""){
			$sql .= "where  ed_year='$year_active_result[ed_year]' and school_code='$_REQUEST[school_index]'  ";
			}
			else if($_REQUEST['class_index']!=""){
			$sql .= "where ed_year='$year_active_result[ed_year]'  and  classlevel='$_REQUEST[class_index]'  ";
			}
	
$dbquery = mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($dbquery);
$totalpages=ceil($num_rows/$pagelen);

if(!(isset($_REQUEST['page']))){
$_REQUEST['page']="";
}

if($_REQUEST['page']==""){
$page=$totalpages;
		if($page<2){
		$page=1;
		}
}
else{
		if($totalpages<$_REQUEST['page']){
		$page=$totalpages;
					if($page<1){
					$page=1;
					}
		}
		else{
		$page=$_REQUEST['page'];
		}
}

$start=($page-1)*$pagelen;

if(($totalpages>1) and ($totalpages<16)){
echo "<div align=center>";
echo "หน้า	";
			for($i=1; $i<=$totalpages; $i++)	{
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
echo "</div>";
}			
if($totalpages>15){
			if($page <=8){
			$e_page=15;
			$s_page=1;
			}
			if($page>8){
					if($totalpages-$page>=7){
					$e_page=$page+7;
					$s_page=$page-7;
					}
					else{
					$e_page=$totalpages;
					$s_page=$totalpages-15;
					}
			}
			echo "<div align=center>";
			if($page!=1){
			$f_page1=$page-1;
			echo "<<a href=$PHP_SELF?$url_link&page=1>หน้าแรก </a>";
			echo "<<<a href=$PHP_SELF?$url_link&page=$f_page1>หน้าก่อน </a>";
			}
			else {
			echo "หน้า	";
			}					
			for($i=$s_page; $i<=$e_page; $i++){
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
			if($page<$totalpages)	{
			$f_page2=$page+1;
			echo "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>";
			echo "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>";
			}
			//echo " <select onchange=\"location.href=this.options[this.selectedIndex].value;\" size=\"1\" name=\"select\">";
			//echo "<option  value=\"\">หน้า</option>";
			//	for($p=1;$p<=$totalpages;$p++){
			//	echo "<option  value=\"?$url_link&page=$p\">$p</option>";
			//	}
			echo "</select>";
echo "</div>";  
}					
//จบแยกหน้า
 
 		//เลือกชั้น
		echo  "<table width=90% border='0' align='center'>";
		echo "<Tr><td align='right'>";
		echo "<form id='frm1' name='frm1'>";
		
		echo "<div align='right'>";
		echo "<Select  name='class_index' size='1'>";
		
				if($_REQUEST['class_index']=='0'){
				$select_class_0="selected";
				}
				else 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";
				}
				else if($_REQUEST['class_index']=='13'){
				$select_class_13="selected";
				}
				else if($_REQUEST['class_index']=='14'){
				$select_class_14="selected";
				}
				else if($_REQUEST['class_index']=='15'){
				$select_class_15="selected";
				}
	
		echo  "<option  value = ''>ทุกชั้น</option>" ;
		echo  "<option value =4 $select_class_4>ป.1</option>";
		echo  "<option value =5 $select_class_5>ป.2</option>";
		echo  "<option value =6 $select_class_6>ป.3</option>";
		echo  "<option value =7 $select_class_7>ป.4</option>";
		echo  "<option value =8 $select_class_8>ป.5</option>";
		echo  "<option value =9 $select_class_9>ป.6</option>";
		echo  "<option value =10 $select_class_10>ม.1</option>";
		echo  "<option value =11 $select_class_11>ม.2</option>";
		echo  "<option value =12 $select_class_12>ม.3</option>";
		echo  "<option value =13 $select_class_13>ม.4</option>";
		echo  "<option value =14 $select_class_14>ม.5</option>";
		echo  "<option value =15 $select_class_15>ม.6</option>";
		echo "</select>";
	
	//เลือก	โรงเรียน
		echo "<Select  name='school_index' size='1'>";
		$sql = "select * from  system_school  order by  school_type,school_code";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery))
		   {
					if($result['school_code']==$_REQUEST['school_index']){
					echo  "<option value = $result[school_code] selected>$result[school_code] $result[school_name]</option>";
					}
			}
		echo "</select>";
		
//เลือกปีการศึกษา
		echo "<Select  name='year_index' size='1'>";
		$sql = "select * from  student_main_edyear  order by ed_year";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery))
		   {
		   			if(($result['year_active']==1) and ($_REQUEST['year_index']=="")){
					echo  "<option value = $result[ed_year] selected>ปีการศึกษา $result[ed_year]</option>";
					}
					else if($result['ed_year']==$_REQUEST['year_index']){
					echo  "<option value = $result[ed_year] selected>ปีการศึกษา $result[ed_year]</option>";
					}
					else{
					echo  "<option value = $result[ed_year]>ปีการศึกษา $result[ed_year]</option>";
					}
			}
		echo "</select>";
		
		echo "&nbsp;<INPUT TYPE='button' name='smb' value='เลือก' onclick='goto_index(1)'>";
		echo "</div>";
		echo "<input type='hidden' name='remote_user_office' value='$remote_user_office'>";
		echo "<input type='hidden' name='remote_user_id' value='$remote_user_id'>";
		echo "<input type='hidden' name='remote_login_status' value='$remote_login_status'>";
		echo "<input type='hidden' name='remote_sync' value='$remote_sync'>";
		echo "</form>";
		echo "</td></Tr></Table>";
		//จบ

$sql = "select  * from  student_main_main ";
			if(($_REQUEST['school_index']=="") and ($_REQUEST['class_index']=="")){
			$sql .= "where ed_year='$year_active_result[ed_year]'  ";
			}
			else if(($_REQUEST['school_index']!="") and ($_REQUEST['class_index']!="")){
			$sql .= "where  ed_year='$year_active_result[ed_year]' and classlevel='$_REQUEST[class_index]' and  school_code='$_REQUEST[school_index]'  ";
			}
			else if($_REQUEST['school_index']!=""){
			$sql .= "where  ed_year='$year_active_result[ed_year]' and school_code='$_REQUEST[school_index]'  ";
			}
			else if($_REQUEST['class_index']!=""){
			$sql .= "where ed_year='$year_active_result[ed_year]'  and  classlevel='$_REQUEST[class_index]'  ";
			}
$sql .= " order by classlevel ,classroom, student_id limit $start,$pagelen";
$dbquery = mysqli_query($connect,$sql);

echo  "<table width='90%' border='1'  borderColor='#000000'  align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#ddd' align='center' ><Td width='50'>ที่</Td><Td width='90'>เลขประจำตัว<br>นักเรียน</Td><Td width='120'>เลขประจำตัว<br>ประชาชน</Td><Td align='center'>ชื่อ</Td><Td width='70'>ชั้น</Td><Td width='50'>ห้อง</Td><Td width='200'>โรงเรียน</Td><td width='70'>รายละเอียด</td></Tr>";
$N=(($page-1)*$pagelen)+1;  //*เกี่ยวข้องกับการแยกหน้า
$M=1;
While ($result = mysqli_fetch_array($dbquery))
	{
		
			if(($M%2) == 0)
			$color="#CCFFFF";
			else  	$color="#FFFFFF";
			$id=$result['id'];
			$classlevel=$result['classlevel'];
			$school_code=$result['school_code'];
			$person_id=$result['person_id'];
			$person_id=trim($person_id);
			
echo "<Tr  bgcolor=$color align='center'><Td>$N</Td><Td>$result[student_id]</Td><Td>$result[person_id]</Td>";
echo "<Td align='left'>$result[prename]$result[name]&nbsp;&nbsp;&nbsp;$result[surname]</Td>";
echo "<Td align='center'>$school_class_ar[$classlevel]</Td>";
echo "<Td align='center'>$result[classroom]</Td>";
echo "<Td align='left'>$result[school_name]</Td>";
echo "<td><a href=?file=level_report_2&index=7&person_id=$person_id&school_index=$school_code&class_index=$classlevel&year_index=$year_active_result[ed_year]&page=$page&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><img src=../../../images/browse.png border='0'></a></td>";
echo "</Tr>";
$M++;
$N++;  //*เกี่ยวข้องกับการแยกหน้า
	}
echo "</Table>";
}
mysqli_close($connect_bets);

?>
<script>

function goto_index(val){
	if(val==1){
		callfrm("?file=level_report_2");   
		}
}
</script>

${this.title}

Code Editor : level_report_2.php