public function executeSave() { $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $term = $this->getRequestParameter('term'); $accal_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($academic_calendar); $employee_id = $this->getRequestParameter('employee_id'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $descs = $this->getRequestParameter('desc'); foreach ($descs as $m => $desc) { if ($desc != null) { if ($desc != '-') { $ced = new Criteria(); $ced->add(StudentDescPeer::STUDENT_ACCAL_ID, $m); $ced->add(StudentDescPeer::TERM, $term); $spec = StudentDescPeer::doSelectOne($ced); if ($spec == null) { $spec = new StudentDesc(); } $spec->setStudentAccalId($m); $spec->setTerm($term); $spec->setNote($desc); $spec->save(); } else { $ced = new Criteria(); $ced->add(StudentDescPeer::STUDENT_ACCAL_ID, $m); $ced->add(StudentDescPeer::TERM, $term); $spec = StudentDescPeer::doSelectOne($ced); if ($spec != null) { $spec->delete(); } } } } return $this->redirect('course_tk/listScore?accal_id=' . $academic_calendar->getId() . '&term=' . $term . '&counseling_id=' . $counseling->getId() . '&employee_id=' . $employee_id); }
public function executeDeleteScoreDescript() { $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $grade_spec = GradeSpecPeer::retrieveByPK($this->getRequestParameter('grade_spec_id')); $this->forward404Unless($grade_spec); $c = new Criteria(); $c->add(StudentDescPeer::STUDENT_ACCAL_ID, $this->getRequestParameter('stu_id')); $c->add(StudentDescPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentDescPeer::TERM, $grade_spec->getId()); $note = StudentDescPeer::doSelectOne($c); $note->delete(); return $this->redirect('course_score/listDescript?course_id=' . $course_schedule->getId()); }