Gecko [ 122.154.134.11 ]

Name	Size	Permission
detail.php	3.16 KB	-rw-r--r--
indicator.php	30.6 KB	-rw-r--r--
livesearch1.php	795 B	-rw-r--r--
livesearch2.php	1.03 KB	-rw-r--r--
livesearch3.php	787 B	-rw-r--r--
livesearch4.php	1.02 KB	-rw-r--r--
livesearch_101.php	17.73 KB	-rw-r--r--
permission.php	11.16 KB	-rw-r--r--
report_1.php	31.11 KB	-rw-r--r--
report_2.php	29.43 KB	-rw-r--r--
report_3.php	21.18 KB	-rw-r--r--
report_4.php	5.9 KB	-rw-r--r--
report_5.php	4.04 KB	-rw-r--r--
sp1.php	62.26 KB	-rw-r--r--
sp1_mobile.php	50.04 KB	-rw-r--r--
sp2.php	6.59 KB	-rw-r--r--
sp3.php	5.75 KB	-rw-r--r--
sp4.php	5.23 KB	-rw-r--r--
standard.php	7.89 KB	-rw-r--r--
std_detail.php	8.18 KB	-rw-r--r--
std_detail2.php	9.22 KB	-rw-r--r--
supervision_activity.php	11.1 KB	-rw-r--r--
supervision_activity_number.ph...	10.05 KB	-rw-r--r--
supervision_activity_rate.php	5.49 KB	-rw-r--r--
supervision_item.php	11.3 KB	-rw-r--r--
supervision_year.php	11.12 KB	-rw-r--r--
teach_table.php	13.48 KB	-rw-r--r--

Code Editor : sp1_mobile.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=$_SESSION['login_user_id'];
require_once "modules/supervision/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>

function e_show(){
document.getElementById("person_display").style.display="block";
}
</script>
<script type="text/javascript" src="./css/js/calendarDateInput2.js"></script>

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

if($_SESSION['login_status']>=12){
$_REQUEST['school_index']=$_SESSION['user_school'];
		if($_SESSION['login_status']==14){
		$_REQUEST['person_index']=$_SESSION['login_user_id'];
		}
}

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='100%' 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  "<table width=100% border='0' align='center'>";
		echo "<Tr><td align='right'>";
		if($_SESSION['login_status']<=4){
		?>
		พิมพ์ค้นหาครูฯ <input type="text" size="15" style="background: #C0F9BD" onkeyup="showResult_2(this.value)">
		<div id="livesearch"></div><div id="livesearch_2"></div>
		<?php
		}
		
		echo "</td></Tr>";
		echo "<Tr><td align='right'>";

//เลือกบุคลากร
		if(($_SESSION['login_status']>10) and ($_SESSION['login_status']<=14)){
		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='$_SESSION[user_school]' and status='0' and (position_code='1' or position_code='2' or position_code='3' 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($_SESSION['login_status']>=14){
							if($result['person_id']==$_SESSION['login_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>";
		}
		else{
		echo "<div id='person_display' style='display:none' 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='$_REQUEST[school_index]' and status='0' and (position_code='1' or position_code='2' or position_code='3' 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($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 "</div>";
		}
		echo "</td></Tr>";
		echo "</Table>";
		if($_REQUEST['school_index']!=""){
		echo "<script>e_show();</script>"; 
		}
		//จบ
		
		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($_SESSION['login_status']<=4){
		$level=3;
		}
		else if($_SESSION['login_status']>=14){
		$level=1;
		}
		else if($_SESSION['login_status']==12 or $_SESSION['login_status']==13){
					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=\"?option=supervision&task=main/sp1_mobile&index=1\"' 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=\"?option=supervision&task=main/sp1_mobile&index=1\"' class='button button2'></div>";
		exit();
		}
		
		echo  "<table width='100%' border='1' align='center' style='border-collapse: collapse'>";
		echo "<Tr bgcolor='#FBD562' align='center' height='30' class='subHeader'><td align='center' 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='30'><br><a href='modules/supervision/main/sp2.php?ref_id=$ref_id&school_index=$_REQUEST[school_index]&person_index=$_REQUEST[person_index]&officer=$officer&return=1' class='dialogify'><img src=./images/edit.png border='0'></a></td></Tr>";
		echo "<Tr><td width='50' align='center' bgcolor='#B4E4BB'>ไม่ได้<br>ดำเนินการ</td><td width='50' align='center' bgcolor='#B4E4BB'>ดำเนินการ</td><Td width='40' align='center'>น้อยที่สุด<br><font color='#271DA9'></font></td><Td width='40' align='center'>น้อย<br><font color='#271DA9'></font></td><Td width='40' align='center' bgcolor='#F5ECCE'>ปานกลาง<br><font color='#271DA9'></font></td><Td width='40' align='center'>มาก<br><font color='#271DA9'></font><Td width='40' 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='9'>$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 align='left' bgcolor='#FFFFB' colspan='8'>$M.$N $subject_name</Td>";
					echo "<td align='center' bgcolor='#FFFFB'><a href='modules/supervision/main/sp2.php?ref_id=$ref_id&school_index=$_REQUEST[school_index]&subject_code=$subject_code&person_index=$_REQUEST[person_index]&officer=$officer&return=1' 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 align='left' colspan='9'>$M.$N.$X $indicator_name";
									if($indicator_explain!="" or $type==2){
									echo "<span id='start$id_indicator'>";
									echo "<font size='1'>"; ?> 
									<a href="#" onclick="explain(<?php echo $id_indicator; ?>,1);">[อธิบาย]</a> <?php
									echo "</font>";
									
									echo "</span>";
									echo "<span id='stop$id_indicator' style='display:none'>";
									echo "<font size='1'>"; ?> 
									<a href="#" onclick="explain(<?php echo $id_indicator; ?>,2);">[ปิดคำอธิบาย]</a> <?php
									echo "</font>";
									echo "</span>";
									}
									echo "<span id='$id_indicator' style='display:none'>";
									if($type==1){
									echo "<font color='#5858FA'>$indicator_explain</font>";
									}
									if($type==2){
									echo "<font color='#5858FA'>";
									echo "ค่าต่ำสุด = $min"; echo "<br>";
									echo "ค่าสูงสุด = $max"; echo "<br>";
									echo "ระดับน้อยที่สุด = $g1"; echo "<br>";
									echo "ระดับน้อย = $g2"; echo "<br>";
									echo "ระดับปานกลาง = $g3"; echo "<br>";
									echo "ระดับมาก = $g4"; echo "<br>";
									echo "ระดับมากที่สุด = $g5"; echo "<br>";
									echo $indicator_explain;
									echo "</font>";
									}
									echo "</span>";
									echo "</Td></tr>";
									
									echo "<tr><td></td><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='school_index' value='$_REQUEST[school_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>";		
		echo "</form>";
		} //end if($name!="")
}

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=\"?option=supervision&task=main/sp1_mobile&index=3&id=$_GET[id]&ref_id=$_GET[ref_id]&page=$_GET[page]\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?option=supervision&task=main/sp1_mobile&page=$_GET[page]\"'";
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($_SESSION['login_status']<=4){
$level=3;
}
else if($_SESSION['login_status']>=14){
$level=1;
}
else if($_SESSION['login_status']==12 or $_SESSION['login_status']==13){
			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 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'];

echo "<form id='frm1' name='frm1'>";
		echo "<table width='100%' border='0' align='center'>";
		echo "<Tr ><Td colspan='4' align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?option=supervision&task=main/sp1_mobile&page=$_GET[page]\"'></Td></Tr>";

echo "<tr align='left'><td><font color='#271DA9'><strong>ชื่อ : </strong></font>$prename$name $surname&nbsp;&nbsp;&nbsp;<font color='#271DA9'><strong>โรงเรียน: </strong></font>$school_name</td>";
		echo "</tr>";
		echo "</table>";
	
		echo  "<table width='100%' border='1' align='center' style='border-collapse: collapse'>";
		echo "<Tr bgcolor='#FBD562' align='center' height='30' class='subHeader'><td align='center' 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='modules/supervision/main/sp2.php?ref_id=$ref_id&school_index=$school_index&person_index=$person_index&officer=$officer&officer=$officer&return=1.1&page=$_GET[page]' 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'>ดี<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='9'>$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 align='left' bgcolor='#FFFFB' colspan='8'>$M.$N $subject_name</Td>";
					echo "<td align='center' bgcolor='#FFFFB'><a href='modules/supervision/main/sp2.php?ref_id=$ref_id&school_index=$school_index&subject_code=$subject_code&person_index=$person_index&officer=$officer&officer=$officer&return=1.1&page=$_GET[page]' 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 align='left' colspan='9'>$M.$N.$X $indicator_name";
									if($indicator_explain!="" or $type==2){
									echo "<span id='start$id_indicator'>";
									echo "<font size='1'>"; ?> 
									<a href="#" onclick="explain(<?php echo $id_indicator; ?>,1);">[อธิบาย]</a> <?php
									echo "</font>";
									
									echo "</span>";
									echo "<span id='stop$id_indicator' style='display:none'>";
									echo "<font size='1'>"; ?> 
									<a href="#" onclick="explain(<?php echo $id_indicator; ?>,2);">[ปิดคำอธิบาย]</a> <?php
									echo "</font>";
									echo "</span>";
									}
									echo "<span id='$id_indicator' style='display:none'>";
									if($type==1){
									echo "<font color='#5858FA'>$indicator_explain</font>";
									}
									if($type==2){
									echo "<font color='#5858FA'>";
									echo "ค่าต่ำสุด = $min"; echo "<br>";
									echo "ค่าสูงสุด = $max"; echo "<br>";
									echo "ระดับน้อยที่สุด = $g1"; echo "<br>";
									echo "ระดับน้อย = $g2"; echo "<br>";
									echo "ระดับปานกลาง = $g3"; echo "<br>";
									echo "ระดับมาก = $g4"; echo "<br>";
									echo "ระดับมากที่สุด = $g5"; echo "<br>";
									echo $indicator_explain;
									echo "</font>";
									}
									echo "</span>";
									echo "</Td></tr>";
									
									
									$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 "<tr><td></td><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'><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 "<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='40%' 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='modules/supervision/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])
										}
								}
					}			
		}	
				//แก้ไข 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==1) or ($index==2) or ($index==5))){
//ส่วนของการแยกหน้า
$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="option=supervision&task=main/sp1_mobile";  // 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($_SESSION['login_status']>10){
		if($time_for_teacher==1){
echo  "<table width='100%' border='0' align='center'>";
echo "<Tr><Td align='left'><INPUT TYPE='button' name='smb' value='บันทึกการนิเทศ ฯ' onclick='location.href=\"?option=supervision&task=main/sp1_mobile&index=1\"' 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>";
		}
}
else{
echo  "<table width='100%' border='0' align='center'>";
echo "<Tr><Td align='left'><INPUT TYPE='button' name='smb' value='บันทึกการนิเทศ ฯ' onclick='location.href=\"?option=supervision&task=main/sp1_mobile&index=1\"' class='button button2'></Td><td align='right'></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 supervision_item on  supervision_main.item=supervision_item.id
left join system_school on  supervision_main.school_id=system_school.school_code 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='100%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FBD562' align='center' height='40' class='subHeader'><Td>ที่</Td><Td>วันที่</Td><Td>ผู้รับการนิเทศ ฯ</Td><Td>โรงเรียน</Td><td align='center'>ลบ</td><Td 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'];
$item_active=$result['item_active'];
$item=$result['item'];

echo "<tr><td align='center'>$N</td><td align='center'>$rec_date</td><td>$result[prename]$result[name] $result[surname]</td><td>$result[school_name]</td>";
if($_SESSION['login_status']>10){	
		if($item_active==1){
			echo "<td align='center'><a href=?option=supervision&task=main/sp1_mobile&id=$id&ref_id=$ref_id&index=2&page=$page><img src=./images/drop.png border='0'></a></td><td align='center'><a href=?option=supervision&task=main/sp1_mobile&id=$id&ref_id=$ref_id&index=5&page=$page><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=?option=supervision&task=main/sp1_mobile&id=$id&ref_id=$ref_id&index=2&page=$page><img src=./images/drop.png border='0'></a></td><td align='center'><a href=?option=supervision&task=main/sp1_mobile&id=$id&ref_id=$ref_id&index=5&page=$page><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("?option=supervision&task=main/sp1_mobile"); 
	}else if(val==1){
			callfrm("?option=supervision&task=main/sp1_mobile&index=4");
	}
}

function goto_update(val){
	if(val==0){
		callfrm("?option=supervision&task=main/sp1_mobile");  
	}else if(val==1){
		callfrm("?option=supervision&task=main/sp1_mobile&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: 400,
			width: 380,
			minHeight: 400,
			minWidth: 380,
			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_mobile.php