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