Viewing file: epTableCT.php (5.08 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "../class/clsrg_ExternalPlace.php";
include_once "../class/clsrg_MainExternalPlace.php";
include_once "../class/clsrg_SubExternalPlace.php";
$conn = new Connection();
$oEp = new rg_ExternalPlace();
$oMep = new rg_MainExternalPlace();
$oSep = new rg_SubExternalPlace();
?>
<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(epMepId, epSepId, mepName, sepName)
{
window.opener.document.pc.ctEpMepId.value = epMepId;
window.opener.document.pc.ctEpSepId.value = epSepId;
window.opener.document.pc.mepName.value = mepName;
window.opener.document.pc.sepName.value = sepName;
window.close();
}
</script>
</head>
<body bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td><font size="2"><b>สถานที่ฝึกงานหลัก</b></font>
<select name="epMepIdSearch" onChange="location.href = '<?php echo $_SERVER['PHP_SELF']?>?epMepIdSearch='+encodeURI(options[selectedIndex].value)">
<option value="">--เลือกสถานที่ฝึกงานหลัก--</option>
<?php
$oEp->RSrg_ExternalPlaceGroupMepId();
while($oEp->GetRecord()) {
$oMep->SearchByKey($oEp->epMepId);
$oMep->GetRecord();
?>
<option value="<?php echo $oEp->epMepId;?>" <?php echo ($oEp->epMepId==$epMepIdSearch) ? 'selected' : '';?>><?php echo $oMep->mepName;?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td><font size="2"><b>สถานที่ฝึกงานย่อย</b></font>
<select name="epSepIdSearch" onChange="location.href = '<?php echo $_SERVER['PHP_SELF']?>?epSepIdSearch='+encodeURI(options[selectedIndex].value)">
<option value="">---เลือกสถานที่ฝึกงานย่อย---</option>
<?php
$oEp->RSrg_ExternalPlaceGroupSepId();
while($oEp->GetRecord()) {
$oSep->SearchByKey($oEp->epSepId);
$oSep->GetRecord();
?>
<option value="<?php echo $oEp->epSepId;?>" <?php echo ($oEp->epSepId==$epSepIdSearch) ? 'selected' : '';?>><?php echo $oSep->sepName;?></option>
<?php
}
?>
</select></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="silver">
<tr bgcolor="#0066CC">
<td width="12%" height="22" align="center"><font size="2" color="#FFFFFF"><b>ลำดับที่</b></font></td>
<td width="58%" align="center"><font size="2" color="#FFFFFF"><b>สถานที่ฝึกงานหลัก</b></font></td>
<td width="30%" align="center"><font size="2" color="#FFFFFF"><b>สถานที่ฝึกงานย่อย</b></font></td>
</tr>
<?php
if(!$epMepIdSearch && !$epSepIdSearch)
$oEp->RSrg_ExternalPlace();
else
$oEp->RSrg_ExternalPlaceByMepIdOrSepId($epMepIdSearch, $epSepIdSearch);
$numRow = $oEp->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;
if(!$epMepIdSearch && !$epSepIdSearch)
$oEp->RSrg_ExternalPlaceOrderMepNameSepNameLimit($start, $page_size);
else
$oEp->RSrg_ExternalPlaceByMepIdOrSepIdOrderMepNameSepNameLimit($epMepIdSearch, $epSepIdSearch, $start, $page_size);
while($oEp->GetRecord()) {
$oMep->SearchByKey($oEp->epMepId);
$oMep->GetRecord();
$oSep->SearchByKey($oEp->epSepId);
$oSep->GetRecord();
?>
<tr bgcolor="#FFFFFF">
<td height="22" align="center"><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oEp->epMepId;?>","<?php echo $oEp->epSepId;?>","<?php echo $oMep->mepName;?>","<?php echo $oSep->sepName;?>")'><?php echo $start+$i+1;?></font></td>
<td><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oEp->epMepId;?>","<?php echo $oEp->epSepId;?>","<?php echo $oMep->mepName;?>","<?php echo $oSep->sepName;?>")'><?php echo $oMep->mepName;?></font></td>
<td><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oEp->epMepId;?>","<?php echo $oEp->epSepId;?>","<?php echo $oMep->mepName;?>","<?php echo $oSep->sepName;?>")'><?php echo $oSep->sepName;?></font></td>
</tr>
<?php
$i++;
}
if($i == 0) {
?>
<tr bgcolor="#FFFFFF">
<td colspan="3" align="center"><font size="2" color="#FF0000">** ไม่ปรากฏรายการดังกล่าวในฐานข้อมูล **</font></td>
</tr>
<?php
}
?>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="silver">
<tr>
<td><font size="2">หน้า->
<?php
for ($num=1; $num<=$total_page; $num++) {
if($num == $page_id)
echo $num." ";
else {
?>
<a href="epTableCT.php?page_id=<?php echo $num;?>&epMepIdSearch=<?php echo $epMepIdSearch;?>&epSepIdSearch=<?php echo $epSepIdSearch;?>"><?php echo '[ '.$num.' ]';?></a>
<?php
}
}
?>
</font></td>
<td align="right"><font size="2">รวม <?php echo $numRow;?> รายการ</font></td>
</tr>
</table>
</body>
</html>
|