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