public static function doSelectByStudentCourse() { $student_score_id = sfContext::getInstance()->getRequest()->getParameter('id'); $student_score = StudentScorePeer::retrieveByPK($student_score_id); $subject_accal = null; $objs = array(); if ($student_score) { $subject_accal = $student_score->getStudentCourse()->getSubjectAccal(); } if ($subject_accal == null) { return $objs; } $subject_gradings = $subject_accal->getSubjectGradings(); foreach ($subject_gradings as $sg) { $objs[] = $sg->getGradeComponent(); } return $objs; }
public function executeUpdateScore() { $ss_update_grade = $this->getRequestParameter('student_score_update_grade'); $ss_update_rem = $this->getRequestParameter('student_score_update_remark'); $ss_update_cit = $this->getRequestParameter('student_score_update_citation'); $ss_add_grade = $this->getRequestParameter('student_score_add_grade'); $ss_add_rem = $this->getRequestParameter('student_score_add_remark'); $ss_add_cit = $this->getRequestParameter('student_score_add_citation'); $subject_accal_id = $this->getRequestParameter('subject_accal_id'); $class_group_id = $this->getRequestParameter('class_group_id'); $this->forward404Unless($subject_accal_id); foreach ($ss_update_grade as $ss_id => $ss_grade) { if ($ss_grade) { $ss = StudentScorePeer::retrieveByPK($ss_id); $ss->setGrade($ss_grade); if ($ss_update_rem[$ss_id]) { $ss->setRemark($ss_update_rem[$ss_id]); } else { $ss->setRemark(''); } if ($ss_update_cit[$ss_id]) { $ss->setCitationId($ss_update_cit[$ss_id]); } else { $ss->setCitationId(''); } $ss->save(); } } foreach ($ss_add_grade as $sc_id => $grade_comps) { foreach ($grade_comps as $gc_id => $grade) { if ($grade > 0) { $ss = new StudentScore(); $ss->setStudentCourseId($sc_id); $ss->setGradeComponentId($gc_id); $ss->setGrade($grade); if ($ss_add_rem[$sc_id][$gc_id]) { $ss->setRemark($ss_add_rem[$sc_id][$gc_id]); } if ($ss_add_cit[$sc_id][$gc_id]) { $ss->setCitationId($ss_add_cit[$sc_id][$gc_id]); } $ss->save(); } } } return $this->redirect('subject_accal_l/editScore?subject_accal_id=' . $subject_accal_id . '&class_group_id=' . $class_group_id); }