<?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>
<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="100%">
      <tr>
    <td align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"]; ?>"><strong>รายงานหน้าที่งานสารบรรณของบุคคลทุกหน่วยงาน  สรุป ณ วันที่&nbsp;<? 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>หน่วยงาน ::&nbsp;</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>สถานะการใช้งาน ::&nbsp;</strong>
                <? if($oDlc1->SearchDeptconfirm($oDP->deptId)=="Y"){  echo "ยืนยันการใช้งานแล้ว"; }else{  echo "ยังไม่ยืนยันการใช้งาน"; } ?>
                </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="25%" align="center"><strong>ตำแหน่ง</strong></td>
                <td  align="center" ><strong>บุคลากร</strong><strong></strong></td>
                <td width="10%" align="center"><strong>เสนอเซ็น</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>
              </tr>
              <? 
                    $oDlc->SearchByDeptMaxDocGroup($oDP->deptId,$MaxDocGroup);
                    $i=0;
                     while($oDlc->GetRecord()){
                ?>
              <tr > 
                <td align="center" height="22"><? echo a2th($oDlc->DlcSeq); ?></td>
                <td align="left" ><? $oDlp->SearchByKey($oDlc->DlpID); $oDlp->GetRecord(); echo "&nbsp;$oDlc->DlpID&nbsp;".$oDlp->DlpName; ?></td>
                <? $oPS->SearchByKey($oDlc->personId);  $oPS->GetRecord();?>
                <td width="25%" align="left"><? echo "&nbsp;$oDlc->personId&nbsp;".GetPrefix($oPS->prefixId).$oPS->fName."&nbsp;".$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>
              </tr>
              <?  $i++;   } //end loop lineconfig
                   if($i=="0"){ ?>
                    <tr><td align="center" colspan="8" 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></table>
</body>
</html>

<script language="javascript">
function showdept(){
    document.ff.submit();
}
</script>