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 "";
?>