public function postApplication() { $username = Input::get("username"); $applicantId = Input::get("applicant_id"); $orderOfPreference = Input::get("schoolPiority"); $schoolId = Input::get("schoolId"); $type = Input::get("type"); $distance = Input::get("distanceT"); $medium = ''; if (Input::get("MediumT") == 0) { $medium = 'Sinhala'; } else { $medium = 'Tamil'; } $guardianNic = Input::get("guardianNic"); $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")); $yearset = array(Input::get("year1"), Input::get("year2"), Input::get("year3"), Input::get("year4"), Input::get("year5"), Input::get("year6")); $divisionSet = array(Input::get("division1"), Input::get("division2"), Input::get("division3"), Input::get("division4"), Input::get("division5"), Input::get("division6")); $application = new application(); $application->setOrderOfPreference($orderOfPreference); $application->setType($type); $application->setSchool_id($schoolId); $application->setDistance($distance); $application->setMedium($medium); $application->setApplicant_id($applicantId); $isStudentApplySchoolFromThisCategory = DBApplicationController::isStudentApplySchoolFromThisCategory($applicantId, $schoolId, $type); if ($isStudentApplySchoolFromThisCategory) { return "you have allready added this type of application to this school"; } switch ($type) { case 0: $resultCD = DBGuardianController::hasCategory1Detail($guardianNic); if ($resultCD) { $applicantResult = DBApplicationController::addApplication($application); if ($applicantResult) { return "added successfully"; } else { return "not aded successfully"; } } else { return View::make('G1SAS/category1')->with('application', $application)->with('username', $username)->with('schools', $schoolIds)->with('yArray', $yearset)->with('guardianNic', $guardianNic)->with('dArray', $divisionSet); } break; case 1: // never reached because "a" is already matched with 0 return View::make('G1SAS/category2')->with('application', $application)->with('username', $username)->with('schools', $schoolIds)->with('yArray', $yearset)->with('guardianNic', $guardianNic)->with('dArray', $divisionSet); break; case 2: return View::make('G1SAS/category3')->with('application', $application)->with('username', $username)->with('schools', $schoolIds)->with('yArray', $yearset)->with('guardianNic', $guardianNic)->with('dArray', $divisionSet); break; case 3: // never reached because "a" is already matched with 0 return View::make('G1SAS/category4')->with('application', $application)->with('username', $username)->with('schools', $schoolIds)->with('yArray', $yearset)->with('guardianNic', $guardianNic)->with('dArray', $divisionSet); break; case 4: return View::make('G1SAS/category5')->with('application', $application)->with('username', $username)->with('schools', $schoolIds)->with('yArray', $yearset)->with('guardianNic', $guardianNic)->with('dArray', $divisionSet); break; case 5: return View::make('G1SAS/category6')->with('application', $application)->with('username', $username)->with('schools', $schoolIds)->with('yArray', $yearset)->with('guardianNic', $guardianNic)->with('dArray', $divisionSet); break; } }
public static function addCategory3($application, $schoolIds, $yArray, $dArray, $guardianNic, $ppo, $achievements, $donations, $siblings) { $db = Connection::getInstance(); $mysqli = $db->getConnection(); $mysqli->autocommit(FALSE); $applicantResult = DBApplicationController::addApplication($application); if ($applicantResult) { $resultSchoolSet = true; $isApplicanthasCSS = DBSchoolController::isApplicanthasCSS($application->getApplicant_id()); if ($isApplicanthasCSS) { //do not need add school set } else { // return $schoolIds[1]; $resultSchoolSet = DBSchoolController::addCloseSchoolSet($application->getApplicant_id(), $schoolIds); } if ($resultSchoolSet) { $resultEL = true; $isGuardianHasEL = DBGuardianController::isGuardianHasEL($guardianNic); if ($isGuardianHasEL) { } else { $resultEL = DBElectrocalListController::addElectrocalListDetail($dArray, $yArray, $guardianNic); } if ($resultEL) { for ($i = 0; $i < 3; $i++) { $resultC = true; $resultEA = true; $resultD = true; $resultS = true; $resultCD = DBGuardianController::hasCategory3Detail($ppo[$i]->getAdmissionNumber(), $application->getSchool_id()); if ($resultCD == false) { $resultC = DBCategory3Controller::addCategory3($ppo[$i]); $resultEA = DBCPAchievementController::addCPAchievement($achievements[$i]); $resultD = DBCurPupilDonationController::addCPDonation($donations[$i]); $resultS = DBSiblingController::addSibling($siblings[$i]); } if ($resultD and $resultEA and $resultC and $resultS) { } else { $mysqli->rollback(); $mysqli->commit(); return false; } } $mysqli->commit(); return true; } else { $mysqli->rollback(); $mysqli->commit(); return FALSE; } } else { $mysqli->rollback(); $mysqli->commit(); return FALSE; } } else { $mysqli->rollback(); $mysqli->commit(); return FALSE; } }