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

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
require_once "modules/building/time_inc.php";

?>
<script type="text/javascript" src="jquery/jquery-1.5.1.js"></script> 
<script type="text/javascript">
function showResult(str) {
  if (str.length==0) { 
    document.getElementById("livesearch").innerHTML="";
    document.getElementById("livesearch").style.border="0px";
    return;
  }
  if (window.XMLHttpRequest) {
    // code for IE7+, Firefox, Chrome, Opera, Safari
    xmlhttp=new XMLHttpRequest();
  } else {  // code for IE6, IE5
    xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
  xmlhttp.onreadystatechange=function() {
    if (this.readyState==4 && this.status==200) {
      document.getElementById("livesearch").innerHTML=this.responseText;
      document.getElementById("livesearch").style.border="1px solid #A5ACB2";
    }
  }
  xmlhttp.open("GET","modules/building/main/livesearch_2.php?q="+str+"&return_file=report_1_mobile",true);
  xmlhttp.send();
}
</script>
<?php

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

//ส่วนหัว
echo "<br />";
echo "<table width='100%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ข้อมูลสิ่งก่อสร้าง</strong></font></td></tr>";
echo "</table>";

if($index==7){
$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='100%' align='center'>";
echo "<tr><td>";
echo  "<fieldset>";
echo "<legend>&nbsp; <B>แสดงรายละเอียดข้อมูล</B>: &nbsp;</legend>";

echo "<Table width='100%' Border='0' align='center'>";
echo "<Tr><Td  align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?option=building&task=main/report_1_mobile&school_code=$_GET[school_code]&page=$_GET[page]\"'></Td></Tr>";
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='school_code' size='1'>";
echo  "<option  value = ''>เลือก</option>" ;

$sql = "select * from  system_school  where school_type='1' order by school_code";
$dbquery = mysqli_query($connect,$sql);
While ($school_result = mysqli_fetch_array($dbquery)){
			if($school_result['school_code']==$result_ref['school_code']){
			echo  "<option  value ='$school_result[school_code]' selected>$school_result[school_code] $school_result[school_name]</option>" ;
			}
}	
echo "</select>";
echo "</Td></Tr>";

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'>วันเดือนปีที่สร้าง&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'><a href='modules/building/main/pic_show.php?&file=$file_name' target='_blank'><img src=modules/building/upload_files/$file_name border='0' width='400'></a></Td></Tr>";
}

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

//ส่วนแสดงผล
if(!($index==7)){
//ส่วนของการแยกหน้า
if($_REQUEST['school_code']==""){
$sql = "select *,building_main.id from building_main left join system_school on building_main.school_code=system_school.school_code 
 left join building_model on building_main.model_code=building_model.model_code where status='0'";
}
else{
$sql = "select *,building_main.id from building_main left join system_school on building_main.school_code=system_school.school_code 
 left join building_model on building_main.model_code=building_model.model_code where building_main.school_code='$_REQUEST[school_code]' and status='0'";
}
$dbquery= mysqli_query($connect,$sql);
$num_rows=mysqli_num_rows($dbquery);

$pagelen=20; // กำหนดแถวต่อหน้า
$url_link="option=building&task=main/report_1_mobile&school_code=$_REQUEST[school_code]";
$totalpages=ceil($num_rows/$pagelen);

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

if($_REQUEST['page']==""){
$page=$totalpages;
		if($page<2){
		$page=1;
		}
}
else{
		if($totalpages<$_REQUEST['page']){
		$page=$totalpages;
					if($page<1){
					$page=1;
					}
		}
		else{
		$page=$_REQUEST['page'];
		}
}

$start=($page-1)*$pagelen;

if(($totalpages>1) and ($totalpages<6)){
echo "<div align=center>";
echo "หน้า	";
			for($i=1; $i<=$totalpages; $i++)	{
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
echo "</div>";
}			
if($totalpages>5){
			if($page <=3){
			$e_page=5;
			$s_page=1;
			}
			if($page>3){
					if($totalpages-$page>=2){
					$e_page=$page+2;
					$s_page=$page-2;
					}
					else{
					$e_page=$totalpages;
					$s_page=$totalpages-5;
					}
			}
			echo "<div align=center>";
			if($page!=1){
			$f_page1=$page-1;
			echo "<<a href=$PHP_SELF?$url_link&page=1>แรก </a>";
			echo "<<<a href=$PHP_SELF?$url_link&page=$f_page1>ก่อน </a>";
			}
			else {
			echo "หน้า	";
			}					
			for($i=$s_page; $i<=$e_page; $i++){
					if($i==$page){
					echo "[<b><font size=+1 color=#990000>$i</font></b>]";
					}
					else {
					echo "<a href=$PHP_SELF?$url_link&page=$i>[$i]</a>";
					}
			}
			if($page<$totalpages)	{
			$f_page2=$page+1;
			echo "<a href=$PHP_SELF?$url_link&page=$f_page2> ถัด</a>>>";
			echo "<a href=$PHP_SELF?$url_link&page=$totalpages> ท้าย</a>>";
			}
			echo " <select onchange=\"location.href=this.options[this.selectedIndex].value;\" size=\"1\" name=\"select\">";
			echo "<option  value=\"\">หน้า</option>";
				for($p=1;$p<=$totalpages;$p++){
				echo "<option  value=\"?$url_link&page=$p\">$p</option>";
				}
			echo "</select>";
echo "</div>";  
}					
//จบแยกหน้า

echo "<form id='frm1' name='frm1'>";
echo "<table width='100%' align='center'>";
echo "<tr><td colspan='2' align='right'>";
		?>
		ค้นหาโรงเรียน <input type="text" size="15" onkeyup="showResult(this.value)">
		<div id="livesearch"></div>
		<?php
echo "</td></tr>";
echo "<tr><Td align='left'></Td><td align='right'>";

echo "เลือกโรงเรียน&nbsp";
echo "<Select  name='school_code' size='1' onchange='goto_display(1)'>";
echo  '<option value ="" >ทั้งหมด</option>' ;
$sql = "select * from  system_school";
$dbquery = mysqli_query($connect,$sql);
While ($result = mysqli_fetch_array($dbquery)){
			if($_REQUEST['school_code']==""){
			echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
			}
			else{
					if($_REQUEST['school_code']==$result['school_code']){
					echo "<option value=$result[school_code] selected>$result[school_code] $result[school_name]</option>"; 
					}
					else{
					echo "<option value=$result[school_code]>$result[school_code] $result[school_name]</option>"; 
					}
			}		
}
	echo "</select>";
echo "</td></tr></table>";
echo "</form>";

echo  "<table width='100%' border='1' align='center' style='border-collapse: collapse'>";
if($_REQUEST['school_code']==""){
$sql = "select *,building_main.id from building_main left join system_school on building_main.school_code=system_school.school_code 
 left join building_model on building_main.model_code=building_model.model_code where status='0'
order by building_main.id limit $start,$pagelen";
}
else{
$sql = "select *,building_main.id from building_main left join system_school on building_main.school_code=system_school.school_code 
 left join building_model on building_main.model_code=building_model.model_code where building_main.school_code='$_REQUEST[school_code]' and status='0'
order by building_main.id limit $start,$pagelen";
}

$dbquery = mysqli_query($connect,$sql);
echo "<Tr bgcolor='#ddd' align='center' height='30' class='subHeader'><Td>ที่</Td><Td>โรงเรียน</Td><Td>แบบ</Td><td>รายละเอียด</td></Tr>";

$N=(($page-1)*$pagelen)+1;  //*เกี่ยวข้องกับการแยกหน้า
$M=1;
While ($result = mysqli_fetch_array($dbquery))
	{
		$id = $result['id'];
		$school_code= $result['school_code'];
		$school_name= $result['school_name'];
		$model_code= $result['model_code'];
		$model_name= $result['model_name'];
		$type_code= $result['type_code'];
		
		if(($N%2) == 0)
		$color="#FFFFC";
		else 	$color="#FFFFFF";
		
		echo "<Tr bgcolor='$color' align='center' valign='top'><Td >$N</Td><Td align='left'>$school_code $school_name</Td><Td align='left'>$model_code $model_name</Td>"; 
		echo "<td><a href=?option=building&task=main/report_1_mobile&id=$id&index=7&school_code=$_REQUEST[school_code]&page=$page><img src=./images/browse.png border='0'></a></td>";
		echo "</Tr>";
$M++;
$N++;
	}
}
?>

${this.title}

Code Editor : report_1_mobile.php