Gecko [ 122.154.134.11 ]

Name	Size	Permission
images	[ DIR ]	drwxr-xr-x
detail.php	2.98 KB	-rw-r--r--
index.php	969 B	-rw-r--r--
livesearch_201.php	17.56 KB	-rw-r--r--
report_1.php	29.01 KB	-rw-r--r--
report_2.php	27.99 KB	-rw-r--r--
sp1.php	59.17 KB	-rw-r--r--
sp2.php	6.04 KB	-rw-r--r--
sp3.php	5.98 KB	-rw-r--r--
std_detail3.php	7.95 KB	-rw-r--r--
std_detail4.php	8.99 KB	-rw-r--r--
teach_list.php	18.65 KB	-rw-r--r--
teach_report.php	9.8 KB	-rw-r--r--

Code Editor : sp1.php

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

?>
<style>
.button {
    background-color: #4CAF50; /* Green */
    border: none;
    color: white;
    padding: 5px 12px;
    text-align: center;
    text-decoration: none;
    display: inline-block;
    font-size: 13px;
    margin: 2px 1px;
    cursor: pointer;
}

.button2 {background-color: #008CBA;} /* Blue */
.button3 {background-color: #f44336;} /* Red */ 
.button4 {background-color: #e7e7e7; color: black;} /* Gray */ 
.button5 {background-color: #555555;} /* Black */
</style>

<?php
if(!(isset($_REQUEST['school_index']))){
$_REQUEST['school_index']="";
}

if(isset($_GET['school_code'])){
$_REQUEST['school_index']=$_GET['school_code'];
}

if(!(isset($_POST['rec_time']))){
$_POST['rec_time']=date("Y-m-d");  
}

$_REQUEST['school_index']=$remote_user_office;

if($remote_login_status==4){
$_REQUEST['person_index']=$remote_user_id;
}

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

if(isset($_REQUEST['person_index'])){
		if(!(isset($_SESSION['sp_ref_id'][$_REQUEST['person_index']]))){
		$timestamp = mktime(date("H"), date("i"),date("s"), date("m") ,date("d"), date("Y"))  ;	
		$rand_number=rand();
		$_SESSION['sp_ref_id'][$_REQUEST['person_index']]= $timestamp."x".$rand_number;
		}
}

$time_for_teacher=1;  // เวลาสำหรับครูนิทศ
$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'];
$time_for_teacher=0;
}

//ส่วนหัว
echo "<br />";
if(!(($index==2) or ($index==5))){
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>นิเทศ ติดตาม และประเมินผลการจัดการศึกษา</strong></font></td></tr>";
echo "</table>";
}

if($index==1){ 
echo "<form id='frm1' name='frm1'>";		
		echo "<input type='hidden' name='remote_user_office' value='$remote_user_office'>";
		echo "<input type='hidden' name='remote_user_id' value='$remote_user_id'>";
		echo "<input type='hidden' name='remote_login_status' value='$remote_login_status'>";
		echo "<input type='hidden' name='remote_sync' value='$remote_sync'>";
		
		echo  "<table width=90% border='0' align='center'>";
		echo "<Tr><td align='right'>";
		
	//เลือก	โรงเรียน
		echo "<Select  name='school_index' size='1' style='color: #009900' onchange='goto_index(1)'>";
		$sql = "select * from  system_school  order by  school_type,school_code";
		$dbquery = mysqli_query($connect,$sql);
		While ($result = mysqli_fetch_array($dbquery))
		   {
					if($remote_user_office==$result['school_code']){
								echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
					}
			}
		echo "</select>";
		
		echo "</td></Tr>";
		echo "<Tr><td align='right'>";
		
		//เลือกบุคลากร
		echo "<Select  name='person_index' size='1' style='color: #009900' onchange='goto_index(2)'>";
		echo  "<option  value = ''>เลือกครูและบุคลากร</option>" ;
		$sql = "select * from  person_sch_main where school_code='$remote_user_office' and status='0' and (position_code='1' or position_code='2' or position_code='3' or position_code='4' or position_code='11' or position_code='12' or position_code='31' or position_code='35')  order by position_code,name";

$dbquery = mysqli_query($connect,$sql);
		$prename=""; $name="";  $surname="";
		While ($result = mysqli_fetch_array($dbquery))
		   {
		   			if($remote_login_status>=4){
							if($result['person_id']==$remote_user_id){
							echo  "<option value = $result[person_id] selected>$result[name] $result[surname]</option>";
							$prename=$result['prename']; 
							$name=$result['name']; 
							$surname=$result['surname'];
							}
					}
					else{
							if($result['person_id']==$_REQUEST['person_index']){
							echo  "<option value = $result[person_id] selected>$result[name] $result[surname]</option>";
							$prename=$result['prename']; 
							$name=$result['name']; 
							$surname=$result['surname'];
							}
							else{
							echo  "<option value = $result[person_id]>$result[name] $result[surname]</option>";
						   }
					}	   
			}
		echo "</select>";
		echo "</td></Tr>";
		echo "</Table>";
		//จบ
		
		if($name!=""){	
		$ref_id=$_SESSION['sp_ref_id'][$_REQUEST['person_index']];
		
		//หาตำแหน่ง
		$sql_position= "select position_code from person_sch_main where person_id='$_REQUEST[person_index]' ";
		$dbquery_position=mysqli_query($connect,$sql_position);
		$result_position = mysqli_fetch_array($dbquery_position);
		$position=$result_position['position_code'];
		
		//หาว่ามีการประเมินระดับ 1 แล้วหรือยัง
		$sql_search_1= "select id from supervision_main where level='1' and person_id='$_REQUEST[person_index]' and item='$result_item[id]' ";
		$dbquery_search_1=mysqli_query($connect,$sql_search_1);
		$level_1_num=mysqli_num_rows($dbquery_search_1);

//หาว่ามีการประเมินระดับ 2 แล้วหรือยัง
		$sql_search_2= "select id from supervision_main where level='2' and person_id='$_REQUEST[person_index]' and item='$result_item[id]' ";
		$dbquery_search_2=mysqli_query($connect,$sql_search_2);
		$level_2_num=mysqli_num_rows($dbquery_search_2);
		
		if($remote_login_status>=4){
		$level=1;
		}
		else if($remote_login_status==2 or $remote_login_status==3){
					if($officer==$_REQUEST['person_index']){
					$level=1;
					}
					else{
					$level=2;
					}
		}
		
		if($level==1 and $level_1_num>=1){
		echo "<div align='center'><font size='3'>มีการประเมินตนเองแล้ว ในรอบนี้</font></div>";
		echo "<div align='center'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='location.href=\"?file=sp1&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"' class='button button2'></div>";
		exit();
		}
		else if($level==2 and $level_2_num>=1){
		echo "<div align='center'><font size='3'>มีการนิเทศ ติดตาม และประเมินผล ระดับสถานศึกษาแล้ว ในรอบนี้</font></div>";
		echo "<div align='center'><INPUT TYPE='button' name='smb' value='ตกลง' onclick='location.href=\"?file=sp1&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"' class='button button2'></div>";
		exit();
		}
		
		echo "<table width='90%' border='0' align='center'>";
		echo "<tr align='left'><td width='30%'><font color='#271DA9'><strong>ผู้รับการนิเทศ ติดตาม ประเมินผล : </strong></font>$prename$name $surname</td>";
		echo "<td align='left'>";
		
		list($year,$month,$day) = explode("-",$_POST['rec_time']);	
		?>
		<script>
		var Y_date=<?php echo $year?>  
		var m_date=<?php echo $month?>  
		var d_date=<?php echo $day?>  
		Y_date= Y_date+'/'+m_date+'/'+d_date
		DateInput('rec_time', true, 'YYYY-MM-DD', Y_date)</script>
		<?php
		echo "</td>";
		echo "</tr>";
		echo "</table>";
		
		echo  "<table width='90%' 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><td align='center' rowspan='2' width='50'>บันทึก<br><a href='sp2.php?ref_id=$ref_id&school_index=$_REQUEST[school_index]&person_index=$_REQUEST[person_index]&officer=$officer&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync' class='dialogify'><img src=../../../images/edit.png border='0'></a></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 *,supervision_standard.id from supervision_standard inner join supervision_year on supervision_standard.year=supervision_year.year where supervision_year.year_active='1' order by supervision_standard.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'];
		$standard_type = $result_1['type'];
		$year = $result_1['year'];
		
		if(($position>2) and ($standard_type==1)){
		continue;
		}
		
		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 ";
				$dbquery_2 = mysqli_query($connect,$sql_2);
				$N=1; 
				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>";
					echo "<td align='center' bgcolor='#FFFFB'><a href='sp2.php?ref_id=$ref_id&school_index=$_REQUEST[school_index]&subject_code=$subject_code&person_index=$_REQUEST[person_index]&officer=$officer&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync' class='dialogify'><img src=../../../images/edit.png border='0'></a></td></tr>";
					
								$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";
									
if($indicator_explain!="" or $type==2){
?>
<a href="detail.php?id=<?php echo $id_indicator;?>" class="dialogify" title="คำอธิบาย"><?php echo "<font size='1'>คำอธิบาย</font>" ?></a>
<?php
}									
									echo "</Td>";
									
									echo "<td bgcolor='#B4E4BB' align='center'><input type='radio' name='a_$indicator_code' id='a1_$indicator_code' value='1' onchange='check_2($indicator_code,$type)'></td><td bgcolor='#B4E4BB' align='center'><input type='radio' name='a_$indicator_code' id='a2_$indicator_code' value='2' onchange='check_2($indicator_code,$type)'></td>";
									if($type==2){
									echo "<td align='center' colspan=3><input type='text' name='c_$indicator_code' id='c_$indicator_code' size='10' onchange='check($indicator_code,$min,$max)'></Td>";
									echo "<td align='left' colspan='2'>&nbsp;&nbsp;$unit</Td>";
									}
									else{
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b1_$indicator_code' value='1'></Td>";
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b2_$indicator_code' value='2'></Td>";
									echo "<td align='center' bgcolor='#F5ECCE'><input type='radio' name='b_$indicator_code' id='b3_$indicator_code' value='3'></Td>";
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b4_$indicator_code' value='4'></Td>";
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b5_$indicator_code' value='5'></Td>";
									}
									echo "<td align='center'></td>";
									echo "</Tr>";
									$X++;
									}
						
					$N++;
					}
	$M++;
	}
		echo "</Table>";
		echo "<Br>";
		echo "<div align='center'>";
		echo "<INPUT TYPE='Hidden' name='standard_year' value='$year'>";
		echo "<INPUT TYPE='Hidden' name='person_id' value='$_REQUEST[person_index]'>";
		echo "<INPUT TYPE='Hidden' name='ref_id' value='$ref_id'>";
		echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'>
				&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ล้างข้อมูล' onclick='ClearCheck()'>";
		echo "</div>";		
		} //end if($name!="")
echo "</form>";
}

if($index==2){
echo "<table width='500' border='0' align='center'>";
echo "<tr><td align='center'><font color='#990000' size='4'>โปรดยืนยันความต้องการลบข้อมูลอีกครั้ง</font><br></td></tr>";
echo "<tr><td align=center>";
echo "<INPUT TYPE='button' name='smb' value='ยืนยัน' onclick='location.href=\"?file=sp1&index=3&id=$_GET[id]&ref_id=$_GET[ref_id]&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?file=sp1&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"'";
echo "</td></tr></table>";
}

if($index==3){

$sql = "delete from supervision_file where ref_id='$_GET[ref_id]'";
$dbquery = mysqli_query($connect,$sql);

$sql = "delete from supervision_comment where ref_id='$_GET[ref_id]'";
$dbquery = mysqli_query($connect,$sql);

$sql = "delete from supervision_main_2 where ref_id='$_GET[ref_id]'";
$dbquery = mysqli_query($connect,$sql);

$sql = "delete from supervision_main where id='$_GET[id]'";
$dbquery = mysqli_query($connect,$sql);

}

//ส่วนบันทึกข้อมูล
if($index==4){
if($remote_login_status>=4){
$level=1;
}
else if($remote_login_status==2 or $remote_login_status==3){
			if($officer==$_REQUEST['person_index']){
			$level=1;
			}
			else{
			$level=2;
			}
}

$sql = "insert into supervision_main(level,standard_year,person_id,school_id,ref_id,item,assessor,rec_date) values ('$level','$_POST[standard_year]', '$_POST[person_id]','$_POST[school_index]','$_POST[ref_id]','$supervision_item','$officer','$_POST[rec_time]')";
$dbquery = mysqli_query($connect,$sql);
        //บันทึกผลการประเมิน
		$sql_1 = "select standard_code from supervision_standard inner join supervision_year on supervision_standard.year=supervision_year.year where supervision_year.year_active='1' order by supervision_standard.standard_code";
		$dbquery_1 = mysqli_query($connect,$sql_1);
		While ($result_1 = mysqli_fetch_array($dbquery_1))	{
		$standard_code= $result_1['standard_code'];
				
					$sql_2 = "select subject_code from supervision_subject where standard_code=$standard_code order by subject_code ";
					$dbquery_2 = mysqli_query($connect,$sql_2);
					While ($result_2 = mysqli_fetch_array($dbquery_2)) {
					$subject_code= $result_2['subject_code'];
					
								$sql_3 = "select * from supervision_indicator where subject_code=$subject_code order by indicator_code ";
								$dbquery_3 = mysqli_query($connect,$sql_3);
								While ($result_3 = mysqli_fetch_array($dbquery_3)) {
								$id_indicator = $result_3['id'];
								$indicator_code= $result_3['indicator_code'];
								$type= $result_3['type'];
								$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'];
								$a="a_".$indicator_code;
								$b="b_".$indicator_code;
								$c="c_".$indicator_code;
								
								if(!(isset($_POST[$a]))){
								$act=0;
								}
								else{
								$act=$_POST[$a];
								}
								
										if($type==1){
												if(isset($_POST[$a]) or isset($_POST[$b])){
																if(!(isset($_POST[$b]))){
																$_POST[$b]=0;
																}
																else{
																$act=2;
																}
																
														$sql_del ="select id from supervision_main_2 where ref_id='$_POST[ref_id]' and person_id='$_POST[person_id]' and indicator_code='$indicator_code' ";
														$dbquery_del = mysqli_query($connect,$sql_del);
														$num=mysqli_num_rows($dbquery_del);
														if($num>=1){
														$sql_del_2 ="delete from supervision_main_2 where ref_id='$_POST[ref_id]' and person_id='$_POST[person_id]' and indicator_code='$indicator_code' ";
														$dbquery_del_2 = mysqli_query($connect,$sql_del_2);
														}
															
												$sql = "insert into supervision_main_2(ref_id,person_id,indicator_code,act,quality,rec_date) values ('$_POST[ref_id]','$_POST[person_id]','$indicator_code','$act','$_POST[$b]','$_POST[rec_time]')";
												$dbquery = mysqli_query($connect,$sql);
												}
										}
										else if($type==2){
												if(isset($_POST[$a]) or ($_POST[$c]!="")){
																if($_POST[$c]==""){
																$_POST[$c]=-1;
																}
																else{
																$act=2;
																}
														$sql_del ="select id from supervision_main_2 where ref_id='$_POST[ref_id]' and person_id='$_POST[person_id]' and indicator_code='$indicator_code' ";
														$dbquery_del = mysqli_query($connect,$sql_del);
														$num=mysqli_num_rows($dbquery_del);
														if($num>=1){
														$sql_del_2 ="delete from supervision_main_2 where ref_id='$_POST[ref_id]' and person_id='$_POST[person_id]' and indicator_code='$indicator_code' ";
														$dbquery_del_2 = mysqli_query($connect,$sql_del_2);
														}
												//คำนวณ
												if($function_number==1){
												$q=cal_1($g1,$g2,$g3,$g4,$g5,$_POST[$c]);
												}
												else if($function_number==2){
												$q=cal_2($g1,$g2,$g3,$g4,$g5,$_POST[$c]);
												}
												$q=number_format($q,2);
												$sql = "insert into supervision_main_2(ref_id,person_id,indicator_code,act,quanlity,quality,rec_date) values ('$_POST[ref_id]','$_POST[person_id]','$indicator_code','$act','$_POST[$c]','$q','$_POST[rec_time]')";
												$dbquery = mysqli_query($connect,$sql);
												}
										}
								}
					}			
		}	
}

if($index==5){
echo "<table width='100%' 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,person_sch_main.position_code,supervision_main.status 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[id]' ";
$dbquery = mysqli_query($connect,$sql);
$result_ref = mysqli_fetch_array($dbquery);
$main_id=$result_ref['id']; 
$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']; 
$school_index=$result_ref['school_id']; 
$person_index=$result_ref['person_id']; 
$position=$result_ref['position_code'];
$standard_year=$result_ref['standard_year'];
$status=$result_ref['status'];
$position_code=$result_ref['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'];

echo "<form id='frm1' name='frm1'>";		
		echo "<input type='hidden' name='remote_user_office' value='$remote_user_office'>";
		echo "<input type='hidden' name='remote_user_id' value='$remote_user_id'>";
		echo "<input type='hidden' name='remote_login_status' value='$remote_login_status'>";
		echo "<input type='hidden' name='remote_sync' value='$remote_sync'>";
		
		echo "<table width='90%' border='0' align='center'>";
		echo "<Tr ><Td colspan='4' align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?file=sp1&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"'></Td></Tr>";

echo "<tr align='left'><td><font color='#271DA9'><strong>ผู้รับการนิเทศ ติดตาม ประเมินผล : </strong></font>$prename$name $surname ($position_name)</td><td><font color='#271DA9'><strong>โรงเรียน: </strong></font>$school_name</td>";
		echo "<td align='left'>";
		echo $rec_date;
		echo "</td>";
		echo "</tr>";
		echo "</table>";
		
if($status==1){
echo "<div style='display:none'>";	
}
else{
echo "<div style='display:block'>";	
}
	
		echo  "<table width='90%' border='1' align='center' style='border-collapse: collapse'>";
		echo "<Tr bgcolor='#FBD562' align='center' height='30' class='subHeader'><Td width='120' rowspan='2'>มาตรฐาน</Td><Td width='120' rowspan='2'>ประเด็นตัวชี้วัด</Td><Td rowspan='2'>รายการตัวชี้วัด</Td><td align='center' colspan='2'>การปฏิบัติ</td><Td align='center' colspan='5'>ระดับคุณภาพ / <font color='#271DA9'>ปริมาณ</font></Td><td align='center' rowspan='2' width='50'>บันทึก<br><a href='sp3.php?ref_id=$ref_id&school_index=$school_index&person_index=$person_index&officer=$officer&return=2&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync' class='dialogify'><img src=../../../images/edit.png border='0'></a></td></Tr>";
		echo "<Tr><td width='80' align='center' bgcolor='#B4E4BB'>ไม่ได้<br>ดำเนินการ</td><td width='80' 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'];
		$standard_type = $result_1['type'];

if(($position>2) and ($standard_type==1)){
		continue;
		}
		
		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>";
					echo "<td align='center' bgcolor='#FFFFB'><a href='sp3.php?ref_id=$ref_id&school_index=$school_index&subject_code=$subject_code&person_index=$person_index&officer=$officer&return=2&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync' class='dialogify'><img src=../../../images/edit.png border='0'></a></td></tr>";
					
								$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";
									
if($indicator_explain!="" or $type==2){
?>
<a href="detail.php?id=<?php echo $id_indicator;?>" class="dialogify" title="คำอธิบาย"><?php echo "<font size='1'>คำอธิบาย</font>" ?></a>
<?php
}									
									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="checked";
											}
											else if($result_4['quality']==2){
											$b2_check="checked";
											}
											else if($result_4['quality']==3){
											$b3_check="checked";
											}
											else if($result_4['quality']==4){
											$b4_check="checked";
											}
											else if($result_4['quality']==5){
											$b5_check="checked";
											}
									}

echo "<td bgcolor='#D8F1DC' align='center'><input type='radio' name='a_$indicator_code' id='a1_$indicator_code' value='1' $a1_check onchange='check_2($indicator_code,$type)'></td><td bgcolor='#D8F1DC' align='center'><input type='radio' name='a_$indicator_code' id='a2_$indicator_code' value='2' $a2_check onchange='check_2($indicator_code,$type)'></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' onchange='check($indicator_code,$min,$max)'></Td>";
									echo "<td align='left' colspan='2'>&nbsp;&nbsp;$unit</Td>";
									}
									else{
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b1_$indicator_code' value='1' $b1_check ></Td>";
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b2_$indicator_code' value='2' $b2_check ></Td>";
									echo "<td align='center' bgcolor='#F5ECCE'><input type='radio' name='b_$indicator_code' id='b3_$indicator_code' value='3' $b3_check ></Td>";
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b4_$indicator_code' value='4' $b4_check ></Td>";
									echo "<td align='center'><input type='radio' name='b_$indicator_code' id='b5_$indicator_code' value='5' $b5_check ></Td>";
									}
									echo "<td align='center'></td>";
									echo "</Tr>";
									$X++;
									}
						
					$N++;
					}
	$M++;
	}
	echo "</Table>";
echo "</div>";	
	
echo "<br>";
				$sql_2 = "select *,supervision_comment.id 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_id=$result_ref_2['id'];
				$subject=$result_ref_2['subject_name'];
				if($subject==""){
				$subject="ทั่วไป";
				}
				echo "<table width='30%' border='1' align='center' style='border-collapse: collapse'>";
				echo "<Tr bgcolor='#FBD562'><Td align='left'> $subject</Td></Tr>";
				echo "</tr>";
				echo "<Tr><Td>";
				echo "<textarea rows='10' cols='45' name='comment_$subject_id'>$result_ref_2[comment]</textarea>";
				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)){
				$file_id=$result_ref_2['id'];
				echo "<table width='30%' border='1' align='center' style='border-collapse: collapse'>";
				echo "<Tr bgcolor='#FBD562'><Td align='left'>เอกสาร $F</Td><Td align='center' width='90'><input type='checkbox' name='files_$file_id' value='1'>ลบเอกสาร</Td></Tr>";
				echo "</tr>";
				echo "<Tr><Td colspan='2'>";
				echo  "<a href='../upload_files/$result_ref_2[file_name]' target='_blank'>ดาวน์โหลดเอกสาร $F</a>";
				echo "</Td></Tr>";
				echo "</tr>";
				echo "</table>";
				$F++;
				}
			echo "<Br>";
			echo "<div align='center'>";
			echo "<INPUT TYPE='Hidden' name='id' value='$main_id'>";
			echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_update(1)'>";			;
			echo "</div>";		
			echo "</form>";
}

if($index==6){
$sql = "select *,supervision_main.id,supervision_main.person_id,supervision_main.school_id,supervision_main.ref_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='$_POST[id]' ";
$dbquery = mysqli_query($connect,$sql);
$result_ref = mysqli_fetch_array($dbquery);
$level=$result_ref['level']; 
$_POST['person_id']=$result_ref['person_id']; 
$_POST['school_index']=$result_ref['school_id']; 
$_POST['ref_id']=$result_ref['ref_id']; 
$_POST['rec_time']=$result_ref['rec_date'];

//บันทึกผลการประเมิน
		$sql_1 = "select standard_code from supervision_standard inner join supervision_year on supervision_standard.year=supervision_year.year where supervision_year.year_active='1' order by supervision_standard.standard_code";
		$dbquery_1 = mysqli_query($connect,$sql_1);
		While ($result_1 = mysqli_fetch_array($dbquery_1))	{
		$standard_code= $result_1['standard_code'];
				
					$sql_2 = "select subject_code from supervision_subject where standard_code=$standard_code order by subject_code ";
					$dbquery_2 = mysqli_query($connect,$sql_2);
					While ($result_2 = mysqli_fetch_array($dbquery_2)) {
					$subject_code= $result_2['subject_code'];
					
								$sql_3 = "select * from supervision_indicator where subject_code=$subject_code order by indicator_code ";
								$dbquery_3 = mysqli_query($connect,$sql_3);
								While ($result_3 = mysqli_fetch_array($dbquery_3)) {
								$id_indicator = $result_3['id'];
								$indicator_code= $result_3['indicator_code'];
								$type= $result_3['type'];
								$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'];
								$a="a_".$indicator_code;
								$b="b_".$indicator_code;
								$c="c_".$indicator_code;
								
								//เช็คว่าไม่รายการบันทึกหรือไม่
								$sql_4 = "select * from supervision_main_2 where indicator_code='$indicator_code' and ref_id='$result_ref[ref_id]' "; 
								$dbquery_4 = mysqli_query($connect,$sql_4);
								$result_4 = mysqli_fetch_array($dbquery_4);
								//
								
								if(!(isset($_POST[$a]))){
								$act=0;
								}
								else{
								$act=$_POST[$a];
								}
								
										if($type==1){
												if(isset($_POST[$a]) or isset($_POST[$b])){
																if(!(isset($_POST[$b]))){
																$_POST[$b]=0;
																}
																else{
																$act=2;
																}
														if($result_4){	
														$sql = "update supervision_main_2 set act='$act', quality='$_POST[$b]' where indicator_code='$indicator_code' and ref_id='$_POST[ref_id]' ";
														$dbquery = mysqli_query($connect,$sql);
														}
														else{
														$sql = "insert into supervision_main_2(ref_id,person_id,indicator_code,act,quality,rec_date) values ('$result_ref[ref_id]','$result_ref[person_id]','$indicator_code','$act','$_POST[$b]','$result_ref[rec_date]')";
														$dbquery = mysqli_query($connect,$sql);
														}
												}//if(isset($_POST[$a])
										}
										else if($type==2){
												if(isset($_POST[$a]) or ($_POST[$c]!="")){
																if($_POST[$c]==""){
																$_POST[$c]=-1;
																}
																else{
																$act=2;
																}
												//คำนวณ
												if($function_number==1){
												$q=cal_1($g1,$g2,$g3,$g4,$g5,$_POST[$c]);
												}
												else if($function_number==2){
												$q=cal_2($g1,$g2,$g3,$g4,$g5,$_POST[$c]);
												}
												$q=number_format($q,2);
												
														if($result_4){	
														$sql = "update supervision_main_2 set act='$act', quanlity='$_POST[$c]', quality='$q' where indicator_code='$indicator_code' and ref_id='$_POST[ref_id]' ";
														$dbquery = mysqli_query($connect,$sql);
														}
														else{
														$sql = "insert into supervision_main_2(ref_id,person_id,indicator_code,act,quanlity,quality,rec_date) values ('$result_ref[ref_id]','$result_ref[person_id]','$indicator_code','$act','$_POST[$c]','$q','$result_ref[rec_date]')";
														$dbquery = mysqli_query($connect,$sql);
														}
												}//end if(isset($_POST[$a])
												
										}
								}// end while
					}			
		}	
				//แก้ไข comment  และเอกสาร
				foreach ($_POST as $key => $value) {
				$comment=explode("_", $key);
						if(isset($comment[0])){
								if($comment[0]=="comment"){
								$comment_id=$comment[1] ;
								$sql = "update supervision_comment set comment='$value' where id='$comment_id' ";
								$dbquery = mysqli_query($connect,$sql);
								}
						}
				// เอกสาร
				$files=explode("_", $key);
						if(isset($files[0])){
								if($files[0]=="files"){
								$files_id=$files[1] ;
								$sql = "delete from supervision_file where id='$files_id'";
								$dbquery = mysqli_query($connect,$sql);
								}
						}
				}
}

if($index==7){

$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[id]' ";
$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 "<table width='90%' border='0' align='center'>";
		echo "<Tr ><Td colspan='4' align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?file=sp1&page=$_GET[page]&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"'></Td></Tr>";

if($row_num==0){
echo "<div style='display:none'>";	
}
else{
echo "<div style='display:block'>";	
}
	
		echo  "<table width='90%' border='1' align='center' style='border-collapse: collapse'>";
		echo "<Tr bgcolor='#FBD562' align='center' height='30' class='subHeader'><Td width='120' rowspan='2'>มาตรฐาน</Td><Td width='120' rowspan='2'>ประเด็นตัวชี้วัด</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='80' align='center' bgcolor='#B4E4BB'>ไม่ได้<br>ดำเนินการ</td><td width='80' 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";
									
if($indicator_explain!="" or $type==2){
?>
<a href="detail.php?id=<?php echo $id_indicator;?>" class="dialogify" title="คำอธิบาย"><?php echo "<font size='1'>คำอธิบาย</font>" ?></a>
<?php
}									
									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='#81F781'><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='#FBD562'><Td>เอกสาร $F</Td></Tr>";
				echo "</tr>";
				echo "<Tr><Td>";
				echo  "<a href='../upload_files/$result_ref_2[file_name]' target='_blank'>ดาวน์โหลดเอกสาร $F</a>";
				echo "</Td></Tr>";
				echo "</tr>";
				echo "</table>";
				$F++;
				}
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==2) or ($index==5) or ($index==7))){
	if(!($position_code==1 or $position_code==2 or $position_code==3 or $position_code==4 or $position_code==11 or $position_code==12 or $position_code==31 or $position_code==35)){
	echo "<br><div align='center'><font color='#D35400' size='2'><strong>เฉพาะครูเท่านั้น</strong></font><div>";
	exit();
	}
//ส่วนของการแยกหน้า
$sql = "select  id from supervision_main where supervision_main.assessor='$officer'";
$dbquery = mysqli_query($connect,$sql);
$num_rows = mysqli_num_rows($dbquery );

$pagelen=20;  // 1_กำหนดแถวต่อหน้า
$url_link="file=sp1";  // 2_กำหนดลิงค์ฺ
$totalpages=ceil($num_rows/$pagelen);

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

if($_REQUEST['page']==""){
$page=$totalpages;
		if($page<2){
		$page=1;
		}
}
else{
		if($totalpages<$_REQUEST['page']){
		$page=$totalpages;
					if($page<1){
					$page=1;
					}
		}
		else{
		$page=$_REQUEST['page'];
		}
}

$start=($page-1)*$pagelen;

if(($totalpages>1) and ($totalpages<16)){
echo "<div align=center>";
echo "หน้า	";
			for($i=1; $i<=$totalpages; $i++)	{
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
echo "</div>";
}			
if($totalpages>15){
			if($page <=8){
			$e_page=15;
			$s_page=1;
			}
			if($page>8){
					if($totalpages-$page>=7){
					$e_page=$page+7;
					$s_page=$page-7;
					}
					else{
					$e_page=$totalpages;
					$s_page=$totalpages-15;
					}
			}
			echo "<div align=center>";
			if($page!=1){
			$f_page1=$page-1;
			echo "<<a href=$PHP_SELF?$url_link&page=1>หน้าแรก </a>";
			echo "<<<a href=$PHP_SELF?$url_link&page=$f_page1>หน้าก่อน </a>";
			}
			else {
			echo "หน้า	";
			}					
			for($i=$s_page; $i<=$e_page; $i++){
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
			if($page<$totalpages)	{
			$f_page2=$page+1;
			echo "<a href=$PHP_SELF?$url_link&page=$f_page2> หน้าถัดไป</a>>>";
			echo "<a href=$PHP_SELF?$url_link&page=$totalpages> หน้าสุดท้าย</a>>";
			}
			echo " <select onchange=\"location.href=this.options[this.selectedIndex].value;\" size=\"1\" name=\"select\">";
			echo "<option  value=\"\">หน้า</option>";
				for($p=1;$p<=$totalpages;$p++){
				echo "<option  value=\"?$url_link&page=$p\">$p</option>";
				}
			echo "</select>";
echo "</div>";  
}					
//จบแยกหน้า

if($remote_login_status>1){
		if($time_for_teacher==1){
echo  "<table width='90%' border='0' align='center'>";
echo "<Tr><Td align='left'><INPUT TYPE='button' name='smb' value='บันทึกการนิเทศ ติดตาม และประเมินผล' onclick='location.href=\"?file=sp1&index=1&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync\"' class='button button2'></Td><td align='right'></td>";
echo "</Tr></Table>";
		}
		else{
		echo  "<table width='90%' border='0' align='center'>";
		echo "<Tr><Td align='left'><font color='#ff0000'>*ขณะนี้อยู่ระหว่างปิดรอบการบันทึกการนิเทศ ติดตาม และประเมินผล</font></td>";
		echo "</Tr></Table>";
		}
}

$sql = "select *,supervision_main.id,supervision_main.rec_date,supervision_main.status,supervision_main.item 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 
left join supervision_item on  supervision_main.item=supervision_item.id
where supervision_main.assessor='$officer' order by supervision_main.rec_date,supervision_main.id limit $start,$pagelen";
$dbquery = mysqli_query($connect,$sql);
echo  "<table width='90%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FBD562' align='center' height='40' class='subHeader'><Td width='50'>ที่</Td><Td width='120'>วันที่</Td><Td>ผู้รับการนิเทศ ติดตาม ประเมินผล</Td><Td>ตำแหน่ง</Td><Td>โรงเรียน</Td><Td>ผู้นิเทศ ติดตาม ประเมินผล</Td><td width='70' align='center'>รายละเอียด</td><td width='40' align='center'>ลบ</td><Td width='40' align='center'>แก้ไข</Td></Tr>";
$N=(($page-1)*$pagelen)+1; //*เกี่ยวข้องกับการแยกหน้า
$M=1;
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'];
$status=$result['status'];
$position_code=$result['position_code'];
$item_active=$result['item_active'];
$item=$result['item'];

$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'];
		}
		
		$status_text="";
		if($status==1){
		$status_text="<font color='#0000FF'>[ภาพรวม]</font>";
		}
		
echo "<tr><td align='center'>$N</td><td align='center'>$rec_date</td><td>$result[prename]$result[name] $result[surname] $status_text</td><td>$position_name</td><td>$result[school_name]</td><td>$assessor</td>";
echo "<td align='center'><a href=?file=sp1&id=$id&index=7&page=$page&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync>คลิก</a></td>";
if($remote_login_status>1){
			if($item_active==1){
			echo "<td align='center'><a href=?file=sp1&id=$id&ref_id=$ref_id&index=2&page=$page&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><img src=../../../images/drop.png border='0'></a></td><td align='center'><a href=?file=sp1&id=$id&ref_id=$ref_id&index=5&page=$page&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><img src=../../../images/edit.png border='0'></a></td>";
			}
			else{
			echo "<td></td><td></td>";
			}
}
else{
			if($item==$supervision_item){
			echo "<td align='center'><a href=?file=sp1&id=$id&ref_id=$ref_id&index=2&page=$page><img src=../../../images/drop.png border='0'></a></td><td align='center'><a href=?file=sp1&id=$id&ref_id=$ref_id&index=5&page=$page&remote_user_office=$remote_user_office&remote_user_id=$remote_user_id&remote_login_status=$remote_login_status&remote_sync=$remote_sync><img src=../../../images/edit.png border='0'></a></td>";
			}
			else{
			echo "<td></td><td></td>";
			}
}
echo "</tr>";
$M++;
$N++;  //*เกี่ยวข้องกับการแยกหน้า
}
echo "</Table>";
} // end if

function goto_url(val){
	if(val==0){
		callfrm("?file=sp1"); 
	}else if(val==1){
			callfrm("?file=sp1&index=4");
	}
}

function goto_update(val){
	if(val==0){
		callfrm("?file=sp1");  
	}else if(val==1){
		callfrm("?file=sp1&index=6");  
	}
}

function ClearCheck() {
	for (var i = 0; i < document.frm1.elements.length; i++)	{
	var e = document.frm1.elements[i];
	e.checked =  false;
	}
}

function check_2(x,t){
var item_a1="a1_"+x;
var item_a2="a2_"+x;

var item_b1="b1_"+x;
var item_b2="b2_"+x;
var item_b3="b3_"+x;
var item_b4="b4_"+x;
var item_b5="b5_"+x;

</script>

$(function() {
			$("#dialog").dialog({
			height: 500,
			width: 500,
			minHeight: 500,
			minWidth: 500,
			autoOpen: false,
			show: "blind",
			hide: "explode",
				modal: true,
				resizable: false,
				buttons: {
					"Close": function() {
						$(this).dialog("close");
					}
				}
			});
			$(".dialogify").click(function(e) {
				e.preventDefault();
				$("#dialog").html("");
				$("#dialog").dialog("option", "title", "Loading...").dialog("open");
				$("#dialog").load(this.href, function() {
					$(this).dialog("option", "title", "คำอธิบาย");
				});
			});
		});	
</script>

${this.title}

Code Editor : sp1.php