Viewing file:  showpstable.php (3.84 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../class/clsUmuser.php";
include_once "../link/keyThai.php";
include_once "getPrefix.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oUs = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_UMS'], $GLOBALS['DBUSER_UMS'], $GLOBALS['DBPASS_UMS']);
$oDp6 = new Department($oC);
$oPS = new Person($oC);
$oUms= new umuser($oUs);
?>
<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">
</head>
<style>
<!--
A:link {text-decoration: none; color: #000000}
A:visited {text-decoration: none; color: #000000}
A:hover {text-decoration: none; font-weight: underline; color: #015181}
-->
</style>
<form name="ff">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td height="30" align="left"><strong><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"];?>">
<img src="../picture/search2.jpg" alt="" border="0" >
ข้อมูลบุคลากร</font></strong></td></tr>
<tr>
<td align="center"><br>
<table width="99%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="silver">
<tr><td colspan="8" align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_9"];?>" height="24"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ข้อมูลบุคลากรใน<? $oDp6->SearchByKey($deptId); if($oDp6->GetRecord()==1){ echo $oDp6->deptName; } ?></b></font></td></tr>
<tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_9"];?>">
<td width="10%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>#</b></font></td>
<td width="15%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>
คำนำหน้า<br>ชื่อ</b></font></td>
<td width="35%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ชื่อ</b></font></td>
<td width="40%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>นามสกุล</b></font></td>
</tr>
<?
$j=0;
$oPS->RSPersonf1dept($deptId);
while($oPS->GetRecord()){
$oUms->SearchByUsPsCode($oPS->personId);
$oUms->GetRecord();
if(($j%2) == 0)
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_5"]."\">";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_11"]."\">";
?>
<td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo a2th($j+1); ?></font></td>
<td align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"> <? echo GetPrefix($oPS->prefixId); ?></font></td>
<td align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"> <? echo $oPS->fName; ?></font></td>
<td align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"> <? echo $oPS->lName; ?></font></td>
</tr>
<? $j++; }
if($j==0){
?>
<tr><td colspan="7" align="center" bgcolor="#FFFFFF"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากรของหน่วยงานนี้ **</font></td></tr>
<? } ?>
</table>
</td>
</tr>
</table>
<input type="hidden" name="DlcID" value="<? echo $DlcID; ?>">
<input type="hidden" name="deptId" value="<? echo $deptId; ?>">
</form>
</body>
</html>
|