Viewing file: processimportupdate.php (7.7 KB) -rwxr-xr-x 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/clsStudentMaster.php";
include_once "../class/clsStudentBio.php";
$oSm = new StudentMaster($oC2);
$oSm2 = new StudentMaster($oC2);
$oSb = new StudentBio($oC2);
include_once "../class/clsimportupdate.php";
include_once "../class/clsalumnimain.php";
include_once "../class/clsalumnibio.php";
include_once "../class/clsmapprogram.php";
include_once "../link/function.php";
$obj = new ImportUpdate($oC1);
$obj2 = new ImportUpdate($oC1);
$oAm = new AlumniMain($oC1);
$oAm2 = new AlumniMain($oC1);
$oAb = new AlumniBio($oC1);
$oMp = new mapprogram($oC1);
if($method=="add"){
$countup = 0;
// Check Map Program
$oSm->RSStudentMasterGroupProgramgraduateYear(4);
while($oSm->GetRecord())
{
$oMp->SearchByprogramId_reg($oSm->programId);
if($oMp->GetRecord()==0)
{
echo "<meta http-equiv='refresh' content='0; URL=addalumni_reg.php?check=1'>";
}
else
{
$oSm2->RSStudentMasterProgramgraduateYear(4,$oSm->programId);
while($oSm2->GetRecord())
{
$oAm2->SearchByStudentId($oSm2->studentId);
if($oAm2->GetRecord()==0)
{
$oAm->AddNew();
$oAm->alumniId=$oAm->GetNextCode();
$oAm->studentId=$oSm2->studentId;
$oAm->studentCode=$oSm2->studentCode;
$oAm->levelId=$oSm->levelId;
$oMp->SearchByprogramId_reg($oSm2->programId);
$oMp->GetRecord();
$oAm->programId=$oMp->programId_alumni;
$oAm->prefixId=$oSm2->prefixId;
$oAm->studentName=$oSm2->studentName;
$oAm->studentSurname=$oSm2->studentSurname;
$oAm->studentNameEng=$oSm2->studentNameEng;
$oAm->studentSurnameEng=$oSm2->studentSurnameEng;
$oAm->creditAttempt=$oSm2->creditAttempt;
$oAm->creditSatisfy=$oSm2->creditSatisfy;
$oAm->GPA=$oSm2->GPA;
$oAm->admitAcadYear=$oSm2->admitAcadYear;
$oAm->admitSemester=$oSm2->admitSemester;
$oAm->admitDate=$oSm2->admitDate;
$oAm->finishDate=$oSm2->finishDate;
$oAm->studentPassword=$oSm2->studentPassword;
$oAm->studentEmail=$oSm2->studentEmail;
$oAm->studentYear=$oSm2->studentYear;
$oAm->studentStatus=$oSm2->studentStatus;
$oAm->officerId1=$oSm2->officerId1;
$oAm->officerId2=$oSm2->officerId2;
$oAm->financeStatus=$oSm2->financeStatus;
$oAm->updateUserId=$oSm2->updateUserId;
$oAm->updateDateTime=$oSm2->updateDateTime;
$oAm->citizenId=$oSm2->citizenId;
$oAm->graduateYear=$oSm2->graduateYear;
$oAm->genStatus=$oSm2->genStatus;
$oAm->genNo=$oSm2->genNo;
$oAm->entryTypeId=$oSm2->entryTypeId;
$oAm->entryTypeId2=$oSm2->entryTypeId2;
$oAm->studentSex=$oSm2->studentSex;
$oAm->scholarId=$oSm2->scholarId;
$oAm->preAdmitPositionId=$oSm2->preAdmitPositionId;
$oAm->totalPoint=$oSm2->totalPoint;
$oAm->honor=$oSm2->honor;
$oAm->medal=$oSm2->medal;
$oAm->exitExam=$oSm2->exitExam;
$oAm->studentStatusTmp=$oSm2->studentStatusTmp;
$oAm->importtoalumni='A';
$oAm->glantId='N';
$oAm->glantDate=$glantDate;
$oAm->glantreqDate=$glantreqDate;
list($finishAcadYear, $monthAd, $dayAd) = split('[-]', (splitDateDbL($oAm->finishDate,"-")));
$oAm->finishAcadYear=$finishAcadYear+544;
$oAm->Save();
$oSb->SearchByKey($oSm2->studentId);
$oSb->GetRecord();
$oAb->AddNew();
$oAb->alumniId=$oAm->alumniId;
$oAb->studentId=$oSb->studentId;
$oAb->nationId=$oSb->nationId;
$oAb->religionId=$oSb->religionId;
$oAb->bloodGroup=$oSb->bloodGroup;
$oAb->birthDate=$oSb->birthDate;
$oAb->birthProvinceId=$oSb->birthProvinceId;
$oAb->homeAddress=$oSb->homeAddress;
$oAb->homeDistrictId=$oSb->homeDistrictId;
$oAb->homeAmphurId=$oSb->homeAmphurId;
$oAb->homeProvinceId=$oSb->homeProvinceId;
$oAb->homeZipcode=$oSb->homeZipcode;
$oAb->homePhoneNo=$oSb->homePhoneNo;
$oAb->officeName=$oSb->officeName;
$oAb->officeAddress=$oSb->officeAddress;
$oAb->officeDistrictId=$oSb->officeDistrictId;
$oAb->officeAmphurId=$oSb->officeAmphurId;
$oAb->officeProvinceId=$oSb->officeProvinceId;
$oAb->officeZipcode=$oSb->officeZipcode;
$oAb->officePhoneNo=$oSb->officePhoneNo;
$oAb->workingStatus=$oSb->workingStatus;
$oAb->workingPosition=$oSb->workingPosition;
$oAb->workingSalary=$oSb->workingSalary;
$oAb->fatherName=$oSb->fatherName;
$oAb->fatherAddress=$oSb->fatherAddress;
$oAb->fatherDistrictId=$oSb->fatherDistrictId;
$oAb->fatherAmphurId=$oSb->fatherAmphurId;
$oAb->fatherProvinceId=$oSb->fatherProvinceId;
$oAb->fatherZipcode=$oSb->fatherZipcode;
$oAb->fatherPhoneNo=$oSb->fatherPhoneNo;
$oAb->fatherOccupation=$oSb->fatherOccupation;
$oAb->fatherStatus=$oSb->fatherStatus;
$oAb->motherName=$oSb->motherName;
$oAb->motherAddress=$oSb->motherAddress;
$oAb->motherDistrictId=$oSb->motherDistrictId;
$oAb->motherAmphurId=$oSb->motherAmphurId;
$oAb->motherProvinceId=$oSb->motherProvinceId;
$oAb->motherZipcode=$oSb->motherZipcode;
$oAb->motherPhoneNo=$oSb->motherPhoneNo;
$oAb->motherOccupation=$oSb->motherOccupation;
$oAb->motherStatus=$oSb->motherStatus;
$oAb->studentSex=$oSb->studentSex;
$oAb->parentName=$oSb->parentName;
$oAb->parentRelation=$oSb->parentRelation;
$oAb->parentAddress=$oSb->parentAddress;
$oAb->parentDistrictId=$oSb->parentDistrictId;
$oAb->parentAmphurId=$oSb->parentAmphurId;
$oAb->parentProvinceId=$oSb->parentProvinceId;
$oAb->parentZipcode=$oSb->parentZipcode;
$oAb->parentPhoneNo=$oSb->parentPhoneNo;
$oAb->parentMobile=$oSb->parentMobile;
$oAb->parentOcc=$oSb->parentOcc;
$oAb->parentIncome=$oSb->parentIncome;
$oAb->parentEmail=$oSb->parentEmail;
$oAb->contactPerson=$oSb->contactPerson;
$oAb->contactAddress=$oSb->contactAddress;
$oAb->contactDistrictId=$oSb->contactDistrictId;
$oAb->contactAmphurId=$oSb->contactAmphurId;
$oAb->contactProvinceId=$oSb->contactProvinceId;
$oAb->contactZipcode=$oSb->contactZipcode;
$oAb->contactPhoneNo=$oSb->contactPhoneNo;
$oAb->cardExpiryDate=$oSb->cardExpiryDate;
$oAb->currentAddress=$oSb->currentAddress;
$oAb->currentDistrictId=$oSb->currentDistrictId;
$oAb->currentAmphurId=$oSb->currentAmphurId;
$oAb->currentProvinceId=$oSb->currentProvinceId;
$oAb->currentZipcode=$oSb->currentZipcode;
$oAb->currentPhoneNo=$oSb->currentPhoneNo;
$oAb->graduateAddress=$oSb->graduateAddress;
$oAb->graduateDistrictId=$oSb->graduateDistrictId;
$oAb->graduateAmphurId=$oSb->graduateAmphurId;
$oAb->graduateProvinceId=$oSb->graduateProvinceId;
$oAb->graduateZipcode=$oSb->graduateZipcode;
$oAb->graduatePhoneNo=$oSb->graduatePhoneNo;
$oAb->maritalStatusId=$oSb->maritalStatusId;
$oAb->weight=$oSb->weight;
$oAb->height=$oSb->height;
$oAb->picturePath="../picturePerson/photo.gif";
$oAb->recruitmentTypeId=$oSb->recruitmentTypeId;
$oAb->occExamResult=$oSb->occExamResult;
$oAb->canRefund=$oSb->canRefund;
$oAb->oldStudentName=$oSb->oldStudentName;
$oAb->entryDegree=$oSb->entryDegree;
$oAb->healthPrivId=$oSb->healthPrivId;
$oAb->o1prefixId=$o1prefixId;
$oAb->o1fName=$o1fName;
$oAb->o1lName=$o1lName;
$oAb->o2prefixId=$o2prefixId;
$oAb->o2fName=$o2fName;
$oAb->o2lName=$o2lName;
$countup ++;
$oAb->Save();
}
}
}
}
echo "<meta http-equiv='refresh' content='0; URL=addalumni_reg.php?check=2&numnewrecord=$countup'>";
}
?>
|