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); }