public function executeSaveCopy()
{
$accal_tujuan = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal1'));
$accal_asal = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal2'));
$params = array();
foreach (explode('&', $this->getRequestParameter('ekskul_list_ser')) as $p) {
$p = explode('=', $p);
$params[rawurldecode($p[0])][] = rawurldecode($p[1]);
}
if (array_key_exists('ekskuls', $params)) {
foreach ($params['ekskuls'] as $ekskul_id) {
$sc = SchedulePeer::retrieveByPK($ekskul_id);
$cw = new Criteria();
$cw->add(ScheduleDetailPeer::SCHEDULE_ID, $sc->getId());
$sc_details = ScheduleDetailPeer::doSelect($cw);
$cd = new Criteria();
$cd->add(ScheduleTutorPeer::SCHEDULE_ID, $sc->getId());
$sc_tutors = ScheduleTutorPeer::doSelect($cd);
$schedule = new Schedule();
$schedule->setGradeComponentId($sc->getGradeComponentId());
$schedule->setAcademicCalendarId($accal_tujuan->getId());
$schedule->setType(2);
$schedule->setEmployeeId($sc->getEmployeeId());
$schedule->save();
foreach ($sc_details as $sc_detail) {
$schedule_detail = new ScheduleDetail();
$schedule_detail->setSchedule($schedule);
$schedule_detail->setLocationId($sc_detail->getLocationId());
$schedule_detail->setClassSessionId($sc_detail->getClassSessionId());
$schedule_detail->setDay($sc_detail->getDay());
$schedule_detail->save();
$cb = new Criteria();
$cb->add(StudentRaportPeer::GRADE_COMPONENT_ID, $sc->getGradeComponentId());
$cb->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $sc->getAcademicCalendarId());
$cb->add(StudentRaportPeer::SCHEDULE_DETAIL_ID, $sc_detail->getId());
$cb->add(StudentRaportPeer::SCHEDULE_ID, $sc->getId());
$stu_raports = StudentRaportPeer::doSelect($cb);
foreach ($stu_raports as $stu_raport) {
$sr = new StudentRaport();
$sr->setStudentId($stu_raport->getStudentId());
$sr->setAcademicCalendarId($accal_tujuan->getId());
$sr->setGradeComponentId($sc->getGradeComponentId());
$sr->setClassGroupId($sc->getClassGroupId());
$sr->setSchedule($schedule);
$sr->setScheduleDetail($schedule_detail);
$sr->save();
}
}
foreach ($sc_tutors as $sc_tutor) {
$schedule_tutor = new ScheduleTutor();
$schedule_tutor->setSchedule($schedule);
$schedule_tutor->setEmployeeId($sc_tutor->getEmployeeId());
$schedule_tutor->save();
}
}
}
return $this->redirect('extracurricular/list');
}
public function executeSaveEksSmp()
{
$academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id'));
$this->forward404Unless($academic_calendar);
$schedule = SchedulePeer::retrieveByPk($this->getRequestParameter('schedule_id'));
$this->forward404Unless($schedule);
$schedule_detail = ScheduleDetailPeer::retrieveByPk($this->getRequestParameter('detail_id'));
$this->forward404Unless($schedule_detail);
$class_group = ClassGroupPeer::retrieveByPK($this->getRequestParameter('class_id'));
$this->forward404Unless($class_group);
$student_list_ser = $this->getRequestParameter('student_list_ser');
$params = array();
foreach (explode('&', $this->getRequestParameter('student_list_ser')) as $p) {
$p = explode('=', $p);
$params[rawurldecode($p[0])][] = rawurldecode($p[1]);
}
if (array_key_exists('students', $params)) {
foreach ($params['students'] as $student_id) {
$cr = new Criteria();
$cr->add(StudentRaportPeer::GRADE_COMPONENT_ID, $schedule->getGradeComponentId());
$cr->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $schedule->getAcademicCalendarId());
$cr->add(StudentRaportPeer::SCHEDULE_DETAIL_ID, $schedule_detail->getId());
$cr->add(StudentRaportPeer::SCHEDULE_ID, $schedule->getId());
$cr->add(StudentRaportPeer::CLASS_GROUP_ID, $class_group->getId());
$cr->add(StudentRaportPeer::STUDENT_ID, $student_id);
$sc = StudentRaportPeer::doSelectOne($cr);
if ($sc == null) {
$sc = new StudentRaport();
}
$sc->setStudentId($student_id);
$sc->setAcademicCalendarId($schedule->getAcademicCalendarId());
$sc->setGradeComponentId($schedule->getGradeComponentId());
$sc->setClassGroupId($class_group->getId());
$sc->setScheduleId($schedule->getId());
$sc->setScheduleDetailId($schedule_detail->getId());
$sc->save();
}
}
$this->schedule = $schedule;
$this->schedule_detail = $schedule_detail;
$this->academic_calendar = $academic_calendar;
#return $this->redirect('counseling_sd/listEksStu?id='.$schedule->getId().'&detail_id='.$schedule_detail->getId().'&accal_id='.$academic_calendar->getId().'&counseling_id='.$counseling->getId());
$this->getRequest()->setParameter('accal_id', $academic_calendar->getId());
$this->getRequest()->setParameter('id', $schedule->getId());
$this->getRequest()->setParameter('detail_id', $schedule_detail->getId());
$this->forward($this->getModuleName(), 'listEksStu');
}
public function executeUpdate()
{
$params = array();
foreach (explode('&', $this->getRequestParameter('student_list_ser')) as $p) {
$p = explode('=', $p);
$params[rawurldecode($p[0])][] = rawurldecode($p[1]);
}
if (array_key_exists('students', $params)) {
foreach ($params['students'] as $su_id) {
$sc = new StudentRaport();
$sc->setStudentId($su_id);
$sc->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id'));
$sc->setGradeComponentId($this->getRequestParameter('grade_component_id'));
$sc->setClassGroupId($this->getRequestParameter('class_group_id'));
$sc->setScheduleId($this->getRequestParameter('schedule_id'));
$sc->setScheduleDetailId($this->getRequestParameter('schedule_detail_id'));
$sc->save();
}
}
return $this->redirect('course_ekskul/list?id=' . $this->getRequestParameter('schedule_id') . '&detail_id=' . $this->getRequestParameter('schedule_detail_id'));
}
public function executeUpdateDevelopment()
{
$student_id = $this->getRequestParameter('student_id');
$student = StudentPeer::retrieveByPK($student_id);
$this->forward404Unless($student);
$this->student = $student;
$student_course = new StudentCourse();
$student_course->setStudentId($student->getId());
$student_course->setClassGroupId($student->getClassGroupId());
$student_course->setAcademicCalendarId($student->getAcademicCalendarId());
$student_course->setGradeComponentId($this->getRequestParameter('grade_component_id'));
$student_course->save();
$g = new StudentRaport();
$g->setStudentCourse($student_course);
$g->setGradeComponentId($this->getRequestParameter('grade_component_id'));
$g->setGrade($this->getRequestParameter('grade'));
$g->save();
return $this->redirect('student_score/listDev?student_id=' . $student->getId());
}
