<table style="margin:15px 15px 0px 10px;"> <tr> <td style="font-size: 11px; border: 1px solid #2E2E2E;padding:3px 5px;font-weight:bold;"><?php echo __('Kategori Penilaian'); ?> </td> <td style="font-size: 11px; border: 1px solid #2E2E2E;padding:3px 5px;font-weight:bold;"><?php echo __('Urutan'); ?> </td> </tr> <?php foreach ($grade_specs as $sc) { $cm = new Criteria(); $cm->add(ScoreRuleObjectPeer::GRADE_SPEC_ID, $sc->getId()); $sc->rule = ScoreRuleSubjectPeer::doSelectOne($cm); ?> <tr> <td style="cursor:pointer;font-size: 11px; border: 1px solid #2E2E2E;padding:3px 5px;<?php if (!isset($sc->rule)) { echo "color: #888888;"; } else { echo "color: #2A00FF;"; } ?> " onclick=" if (this.style.color != 'rgb(136, 136, 136)') { // unse this.style.color = '#888888'; Element.remove('sub_'+this.id); this.innerHTML += '<input type=hidden name=delsub['+this.id+'] id=delsub_'+this.id+'>';
public function executeSave() { $score_rule_id = $this->getRequestParameter('id'); $score_rule = ScoreRulePeer::retrieveByPK($score_rule_id); $this->forward404Unless($score_rule); $subs = $this->getRequestParameter('sub'); foreach ($subs as $m => $sub) { $ids = split('_', $m); ## $ids [0] == Subject Curr Id ## $ids [1] == Score Rule Id $c = new Criteria(); $c->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $ids[1]); $c->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $ids[0]); $score_rule_subject = ScoreRuleSubjectPeer::doSelectOne($c); if ($score_rule_subject == null) { $score_rule_subject = new ScoreRuleSubject(); } $score_rule_subject->setSubjectCurrId($ids[0]); $score_rule_subject->setScoreRuleId($ids[1]); $score_rule_subject->setPublished(1); $score_rule_subject->save(); } $sequences = $this->getRequestParameter('sequence'); foreach ($sequences as $m => $sequence) { $ids = split('_', $m); ## $ids [0] == Subject Curr Id ## $ids [1] == Score Rule Id $c = new Criteria(); $c->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $ids[1]); $c->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $ids[0]); $score_rule_subject = ScoreRuleSubjectPeer::doSelectOne($c); if ($score_rule_subject == null) { $score_rule_subject = new ScoreRuleSubject(); } $score_rule_subject->setSubjectCurrId($ids[0]); $score_rule_subject->setScoreRuleId($ids[1]); $score_rule_subject->setSequence($sequence); $score_rule_subject->save(); } $parents = $this->getRequestParameter('parent'); foreach ($parents as $m => $parent) { if ($parent != null) { $ids = split('_', $m); ## $ids [0] == Subject Curr Id ## $ids [1] == Score Rule Id $c = new Criteria(); $c->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $ids[1]); $c->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $ids[0]); $score_rule_subject = ScoreRuleSubjectPeer::doSelectOne($c); if ($score_rule_subject == null) { $score_rule_subject = new ScoreRuleSubject(); } $score_rule_subject->setSubjectCurrId($ids[0]); $score_rule_subject->setScoreRuleId($ids[1]); $score_rule_subject->setParent($parent); $score_rule_subject->save(); } } $tipes = $this->getRequestParameter('tipe'); foreach ($tipes as $m => $tipe) { $ids = split('_', $m); ## $ids [0] == Subject Curr Id ## $ids [1] == Score Rule Id $c = new Criteria(); $c->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $ids[1]); $c->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $ids[0]); $score_rule_subject = ScoreRuleSubjectPeer::doSelectOne($c); if ($score_rule_subject == null) { $score_rule_subject = new ScoreRuleSubject(); } $score_rule_subject->setSubjectCurrId($ids[0]); $score_rule_subject->setScoreRuleId($ids[1]); $score_rule_subject->setSubjectType($tipe); $score_rule_subject->save(); } $delsubs = $this->getRequestParameter('delsub'); foreach ($delsubs as $m => $delsub) { $ids = split('_', $m); ## $ids [0] == Subject Curr Id ## $ids [1] == Score Rule Id $c = new Criteria(); $c->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $ids[1]); $c->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $ids[0]); $score_rule_subject = ScoreRuleSubjectPeer::doSelectOne($c); if ($score_rule_subject != null) { $score_rule_subject->delete(); } } return $this->redirect('score_rule_new/listSubject?rule_id=' . $score_rule->getId()); }
public function executePrintFinal2() { $counseling_id = $this->getRequestParameter('counseling_id'); $counseling = CounselingPeer::retrieveByPK($counseling_id); $this->forward404Unless($counseling); $academic_calendar = AcademicCalendarPeer::retrieveByPK($this->getRequestParameter('accal_id')); $this->forward404Unless($academic_calendar); $time = $this->getRequestParameter('time'); $time2 = $this->getRequestParameter('time2'); $tgl = $this->getRequestParameter('tgl_cetak'); $c = new Criteria(); $c->add(TempTablePeer::COUNSELING_ID, $counseling->getId()); $c->add(TempTablePeer::TIME, $time); $c->addJoin(VStudentActivePeer::ID, TempTablePeer::STUDENT_ID); $c->addAscendingOrderByColumn(VStudentActivePeer::CLASS_NAME); $students = VStudentActivePeer::doSelect($c); $this->forward404Unless($students); ## Daftar Mata Pelajaran di Jadwal Pelajaran $cw = new Criteria(); $cw->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cw->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $subjects = VCoursePeer::doSelect($cw); $course_ids = array(); $subject_ids = array(); foreach ($subjects as $subject) { $subject_ids[] = $subject->getSubjectCurrId(); $course_ids[$subject->getSubjectCurrId()] = $subject->getId(); } $this->subjects = $subjects; $this->course_ids = $course_ids; ## Menentukan Aturan Penilaian (Akhir Semester) $cd = new Criteria(); $cd->add(ScoreRulePeer::CLASS_GROUP_ID, $counseling->getClassGroup()->getParent()); $cd->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $cd->add(ScoreRulePeer::TYPE, ScoreRule::TYPE_TWO); $score_rule = ScoreRulePeer::doSelectOne($cd); $this->score_rule = $score_rule; ## Menentukan Aturan Penilaian (Tengah Semester) $cd = new Criteria(); $cd->add(ScoreRulePeer::CLASS_GROUP_ID, $counseling->getClassGroup()->getParent()); $cd->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $cd->add(ScoreRulePeer::TYPE, ScoreRule::TYPE_ONE); $cd->add(ScoreRulePeer::CLASS_TYPE_ID, $counseling->getClassTypeId()); $score_rule = ScoreRulePeer::doSelectOne($cd); $this->score_rule = $score_rule; ## Memunculkan semua mata pelajaran yang ada di aturan penilaian ## Mengelompokannya untuk kelompok A $cm = new Criteria(); $cm->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cm->add(ScoreRuleSubjectPeer::PUBLISHED, ScoreRule::ONE, Criteria::IN); #$cm->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $cton1 = $cm->getNewCriterion(ScoreRuleSubjectPeer::SUBJECT_TYPE, ScoreRuleSubject::SUBJECT_ONE, Criteria::IN); $cton2 = $cm->getNewCriterion(ScoreRuleSubjectPeer::SUBJECT_TYPE, ScoreRuleSubject::SUBJECT_THREE, Criteria::IN); $cton1->addOr($cton2); $cm->add($cton1); $cm->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $list_subs = ScoreRuleSubjectPeer::doSelect($cm); $subject_count = ScoreRuleSubjectPeer::doCount($cm); $this->list_subs = $list_subs; $this->subject_count = $subject_count; ## Memunculkan semua mata pelajaran yang ada di aturan penilaian ## Mengelompokannya untuk kelompok B $cmt = new Criteria(); $cmt->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cmt->add(ScoreRuleSubjectPeer::PUBLISHED, ScoreRule::ONE, Criteria::IN); $cmt->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, ScoreRuleSubject::SUBJECT_TWO, Criteria::IN); $cmt->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $list_subject = ScoreRuleSubjectPeer::doSelect($cmt); $subj_count = ScoreRuleSubjectPeer::doCount($cmt); $this->list_subject = $list_subject; $this->subj_count = $subj_count; $cmti = new Criteria(); $cmti->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cmti->add(ScoreRuleSubjectPeer::PUBLISHED, ScoreRule::ONE, Criteria::IN); $cmti->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, 5, Criteria::IN); $cmti->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $group_b = ScoreRuleSubjectPeer::doSelectOne($cmti); $this->group_b = $group_b; $cte = new Criteria(); $cte->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cte->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $stuaccals = StudentAccalPeer::doSelect($cte); $this->stuaccals = $stuaccals; $stuaccal_id = array(); foreach ($stuaccals as $stuaccal) { $stuaccal_id[$stuaccal->getStudentId()] = $stuaccal->getId(); } $this->stuaccal_id = $stuaccal_id; ## Mengelompokkan Penilaian Pengetahuan berdasarkan Tahun Ajaran dan Kelas $cr = new Criteria(); $stugrades = StudentGradeRaportPeer::doSelect($cr); $this->stugrades = $stugrades; $grades = array(); $grades_value = array(); $remarks = array(); $grade_avg = array(); foreach ($stugrades as $stugrade) { $grades[$stugrade->getStudentAccalId() . '#' . $stugrade->getCourseScheduleId() . '#' . $stugrade->getGradeSpecId()] = $stugrade->getGrade(); $grades_value[$stugrade->getStudentAccalId() . '#' . $stugrade->getCourseScheduleId() . '#' . $stugrade->getGradeSpecId()] = $stugrade->getGradeValue(); $remarks[$stugrade->getStudentAccalId() . '#' . $stugrade->getCourseScheduleId() . '#' . $stugrade->getGradeSpecId()] = $stugrade->getRemark(); $grade_avg[$stugrade->getCourseScheduleId() . '#' . $stugrade->getGradeSpecId()] = (array_key_exists($stugrade->getCourseScheduleId() . '#' . $stugrade->getGradeSpecId(), $grade_avg) ? $grade_avg[$stugrade->getCourseScheduleId() . '#' . $stugrade->getGradeSpecId()] : 0) + $stugrade->getGradeValue(); } $this->grades = $grades; $this->grade_avg = $grade_avg; $this->grades_value = $grades_value; $this->remarks = $remarks; $cmi = new Criteria(); $cmi->add(GradeConversionPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId()); $cmi->add(GradeConversionPeer::TYPE_CONVERSION, GradeConversion::TYPE_ALL); $grade_conversions = GradeConversionPeer::doSelect($cmi); $grade_select = array(); $detail_select = array(); foreach ($grade_conversions as $grade_conv) { $grade_select[$grade_conv->getName()] = $grade_conv->getDescription(); $detail_select[$grade_conv->getName()] = $grade_conv->getDetail(); } $this->detail_select = $detail_select; $this->grade_select = $grade_select; $this->grade_conversions = $grade_conversions; $cmit = new Criteria(); $cmit->add(GradeConversionPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId()); $grade_convs = GradeConversionPeer::doSelect($cmit); $remark_select = array(); $name_select = array(); $descript_select = array(); foreach ($grade_convs as $grade_conve) { $remark_select[$grade_conve->getName() . '#' . $grade_conve->getTypeConversion()] = $grade_conve->getDescription(); $name_select[$grade_conve->getGrade() . '#' . $grade_conve->getTypeConversion()] = $grade_conve->getName(); $descript_select[$grade_conve->getGrade() . '#' . $grade_conve->getTypeConversion()] = $grade_conve->getDetail(); } $cbt = new Criteria(); $cbt->add(GradeConversionPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId()); $cbt->add(GradeConversionPeer::TYPE_CONVERSION, GradeConversion::TYPE_KNOWLEDGE); $know_convs = GradeConversionPeer::doSelect($cbt); $this->know_convs = $know_convs; $cbti = new Criteria(); $cbti->add(GradeConversionPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId()); $cbti->add(GradeConversionPeer::TYPE_CONVERSION, GradeConversion::TYPE_SKILL); $skill_convs = GradeConversionPeer::doSelect($cbti); $this->skill_convs = $skill_convs; $this->name_select = $name_select; $this->remark_select = $remark_select; $this->grade_conversions = $grade_conversions; ## Penilaian Habit $cmi = new Criteria(); $cmi->add(StudentHabitPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cmi->add(StudentHabitPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $student_habits = StudentHabitPeer::doSelect($cmi); $habit = array(); foreach ($student_habits as $student_habit) { $habit[$student_habit->getGradeComponentId() . '#' . $student_habit->getStudentId()] = $student_habit; } $this->student_habits = $student_habits; $this->habit = $habit; $cwi = new Criteria(); $cwi->add(CourseRegulationPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cwi->add(CourseRegulationPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $c_regulations = CourseRegulationPeer::doSelect($cwi); $course_reg = array(); foreach ($c_regulations as $cr) { $course_reg[$cr->getAcademicCalendarId() . '#' . $cr->getSubjectCurrId() . '#' . $cr->getClassGroupId()] = $cr->getKkm(); } $this->c_regulations = $c_regulations; $this->course_reg = $course_reg; ## Ekskul $cwe = new Criteria(); $cwe->add(GradeComponentPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId(), Criteria::IN); $cton1 = $cwe->getNewCriterion(GradeComponentPeer::GRADE_SPEC_ID, 20, Criteria::IN); $cton2 = $cwe->getNewCriterion(GradeComponentPeer::PUBLISHED, 1, Criteria::IN); $cton1->addAnd($cton2); $cwe->add($cton1); $this->grade_components = GradeComponentPeer::doSelect($cwe); $this->grade_count = GradeComponentPeer::doCount($cwe); $this->course_reg = $course_reg; $ce = new Criteria(); $ce->add(DepartmentDetailPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $this->department_detail = DepartmentDetailPeer::doSelectOne($ce); $cb = new Criteria(); $cb->add(StudentAbsencePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cb->addGroupByColumn(StudentAbsencePeer::STUDENT_ID); $cb->addGroupByColumn(StudentAbsencePeer::START); $cb->addGroupByColumn(StudentAbsencePeer::ACADEMIC_CALENDAR_ID); $cb->addGroupByColumn(StudentAbsencePeer::CLASS_GROUP_ID); $sas = StudentabsencePeer::doSelect($cb); $absence = array(); if (count($sas)) { foreach ($sas as $sa) { $absence[$sa->getStatus() . '#' . $sa->getStudentId()] = (array_key_exists($sa->getStatus() . '#' . $sa->getStudentId(), $absence) ? $absence[$sa->getStatus() . '#' . $sa->getStudentId()] : 0) + 1; } } $this->absence = $absence; $cmot = new Criteria(); $cmot->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cmot->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cmot->addJoin(StudentPeer::ID, StudentAccalPeer::STUDENT_ID); $this->student_count = StudentPeer::doCount($cmot); $this->students = $students; $this->subtitle = ''; $this->counseling = $counseling; $this->tanggal = $time; $this->tgl_cetak = $tgl; $this->time2 = $time2; $this->academic_calendar = $academic_calendar; $this->orientation = 'portrait'; $this->papersize = 'a4'; $this->setViewClass('sfDomPDF'); }