/** * @before _secure, _school */ public function remove($user_id) { $this->noview(); $sub = Registry::get("MongoDB")->submission; $scholar = Scholar::first(array("user_id = ?" => $user_id)); if (!$scholar || $scholar->organization_id != $this->organization->id) { self::redirect("/404"); } $user = User::first(array("id = ?" => $user_id)); if (!$user) { self::redirect("/404"); } $enrollment = Enrollment::first(array("user_id = ?" => $user->id)); $submissions = $sub->find(array("user_id" => (int) $user->id)); $examResults = ExamResult::all(array("user_id = ?" => $user->id)); foreach ($examResults as $r) { // $r->delete(); } foreach ($submissions as $s) { // $s->remove(); } // $enrollment->delete(); // $user->delete(); // $scholar->delete(); self::redirect($_SERVER['HTTP_REFERER']); }
public function results($course) { $exams = \Exam::all(array("course_id = ?" => $course->id), array("year", "type", "id")); $result = array(); foreach ($exams as $e) { $whole_class = \ExamResult::all(array("exam_id = ?" => $e->id), array("marks", "user_id")); $total = 0; $highest = -1; $count = 0; $user_marks = 0; foreach ($whole_class as $w_c) { $total += $w_c->marks; if ((int) $w_c->marks > $highest) { $highest = (int) $w_c->marks; } if ($w_c->user_id == self::$_student->user_id) { $user_marks = (int) $w_c->marks; } ++$count; } $data = array("type" => $e->type, "year" => $e->year, "exam_id" => $e->id, "marks" => $user_marks, "highest" => $highest, "average" => $total / $count); $data = ArrayMethods::toObject($data); $result[] = $data; } return $result; }
private function _findMarks($opts = array()) { $setCourses = $opts["setCourses"]; $exams = $opts["exams"]; $results = array(); $setResults = array(); foreach ($exams as $e) { $result = ExamResult::first(array("exam_id = ?" => $e->id, "user_id = ?" => $opts["user_id"])); $setResults["{$result->id}"] = $result; $data = array("course" => $setCourses["{$e->course_id}"], "marks" => $result->marks, "course_id" => $e->course_id, "result_id" => $result->id); $data = ArrayMethods::toObject($data); $results[] = $data; } return array("results" => $results, "setResults" => $setResults); }
$x = array(); //for unique branch id foreach ($data as $list) { $x[] = $list['exam_result_schedule_branch_id']; } $sb_id = array_unique($x); //for foreach ($sb_id as $list1) { $m = 1; $sem = ExamScheduleBranch::model()->findByPk($list1); $scid = ExamSchedule::model()->findByPk($sem['exam_schedule_id']); $name = ExamName::model()->findByPk($scid['exam_schedule_exam_name_id']); $sem = AcademicTerm::model()->findByPk($sem['exam_schedule_branch_term_period_id'])->academic_term_name; $cat = ExamCategory::model()->findByPk($name['exam_category_id'])->exam_category_name; $type = ExamType::model()->findByPk($scid['exam_type_id'])->exam_type_name; $data1 = ExamResult::model()->findAll(array('condition' => 'exam_result_schedule_branch_id=' . $list1 . ' AND exam_result_student_id=' . $stu_id)); echo "<table class='table_data'>"; echo "<th colspan=\"12\" style=\"font-size:16px;\">"; echo 'Sem:' . $sem . ' ' . 'Category:' . $cat . ' ' . 'Type:' . $type; echo "</th>"; echo "<tr class='table_header'><th>Subject</th><th>Gain Mark</th><th>Total Mark</th></tr>"; foreach ($data1 as $list2) { if ($m % 2 == 0) { $class = "odd"; } else { $class = "even"; } echo "<tr class=" . $class . "><td>" . SubjectMaster::model()->findByPk($list2['exam_result_subject_id'])->subject_master_name . "</td>"; echo "<td>" . $list2['exam_result_gain_mark'] . "</td>"; echo "<td>" . $list2['exam_result_total_mark'] . "</td></tr>"; $m++;