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());
}
}
public static function getNilaiKi4($studentAccal, $subjectCurrId)
{
$c = new Criteria();
$c->add(CourseSchedulePeer::SUBJECT_CURR_ID, $subjectCurrId);
$c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $studentAccal->getAcademicCalendarId());
$c->add(CourseSchedulePeer::CLASS_GROUP_ID, $studentAccal->getClassGroupId());
$courseSchedule = CourseSchedulePeer::doSelectOne($c);
if (!$courseSchedule) {
return false;
}
$c = new Criteria();
$c->add(Cur13ReportPeer::STUDENT_ACCAL_ID, $studentAccal->getId(), Criteria::EQUAL);
$c->add(Cur13ReportPeer::CUR13_KI_ID, ScoreRule::FOUR, Criteria::EQUAL);
$c->add(Cur13ReportPeer::COURSE_SCHEDULE_ID, $courseSchedule->getId(), Criteria::EQUAL);
return Cur13ReportPeer::doSelectOne($c);
}
