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 function addStudentMedical(StudentMedical $l)
{
$this->collStudentMedicals[] = $l;
$l->setStudentHealth($this);
}
public function addStudentMedical(StudentMedical $l)
{
$this->collStudentMedicals[] = $l;
$l->setIllness($this);
}
public function addStudentMedical(StudentMedical $l)
{
$this->collStudentMedicals[] = $l;
$l->setAcademicCalendar($this);
}
public function addStudentMedical(StudentMedical $l)
{
$this->collStudentMedicals[] = $l;
$l->setClassGroup($this);
}
