Viewing file:  BuildingDetail.php (6.11 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include("./include/FunctionDB.php");
include("./include/Function.php");
ConnectDB();
$sql ="Select * From building_tb Where BuildD_No='$BuildD_No'";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs = mysql_fetch_array($result);
/** โฟลเดอร์ไฟล์เอกสาร */
$Img1 = str_replace( "../", "", $rs['Img1'] );
$doc_path = $Img1."/Man_pic";
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="./css/default.css" rel="stylesheet" type="text/css" />
<title><?=$_Config_sitename;?></title>
<script type="text/javascript" src="./js/utilities.js"></script>
<table width="574" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<th width="574" scope="col"><form action="" method="post" name="form1" id="form1">
<fieldset>
<table width="94%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#DDDDDD" style=" border:0px solid gray"size="12">
<tr bgcolor="#BFD0E6">
<td colspan="3" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#BFD0E6">
<td colspan="3" bgcolor="#FFFFFF"><div align="center"><span class="style1"><font color="#999999"><strong><font color="#000000">รายละเอียด
ข้อมูล สิ่งก่อสร้าง
และ อาคารสถานที่</font></font></font></span></div></td>
</tr>
<tr bgcolor="#eeeeee">
<td colspan="3" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td > <p> </p>
<p> </p></td>
<td ><img src="./Man_pic/<?php echo $rs['Img1']; ?>" width="377" height="251" /></td>
<td > </td>
<td width="1%"> </td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">เลขที่แบบก่อสร้าง</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><? echo $rs[BuildD_ID]?></a></td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#eeeeee">
<td width="18%" bordercolor="#CCCCCC" bgcolor="#FFFFFF">ชื่ออาคาร</a></td>
<td width="75%" bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $rs[Build_name]?></font></td>
<td width="6%" rowspan="9" bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">ประเภทอาคาร</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><?
$code = $rs [Build_type];
$strSQL1 = "SELECT * FROM building_type_tb WHERE code='$code' ";
$result1= mysql_query($strSQL1);
while( $rs1 = mysql_fetch_array($result1))
{
echo"<option value=\"$rs1[code]\" ><b>$rs1[Type_name]</b></option>\n";
}
?></a> </td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">ชื่อย่ออาคาร</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><? echo $rs[Short_name]?></a></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">จำนวนชั้น</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><? echo $rs[Class_unit]?></a></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">จำนวนห้อง</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"><? echo $rs[Room_unit]?></font></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><div align="center" class="style2">
<div align="left"><font face="Tahoma">ปีที่สร้างแล้วเสร็จ</font></div>
</div></td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[BuildD_Yr];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
$m = getThaiSubMonth($month);
echo"$day"." "."$m"." "."$year";
?>
</font></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">พื้นที่</a></td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><? echo $rs[Area]?> ตรม</a></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">ราคา/หน่วย</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> <? echo number_format($rs['BuildD_Pr'],2,'.',','); ?> <font color="#000000">บาท</a></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">แหล่งเงิน</a>
</td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><font color="#003399" size="2" face="Tahoma"> <?php
$MoneyS_C= $rs [MoneyS_C];
$strSQL1 = "SELECT * FROM money_source_tb WHere MoneyS_C='$MoneyS_C ' ";
$result1= mysql_query($strSQL1);
while( $rs1 = mysql_fetch_array($result1))
{
echo"<option value=\"$rs1[MoneyS_C]\" ><b>$rs1[MoneyS_M]</b></option>\n";
}
?></font></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF">รายละเอียด</a></td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"><? echo nl2br($rs[Description])?></a> </td>
<td bordercolor="#FFFFCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#BFD0E6">
<td height="20" colspan="3" bgcolor="#FFFFFF" align="center">
<input type="button" name="Submit2" value=" ปิดหน้าต่าง" onclick="javascript:parent.close();" class="button1" />
</td>
</tr>
</table>
</fieldset>
</form></th>
</tr>
</table>
|