Gecko [ 122.154.134.11 ]

Name	Size	Permission
building_show.php	4.58 KB	-rw-r--r--
livesearch1.php	787 B	-rw-r--r--
livesearch_202.php	5.82 KB	-rw-r--r--
livesearch_2021.php	4.86 KB	-rw-r--r--
livesearch_204.php	11.9 KB	-rw-r--r--
livesearch_2041.php	9.97 KB	-rw-r--r--
livesearch_2044.php	11.8 KB	-rw-r--r--
livesearch_20441.php	9.83 KB	-rw-r--r--
livesearch_206.php	11.79 KB	-rw-r--r--
livesearch_2061.php	9.79 KB	-rw-r--r--
livesearch_301.php	3.16 KB	-rw-r--r--
livesearch_302.php	3.36 KB	-rw-r--r--
livesearch_ach.php	7.15 KB	-rw-r--r--
livesearch_ach_2.php	7.85 KB	-rw-r--r--
livesearch_allperson.php	1.59 KB	-rw-r--r--
livesearch_amphoe_school.php	1.53 KB	-rw-r--r--
livesearch_budget.php	10.99 KB	-rw-r--r--
livesearch_building.php	3.14 KB	-rw-r--r--
livesearch_chart2.php	625 B	-rw-r--r--
livesearch_chart3.php	872 B	-rw-r--r--
livesearch_chart3_2.php	987 B	-rw-r--r--
livesearch_chart3_3.php	1.37 KB	-rw-r--r--
livesearch_chart3_4.php	847 B	-rw-r--r--
livesearch_chart3_5.php	883 B	-rw-r--r--
livesearch_chart3_6.php	879 B	-rw-r--r--
livesearch_chart3_7.php	922 B	-rw-r--r--
livesearch_chart4.php	607 B	-rw-r--r--
livesearch_chart4_2.php	1.05 KB	-rw-r--r--
livesearch_computer.php	4.46 KB	-rw-r--r--
livesearch_g_ach_2.php	8.67 KB	-rw-r--r--
livesearch_health1.php	9.7 KB	-rw-r--r--
livesearch_health2.php	8.81 KB	-rw-r--r--
livesearch_khetopportunity.php	3.74 KB	-rw-r--r--
livesearch_khetopportunity2.ph...	3.8 KB	-rw-r--r--
livesearch_khetopportunity3.ph...	3.74 KB	-rw-r--r--
livesearch_khetperson.php	1.44 KB	-rw-r--r--
livesearch_nt.php	2.68 KB	-rw-r--r--
livesearch_nt2.php	3.05 KB	-rw-r--r--
livesearch_nt3.php	5.26 KB	-rw-r--r--
livesearch_opportunity.php	8 KB	-rw-r--r--
livesearch_opportunity2.php	8 KB	-rw-r--r--
livesearch_opportunity3.php	8.01 KB	-rw-r--r--
livesearch_plan.php	4.3 KB	-rw-r--r--
livesearch_plc.php	5.71 KB	-rw-r--r--
livesearch_plc2.php	3.15 KB	-rw-r--r--
livesearch_read.php	7.91 KB	-rw-r--r--
livesearch_sch_person.php	1.51 KB	-rw-r--r--
livesearch_school.php	2.19 KB	-rw-r--r--
livesearch_school_group.php	2.64 KB	-rw-r--r--
livesearch_school_group2.php	2.3 KB	-rw-r--r--
livesearch_small_school.php	1.95 KB	-rw-r--r--
livesearch_smss_std.php	5.28 KB	-rw-r--r--
livesearch_std.php	11.24 KB	-rw-r--r--
livesearch_std2.php	11.05 KB	-rw-r--r--
livesearch_std3.php	7.02 KB	-rw-r--r--
livesearch_std4.php	6.91 KB	-rw-r--r--
livesearch_std_check.php	3.31 KB	-rw-r--r--
livesearch_std_check2.php	3.28 KB	-rw-r--r--
livesearch_student.php	3.96 KB	-rw-r--r--
livesearch_student2.php	4.17 KB	-rw-r--r--
livesearch_student3.php	10.44 KB	-rw-r--r--
livesearch_student_list.php	5.22 KB	-rw-r--r--
livesearch_supervision.php	13.24 KB	-rw-r--r--
permission.php	11.13 KB	-rw-r--r--
school_report_1.php	52.88 KB	-rw-r--r--
school_report_2.php	36.59 KB	-rw-r--r--

Code Editor : livesearch_opportunity.php

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}
error_reporting(0);

if($_SESSION['user_os'] =="mobile"){
$width_1="97%";
}
else{
$width_1="80%";
}

require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

$q=$_GET["q"];

function getDateThai($date){
list($y,$m,$d) =preg_split("/-/",$date);
$y=$y+543;
return "$d/$m/$y";
}

function getDateEng($date){
list($d,$m,$y)= explode("/",$date);
$y=$y-543;
return "$y-$m-$d";
}

$_REQUEST['school_code']=$q;

$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'];
$ed_year_now=$result_edyear['ed_year'];
$table="opportunity_search".$ed_year;  //ตารางแต่ละปีการศึกษา

//หาตารางมีหรือไม่ หากไม่มีให้เพิ่มตาราง
$sql_table="SHOW TABLES FROM `$dbname` LIKE '$table' ";
$dbquery_table= mysqli_query($connect,$sql_table);
if($result_table= mysqli_fetch_array($dbquery_table)){
}
else{
}

$ed_year2=$ed_year-1;  //ปีก่อน
$table2="opportunity_search".$ed_year2; 
$sql2="SHOW TABLES FROM `$dbname` LIKE '$table2' ";
$dbquery2= mysqli_query($connect,$sql2);
if($result2= mysqli_fetch_array($dbquery2)){
$table2_status=1;
}
else{
$table2_status=0;
}

$start_year=$ed_year-6;  //5+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 " ";
echo "<div align='center'>เด็กในเขตพื้นที่บริการสถานศึกษา อายุ 3-5 ปี เข้าเรียน ปีการศึกษา $ed_year</div>";
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
echo "<Tr bgcolor='#FFCCCC' align='center'><Td>ที่</Td><Td>ชื่อ</Td><Td>วดป เกิด</Td><Td>บ้านเลขที่</Td><Td>หมู่ที่</Td><Td>ชื่อบ้าน</Td><Td>ตำบล</Td><Td>อำเภอ</Td><Td>จังหวัด</Td><Td>สถานศึกษา/สาเหตุ</Td><Td>ชั้น</Td></Tr>";
$M=1;
$N=0;
$sql ="SELECT *,opportunity_population.person_id FROM opportunity_population left join opportunity_village on opportunity_population.moo_code = opportunity_village.vill_code 
left join opportunity_tambon on opportunity_population.tambon = opportunity_tambon.tambon_code
left join opportunity_amphoe on opportunity_population.amphoe = opportunity_amphoe.amp_code
left join opportunity_province on opportunity_population.province = opportunity_province.prov_code
left join $table on opportunity_population.person_id = $table.person_id
where (opportunity_population.birthday between '$date_start' and '$date_stop') and check_pop='1'";
		$sql2="SELECT * FROM opportunity_sch_area where school_code='$_REQUEST[school_code]' and area_type='1' 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'";
				}
$sql_sch=$sql." order by province,amphoe,tambon,moo_code,birthday";

$dbquery_sch = mysqli_query($connect,$sql_sch);
While ($result_sch = mysqli_fetch_array($dbquery_sch)){
$person_id= $result_sch['person_id'];
$prename= $result_sch['prename'];
$name= $result_sch['name'];
$surname= $result_sch['surname'];
$birthday= $result_sch['birthday'];
$ban_no= $result_sch['ban_no'];
$moo_code= $result_sch['moo_code'];
$vill_no=substr($moo_code, -2, 2);
$vill_name= $result_sch['vill_name'];
$tambon_name= $result_sch['tambon_name'];
$amp_name= $result_sch['amp_name'];
$prov_name= $result_sch['prov_name'];
$study_school= $result_sch['study_school'];
$class= $result_sch['study_class'];
$cause= $result_sch['cause'];

if(($study_school!="") or ($cause>20)){
$N++;
}

$prename_text="";		
	if($prename=='001'){
	$prename_text="เด็กชาย";
	}
	else if($prename=='002'){
	$prename_text="เด็กหญิง";
	}	
	else if($prename=='003'){
	$prename_text="นาย";
	}	
	else if($prename=='004'){
	$prename_text="นางสาว";
	}

$class_text="";
if($class==1){
$class_text="อ.1(3ปี)";
}
else if($class==2){
$class_text="อ.1";
}
else if($class==3){
$class_text="อ.2";
}
else if($class==4){
$class_text="ป.1";
}
else if($class==5){
$class_text="ป.2";
}
else if($class==6){
$class_text="ป.3";
}
else if($class==7){
$class_text="ป.4";
}
else if($class==8){
$class_text="ป.5";
}
else if($class==9){
$class_text="ป.6";
}
else if($class==10){
$class_text="ม.1";
}
else if($class==11){
$class_text="ม.2";
}
else if($class==12){
$class_text="ม.3";
}
else if($class==13){
$class_text="ม.4";
}
else if($class==14){
$class_text="ม.5";
}
else if($class==15){
$class_text="ม.6";
}

if($cause>=21 and $cause<=29){
		if($cause==21){
		$study_school="ไม่พบตัวตนในพื้นที่";
		}
		else if($cause==22){
		$study_school="ตาย";
		}
		else if($cause==23){
		$study_school="พิการ/เจ็บป่วยรุนแรง";
		}
		else if($cause==24){
		$study_school="ย้ายออกนอกพื้นที่";
		}
		else if($cause==25){
		$study_school="ขาดแคลน/ยากจน";
		}
		else if($cause==26){
		$study_school="สมรส";
		}
		else if($cause==27){
		$study_school="ถูกดำเนินคดี";
		}
		else if($cause==28){
		$study_school="ไม่ต้องการเรียน";
		}
		else if($cause==29){
		$study_school="สาเหตุอื่น ๆ";
		}
}

if(($M%2) == 0)
		$color="#FFFFC";
		else  $color="#FFFFFF";

echo "<Tr bgcolor='$color' align='left'><td align='center'>$M</td><td>$prename_text$name $surname</td><td align='right'>";
echo thai_date_3($birthday);
echo "</td><td align='center'>$ban_no</td><td align='center'>$vill_no</td><td>$vill_name</td><td>$tambon_name</td><td>$amp_name</td><td>$prov_name</td><td>$study_school</td><td>$class_text</td>";
echo "</tr>";
$M++;
}
	if(($M-1)>0){
	$action_percent=($N/($M-1))*100;
	$action_percent=number_format($action_percent,2);
	}
	else{
	$action_percent=0;
	}
echo "<tr><td colspan='11' align='center'>ดำเนินการติดตามประชากรวัยเรียนให้ได้รับการศึกษา จำนวน $action_percent %</td></tr>";
echo "</table>";
?>

${this.title}

Code Editor : livesearch_opportunity.php