Viewing file: setPsDeptGroup.php (4.58 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">กำหนดผู้ใช้ทั่วไปในหน่วยงานรองแยกตามหน่วยงาน</font></legend><br> <form name="ff" target="_blank"> <table width="95%" align="center"> <tr align="center"> <td align="center" colspan="2"> <table width="95%" 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()){ ?> <tr> <td colspan="8" height="22" bgcolor="#FFFFFF"> <strong>หน่วยงานหลัก :: <? echo $oDP->deptName; ?></strong></td></tr> <? $i=0; $oPS->SearchByDeptId2($oDP->deptId); while($oPS->GetRecord()){ ?> <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; ?>&showrepedit=1"><img src="../picture/textedit3.gif" border="0"></a></td> </tr> <? $i++; } if($i==0){ ?> <tr><td colspan="6" align="center" bgcolor="#FFFFFF" height="22"><font size="2">** ไม่มีข้อมูลบุคลากร **</font></td></tr> <? } }?> </table> </td></tr> </table> </form> </fieldset> <table width="90%" border="0" align="center"> <tr> <td width="132"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2"> <strong>หมายเหตุ : </strong> </font></td> <td width="970"><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>
|