public function executePrintMiddle() { $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'); $term = $this->getRequestParameter('term'); $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); ## Menentukan Aturan Penilaian $cd = new Criteria(); $cd->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $cd->add(ClassGroupPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $cd->addJoin(ScoreRulePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $cd->add(ScoreRulePeer::TYPE, 5); $score_rule = ScoreRulePeer::doSelectOne($cd); $this->score_rule = $score_rule; $ct = new Criteria(); $ct->add(GradeSpecPeer::PARENT, 1, Criteria::IN); $ct->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $ct->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ct->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $ct->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade1 = ScoreRuleObjectPeer::doSelect($ct); $this->count1 = ScoreRuleObjectPeer::doCount($ct); $cte = new Criteria(); $cte->add(GradeSpecPeer::PARENT, 7, Criteria::IN); $cte->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $cte->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $cte->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cte->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade2 = ScoreRuleObjectPeer::doSelect($cte); $this->count2 = ScoreRuleObjectPeer::doCount($cte); $ctm = new Criteria(); $ctm->add(GradeSpecPeer::PARENT, 90, Criteria::IN); $ctm->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $ctm->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ctm->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $ctm->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade3 = ScoreRuleObjectPeer::doSelect($ctm); $this->count3 = ScoreRuleObjectPeer::doCount($ctm); $ce = new Criteria(); $ce->add(DepartmentDetailPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $this->department_detail = DepartmentDetailPeer::doSelectOne($ce); ## 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); $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(StudentRaportPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cr->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $stugrades = StudentRaportPeer::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; $this->students = $students; $this->subtitle = ''; $this->counseling = $counseling; $this->tanggal = $time; $this->tgl_cetak = $tgl; $this->time2 = $time2; $this->academic_calendar = $academic_calendar; $this->term = $term; if ($academic_calendar->getDepartment()->getCourseModel() == Department::CM_TK) { $term = $this->getRequestParameter('term'); $this->orientation = 'landscape'; $this->setTemplate('printMiddle'); $this->papersize = 'a4'; } elseif ($academic_calendar->getDepartment()->getCourseModel() == Department::CM_SMA) { $this->orientation = 'landscape'; $this->setTemplate('printMiddleSMA'); $this->papersize = 'legal'; } else { ## Khusus SMPIA 6 (Dipisahin ngedadak soalnya) if ($academic_calendar->getDepartmentId() == 7) { $this->setTemplate('printMiddleSMP6'); $this->orientation = 'portrait'; $this->papersize = 'a4'; } else { $this->setTemplate('printMiddle'); $this->orientation = 'portrait'; $this->papersize = 'a4'; } } $this->setViewClass('sfDomPDF'); }
public function executeSavePreview() { $class_group1 = $this->getRequestParameter('class1'); $academic1 = $this->getRequestParameter('accal1'); $class_group2 = $this->getRequestParameter('class2'); $academic2 = $this->getRequestParameter('accal2'); $c = new Criteria(); $c->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $academic1); $c->add(ScoreRulePeer::CLASS_GROUP_ID, $class_group1); $s_rules = ScoreRulePeer::doSelect($c); foreach ($s_rules as $s_rule) { $score_rule = new ScoreRule(); $score_rule->setAcademicCalendarId($academic2); $score_rule->setClassGroupId($class_group2); $score_rule->setClassTypeId($s_rule->getClassTypeId()); $score_rule->setName($s_rule->getName()); $score_rule->setLanguage($s_rule->getLanguage()); $score_rule->setImage($s_rule->getImage()); $score_rule->setKkmFinal($s_rule->getKkmFinal()); $score_rule->setAvgScore($s_rule->getAvgScore()); $score_rule->setTeacher($s_rule->getTeacher()); $score_rule->setType($s_rule->getType()); $score_rule->setTotalScore($s_rule->getTotalScore()); $score_rule->setAvgClass($s_rule->getAvgClass()); $score_rule->setKkmSpec($s_rule->getKkmSpec()); $score_rule->save(); $cw = new Criteria(); $cw->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $s_rule->getId()); $c_objects = ScoreRuleObjectPeer::doSelect($cw); foreach ($c_objects as $c_object) { $score_rule_object = new ScoreRuleObject(); $score_rule_object->setScoreRule($score_rule); $score_rule_object->setGradeSpecId($c_object->getGradeSpecId()); $score_rule_object->setPublished($c_object->getPublished()); $score_rule_object->setSequence($c_object->getSequence()); $score_rule_object->save(); } $cr = new Criteria(); $cr->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $s_rule->getId()); $c_subjects = ScoreRuleSubjectPeer::doSelect($cr); foreach ($c_subjects as $c_subject) { $score_rule_subject = new ScoreRuleSubject(); $score_rule_subject->setScoreRule($score_rule); $score_rule_subject->setSequence($c_subject->getPublished()); $score_rule_subject->setSubjectCurrId($c_subject->getSubjectCurrId()); $score_rule_subject->setSubjectType($c_subject->getSubjectType()); $score_rule_subject->setPublished($c_subject->getPublished()); $score_rule_subject->setParent($c_subject->getParent()); $score_rule_subject->save(); } } return $this->redirect('score_rule_new/list'); }
public static function retrieveByPK($id, $score_rule_id, $grade_spec_id, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $criteria = new Criteria(); $criteria->add(ScoreRuleObjectPeer::ID, $id); $criteria->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule_id); $criteria->add(ScoreRuleObjectPeer::GRADE_SPEC_ID, $grade_spec_id); $v = ScoreRuleObjectPeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }
public function executePrintMiddle() { $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'); $term = $this->getRequestParameter('term'); $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); ## Menentukan Aturan Penilaian $cd = new Criteria(); $cd->add(ScoreRulePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $cd->add(ClassGroupPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $cd->addJoin(ScoreRulePeer::CLASS_GROUP_ID, ClassGroupPeer::ID); $cd->add(ScoreRulePeer::TYPE, 5); $score_rule = ScoreRulePeer::doSelectOne($cd); /* var_dump($score_rule->toArray()); die(); */ $this->score_rule = $score_rule; $ct = new Criteria(); $ct->add(GradeSpecPeer::PARENT, 1, Criteria::IN); $ct->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $ct->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ct->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $ct->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade1 = ScoreRuleObjectPeer::doSelect($ct); $this->count1 = ScoreRuleObjectPeer::doCount($ct); $cte = new Criteria(); $cte->add(GradeSpecPeer::PARENT, 7, Criteria::IN); $cte->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $cte->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $cte->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $cte->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade2 = ScoreRuleObjectPeer::doSelect($cte); $this->count2 = ScoreRuleObjectPeer::doCount($cte); $ctm = new Criteria(); $ctm->add(GradeSpecPeer::PARENT, 90, Criteria::IN); $ctm->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $ctm->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ctm->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $score_rule->getId(), Criteria::IN); $ctm->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade3 = ScoreRuleObjectPeer::doSelect($ctm); $this->count3 = ScoreRuleObjectPeer::doCount($ctm); $ce = new Criteria(); $ce->add(DepartmentDetailPeer::DEPARTMENT_ID, $counseling->getAcademicCalendar()->getDepartmentId()); $this->department_detail = DepartmentDetailPeer::doSelectOne($ce); ## 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); $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(StudentRaportPeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cr->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $stugrades = StudentRaportPeer::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); $stu_accal = array(); foreach ($stu_accs as $stu_acc) { $stu_accal[$stu_acc->getStudentId()] = $stu_acc->getId(); } $this->stu_accal = $stu_accal; $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; $this->students = $students; $this->subtitle = ''; $this->counseling = $counseling; $this->tanggal = $time; $this->tgl_cetak = $tgl; $this->time2 = $time2; $this->academic_calendar = $academic_calendar; $this->term = $term; if ($academic_calendar->getDepartment()->getCourseModel() == Department::CM_TK) { $term = $this->getRequestParameter('term'); $this->orientation = 'landscape'; $this->setTemplate('printMiddle'); $this->papersize = 'a4'; } elseif ($academic_calendar->getDepartment()->getCourseModel() == Department::CM_SMA) { $this->orientation = 'landscape'; $this->setTemplate('printMiddleSMA'); $this->papersize = 'legal'; } else { ## Khusus SMPIA 6 (Dipisahin ngedadak soalnya) if ($academic_calendar->getDepartmentId() == 7) { $this->setTemplate('printMiddleSMP6'); $cde = new Criteria(); $cde->add(ScoreRulePeer::KKM_SPEC, $academic_calendar->getDepartmentId()); $cde->add(ScoreRulePeer::TYPE, ScoreRule::TYPE_ONE); $cde->add(ScoreRulePeer::CLASS_TYPE_ID, $counseling->getClassTypeId()); $s_rule = ScoreRulePeer::doSelectOne($cde); $this->s_rule = $s_rule; ## Memunculkan semua mata pelajaran yang ada di aturan penilaian ## Mengelompokannya untuk kelompok A $cm = new Criteria(); $cm->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $s_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, $s_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; ## Memunculkan semua mata pelajaran yang ada di aturan penilaian ## Mengelompokannya untuk kelompok C $cmp = new Criteria(); $cmp->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $s_rule->getId(), Criteria::IN); $cmp->add(ScoreRuleSubjectPeer::PUBLISHED, ScoreRule::ONE, Criteria::IN); $cmp->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, ScoreRuleSubject::SUBJECT_SIX, Criteria::IN); $cmp->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $list_subjs = ScoreRuleSubjectPeer::doSelect($cmp); $s_count = ScoreRuleSubjectPeer::doCount($cmp); $this->list_subjs = $list_subjs; $this->s_count = $s_count; ## Khusus SMPIA 8 } elseif ($academic_calendar->getDepartmentId() == 10) { ## Menentukan Aturan Penilaian (Tengah Semester) $cdi = new Criteria(); $cdi->add(ScoreRulePeer::KKM_SPEC, $counseling->getAcademicCalendar()->getDepartmentId()); $cdi->add(ScoreRulePeer::TYPE, ScoreRule::TYPE_ONE); $cdi->add(ScoreRulePeer::CLASS_TYPE_ID, $counseling->getClassTypeId()); $sc_rule = ScoreRulePeer::doSelectOne($cdi); $this->sc_rule = $sc_rule; $cti = new Criteria(); $cti->add(GradeSpecPeer::PARENT, 1, Criteria::IN); $cti->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $cti->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $cti->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $sc_rule->getId(), Criteria::IN); $cti->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade4 = ScoreRuleObjectPeer::doSelect($cti); $this->count4 = ScoreRuleObjectPeer::doCount($cti); $ctf = new Criteria(); $ctf->add(GradeSpecPeer::PARENT, 7, Criteria::IN); $ctf->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $ctf->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ctf->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $sc_rule->getId(), Criteria::IN); $ctf->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade5 = ScoreRuleObjectPeer::doSelect($ctf); $this->count5 = ScoreRuleObjectPeer::doCount($ctf); $ctg = new Criteria(); $ctg->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ctg->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $sc_rule->getId(), Criteria::IN); $ctg->add(ScoreRuleObjectPeer::SEQUENCE, TestApplicant::REG_INFO_EXB, Criteria::IN); $ctg->addAscendingOrderByColumn(ScoreRuleObjectPeer::ID); $this->grade6 = ScoreRuleObjectPeer::doSelect($ctg); $this->count6 = ScoreRuleObjectPeer::doCount($ctg); $cth = new Criteria(); $cth->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $cth->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $sc_rule->getId(), Criteria::IN); $cth->add(ScoreRuleObjectPeer::SEQUENCE, TestApplicant::REG_INFO_MISC, Criteria::IN); $cth->addAscendingOrderByColumn(ScoreRuleObjectPeer::ID); $this->grade7 = ScoreRuleObjectPeer::doSelect($cth); $this->count7 = ScoreRuleObjectPeer::doCount($cth); $ctj = new Criteria(); $ctj->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ctj->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $sc_rule->getId(), Criteria::IN); $ctj->add(ScoreRuleObjectPeer::SEQUENCE, 7, Criteria::IN); $ctj->addAscendingOrderByColumn(ScoreRuleObjectPeer::ID); $this->grade8 = ScoreRuleObjectPeer::doSelect($ctj); $this->count8 = ScoreRuleObjectPeer::doCount($ctj); ## Mengelompokkan Penilaian Anak berdasarkan Tahun Ajaran dan Kelas $cre = new Criteria(); $sgrades = StudentGradeRaportPeer::doSelect($cre); $this->sgrades = $sgrades; $nilai = array(); foreach ($sgrades as $sgrade) { $nilai[$sgrade->getStudentAccalId() . '#' . $sgrade->getGradeSpecId() . '#' . $sgrade->getCourseScheduleId()] = $sgrade->getGrade(); } $this->nilai = $nilai; $crf = new Criteria(); $crf->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $crf->add(CourseSchedulePeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $courses = CourseSchedulePeer::doSelect($crf); $course_id = array(); foreach ($courses as $course) { $course_id[$course->getSubjectCurrId()] = $course->getId(); } $this->course_id = $course_id; $this->setTemplate('printMiddleSMP8'); } else { $this->setTemplate('printMiddleSMP9'); $cde = new Criteria(); $cde->add(ScoreRulePeer::KKM_SPEC, $academic_calendar->getDepartmentId()); $cde->add(ScoreRulePeer::TYPE, ScoreRule::TYPE_ONE); $cde->add(ScoreRulePeer::CLASS_TYPE_ID, $counseling->getClassTypeId()); $s_rule = ScoreRulePeer::doSelectOne($cde); $this->s_rule = $s_rule; ## Memunculkan semua mata pelajaran yang ada di aturan penilaian ## Mengelompokannya untuk kelompok A $cm = new Criteria(); $cm->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $s_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, $s_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; ## Memunculkan semua mata pelajaran yang ada di aturan penilaian ## Mengelompokannya untuk kelompok C $cmp = new Criteria(); $cmp->add(ScoreRuleSubjectPeer::SCORE_RULE_ID, $s_rule->getId(), Criteria::IN); $cmp->add(ScoreRuleSubjectPeer::PUBLISHED, ScoreRule::ONE, Criteria::IN); $cmp->add(ScoreRuleSubjectPeer::SUBJECT_TYPE, ScoreRuleSubject::SUBJECT_SIX, Criteria::IN); $cmp->addAscendingOrderByColumn(ScoreRuleSubjectPeer::SEQUENCE); $list_subjs = ScoreRuleSubjectPeer::doSelect($cmp); $s_count = ScoreRuleSubjectPeer::doCount($cmp); $this->list_subjs = $list_subjs; $this->s_count = $s_count; $ct = new Criteria(); $ct->add(GradeSpecPeer::PARENT, 1, Criteria::IN); $ct->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $ct->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $ct->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $s_rule->getId(), Criteria::IN); $ct->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade1 = ScoreRuleObjectPeer::doSelect($ct); $this->count1 = ScoreRuleObjectPeer::doCount($ct); $cte = new Criteria(); $cte->add(GradeSpecPeer::PARENT, 7, Criteria::IN); $cte->addJoin(GradeSpecPeer::ID, ScoreRuleObjectPeer::GRADE_SPEC_ID); $cte->add(ScoreRuleObjectPeer::PUBLISHED, 1, Criteria::IN); $cte->add(ScoreRuleObjectPeer::SCORE_RULE_ID, $s_rule->getId(), Criteria::IN); $cte->addAscendingOrderByColumn(ScoreRuleObjectPeer::SEQUENCE); $this->grade2 = ScoreRuleObjectPeer::doSelect($cte); $this->count2 = ScoreRuleObjectPeer::doCount($cte); } if ($academic_calendar->getDepartmentId() == 10) { $this->setLayout = false; $this->orientation = 'landscape'; } else { $this->orientation = 'potrait'; } $this->papersize = 'a4'; } if (SF_ENVIRONMENT != 'dev') { $this->setViewClass('sfDomPDF'); } }