public function getStudentAccal($con = null)
{
include_once 'lib/model/om/BaseStudentAccalPeer.php';
if ($this->aStudentAccal === null && $this->student_accal_id !== null) {
$this->aStudentAccal = StudentAccalPeer::retrieveByPK($this->student_accal_id, $con);
}
return $this->aStudentAccal;
}
public function executeSaveScore()
{
$student_id = $this->getRequestParameter('student_id');
$student = StudentPeer::retrieveByPK($student_id);
$this->forward404Unless($student);
$academic_calendar_id = $this->getRequestParameter('academic_calendar_id');
$academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id);
$this->forward404Unless($academic_calendar);
$counseling_id = $this->getRequestParameter('counseling_id');
$counseling = CounselingPeer::retrieveByPK($counseling_id);
$this->forward404Unless($counseling);
$student_accal_id = $this->getRequestParameter('student_accal_id');
$student_accal = StudentAccalPeer::retrieveByPK($student_accal_id);
$this->forward404Unless($student_accal);
$scores = $this->getRequestParameter('score');
foreach ($scores as $k => $score) {
if ($score != null) {
$cb = new Criteria();
$cb->add(CounselingRaportPeer::STUDENT_ACCAL_ID, $student_accal->getId());
$cb->add(CounselingRaportPeer::COUNSELING_SPEC_ID, $k);
$raport = CounselingRaportPeer::doSelectOne($cb);
if ($raport == null) {
$raport = new CounselingRaport();
}
$raport->setStudentAccalId($student_accal->getId());
$raport->setCounselingSpecId($k);
$raport->setGrade($score);
$raport->save();
} else {
$cb = new Criteria();
$cb->add(CounselingRaportPeer::STUDENT_ACCAL_ID, $student_accal->getId());
$cb->add(CounselingRaportPeer::COUNSELING_SPEC_ID, $k);
$raport = CounselingRaportPeer::doSelectOne($cb);
if ($raport != null) {
$raport->delete();
}
}
}
return $this->redirect('counseling_raport/listCounselingScore?accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId());
}
public function executeUpdate2()
{
$course_schedule_id = $this->getRequestParameter('course_id');
$course_schedule = CourseSchedulePeer::retrieveByPK($course_schedule_id);
$this->forward404Unless($course_schedule);
$this->course_schedule = $course_schedule;
$academic_calendar = $course_schedule->getAcademicCalendar();
$this->academic_calendar = $academic_calendar;
$cur13_id = $this->getRequestParameter('cur13_id');
$cur13_ki = Cur13KiPeer::retrieveByPK($cur13_id);
$this->forward404Unless($cur13_ki);
$this->cur13_ki = $cur13_ki;
$nilai = $this->getRequestParameter('nilai');
foreach ($nilai as $studentAccalId => $n) {
$studentAccal = StudentAccalPeer::retrieveByPK($studentAccalId);
if (!$studentAccal) {
continue;
}
$c = new Criteria();
$c->add(Cur13ReportPeer::STUDENT_ACCAL_ID, $studentAccal->getId(), Criteria::EQUAL);
$c->add(Cur13ReportPeer::CUR13_KI_ID, $cur13_ki->getId(), Criteria::EQUAL);
$c->add(Cur13ReportPeer::COURSE_SCHEDULE_ID, $course_schedule->getId(), Criteria::EQUAL);
$nilaiSiswa = Cur13ReportPeer::doSelectOne($c);
if (!$nilaiSiswa) {
$nilaiSiswa = new Cur13Report();
$nilaiSiswa->setStudentAccalId($studentAccal->getId());
$nilaiSiswa->setCur13KiId($cur13_ki->getId());
$nilaiSiswa->setCourseScheduleId($course_schedule->getId());
}
if (empty($n['rata2'])) {
$nilaiSiswa->setGrade('');
$nilaiSiswa->setRemark('');
$nilaiSiswa->setGradeScale('');
$nilaiSiswa->setTotalValue('');
$nilaiSiswa->setAvgValue('');
$nilaiSiswa->setDescription('');
} else {
$nilaiSiswa->setGrade($n['rata2']);
$nilaiSiswa->setRemark($n['capaian']);
$nilaiSiswa->setGradeScale($n['scale']);
$nilaiSiswa->setDescription($n['description']);
}
$nilaiSiswa->save();
}
if ($cur13_id == ScoreRule::THREE) {
return $this->redirect('course_sd/listRecaptKi3?accal_id=' . $academic_calendar->getId() . '&course_id=' . $course_schedule->getId());
} else {
return $this->redirect('course_sd/listRecaptKi4?accal_id=' . $academic_calendar->getId() . '&course_id=' . $course_schedule->getId());
}
}
