<?php
include_once "template.php";
include_once "../link/function.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../class/clsDepartmentPE.php";
include_once "../class/clsPersonPE.php";

$oCc = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EPERSON'], $GLOBALS['DBUSER_EPERSON'], $GLOBALS['DBPASS_EPERSON']);
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EOFFICE'], $GLOBALS['DBUSER_EOFFICE'], $GLOBALS['DBPASS_EOFFICE']);

$oDP = new Department($oC);
$oPS = new person($oC);
$oDPp = new departmentPE($oCc);
$oDPp2 = new departmentPE($oCc);
$oPSp = new PersonPE($oCc);

echo "<br><br><div align=center><strong>--- ระบบกำลังนำข้อมูลบุคลากรเข้า กรุณารอสักครู่ ---</strong></div>";
             $maxdate=$oDPp->MaxDate();
            $flagCommit = true;
            $checkflagCommit= true;
            $oC->BeginTrans();

 $oDPp->RSdepartment2();
 while($oDPp->GetRecord()){
             $oDP->AddNew();
            $oDP->deptId=$oDPp->deptId;
            //echo "deptId=".$oDP->deptId."<br>";
            $oDP->deptName=$oDPp->deptName;
            //echo "deptName=".$oDP->deptName."<br>";
            $oDP->deptDesc=$oDPp->deptDesc;
            $oDP->deptCode=$oDPp->deptCode;
            $oDP->deptParent=$oDPp->deptParent;
            $oDP->deptYear=$oDPp->deptYear;
            $oDP->deptDate=$oDPp->deptDate;
            //echo "deptDate=".$oDP->deptDate."<br>";
            $oDP->deptRef=$oDPp->deptRef;
            $oDP->pbriId=$oDPp->pbriId;
            $oDP->deptIsCenter="";
            $oDP->receiveIn="Y";
            $oDP->sendIn="Y";
            $oDP->sendOut="Y";
            $oDP->deptNo=$oDPp->deptNo;
            //echo "deptNo=".$oDP->deptNo."<br>";
            if($oDP->deptDate==$maxdate){
                $oDP->docGroup=1;
            }else{
                $oDP->docGroup=0;
            }
            $oDP->depttypeId=$oDPp->depttypeId;
            //echo "depttypeId=".$oDP->depttypeId."<br>";
            $oDP->deptParentId=$oDPp->deptParentId;
            //echo "deptParentId=".$oDP->deptParentId."<br>";
            $oDP->deptLevel=$oDPp->deptLevel;
            //echo "deptLevel=".$oDP->deptLevel."<br>";
            $oDP->deptGroup=$oDPp->deptGroup;
        //echo "deptGroup=".$oDP->deptGroup."<br>";            
            $checkflagCommit = $oDP->Save();
            if(!$checkflagCommit){ $flagCommit=$checkflagCommit;   }
 }     
 
$oPSp->RSPersonf1();
 while($oPSp->GetRecord()){
             $oPS->AddNew();
            $oPS->personId=$oPSp->personId;
            //echo "e=".$oPS->personId."p=".$oPSp->personId."n=".$oPSp->fName."<br>";
            $oPS->deptId=$oPSp->deptId;
            $oPS->workGpId="";
            if($oPSp->prefixId=="2" ||  $oPSp->prefixId=="3"){
                $oPS->prefixId=$oPSp->prefixId;
            }else{
                $oPS->prefixId="1";
            }
            $oPS->fName=$oPSp->fName;
            $oPS->lName=$oPSp->lName;
            $oPS->fStatus=$oPSp->fStatus;
            $oPS->adminId=$oPSp->adminId;
            $oPS->fRetire=$oPSp->fRetire;
            $oPS->hireId=$oPSp->hireId;
            $checkflagCommit = $oPS->Save();
            if(!$checkflagCommit){ $flagCommit=$checkflagCommit;   }
 }
    if($flagCommit)
        $oC->CommitTrans();
    else
        $oC->RollbackTrans();
                                                 
echo "<meta http-equiv='refresh' content='0; URL=ImportPerson.php?s=1'>";

?>