/**
* @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++;
