public function getCustody() { $cr = new Criteria(); $cr->add(AcademicCalendarPeer::DEPARTMENT_ID, $this->getDepartmentId()); $cr->add(AcademicCalendarPeer::COURSE_MODEL, 'C'); $cr->add(AcademicCalendarPeer::CURR_SYSTEM_ID, 1); $parent = AcademicCalendarPeer::doSelectOne($cr); $c = new Criteria(); $c->add(CounselingTutorPeer::EMPLOYEE_ID, $this->getId()); $c->addJoin(CounselingPeer::ID, CounselingTutorPeer::COUNSELING_ID); $c->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $parent->getId()); $custody = CounselingPeer::doSelectOne($c); return $custody; }
public function executeGetListFinalAll() { $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->academic_calendar = $academic_calendar; $student_id = $this->getRequestParameter('student_id'); $student = StudentPeer::retrieveByPK($student_id); $this->forward404Unless($student); $this->student = $student; $c = new Criteria(); $c->add(StudentAccalPeer::STUDENT_ID, $student_id, Criteria::IN); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar_id, Criteria::IN); $stu_accal = StudentAccalPeer::doSelectOne($c); $this->stu_accal = $stu_accal; $cw = new Criteria(); $cw->add(CounselingPeer::CLASS_GROUP_ID, $stu_accal->getClassGroupId()); $cw->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counseling = CounselingPeer::doSelectOne($cw); $this->counseling = $counseling; $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); #SMP if ($academic_calendar->getDepartmentId() == 2) { $cb = new Criteria(); $cb->add(VCoursePeer::CLASS_GROUP_ID, $stu_accal->getClassGroupId(), Criteria::IN); $cb->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN); $cb->add(VCoursePeer::SUBJECT_CURR_ID, 316, Criteria::NOT_IN); $cb->addAscendingOrderByColumn(VCoursePeer::CODE); $this->subjects = VCoursePeer::doSelect($cb); $this->subject_count = VCoursePeer::doCount($cb); #SD } elseif ($academic_calendar->getDepartmentId() == 3) { $cb = new Criteria(); $cb->add(VCoursePeer::CLASS_GROUP_ID, $stu_accal->getClassGroupId(), Criteria::IN); $cb->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN); $cb->add(VCoursePeer::SUBJECT_GROUP_ID, 7, Criteria::IN); $cb->add(VCoursePeer::SUBJECT_CURR_ID, 319, Criteria::NOT_IN); $cb->add(VCoursePeer::SUBJECT_CURR_ID, 333, Criteria::NOT_IN); $cb->addAscendingOrderByColumn(VCoursePeer::CODE); $this->subjects7 = VCoursePeer::doSelect($cb); $subject_count7 = VCoursePeer::doCount($cb); $this->subject_count7 = $subject_count7; $cm = new Criteria(); $cm->add(VCoursePeer::CLASS_GROUP_ID, $stu_accal->getClassGroupId(), Criteria::IN); $cm->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId(), Criteria::IN); $cm->add(VCoursePeer::SUBJECT_GROUP_ID, 8, Criteria::IN); $cm->addAscendingOrderByColumn(VCoursePeer::CODE); $this->subjects8 = VCoursePeer::doSelect($cm); $subject_count8 = VCoursePeer::doCount($cm); $this->subject_count8 = $subject_count8; } $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('VCourse', $rpp); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $actions = array(array()); $this->actions = $actions; }
public function executeGetListScore() { $cur13Lib = new cur13Lib(); $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $class_group_id = $this->getRequestParameter('class_group_id'); $class_group = ClassGroupPeer::retrieveByPK($class_group_id); $this->forward404Unless($class_group); $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->forward404Unless($academic_calendar); ## Cek apakah Guru Tersebut merupakan Walas dari kelas ini $cf = new Criteria(); $cf->add(CounselingTutorPeer::EMPLOYEE_ID, $employee->getId()); $cf->addJoin(CounselingPeer::ID, CounselingTutorPeer::COUNSELING_ID); $cf->add(CounselingPeer::CLASS_GROUP_ID, $class_group->getId()); $cf->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counsel_tutor = CounselingPeer::doSelectOne($cf); $this->counsel_tutor = $counsel_tutor; $c = new Criteria(); if ($cur13Lib->isFullAccess($employee)) { $cf = new Criteria(); $cf->addJoin(CounselingPeer::ID, CounselingTutorPeer::COUNSELING_ID); $cf->add(CounselingPeer::CLASS_GROUP_ID, $class_group->getId()); $cf->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counsel_tutor = CounselingPeer::doSelectOne($cf); $this->counsel_tutor = $counsel_tutor; $c = new Criteria(); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId()); $c->addAscendingOrderByColumn(CourseSchedulePeer::CLASS_GROUP_ID); } else { $c = new Criteria(); $c->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee->getId(), Criteria::IN); $c->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId()); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); if (!$this->getRequest()->getParameter('sort') && !$this->getUser()->getAttribute('sort_field', null, 'course')) { $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addJoin(CourseSchedulePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addAscendingOrderByColumn(SubjectPeer::NAME); } } /* $c->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee->getId(), Criteria::IN); $c->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId(), Criteria::IN); ## Khusus Home Session $cton1 = $c->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 84, Criteria::NOT_IN); $cton2 = $c->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 85, Criteria::NOT_IN); $cton1->addAnd($cton2); $c->add($cton1); if (!$this->getRequest()->getParameter('sort') && !$this->getUser()->getAttribute('sort_field', null, 'course')) { $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addJoin(CourseSchedulePeer::SUBJECT_CURR_ID, SubjectCurrPeer::ID); $c->addAscendingOrderByColumn(SubjectPeer::NAME); } */ $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'course')); $this->getUser()->setAttribute('max_per_page', $rpp, 'course'); $pager = new sfPropelPager('CourseSchedule', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'course')); $this->getUser()->setAttribute('page', $page, 'course'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $cw = new Criteria(); $cw->add(CourseScheduleTutorPeer::EMPLOYEE_ID, $employee->getId(), Criteria::IN); $cw->addJoin(CourseSchedulePeer::ID, CourseScheduleTutorPeer::COURSE_SCHEDULE_ID); $cw->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cw->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId(), Criteria::IN); ## Khusus Home Session $cton1 = $cw->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 84, Criteria::NOT_IN); $cton2 = $cw->getNewCriterion(CourseSchedulePeer::SUBJECT_CURR_ID, 85, Criteria::NOT_IN); $cton1->addAnd($cton2); $cw->add($cton1); $cw->addAscendingOrderByColumn(CourseSchedulePeer::ID); $cw->setLimit(1); $course_schedule = CourseSchedulePeer::doSelectOne($cw); ## Menangkap satu ID Siswa $ct = new Criteria(); $ct->add(StudentAccalPeer::CLASS_GROUP_ID, $class_group->getId()); $ct->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $ct->addJoin(StudentPeer::ID, StudentAccalPeer::STUDENT_ID); $ct->add(StudentPeer::STATUS, 2, Criteria::NOT_EQUAL); $ct->add(StudentPeer::STATUS, 3, Criteria::NOT_EQUAL); $ct->addAscendingOrderByColumn(StudentPeer::NAME); $ct->setLimit(1); $student = StudentPeer::doSelectOne($ct); $this->student = $student; $this->setTemplate('getCourse'); $actions = array(); $this->actions = $actions; if ($academic_calendar->getCourseModel() == 'A') { $this->term = ScoreRule::ONE; } else { $this->term = ScoreRule::TWO; } $this->course_schedule = $course_schedule; $this->subtitle = $academic_calendar->toString() . ' # ' . $class_group->toString(); $this->employee_id = $employee_id; $this->employee = $employee; $this->academic_calendar = $academic_calendar; $this->class_group = $class_group; }
public function executeGetListEkskul() { $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->academic_calendar = $academic_calendar; $this->accal = $academic_calendar->getId(); $student_id = $this->getRequestParameter('student_id'); $student = StudentPeer::retrieveByPK($student_id); $this->forward404Unless($student); $this->student = $student; $c = new Criteria(); $c->add(StudentAccalPeer::STUDENT_ID, $student_id, Criteria::IN); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar_id, Criteria::IN); $stu_accal = StudentAccalPeer::doSelectOne($c); $this->stu_accal = $stu_accal; $cw = new Criteria(); $cw->add(CounselingPeer::CLASS_GROUP_ID, $stu_accal->getClassGroupId()); $cw->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counseling = CounselingPeer::doSelectOne($cw); $this->counseling = $counseling; $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $student->getId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $c->addJoin(GradeComponentPeer::ID, StudentRaportPeer::GRADE_COMPONENT_ID); $c->add(GradeComponentPeer::GRADE_SPEC_ID, 21); $c->addAscendingOrderByColumn(GradeComponentPeer::NAME); $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'grade_component')); $this->getUser()->setAttribute('max_per_page', $rpp, 'grade_component'); $pager = new sfPropelPager('GradeComponent', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'grade_component')); $this->getUser()->setAttribute('page', $page, 'grade_component'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(); array_unshift($actions, array('name' => '_AS_CSV_', 'url' => "student_ekskul/listEkskulAsCSV?academic_calendar_id=" . $academic_calendar->getId() . "&student_id=" . $student->getId(), 'color' => 'black', 'type' => 'direct')); array_unshift($actions, array('name' => '_AS_PDF_', 'url' => "student_ekskul/listEkskulAsPDF?academic_calendar_id=" . $academic_calendar->getId() . "&student_id=" . $student->getId(), 'color' => 'black', 'type' => 'direct')); $this->actions = $actions; $this->subtitle = $academic_calendar->getName(); }
<td style="text-align: left; font-size: 10px; font-weight: bold;"> <?php $c = new Criteria(); $c->add(EmployeePeer::DEPARTMENT_ID, $course_schedule->getAcademicCalendar()->getDepartmentId()); $c->add(EmployeePeer::STAFF_TYPE_ID, 14); $employee = EmployeePeer::doSelectOne($c); echo $employee->getName() ? $employee->getName() : '-'; ?> </td> <td style="text-align: left; font-size: 10px; font-weight: bold;"> <?php $cr = new Criteria(); $cton1 = $cr->getNewCriterion(CounselingPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId(), Criteria::IN); $cton2 = $cr->getNewCriterion(CounselingPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendar()->getParent(), Criteria::IN); $cton3 = $cr->getNewCriterion(CounselingPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId(), Criteria::IN); $cton2->addOr($cton3); $cton1->addAnd($cton2); $cr->add($cton1); $counseling = CounselingPeer::doSelectOne($cr); $counselings = CounselingPeer::retrieveByPK($counseling->getId()); $tutors = array(); foreach ($counselings->getCounselingTutors() as $cr) { $tutors[] = $cr->getEmployee() ? $cr->getEmployee()->getName() : '-'; } echo join("<br>", $tutors); ?> </td> </tr> </table> </center>
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'); $c = new Criteria(); $c->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $this->getRequestParameter('academic_calendar_id')); $c->add(CounselingPeer::CLASS_GROUP_ID, $this->getRequestParameter('class_group_id')); $counseling = CounselingPeer::doSelectOne($c); if ($counseling == null) { $counseling = new Counseling(); } #$counseling->setId($this->getRequestParameter('id')); $counseling->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $counseling->setClassGroupId($this->getRequestParameter('class_group_id')); $counseling->save(); return $this->redirect('counselor_new/lector?id=' . $counseling->getId()); }
public function executeGetListTryoutAll() { $academic_calendar_id = $this->getRequestParameter('academic_calendar_id'); $academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id); $this->academic_calendar = $academic_calendar; $student_id = $this->getRequestParameter('student_id'); $student = StudentPeer::retrieveByPK($student_id); $this->forward404Unless($student); $this->student = $student; $c = new Criteria(); $c->add(StudentAccalPeer::STUDENT_ID, $student_id, Criteria::IN); $c->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar_id, Criteria::IN); $stu_accal = StudentAccalPeer::doSelectOne($c); $this->stu_accal = $stu_accal; $cw = new Criteria(); $cw->add(CounselingPeer::CLASS_GROUP_ID, $stu_accal->getClassGroupId()); $cw->add(CounselingPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent()); $counseling = CounselingPeer::doSelectOne($cw); $this->counseling = $counseling; ## Menentukan Aturan Penilaian $cd = new Criteria(); $cd->add(ClassGroupPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId()); $cd->addJoin(ScoreRulePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $cd->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $cd->add(ScoreRulePeer::TYPE, 5); $score_rule = ScoreRulePeer::doSelectOne($cd); $this->score_rule = $score_rule; $ct = new Criteria(); $ct->add(GradeSpecPeer::PARENT, 45, Criteria::IN); $this->grade1 = GradeSpecPeer::doSelect($ct); $this->count1 = GradeSpecPeer::doCount($ct); $cte = new Criteria(); $cte->add(GradeSpecPeer::PARENT, 7, Criteria::IN); $this->grade2 = GradeSpecPeer::doSelect($cte); $this->count2 = GradeSpecPeer::doCount($cte); ## Daftar Mata Pelajaran di Jadwal Pelajaran $cty = new Criteria(); $cty->add(VCoursePeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cty->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $subjects = VCoursePeer::doSelect($cty); $subject_ids = array(); foreach ($subjects as $subject) { $subject_ids[] = $subject->getSubjectCurrId(); } $this->subjects = $subjects; ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $cr = new Criteria(); $cr->add(StudentTryoutPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cr->add(StudentTryoutPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $stugrades = StudentTryoutPeer::doSelect($cr); $this->stugrades = $stugrades; ## Menentukan Aturan Penilaian Yang digunakan $cm = new Criteria(); $cm->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cm->add(ScoreRuleSubjectPeer::PUBLISHED, 1, Criteria::IN); $cm->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $cm->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $list_subs = ScoreRuleSubjectPeer::doSelect($cm); $subject_count = ScoreRuleSubjectPeer::doCount($cm); $this->list_subs = $list_subs; $this->subject_count = $subject_count; ## Kelompokkan Mata Pelajaran Muatan Nasional $cmi = new Criteria(); $cmi->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cmi->add(ScoreRuleSubjectPeer::PUBLISHED, 1, Criteria::IN); $cmi->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, 1, Criteria::IN); $cmi->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $cmi->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $subs1 = ScoreRuleSubjectPeer::doSelect($cmi); $subs1_count = ScoreRuleSubjectPeer::doCount($cmi); $this->subs1 = $subs1; $this->subs1_count = $subs1_count; ## Kelompokkan Mata Pelajaran Muatan Lokal $ciw = new Criteria(); $ciw->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $ciw->add(ScoreRuleSubjectPeer::PUBLISHED, 1, Criteria::IN); $ciw->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, 2, Criteria::IN); $ciw->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $ciw->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $subs2 = ScoreRuleSubjectPeer::doSelect($ciw); $subs2_count = ScoreRuleSubjectPeer::doCount($ciw); $this->subs2 = $subs2; $this->subs2_count = $subs2_count; ## Kelompokkan Mata Pelajaran IPA $ci = new Criteria(); $ci->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $ci->add(ScoreRuleSubjectPeer::PUBLISHED, 1, Criteria::IN); $ci->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, 3, Criteria::IN); $ci->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $ci->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $ipas = ScoreRuleSubjectPeer::doSelect($ci); $ipas_count = ScoreRuleSubjectPeer::doCount($ci); $this->ipas = $ipas; $this->ipas_count = $ipas_count; ## Kelompokkan Mata Pelajaran IPS $cit = new Criteria(); $cit->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cit->add(ScoreRuleSubjectPeer::PUBLISHED, 1, Criteria::IN); $cit->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, 4, Criteria::IN); $cit->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $cit->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $ips = ScoreRuleSubjectPeer::doSelect($cit); $ips_count = ScoreRuleSubjectPeer::doCount($cit); $this->ips = $ips; $this->ips_count = $ips_count; ## Kelompokkan Mata Pelajaran Setelah IPS $cet = new Criteria(); $cet->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cet->add(ScoreRuleSubjectPeer::PUBLISHED, 1, Criteria::IN); $cet->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, 5, Criteria::IN); $cet->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $subject_ids, Criteria::IN); $cet->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $subs3 = ScoreRuleSubjectPeer::doSelect($cet); $subs3_count = ScoreRuleSubjectPeer::doCount($cet); $this->subs3 = $subs3; $this->subs3_count = $subs3_count; ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $cem = new Criteria(); $cem->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cem->add(StudentAccalPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cem->add(StudentAccalPeer::STATUS, 1); $stu_accs = StudentAccalPeer::doSelect($cem); $this->stu_accs = $stu_accs; $cw = new Criteria(); $cw->add(CourseRegulationPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $cw->add(CourseRegulationPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $c_regulations = CourseRegulationPeer::doSelect($cw); $this->c_regulations = $c_regulations; $actions = array(); #array_unshift($actions, array('name'=>'_AS_PDF_','url'=>"student_score_s/listAsPDF?academic_calendar_id=".$academic_calendar->getId()."&student_id=".$student->getId(), # 'color'=>'black', 'type'=>'direct')); $this->actions = $actions; }