Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
install	[ DIR ]	drwxr-xr-x
manual	[ DIR ]	drwxr-xr-x
picture	[ DIR ]	drwxrwxrwx
upload	[ DIR ]	drwxrwxrwx
default.php	248 B	-rwxr-xr-x
ed_year.php	10.65 KB	-rwxr-xr-x
export_test.php	930 B	-rw-r--r--
export_to_excel.php	3.08 KB	-rwxr-xr-x
export_to_excel2.php	3.03 KB	-rwxr-xr-x
getxml_student.php	14.36 KB	-rw-r--r--
getxml_student.phpOLD	11.7 KB	-rwxr-xr-x
getxml_student2.php	9.39 KB	-rw-r--r--
index.php	258 B	-rwxr-xr-x
livesearch.php	625 B	-rwxr-xr-x
livesearch_2.php	640 B	-rwxr-xr-x
livesearch_3.php	629 B	-rwxr-xr-x
livesearch_mobile.php	630 B	-rwxr-xr-x
menu.php	5.64 KB	-rwxr-xr-x
menu_mobile.php	932 B	-rwxr-xr-x
permission.php	8.45 KB	-rwxr-xr-x
permission_sch.php	8.83 KB	-rwxr-xr-x
permission_sch_khet.php	13.49 KB	-rwxr-xr-x
return_permission_sch_khet.php	779 B	-rwxr-xr-x
student_getxml.php	2.51 KB	-rwxr-xr-x
student_getxml2.php	3.1 KB	-rwxr-xr-x
student_import.php	6.72 KB	-rwxr-xr-x
student_import2.php	8.26 KB	-rw-r--r--
student_import3.php	4.35 KB	-rw-r--r--
student_import_2.php	6.67 KB	-rw-r--r--
student_importx.php	6.36 KB	-rwxr-xr-x
student_khet_update.php	34.99 KB	-rwxr-xr-x
student_num.php	10.17 KB	-rw-r--r--
student_report1.php	14.48 KB	-rwxr-xr-x
student_report1_mobile.php	12.93 KB	-rwxr-xr-x
student_report2.php	9.46 KB	-rwxr-xr-x
student_report3.php	7.82 KB	-rwxr-xr-x
student_report4.php	10.73 KB	-rw-r--r--
student_report5.php	9.17 KB	-rw-r--r--
student_sch_update.php	25.93 KB	-rwxr-xr-x
student_tranfer.php	4.2 KB	-rw-r--r--

Code Editor : student_report5.php

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

//ปีการศึกษา
$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($index!=1){ 
$sql_1 = "select sum(student) as student_number1 from student_main_num where  ed_year='$year_active_result[ed_year]' " ;
$dbquery1 = mysqli_query($connect,$sql_1);
$result1 = mysqli_fetch_array($dbquery1);
$student_number1=$result1['student_number1'];

$sql_2 = "select count(student_main_main.id) as student_number2 from student_main_main left join system_school on student_main_main.school_code=system_school.school_code where  ed_year='$year_active_result[ed_year]' and system_school.school_type='1' and student_main_main.classlevel>'0' " ;
$dbquery2 = mysqli_query($connect,$sql_2);
$result2 = mysqli_fetch_array($dbquery2);
$student_number2=$result2['student_number2'];

if($student_number1!=$student_number2){
				echo "<script>document.location.href='?option=student_main&task=student_num&index=1';</script>\n";
		}
	
}

//ส่วนหัว
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>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ปีการศึกษา $year_active_result[ed_year]</strong></font></td></tr>";
echo "</table>";
echo "<br>";

if($index==1){
$sql = "select * from system_school where school_type='1' order by school_code";
$dbquery = mysqli_query($connect,$sql);

$N=1;
		While ($result = mysqli_fetch_array($dbquery))
			{
				$id = $result['id'];
				$school_code= $result['school_code'];
				$school_name= $result['school_name'];
				
				$sql_count= "select count(id) as student from student_main_main  where school_code='$school_code' and ed_year='$year_active_result[ed_year]' and (classlevel>=1 and classlevel<=15)";
				$dbquery_count = mysqli_query($connect,$sql_count);
				$result_count = mysqli_fetch_array($dbquery_count);
				$student_num=$result_count['student']; 
				
				//ก่อนประถม
				$sql_count_1= "select count(id) as student from student_main_main  where school_code='$school_code' and ed_year='$year_active_result[ed_year]' and (classlevel='1' or classlevel='2' or classlevel='3')";
				$dbquery_count_1 = mysqli_query($connect,$sql_count_1);
				$result_count_1 = mysqli_fetch_array($dbquery_count_1);
				$student_num_1=$result_count_1['student']; 
				
				//ประถม
				$sql_count_2= "select count(id) as student from student_main_main  where school_code='$school_code' and ed_year='$year_active_result[ed_year]' and (classlevel='4' or classlevel='5' or classlevel='6' or classlevel='7' or classlevel='8' or classlevel='9')";
				$dbquery_count_2 = mysqli_query($connect,$sql_count_2);
				$result_count_2 = mysqli_fetch_array($dbquery_count_2);
				$student_num_2=$result_count_2['student']; 
				
				//มัธบมศึกษา
				$sql_count_3= "select count(id) as student from student_main_main  where school_code='$school_code' and ed_year='$year_active_result[ed_year]' and (classlevel='10' or classlevel='11' or classlevel='12' or classlevel='13' or classlevel='14' or classlevel='15')";
				$dbquery_count_3 = mysqli_query($connect,$sql_count_3);
				$result_count_3 = mysqli_fetch_array($dbquery_count_3);
				$student_num_3=$result_count_3['student']; 
				
				$sql_num = "select * from student_main_num where school_code='$school_code' and 	ed_year='$year_active_result[ed_year]'";
				$dbquery_num = mysqli_query($connect,$sql_num);
				$num_rows=mysqli_num_rows($dbquery_num);

for($x = 1; $x <= 15; $x++){
						$sql_c1= "select count(id) as student from student_main_main  where school_code='$school_code' and ed_year='$year_active_result[ed_year]' and classlevel='$x' ";
						$dbquery_c1 = mysqli_query($connect,$sql_c1);
						$result_c1 = mysqli_fetch_array($dbquery_c1);
						$student[$x]=$result_c1['student']; 
				} //end for		
				
				if($num_rows<1){		
				$sql_insert = "insert into student_main_num (school_code,ed_year,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,student,pre_primary_std,primary_std,secondary_std) values ( '$school_code','$year_active_result[ed_year]',$student[1],$student[2],$student[3],$student[4],$student[5],$student[6],$student[7],$student[8],$student[9],$student[10],$student[11],$student[12],$student[13],$student[14],$student[15],'$student_num','$student_num_1','$student_num_2','$student_num_3')";
				$dbquery_insert = mysqli_query($connect,$sql_insert);
				}
				else{
				$sql_update = "update student_main_num set student='$student_num', pre_primary_std='$student_num_1', primary_std='$student_num_2', secondary_std='$student_num_3',c1=$student[1],c2=$student[2],c3=$student[3],c4=$student[4],c5=$student[5],c6=$student[6],c7=$student[7],c8=$student[8],c9=$student[9],c10=$student[10],c11=$student[11],c12=$student[12],c13=$student[13],c14=$student[14],c15=$student[15] where school_code='$school_code' and 	ed_year='$year_active_result[ed_year]'";
				$dbquery_update = mysqli_query($connect,$sql_update);
				}
				
		} //end while
}

//$sql = "select * from system_school left join student_main_num on system_school.school_code=student_main_num.school_code where system_school.school_type='1' and student_main_num.ed_year='$year_active_result[ed_year]' order by system_school.school_code";
$sql = "select * from system_school  where school_type='1' order by school_code";
$dbquery = mysqli_query($connect,$sql);
$N=1;
/*
$sum_pre_primary_std=0;
$sum_primary_std=0;
$sum_secondary_std=0;
$total_std=0;
$sum_c1=0;$sum_c2=0;$sum_c3=0;$sum_c4=0;$sum_c5=0;$sum_c6=0;$sum_c7=0;$sum_c8=0;$sum_c9=0;$sum_c10=0;$sum_c11=0;$sum_c12=0;$sum_c13=0;$sum_c14=0;$sum_c15=0;
*/
echo  "<table width='95%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#E6E6E6' align='center'><Td width='50'>ที่</Td> <Td>รหัสโรงเรียน</Td><Td>ชื่อโรงเรียน</Td><Td>นร.ทั้งหมด</Td><Td>จำนวนข้อมูล</Td><Td>On-air</Td><Td>On-hand</Td><Td>On-demand</Td><Td>Online</Td><Td>On-site<br>(รวม)</Td><Td>On-site<br>(ไม่มีอุปกรณ์)</Td><Td>On-site<br>(ไม่มีผู้ปกครองดูแล)</Td></Tr>";
		While ($result = mysqli_fetch_array($dbquery))
			{
				$id = $result['id'];
				$school_code= $result['school_code'];
				$school_name= $result['school_name'];
				
				$sql2 = "select * from student_main_main  where school_code='$school_code' and ed_year='$year_active_result[ed_year]' ";
				$dbquery2 = mysqli_query($connect,$sql2);
				$std_num=mysqli_num_rows($dbquery2);
				
				$sql3 = "select * from student_main_distant INNER JOIN student_main_main on student_main_distant.person_id=student_main_main.person_id where student_main_main.school_code='$school_code' and student_main_main.ed_year='$year_active_result[ed_year]' ";
				$dbquery3 = mysqli_query($connect,$sql3);
				$data_num=mysqli_num_rows($dbquery3);

echo "<tr align='center'><td>$N</td><td>$school_code</td><td align='left'>$school_name</td>";
echo "<td>$std_num</td><td>$data_num</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>";
echo "</tr>";			
$N++;	
		}
		/*
				$sum_pre_primary_std=number_format($sum_pre_primary_std);
				$sum_primary_std=number_format($sum_primary_std);
				$sum_secondary_std=number_format($sum_secondary_std);
				$total_std=number_format($total_std);
				
				$sum_c1=number_format($sum_c1);
				$sum_c2=number_format($sum_c2);
				$sum_c3=number_format($sum_c3);
				$sum_c4=number_format($sum_c4);
				$sum_c5=number_format($sum_c5);
				$sum_c6=number_format($sum_c6);
				$sum_c7=number_format($sum_c7);
				$sum_c8=number_format($sum_c8);
				$sum_c9=number_format($sum_c9);
				$sum_c10=number_format($sum_c10);
				$sum_c11=number_format($sum_c11);
				$sum_c12=number_format($sum_c12);
				$sum_c13=number_format($sum_c13);
				$sum_c14=number_format($sum_c14);
				$sum_c15=number_format($sum_c15);
*/
//echo "<tr align='center' bgcolor='#E6E6E6'><td colspan='3'>รวม</td><td>$sum_c1</td><td>$sum_c2</td><td>$sum_c3</td><td>$sum_pre_primary_std</td><td>$sum_c4</td><td>$sum_c5</td><td>$sum_c6</td><td>$sum_c7</td><td>$sum_c8</td><td>$sum_c9</td><td>$sum_primary_std</td><td>$sum_c10</td><td>$sum_c11</td><td>$sum_c12</td><td>$sum_c13</td><td>$sum_c14</td><td>$sum_c15</td><td>$sum_secondary_std</td><td>$total_std</td></tr>";
echo "</Table>";
?>

${this.title}

Code Editor : student_report5.php