<?php
include_once("../../class/clsConnection.php");
include_once("../../class/clsDB.php");
include_once "../global.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";

$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);

$maxdocgroup=$oDP->SearchMaxDocGroup();

        $oDP->SearchBydeptDateDocGroup($maxdocgroup);
        while($oDP->GetRecord()){
            if($deptId[$oDP->deptId]==$oDP->deptId){
                $oPSd->SearchBypersonIddeptId($ps,$oDP->deptId,$maxdocgroup);
                if($oPSd->GetRecord()==0){
                    //echo 'add<br>';
                    $oPSd->AddNew();
                    $oPSd->psdID=$oPSd->GetNextCode();
                    $oPSd->personId=$ps;
                    $oPSd->deptId=$oDP->deptId;
                    $oPSd->docGroup=$maxdocgroup;
                    $oPSd->Save();                
                }else{
                    //echo 'edit<br>';
                    $oPSd->Edit();
                    $oPSd->psdID=$oPSd->psdID;
                    $oPSd->personId=$oPSd->personId;
                    $oPSd->deptId=$oDP->deptId;
                    $oPSd->docGroup=$oPSd->docGroup;
                    $oPSd->Save();
                }
            }else{
                $oPSd->SearchBypersonIddeptId($ps,$oDP->deptId,$maxdocgroup);
                if($oPSd->GetRecord()==1){
                    //echo 'del<br>';
                    $oPSd->Delete();
                }            
            }            
        }
if($showrep==1){
    echo "<meta http-equiv='refresh' content='0; URL=printSetPsDept.php'>";
}else if($showrepedit==1){
    echo "<meta http-equiv='refresh' content='0; URL=setPsDeptGroup.php'>";
}else{
    echo "<meta http-equiv='refresh' content='0; URL=addSetPsDept.php?ps=$ps'>";
}        
?>