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_report4.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";
$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>อ.1</Td><Td>อ.2</Td><Td>อ.3</Td><Td>นร.ก่อนประถม</Td><Td>ป.1</Td><Td>ป.2</Td><Td>ป.3</Td><Td>ป.4</Td><Td>ป.5</Td><Td>ป.6</Td><Td>นร.ประถม</Td><Td>ม.1</Td><Td>ม.2</Td><Td>ม.3</Td><Td>ม.4</Td><Td>ม.5</Td><Td>ม.6</Td><Td>นร.มัธยม</Td><Td width='70'>นร.ทั้งหมด</Td></Tr>";
		While ($result = mysqli_fetch_array($dbquery))
			{
				$id = $result['id'];
				$school_code= $result['school_code'];
				$school_name= $result['school_name'];
				$pre_primary_std= $result['pre_primary_std'];
				$primary_std= $result['primary_std'];
				$secondary_std= $result['secondary_std'];
				$student= $result['student'];
				$c1= $result['c1'];
				$c2= $result['c2'];
				$c3= $result['c3'];
				$c4= $result['c4'];
				$c5= $result['c5'];
				$c6= $result['c6'];
				$c7= $result['c7'];
				$c8= $result['c8'];
				$c9= $result['c9'];
				$c10= $result['c10'];
				$c11= $result['c11'];
				$c12= $result['c12'];
				$c13= $result['c13'];
				$c14= $result['c14'];
				$c15= $result['c15'];
				
				$sum_c1=$sum_c1+$c1;
				$sum_c2=$sum_c2+$c2;
				$sum_c3=$sum_c3+$c3;
				$sum_c4=$sum_c4+$c4;
				$sum_c5=$sum_c5+$c5;
				$sum_c6=$sum_c6+$c6;
				$sum_c7=$sum_c7+$c7;
				$sum_c8=$sum_c8+$c8;
				$sum_c9=$sum_c9+$c9;
				$sum_c10=$sum_c10+$c10;
				$sum_c11=$sum_c11+$c11;
				$sum_c12=$sum_c12+$c12;
				$sum_c13=$sum_c13+$c13;
				$sum_c14=$sum_c14+$c14;
				$sum_c15=$sum_c15+$c15;

$sum_pre_primary_std=$sum_pre_primary_std+$pre_primary_std;
				$sum_primary_std=$sum_primary_std+$primary_std;
				$sum_secondary_std=$sum_secondary_std+$secondary_std;
				$total_std=$total_std+$student;
				
echo "<tr align='center'><td>$N</td><td>$school_code</td><td align='left'>$school_name</td>";
echo "<td>";
		if($c1>0){
		echo $c1;
		}
echo "</td><td>";
		if($c2>0){
		echo $c2;
		}
echo "</td><td>";
		if($c3>0){
		echo $c3;
		}
echo "</td><td bgcolor='#E6E6E6'>";
///
		if($pre_primary_std>0){
		echo $pre_primary_std;
		}
echo "</td><td>";
		if($c4>0){
		echo $c4;
		}
echo "</td><td>";
		if($c5>0){
		echo $c5;
		}
echo "</td><td>";
		if($c6>0){
		echo $c6;
		}
echo "</td><td>";
		if($c7>0){
		echo $c7;
		}
echo "</td><td>";
		if($c8>0){
		echo $c8;
		}
echo "</td><td>";
		if($c9>0){
		echo $c9;
		}
echo "</td><td bgcolor='#E6E6E6'>";
///
		if($primary_std>0){
		echo $primary_std;
		}
echo "</td><td>";
		if($c10>0){
		echo $c10;
		}
echo "</td><td>";
		if($c11>0){
		echo $c11;
		}
echo "</td><td>";
		if($c12>0){
		echo $c12;
		}
echo "</td><td>";
		if($c13>0){
		echo $c13;
		}
echo "</td><td>";
		if($c14>0){
		echo $c14;
		}
echo "</td><td>";
		if($c15>0){
		echo $c15;
		}
echo "</td><td bgcolor='#E6E6E6'>";

//
		if($secondary_std>0){
		echo $secondary_std;
		}
echo "</td><td>";
		if($student>0){
		echo $student;
		}
echo "</td></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_report4.php