Viewing file:  printRepPsInDeptHTML.php (3.45 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
set_time_limit(0);
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 "../class/clsadmin.php";
include_once "../class/clshire.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EPERSON'], $GLOBALS['DBUSER_EPERSON'], $GLOBALS['DBPASS_EPERSON']);
$oUs = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_UMS'], $GLOBALS['DBUSER_UMS'], $GLOBALS['DBPASS_UMS']);
$oDP = new Department($oC);
$oPS = new Person($oC);
$oUms= new umuser($oUs);
$oAd = new admin($oC);
$oHr = new hire($oC);
include_once "getPrefix.php";
?>
<title>รายงานข้อมูลบุคลากรในหน่วยงาน<? echo $deptName;?></title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<body>
<table border="0" align="center" width="95%"><tr>
<td align="center">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" style="border-collapse:collapse">
<tr><td colspan="7" align="center" height="24"><font size="2"><b>ข้อมูลบุคลากรในหน่วยงาน<? echo $deptName;?></b></font></td></tr>
<tr align="center">
<td width="6%" height="35" align="center"><font size="2" ><b>#</b></font></td>
<td width="7%" align="center"><font size="2" ><b>
คำนำหน้า<br>ชื่อ</b></font></td>
<td width="16%" align="center"><font size="2" ><b>ชื่อ</b></font></td>
<td width="18%" align="center"><font size="2" ><b>นามสกุล</b></font></td>
<td width="21%" align="center"><font size="2" ><b>ตำแหน่งในการเรียงลำดับ</b></font></td>
<td width="13%" align="center"><font size="2" ><b>ประเภทบุคลากร</b></font></td>
<td width="14%" align="center"><font size="2" ><b>ชื่อผู้ใช้<br>
(Username)</b></font></td>
</tr>
<?
$j=0;
if($deptId=="nodept"){
$oPS->SearchByNodeptNamedocGroup($oDP->MaxDate());
}else{
$oPS->RSPersonf1dept($deptId);
}
while($oPS->GetRecord()){
$oUms->SearchByUsPsCode($oPS->personId);
$oUms->GetRecord();
?>
<tr>
<td align="center"><font size=2><? echo $j+1; ?></font></td>
<td align="left"> <font size=2><? echo GetPrefixshow($oPS->prefixId); ?></font></td>
<td align="left"> <font size=2><? echo $oPS->fName; ?></font></td>
<td align="left"> <font size=2><? echo $oPS->lName; ?></font></td>
<td align="left"> <font size=2><? $oAd->SearchByKey($oPS->adminId); if($oAd->GetRecord()==1){ echo $oAd->adminName; }?></font></td>
<td align="left"> <font size=2><? $oHr->SearchByKey($oPS->hireId); if($oHr->GetRecord()==1){ echo $oHr->hireName; }?></font></td>
<td align="left"> <font size=2><? echo $oUms->UsLogin; ?></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>
<tr><td> </td></tr>
<tr>
<td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">วันที่พิมพ์ : <?php echo date('d-m-Y H:i:s', time());?></font></td>
</tr>
</table>
</body>
|