Viewing file:  printRepPersonex.php (6.41 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
set_time_limit(0);
header('Content-type: application/xls');
header('Content-Disposition: attachment; filename="printRepPersonex.xls"');
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);
$oDP2 = new Department($oC);
$oDP3 = new Department($oC);
$oPS = new Person($oC);
$oPS2 = new Person($oC);
$oPS3 = new Person($oC);
$oUms= new umuser($oUs);
$oUms2= new umuser($oUs);
$oUms3= new umuser($oUs);
$oAd = new admin($oC);
$oHr = new hire($oC);
include_once "getPrefix.php";
?>
<title>รายงานข้อมูลบุคลากรทุกหน่วยงาน</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<body>
<div id="tabmargin">
<br>
<table width=730 align="center">
<tr><td height="150">
<table border="0" align="center" width="100%"><tr>
<td align="center">
<table width="99%" border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#DADADA" style="border-collapse:collapse">
<tr><td colspan="7" align="center" height="24"><font face="MS Sans Serif, Tahoma, sans-serif"><b>ข้อมูลบุคลากร</b></font></td></tr>
<tr align="center" >
<td width="6%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>#</b></font></td>
<td width="7%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>
คำนำหน้า<br>ชื่อ</b></font></td>
<td width="16%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>ชื่อ</b></font></td>
<td width="18%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>นามสกุล</b></font></td>
<td width="19%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>ตำแหน่ง<br>ในการเรียงลำดับ</b></font></td>
<td width="19%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>ประเภทบุคลากร</b></font></td>
<td width="14%" align="center"><font face="MS Sans Serif, Tahoma, sans-serif"><b>ชื่อผู้ใช้<br>
(Username)</b></font></td>
</tr>
<? $oDP->RSDeptByMaxdeptDate2();
while($oDP->GetRecord()){
?>
<tr><td colspan="7" height="22"> <strong><? echo $oDP->deptName; ?></strong></td></tr>
<?
$oPS->RSPersonf1dept($oDP->deptId);
$i=0;
while($oPS->GetRecord()){
$oUms->SearchByUsPsCode($oPS->personId);
$oUms->GetRecord();
if(($i%2) == 0)
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_5"]."\">";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_11"]."\">";
?>
<td align="center" height="22"><? echo $i+1; ?></td>
<td align="left"> <? echo GetPrefixshow($oPS->prefixId); ?></td>
<td align="left"> <? echo $oPS->fName; ?></td>
<td align="left"> <? echo $oPS->lName; ?></td>
<td align="left"> <? $oAd->SearchByKey($oPS->adminId); if($oAd->GetRecord()==1){ echo $oAd->adminName; }?></td>
<td align="left"> <? $oHr->SearchByKey($oPS->hireId); if($oHr->GetRecord()==1){ echo $oHr->hireName; }?></td>
<td align="left"> <? echo $oUms->UsLogin; ?></td>
</tr>
<? $i++; }
if($i==0){
?>
<tr><td colspan="7" align="center" height="22"><font face="MS Sans Serif, Tahoma, sans-serif">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? }
$j++;
}
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
if($oPS3->SearchCountByNodeptNamedocGroup($oDP->MaxDate())!='0'){
?>
<tr><td bgcolor="#FFFFFF" colspan="7"> </td></tr>
<tr><td colspan="7" height="22"> <strong>ไม่มีหน่วยงานที่สังกัด</strong></td></tr>
<?
$oPS2->SearchByNodeptNamedocGroup($oDP->MaxDate());
$z=0;
while($oPS2->GetRecord()){
$oUms2->SearchByUsPsCode($oPS2->personId);
$oUms2->GetRecord();
if(($i%2) == 0)
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_5"]."\">";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_11"]."\">";
?>
<td align="center" height="22"><? echo $z+1; ?></td>
<td align="left"> <? echo GetPrefixshow($oPS2->prefixId); ?></td>
<td align="left"> <? echo $oPS2->fName; ?></td>
<td align="left"> <? echo $oPS2->lName; ?></td>
<td align="left"> <? $oAd->SearchByKey($oPS2->adminId); if($oAd->GetRecord()==1){ echo $oAd->adminName; }?></td>
<td align="left"> <? $oHr->SearchByKey($oPS2->hireId); if($oHr->GetRecord()==1){ echo $oHr->hireName; }?></td>
<td align="left"> <? echo $oUms2->UsLogin; ?></td>
</tr>
<? $z++; }
if($z==0){
?>
<tr><td colspan="7" align="center" height="22"><font face="MS Sans Serif, Tahoma, sans-serif">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? } }
//------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
if($j==0){
?>
<tr><td colspan="7" align="center" height="22"><font face="MS Sans Serif, Tahoma, sans-serif">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? } ?>
</table>
</td></tr>
<tr><td> </td></tr>
<tr><td align="center"><input type="button" name="cancel" value="กลับสู่เมนูหลัก" onClick="location.href = '?mm=1'"></td></tr>
</table>
<br>
<br>
<br><br> <br><br>
</td>
</tr>
</table>
</body>
<script language="javascript">
function showDocex(){
document.ff.submit();
}
</script>
|