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

<?php
session_start();

if(!(isset($_SESSION['login_user_id']))){
 exit();
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<?php
if(isset($_SESSION['user_os'])){
	if($_SESSION['user_os']=='mobile'){
	echo "<meta name = 'viewport' content = 'width = device-width'>";
	}
}
?>
<style type="text/css">

</style>
</head>
<body>

<?php
require_once "../../../amssplus_connect.php";	
require_once("../../../mainfile.php");

$sql_item = "select id,item 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'];
$item_name=$result_item['item'];
}
else{
$sql_item = "select id,item 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'];
$item_name=$result_item['item'];
}

$sql_school = "select school_name from system_school where school_code='$_GET[school_code]'";
$dbquery_school = mysqli_query($connect,$sql_school);
$result_school = mysqli_fetch_array($dbquery_school);
$school_name=$result_school['school_name'];

echo "<br />";
echo "<table width='70%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>รายงานการประเมินตนเอง</strong></font></td></tr>";
echo "<tr align='center'><td><font color='#006666' size='2'><strong>$item_name</strong></font></td></tr>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>$school_name</strong></font></td></tr>";
echo "</table>";

echo "<br>";
echo "<table border='1' style='border-collapse: collapse' width='90%' align='center'>";
echo "<Tr bgcolor='#E6E6E6' align='center'><Td width='50'>ที่</Td><Td>ชื่อ</Td><Td>ตำแหน่ง</Td><td width='50'>ประเมินตนเอง</Td><td width='50'>แนบไฟล์</Td></Tr>";

$sql3 = "select *,person_sch_main.person_id from person_sch_main  left join person_sch_position on person_sch_main.position_code=person_sch_position.position_code where person_sch_main.school_code='$_GET[school_code]' and (person_sch_main.position_code='1' or person_sch_main.position_code='2' or person_sch_main.position_code='3' or person_sch_main.position_code='4' or person_sch_main.position_code='11' or person_sch_main.position_code='12' or person_sch_main.position_code='31' or person_sch_main.position_code='35') and person_sch_main.status='0' order by person_sch_main.position_code ";
$dbquery3 = mysqli_query($connect,$sql3);
$N=1;
While ($result3 = mysqli_fetch_array($dbquery3)){
$person_id = $result3['person_id'];
$prename = $result3['prename'];
$name = $result3['name'];
$surname = $result3['surname'];
$position_name = $result3['position_name'];
$file_check="";
			if(($N%2) == 0)
			$color="#FFFFC";
			else  $color="#FFFFFF";
			
			$sql4 = "select  id,ref_id from supervision_main where person_id='$person_id' and school_id='$_GET[school_code]' and level='1' and item='$supervision_item' ";
			$dbquery4 = mysqli_query($connect,$sql4);
			$result4 = mysqli_fetch_array($dbquery4);
			$ref_id=$result4['ref_id']; 
					if($result4){
					$do_check="<b>/</b>";
								$sql5 = "select  id from supervision_file where ref_id='$ref_id' ";
								$dbquery5 = mysqli_query($connect,$sql5);
								$result5 = mysqli_fetch_array($dbquery5);
								if($result5){
								$file_check="<b>/</b>";
								}
								else{
								$file_check="";
								}
					}
					else{
					$do_check="";
					}

echo "<tr bgcolor='$color'><td align='center'>$N</td><td>$prename$name&nbsp;&nbsp;&nbsp;$surname</td><td>$position_name</td><td align='center'>$do_check</td><td align='center'>$file_check</td></tr>";
$N++;
}
echo "</table>";
?>

${this.title}

Code Editor : report_5.php