public static function getCategory5($NIC)
{
$db = Connection::getInstance();
$mysqli = $db->getConnection();
$query = "select * from officerOnTransfer where NIC='{$NIC}';";
$result = $mysqli->query($query);
$category = new OfficerOnTransfer();
if ($result->num_rows > 0) {
if ($row = $result->fetch_assoc()) {
$category->setNic($row["NIC"]);
$category->setDateOfTransferReceived($row["dateOfTransferReceived"]);
$category->setBeforeWorkedPlace($row["beforeWorkedPlace"]);
$category->setAfterWorkedPlace($row["afterWorkedPlace"]);
$category->setDistanceOfTransfer($row["distanceOfTransfer"]);
$category->setYear1RemLeave($row["year1RemLeave"]);
$category->setYear2RemLeave($row["year2RemLeave"]);
$category->setYear3RemLeave($row["year3RemLeave"]);
$category->setYear4RemLeave($row["year4RemLeave"]);
$category->setServicePeriod($row["servicePeriod"]);
}
}
return $category;
}
public function postAddcategory()
{
//return "erer";
//$application=Input::get("application");
$type = Input::get("typeOfApplication");
$orderOfPreference = Input::get("orderOfPreference");
$schoolId = Input::get("schoolId");
$distance = Input::get("distance");
$medium = Input::get("medium");
$applicationId = DBApplicationController::getNextApplicationId();
$applicantId = Input::get("applicantId");
$guardianNic = Input::get("guardianNic");
$application = new Application();
$application->setSchool_id($schoolId);
$application->setApplication_id($applicationId);
$application->setApplicant_id($applicantId);
$application->setType($type);
$application->setMedium($medium);
$application->setOrderOfPreference($orderOfPreference);
$application->setDistance($distance);
$application->setMark(0);
$schoolIds = array(Input::get("schoolId1"), Input::get("schoolId2"), Input::get("schoolId3"), Input::get("schoolId4"), Input::get("schoolId5"), Input::get("schoolId6"), Input::get("schoolId7"), Input::get("schoolId8"), Input::get("schoolId9"), Input::get("schoolId10"));
$yArray = array(Input::get("year1"), Input::get("year2"), Input::get("year3"), Input::get("year4"), Input::get("year5"), Input::get("year6"));
$dArray = array(Input::get("division1"), Input::get("division2"), Input::get("division3"), Input::get("division4"), Input::get("division5"), Input::get("division6"));
$db = Connection::getInstance();
$mysqli = $db->getConnection();
if ($type == 0) {
$isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, 0);
if ($isStudentApplySchoolFromThisCategory) {
return "you have allready added this type of application to this school";
}
$noOfYearsInElectrocalRegister = Input::get('noOfYearsInElectrocalRegister');
$noOfYearsSpouseInElectrocalRegister = Input::get('noOfYearsSpouseInElectrocalRegister');
$typeOfTitleDeed = Input::get('typeOfTitleDeed');
$noOfAditionalDocumentForResident = Input::get('noOfAditionalDocumentForResident');
$closeSchoolCount = Input::get('closeSchoolCount');
$category = new Resident_in_closeProximity();
$category->setNoOfAditionalDocumentForResident($noOfAditionalDocumentForResident);
$category->setCloseSchoolCount($closeSchoolCount);
$category->setTypeOfTitleDeed($typeOfTitleDeed);
$category->setNoOfYearsSpouseInElectrocalRegister($noOfYearsSpouseInElectrocalRegister);
$category->setNoOfYearsInElectrocalRegister($noOfYearsInElectrocalRegister);
$category->setNic($guardianNic);
$resultC1 = DBApplicationController::addCategory1($application, $category, $schoolIds, $yArray, $dArray, $guardianNic);
if ($resultC1) {
return "application addded successfully";
} else {
return "application not added successfully";
}
} elseif ($type == 1) {
$isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, 1);
if ($isStudentApplySchoolFromThisCategory) {
return "you have allready added this type of application to this school";
}
$gradeOfAdmission = Input::get("gradeOfAdmission");
$gradeOfLeaving = Input::get("gradeOfLeaving");
$pastPupilOrganizationMembership = Input::get("pastPupilOrganizationMembership");
$eAchievementDetail = Input::get("eAchievementDetail");
$cAchievementDetail = Input::get("cAchievementDetail");
$eAchievementId = DBPPAchievementController::getNexPastPupilAId($guardianNic);
$cAchievementId = $eAchievementId + 1;
$guardian = DBGuardianController::getGuardianByNic($guardianNic);
$category2 = new PastPupil();
$category2->setSchoolId($schoolId);
$category2->setNIC($guardianNic);
$category2->setGradeOfAdmission($gradeOfAdmission);
$category2->setGradeOfLeaving($gradeOfLeaving);
$category2->setPastPupilOrganizationMembership($pastPupilOrganizationMembership);
$eAchievement = new PastPupil_achievement();
$eAchievement->setSchoolId($schoolId);
$eAchievement->setNIC($guardianNic);
$eAchievement->setAchievementID($eAchievementId);
$eType = 'Education';
$eAchievement->setType($eType);
$eAchievement->setAchievementDetail($eAchievementDetail);
$cAchievement = new PastPupil_achievement();
$cAchievement->setSchoolId($schoolId);
$cAchievement->setNIC($guardianNic);
$cAchievement->setAchievementID($cAchievementId);
$cType = 'Co_curricular';
$cAchievement->setType($cType);
$cAchievement->setAchievementDetail($eAchievementDetail);
$resultC1 = DBApplicationController::addCategory2($application, $category2, $schoolIds, $yArray, $dArray, $guardianNic, $eAchievement, $cAchievement);
if ($resultC1) {
return "type 2 application addded successfully";
} else {
return "type 2 application not addded successfully";
}
} elseif ($type == 2) {
$isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, 2);
if ($isStudentApplySchoolFromThisCategory) {
return "you have allready added this type of application to this school";
}
$firstName1 = Input::get("firstName1");
$lastName1 = Input::get("lastName1");
$admissionNumber1 = Input::get("admissionNumber1");
$gradeAdmission1 = Input::get("gradeAdmission1");
$dateOfAdmission1 = Input::get("dateOfAdmision1");
$category31 = new Currentstudent();
$category31->setSchoolId($schoolId);
$category31->setFirstName($firstName1);
$category31->setLastName($lastName1);
$category31->setAdmissionNumber($admissionNumber1);
$category31->setGradeOfAdmission($gradeAdmission1);
$category31->setDateOfAdmission($dateOfAdmission1);
$eAchievementDetail1 = Input::get("eAchiement1");
$eAchievementId1 = DBCPAchievementController::getNexCurrentPupilAId($admissionNumber1);
$achievementObject1 = new Cur_pupil_educationalachievement();
$achievementObject1->setAdmissionNumber($admissionNumber1);
$achievementObject1->setAchievementID($eAchievementId1);
$achievementObject1->setSchoolId($schoolId);
$achievementObject1->setAchievementDetail($eAchievementDetail1);
$donationDetail1 = Input::get("donationDetail1");
$donationId1 = DBCurPupilDonationController::getNexCurrentPupilDId($admissionNumber1);
$donationObject1 = new Cur_pupil_donation();
$donationObject1->setSchoolId($schoolId);
$donationObject1->setAdmissionNumber($admissionNumber1);
$donationObject1->setDonationId($donationId1);
$donationObject1->setDonationDetail($donationDetail1);
$sibling1 = new Sibling();
$sibling1->setAdmissionNumber($admissionNumber1);
$sibling1->setApplicantId($applicantId);
$sibling1->setSchoolId($schoolId);
$firstName2 = Input::get("firstName2");
$lastName2 = Input::get("lastName2");
$admissionNumber2 = Input::get("admissionNumber2");
$gradeAdmission2 = Input::get("gradeAdmission2");
$dateOfAdmission2 = Input::get("dateOfAdmision2");
$category32 = new Currentstudent();
$category32->setSchoolId($schoolId);
$category32->setFirstName($firstName2);
$category32->setLastName($lastName2);
$category32->setAdmissionNumber($admissionNumber2);
$category32->setGradeOfAdmission($gradeAdmission2);
$category32->setDateOfAdmission($dateOfAdmission2);
$eAchievementDetail2 = Input::get("eAchiement2");
$eAchievementId2 = DBCPAchievementController::getNexCurrentPupilAId($admissionNumber2);
$achievementObject2 = new Cur_pupil_educationalachievement();
$achievementObject2->setAdmissionNumber($admissionNumber2);
$achievementObject2->setAchievementID($eAchievementId2);
$achievementObject2->setSchoolId($schoolId);
$achievementObject2->setAchievementDetail($eAchievementDetail2);
$donationDetail2 = Input::get("donationDetail2");
$donationId2 = DBCurPupilDonationController::getNexCurrentPupilDId($admissionNumber2);
$donationObject2 = new Cur_pupil_donation();
$donationObject2->setSchoolId($schoolId);
$donationObject2->setAdmissionNumber($admissionNumber2);
$donationObject2->setDonationId($donationId2);
$donationObject2->setDonationDetail($donationDetail2);
$sibling2 = new Sibling();
$sibling2->setAdmissionNumber($admissionNumber2);
$sibling2->setApplicantId($applicantId);
$sibling2->setSchoolId($schoolId);
$firstName3 = Input::get("firstName3");
$lastName3 = Input::get("lastName3");
$admissionNumber3 = Input::get("admissionNumber3");
$gradeAdmission3 = Input::get("gradeAdmission3");
$dateOfAdmission3 = Input::get("dateOfAdmision3");
$category33 = new Currentstudent();
$category33->setSchoolId($schoolId);
$category33->setFirstName($firstName3);
$category33->setLastName($lastName3);
$category33->setAdmissionNumber($admissionNumber3);
$category33->setGradeOfAdmission($gradeAdmission3);
$category33->setDateOfAdmission($dateOfAdmission3);
$eAchievementDetail3 = Input::get("eAchiement3");
$eAchievementId3 = DBCPAchievementController::getNexCurrentPupilAId($admissionNumber3);
$achievementObject3 = new Cur_pupil_educationalachievement();
$achievementObject3->setAdmissionNumber($admissionNumber3);
$achievementObject3->setAchievementID($eAchievementId3);
$achievementObject3->setSchoolId($schoolId);
$achievementObject3->setAchievementDetail($eAchievementDetail3);
$donationDetail3 = Input::get("donationDetail3");
$donationId3 = DBCurPupilDonationController::getNexCurrentPupilDId($admissionNumber3);
$donationObject3 = new Cur_pupil_donation();
$donationObject3->setSchoolId($schoolId);
$donationObject3->setAdmissionNumber($admissionNumber3);
$donationObject3->setDonationId($donationId3);
$donationObject3->setDonationDetail($donationDetail3);
$sibling3 = new Sibling();
$sibling3->setAdmissionNumber($admissionNumber3);
$sibling3->setApplicantId($applicantId);
$sibling3->setSchoolId($schoolId);
$ppo = array($category31, $category32, $category33);
$achievements = array($achievementObject1, $achievementObject2, $achievementObject3);
$donations = array($donationObject1, $donationObject2, $donationObject3);
$siblings = array($sibling1, $sibling2, $sibling3);
$resultC1 = DBApplicationController::addCategory3($application, $schoolIds, $yArray, $dArray, $guardianNic, $ppo, $achievements, $donations, $siblings);
if ($resultC1) {
return "type 3 application addded successfully";
} else {
return "type 3 application not addded successfully";
}
} elseif ($type == 3) {
$isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, 3);
if ($isStudentApplySchoolFromThisCategory) {
return "you have allready added this type of application to this school";
}
$permenentEmployeePost = Input::get("permenentEmployeePost");
$distanceFromResidentToWork = Input::get("distanceFromResidentToWork");
$nowInDifficultSchoolService = Input::get("nowInDifficultSchoolService");
$periodOfDifficultSchoolService = Input::get("periodOfDifficultSchoolService");
$servingPeriodOfSchool = Input::get("servingPeriodOfSchool");
$closeSchoolCount = Input::get("closeSchoolCount");
$year1RemLeave = Input::get("year1RemLeave");
$year2RemLeave = Input::get("year2RemLeave");
$year3RemLeave = Input::get("year3RemLeave");
$year4RemLeave = Input::get("year4RemLeave");
$category4 = new EducationalServiceOfficer();
$category4->setNic($guardianNic);
$category4->setPermenentEmployeePost($permenentEmployeePost);
$category4->setCloseSchoolCount($closeSchoolCount);
$category4->setDistanceFromResidentToWork($distanceFromResidentToWork);
$category4->setNowInDifficultSchoolService($nowInDifficultSchoolService);
$category4->setPeriodOfDifficultSchoolService($periodOfDifficultSchoolService);
$category4->setServingSchoolId($schoolId);
$category4->setServingPeriodOfSchool($servingPeriodOfSchool);
$category4->setYear1RemLeave($year1RemLeave);
$category4->setYear2RemLeave($year2RemLeave);
$category4->setYear3RemLeave($year3RemLeave);
$category4->setYear4RemLeave($year4RemLeave);
$resultC1 = DBApplicationController::addCategory4($application, $category4, $schoolIds, $yArray, $dArray, $guardianNic);
if ($resultC1) {
return "type 4 application addded successfully";
} else {
return "type 4 application not addded successfully";
}
} elseif ($type == 4) {
$isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, 4);
if ($isStudentApplySchoolFromThisCategory) {
return "you have allready added this type of application to this school";
}
$year = Input::get("year");
$month = Input::get("month");
$date = Input::get("date");
$dateOfTransferReceived = $year . "/" . $month . "/" . $date;
$beforeWorkedPlace = Input::get("beforeWorkedPlace");
$afterWorkedPlace = Input::get("afterWorkedPlace");
$distanceOfTransfer = Input::get("distanceOfTransfer");
$year1RemLeave = Input::get("year1RemLeave");
$year2RemLeave = Input::get("year2RemLeave");
$year3RemLeave = Input::get("year3RemLeave");
$year4RemLeave = Input::get("year4RemLeave");
$servicePeriod = Input::get("servicePeriod");
$category5 = new OfficerOnTransfer();
$category5->setNic($guardianNic);
$category5->setDateOfTransferReceived($dateOfTransferReceived);
$category5->setBeforeWorkedPlace($beforeWorkedPlace);
$category5->setAfterWorkedPlace($afterWorkedPlace);
$category5->setDistanceOfTransfer($distanceOfTransfer);
$category5->setYear1RemLeave($year1RemLeave);
$category5->setYear2RemLeave($year2RemLeave);
$category5->setYear3RemLeave($year3RemLeave);
$category5->setYear4RemLeave($year4RemLeave);
$category5->setServicePeriod($servicePeriod);
$resultC1 = DBApplicationController::addCategory5($application, $category5, $schoolIds, $yArray, $dArray, $guardianNic);
if ($resultC1) {
return "type 5 application addded successfully";
} else {
return "type 5 application not addded successfully";
}
} elseif ($type == 5) {
$isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, 5);
if ($isStudentApplySchoolFromThisCategory) {
return "you have allready added this type of application to this school";
}
$dateOfReturned = Input::get("dateOfReturned");
$periodAboardStay = Input::get("PeriodOfStayAbroad");
$reason = Input::get("reason");
$category6 = new PersonComingFromAbroad();
$category6->setNic($guardianNic);
$category6->setDateOfReturned($dateOfReturned);
$category6->setPerioadAbroadStay($periodAboardStay);
$category6->setReasonsForStay($reason);
$resultC1 = DBApplicationController::addCategory6($application, $category6, $schoolIds, $yArray, $dArray, $guardianNic);
if ($resultC1) {
return "type 6 application addded successfully";
} else {
return "type 6 application not addded successfully";
}
}
//application eka add wen ona/////gurdian waguwata sambanda wela add wen on catogary 1
}
public function postEditcategory5()
{
$nic = Input::get('nic');
$dateOfTransferReceived = Input::get("dateOfTransferReceived");
$beforeWorkedPlace = Input::get("beforeWorkedPlace");
$afterWorkedPlace = Input::get("afterWorkedPlace");
$distanceOfTransfer = Input::get("distanceOfTransfer");
$year1RemLeave = Input::get("year1RemLeave");
$year2RemLeave = Input::get("year2RemLeave");
$year3RemLeave = Input::get("year3RemLeave");
$year4RemLeave = Input::get("year4RemLeave");
$servicePeriod = Input::get("servicePeriod");
$category5 = new OfficerOnTransfer();
$category5->setNic($nic);
$category5->setDateOfTransferReceived($dateOfTransferReceived);
$category5->setBeforeWorkedPlace($beforeWorkedPlace);
$category5->setAfterWorkedPlace($afterWorkedPlace);
$category5->setDistanceOfTransfer($distanceOfTransfer);
$category5->setYear1RemLeave($year1RemLeave);
$category5->setYear2RemLeave($year2RemLeave);
$category5->setYear3RemLeave($year3RemLeave);
$category5->setYear4RemLeave($year4RemLeave);
$category5->setServicePeriod($servicePeriod);
$result = DBCategory5Controller::editCategory5($category5);
if ($result) {
return "category 5 editted well";
} else {
return "category 5 not editted well";
}
}