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_khetopportunity2.php

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

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

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

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

$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{
}

$start_year=$ed_year-12;  //11+1 ปี
$stop_year=$ed_year-6; //6 ปี

$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 "<div align='center'><font color='#006666'><strong>เด็กอายุ 6-11 ปี ติดตามเข้าเรียน ปีการศึกษา $ed_year</strong></font></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></Tr>";

$sql ="SELECT count(opportunity_population.id) as pop_total FROM opportunity_population left join $table on opportunity_population.person_id = $table.person_id
where (opportunity_population.birthday between '$date_start' and '$date_stop') and opportunity_population.check_pop='1' ";
$dbquery_sch = mysqli_query($connect,$sql);
$result_sch = mysqli_fetch_array($dbquery_sch);
$pop_total=$result_sch['pop_total'];
$pop_total2=number_format($pop_total);

$sql2="SELECT count($table.id) as toschool_total FROM opportunity_population left join $table on opportunity_population.person_id = $table.person_id
where (opportunity_population.birthday between '$date_start' and '$date_stop') and opportunity_population.check_pop='1' and $table.status='1' ";
$dbquery_sch2 = mysqli_query($connect,$sql2);
$result_sch2 = mysqli_fetch_array($dbquery_sch2);
$toschool_total=$result_sch2['toschool_total'];
$toschool_total2=number_format($toschool_total);

if($pop_total!=0){
	$action_percent=($toschool_total/$pop_total)*100;
	$action_percent=number_format($action_percent,2);
	}

echo "<Tr align='center'><Td>$pop_total2</Td><Td>$toschool_total2</Td><Td>$action_percent</Td></Tr>";

echo "</table>";
?>

${this.title}

Code Editor : livesearch_khetopportunity2.php