Viewing file: processSetPsDept.php (1.7 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/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'>"; } ?>
|