Viewing file: showPsWorkTable.php (4.44 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();
?> <table border="0" align="center" width="102%"> <tr> <td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>"><strong>รายงานหน้าที่งานสารบรรณของบุคคลทุกหน่วยงาน สรุป ณ วันที่ <? echo abbreDate(splitDateDb2(getNowDateTh())); ?></strong></font></td> </tr> <tr><td align="center"> <br> <? $oDP->SearchBydeptDateDocGroup($MaxDocGroup); while($oDP->GetRecord()){ ?> <table width="95%" height="22" border="0" align="center" cellpadding="0" cellspacing="0"> <tr><td colspan="8" height="25" align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"];?>"><strong>หน่วยงาน :: </strong><? echo $oDP->deptName; ?></font></td></tr> <tr><td colspan="8" height="25" align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"];?>"><strong>สถานะการใช้งาน :: </strong> <? if($oDlc1->SearchDeptconfirm($oDP->deptId)=="Y"){ echo "ยืนยันการใช้งานแล้ว"; }else{ echo "<font color=\"#FF0000\">ยังไม่ยืนยันการใช้งาน</font>"; } ?> </font></td></tr> </table> <table width="95%" height="22" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#DADADA" style="border-collapse:collapse"> <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_15'];?>"> <td width="6%" align="center"><strong>ลำดับ</strong></td> <td width="21%" align="center"><strong>ตำแหน่ง</strong></td> <td align="center" ><strong>บุคลากร</strong><strong></strong></td> <td width="10%" align="center"><strong>เสนอ<br>ลงนาม</strong></td> <td width="8%" align="center"><strong>ลงนาม</strong></td> <td width="8%" align="center"><strong>ส่งผ่าน</strong></td> <td width="8%" align="center"><strong>ส่ง</strong></td> <td width="10%" align="center"><strong>ดู<br> หนังสือ</strong></td> <td width="8%" align="center"><strong>Active</strong></td> </tr> <? $oDlc->SearchByDeptMaxDocGroup($oDP->deptId,$MaxDocGroup); $i=0; while($oDlc->GetRecord()){ ?> <tr > <td align="center" height="22"><? echo a2th($oDlc->DlcSeq); ?><? //echo "DlcID=".$oDlc->DlcID; ?></td> <td align="left" ><? $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); echo " ".$oDlp->DlpName; ?></td> <? $oPS->SearchByKey($oDlc->personId); $oPS->GetRecord();?> <td width="21%" align="left"><? echo " ".GetPrefix($oPS->prefixId).$oPS->fName." ".$oPS->lName; ?></td> <td align="center"><? if($oDlc->DlcPropose=="Y"){ ?><img src="../picture/apply.gif" border="0" align="absmiddle"><? }?></td> <td align="center"><? if($oDlc->DlcSign=="Y"){ ?><img src="../picture/apply.gif" border="0" align="absmiddle"><? }?></td> <td align="center"><? if($oDlc->DlcByPass=="Y"){ ?> <img src="../picture/apply.gif" border="0" align="absmiddle"><? }?></td> <td align="center"><? if($oDlc->DlcSend=="Y"){ ?><img src="../picture/apply.gif" border="0" align="absmiddle"><? }?></td> <td align="center"><? if($oDlc->DlcView=="Y"){ ?><img src="../picture/apply.gif" border="0" align="absmiddle"><? }?></td> <td align="center"><? if($oDlc->DlcActive=="Y"){ ?><img src="../picture/apply.gif" border="0" align="absmiddle"><? }?></td> </tr> <? $i++; } //end loop lineconfig if($i=="0"){ ?> <tr><td align="center" colspan="9" height="25"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">ยังไม่มีการกำหนดหน้าที่งานสารบรรณของบุคคล</font></td></tr> <? } // if no lineconfig ?> </table><br> <? } //loop show each dept?> <br> </td></tr> <tr><td align="center"><input type="button" name="cancel" value="กลับหน้าหลัก" onClick="location.href = 'searchPrintDocLineConfig.php'"></td></tr> </table>
|