Gecko [ 122.154.134.11 ]

Name	Size	Permission
building_show.php	4.58 KB	-rw-r--r--
livesearch1.php	787 B	-rw-r--r--
livesearch_202.php	5.82 KB	-rw-r--r--
livesearch_2021.php	4.86 KB	-rw-r--r--
livesearch_204.php	11.9 KB	-rw-r--r--
livesearch_2041.php	9.97 KB	-rw-r--r--
livesearch_2044.php	11.8 KB	-rw-r--r--
livesearch_20441.php	9.83 KB	-rw-r--r--
livesearch_206.php	11.79 KB	-rw-r--r--
livesearch_2061.php	9.79 KB	-rw-r--r--
livesearch_301.php	3.16 KB	-rw-r--r--
livesearch_302.php	3.36 KB	-rw-r--r--
livesearch_ach.php	7.15 KB	-rw-r--r--
livesearch_ach_2.php	7.85 KB	-rw-r--r--
livesearch_allperson.php	1.59 KB	-rw-r--r--
livesearch_amphoe_school.php	1.53 KB	-rw-r--r--
livesearch_budget.php	10.99 KB	-rw-r--r--
livesearch_building.php	3.14 KB	-rw-r--r--
livesearch_chart2.php	625 B	-rw-r--r--
livesearch_chart3.php	872 B	-rw-r--r--
livesearch_chart3_2.php	987 B	-rw-r--r--
livesearch_chart3_3.php	1.37 KB	-rw-r--r--
livesearch_chart3_4.php	847 B	-rw-r--r--
livesearch_chart3_5.php	883 B	-rw-r--r--
livesearch_chart3_6.php	879 B	-rw-r--r--
livesearch_chart3_7.php	922 B	-rw-r--r--
livesearch_chart4.php	607 B	-rw-r--r--
livesearch_chart4_2.php	1.05 KB	-rw-r--r--
livesearch_computer.php	4.46 KB	-rw-r--r--
livesearch_g_ach_2.php	8.67 KB	-rw-r--r--
livesearch_health1.php	9.7 KB	-rw-r--r--
livesearch_health2.php	8.81 KB	-rw-r--r--
livesearch_khetopportunity.php	3.74 KB	-rw-r--r--
livesearch_khetopportunity2.ph...	3.8 KB	-rw-r--r--
livesearch_khetopportunity3.ph...	3.74 KB	-rw-r--r--
livesearch_khetperson.php	1.44 KB	-rw-r--r--
livesearch_nt.php	2.68 KB	-rw-r--r--
livesearch_nt2.php	3.05 KB	-rw-r--r--
livesearch_nt3.php	5.26 KB	-rw-r--r--
livesearch_opportunity.php	8 KB	-rw-r--r--
livesearch_opportunity2.php	8 KB	-rw-r--r--
livesearch_opportunity3.php	8.01 KB	-rw-r--r--
livesearch_plan.php	4.3 KB	-rw-r--r--
livesearch_plc.php	5.71 KB	-rw-r--r--
livesearch_plc2.php	3.15 KB	-rw-r--r--
livesearch_read.php	7.91 KB	-rw-r--r--
livesearch_sch_person.php	1.51 KB	-rw-r--r--
livesearch_school.php	2.19 KB	-rw-r--r--
livesearch_school_group.php	2.64 KB	-rw-r--r--
livesearch_school_group2.php	2.3 KB	-rw-r--r--
livesearch_small_school.php	1.95 KB	-rw-r--r--
livesearch_smss_std.php	5.28 KB	-rw-r--r--
livesearch_std.php	11.24 KB	-rw-r--r--
livesearch_std2.php	11.05 KB	-rw-r--r--
livesearch_std3.php	7.02 KB	-rw-r--r--
livesearch_std4.php	6.91 KB	-rw-r--r--
livesearch_std_check.php	3.31 KB	-rw-r--r--
livesearch_std_check2.php	3.28 KB	-rw-r--r--
livesearch_student.php	3.96 KB	-rw-r--r--
livesearch_student2.php	4.17 KB	-rw-r--r--
livesearch_student3.php	10.44 KB	-rw-r--r--
livesearch_student_list.php	5.22 KB	-rw-r--r--
livesearch_supervision.php	13.24 KB	-rw-r--r--
permission.php	11.13 KB	-rw-r--r--
school_report_1.php	52.88 KB	-rw-r--r--
school_report_2.php	36.59 KB	-rw-r--r--

Code Editor : building_show.php

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}

require_once("../../../amssplus_connect.php");
require_once "../../../modules/building/time_inc.php";	
require_once("../../../mainfile.php");

echo "<br />";
$sql = "select * from building_main, building_model, building_type, building_category where building_main.model_code=building_model.model_code and building_model.type_code=building_type.type_code and building_type.cate_code=building_category.cate_code and building_main.id='$_GET[id]' ";
$dbquery = mysqli_query($connect,$sql);
$result_ref = mysqli_fetch_array($dbquery);

echo "<Table width='95%' align='center'>";
echo "<tr><td>";
echo  "<fieldset>";
echo "<legend>&nbsp; <B>แสดงรายละเอียดข้อมูล</B>: &nbsp;</legend>";

echo "<Table width='100%' Border='0' align='center'>";
echo "</table>";

echo "<Table width='100%' Border='0' align='center'>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ประภทสิ่งก่อสร้าง&nbsp;</Td><Td>";
echo "<Select  name='building_category' id='building_category' size='1' onchange='e_show()'>";
echo  "<option  value = ''>เลือก</option>" ;

$sql = "select * from building_category order by cate_code";
$dbquery = mysqli_query($connect,$sql);
While ($cate_result = mysqli_fetch_array($dbquery)){
		if($cate_result['cate_code']==$result_ref['cate_code']){
		echo  "<option  value ='$cate_result[cate_code]' selected>$cate_result[cate_code] $cate_result[cate_name]</option>" ;
		}
}	
echo "</select>";
echo "</Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>ชนิดสิ่งก่อสร้าง&nbsp;</Td><Td>";
echo "<Select  name='building_type' id='building_type' size='1'>";
echo  "<option  value = ''>เลือก</option>" ;

$sql = "select * from building_type where cate_code='$result_ref[cate_code]' order by type_code";
$dbquery = mysqli_query($connect,$sql);
While ($type_result = mysqli_fetch_array($dbquery)){
		if($type_result['type_code']==$result_ref['type_code']){
		echo  "<option  value ='$type_result[type_code]' selected>$type_result[type_code] $type_result[type_name]</option>" ;
		}
}	
echo "</select>";
echo "</Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>แบบสิ่งก่อสร้าง&nbsp;</Td><Td>";
echo "<Select  name='building_model' id='building_model' size='1'>";
echo  "<option  value = ''>เลือก</option>" ;

$sql = "select * from building_model  where type_code ='$result_ref[type_code]' order by building_model.model_code";
$dbquery = mysqli_query($connect,$sql);
While ($model_result = mysqli_fetch_array($dbquery)){
		if($model_result['model_code']==$result_ref['model_code']){
		echo  "<option  value ='$model_result[model_code]' selected>$model_result[model_code] $model_result[model_name]</option>" ;
		}
}	
echo "</select>";
echo "</Td></Tr>";

echo "<Tr align='left'><Td ></Td><Td align='right'>";
echo "จำนวนห้อง&nbsp;&nbsp;";
echo "</Td><Td>";
echo "<Input Type='Text' Name='room'  Size='4' value='$result_ref[room]' readonly>";
echo "</Td></Tr>";
$build_date=$result_ref['build_date'];

if($build_date=="0001-01-01"){
$build_date="";;
}
else{
$build_date=getDateThai($build_date);
}

echo "<Tr align='left'><Td ></Td><Td align='right'>";
echo "ปีงบประมาณที่ได้รับงบ&nbsp;&nbsp;";
echo "</Td><Td>";
echo "<Input Type='Text' Name='get_year'  Size='4'  value='$result_ref[get_year]' readonly>";
echo "</Td></Tr>";

echo "<Tr align='left'><Td></Td><Td align='right'>วันเดือนปีที่สร้าง&nbsp;&nbsp;</Td>";
echo "<Td align='left'>";
echo "<Input Type='Text' Name='build_date' Size='10' value='$build_date' readonly>";
echo "</Td></Tr>";
echo "<Tr align='left'><Td ></Td><Td align='right'>ข้อมูลเพิ่มเติม&nbsp;&nbsp;</Td><Td><Input Type='Text'  Name='other' Size='50' value='$result_ref[other]' readonly></Td></Tr>";

$sql = "select *  from building_file where building_id='$_GET[id]' order by id desc";
$dbquery = mysqli_query($connect,$sql);
$N=1;
While ($result = mysqli_fetch_array($dbquery)){
$file_name=$result['file_name'];  
		$rec_date=$result['rec_date'];
		$rec_date=thai_date_3($rec_date);
echo "<Tr align='left'><Td ></Td><Td align='right'>$rec_date</Td><Td align='left'><img src='../../../modules/building/upload_files/$file_name' border='0' width='500'></Td></Tr>";

}

echo "<Br>";
echo "</Table>";
echo "<Br>";
echo "</fieldset>";
echo "</td></tr>";
echo "</table>";
?>

${this.title}

Code Editor : building_show.php