Viewing file: processaddpersonex.php (7.45 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
BeginTrans();
$oUs->BeginTrans();
//------------add person-------------------------
$UPath='uploadfile/'.$filename;
$fp = fopen($UPath, "r");
while(!feof($fp)) {
$char = fgets($fp);
list($prefixId, $name, $surname, $deptId, $loginname,$adminId,$hireId) = split('[,]', $char);
$prefixId = rtrim($prefixId);
$name = rtrim($name);
$surname = rtrim($surname);
$deptId= rtrim($deptId);
$loginname=substr(strtolower(rtrim($loginname)),0,8);
$adminId = rtrim($adminId);
$hireId= rtrim($hireId);
if($prefixId!="" && $name!="" && $surname!="" && $deptId!="" && $loginname!="" && $adminId!="" && $hireId!=""){
//---------------------------add data to people
//echo "+++++people table ";
$oPS->AddNew();
if($oPS->GetNextCode()==1){
$j=2;
}else{
$j=$oPS->GetNextCode();
}
$oPS->personId=$j;
//echo "personId".$oPS->personId." ";
$oPS->prefixId=$prefixId;
//echo "prefixId".$oPS->prefixId." ";
$oPS->fName=$name;
//echo "fName".$oPS->fName." ";
$oPS->lName=$surname;
//echo "lName".$oPS->lName." ";
$oPS->receiveDate=$oPS->receiveDate;
//echo "receiveDate".$oPS->receiveDate." ";
$oPS->pId=$oPS->pId;
//echo "pId".$oPS->pId." ";
$oPS->adlineId=$oPS->adlineId;
//echo "adlineId".$oPS->adlineId." ";
$oPS->adminposId=$oPS->adminposId;
//echo "adminposId".$oPS->adminposId." ";
$oPS->hireId=$hireId;
//echo "hireId".$oPS->hireId." ";
$oPS->majortypeId=$oPS->majortypeId;
//echo "majortypeId".$oPS->majortypeId." ";
$oPS->levelposId=$oPS->levelposId;
//echo "levelposId".$oPS->levelposId." ";
$oPS->stepSal=$oPS->stepSal;
//echo "stepSal".$oPS->stepSal." ";
$oPS->salary=$oPS->salary;
//echo "salary".$oPS->salary." ";
$oPS->partyId=$oPS->partyId;
//echo "partyId".$oPS->partyId." ";
$oPS->deptId=$deptId;
//echo "deptId".$oPS->deptId." ";
$oPS->majorId=$oPS->majorId;
//echo "majorId".$oPS->majorId." ";
$oPS->assignId=$oPS->assignId;
//echo "assignId".$oPS->assignId." ";
$oPS->promoteDate=$oPS->promoteDate;
//echo "promoteDate".$oPS->promoteDate." ";
$oPS->educDate=$oPS->educDate;
//echo "educDate".$oPS->educDate." ";
$oPS->posDate=$oPS->posDate;
//echo "posDate".$oPS->posDate." ";
$oPS->fullsalDate=$oPS->fullsalDate;
//echo "fullsalDate".$oPS->fullsalDate." ";
$oPS->typemoveId=$oPS->typemoveId;
//echo "typemoveId".$oPS->typemoveId." ";
$oPS->fyDecor=$oPS->fyDecor;
//echo "fyDecor".$oPS->fyDecor." ";
$oPS->lastDecor=$oPS->lastDecor;
//echo "lastDecor".$oPS->lastDecor." ";
$oPS->fRetire="0";
//echo "fRetire".$oPS->fRetire." ";
$oPS->adminId=$adminId;
//echo "adminId".$oPS->adminId." ";
$oPS->done=$oPS->done;
//echo "done".$oPS->done." ";
$oPS->accountNo=$oPS->accountNo;
//echo "accountNo".$oPS->accountNo." ";
$oPS->useSalary=$oPS->useSalary;
//echo "useSalary".$oPS->useSalary." ";
$oPS->personCode=$oPS->personCode;
//echo "personCode".$oPS->personCode." ";
$oPS->oldpersonCode=$oPS->oldpersonCode;
//echo "oldpersonCode".$oPS->oldpersonCode." ";
$oPS->admidYear=$oPS->admidYear;
//echo "admidYear".$oPS->admidYear." ";
$oPS->partyAtId=$oPS->partyAtId;
//echo "partyAtId".$oPS->partyAtId." ";
$oPS->partypracticeId=$oPS->partypracticeId;
//echo "partypracticeId".$oPS->partypracticeId." ";
$oPS->firstadmidDate=$oPS->firstadmidDate;
//echo "firstadmidDate".$oPS->firstadmidDate." ";
$oPS->posDegree=$oPS->posDegree;
//echo "posDegree".$oPS->posDegree." ";
$oPS->posEducmajor=$oPS->posEducmajor;
//echo "posEducmajor".$oPS->posEducmajor." ";
$oPS->enterType=$oPS->enterType;
//echo "enterType".$oPS->enterType." ";
$oPS->fStatus="1";
//echo "fStatus".$oPS->fStatus." ";
$oPS->salary2=$oPS->salary2;
//echo "salary2".$oPS->salary2." ";
$oPS->fullStep=$oPS->fullStep;
//echo "fullStep".$oPS->fullStep." ";
$oPS->levelposId2=$oPS->levelposId2;
//echo "levelposId2".$oPS->levelposId2." ";
$oPS->stepSal2=$oPS->stepSal2;
//echo "stepSal2".$oPS->stepSal2." ";
$oPS->useSalary2=$oPS->useSalary2;
//echo "useSalary2".$oPS->useSalary2." ";
$flagCommit = $oPS->Save();
if(!$flagCommit){ $checkflagCommit="1"; }
//---------------------------add data to ums
//echo "+++++umuser ";
$oUms->AddNew();
$oUms->UsID=$oUms->GetNextCode();
//echo "UsID".$oUms->UsID." ";
$oUms->UsName=$name." ".$surname;
//echo "UsName".$oUms->UsName." ";
$oUms->UsLogin=$loginname;
//echo "UsLogin".$oUms->UsLogin." ";
$oUms->UsPassword=md5("O]O57".strtolower(rtrim($loginname))."7O[O");
$oUms->UsPsCode=$oPS->personId;
//echo "UsPsCode".$oUms->UsPsCode." ";
//echo "personId".$oPe->personId." ";
$oUms->UsWgID=$oUms->UsWgID;
$oUms->UsQsID=$oUms->UsQsID;
$oUms->UsAnswer=$oUms->UsAnswer;
$oUms->UsEmail=$oUms->UsEmail;
$oUms->UsActive=$oUms->UsActive;
$oUms->UsAdmin=$oUms->UsAdmin;
$oUms->UsDesc=$oUms->UsDesc;
$oUms->UsPwdExpDt=$oUms->UsPwdExpDt;
$oUms->UsUpdDt=$oUms->UsUpdDt;
$oUms->UsUpdUsID=$oUms->UsUpdUsID;
$oUms->UsSessionID=$oUms->UsSessionID;
$flagCommit = $oUms->Save();
if(!$flagCommit){ $checkflagCommit="1"; }
//---------------------------add data to umusergroup
//echo "+++++umusergroup ";
$oUg->AddNew();
$oUg->UgID=$oUg->GetNextCode();
//echo "UsID".$oUg->UgID." ";
$oUg->UgGpID="108"; //ผู้ใข้ทั่วไปของสารบรรณ
//echo "UgGpID".$oUg->UgGpID." ";
$oUg->UgUsID=$oUms->UsID;
//echo "UgUsID".$oUg->UgUsID." ";
$flagCommit = $oUg->Save();
if(!$flagCommit){ $checkflagCommit="1"; }
//echo "-------------------------------- ";
} //if not null
} //while
if($checkflagCommit=="0"){
$oC->CommitTrans();
$oUs->CommitTrans();
}else{
$oC->RollbackTrans();
$oUs->RollbackTrans();
}
}
echo "";
?> bool(false)
|