Viewing file: showPsWorkTable.php (2.54 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php 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/clsDocLinePosition.php"; include_once "../class/clsDocLineConfig.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); $oDlc = new DocLineConfig($oC); $oDlc1 = new DocLineConfig($oC); $oDlp = new docLinePosition($oC); $MaxDocGroup=$oDP->SearchMaxDocGroup();
?> <html> <head> <title>รายชื่อผู้บังคับบัญชาที่ปฏิบัติงานอยู่</title> <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 border="0" align="center" width="95%"> <tr> <td align="center" height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>"><strong>รายชื่อผู้บังคับบัญชาที่ปฏิบัติงานอยู่<br>สรุป ณ วันที่ : <?php echo abbreDate2((date('Y')+543).'-'.date('m').'-'.date('d')).' '.a2th(date('H:i:s'));?></strong></font></td> </tr> <tr><td> </td></tr> <? $oDP->SearchBydeptDateDocGroup($MaxDocGroup); while($oDP->GetRecord()){ ?> <tr><td height="22" align="left" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_16"]; ?>"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"];?>"><strong><? echo $oDP->deptName; ?></font></td></tr> <? $oDlc->SearchByDlcIDSign($oDP->deptId,$MaxDocGroup); $i=0; while($oDlc->GetRecord()){ $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); $oPS->SearchByKey($oDlc->personId); $oPS->GetRecord(); ?> <tr><td height="22"><? echo " ".$oDlp->DlpName; ?> :: <? echo GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName; ?></td></tr>
<? $i++; } //end loop lineconfig if($i=="0"){ ?> <tr><td align="left" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2"> ยังไม่มีการกำหนดหน้าที่งานสารบรรณของบุคคล</font></td></tr> <? } // if no lineconfig ?> <? } //loop show each dept?> <tr><td align="center" height="22"><a href="#" onClick="window.close()"><font size="1" face="Microsoft Sans Serif"><br>[ปิดหน้าต่าง]</font></a></td></tr> </table> </body> </html>
|