public static function getSchoolByEmail($email) { $db = Connection::getInstance(); $mysqli = $db->getConnection(); $query = "select * from school where email='{$email}';"; $result = $mysqli->query($query); $school = new school(); if ($result->num_rows > 0) { if ($row = $result->fetch_assoc()) { $school->setSchool_id($row["schoolId"]); $school->setSchool_name($row["name"]); $school->setMale_percentage($row["malePercentage"]); $school->setCategory($row["category"]); $school->setSinhala_percentage($row["sinhalaPercentage"]); $school->setContact_no($row["contactNumber"]); $school->setNo_of_classes($row["noofClasses"]); $school->setEmail($row["email"]); $school->setPassword($row["password"]); $schools[] = $school; } } return $school; }
public static function calculateschool() { $db = Connection::getInstance(); $mysqli = $db->getConnection(); $query1 = "select * from school;"; $result1 = $mysqli->query($query1); $schools = array(); $calculatedschools = array(); if ($result1->num_rows > 0) { while ($row = $result1->fetch_assoc()) { $school_no; $school = new school(); $school->setSchool_id($row["schoolId"]); $school_no = $row["schoolId"]; $school->setSchool_name($row["name"]); $school->setMale_percentage($row["malePercentage"]); $school->setCategory($row["category"]); $school->setSinhala_percentage($row["sinhalaPercentage"]); $school->setContact_no($row["contactNumber"]); $school->setNo_of_classes($row["noofClasses"]); $capacity; $capacity = $row["noofClasses"] * 40; $school->setEmail($row["email"]); $school->setPassword($row["password"]); $schools[] = $school; //get all application ids //$length=sizeof($Applications); for ($t = 1; $t < 7; $t++) { for ($m = 1; $m < 7; $m++) { $Applications[] = array(); $i = 0; $query4 = "select * from Application where typeOfApplication='{$m}' and orderOfPreference='{$t}' and schoolId='{$school_no}' and isverified='1'"; $result4 = $mysqli->query($query4); if ($result4->num_rows > 0) { while ($row = $result4->fetch_assoc()) { if (!in_array($row["application_id"], $calculatedschools)) { $Applications[$i] = $row["application_id"]; $i++; } } } $length = sizeof($Applications); //save marks in array $Application_Marks[] = array(); //final list of scools in descenting order of marks $schoolselectids[] = array(); /////errrroooooooorrrrrrrrrrrrrrrr if ($result4->num_rows > 0) { // do one thing{ for ($x = 0; $x < sizeof($Applications); $x++) { $id = $Applications[$x]; if ($t == 1) { $query = "select * from close_proximity_mark where application_id='{$id}'"; $result = $mysqli->query($query); $capacityquota = $capacity * 0.5; } elseif ($t == 2) { $query = "select * from pastpupil_mark where application_id='{$id}'"; $result = $mysqli->query($query); $capacityquota = $capacity * 0.25; } elseif ($t == 3) { $query = "select * from current_student_mark where application_id='{$id}'"; $result = $mysqli->query($query); $capacityquota = $capacity * 0.15; } elseif ($t == 4) { $query = "select * from educational_staff_mark where application_id='{$id}'"; $result = $mysqli->query($query); $capacityquota = $capacity * 0.05; } elseif ($t == 5) { $query = "select * from officer_on_transfer_mark where application_id='{$id}'"; $result = $mysqli->query($query); $capacityquota = $capacity * 0.04; } elseif ($t == 6) { $query = "select * from person_abroad_mark where application_id='{$id}'"; $result = $mysqli->query($query); $capacityquota = $capacity * 0.01; } if ($result->num_rows > 0) { if ($row = $result->fetch_assoc()) { if ($t == 1) { $total = $row["no_of_years_live_35"] + $row["residence_proof_10"] + $row["res_proof_other_5"] + $row["closeness_50"]; } if ($t == 2) { $total = $row["no_learnt_grades"] + $row["achievement_mark"] + $row["co_curricular_mark"] + $row["contribution_mark"]; } if ($t == 3) { $total = $row["no_learnt_grades"] + $row["no_living_years"] + $row["closeness_mark"] + $row["residence_proof_mark"] + $row["contribution_mark"]; } if ($t == 4) { $total = $row["no_working_years"] + $row["distance_mark"] + $row["difficult_service_mark"] + $row["unutilized_leave_mark"] + $row["if_in_same_school_mark"]; } if ($t == 5) { $total = $row["distance_on_trans_mark"] + $row["closeness_mark"] + $row["no_serving_years"] + $row["no_serving_years"] + $row["unutilized_leave_mark"]; } if ($t == 6) { $total = $row["time_in_abroad"] + $row["reason_of_transfer"] + $row["closeness_mark"]; } $Application_Marks[$x] = $total; } } else { var_dump(''); } } $length = sizeof($Application_Marks); for ($x = 0; $x < $length; $x++) { $max_key = -1; $max_val = -1; for ($y = 0; $y < $length; $y++) { if ($Application_Marks[$y] > $max_val) { $max_val = $Application_Marks[$y]; $max_key = $y; } } $schoolselectids[$x] = $Applications[$max_key]; var_dump($schoolselectids[$x]); $Application_Marks[$max_key] = 0; } if ($capacityquota > $length) { $capacityquota = $length; } for ($x = 0; $x < $capacityquota; $x++) { $id = $schoolselectids[$x]; $calculatedschools[] = $id; $query = "select applicantId from Application where application_id='{$id}'"; $result = $mysqli->query($query); $applicant_no; if ($result->num_rows > 0) { if ($row = $result->fetch_assoc()) { $applicant_no = $row["applicantId"]; } } $query = "UPDATE studentApplicant SET selectedSchoolId='{$school_no}' WHERE applicantId={$applicant_no}"; $mysqli->query($query); } unset($Applications); unset($Application_Marks); unset($schoolselectids); } else { unset($Applications); unset($Application_Marks); unset($schoolselectids); } } } } } }
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'); } }