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

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

if($_SESSION['user_os'] =="mobile"){
 $width_1="97%";
 }
 else{
  $width_1="80%";
 }
 
require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

require_once "../time_inc.php";

$q=$_GET["q"];
if(isset($_GET["qq"])){
$display=1;  
}
else{
$display=0;
}
echo "<br>";

$sql_item = "select id from supervision_item where item_active='1'";
$dbquery_item = mysqli_query($connect,$sql_item);
if($result_item = mysqli_fetch_array($dbquery_item)){
$supervision_item=$result_item['id'];
}
else{
$sql_item = "select id from supervision_item order by id desc";
$dbquery_item = mysqli_query($connect,$sql_item);
$result_item = mysqli_fetch_array($dbquery_item);
$supervision_item=$result_item['id'];
}

echo "<table width='$width_1' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>รายงานการนิเทศ ติดตาม และประเมินผลการจัดการศึกษา</strong></font></td></tr>";
echo "</table>";

$sql = "select *,supervision_main.id,supervision_main.rec_date from supervision_main left join person_sch_main on supervision_main.person_id=person_sch_main.person_id  where supervision_main.school_id='$q' and item='$supervision_item' order by supervision_main.rec_date,supervision_main.id";

echo  "<table width='$width_1' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#ddd' align='center' height='40' class='subHeader'><Td width='50'>ที่</Td><Td width='120'>วันที่</Td><Td>ผู้รับการนิเทศ ติดตาม ประเมินผล</Td><Td>ตำแหน่ง</Td><Td>ผู้นิเทศ ติดตาม ประเมินผล</Td><td align='center'>ระดับการนิเทศฯ</td><td width='70' align='center'>รายละเอียด</td></Tr>";
$M=1;
$x=1;
$y=1;
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery))	{
$id=$result['id']; 
$rec_date=thai_date_3($result['rec_date']);
$assessor=$result['assessor'];
$ref_id=$result['ref_id'];
$level=$result['level'];
$status=$result['status'];
$position_code=$result['position_code'];

$sql_position = "select position_name from person_sch_position where position_code='$position_code' "; 
			$dbquery_position = mysqli_query($connect,$sql_position);
			$result_position = mysqli_fetch_array($dbquery_position);
			$position_name=$result_position['position_name'];
			
			$sql_2 = "select * from person_main where person_id='$assessor' "; 
			$dbquery_2 = mysqli_query($connect,$sql_2);
			if($result_2 = mysqli_fetch_array($dbquery_2)){
			$assessor=$result_2['prename'].$result_2['name']." ".$result_2['surname'];
			}
			else {
			$sql_2 = "select * from person_sch_main where person_id='$assessor' "; 
			$dbquery_2 = mysqli_query($connect,$sql_2);
			$result_2 = mysqli_fetch_array($dbquery_2);
			$assessor=$result_2['prename'].$result_2['name']." ".$result_2['surname'];
			}

if($level==1){
			$level_text="<font color='#DF0174'>นิเทศตนเอง</font>";
			}
			else if($level==2){
			$level_text="<font color='#0B610B'>โรงเรียน</font>";
			}
			else if($level==3){
			$level_text="<font color=''>สพท.</font>";
			}
			else{
			$level_text="";		
			}	
$e_id=$y."_".$x;	
echo "<tr><td align='center'>$M</td><td align='center'>$rec_date</td><td>$result[prename]$result[name] $result[surname]</td><td>$position_name</td><td>$assessor</td><td align='center'>$level_text</td>";
echo "<td align='center'><div id='$e_id' onclick='supervision($q,$id)' onmouseover='OverFunction($y,$x)'><img src=images/browse.png border='0'></div></td></tr>"; 
$M++;
$x++;
$y++;
}
echo "</table>";

if($display==1){
$sql = "select *,supervision_main.id,supervision_main.rec_date from supervision_main left join person_sch_main on supervision_main.person_id=person_sch_main.person_id 
left join system_school on  supervision_main.school_id=system_school.school_code where supervision_main.id='$_GET[qq]' ";
$dbquery = mysqli_query($connect,$sql);
$result_ref = mysqli_fetch_array($dbquery);
$prename=$result_ref['prename']; 
$name=$result_ref['name']; 
$surname=$result_ref['surname']; 
$school_name=$result_ref['school_name']; 
$rec_date=thai_date_3($result_ref['rec_date']);		
$ref_id=$result_ref['ref_id']; 
$standard_year=$result_ref['standard_year'];
$assessor=$result_ref['assessor'];
$position_code=$result_ref['position_code'];

echo "<br>";
		echo "<table width='$width_1' border='0' align='center'>";
		echo "<Tr><Td colspan='4' align='right'></Td></Tr>";

echo "<tr align='left'><td><font color='#271DA9'><strong>ผู้รับการนิเทศ ติดตาม ประเมินผล : </strong></font>$prename$name $surname ($position_name)</td>";
		echo "<td align='left'><font color='#271DA9'><strong>ผู้นิเทศ ติดตาม ประเมินผล : </strong></font>";
		
		$sql_person = "select * from person_main where person_id='$assessor' "; 
		$dbquery_person = mysqli_query($connect,$sql_person );
		if($result_person = mysqli_fetch_array($dbquery_person)){
		$assessor=$result_person['prename'].$result_person['name']." ".$result_person['surname'];
		}
		else {
		$sql_person = "select * from person_sch_main where person_id='$assessor' "; 
		$dbquery_person = mysqli_query($connect,$sql_person);
		$result_person = mysqli_fetch_array($dbquery_person);
		$assessor=$result_person['prename'].$result_person['name']." ".$result_person['surname'];
		}
		echo $assessor;
		echo "</td>";
		echo "<td align='left'>";
		echo $rec_date;
		echo "</td>";
		echo "</tr>";
		echo "</table>";
		
//ตรวจว่ามีการประเมินหรือไม่
	$sql = "select id from supervision_main_2 where ref_id='$ref_id' ";	
	$dbquery_check = mysqli_query($connect,$sql);
	$row_num=mysqli_num_rows($dbquery_check);

if($row_num==0){
echo "<div style='display:none'>";	
}
else{
echo "<div style='display:block'>";	
}

echo  "<table width='$width_1' border='1' align='center' style='border-collapse: collapse'>";
		echo "<Tr bgcolor='#FBD562' align='center' height='30' class='subHeader'><Td width='80' rowspan='2'>มาตรฐาน</Td><Td width='80' rowspan='2'>ประเด็น<br>ตัวชี้วัด</Td><Td rowspan='2'>รายการตัวชี้วัด</Td><td align='center' colspan='2'>การปฏิบัติ</td><Td align='center' colspan='5'>ระดับคุณภาพ / <font color='#271DA9'>ปริมาณ</font></Td></Tr>";
		echo "<Tr><td width='70' align='center' bgcolor='#B4E4BB'>ไม่ได้<br>ดำเนินการ</td><td width='70' align='center' bgcolor='#B4E4BB'>ดำเนินการ</td><Td width='50' align='center'>กำลังพัฒนา<br><font color='#271DA9'></font></td><Td width='40' align='center'>ปานกลาง<br><font color='#271DA9'></font></td><Td width='50' align='center' bgcolor='#F5ECCE'>ดี<br><font color='#271DA9'></font></td><Td width='50' align='center'>ดีเลิศ<br><font color='#271DA9'></font><Td width='50' align='center'>ยอดเยี่ยม<br><font color='#271DA9'></font></Td></Tr>";
$M=1;
$sql_1 = "select * from supervision_standard where year='$standard_year' order by standard_code";
$dbquery_1 = mysqli_query($connect,$sql_1);
While ($result_1 = mysqli_fetch_array($dbquery_1))	{

$id_standard = $result_1['id'];
		$standard_code= $result_1['standard_code'];
		$standard_name= $result_1['standard_name'];
		
		echo "<Tr bgcolor='#ddd' align='center'><Td align='left' colspan='11'>$M $standard_name</Td></tr>";
				$sql_2 = "select * from supervision_subject where standard_code=$standard_code order by subject_code ";
				$N=1; 
				$dbquery_2 = mysqli_query($connect,$sql_2);
				While ($result_2 = mysqli_fetch_array($dbquery_2)) {
						$id_subject = $result_2['id'];
						$subject_code= $result_2['subject_code']; 
						$subject_name= $result_2['subject_name'];
					echo "<Tr align='center'><td></td><Td align='left' bgcolor='#FFFFB' colspan='9'>$M.$N $subject_name</Td>";
					
								$sql_3 = "select * from supervision_indicator where subject_code=$subject_code order by indicator_code ";
								$dbquery_3 = mysqli_query($connect,$sql_3);
								$X=1;
								While ($result_3 = mysqli_fetch_array($dbquery_3)) {
										$id_indicator = $result_3['id'];
										$indicator_code= $result_3['indicator_code'];
										$indicator_name= $result_3['indicator_name'];
										$type= $result_3['type']; 
										$unit= $result_3['unit'];
										$min= $result_3['min'];
										$max= $result_3['max'];
										$g1= $result_3['g1'];
										$g2= $result_3['g2'];
										$g3= $result_3['g3'];
										$g4= $result_3['g4'];
										$g5= $result_3['g5'];
										$function_number= $result_3['function_number'];
										$indicator_explain= $result_3['indicator_explain'];
										
									echo "<Tr align='center'><td colspan='2'></td><Td align='left'>$M.$N.$X $indicator_name";
									echo "</Td>";
									
									$sql_4 = "select * from supervision_main_2 where indicator_code=$indicator_code and ref_id='$ref_id'";
									$dbquery_4 = mysqli_query($connect,$sql_4);
									$result_4 = mysqli_fetch_array($dbquery_4);
									
									$a1_check="";  $a2_check=""; 
									if(isset($result_4['act'])){	
											if($result_4['act']==1){
											$a1_check="checked";
											}
											else{
											$a2_check="checked";
											}
									}
									
									$c_value="";
									if(isset($result_4['quanlity'])){	
											if($result_4['quanlity']!=-1){
											$c_value=$result_4['quanlity'];
											}
									}
									
									$b1_check="";  $b2_check="";  $b3_check="";  $b4_check="";  $b5_check=""; 
									if(isset($result_4['quality'])){	
											if($result_4['quality']==1){
											$b1_check="<img src=images/yes.png border='0'>";
											}
											else if($result_4['quality']==2){
											$b2_check="<img src=images/yes.png border='0'>";
											}
											else if($result_4['quality']==3){
											$b3_check="<img src=images/yes.png border='0'>"	;	
											}
											else if($result_4['quality']==4){
											$b4_check="<img src=images/yes.png border='0'>";
											}
											else if($result_4['quality']==5){
											$b5_check="<img src=images/yes.png border='0'>";
											}
									}

echo "<td bgcolor='#D8F1DC' align='center'><input type='radio' name='a_$indicator_code' id='a1_$indicator_code' value='1' $a1_check disabled></td><td bgcolor='#D8F1DC' align='center'><input type='radio' name='a_$indicator_code' id='a2_$indicator_code' value='2' $a2_check disabled></td>";
									if($type==2){
									echo "<td align='center' colspan=3><input type='text' name='c_$indicator_code' id='c_$indicator_code' size='10' value='$c_value' readonly></Td>";
									echo "<td align='left' colspan='2'>&nbsp;&nbsp;$unit</Td>";
									}
									else{
									echo "<td align='center'>$b1_check</Td>";
									echo "<td align='center'>$b2_check</Td>";
									echo "<td align='center' bgcolor='#F5ECCE'>$b3_check</Td>";
									echo "<td align='center'>$b4_check</Td>";
									echo "<td align='center'>$b5_check</Td>";
									}
									echo "</Tr>";
									$X++;
									}
						
					$N++;
					}
	$M++;
	}
	echo "</Table>";
echo "</div>";		
	
echo "<br>";
				$sql_2 = "select * from supervision_comment left join supervision_subject on supervision_comment.subject_code=supervision_subject.subject_code where supervision_comment.ref_id='$ref_id' order by supervision_comment.subject_code";
				$dbquery_2 = mysqli_query($connect,$sql_2);
				while($result_ref_2=mysqli_fetch_array($dbquery_2)){
				$subject=$result_ref_2['subject_name'];
				if($subject==""){
				$subject="ทั่วไป";
				}
				echo "<table width='60%' border='1' align='center' style='border-collapse: collapse'>";
				echo "<Tr bgcolor='#FBD562'><Td> $subject</Td></Tr>";
				echo "</tr>";
				echo "<Tr><Td>";
				echo $result_ref_2['comment'];
				echo "</Td></Tr>";
				echo "</tr>";
				echo "</table>";
				echo "<br>";
				}

$sql_2 = "select * from supervision_file where ref_id='$ref_id' ";
				$dbquery_2 = mysqli_query($connect,$sql_2);
				$F=1;
				while($result_ref_2=mysqli_fetch_array($dbquery_2)){
				echo "<table width='40%' border='1' align='center' style='border-collapse: collapse'>";
				echo "<Tr bgcolor='#D8F1DC'><Td>เอกสาร $F</Td></Tr>";
				echo "</tr>";
				echo "<Tr><Td>";
				echo  "<a href='modules/supervision/upload_files/$result_ref_2[file_name]' target='_blank'>ดาวน์โหลดเอกสาร $F</a>";
				echo "</Td></Tr>";
				echo "</tr>";
				echo "</table>";
				$F++;
				}
}
?>

${this.title}

Code Editor : livesearch_supervision.php