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 : school_report_1.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
?>
 <script src="chart/Chart.js"></script>

$("#datepicker-th-1").datepicker({ changeMonth: true, changeYear: true,dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay,dayNames: ['อาทิตย์','จันทร์','อังคาร','พุธ','พฤหัสบดี','ศุกร์','เสาร์'],
              dayNamesMin: ['อา.','จ.','อ.','พ.','พฤ.','ศ.','ส.'],
              monthNames: ['มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฎาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม'],
              monthNamesShort: ['ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.']});
		    $("#datepicker-th-2").datepicker({ changeMonth: true, changeYear: true,dateFormat: 'dd/mm/yy', isBuddhist: true, defaultDate: toDay,dayNames: ['อาทิตย์','จันทร์','อังคาร','พุธ','พฤหัสบดี','ศุกร์','เสาร์'],
              dayNamesMin: ['อา.','จ.','อ.','พ.','พฤ.','ศ.','ส.'],
              monthNames: ['มกราคม','กุมภาพันธ์','มีนาคม','เมษายน','พฤษภาคม','มิถุนายน','กรกฎาคม','สิงหาคม','กันยายน','ตุลาคม','พฤศจิกายน','ธันวาคม'],
              monthNamesShort: ['ม.ค.','ก.พ.','มี.ค.','เม.ย.','พ.ค.','มิ.ย.','ก.ค.','ส.ค.','ก.ย.','ต.ค.','พ.ย.','ธ.ค.']});
			});
</script>
<?php
 
if($_SESSION['user_os'] =="mobile"){
$w1="97%";
$w2="97%";
$w3="97%";
$w4="97%";
$w5="97%";
}
else{
$w1="100%";
$w2="80%";
$w3="70%";
$w4="60%";
$w5="50%";
}

//กรณีบุคลากรในโรงเรยน
if(($_SESSION['login_status']>=12) and ($_SESSION['login_status']<=14)){
$_REQUEST['school_code']=$_SESSION['user_school'];
}

if(!(isset($_REQUEST['school_code']))){
$_REQUEST['school_code']="";
}

$sql = "select * from  system_school";
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
$school_ar[$result['school_code']]=$result['school_name'];
}

echo "<br />";
echo "<table width='70%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>วิเคราะห์สภาพการณ์สถานศึกษา</strong></font></td></tr>";
if($_REQUEST['school_code']!=""){
echo "<tr align='center'><td><font color='#006666' size='2'><strong>";
echo $school_ar[$_REQUEST['school_code']];
echo "</strong></font></td></tr>";
}
echo "</table>";

//ส่วนการแสดงผล *
if($_SESSION['login_status']<=4){
echo "<form id='frm1' name='frm1'>";
echo "<table width='95%' align='center'>";

echo "<Tr><td align='right'>";
		?>
		ค้นหาโรงเรียน <input type="text" size="15" onkeyup="showResult(this.value)">
		<div id="livesearch"></div>
		<?php
		echo "</td></tr>";

echo "<tr><td align='right'>";
if($_SESSION['user_os'] =="desktop"){
echo "เลือกสถานศึกษา&nbsp";
}
echo "<Select  name='school_code' size='1' onchange='goto_display(1)'>";
echo  '<option value ="" >เลือก</option>' ;
$sql = "select * from  system_school order by school_type,school_code";
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
			if($_REQUEST['school_code']==""){
			echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
			}
			else{
					if($_REQUEST['school_code']==$result['school_code']){
					echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
					}
					else{
					echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
					}
			}		
}
	echo "</select>";
echo "</td></tr></table>";
echo "</form>";
}

//display
if($_REQUEST['school_code']==""){
	echo "<br />";
	echo "<br />";
	echo "<br />";
	echo "<div align='center'><img src='modules/warroom/images/warroom.jpg' border='0' width='20%'></div>";
}
else if($_REQUEST['school_code']!=""){
echo "<table border='0' style='border-collapse: collapse' width='95%' align='center'><tr align='center'><td>";
//////

//ปีการศึกษา
$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);
		
//d1 ข้อมูลพื้นฐาน
echo "<br>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#CED8F6'>";
echo "<td colspan='2' height='30'>&nbsp;&nbsp;<b>ข้อมูลพื้นฐาน</b></td>";
echo "</tr>";

$sql_school_detail = "select * from  system_school_detail where school_code='$_REQUEST[school_code]'";
$dbquery_school_detail = mysqli_query($connect,$sql_school_detail);
$result_school_detail = mysqli_fetch_array($dbquery_school_detail);
$edschool_type=$result_school_detail['edschool_type'];
if($edschool_type==1){
$sch_type="โรงเรียนอนุบาล";
}
else if($edschool_type==2){
$sch_type="โรงเรียนประถมศึกษา";
}
else if($edschool_type==3){
$sch_type="โรงเรียนขยายโอกาสทางการศึกษา";
}
else if($edschool_type==4){
$sch_type="โรงเรียนมัธยมศึกษา";
}
else{
$sch_type="ไม่ระบุ";
}

//จำนวนนร.สูงสุด
$sql_count= "select * from student_main_num  where school_code='$_REQUEST[school_code]' and ed_year='$year_active_result[ed_year]'";
$dbquery_count = mysqli_query($connect,$sql_count);
$result_count = mysqli_fetch_array($dbquery_count);
$student_max=0;
for($x = 1; $x <= 15; $x++){
$c="c".$x; 
$student_num=$result_count["$c"]; 
		if($student_num>$student_max){
		$student_max=$student_num;
				if($student_max>40){
				$student_max=40;
				}
		}
}

//จำนวนคอมพิวเตอร์ 
$sql_computer= "select equipment_num from dltv_equipment where school_code='$_REQUEST[school_code]' and equipment_type='1'";
$dbquery_computer = mysqli_query($connect,$sql_computer);
$result_computer = mysqli_fetch_array($dbquery_computer);
$computer_num=$result_computer['equipment_num'];  
if($computer_num!=""){
		if($student_max>0){
		$computer_percent=$computer_num/$student_max*100;
				if($computer_percent>100){
				$computer_percent=100;
				}
		$computer_percent=number_format($computer_percent,2);	
		}
}
else{
$computer_percent="";
}

echo "<tr align='left'>";
echo "<td colspan='2'>&nbsp;&nbsp;	<b>รหัสสถานศึกษา</b> : <font color='#31B404'>รหัส AMSSPLUS : $result_school_detail[school_code]&nbsp;&nbsp;&nbsp;&nbsp;รหัส ศธ : $result_school_detail[school_code10]</font></td>";
echo "</tr>";
echo "<tr align='left' bgcolor='#F2F2F2'>";
echo "<td colspan='2'>&nbsp;&nbsp;<b>ประเภทสถานศึกษา</b> : <font color='#31B404'>$sch_type</font></td>";
echo "</tr>";
echo "<tr align='left'>";
echo "<td colspan='2'>&nbsp;&nbsp;<b>ที่ตั้ง</b> : <font color='#31B404'>ตำบล$result_school_detail[tambon] อำเภอ$result_school_detail[amphoe] จังหวัด$result_school_detail[province] $result_school_detail[postcode] พิกัด$result_school_detail[map]</font></td>";
echo "</tr>";
echo "<tr align='left'>";
echo "<td colspan='2'>&nbsp;&nbsp;<b>ความพร้อมด้านคอมพิวเตอร์เพื่อการเรียนการสอน</b> : <font color='#31B404'>$computer_percent %</font>";
if($computer_percent!=""){
		if($computer_percent<50){
		echo "<font color='#FE2E64'>*****</font>";
		}
echo "  (";
echo  "มี ".$computer_num." "."ควรมี ".$student_max;
echo ")";
}

echo "</td>";
echo "</tr>";
echo "<tr align='center'>";
echo "<td align='left'>&nbsp;&nbsp;<b>อาคารสถานที่</b></td><td align='center' valign='top' width='60'><input type='button' id='building_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'building','val3','val4')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='building' style='display:none' align='center'></div>";
echo "<br>";

echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left' bgcolor='#F2F2F2'>";

$sql_count= "select count(id) as student from student_main_main  where school_code='$_REQUEST[school_code]' and ed_year='$year_active_result[ed_year]'";
		$dbquery_count = mysqli_query($connect,$sql_count);
		$result_count = mysqli_fetch_array($dbquery_count);
		$student_num=$result_count['student'];

echo "<td>&nbsp;&nbsp;<b>จำนวนนักเรียน</b> : <font color='#31B404'>(AMSS++ ปีการศึกษา $year_active_result[ed_year]) $student_num คน </font>";
echo "</td><td align='right' valign='top'>จำนวนนักเรียนแต่ละชั้น&nbsp;<input type='button' id='student_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'student','val3','val4')>";
if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}
echo "&nbsp;&nbsp;&nbsp;&nbsp;รายชื่อนักเรียน&nbsp;<input type='button' id='student_list_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'student_list','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='student' style='display:none' align='center'>";
		echo "</div>";
		echo "<div id='student_list' style='display:none'>";
		echo "</div>";
/////

echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left'>";
echo "<td>&nbsp;&nbsp;<b>รายชื่อนักเรียนในระบบ SMSS</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='smss_std_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'smss_std','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='smss_std' style='display:none' align='center'>";
		echo "</div>";
/////

echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left' bgcolor='#F2F2F2'>";
echo "<td>&nbsp;&nbsp;<b>แนวโน้มจำนวนนักเรียน</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='chart3_button' value='แสดงกราฟ' onclick=chart($_REQUEST[school_code],'chart3','edyear','student','จำนวนนักเรียน','line')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='chart3_div' style='display:none'>";
		echo "<br>";
		echo "<table align='center' border='1' style='border-collapse: collapse' width='$w4'><tr><td>";
		echo "<canvas id='chart3' width='600' height='300'></canvas>";
		echo "</td></tr></table>";
		echo "</div>";
/////
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left' bgcolor='#F2F2F2'>";
echo "<td>&nbsp;&nbsp;<b>แนวโน้มจำนวนประชากร</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='chart3_3_button' value='แสดงกราฟ' onclick=chart($_REQUEST[school_code],'chart3_3','edyear','student','จำนวนประชากร','line')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='chart3_3_div' style='display:none'>";
		echo "<br>";
		echo "<table align='center' border='1' style='border-collapse: collapse' width='$w4'><tr><td>";
		echo "<canvas id='chart3_3' width='600' height='300'></canvas>";
		echo "</td></tr></table>";
		echo "</div>";
/////

echo "<br>";

echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left' bgcolor='#F2F2F2'>";
$sql_person = "select * from person_sch_main left join  person_sch_position on person_sch_main.position_code= person_sch_position.position_code where person_sch_main.status='0' and person_sch_main.school_code='$_REQUEST[school_code]' order by person_sch_main.school_code, person_sch_main.position_code,person_sch_main.person_order";
$dbquery_person = mysqli_query($connect,$sql_person);
$person_num=mysqli_num_rows($dbquery_person);

echo "<td>&nbsp;&nbsp;<b>จำนวนครูและบุคลากรทางการศึกษา</b> :&nbsp;&nbsp;<font color='#31B404'>$person_num คน</font>";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='person_button' value='รายละเอียด' onclick=e_show('person')></td></tr>";
//////
echo "<tr><td colspan='2'>";
		echo "<div id='person' style='display:none'>";
		echo "<table  width='100%' border='1' style='border-collapse: collapse'>";
		$N=1;
		echo "<tr bgcolor='#FFCCCC' align='center'><td>ที่</td><td>ชื่อ</td><td>ตำแหน่ง</td><td>รูปภาพ</td></tr>";
		while($result_person = mysqli_fetch_array($dbquery_person)){
			if(($N%2) == 0){ 
			$color="#FFFFC";
			}
			else {
			$color="#FFFFFF";
			}
		echo "<tr bgcolor=$color><td>&nbsp;&nbsp;$N</td><td>$result_person[prename]$result_person[name]&nbsp;&nbsp;$result_person[surname]</td><td>&nbsp;&nbsp;$result_person[position_name]</td>";
		if($result_person['pic']!=""){
echo "<Td align='center'><a href='modules/person/pic_show_2.php?&person_id=$result_person[person_id]' target='_blank'><img src=images/admin/user.gif border='0' alt='รูปภาพ'></a></Td>";
		}
		else{
		echo "<Td align='center'>&nbsp;</Td>";
		}
		echo "</tr>";
		$N++;
		}
		echo "</table>";
		echo "</div>";
echo "</td></tr>";
///////////
echo "</table>";

echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left' bgcolor='#F2F2F2'>";
echo "<td>&nbsp;&nbsp;<b>ข้าราชการครูและบุคลากรทางการศึกษา เกษียณอายุ 15 ปีข้างหน้า</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='chart3_7_button' value='แสดงกราฟ' onclick=chart('$_REQUEST[school_code]','chart3_7','edyear','student','จำนวนผู้เกษียณ','line')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='chart3_7_div' style='display:none'>";
		echo "<br>";
		echo "<table align='center' border='1' style='border-collapse: collapse' width='$w4'><tr><td>";
		echo "<canvas id='chart3_7' width='600' height='300'></canvas>";
		echo "</td></tr></table>";
		echo "</div>";

//////////////////////////////////////////////////
echo "<br><br>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#CED8F6'>";
echo "<td colspan='2' height='30'>&nbsp;&nbsp;<b>คุณภาพผู้เรียน</b></td>";
echo "</tr>";
echo "</table>";

// NT
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center'>";
echo "<td align='left'>&nbsp;&nbsp;<b>ผลสอบ NT</b></td><td align='right'>แสดงข้อมูลแบบตาราง&nbsp;<input type='button' id='nt_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'nt','val3','val4')>";
if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}
echo "&nbsp;&nbsp;&nbsp;&nbsp;แสดงกราฟ&nbsp;<input type='button' id='chart4_button' value='แสดงกราฟ' onclick=chart($_REQUEST[school_code],'chart4','edyear','score_avg','คะแนนเฉลี่ย_NT','line')></td>";
echo "</tr>";
echo "</table>";
echo "<div id='nt' style='display:none' align='center'></div>";

echo "<div id='chart4_div' style='display:none'>";
		echo "<br>";
		echo "<table align='center' border='1' style='border-collapse: collapse' width='$w4'><tr><td>";
		echo "<canvas id='chart4' width='600' height='300'></canvas>";
		echo "</td></tr></table>";
		echo "</div>";
		echo "<br>";

// ONET
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#F2F2F2'>";
echo "<td align='left'>&nbsp;&nbsp;<b>ผลสอบ O-NET</b></td><td align='center' valign='top' width='60'><input type='button' id='ach_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'ach','val3','val4')></td>";
echo "</tr>";
echo "</table>";
echo "<div id='ach' style='display:none' align='center'></div>";

echo "<br>";
$class_ar[6]="ชั้นประถมศึกษาปีที่ 6";
$class_ar[9]="ชั้นมัธยมศึกษาปีที่ 3";
$class_ar[12]="ชั้นมัธยมศึกษาปีที่ 6";

$sql = "select distinct test_class from achievement_main where  test_type='1' and test_class='6' and school='$_REQUEST[school_code]' limit 1";
$qury = mysqli_query($connect,$sql);
if($result=mysqli_fetch_array($qury)){
			$strQuery = "select  score_avg,ed_year from achievement_main where test_type='1' and test_class='6' and school='$_REQUEST[school_code]' order by ed_year";
			$dbquery = mysqli_query($connect,$strQuery);
			while($result_ach = mysqli_fetch_array($dbquery)){
			 $data[] = $result_ach['score_avg'];
			 $labels[] =$result_ach['ed_year'];
			 }

echo "<table align='center' border='1' style='border-collapse: collapse'  width='$w4'><tr><td>";
?>
<canvas id="myChart" width="600" height="300"></canvas>
<script>
        var ctx = document.getElementById("myChart");
        var myChart = new Chart(ctx, {
            type: 'line',
            data: {
                labels: <?php echo json_encode($labels)?>,
                datasets: [{
                    label: 'คะแนนเฉลี่ยรายวิชา O-NET ชั้น ป.6',
                	data: <?php echo json_encode($data, JSON_NUMERIC_CHECK);?>,
                    backgroundColor: [
                        'rgba(255, 99, 132, 0.2)',
                        'rgba(54, 162, 235, 0.2)',
                        'rgba(255, 206, 86, 0.2)',
                        'rgba(75, 192, 192, 0.2)',
                        'rgba(153, 102, 255, 0.2)',
                        'rgba(255, 159, 64, 0.2)'
                    ],
                    borderColor: [
                        'rgba(255,99,132,1)',
                        'rgba(54, 162, 235, 1)',
                        'rgba(255, 206, 86, 1)',
                        'rgba(75, 192, 192, 1)',
                        'rgba(153, 102, 255, 1)',
                        'rgba(255, 159, 64, 1)'
                    ],
                    borderWidth: 1
                }]
            },
            options: {
                scales: {
                    yAxes: [{
                        ticks: {
                            beginAtZero:true
                        }
                    }]
                }
            }
        });
        </script>    
		
		<?php

echo "</td></tr></table>";
}

$sql = "select distinct test_class from achievement_main where  test_type='1' and test_class='9' and school='$_REQUEST[school_code]' limit 1";
$qury = mysqli_query($connect,$sql);
if($result=mysqli_fetch_array($qury)){
			$strQuery = "select  score_avg,ed_year from achievement_main where test_type='1' and test_class='9' and school='$_REQUEST[school_code]'  order by ed_year";
			$dbquery = mysqli_query($connect,$strQuery);
			while($result_ach = mysqli_fetch_array($dbquery)){
			 $data2[] = $result_ach['score_avg'];
			 $labels2[] =$result_ach['ed_year'];
			 }

echo "<table align='center' border='1' style='border-collapse: collapse'><tr><td width='$w4'>";
?>
<canvas id="myChart_onet2" width="600" height="300"></canvas>
<script>
        var ctx = document.getElementById("myChart_onet2");
        var myChart = new Chart(ctx, {
            type: 'line',
            data: {
                labels: <?php echo json_encode($labels2)?>,
                datasets: [{
                    label: 'คะแนนเฉลี่ยรายวิชา O-NET ชั้น ม.3',
                	data: <?php echo json_encode($data2, JSON_NUMERIC_CHECK);?>,
                    backgroundColor: [
                        'rgba(255, 99, 132, 0.2)',
                        'rgba(54, 162, 235, 0.2)',
                        'rgba(255, 206, 86, 0.2)',
                        'rgba(75, 192, 192, 0.2)',
                        'rgba(153, 102, 255, 0.2)',
                        'rgba(255, 159, 64, 0.2)'
                    ],
                    borderColor: [
                        'rgba(255,99,132,1)',
                        'rgba(54, 162, 235, 1)',
                        'rgba(255, 206, 86, 1)',
                        'rgba(75, 192, 192, 1)',
                        'rgba(153, 102, 255, 1)',
                        'rgba(255, 159, 64, 1)'
                    ],
                    borderWidth: 1
                }]
            },
            options: {
                scales: {
                    yAxes: [{
                        ticks: {
                            beginAtZero:true
                        }
                    }]
                }
            }
        });
        </script>    
		
		<?php

echo "</td></tr></table>";
}

//ผลการประเมินอนุบาล
echo "<br>";		
$this_year=date("Y");
$thai_this_year=$this_year+543; 
$this_month=date("m"); 
if($this_month<10){
$ed_this_year1=$thai_this_year-1;
$ed_this_year2=$thai_this_year-2;
}
else{
$ed_this_year1=$thai_this_year;
$ed_this_year2=$thai_this_year-1;
}

echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#F2F2F2'>";
echo "<td align='left'>&nbsp;&nbsp;<b>ผลการประเมินผู้เรียนตามมาตรฐานสำนักงานเขตพื้นที่การศึกษา ระดับอนุบาล</b></td></tr>";
echo "<tr align='center'>";
echo "<td>";
echo "<input type='button' id='std3_button1' value='ปีการศึกษา $ed_this_year2 ภาคเรียนที่ 1' onclick=ajax_show_3($_REQUEST[school_code],'std3',$ed_this_year2,'1','1')>&nbsp;&nbsp;";
echo "<input type='button' id='std3_button2' value='ปีการศึกษา $ed_this_year2 ภาคเรียนที่ 2' onclick=ajax_show_3($_REQUEST[school_code],'std3',$ed_this_year2,'2','2')>&nbsp;&nbsp;";

if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}

echo "<input type='button' id='std3_button3' value='ปีการศึกษา $ed_this_year1 ภาคเรียนที่ 1' onclick=ajax_show_3($_REQUEST[school_code],'std3',$ed_this_year1,'1','3')>&nbsp;&nbsp;";
echo "<input type='button' id='std3_button4' value='ปีการศึกษา $ed_this_year1 ภาคเรียนที่ 2' onclick=ajax_show_3($_REQUEST[school_code],'std3',$ed_this_year1,'2','4')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='std3' style='display:none' align='center'>";
		echo "</div>";
		
		echo "<div id='2021' style='display:block' align='center'>";
		echo "</div>";
		
		echo "<div id='2041' style='display:block' align='center'>";
		echo "</div>";

//d3 ผลสอบมาตรฐานเขต
echo "<br>"; 
$this_year=date("Y");
$thai_this_year=$this_year+543; 
$this_month=date("m"); 
if($this_month<10){
$ed_this_year1=$thai_this_year-1;
$ed_this_year2=$thai_this_year-2;
}
else{
$ed_this_year1=$thai_this_year;
$ed_this_year2=$thai_this_year-1;
}
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#F2F2F2'>";
echo "<td align='left'>&nbsp;&nbsp;<b>ผลการประเมินผู้เรียนตามมาตรฐานสำนักงานเขตพื้นที่การศึกษา ระดับประถมศึกษาและมัธยมศึกษา</b></td></tr>";
echo "<tr align='center'>";
echo "<td><input type='button' id='std_button1' value='ปีการศึกษา $ed_this_year2 ภาคเรียนที่ 1' onclick=ajax_show_2($_REQUEST[school_code],'std',$ed_this_year2,'1','1')>&nbsp;&nbsp;<input type='button' id='std_button2' value='ปีการศึกษา $ed_this_year2 ภาคเรียนที่ 2' onclick=ajax_show_2($_REQUEST[school_code],'std',$ed_this_year2,'2','2')>&nbsp;&nbsp;";
if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}
echo "<input type='button' id='std_button3' value='ปีการศึกษา $ed_this_year1 ภาคเรียนที่ 1' onclick=ajax_show_2($_REQUEST[school_code],'std',$ed_this_year1,'1','3')>&nbsp;&nbsp;<input type='button' id='std_button4' value='ปีการศึกษา $ed_this_year1 ภาคเรียนที่ 2' onclick=ajax_show_2($_REQUEST[school_code],'std',$ed_this_year1,'2','4')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='std' style='display:none' align='center'>";
		echo "</div>";
		
		echo "<div id='202' style='display:block' align='center'>";
		echo "</div>";
		
		echo "<div id='204' style='display:block' align='center'>";
		echo "</div>";
		
//การคัดกรองการอ่านการเขียน
echo "<br>";		
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left'  bgcolor='#F2F2F2'>";
echo "<td>&nbsp;&nbsp;<b>การอ่านการเขียน</b> :  ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='read_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'read','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='read' style='display:none'>";
		echo "</div>";
/////

// สุขภาพผู้เรียน
echo "<br>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#F2F2F2'>";
echo "<td align='left'>&nbsp;&nbsp;<b>สุขภาพผู้เรียน</b></td><td align='right'>น้ำหนัก ส่วนสูง ตามเกณฑ์อายุ&nbsp;&nbsp;<input type='button' id='health2_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'health2','val3','val4')>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ความสมดุล น้ำหนักกับส่วนสูง&nbsp;&nbsp;<input type='button' id='health1_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'health1','val3','val4')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='health1' style='display:none' align='center'></div>";
		echo "<div id='health2' style='display:none' align='center'></div>";

//นิเทศ
echo "<br>";			
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left'>";
echo "<td>&nbsp;&nbsp;<b>การนิเทศ ติดตาม และประเมินผลการจัดการศึกษา</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='supervision_button' value='รายละเอียด' onclick=ajax_show('$_REQUEST[school_code]','supervision','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='supervision' style='display:none'>";
		echo "</div>";
/////

//สิทธิและโอกาส		
echo "<br><br>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#CED8F6'>";
echo "<td colspan='2' height='30'>&nbsp;&nbsp;<b>สิทธิและโอกาส</b></td>";
echo "</tr>";
echo "</table>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left'>";
echo "<td>&nbsp;&nbsp;<b>การติดตามเด็กวัยเรียนให้ได้รับการศึกษา</b> : ";
echo "</td><td align='center' valign='top'>3-5 ปี <input type='button' id='opportunity_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'opportunity','val3','val4')>";
if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}
echo "&nbsp;&nbsp;&nbsp;&nbsp;6-11 ปี <input type='button' id='opportunity2_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'opportunity2','val3','val4')>";
if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}
echo "&nbsp;&nbsp;&nbsp;&nbsp;12-15 ปี <input type='button' id='opportunity3_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'opportunity3','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='opportunity' style='display:none' align='center'></div>";
		echo "<div id='opportunity2' style='display:none' align='center'></div>";
		echo "<div id='opportunity3' style='display:none' align='center'></div>";
/////

//ประสิทธิภาพการบริหารงาน	
echo "<br><br>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='center' bgcolor='#CED8F6'>";
echo "<td colspan='2' height='30'>&nbsp;&nbsp;<b>ประสิทธิภาพการบริหารงาน</b></td>";
echo "</tr>";
echo "</table>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left'>";
echo "<td>&nbsp;&nbsp;<b>การวางแผน</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='plan_button' value='รายละเอียด' onclick=ajax_show($_REQUEST[school_code],'plan','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='plan' style='display:none' align='center'></div>";
/////

// การมาเรียน
echo "<br>";
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left' bgcolor='#F2F2F2'>";
$today=date("Y-m-d");
$today=getDateThai($today);
echo "<td width='30%'>&nbsp;&nbsp;<b>การมาเรียนของนักเรียน</b> :</td><td align='right'>มาเรียนวันที่ <Input Type='Text' Name='check_day' id='datepicker-th-1' Size='10' value='$today'>&nbsp;<input type='button' id='std_check2_button' value='รายละเอียด' onclick=ajax_std_check3($_REQUEST[school_code],'std_check2','val3','val4')>";
if($_SESSION['user_os'] =="mobile"){
echo "<br>";
}
echo "&nbsp;&nbsp;&nbsp;&nbsp;ตลอดปีการศึกษา&nbsp;<input type='button' id='std_check_button' value='รายละเอียด' onclick=ajax_std_check1($_REQUEST[school_code],'std_check','val3','val4')></td>";
echo "</tr>";
echo "</table>";
		echo "<div id='std_check2' style='display:none' align='center'></div>";
		echo "<div id='std_check' style='display:none' align='center'></div>";
		echo "<div id='3011_div' style='display:none' align='center'></div>";
		echo "<div id='3012_div' style='display:none' align='center'></div>";
		echo "<div id='3013_div' style='display:none' align='center'></div>";
		echo "<div id='3014_div' style='display:none' align='center'></div>";
		echo "<div id='3015_div' style='display:none' align='center'></div>";
		echo "<div id='3016_div' style='display:none' align='center'></div>";
		echo "<div id='3017_div' style='display:none' align='center'></div>";
		echo "<div id='3018_div' style='display:none' align='center'></div>";
		echo "<div id='3019_div' style='display:none' align='center'></div>";
		echo "<div id='30110_div' style='display:none' align='center'></div>";
		echo "<div id='30111_div' style='display:none' align='center'></div>";
		echo "<div id='30112_div' style='display:none' align='center'></div>";
		echo "<div id='30113_div' style='display:none' align='center'></div>";
		echo "<div id='30114_div' style='display:none' align='center'></div>";
		echo "<div id='30115_div' style='display:none' align='center'></div>";
		
		echo "<div id='3021_div' style='display:none' align='center'></div>";
		echo "<div id='3022_div' style='display:none' align='center'></div>";
		echo "<div id='3023_div' style='display:none' align='center'></div>";
		echo "<div id='3024_div' style='display:none' align='center'></div>";
		echo "<div id='3025_div' style='display:none' align='center'></div>";
		echo "<div id='3026_div' style='display:none' align='center'></div>";
		echo "<div id='3027_div' style='display:none' align='center'></div>";
		echo "<div id='3028_div' style='display:none' align='center'></div>";
		echo "<div id='3029_div' style='display:none' align='center'></div>";
		echo "<div id='30210_div' style='display:none' align='center'></div>";
		echo "<div id='30211_div' style='display:none' align='center'></div>";
		echo "<div id='30212_div' style='display:none' align='center'></div>";
		echo "<div id='30213_div' style='display:none' align='center'></div>";
		echo "<div id='30214_div' style='display:none' align='center'></div>";
		echo "<div id='30215_div' style='display:none' align='center'></div>";
		
//PLC
echo "<br>";			
echo "<table border='1' style='border-collapse: collapse' width='$w2' align='center'>";
echo "<tr align='left'>";
echo "<td>&nbsp;&nbsp;<b>PLC</b> : ";
echo "</td><td align='center' valign='top' width='60'><input type='button' id='plc_button' value='รายละเอียด' onclick=ajax_show('$_REQUEST[school_code]','plc','val3','val4')></td>";
echo "</tr>";
echo "</table>";
/////
		echo "<div id='plc' style='display:none'>";
		echo "</div>";
/////
		
} //endi if display

?>
<script>

function goto_display(val){
	if(val==1){
		callfrm("?option=warroom&task=main/school_report_1"); 
		}
	else if(val==2){
		callfrm("?option=warroom&task=main/school_report_1&index=8"); 
		}
}

function ajax_show(val1,val2,val3,val4) { 
var livesearch="livesearch_"+val2+".php";
var display_button=val2+"_button";

function ajax_show_2(val1,val2,val3,val4,val5) { 
var livesearch="livesearch_"+val2+".php";
var display_button=val2+"_button"+val5;

if(val5== "1"){
	document.getElementById(val2+"_button2").style.backgroundColor = "";
	document.getElementById(val2+"_button3").style.backgroundColor = "";
	document.getElementById(val2+"_button4").style.backgroundColor = "";
			if(document.getElementById(display_button).style.backgroundColor != ""){
			document.getElementById(val2).style.display="none";
			}
   }
 else if(val5== "2"){
	document.getElementById(val2+"_button1").style.backgroundColor = "";
	document.getElementById(val2+"_button3").style.backgroundColor = "";
	document.getElementById(val2+"_button4").style.backgroundColor = "";
			if(document.getElementById(display_button).style.backgroundColor != ""){
			document.getElementById(val2).style.display="none";
			}
   }
  else if(val5== "3"){
	document.getElementById(val2+"_button1").style.backgroundColor = "";
	document.getElementById(val2+"_button2").style.backgroundColor = "";
	document.getElementById(val2+"_button4").style.backgroundColor = "";
			if(document.getElementById(display_button).style.backgroundColor != ""){
			document.getElementById(val2).style.display="none";
			}
   }
  else if(val5== "4"){
	document.getElementById(val2+"_button1").style.backgroundColor = "";
	document.getElementById(val2+"_button2").style.backgroundColor = "";
	document.getElementById(val2+"_button3").style.backgroundColor = "";
			if(document.getElementById(display_button).style.backgroundColor != ""){
			document.getElementById(val2).style.display="none";
			}
   }

if(document.getElementById(val2).style.display=="none"){
		  document.getElementById(display_button).style.backgroundColor = "";
		  }
		 else{
		  document.getElementById(display_button).style.backgroundColor = "#F78181";
		  }
document.getElementById("202").innerHTML="";				  
document.getElementById("204").innerHTML="";		  
}

function ajax_show_3(val1,val2,val3,val4,val5) { 
var livesearch="livesearch_"+val2+".php";
var display_button=val2+"_button"+val5;

if(document.getElementById(val2).style.display=="none"){
		  document.getElementById(display_button).style.backgroundColor = "";
		  }
		 else{
		  document.getElementById(display_button).style.backgroundColor = "#F78181";
		  }
document.getElementById("2021").innerHTML="";				  
document.getElementById("2041").innerHTML="";		  
}

function ajax_std_check1(val1,val2,val3,val4) { 
var livesearch="livesearch_"+val2+".php";
//var table_display=val2+"_show";
var display_button=val2+"_button";

if (window.XMLHttpRequest) {
    // code for IE7+, Firefox, Chrome, Opera, Safari
    xmlhttp=new XMLHttpRequest();
  } else {  // code for IE6, IE5
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
  xmlhttp.onreadystatechange=function() {
    if (this.readyState==4 && this.status==200) {
      document.getElementById(val2).innerHTML=this.responseText;
    }
  }
  xmlhttp.open("GET","modules/warroom/main/"+livesearch+"?q="+val1+"&val3="+val3+"&val4="+val4,true);
  xmlhttp.send();
  
		if(document.getElementById(val2).style.display=="block"){
		document.getElementById(display_button).value="รายละเอียด";
		document.getElementById(display_button).style.backgroundColor = "#A9D0F5";
		document.getElementById(val2).style.display="none";
				document.getElementById('3011_div').style.display="none";
				document.getElementById('3012_div').style.display="none";
				document.getElementById('3013_div').style.display="none";
				document.getElementById('3014_div').style.display="none";
				document.getElementById('3015_div').style.display="none";
				document.getElementById('3016_div').style.display="none";
				document.getElementById('3017_div').style.display="none";
				document.getElementById('3018_div').style.display="none";
				document.getElementById('3019_div').style.display="none";
				document.getElementById('30110_div').style.display="none";
				document.getElementById('30111_div').style.display="none";
				document.getElementById('30112_div').style.display="none";
				document.getElementById('30113_div').style.display="none";
				document.getElementById('30114_div').style.display="none";
				document.getElementById('30115_div').style.display="none";
		}
		else if(document.getElementById(val2).style.display=="none"){
		document.getElementById(display_button).value="ไม่แสดงรายละเอียด";
		document.getElementById(display_button).style.backgroundColor = "#F78181";
		document.getElementById(val2).style.display="block";
		}
}

function chart(val1,val2,val3,val4,val5,val6) {
var livesearch="livesearch_"+val2+".php";
var chart_display=val2; 
var data_x=val3;
var data_y=val4;
var label_text=val5;
var chart_type=val6;
var display_button=val2+"_button";
var div_display=val2+"_div";

function Over2Function(x) {
var e_id=x;  
document.getElementById(e_id).style.cursor="pointer";
document.getElementById(e_id).style.color = "orange";
}

function Out2Function(x) {
var e_id=x;
document.getElementById(e_id).style.color = "black";
}

function DelFunction(x) {
 alert(x);
 document.getElementById(x).innerHTML="";
}

function supervision(val1,val2){
var val3="supervision";
var livesearch="livesearch_"+val3+".php";

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

${this.title}

Code Editor : school_report_1.php