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 : report_3.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>

<?php
$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'];
}
if(!(isset($_REQUEST['item_index']))){
$_REQUEST['item_index']=$supervision_item;
}

//ส่วนหัว
echo "<br />";
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==6){
$sql="select * from person_main where person_id='$_GET[person_id]' ";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>$result[prename]$result[name] $result[surname]</strong></font></td></tr>";
echo "</table>";

//ส่วนของการแยกหน้า
$sql = "select  id from supervision_main where assessor='$_GET[person_id]' and item='$_REQUEST[item_index]'";
$dbquery = mysqli_query($connect,$sql);
$num_rows = mysqli_num_rows($dbquery );

$pagelen=20;  // 1_กำหนดแถวต่อหน้า
$url_link="option=supervision&task=main/report_3&index=6&person_id=$_GET[person_id]&item_index=$_REQUEST[item_index]";  // 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 "</div>";  
}					
//จบแยกหน้า

$sql = "select *,supervision_main.id,supervision_main.rec_date,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 assessor='$_GET[person_id]' and item='$_REQUEST[item_index]' order by supervision_main.rec_date,supervision_main.id limit $start,$pagelen";
$dbquery = mysqli_query($connect,$sql); 
echo "<table width='80%' border='0' align='center'>";
echo "<Tr ><Td align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?option=supervision&task=main/report_3&item_index=$_REQUEST[item_index]\"' class='button button2'></Td></Tr>";
echo "</table>";
echo  "<table width='80%' 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></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'];

$sql_position = "select position_name from person_sch_position where position_code='$position_code' "; 
		$dbquery_position = mysqli_query($connect,$sql_position);
		$result_position = mysqli_fetch_array($dbquery_position);
		$position_name=$result_position['position_name'];

$sql_2 = "select * from person_main where person_id='$assessor' "; 
		$dbquery_2 = mysqli_query($connect,$sql_2);
		if($result_2 = mysqli_fetch_array($dbquery_2)){
		$assessor=$result_2['prename'].$result_2['name']." ".$result_2['surname'];
		}
		else {
		$sql_2 = "select * from person_sch_main where person_id='$assessor' "; 
		$dbquery_2 = mysqli_query($connect,$sql_2);
		$result_2 = mysqli_fetch_array($dbquery_2);
		$assessor=$result_2['prename'].$result_2['name']." ".$result_2['surname'];
		}
		
		$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=?option=supervision&task=main/report_3&id=$id&index=7&page=$page&person_id=$_GET[person_id]&item_index=$_REQUEST[item_index]><img src=./images/browse.png border='0' alt='รายละเอียด'></a></td></tr>"; 
$M++;
$N++;  //*เกี่ยวข้องกับการแยกหน้า
}
echo "</Table>";
}

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=\"?option=supervision&task=main/report_3&index=6&page=$_GET[page]&person_id=$_GET[person_id]&item_index=$_REQUEST[item_index]\"' class='button button2'></Td></Tr>";

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

if($row_num==0){
echo "<div style='display:none'>";	
}
else{
echo "<div style='display:block'>";	
}
	
		echo  "<table width='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></Tr>";
		echo "<Tr><td width='70' align='center' bgcolor='#B4E4BB'>ไม่ได้<br>ดำเนินการ</td><td width='70' align='center' bgcolor='#B4E4BB'>ดำเนินการ</td><Td width='50' align='center'>กำลังพัฒนา<br><font color='#271DA9'></font></td><Td width='40' align='center'>ปานกลาง<br><font color='#271DA9'></font></td><Td width='50' align='center' bgcolor='#F5ECCE'>ดี<br><font color='#271DA9'></font></td><Td width='50' align='center'>ดีเลิศ<br><font color='#271DA9'></font><Td width='50' align='center'>ยอดเยี่ยม<br><font color='#271DA9'></font></Td></Tr>";
$M=1;
$sql_1 = "select * from supervision_standard where year='$standard_year' order by standard_code";
$dbquery_1 = mysqli_query($connect,$sql_1);
While ($result_1 = mysqli_fetch_array($dbquery_1))	{

$id_standard = $result_1['id'];
		$standard_code= $result_1['standard_code'];
		$standard_name= $result_1['standard_name'];
		
		echo "<Tr bgcolor='#ddd' align='center'><Td align='left' colspan='11'>$M $standard_name</Td></tr>";
				$sql_2 = "select * from supervision_subject where standard_code=$standard_code order by subject_code ";
				$N=1; 
				$dbquery_2 = mysqli_query($connect,$sql_2);
				While ($result_2 = mysqli_fetch_array($dbquery_2)) {
						$id_subject = $result_2['id'];
						$subject_code= $result_2['subject_code']; 
						$subject_name= $result_2['subject_name'];
					echo "<Tr align='center'><td></td><Td align='left' bgcolor='#FFFFB' colspan='9'>$M.$N $subject_name</Td>";
					
								$sql_3 = "select * from supervision_indicator where subject_code=$subject_code order by indicator_code ";
								$dbquery_3 = mysqli_query($connect,$sql_3);
								$X=1;
								While ($result_3 = mysqli_fetch_array($dbquery_3)) {
										$id_indicator = $result_3['id'];
										$indicator_code= $result_3['indicator_code'];
										$indicator_name= $result_3['indicator_name'];
										$type= $result_3['type']; 
										$unit= $result_3['unit'];
										$min= $result_3['min'];
										$max= $result_3['max'];
										$g1= $result_3['g1'];
										$g2= $result_3['g2'];
										$g3= $result_3['g3'];
										$g4= $result_3['g4'];
										$g5= $result_3['g5'];
										$function_number= $result_3['function_number'];
										$indicator_explain= $result_3['indicator_explain'];
										
									echo "<Tr align='center'><td colspan='2'></td><Td align='left'>$M.$N.$X $indicator_name";
									
if($indicator_explain!="" or $type==2){
?>
<a href="modules/supervision/main/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='modules/supervision/upload_files/$result_ref_2[file_name]' target='_blank'>ดาวน์โหลดเอกสาร $F</a>";
				echo "</Td></Tr>";
				echo "</tr>";
				echo "</table>";
				$F++;
				}
}

//ส่วนแสดงผล

if(!(($index==6) or ($index==7))){
echo "<br>";
		echo "<form id='frm1' name='frm1'>";
		echo  "<table width=80% border='0' align='center'>";
		echo "<Tr><td align='right'>";
		echo "รอบการนิเทศฯ&nbsp;&nbsp;<Select  name='item_index' size='1' style='color: #009900' onchange='goto_index(1)'>";
		$sql_item = "select * from supervision_item order by id desc";
		$dbquery_item = mysqli_query($connect,$sql_item);
		While ($result_item = mysqli_fetch_array($dbquery_item))
		   {
				if($_REQUEST['item_index']==$result_item['id']){
				echo "<option value=$result_item[id] selected>$result_item[item]</option>"; 
				}
				else{
				echo "<option value=$result_item[id]>$result_item[item]</option>"; 
				}
			}
		echo "</select>";
		echo "</td></Tr>";
		echo "</table>";
		echo "</form>";
		
$sql="select * from supervision_permission left join person_main on supervision_permission.person_id=person_main.person_id 
left join person_position on person_main.position_code=person_position.position_code where supervision_permission.p2='1' 
order by person_main.position_code,person_main.person_order ";
$dbquery = mysqli_query($connect,$sql);
echo  "<table width='80%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FBD562' align='center' height='40' class='subHeader'><Td width='50'>ที่</Td><Td>ผู้นิเทศ ติดตาม และประเมินผล</Td><Td>ตำแหน่ง</Td><td width='120' align='center'>จำนวนชุด</td><td width='70' align='center'>รายละเอียด</td></Tr>";
$N=1;
While ($result = mysqli_fetch_array($dbquery))	{
$id=$result['id'];
$person_id=$result['person_id'];
$position_name=$result['position_name'];
		
		$sql_1 = "select count(supervision_main.id) as num from supervision_main where assessor='$person_id' and item='$_REQUEST[item_index]'";
		$dbquery_1 = mysqli_query($connect,$sql_1);
		$result_1 = mysqli_fetch_array($dbquery_1);

echo "<tr><td align='center'>$N</td><td>$result[prename]$result[name] $result[surname]</td><td>$position_name</td><td align='center'>$result_1[num]</td>";
if($result_1['num']>0){
echo "<td align='center'><a href=?option=supervision&task=main/report_3&person_id=$person_id&index=6&item_index=$_REQUEST[item_index]><img src=./images/browse.png border='0' alt='รายละเอียด'></a></td>";
}
else{
echo "<td></td>";
}
echo "</tr>"; 
$N++;  
}
echo "</Table>";
} // end if

?>
<script>
function goto_index(val){
	if(val==1){
		callfrm("?option=supervision&task=main/report_3"); 
	}
}
</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 : report_3.php