Viewing file:  homeDistrictTable.php (5.5 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("../configuration.php");
include_once "../class/clsDistrictMIS.php";
include_once "../class/clsAmphurMIS.php";
include_once "../class/clsProvinceMIS.php";
$conn = new Connection();
$oDt = new District();
$oAm = new Amphur();
$oPv = new Province();
?>
<html>
<head>
<title>ตารางตำบล อำเภอและจังหวัด</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<style>
<!--
A:link {text-decoration: none }
A:visited {text-decoration: none}
A:hover {text-decoration: none; font-weight: underline}
-->
</style>
<!---------------------------------------Begin JavaScript---------------------------------------->
<script language="JavaScript">
function ReturnValue(homeDistrictId,homeDistrict,homeAmphurId,homeAmphur,homeProvinceId,homeProvince)
{
window.opener.document.pc.districtId.value = homeDistrictId;
window.opener.document.pc.districtName.value = homeDistrict;
window.opener.document.pc.amphurId.value = homeAmphurId;
window.opener.document.pc.amphurName.value = homeAmphur;
window.opener.document.pc.provinceId.value = homeProvinceId;
window.opener.document.pc.provinceName.value = homeProvince;
window.close();
}
</script>
</head>
<body bgcolor="#FFFFFF">
<form action="<?php echo $PHP_SELF;?>" method="post" name="frm">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td colspan="4" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="2"><b>ชื่อจังหวัด : </b>
<input type="text" name="provinceName" size="10">
<b>ชื่ออำเภอ : </b>
<input type="text" name="amphurName" size="10">
<b>ชื่อตำบล : </b></font>
<input type="text" name="districtName" size="10">
<input type="submit" name="search" value="ค้นหา"></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr bgcolor="#0066CC">
<td width="10%" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="2" color="#FFFFFF"><b>ลำดับที่</b></font></td>
<td width="30%" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="2" color="#FFFFFF"><b>ชื่อจังหวัด</b></font></td>
<td width="30%" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="2" color="#FFFFFF"><b>ชื่ออำเภอ</b></font></td>
<td width="30%" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="2" color="#FFFFFF"><b>ชื่อตำบล</b></font></td>
</tr>
<?php
$oDt->RSDistrictByPvNameAndApNameAndDtName($provinceName, $amphurName, $districtName);
$numRow = $oDt->NumRow();
$page_size = 10;
$total_page = (int)($numRow/$page_size);
if(($numRow%$page_size) != 0)
$total_page++;
if(isset($page_id))
$start = $page_size*($page_id-1);
else {
$page_id = 1;
$start = 0;
}
$i = 0;
$oDt->RSDistrictByPvNameAndApNameAndDtNameLimit($provinceName, $amphurName, $districtName, $start, $page_size);
while($oDt->GetRecord()) {
$oAm->SearchByKey($oDt->amphurId);
$oAm->GetRecord();
$oPv->SearchByKey($oDt->provinceId);
$oPv->GetRecord();
?>
<tr bgcolor="#FFFFFF">
<td align="center"><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oDt->districtId;?>","<?php echo $oDt->districtName;?>","<?php echo $oAm->amphurId;?>","<?php echo $oAm->amphurName;?>","<?php echo $oPv->provinceId;?>","<?php echo $oPv->provinceName;?>")'><?php echo $start+$i+1;?></font></td>
<td><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oDt->districtId;?>","<?php echo $oDt->districtName;?>","<?php echo $oAm->amphurId;?>","<?php echo $oAm->amphurName;?>","<?php echo $oPv->provinceId;?>","<?php echo $oPv->provinceName;?>")'><?php echo $oPv->provinceName;?></font></td>
<td><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oDt->districtId;?>","<?php echo $oDt->districtName;?>","<?php echo $oAm->amphurId;?>","<?php echo $oAm->amphurName;?>","<?php echo $oPv->provinceId;?>","<?php echo $oPv->provinceName;?>")'><?php echo $oAm->amphurName;?></font></td>
<td><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oDt->districtId;?>","<?php echo $oDt->districtName;?>","<?php echo $oAm->amphurId;?>","<?php echo $oAm->amphurName;?>","<?php echo $oPv->provinceId;?>","<?php echo $oPv->provinceName;?>")'><?php echo $oDt->districtName;?></font></td>
</tr>
<?php
$i++;
}
if($i == 0) {
?>
<tr>
<td colspan="4" align="center" bgcolor="#FFFFFF"><font size="2" color="#FF0000">** ไม่ปรากฏรายการดังกล่าวในฐานข้อมูล **</font></td>
</tr>
<?php
}
?>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr bgcolor="silver">
<td width="80%"><font size="2" face="MS Sans Serif" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">หน้า->
<?php
for ($num=1; $num<=$total_page; $num++) {
if($num == $page_id)
echo $num." ";
else {
?>
<a href="homeDistrictTable.php?page_id=<?php echo $num;?>&provinceName=<?php echo $provinceName;?>&amphurName=<?php echo $amphurName;?>&districtName=<?php echo $districtName;?>"><?php echo '[ '.$num.' ]';?></a>
<?php
}
}
?>
</font></td>
<td align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">รวม <?php echo $numRow;?> รายการ</font></td>
</tr>
<tr>
<td align="center" colspan="4"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><a href="#" onClick="window.close()">[ปิดหน้าต่างนี้]</a></font></td>
</tr>
</table>
</form>
</body>
</html>
<?php
$oDt->Destroy();
$oAm->Destroy();
$oPv->Destroy();
$conn->Disconnect();
?>
|