public function executeUploadFinish() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $this->employee_id = $employee_id; $this->employee = $employee; $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $actions = array(); $this->actions = $actions; $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - (' . $course_schedule->getClassGroup()->toString() . ' # ' . $course_schedule->getAcademicCalendar()->getName() . ')'; $this->type = 'edit'; $this->course_schedule = $course_schedule; $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 1); $cr->addAscendingOrderByColumn(GradeSpecPeer::ID); $this->grade1 = GradeSpecPeer::doSelect($cr); $this->count1 = GradeSpecPeer::doCount($cr); $cw = new Criteria(); $cw->add(GradeSpecPeer::PARENT, 7); $cw->addAscendingOrderByColumn(GradeSpecPeer::ID); $this->grade2 = GradeSpecPeer::doSelect($cw); $this->count2 = GradeSpecPeer::doCount($cw); $cm = new Criteria(); $cm->addJoin(StudentAccalPeer::STUDENT_ID, VStudentActivePeer::ID); $cm->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cm->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c = new Criteria(); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addJoin(VStudentActivePeer::ID, StudentAccalPeer::STUDENT_ID); $c->addJoin(StudentPeer::ID, VStudentActivePeer::ID); $c->addAscendingOrderByColumn(StudentPeer::CLASS_NAME); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('Student', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $this->student_count = StudentAccalPeer::doCount($cm); }
public function executeUpdate() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $schedule = new Schedule(); } else { $schedule = SchedulePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($schedule); } $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $schedule->setId($this->getRequestParameter('id')); $schedule->setSubjectCurrId($course_schedule->getSubjectCurrId()); $schedule->setClassGroupId($course_schedule->getClassGroupId()); $schedule->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $schedule->setDay($this->getRequestParameter('day')); $schedule->setName($this->getRequestParameter('name')); $schedule->setSemester($this->getRequestParameter('semester')); $schedule->setKkm($this->getRequestParameter('kkm')); $schedule->setType(1); $schedule->setClassSessionId($this->getRequestParameter('class_session_id')); $c = new Criteria(); $c->add(CourseScheduleTutorPeer::COURSE_SCHEDULE_ID, $course_schedule->getId()); $cst = CourseScheduleTutorPeer::doSelectOne($c); if ($employee->getStaffTypeId() != 21) { $schedule->setEmployeeId($this->getRequestParameter('employee_id')); } else { $schedule->setEmployeeId($cst->getEmployeeId()); } #$schedule->setEmployeeId($this->getRequestParameter('employee_id')); $schedule->setLocationId($this->getRequestParameter('location_id')); $schedule->setGradeSpecId($this->getRequestParameter('grade_spec_id')); $schedule->setDate($this->getRequestParameter('date')); $schedule->setDetail($this->getRequestParameter('detail')); $schedule->save(); /* SMS Add */ if (SF_ENVIRONMENT == 'dev') { if ($this->getRequestParameter('send_message') == 1) { $lekarSms = new lekarSms(); $userType = $this->getContext()->getUser()->getAttribute('usertype', '', 'bo'); $lekarSms->sendSmsCourseTest($schedule, $userType); } } /* --- */ return $this->redirect('course_test/list?course_id=' . $course_schedule->getId()); }
public function executeListRecapt() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $this->course_schedule = $course_schedule; $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); #array_unshift($actions, array('name'=>'Print Excel','url'=>"course_sd/listRecaptAsCSV?course_id=".$course_schedule->getId(), 'color'=>'black', 'type'=>'direct')); #array_unshift($actions, array('name'=>'Print PDF','url'=>"course_sd/listRecaptAsPDF?course_id=".$course_schedule->getId(), 'color'=>'black', 'type'=>'direct')); $this->actions = $actions; ## Mengambil Kompetensi Dasar Untuk KI.3 $cur13_ki = ScoreRule::THREE; $ct = new Criteria(); $ct->add(Cur13TermPeer::CUR13_KI_ID, $cur13_ki); $ct->add(Cur13TermPeer::COURSE_SCHEDULE_ID, $course_schedule->getId()); $cur13_terms = Cur13TermPeer::doSelect($ct); $cur13_term_count = Cur13TermPeer::doCount($ct); $this->cur13_terms = $cur13_terms; $this->cur13_term_count = $cur13_term_count; $actions2 = array(array('name' => '<span>Penilaian 2013</span>', 'url' => 'course_sd/list?accal_id=' . $course_schedule->getAcademicCalendarId() . '&class_id=' . $course_schedule->getClassGroupId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Proses Nilai KI.3 (Pengetahuan)</span>', 'url' => 'course_sd/listRecapt?course_id=' . $course_schedule->getId(), 'color' => 'sun', 'type' => 'direct')); array_push($actions2, array('name' => '<span>Proses Nilai KI.4 (Keterampilan)</span>', 'url' => 'course_sd/listRecaptKi4?course_id=' . $course_schedule->getId(), 'color' => 'sky')); $this->actions2 = $actions2; $this->subtitle = $course_schedule->getAcademicCalendar()->getName() . ' # ' . $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - id:' . $course_schedule->getId(); $this->type = 'edit'; $this->cur13_ki = $cur13_ki; $this->title = 'Proses Nilai Raport KI.3 (Pengetahuan)'; $c = new Criteria(); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addJoin(StudentPeer::ID, StudentAccalPeer::STUDENT_ID); $c->add(StudentPeer::STATUS, Student::STATUS_ACTIVE); $c->addAscendingOrderByColumn(StudentPeer::CLASS_NAME); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('Student', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; ## Mengambil Student Accal Id $cm = new Criteria(); $cm->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cm->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $stu_accals = StudentAccalPeer::doSelect($cm); $student_accal_id = array(); foreach ($stu_accals as $stu_accal) { $student_accal_id[$stu_accal->getStudentId()] = $stu_accal->getId(); } $this->student_accal_id = $student_accal_id; $cri = new Criteria(); $stuterms = Cur13GradeTermPeer::doSelect($cri); $this->stuterms = $stuterms; $grade_scale = array(); $grade_value = array(); $remark = array(); foreach ($stuterms as $stuterm) { $grade_scale[$stuterm->getStudentAccalId() . '#' . $stuterm->getCur13TermId()] = $stuterm->getGradeScale(); $grade_value[$stuterm->getStudentAccalId() . '#' . $stuterm->getCur13TermId()] = $stuterm->getGrade(); $remark[$stuterm->getStudentAccalId() . '#' . $stuterm->getCur13TermId()] = $stuterm->getRemark(); } $this->grade_scale = $grade_scale; $this->grade_value = $grade_value; $this->remark = $remark; $ct = new Criteria(); $ct->add(GradeConversionPeer::GRADE_CONVERSION_TEMPLATE_ID, 17); $grade_convs = GradeConversionPeer::doSelect($ct); $descript_select = array(); foreach ($grade_convs as $grade_conv) { $descript_select[$grade_conv->getName()] = $grade_conv->getDescription(); } $this->descript_select = $descript_select; }
public function executeListRecaptAfective() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $this->employee_id = $employee_id; $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $c = new Criteria(); $c->addJoin(VStudentAccalPeer::STUDENT_ID, VStudentActivePeer::ID); $c->add(VStudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(VStudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addAscendingOrderByColumn(VStudentAccalPeer::CLASS_NAME); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('VStudentAccal', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $this->student_count = VStudentAccalPeer::doCount($c); $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); $this->actions = $actions; $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - (' . $course_schedule->getClassGroup()->toString() . ' # ' . $course_schedule->getAcademicCalendar()->getName() . ')'; $this->type = 'edit'; $this->course_schedule = $course_schedule; ##Nilai Observasi $cr = new Criteria(); $cr->add(GradeSpecPeer::CODE, 'Obs', Criteria::IN); $cr->addAscendingOrderByColumn(GradeSpecPeer::ID); $prakteks = GradeSpecPeer::doSelect($cr); $prakteks_ids = array(); foreach ($prakteks as $praktek) { $prakteks_ids[] = $praktek->getId(); } $this->prakteks = $prakteks; $this->prakteks_ids = $prakteks_ids; ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $cr = new Criteria(); $cr->add(StudentGradeRaportPeer::COURSE_SCHEDULE_ID, $course_schedule->getId(), Criteria::IN); $cr->add(StudentGradeRaportPeer::GRADE_SPEC_ID, $prakteks_ids, Criteria::IN); $stugrades = StudentGradeRaportPeer::doSelect($cr); $this->stugrades = $stugrades; $student_avg = array(); $student_total = array(); foreach ($stugrades as $stugrade) { $student_avg[$stugrade->getStudentAccalId()] = (array_key_exists($stugrade->getStudentAccalId(), $student_avg) ? $student_avg[$stugrade->getStudentAccalId()] : 0) + $stugrade->getGrade(); $student_total[$stugrade->getStudentAccalId()] = (array_key_exists($stugrade->getStudentAccalId(), $student_total) ? $student_total[$stugrade->getStudentAccalId()] : 0) + 1; } $this->student_avg = $student_avg; $this->student_total = $student_total; #End Nilai Observasi ##Nilai Diri Sendiri $cri = new Criteria(); $cri->add(GradeSpecPeer::CODE, 'Diri', Criteria::IN); $cri->addAscendingOrderByColumn(GradeSpecPeer::ID); $projects = GradeSpecPeer::doSelect($cri); $projects_ids = array(); foreach ($projects as $project) { $projects_ids[] = $project->getId(); } $this->projects = $projects; $this->projects_ids = $projects_ids; ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $crm = new Criteria(); $crm->add(StudentGradeRaportPeer::COURSE_SCHEDULE_ID, $course_schedule->getId(), Criteria::IN); $crm->add(StudentGradeRaportPeer::GRADE_SPEC_ID, $projects_ids, Criteria::IN); $stuprojects = StudentGradeRaportPeer::doSelect($crm); $this->stugrades = $stuprojects; $project_avg = array(); $project_total = array(); foreach ($stuprojects as $stuproject) { $project_avg[$stuproject->getStudentAccalId()] = (array_key_exists($stuproject->getStudentAccalId(), $project_avg) ? $project_avg[$stuproject->getStudentAccalId()] : 0) + $stuproject->getGrade(); $project_total[$stuproject->getStudentAccalId()] = (array_key_exists($stuproject->getStudentAccalId(), $project_total) ? $project_total[$stuproject->getStudentAccalId()] : 0) + 1; } $this->project_avg = $project_avg; $this->project_total = $project_total; #End Nilai Diri ##Nilai Antar Teman $crt = new Criteria(); $crt->add(GradeSpecPeer::CODE, 'Antar', Criteria::IN); $crt->addAscendingOrderByColumn(GradeSpecPeer::ID); $portfolios = GradeSpecPeer::doSelect($crt); $portfolio_ids = array(); foreach ($portfolios as $portfolio) { $portfolio_ids[] = $portfolio->getId(); } $this->portfolios = $portfolios; $this->portfolio_ids = $portfolio_ids; ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $crn = new Criteria(); $crn->add(StudentGradeRaportPeer::COURSE_SCHEDULE_ID, $course_schedule->getId(), Criteria::IN); $crn->add(StudentGradeRaportPeer::GRADE_SPEC_ID, $portfolio_ids, Criteria::IN); $stuportfolios = StudentGradeRaportPeer::doSelect($crn); $this->stuportfolios = $stuportfolios; $portfolio_avg = array(); $portfolio_total = array(); foreach ($stuportfolios as $stuportfolio) { $portfolio_avg[$stuportfolio->getStudentAccalId()] = (array_key_exists($stuportfolio->getStudentAccalId(), $portfolio_avg) ? $portfolio_avg[$stuportfolio->getStudentAccalId()] : 0) + $stuportfolio->getGrade(); $portfolio_total[$stuportfolio->getStudentAccalId()] = (array_key_exists($stuportfolio->getStudentAccalId(), $portfolio_total) ? $portfolio_total[$stuportfolio->getStudentAccalId()] : 0) + 1; } $this->portfolio_avg = $portfolio_avg; $this->portfolio_total = $portfolio_total; #End Nilai Antar teman ##Nilai Jurnal Guru $crw = new Criteria(); $crw->add(GradeSpecPeer::CODE, 'JG', Criteria::IN); $crw->addAscendingOrderByColumn(GradeSpecPeer::ID); $jurnals = GradeSpecPeer::doSelect($crw); $jurnal_ids = array(); foreach ($jurnals as $jurnal) { $jurnal_ids[] = $jurnal->getId(); } $this->jurnals = $jurnals; $this->jurnal_ids = $jurnal_ids; ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $cro = new Criteria(); $cro->add(StudentGradeRaportPeer::COURSE_SCHEDULE_ID, $course_schedule->getId(), Criteria::IN); $cro->add(StudentGradeRaportPeer::GRADE_SPEC_ID, $jurnal_ids, Criteria::IN); $stujurnals = StudentGradeRaportPeer::doSelect($cro); $this->stujurnals = $stujurnals; $jurnal_avg = array(); $jurnal_total = array(); foreach ($stujurnals as $stujurnal) { $jurnal_avg[$stujurnal->getStudentAccalId()] = (array_key_exists($stujurnal->getStudentAccalId(), $jurnal_avg) ? $jurnal_avg[$stujurnal->getStudentAccalId()] : 0) + $stujurnal->getGrade(); $jurnal_total[$stujurnal->getStudentAccalId()] = (array_key_exists($stujurnal->getStudentAccalId(), $jurnal_total) ? $jurnal_total[$stujurnal->getStudentAccalId()] : 0) + 1; } $this->jurnal_avg = $jurnal_avg; $this->jurnal_total = $jurnal_total; #End Nilai Jurnal Guru $cem = new Criteria(); $cem->add(CourseRegulationPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cem->add(CourseRegulationPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cem->add(CourseRegulationPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $course_reg = CourseRegulationPeer::doSelectOne($cem); $this->course_reg = $course_reg; $cti = new Criteria(); $cti->add(FormulaPeer::FORMULA_TYPE, Formula::TYPE_AFEKTIF); $formula = FormulaPeer::doSelectOne($cti); $this->formula = $formula; $actions2 = array(array('name' => '<span>Nilai Sikap Per Kategori</span>', 'url' => 'course_afective/listAfective?course_id=' . $course_schedule->getId(), 'color' => 'sky')); array_unshift($actions2, array('name' => '<span>' . $course_schedule->getAcademicCalendar()->getName() . '</span>', 'url' => 'course_score_new/list', 'color' => 'sky')); array_push($actions2, array('name' => '<span>Nilai Sikap Keseluruhan</span>', 'url' => 'course_afective/listAllAfective?course_id=' . $course_schedule->getId(), 'color' => 'sky')); array_push($actions2, array('name' => '<span>Rekap Nilai Sikap</span>', 'url' => 'course_afective/listRecaptAfective?course_id=' . $course_schedule->getId(), 'color' => 'sun', 'type' => 'direct')); $this->actions2 = $actions2; $cb = new Criteria(); $cb->add(GradeConversionPeer::DEPARTMENT_ID, $course_schedule->getAcademicCalendar()->getDepartmentId()); $cb->add(GradeConversionPeer::TYPE_CONVERSION, GradeConversion::TYPE_AFEKTIF); $grade_convs = GradeConversionPeer::doSelect($cb); $grade_select = array(); foreach ($grade_convs as $grade_conv) { $grade_select[$grade_conv->getGrade()] = $grade_conv->getName(); } $this->grade_select = $grade_select; $this->grade_convs = $grade_convs; $this->title = 'Rekap Nilai Sikap'; $this->tipe = 'afective'; $this->setTemplate('listRecapt'); }
public function executePrintTryout() { $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 45); $this->grade = GradeSpecPeer::doSelect($cr); $this->count = GradeSpecPeer::doCount($cr); $cd = new Criteria(); $cd->add(StudentTryoutPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cd->add(StudentTryoutPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cd->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $stugrades = StudentTryoutPeer::doSelect($cd); $grades = array(); $grade_avg = array(); foreach ($stugrades as $stugrade) { $grades[$stugrade->getStudentId() . '#' . $stugrade->getGradeSpecId()] = $stugrade->getGrade(); $grade_avg[$stugrade->getStudentId() . '#' . $stugrade->getGradeSpecId()] = (array_key_exists($stugrade->getStudentId() . '#' . $stugrade->getGradeSpecId(), $grade_avg) ? $grade_avg[$stugrade->getStudentId() . '#' . $stugrade->getGradeSpecId()] : 0) + $stugrade->getGrade(); } $this->grades = $grades; $this->grade_avg = $grade_avg; $c = new Criteria(); $c->addJoin(VStudentAccalPeer::STUDENT_ID, VStudentActivePeer::ID); $c->add(VStudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(VStudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addAscendingOrderByColumn(VStudentAccalPeer::CLASS_NAME); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('VStudentAccal', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $this->student_count = VStudentAccalPeer::doCount($c); $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - ' . $course_schedule->getClassGroup()->toString(); $this->course_schedule = $course_schedule; $cem = new Criteria(); $cem->add(CourseRegulationPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cem->add(CourseRegulationPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cem->add(CourseRegulationPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $course_reg = CourseRegulationPeer::doSelectOne($cem); $this->course_reg = $course_reg; $this->papersize = 'a4'; $this->setLayout(false); $this->orientation = 'potrait'; $this->setViewClass('sfDomPDF'); }
public function executeUpdate() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $tanggal = $this->getRequestParameter('thn') . '-' . $this->getRequestParameter('bln') . '-' . $this->getRequestParameter('tgl'); $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $class_counseling = new ClassCounseling(); } else { $class_counseling = ClassCounselingPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($class_counseling); } $class_counseling->setId($this->getRequestParameter('id')); $class_counseling->setCourseScheduleId($this->getRequestParameter('course_schedule_id')); $class_counseling->setDetail($this->getRequestParameter('detail')); $class_counseling->setAction($this->getRequestParameter('action_desc')); $class_counseling->setStatus($this->getRequestParameter('status')); $class_counseling->setStudentId($this->getRequestParameter('student_id')); $class_counseling->setCounselingStatusId($this->getRequestParameter('counseling_status_id')); $class_counseling->setGrade($this->getRequestParameter('grade')); $class_counseling->setReward($this->getRequestParameter('reward')); $class_counseling->setTimeReport($tanggal); $cs = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_schedule_id')); $this->forward404Unless($cs); $c = new Criteria(); $c->add(CourseScheduleTutorPeer::COURSE_SCHEDULE_ID, $cs->getId()); $cst = CourseScheduleTutorPeer::doSelectOne($c); if ($employee->getStaffTypeId() != 21) { $class_counseling->setEmployeeId($this->getRequestParameter('employee_id')); } else { $class_counseling->setEmployeeId($cst->getEmployeeId()); } $class_counseling->setClassGroupId($cs->getClassGroupId()); $class_counseling->save(); return $this->redirect('course_counseling/list?course_id=' . $this->getRequestParameter('course_schedule_id')); }
public function executeShowCounseling() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $class_counseling = ClassCounselingPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($class_counseling); $this->subtitle = $class_counseling->toString() . ' - id:' . $class_counseling->getId(); $actions = array(array('name' => 'back', 'url' => 'course_counseling/list?course_id=' . $course_schedule->getId(), 'color' => 'black')); $this->actions = $actions; $actions2 = array(array('name' => '<span>Riwayat Agenda Kelas</span>', 'url' => 'course_history/listAgenda?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_unshift($actions2, array('name' => '<span>Riwayat Akademik</span>', 'url' => 'course_history/list', 'color' => 'sun')); array_push($actions2, array('name' => '<span>Riwayat Absensi Kelas</span>', 'url' => 'course_history/listAbsence?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Riwayat Jadwal Tugas/Ulangan/PR</span>', 'url' => 'course_history/listSched?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Riwayat Bimbingan Konseling</span>', 'url' => 'course_history/listCounseling?course_id=' . $course_schedule->getId(), 'color' => 'sun', 'type' => 'direct')); $this->actions2 = $actions2; $this->class_counseling = $class_counseling; $this->course_schedule = $course_schedule; }
public function executeSave() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $class_agenda = new ClassAgenda(); } else { $class_agenda = ClassAgendaPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($class_agenda); } $class_agenda->setId($this->getRequestParameter('id')); $class_agenda->setCourseScheduleId($this->getRequestParameter('course_schedule_id')); $class_agenda->setDetail($this->getRequestParameter('detail')); if ($this->getRequestParameter('date')) { $class_agenda->setDate($this->getRequestParameter('date')); } $class_agenda->setStatus($this->getRequestParameter('status')); $class_agenda->setSubjectGradingId($this->getRequestParameter('subject_grading_id')); $class_agenda->setMeetingPoint($this->getRequestParameter('meeting_point')); $class_agenda->setActionType($this->getRequestParameter('action_type')); $class_agenda->setDay($this->getRequestParameter('day')); if ($this->getRequestParameter('class_group_id')) { $class_agenda->setClassGroupId($this->getRequestParameter('class_group_id')); } else { $cs = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_schedule_id')); $this->forward404Unless($cs); $class_agenda->setClassGroupId($cs->getClassGroupId()); } $class_agenda->setDescription($this->getRequestParameter('description')); $class_agenda->save(); #$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) { # $student_absence = new StudentAbsence(); # # $student_absence->setStudentId($su_id); # $student_absence->setStart($this->getRequestParameter('date')); # $student_absence->setEnd($this->getRequestParameter('date')); # $student_absence->setAcademicCalendarId($class_agenda->getCourseSchedule()->getAcademicCalendarId()); # $student_absence->setClassGroupId($this->getRequestParameter('class_group_id')); # $student_absence->save(); # } #} return $this->redirect('agenda/edit?id=' . $class_agenda->getId()); #return $this->forward('agenda', 'list'); #return $this->forward('agenda', 'edit?id='.$class_agenda->getId()); }
public function executeUpdateTest() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $schedule = new Schedule(); } else { $schedule = SchedulePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($schedule); } $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $schedule->setId($this->getRequestParameter('id')); $schedule->setSubjectCurrId($course_schedule->getSubjectCurrId()); $schedule->setClassGroupId($course_schedule->getClassGroupId()); $schedule->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $schedule->setDay($this->getRequestParameter('day')); $schedule->setName($this->getRequestParameter('name')); $schedule->setSemester($this->getRequestParameter('semester')); $schedule->setKkm($this->getRequestParameter('kkm')); $schedule->setType(1); $schedule->setClassSessionId($this->getRequestParameter('class_session_id')); $schedule->setEmployeeId($this->getRequestParameter('employee_id')); $schedule->setLocationId($this->getRequestParameter('location_id')); $schedule->setGradeSpecId($this->getRequestParameter('grade_spec_id')); $schedule->setDate($this->getRequestParameter('date')); $schedule->setDetail($this->getRequestParameter('detail')); $schedule->save(); return $this->redirect('course/test?employee_id=' . $employee_id . '&course_id=' . $course_schedule->getId()); }
public function executeUpdate() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); $subject_curr_id = $this->getRequestParameter('subject_curr_id'); $subject_curr = SubjectCurrPeer::retrieveByPK($subject_curr_id); $this->forward404Unless($subject_curr); $academic_calendar_id = $this->getRequestParameter('accal_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->forward404Unless($academic_calendar); $class_group_id = $this->getRequestParameter('class_group_id'); $class_group = ClassGroupPeer::retrieveByPK($class_group_id); $this->forward404Unless($class_group); $course_sched = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_sched); $cur13_term = Cur13TermPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($cur13_term); $cur13_term->setCourseScheduleId($course_sched->getId()); $cur13_term->setCode($this->getRequestParameter('code')); $cur13_term->setName($this->getRequestParameter('name')); $cur13_term->setDescription($this->getRequestParameter('description')); #$cur13_term->setCur13KiId($this->getRequestParameter('cur13_ki_id')); $cur13_term->save(); $spkis = $this->getRequestParameter('spki'); $bobot = $this->getRequestParameter('bobot'); foreach ($spkis as $l => $spki) { $ct = new Criteria(); $ct->add(Cur13TermSpecPeer::CUR13_TERM_ID, $cur13_term->getId()); $ct->add(Cur13TermSpecPeer::GRADE_SPEC_ID, $l); $cur13_ts = Cur13TermSpecPeer::doSelectOne($ct); if ($cur13_ts == null) { $cur13_ts = new Cur13TermSpec(); } $cur13_ts->setCur13TermId($cur13_term->getId()); $cur13_ts->setGradeSpecId($l); $cur13_ts->setBobot($bobot[$l]); $cur13_ts->save(); } $delspkis = $this->getRequestParameter('delspki'); foreach ($delspkis as $l => $delspki) { $ct = new Criteria(); $ct->add(Cur13TermSpecPeer::CUR13_TERM_ID, $cur13_term->getId()); $ct->add(Cur13TermSpecPeer::GRADE_SPEC_ID, $l); $cur13_ts = Cur13TermSpecPeer::doSelectOne($ct); if ($cur13_ts != null) { $cur13_ts->delete(); } } return $this->redirect('cur13_term/getSubject?subject_curr_id=' . $subject_curr->getId() . '&accal_id=' . $academic_calendar->getId() . '&class_group_id=' . $class_group->getId()); }
public function executeDeleteSubject() { $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($course_schedule); $accal_id = $this->getRequestParameter('accal_id'); $this->accal_id = $accal_id; $class_id = $this->getRequestParameter('class_id'); $this->class_id = $class_id; $ref_error = 0; foreach ($course_schedule->getRefCountMethods() as $ref) { $method = "count" . $ref['affix']; $count = $course_schedule->{$method}(); if ($count > 0) { ++$ref_error; $this->getRequest()->setError('course_sched/deleteSubject/' . sfInflector::camelize($ref['table']), $count); } } if ($ref_error > 0) { $this->getRequest()->setError('course_sched/deleteSubject', '_ERR_DELETE_ (' . $course_schedule->toString() . ' - id:' . $course_schedule->getId() . ')'); } else { $c = new Criteria(); $c->add(CourseScheduleTutorPeer::COURSE_SCHEDULE_ID, $course_sched->getId()); $cs_tutors = CourseScheduleTutorPeer::doSelect($c); foreach ($cs_tutors as $o) { $o->delete(); } $course_schedule->delete(); } return $this->redirect('course_sched/preview?class_group_id=' . $class_id . '&accal_id=' . $accal_id); }
public function executeDeleteLector() { $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->course_schedule = $course_schedule; $cs_tutor = CourseScheduleTutorPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($cs_tutor); $cs_tutor->delete(); return $this->redirect('course_schedule/detail?id=' . $course_schedule->getId() . '&accal_id=' . $course_schedule->getAcademicCalendarId() . '&semester=' . $course_schedule->getSemester() . '&class_id=' . $course_schedule->getClassGroupId()); }
public function executeSimpan() { $i18n = new sfI18N(); $i18n->initialize($this->getContext()); $i18n->setCulture($this->getUser()->getCulture()); $action_i18n = $i18n->globalMessageFormat->format('save as new'); $action_type = $this->getRequestParameter('action_type'); if ($action_type == $action_i18n || !$this->getRequestParameter('id')) { $class_agenda = new ClassAgenda(); } else { $class_agenda = ClassAgendaPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($class_agenda); } $class_agenda->setId($this->getRequestParameter('id')); $class_agenda->setCourseScheduleId($this->getRequestParameter('course_schedule_id')); $class_agenda->setDetail($this->getRequestParameter('detail')); if ($this->getRequestParameter('date')) { $class_agenda->setDate($this->getRequestParameter('date')); } $class_agenda->setStatus($this->getRequestParameter('status')); $class_agenda->setSubjectGradingId($this->getRequestParameter('subject_grading_id')); $class_agenda->setEmployeeId($this->getRequestParameter('employee_id')); $class_agenda->setMeetingPoint($this->getRequestParameter('meeting_point')); $class_agenda->setActionType($this->getRequestParameter('action_type')); $class_agenda->setDay($this->getRequestParameter('day')); $cs = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_schedule_id')); $this->forward404Unless($cs); $class_agenda->setClassGroupId($cs->getClassGroupId()); $class_agenda->setClassSessionId($this->getRequestParameter('subject_grading_id')); $class_agenda->setDescription($this->getRequestParameter('description')); $class_agenda->save(); if ($this->hasRequestParameter('file') && $this->getRequestParameter('file') != '' && $this->getRequestParameter('file') != null) { $fileName = $this->getRequestParameter('file'); $ca_file = new ClassAgendaFile(); $ca_file->setClassAgenda($class_agenda); $ca_file->setFile($fileName); $ca_file->save(); } if ($this->hasRequestParameter('file_1') && $this->getRequestParameter('file_1') != '' && $this->getRequestParameter('file_1') != null) { $fileName = $this->getRequestParameter('file_1'); $ca_file = new ClassAgendaFile(); $ca_file->setClassAgenda($class_agenda); $ca_file->setFile($fileName); $ca_file->save(); } if ($this->hasRequestParameter('file_2') && $this->getRequestParameter('file_2') != '' && $this->getRequestParameter('file_2') != null) { $fileName = $this->getRequestParameter('file_2'); $ca_file = new ClassAgendaFile(); $ca_file->setClassAgenda($class_agenda); $ca_file->setFile($fileName); $ca_file->save(); } if ($this->hasRequestParameter('file_3') && $this->getRequestParameter('file_3') != '' && $this->getRequestParameter('file_3') != null) { $fileName = $this->getRequestParameter('file_3'); $ca_file = new ClassAgendaFile(); $ca_file->setClassAgenda($class_agenda); $ca_file->setFile($fileName); $ca_file->save(); } if ($this->hasRequestParameter('file_4') && $this->getRequestParameter('file_4') != '' && $this->getRequestParameter('file_4') != null) { $fileName = $this->getRequestParameter('file_4'); $ca_file = new ClassAgendaFile(); $ca_file->setClassAgenda($class_agenda); $ca_file->setFile($fileName); $ca_file->save(); } if ($this->hasRequestParameter('file_5') && $this->getRequestParameter('file_5') != '' && $this->getRequestParameter('file_5') != null) { $fileName = $this->getRequestParameter('file_5'); $ca_file = new ClassAgendaFile(); $ca_file->setClassAgenda($class_agenda); $ca_file->setFile($fileName); $ca_file->save(); } return $this->redirect('course_agenda/listPicket?course_id=' . $this->getRequestParameter('course_schedule_id')); }
public function executeDeleteByEmployee() { $course_regulation = CourseRegulationPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($course_regulation); $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $ref_error = 0; foreach ($course_regulation->getRefCountMethods() as $ref) { $method = "count" . $ref['affix']; $count = $course_regulation->{$method}(); if ($count > 0) { ++$ref_error; $this->getRequest()->setError('course_regulation/deleteByEmployee/' . sfInflector::camelize($ref['table']), $count); } } if ($ref_error > 0) { $this->getRequest()->setError('course_regulation/deleteByEmployee', '_ERR_DELETE_ (' . $course_regulation->toString() . ' - id:' . $course_regulation->getId() . ')'); } else { $course_regulation->delete(); } return $this->redirect('course_regulation/listByEmployee?course_id=' . $course_schedule->getId()); }
public function executeListHistoryScore() { $student_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $student = StudentPeer::retrieveByPK($student_id); $this->forward404Unless($student); $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $c = new Criteria(); $c->addJoin(StudentAccalPeer::STUDENT_ID, VStudentActivePeer::ID); $c->add(StudentAccalPeer::STUDENT_ID, $student->getId()); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $student_accal = StudentAccalPeer::doSelectOne($c); $this->forward404Unless($student_accal); $this->student_accal = $student_accal; $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 1); $this->grade1 = GradeSpecPeer::doSelect($cr); $this->count1 = GradeSpecPeer::doCount($cr); $crew = new Criteria(); $crew->add(GradeSpecPeer::PARENT, 7); $this->grade2 = GradeSpecPeer::doSelect($crew); $this->count2 = GradeSpecPeer::doCount($crew); $actions = array(); $this->actions = $actions; $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - ' . $course_schedule->getClassGroup()->toString(); $this->type = 'list'; $this->course_schedule = $course_schedule; $this->course_schedule_id = $course_schedule_id; $this->student = $student; $actions2 = array(array('name' => '<span>' . $course_schedule->getAcademicCalendar()->getName() . '</span>', 'url' => 'student_agenda/listHistory', 'color' => 'sun')); array_push($actions2, array('name' => '<span>Agenda Kelas</span>', 'url' => 'student_agenda/listHistoryAgenda?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Absensi</span>', 'url' => 'student_agenda/listHistoryAbsence?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Jadwal Tugas/Ulangan/PR</span>', 'url' => 'student_agenda/listHistoryTest?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Penilaian</span>', 'url' => 'student_agenda/listHistoryScore?course_id=' . $course_schedule->getId(), 'color' => 'sun', 'type' => 'direct')); $this->actions2 = $actions2; }
public function executeShowSubject() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($course_schedule); $this->subtitle = $course_schedule->toString() . ' - id:' . $course_schedule->getId(); $actions = array(array('name' => 'back', 'url' => 'subject_plan/listSubject?class_id=' . $this->getRequestParameter('class_id') . '&accal_id=' . $this->getRequestParameter('accal_id'), 'color' => 'white')); $this->actions = $actions; $this->course_schedule = $course_schedule; }
public function executeDeleteAbsence() { $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $attendance_class = AttendanceClassPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($attendance_class); $tanggal = $this->getRequestParameter('time'); $c = new Criteria(); $c->add(StudentAbsencePeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentAbsencePeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentAbsencePeer::START, $tanggal); $absences = StudentAbsencePeer::doSelect($c); foreach ($absences as $absence) { $absence->delete(); } $attendance_class->delete(); return $this->redirect('course_absence/listShow?course_id=' . $course_schedule->getId()); }
public function executeListScoreAsCSV() { $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 1); $cr->addAscendingOrderByColumn(GradeSpecPeer::CODE); $this->grade1 = GradeSpecPeer::doSelect($cr); $this->count1 = GradeSpecPeer::doCount($cr); $cw = new Criteria(); $cw->add(GradeSpecPeer::PARENT, 7); $cw->addAscendingOrderByColumn(GradeSpecPeer::CODE); $this->grade2 = GradeSpecPeer::doSelect($cw); $this->count2 = GradeSpecPeer::doCount($cw); $cm = new Criteria(); $cm->addJoin(StudentAccalPeer::STUDENT_ID, VStudentActivePeer::ID); $cm->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cm->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c = new Criteria(); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addJoin(VStudentActivePeer::ID, StudentAccalPeer::STUDENT_ID); $c->addJoin(StudentPeer::ID, VStudentActivePeer::ID); $c->addAscendingOrderByColumn(StudentPeer::CLASS_NAME); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('Student', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $this->student_count = StudentAccalPeer::doCount($cm); $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - ' . $course_schedule->getClassGroup()->toString(); $this->course_schedule = $course_schedule; $this->setLayout(false); $this->getResponse()->setHttpHeader('Content-Type', 'text/csv'); $this->getResponse()->setHttpHeader('Content-Disposition', 'attachment; filename="' . $this->getModuleName() . '.csv"'); }
public function executeListScore() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $this->employee_id = $employee_id; $this->employee = $employee; $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $course_schedule_id = $course_schedule->getId(); $teacher_ids = array(); foreach ($course_schedule->getCourseScheduleTutors() as $teacher) { $teacher_ids[] = $teacher->getEmployeeId(); } $course_options = array(); $cr = new Criteria(); $cr->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $teacher_ids, Criteria::IN); $cr->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $cr->add(CourseSchedulePeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId(), Criteria::IN); $cr->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId(), Criteria::IN); $cr->addAscendingOrderByColumn(CourseSchedulePeer::ID); $courses = CourseSchedulePeer::doSelect($cr); foreach ($courses as $course) { $course_options[$course->getId()] = $course->getSubjectCurr()->getSubject()->getName(); } $this->course_options = $course_options; $c = new Criteria(); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addJoin(VStudentActivePeer::ID, StudentAccalPeer::STUDENT_ID); $c->addJoin(StudentPeer::ID, VStudentActivePeer::ID); $c->addAscendingOrderByColumn(StudentPeer::CLASS_NAME); $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student'); $pager = new sfPropelPager('Student', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student')); $this->getUser()->setAttribute('page', $page, 'student'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $this->student_count = StudentPeer::doCount($c); #$actions = array(array('name'=>'save','type'=>'submit', 'options'=>array('class'=>'save_button', 'onclick'=>"action_type.value=this.value")),); #array_push($actions, array('name'=>'kembali', 'url'=>'course/listScore?employee_id='.$employee_id,'color'=>'black')); $actions = array(); $this->actions = $actions; $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - ' . $course_schedule->getClassGroup()->toString(); $this->type = 'edit'; $this->course_schedule = $course_schedule; $this->course_schedule_id = $course_schedule_id; $actions2 = array(array('name' => '<span>Agenda Kelas</span>', 'url' => 'course_agenda/list2?course_id=' . $course_schedule->getId(), 'color' => 'sun')); if ($course_schedule->getAcademicCalendar()->getCourseModel() == 'A') { array_unshift($actions2, array('name' => '<span>' . $course_schedule->getAcademicCalendar()->getName() . '</span>', 'url' => 'course/listScore', 'color' => 'sun')); } else { array_unshift($actions2, array('name' => '<span>' . $course_schedule->getAcademicCalendar()->getName() . '</span>', 'url' => 'course/listScore2', 'color' => 'sun')); } array_push($actions2, array('name' => '<span>Absensi Kelas</span>', 'url' => 'course_absence/listShow?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Jadwal Tugas / Ulangan / PR</span>', 'url' => 'course_test/list?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Bimbingan Konseling</span>', 'url' => 'course_counseling/list?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Rumusan Penilaian</span>', 'url' => 'course_regulation/listByEmployee?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Penilaian</span>', 'url' => 'course_detail/listScore?course_id=' . $course_schedule->getId(), 'color' => 'sun', 'type' => 'direct')); array_push($actions2, array('name' => '<span>Rekap Penilaian</span>', 'url' => 'course_detail/listByEmployee?course_id=' . $course_schedule->getId(), 'color' => 'sun')); $this->actions2 = $actions2; }