public function executeSave() { $counsel_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counsel_id); $this->forward404Unless($counseling); $this->counseling = $counseling; $accal_id = $this->getRequestParameter('accal_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id); $this->forward404Unless($academic_calendar); $this->academic_calendar = $academic_calendar; $scores = $this->getRequestParameter('score'); foreach ($scores as $k => $score) { if ($score != null) { if ($score != '-') { $ids = split('_', $k); ## $ids[0] = Student Id ## $ids[1] = Spec Id $c = new Criteria(); $c->add(StudentMedicalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(StudentMedicalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $c->add(StudentMedicalPeer::STUDENT_ID, $ids[0]); $student_medical = StudentMedicalPeer::doSelectOne($c); if ($student_medical == null) { $student_medical = new StudentMedical(); } ## Height if ($ids[1] == 1) { $student_medical->setHeight($score); } elseif ($ids[1] == 2) { $student_medical->setWeight($score); } elseif ($ids[1] == 3) { $student_medical->setListening($score); } elseif ($ids[1] == 4) { $student_medical->setVisual($score); } elseif ($ids[1] == 5) { $student_medical->setDental($score); } $student_medical->setStudentId($ids[0]); $student_medical->setClassGroupId($counseling->getClassGroupId()); $student_medical->setAcademicCalendarId($academic_calendar->getId()); $student_medical->save(); } else { $ids = split('_', $k); ## $ids[0] = Student Id ## $ids[1] = Spec Id $c = new Criteria(); $c->add(StudentMedicalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(StudentMedicalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $c->add(StudentMedicalPeer::STUDENT_ID, $ids[0]); $student_medical = StudentMedicalPeer::doSelectOne($c); if ($student_medical != null) { $student_medical->delete(); } } } } return $this->redirect('counseling_sd/listPhysical?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId()); }
public static function getMedicalStudent($studentAccal) { $c = new Criteria(); $c->add(StudentMedicalPeer::STUDENT_ID, $studentAccal->getStudentId(), Criteria::EQUAL); $c->add(StudentMedicalPeer::ACADEMIC_CALENDAR_ID, $studentAccal->getAcademicCalendarId(), Criteria::EQUAL); return StudentMedicalPeer::doSelectOne($c); }