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 : model.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();
}
?>
<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

$officer=$_SESSION['login_user_id'];

if(!(isset($_REQUEST['group_index']))){
$_REQUEST['group_index']="";
}

//ส่วนหัว
echo "<br />";
if(!(($index==1) or ($index==1.1) or ($index==2) or ($index==2.1) or ($index==5) or ($index==5.1))){
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='70%' 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='70%' Border='0' align='center'>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ประเภท&nbsp;&nbsp;</Td>";
echo "<td><div align='left'><Select  name='cate_code'  size='1'>";
echo  "<option  value = ''>เลือก</option>" ;
$sql = "select * from building_category order by cate_code";
$dbquery = mysqli_query($connect,$sql);
while($result = mysqli_fetch_array($dbquery)){
		$cate_code = $result['cate_code']; 
		$cate_name = $result['cate_name'];
		if($_GET['cate']==$cate_code){
		echo  "<option value=$cate_code selected>$cate_code $cate_name</option>" ;
		}
}				
echo "</select>";
echo "</div></td></tr>";

$sql_2 = "select * from building_type where cate_code='$_GET[cate]' order by id desc";
				$dbquery_2 = mysqli_query($connect,$sql_2);
				$result_2 = mysqli_fetch_array($dbquery_2);
				$type_num=$result_2['type_code']; 
				$type_num=substr($type_num,-2,2);
				if($type_num<=8){
				$type_num="0".($type_num+1);
				}
				else{
				$type_num=($type_num+1);
				}
				$type_num2=$_GET['cate'].$type_num;
echo "<Tr align='left'><Td ></Td><Td align='right'>รหัสชนิด&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='type_code'  Size='8' value='$type_num2'> *เลข 4 หลัก สองหลักแรกเป็นรหัสประเภท</Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อชนิด&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='type_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==1.1){
echo "<Table width='70%' 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>";
echo "<td><div align='left'><Select  name='type_code'  size='1'>";
echo  "<option  value = ''>เลือก</option>" ;
$sql = "select * from building_type where type_code='$_GET[type]' ";
$dbquery = mysqli_query($connect,$sql);
while($result = mysqli_fetch_array($dbquery)){
		$type_code = $result['type_code']; 
		$type_name = $result['type_name'];
		echo  "<option value=$type_code selected>$type_code $type_name</option>" ;
}				
echo "</select>";
echo "</div></td></tr>";

$sql_3 = "select * from building_model where type_code='$_GET[type]' order by id desc";
								$dbquery_3 = mysqli_query($connect,$sql_3);
								$result_3 = mysqli_fetch_array($dbquery_3);
								$model_num=$result_3['model_code']; 
								$model_num=substr($model_num,-2,2);
								if($model_num<=8){
								$model_num="0".($model_num+1);
								}
								else{
								$model_num=($model_num+1);
								}
								$model_num2=$_GET['type'].$model_num;
							echo "<Tr align='left'><Td ></Td><Td align='right'>รหัสแบบ&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='model_code' Size='10' value='$model_num2'> * รหัส 6  หลัก  2 หลักแรกเป็นรหัสประเภท  2 หลักต่อมาเป็นรหัสชนิด</Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อแบบ&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='model_name' Size='50'></Td></Tr>";

echo "<Br>";
echo "</Table>";
echo "<Br>";
echo "<INPUT TYPE='button' name='smb' value='ตกลง' onclick='goto_url(2)'>
		&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/model&index=3&id=$_GET[id]\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?option=building&task=main/model\"'";
echo "</td></tr></table>";
}

if($index==2.1) {
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/model&index=3.1&id=$_GET[id]\"'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ยกเลิก' onclick='location.href=\"?option=building&task=main/model\"'";
echo "</td></tr></table>";
}

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

if($index==3.1){
$sql = "delete from building_model where id=$_GET[id]";
$dbquery = mysqli_query($connect,$sql);
}

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

if($index==4.1){
$rec_date = date("Y-m-d");
$sql = "insert into building_model(model_code,type_code,model_name,officer,rec_date) values ('$_POST[model_code]','$_POST[type_code]','$_POST[model_name]','$officer','$rec_date')";
$dbquery = mysqli_query($connect,$sql);
}

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

echo "<Table width='70%' align='center'>";
echo "<tr><td>";
echo  "<fieldset>";
echo "<legend>&nbsp; <B>แก้ไขข้อมูลชนิดสิ่งก่อสร้าง</B>: &nbsp;</legend>";

echo "<form id='frm1' name='frm1'>";
echo "<Table width='70%' Border='0' align='center'>";

echo "<Tr align='left'><Td ></Td><Td align='right'>รหัสชนิด&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='type_code'  Size='5' value='$result_ref[type_code]' readonly></Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อชนิด&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='type_name' Size='50' value='$result_ref[type_name]'></Td></Tr>";
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 "</form>";
echo "</div>";

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

if($index==5.1){
$sql = "select * from building_model where id='$_GET[id]' ";
$dbquery = mysqli_query($connect,$sql);
$result_ref = mysqli_fetch_array($dbquery);

echo "<Table width='70%' align='center'>";
echo "<tr><td>";
echo  "<fieldset>";
echo "<legend>&nbsp; <B>แก้ไขแบบสิ่งก่อสร้าง</B>: &nbsp;</legend>";

echo "<form id='frm1' name='frm1'>";
echo "<Table width='70%' Border='0' align='center'>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ชนิด&nbsp;&nbsp;</Td>";
echo "<td><div align='left'><Select  name='type_code'  size='1'>";
$sql = "select * from building_type where type_code='$result_ref[type_code]'";
$dbquery = mysqli_query($connect,$sql);
while($result = mysqli_fetch_array($dbquery)){
		$type_code = $result['type_code']; 
		$type_name = $result['type_name'];
		
		echo  "<option value=$type_code>$type_code $type_name</option>" ;
}				
echo "</select>";
echo "</div></td></tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>รหัสแบบ&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='model_code'  Size='10' value='$result_ref[model_code]' readonly></Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>ชื่อแบบ&nbsp;&nbsp;</Td><Td><Input Type='Text' Name='model_name' Size='50' value='$result_ref[model_name]'></Td></Tr>";

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(2)'>
		&nbsp;&nbsp;<INPUT TYPE='button' name='back' value='ย้อนกลับ' onclick='goto_url_update(0)'>";
echo "</form>";
echo "</div>";

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

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

if ($index==6.1){
$rec_date = date("Y-m-d");
$sql = "update building_model set model_name='$_POST[model_name]', 
officer='$officer', rec_date='$rec_date' 
where id='$_POST[id]'";
$dbquery = mysqli_query($connect,$sql);
}

//ส่วนแสดงผล
if(!(($index==1) or ($index==1.1) or ($index==2) or ($index==2.1) or ($index==5) or ($index==5.1))){
echo "<br>";
echo  "<table width='90%' border='1' align='center' style='border-collapse: collapse'>";
echo "<Tr bgcolor='#FBD562' align='center' height='40' class='subHeader'><Td width='50'>ที่</Td><Td width='200'>ประเภท</Td><Td>ชนิด</Td><Td>แบบ</Td><td width='40' align='center'>ลบ</td><Td width='40' align='center'>แก้ไข</Td></Tr>";

$M=1;
$N=1; 
$X=1;
$sql_1 = "select * from building_category order by cate_code";
$dbquery_1 = mysqli_query($connect,$sql_1);
While ($result_1 = mysqli_fetch_array($dbquery_1))	{

$id = $result_1['id'];
		$cate_code= $result_1['cate_code'];
		$cate_name= $result_1['cate_name'];
		
		echo "<Tr bgcolor='#ddd' align='center'><td>$M</td><Td align='left' colspan='2'>$cate_code $cate_name</Td><td align='right'><INPUT TYPE='button' name='smb' value='เพิ่มชนิด' onclick='location.href=\"?option=building&task=main/model&index=1&cate=$cate_code\"' class='button button2'></td><td colspan='2'></td></tr>";
				$sql_2 = "select * from building_type where cate_code=$cate_code order by type_code ";
				$dbquery_2 = mysqli_query($connect,$sql_2);
				While ($result_2 = mysqli_fetch_array($dbquery_2)) {
						$id = $result_2['id'];
						$type_code= $result_2['type_code'];
						$type_name= $result_2['type_name'];
					echo "<Tr align='center'><td colspan='2'></td><Td align='left' bgcolor='#FFFFB'>$type_code $type_name</Td><td align='right' bgcolor='#FFFFB'><INPUT TYPE='button' name='smb' value='เพิ่มแบบ' onclick='location.href=\"?option=building&task=main/model&index=1.1&type=$type_code\"' class='button button4'></td>";
					echo "<td bgcolor='#FFFFB'><a href=?option=building&task=main/model&id=$id&index=2><img src=./images/drop.png border='0'></a></td>";
					echo "<td bgcolor='#FFFFB'><a href=?option=building&task=main/model&id=$id&index=5><img src=./images/edit.png border='0'></a></Td</Tr>";
					
								$sql_3 = "select * from building_model where type_code=$type_code order by type_code ";
								$dbquery_3 = mysqli_query($connect,$sql_3);
								While ($result_3 = mysqli_fetch_array($dbquery_3)) {
										$id = $result_3['id'];
										$model_code= $result_3['model_code'];
										$model_name= $result_3['model_name'];
									echo "<Tr align='center'><td colspan='3'></td><Td align='left'>$model_code $model_name</Td>";
									echo "<td><a href=?option=building&task=main/model&id=$id&index=2.1><img src=./images/drop.png border='0'></a></td>";
									echo "<td><a href=?option=building&task=main/model&id=$id&index=5.1><img src=./images/edit.png border='0'></a></Td></Tr>";
									$X++;
									}
						
					$N++;
					}
	$M++;
	}
echo "</Table>";
} // end if
?>

</script>

${this.title}

Code Editor : model.php