Viewing file:  printSetPsDept.php (4.89 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include_once "template.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../link/keyThai.php";
include_once "../class/clspsdept.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);
$oPSd = new psdept($oC);
$oPSd2 = new psdept($oC);
$maxdocgroup=$oDP->SearchMaxDocGroup();
?>
<html>
<head>
<script language="javascript" src="../source/calendarDateInput.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" align="center">
<tr><td >
<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"><a href="setPsDept.php">กำหนดผู้ใช้ทั่วไปในหน่วยงานรอง</a>
<img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle">ข้อมูลบุคลากรในหน่วยงานรองทั้งหมด
</font></legend>
<form name="ff" target="_blank">
<table width="95%" align="center">
<tr><td align="right"><a href="printSetPsDeptHTML.php" target="_blank"><img src="../picture/print.gif" width="15" height="14" border="0"></a> <a href="printSetPsDeptex.php"><img src="../picture/ico_excel.gif" title="พิมพ์ excel" border="0" style="cursor:pointer;"></a> </td></tr>
<tr align="center">
<td align="center" colspan="2">
<table width="100%" 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>ข้อมูลบุคลากรในหน่วยงานรองทั้งหมด</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="9%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>
คำนำหน้า<br>ชื่อ</b></font></td>
<td width="21%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ชื่อ</b></font></td>
<td width="23%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>นามสกุล</b></font></td>
<td width="21%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>หน่วยงานรอง</b></font></td>
<td width="5%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>แก้ไข</b></font></td>
</tr>
<?
$oDP->SearchBydeptDateDocGroup($maxdocgroup);
while($oDP->GetRecord()){
$i=0;
$oPS->SearchByDeptId2($oDP->deptId);
while($oPS->GetRecord()){
if($oPSd->SearchCountBypersonId($oPS->personId,$maxdocgroup)!=0){
if($i==0){
?>
<tr>
<td colspan="8" height="22" bgcolor="#FFFFFF"> <strong>หน่วยงานหลัก :: <? echo $oDP->deptName; ?></strong></td></tr>
<? }?>
<tr bgcolor=<? echo $GLOBALS["COLOR_BG_TD_11"]; ?>>
<td align="center" bgcolor=<? echo $GLOBALS["COLOR_BG_TD_11"]; ?>><? echo a2th($i+1);?></td>
<td> <? echo GetPrefix($oPS->prefixId); ?></td>
<td height="22" bgcolor=<? echo $GLOBALS["COLOR_BG_TD_11"]; ?>> <? echo $oPS->fName; ?></td>
<td> <? echo $oPS->lName;?></td>
<td><? $oPSd2->SearchBypersonIddeptIddocGroup($oPS->personId,$maxdocgroup);
while($oPSd2->GetRecord()){
echo ' - '.a2th($oPSd2->deptName).'<br>';
}
?></td>
<td align="center"><a href="addSetPsDept.php?ps=<? echo $oPS->personId; ?>&name=<? echo $oPS->fName; ?>&showrep=1"><img src="../picture/textedit3.gif" border="0"></a></td>
</tr>
<? $i++;} }
}?>
</table>
</td></tr>
</table>
</form>
</fieldset>
<table width="90%" border="0" align="center">
<tr>
<td width="76"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2"> <strong>หมายเหตุ
: </strong> </font></td>
<td width="618"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">คลิกที่ <img src="../picture/textedit3.gif" border="0"> เพื่อแก้ไขข้อมูลผู้ใช้ทั่วไปในหน่วยงานรอง</font></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<script>
function printDetailFollowDocDept(p,q){
FileName = "printRepFollowDocDeptDetail.php?DocID="+p+"&DrsID="+q;
var w=600;
var h=600;
strOption = "scrollbars=yes,left=300,top=100,width=" + w + ",height=" + h;
window.open(FileName,"",strOption);
}
</script>
|