Gecko [ 122.154.134.11 ]

Name	Size	Permission
area_check1.php	8.55 KB	-rw-r--r--
area_pop.php	12.51 KB	-rw-r--r--
area_pop_insert.php	22.78 KB	-rw-r--r--
khet_area.php	6.77 KB	-rw-r--r--
livesearch.php	665 B	-rw-r--r--
moo_list.php	14.93 KB	-rw-r--r--
out_school_report_1.php	21.51 KB	-rw-r--r--
out_school_report_2.php	21.52 KB	-rw-r--r--
out_school_report_3.php	21.51 KB	-rw-r--r--
report1.php	5.44 KB	-rw-r--r--
report2.php	9.34 KB	-rw-r--r--
report3.php	11.05 KB	-rw-r--r--
report4.php	11.57 KB	-rw-r--r--
report5.php	12.43 KB	-rw-r--r--
return_ajax_amphoe.php	603 B	-rw-r--r--
return_ajax_tambon.php	616 B	-rw-r--r--
return_ajax_village.php	662 B	-rw-r--r--
sch_operation.php	4.52 KB	-rw-r--r--
school_area.php	19.99 KB	-rw-r--r--
search.php	19.35 KB	-rw-r--r--
search2.php	19.36 KB	-rw-r--r--
search2_khet.php	18.75 KB	-rw-r--r--
search3.php	19.28 KB	-rw-r--r--
search3_khet.php	18.69 KB	-rw-r--r--
search_insert.php	17.01 KB	-rw-r--r--
search_khet.php	19.05 KB	-rw-r--r--

Code Editor : sch_operation.php

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

$sql_edyear ="SELECT ed_year FROM student_main_edyear where year_active='1' ";
$dbquery_edyear= mysqli_query($connect,$sql_edyear);
$result_edyear = mysqli_fetch_array($dbquery_edyear);
$ed_year=$result_edyear['ed_year'];
$table="opportunity_search".$ed_year;  //ตารางแต่ละปีการศึกษา

$start_year=$ed_year-15;  //14+1 ปี
$stop_year=$ed_year-3; //3 ปี

$date_start="17/05/$start_year";	
$date_stop="16/05/$stop_year";
$date_start_page=$date_start;
$date_stop_page=$date_stop;	
$date_start=getDateEng($date_start);
$date_stop=getDateEng($date_stop);

//ส่วนหัว
echo "<br />";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>รายงานการติดตามประชากร 3-14 ปี เข้าเรียน</strong></font></td></tr>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ปีการศึกษา $ed_year</strong></font></td></tr>";
echo "</table>";

echo  "<table width='70%' border='1' borderColor='#999999' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td width='10%'>ที่</Td><Td width='45%'>โรงเรียน</Td><td align='center' width='15%'>จำนวนประชากร<br>3-14 ปี</td><td align='center' width='15%'>ตรวจสอบ<br>การเข้าเรียนแล้ว</td><td align='center' width='15%'>% การตรวจสอบ</td></Tr>";
$M=1;
$sql_school = "select * from system_school where school_type='1' order by school_code";
$dbquery_school = mysqli_query($connect,$sql_school);
$pop_total=0;
$checked_pop_tatal=0;
While ($result_school = mysqli_fetch_array($dbquery_school)){
			
			///////////////////////////////////////
			$sql ="SELECT count(opportunity_population.person_id) as pop_num FROM opportunity_population left join opportunity_village on opportunity_population.moo_code = opportunity_village.vill_code 
			where (opportunity_population.birthday between '$date_start' and '$date_stop') and check_pop='1'";
					$sql2="SELECT * FROM opportunity_sch_area where school_code='$result_school[school_code]' and area_type='2' order by province,amphoe,tambon,village"; 	
					$dbquery2 = mysqli_query($connect,$sql2);
					$x=1;
					While ($result2 = mysqli_fetch_array($dbquery2)){
							if($x==1){
							$sql=$sql." and (";
							}
							if($x>1){
							$sql=$sql." or ";
							}
					$sql=$sql."opportunity_population.moo_code='$result2[village]'";
					$x++;
					}
							if($x>1){
							$sql=$sql.")";
							}
							else {
							$sql=$sql." and opportunity_population.moo_code='00000000'";
							}
							
			$dbquery = mysqli_query($connect,$sql);
			$result= mysqli_fetch_array($dbquery);
			$pop_num=$result['pop_num'];
			$pop_total=$pop_total+$pop_num;
			///////////////////////////////////////////
			$sql3 ="SELECT count(person_id) as checked_pop from $table where school_code='$result_school[school_code]' and status>='1' ";
			$dbquery3 = mysqli_query($connect,$sql3);
			$result3= mysqli_fetch_array($dbquery3);
			$checked_pop=$result3['checked_pop'];
			$checked_pop_tatal=$checked_pop_tatal+$checked_pop;
			////////////////////////////////////////////
			$percent="";
			if($pop_num!=0){
			$percent=$checked_pop/$pop_num*100;
			}
			
		if(($M%2) == 0)
		$color="#FFFFC";
		else 	$color="#FFFFFF";
		
		$pop_num=number_format($pop_num);
		$checked_pop=number_format($checked_pop);
		if($percent){
		$percent=number_format($percent,2);
		}
echo "<Tr bgcolor='$color' align='left'><td align='center'>$M</td><td>$result_school[school_code] $result_school[school_name]</td><td align='center'>$pop_num</td><td align='center'>$checked_pop</td><td align='center'>$percent %</td></tr>";
$M++;
}
		if($pop_total!=0){
		$percent_total=$checked_pop_tatal/$pop_total*100;
		}
		else{
		$percent_total="";
		}
		
		$pop_total=number_format($pop_total);
		$checked_pop_tatal=number_format($checked_pop_tatal);
		$percent_total=number_format($percent_total,2);
echo "<Tr bgcolor='#FFCCCC' align='left'><td align='center'></td><td align='center'>สรุป</td><td align='center'>$pop_total</td><td align='center'>$checked_pop_tatal</td><td align='center'>$percent_total %</td></tr>";
?>

${this.title}

Code Editor : sch_operation.php