public function postIndex() { $user_type = Input::get("userTypeA"); $user_name = Input::get("userNameText"); $password = Input::get("password"); //$deadline = Input::get("deadline"); if ($user_type == 2) { $guardian = DBGuardianController::getGuardian($user_name); if ($guardian->getPassword() == $password) { //if (Hash::check($password, $guardian->getPassword())){ return View::make('G1SAS/userpage')->with('guardian', $guardian)->with('username', $user_name)->with('labelText', 'Your Child-Your School'); } else { return View::make('G1SAS/login')->with('greet', 'Applications for this year is closed.')->with('message', 'Password you enttered is incorrect'); } } elseif ($user_type == 0) { $user = DBAdminController::getAdmin($user_name); if ($user->getPassword() == $password) { // if (Hash::check($password, $user->getPassword())){ return View::make('G1SAS/adminpage')->with('title', "You are logged in as:" . $user_name); } else { return View::make('G1SAS/login')->with('greet', 'Applications for this year is closed.')->with('message', 'Password you enttered is incorrect'); } } else { $school = DBSchoolController::getSchoolByEmail($user_name); if ($school->getPassword() == $password) { //if (Hash::check($password, $school->getPassword())){ return View::make('G1SAS/schoolpage')->with('school', $school)->with('notice', 'School information here'); } else { return View::make('G1SAS/login')->with('greet', 'Applications for this year is closed.')->with('message', 'Password you enttered is incorrect'); } } }
public function getSchoolapplicantsfind() { $schoolid = Input::get("schoolid"); $school = DBSchoolController::getSchool($schoolid); $schools = DBSchoolController::getAllSchool(); $selected = Input::get("school"); $selectedSchool = DBSchoolController::getSchool($selected); $pieces = explode("-", $selected); $schoolId = $pieces[0]; $applicants = DBStudentApplicantController::getSelectedApplicantsForSchool($schoolId); return View::make('G1SAS/showSchoolApplicants')->with('selectedSchool', $selectedSchool)->with('schools', $schools)->with('school', $school)->with('selected', $selected)->with('applicants', $applicants); }
public function getNext() { $applicant_id = Input::get("applicant_id"); $username = Input::get("username"); $school1 = Input::get("school_name1"); $school2 = Input::get("school_name2"); $school3 = Input::get("school_name3"); $school4 = Input::get("school_name4"); $school5 = Input::get("school_name5"); $school6 = Input::get("school_name6"); $ar = array($school1, $school2, $school3, $school4, $school5, $school6); $uni_ar = array_unique($ar); if (sizeof($uni_ar) != 6) { return Redirect::back()->withInput()->with('error', 'please select diffrent 6 schools'); } $school7 = Input::get("school_name7"); $school8 = Input::get("school_name8"); $school9 = Input::get("school_name9"); $school10 = Input::get("school_name10"); $school11 = Input::get("school_name11"); $school12 = Input::get("school_name12"); $school13 = Input::get("school_name13"); $school14 = Input::get("school_name14"); $school15 = Input::get("school_name15"); $school16 = Input::get("school_name16"); $ar = array($school7, $school8, $school9, $school10, $school11, $school12, $school13, $school14, $school5, $school6); $uni_ar = array_unique($ar); if (sizeof($uni_ar) != 10) { return Redirect::back()->withInput()->with('error', 'please select diffrent 10 schools for close school set'); } $division1 = Input::get("Year1d"); $division2 = Input::get("Year2d"); $division3 = Input::get("Year3d"); $division4 = Input::get("Year4d"); $division5 = Input::get("Year5d"); $division6 = Input::get("Year6d"); $year1 = Input::get("year1"); $year2 = Input::get("year2"); $year3 = Input::get("year3"); $year4 = Input::get("year4"); $year5 = Input::get("year5"); $year6 = Input::get("year6"); $ar = array($year1, $year2, $year3, $year4, $year5, $year6); $uni_ar = array_unique($ar); if (sizeof($uni_ar) != 6) { return Redirect::back()->withInput()->with('error', 'please select diffrent 6 years'); } $dArray = array($division1, $division2, $division3, $division4, $division5, $division6); $yArray = array($year1, $year2, $year3, $year4, $year5, $year6); $schoolid_array = array($school1, $school2, $school3, $school4, $school5, $school6, $school7, $school8, $school9, $school10, $school11, $school12, $school13, $school14, $school15, $school16); $schools = array(); $guardian = DBGuardianController::getGuardian($username); $applicant = DBStudentApplicantController::getApplicantById($applicant_id); foreach ($schoolid_array as $schoolid) { $schools[] = DBSchoolController::getSchool($schoolid); } return View::make('G1SAS/SelectionType')->with('username', $username)->with('schools', $schools)->with('dArray', $dArray)->with('yArray', $yArray)->with('guardian', $guardian)->with('applicant', $applicant); }
public function postChangep1() { $applicantId = Input::get("applicant_id"); $schools = DBSchoolController::getApplySchoolSet($applicantId); return View::make('G1SAS/changeSchoolPiority')->with('schools', $schools)->with('applicantId', $applicantId); }
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; } }
public static function getApplySchoolSet($applicantId) { $db = Connection::getInstance(); $mysqli = $db->getConnection(); $query = "select distinct schoolId from application where applicantId='{$applicantId}' order by orderOfPreference"; $result = $mysqli->query($query); $schools = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $schoolId = $row["schoolId"]; $school = DBSchoolController::getSchool($schoolId); $schools[] = $school; } } return $schools; }
public function postAddschool() { $schoolid = Input::get('schoolidtext'); $schoolname = Input::get('schoolnametext'); $category = Input::get('category'); $no_of_classes = Input::get('capacitytext'); $contact_number = Input::get('contacttext'); $male_per = Input::get('malepertext'); $sinhala_per = Input::get('sinhalapertext'); $email = Input::get('emailtext'); $password = Input::get('passwordtext'); $school = new school(); $school->setSchool_id($schoolid); $school->setSchool_name($schoolname); $school->setCategory($category); $school->setContact_no($contact_number); $school->setNo_of_classes($no_of_classes); $school->setMale_percentage($male_per); $school->setSinhala_percentage($sinhala_per); $school->setEmail($email); //$school->setPassword(Hash::make($password)); $school->setPassword($password); $result = DBSchoolController::addSchool($school); if ($result) { return View::make('G1SAS/adminpage')->with('title', 'School added successfully'); } else { return View::make('G1SAS/adminpage')->with('title', 'School was not added'); } }