Gecko [ 122.154.134.11 ]

Name	Size	Permission
affair.php	13.31 KB	-rw-r--r--
b_pic.php	5.98 KB	-rw-r--r--
building_building.php	16.72 KB	-rw-r--r--
building_building_report.php	5.4 KB	-rw-r--r--
building_fix.php	15.92 KB	-rw-r--r--
building_fix_report.php	6.52 KB	-rw-r--r--
building_heavy.php	16 KB	-rw-r--r--
building_heavy_report.php	6.55 KB	-rw-r--r--
building_main.php	30.9 KB	-rw-r--r--
category.php	6.52 KB	-rw-r--r--
livesearch_2.php	659 B	-rw-r--r--
livesearch_3.php	667 B	-rw-r--r--
livesearch_4.php	667 B	-rw-r--r--
model.php	15.4 KB	-rw-r--r--
pic_show.php	709 B	-rw-r--r--
report_1.php	13.61 KB	-rw-r--r--
report_1_mobile.php	12.38 KB	-rw-r--r--
report_affair.php	5.02 KB	-rw-r--r--
report_affair_mobile.php	4.87 KB	-rw-r--r--
report_affair_web.php	5.31 KB	-rw-r--r--
return_ajax_cate.php	614 B	-rw-r--r--
return_ajax_type.php	620 B	-rw-r--r--

Code Editor : category.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'];

//ส่วนหัว
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'>รหัส (2 หลัก)&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='cate_code'  Size='4'></Td></Tr>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อประเภท&nbsp;&nbsp;</Td><Td><Input Type='Text' 
Name='cate_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=building&task=main/category&index=3&id=$_GET[id]\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?option=building&task=main/category\"'";
echo "</td></tr></table>";
}

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

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

//ส่วนฟอร์มแก้ไขข้อมูล
if($index==5){
$sql = "select * from building_category 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='cate_code'  Size='5' value='$result_ref[cate_code]'></Td></Tr>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อมาตรฐาน&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='cate_name' Size='50' value='$result_ref[cate_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 building_category set cate_code='$_POST[cate_code]', cate_name='$_POST[cate_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=building&task=main/category&index=1\"'></Td><td align='right'>";
echo "</td></Tr></Table>";

echo  "<table width='60%' border='1' align='center' style='border-collapse: collapse'>";
$sql = "select * from building_category order by id";
$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'];
		$cate_code= $result['cate_code'];
		$cate_name= $result['cate_name'];
		
		if(($N%2) == 0)
		$color="#FFFFC";
		else 	$color="#FFFFFF";
		
		echo "<Tr bgcolor='$color' align='center' valign='top'><Td >$N</Td><Td align='center'>$cate_code</Td><Td align='left'>$cate_name</Td>";
		echo "<td><a href=?option=building&task=main/category&id=$id&index=2><img src=./images/drop.png border='0'></a></td>";
		echo "<td><a href=?option=building&task=main/category&id=$id&index=5><img src=./images/edit.png border='0'></a></Td</Tr>";
$N++; 
	}
}
?>

</script>

${this.title}

Code Editor : category.php