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 : standard.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
if($result_permission['p1']!=1){
exit();
}

$officer=$_SESSION['login_user_id'];

$sql = "select * from  supervision_year where year_active='1' order by year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$year_active_result = mysqli_fetch_array($dbquery);
if(!($year_active_result)){
echo "<script>alert('ยังไม่ได้กำหนดปีมาตรฐาน ไปที่เมนูจัดการระบบ รายการกำหนดปีมาตรฐานปัจจุบัน'); </script>";
exit();
}

//ส่วนหัว
echo "<br />";
if(!(($index==1) or ($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 "<Table width='60%' align='center'>";
echo "<tr><td>";
echo  "<fieldset>";
echo "<legend>&nbsp; <B>กรอกข้อมูล</B>: &nbsp;</legend>";

echo "<form id='frm1' name='frm1'>";
echo "<Center>";
echo "<Font color='#006666' Size='3'><B>มาตรฐานการจัดการศึกษา</B></Font>";
echo "</Cener>";
echo "<Br>";
echo "<Table width='80%' Border='0' align='center'>";
echo "<Tr align='left'><Td ></Td><Td align='right'>รหัส&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='standard_code'  Size='6' value='$year_active_result[year]xx'></Td></Tr>";
echo "<Tr align='left'><Td ></Td><Td align='right'></Td><Td>* เริ่มต้น 4 หลักแรกด้วยปี พ.ศ. ที่กำหนดเป็นปีมาตรฐาน แล้วตามด้วยลำดับมาตรฐาน 01 ,02 </Td></Tr>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อมาตรฐาน&nbsp;&nbsp;</Td><Td><Input Type='Text' 
Name='standard_name' Size='50'></Td></Tr>";
echo "<Br>";
echo "</Table>";
echo "<Br>";
echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(1)'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ย้อนกลับ' onclick='goto_url(0)'>";
echo "</form>";

echo "</fieldset>";
echo "</td></tr>";
echo "</table>";
}

//ส่วนยืนยันการลบข้อมูล
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/standard&index=3&id=$_GET[id]\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?option=supervision&task=main/standard\"'";
echo "</td></tr></table>";
}

//ส่วนลบข้อมูล
if($index==3){
$sql = "delete from supervision_standard where id='$_GET[id]'";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนบันทึกข้อมูล
if($index==4){
$rec_date = date("Y-m-d");
$sql = "insert into supervision_standard(year,standard_code,standard_name,officer,rec_date) values ('$year_active_result[year]','$_POST[standard_code]', '$_POST[standard_name]','$officer','$rec_date')";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนฟอร์มแก้ไขข้อมูล
if($index==5){
$sql = "select * from supervision_standard where id='$_GET[id]' ";
$dbquery = mysqli_query($connect,$sql);
$result_ref = mysqli_fetch_array($dbquery);

echo "<Table width='60%' align='center'>";
echo "<tr><td>";
echo  "<fieldset>";
echo "<legend>&nbsp; <B>แก้ไขข้อมูล</B>: &nbsp;</legend>";

echo "<form id='frm1' name='frm1'>";
echo "<Table width='60%' Border='0' align='center'>";
echo "<Tr align='left'><Td ></Td><Td align='right'>รหัส&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='standard_code'  Size='5' value='$result_ref[standard_code]'></Td></Tr>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อมาตรฐาน&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='standard_name' Size='50' value='$result_ref[standard_name]'></Td></Tr>";
echo "<Br>";
echo "</Table>";
echo "<Br>";
echo "<div align='center'>";
echo "<INPUT TYPE='Hidden' name='id' value='$_GET[id]'>";
echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url_update(1)'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ย้อนกลับ' onclick='goto_url_update(0)'>";
echo "</div>";		
echo "</form>";

echo "</fieldset>";
echo "</td></tr>";
echo "</table>";
}

//ส่วนปรับปรุงข้อมูล
if ($index==6){
$rec_date = date("Y-m-d");
$sql = "update supervision_standard set standard_code='$_POST[standard_code]', standard_name='$_POST[standard_name]', officer='$officer', rec_date='$rec_date' where id='$_POST[id]'";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==2) or ($index==5))){

echo  "<table width='60%' border='0' align='center'>";
echo "<Tr><Td align='left'><INPUT TYPE='button' name='smb' value='เพิ่มมาตรฐาน' onclick='location.href=\"?option=supervision&task=main/standard&index=1\"'></Td><td align='right'>";
echo "</td></Tr></Table>";

echo  "<table width='60%' border='1' align='center' style='border-collapse: collapse'>";
$sql = "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 = mysqli_query($connect,$sql);
echo "<Tr bgcolor='#ddd' align='center' height='30' class='subHeader'><Td width='60'>ที่</Td><Td width='70'>รหัส</Td><Td>มาตรฐานการจัดการศึกษา</Td><td width='50'>ลบ</td><Td width='50'>แก้ไข</Td></Tr>";

$N=1;
While ($result = mysqli_fetch_array($dbquery))
	{
		$id = $result['id'];
		$standard_code= $result['standard_code'];
		$standard_name= $result['standard_name'];
		
		if(($N%2) == 0)
		$color="#FFFFC";
		else 	$color="#FFFFFF";
		
		echo "<Tr bgcolor='$color' align='center' valign='top'><Td >$N</Td><Td align='center'>$standard_code</Td><Td align='left'>$standard_name</Td>";
		echo "<td><a href=?option=supervision&task=main/standard&id=$id&index=2><img src=./images/drop.png border='0'></a></td>";
		echo "<td><a href=?option=supervision&task=main/standard&id=$id&index=5><img src=./images/edit.png border='0'></a></Td</Tr>";
$N++; 
	}
}
?>

</script>

${this.title}

Code Editor : standard.php