Viewing file:  printRepPerson.php (5.81 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
set_time_limit(0);
include_once "template.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../link/keyThai.php";
include_once "getPrefix.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oDP3 = new Department($oC);
$oPS = new person($oC);
$oPS2 = new person($oC);
$oPS3 = new person($oC);
$oPS4 = new person($oC);
$maxdate = $oDP3->MaxDate();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<br>
<table width=730 align="center">
<tr><td height="150">
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="?mm=1">จัดการข้อมูลบุคลากรและโครงสร้าง</a>
<img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle">รายงานข้อมูลบุคลากรในระบบสารบรรณทุกหน่วยงาน
</font></legend>
<form name="ff" method="post" action="printRepPersonex.php">
<table border="0" width="100%"><tr><td align="right"> </td></tr></table>
<table border="0" align="center" width="100%">
<tr>
<td align="center">
<table border="0" width="75%"><tr><td align="right"><a href="printRepPersonHTML.php" target="_blank"><img src="../picture/print.gif" width="15" height="14" border="0"></a> <a href="printRepPersonex.php" target="_blank"><img src="../picture/ico_excel.gif" title="พิมพ์ excel" border="0" style="cursor:pointer;"></a> </td></tr></table>
<table width="75%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="silver">
<tr><td colspan="4" align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_9"];?>" height="24"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ข้อมูลบุคลากร</b></font></td></tr>
<tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_9"];?>">
<td width="5%" height="35" 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>
คำนำหน้าชื่อ</b></font></td>
<td width="25%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ชื่อ</b></font></td>
<td width="30%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>นามสกุล</b></font></td>
</tr>
<? $oDP->RSDeptByMaxdeptDate();
while($oDP->GetRecord()){
?>
<tr><td colspan="4" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_12"]; ?>" height="22"> <strong><? echo $oDP->deptName; ?></strong></td></tr>
<?
$oPS->RSPersonf1dept2($oDP->deptId);
$i=0;
while($oPS->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"><? echo a2th($i+1); ?></td>
<td align="left"> <? echo GetPrefix($oPS->prefixId); ?></td>
<td align="left"> <? echo $oPS->fName; ?></td>
<td align="left"> <? echo $oPS->lName; ?></td>
</tr>
<? $i++; }
if($i==0){
?>
<tr><td colspan="4" align="center" bgcolor="#FFFFFF" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? }
$j++;
}
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
if($oPS3->SearchCountByNodeptNamedocGroup($oDP->MaxDate())!='0'){
?>
<tr><td bgcolor="#FFFFFF" colspan="4"> </td></tr>
<tr><td colspan="4" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_12"]; ?>" height="22"> <strong>ไม่มีหน่วยงานที่สังกัด</strong></td></tr>
<?
$oPS2->SearchByNodeptNamedocGroup($oDP->MaxDate());
$z=0;
while($oPS2->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 a2th($z+1); ?></td>
<td align="left"> <? echo GetPrefix($oPS2->prefixId); ?></td>
<td align="left"> <? echo $oPS2->fName; ?></td>
<td align="left"> <? echo $oPS2->lName; ?></td>
</tr>
<? $z++; }
if($z==0){
?>
<tr><td colspan="4" align="center" bgcolor="#FFFFFF" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? } }
//------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
?>
<?
if($j==0){
?>
<tr><td colspan="4" align="center" bgcolor="#FFFFFF" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากร **</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>
</form><br>
</fieldset>
<br>
<br>
<br><br> <br><br>
</td>
</tr>
</table>
</body>
</html>
<script language="javascript">
function showDocex(){
document.ff.submit();
}
</script>
|