Viewing file:  checkChangeDept.php (3.72 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 "../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";
include_once "../class/clsdeptref.php";
include_once "../class/clsdeptrefPE.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);
$oPSp = new PersonPE($oCc);
$oDr= new deptref($oC);
$oDrpe= new deptrefpe($oCc);
$error=0;
$oDPp->SearchDeptByMaxdeptDate();
while($oDPp->GetRecord() && $error!="1"){
$oDP->SearchByKey($oDPp->deptId);
if($oDP->GetRecord()=="1"){
$error=1;
}
} //while
if($error!=1){
$oDPp->SearchDeptByMaxdeptDate();
$maxnext=$oDP->SearchMaxDocGroup();
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;
echo "deptDesc=".$oDP->deptDesc."<br>";
$oDP->deptCode=$oDPp->deptCode;
echo "deptCode=".$oDP->deptCode."<br>";
$oDP->deptParent=$oDPp->deptParent;
echo "deptParent=".$oDP->deptParent."<br>";
$oDP->deptYear=$oDPp->deptYear;
echo "deptYear=".$oDP->deptYear."<br>";
$oDP->deptDate=$oDPp->deptDate;
echo "deptDate=".$oDP->deptDate."<br>";
$oDP->deptRef=$oDPp->deptRef;
echo "deptRef=".$oDP->deptRef."<br>";
$oDP->pbriId=$oDPp->pbriId;
echo "pbriId=".$oDP->pbriId."<br>";
$oDP->receiveIn="Y";
echo "receiveIn=".$oDP->receiveIn."<br>";
$oDP->sendIn="Y";
echo "sendIn=".$oDP->sendIn."<br>";
$oDP->sendOut="Y";
echo "sendOut=".$oDP->sendOut."<br>";
$oDP->deptIsCenter="";
$oDP->docGroup=($maxnext+1);
echo "docGroup=".$oDP->docGroup."<br>";
$oDP->deptNo=$oDPp->deptNo;
echo "deptNo=".$oDP->deptNo."<br>";
$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>";
echo "-------------------------------------------<br>";
$oDP->Save();
$oDrpe->searchBydeptId($oDPp->deptId);
while($oDrpe->GetRecord()){
$oDr->AddNew();
$oDr->drId=$oDr->GetNextCode();
$oDr->deptId=$oDPp->deptId;
$oDr->deptrefId=$oDrpe->deptrefId;
$oDr->Save();
}
}
$oPSp->RSPersonf1();
while($oPSp->GetRecord()){
$oPS->SearchByKey($oPSp->personId);
if($oPS->GetRecord()=="1"){
$oPS->Edit();
$oPS->personId=$oPSp->personId;
$oPS->deptId=$oPSp->deptId;
$oPS->workGpId=$oPS->workGpId;
$oPS->prefixId=$oPSp->prefixId;
$oPS->fName=$oPSp->fName;
$oPS->lName=$oPSp->lName;
$oPS->fStatus=$oPSp->fStatus;
$oPS->adminId=$oPSp->adminId;
$oPS->fRetire=$oPSp->fRetire;
$oPS->hireId=$oPSp->hireId;
//echo "เจอ=update=".$oPS->fName."".$oPS->lName."fstatus=".$oPS->fStatus."<br>";
$oPS->Save();
}
}
//// running
} //if error
$result = $error;
?>
<script language="JavaScript">
parent.location.href = "ChangeDept.php?result=<? echo $result; ?>";
</script>
|