echo include_partial('global/tab', array('actions2' => $actions2)); echo form_remote_tag(array('url' => 'course_score/salvareCounseling', 'update' => 'content', 'script' => 'true', 'before' => "this.blur();showIndicator('content', 'snakebig_black');", 'complete' => "hideIndicator()", 'name' => 'edit_form')); echo include_partial('global/title4', array('actions' => $actions, 'subtitle' => $subtitle, 'type' => $type, 'title' => __('Penilaian Keseluruhan'))); echo input_hidden_tag('action_type', ''); echo input_hidden_tag('course_id', $course_schedule->getId()); echo input_hidden_tag('employee_id', $employee_id); $grade1_ids = array(); $grade2_ids = array(); $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); $cer = new Criteria(); $cer->add(GradeSpecKkmPeer::COURSE_SCHEDULE_ID, $course_schedule->getId()); $gradespecs = GradeSpecKkmPeer::doSelect($cer); $specs = array(); foreach ($gradespecs as $gradespec) { $specs[$gradespec->getGradeSpecId()] = $gradespec->getKkm(); } ?> <table class="list_score"> <tr><td class="list_score"> <table class="list_content" width="100%"> <thead> <tr> <th class="score" width="5%" height="25px">#</th> <th class="score"><?php echo __('Name');
public function executeSalvare() { $course_id = $this->getRequestParameter('course_id'); $course_schedule = CourseSchedulePeer::retrieveByPK($course_id); $this->forward404Unless($course_schedule); ## Simpan KKM Per Kategori Penilaian $kkms = $this->getRequestParameter('kkm'); foreach ($kkms as $m => $kkm) { if ($kkm != null) { if ($kkm != '-') { $ids = split('_', $m); $ced = new Criteria(); $ced->add(GradeSpecKkmPeer::COURSE_SCHEDULE_ID, $ids[0]); $ced->add(GradeSpecKkmPeer::GRADE_SPEC_ID, $ids[1]); $spec = GradeSpecKkmPeer::doSelectOne($ced); if ($spec == null) { $spec = new GradeSpecKkm(); } $spec->setCourseScheduleId($ids[0]); $spec->setGradeSpecId($ids[1]); $spec->setKkm($kkm); $spec->save(); } else { $ids = split('_', $m); $ced = new Criteria(); $ced->add(GradeSpecKkmPeer::COURSE_SCHEDULE_ID, $ids[0]); $ced->add(GradeSpecKkmPeer::GRADE_SPEC_ID, $ids[1]); $spec = GradeSpecKkmPeer::doSelectOne($ced); if ($spec != null) { $spec->delete(); } } } } ## Penilaian Umum $scores = $this->getRequestParameter('score'); foreach ($scores as $k => $score) { if ($score != null) { if ($score != '-') { $ids = split('_', $k); $cd = new Criteria(); $cd->add(StudentAccalPeer::STUDENT_ID, $ids[0]); $cd->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cd->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $stu_accal = StudentAccalPeer::doSelectOne($cd); if ($ids[1] == 92) { $cm = new Criteria(); $cm->add(CourseRegulationPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cm->add(CourseRegulationPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cm->add(CourseRegulationPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c_regulation = CourseRegulationPeer::doSelectOne($cm); $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $c->add(StudentRaportPeer::GRADE_SPEC_ID, $ids[1]); $c->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $g = StudentRaportPeer::doSelectOne($c); if ($g == null) { $g = new StudentRaport(); } $g->setStudentId($ids[0]); $g->setGradeSpecId($ids[1]); $g->setGrade($score); $g->setSubjectCurrId($course_schedule->getSubjectCurrId()); $g->setClassGroupId($course_schedule->getClassGroupId()); $g->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $g->setCitationId($stu_accal->getId()); $g->save(); if ($c_regulation) { $cg = new Criteria(); $cg->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $cg->add(StudentRaportPeer::GRADE_SPEC_ID, $ids[1]); $cg->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cg->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cg->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $nr = StudentRaportPeer::doSelectOne($cg); $f = new Criteria(); $f->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $f->add(StudentRaportPeer::GRADE_SPEC_ID, 14); $f->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $f->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $f->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $uh = StudentRaportPeer::doSelectOne($f); if ($nr->getGrade() >= $c_regulation->getKkm()) { if ($uh == null) { $uh = new StudentRaport(); } $uh->setStudentId($ids[0]); $uh->setGradeSpecId(14); $uh->setGrade($c_regulation->getKkm()); $uh->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uh->setClassGroupId($course_schedule->getClassGroupId()); $uh->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uh->setCitationId($stu_accal->getId()); $uh->save(); } elseif ($nr->getGrade() < $c_regulation->getKkm()) { if ($uh == null) { $uh = new StudentRaport(); $uh->setStudentId($ids[0]); $uh->setGradeSpecId(14); $uh->setGrade($nr->getGrade()); $uh->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uh->setClassGroupId($course_schedule->getClassGroupId()); $uh->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uh->setCitationId($stu_accal->getId()); $uh->save(); } else { if ($nr->getGrade() > $uh->getGrade()) { $uh->setStudentId($ids[0]); $uh->setGradeSpecId(14); $uh->setGrade($nr->getGrade()); $uh->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uh->setClassGroupId($course_schedule->getClassGroupId()); $uh->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uh->setCitationId($stu_accal->getId()); $uh->save(); } } } } } else { $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $c->add(StudentRaportPeer::GRADE_SPEC_ID, $ids[1]); $c->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $g = StudentRaportPeer::doSelectOne($c); if ($g == null) { $g = new StudentRaport(); } $g->setStudentId($ids[0]); $g->setGradeSpecId($ids[1]); $g->setGrade($score); $g->setSubjectCurrId($course_schedule->getSubjectCurrId()); $g->setClassGroupId($course_schedule->getClassGroupId()); $g->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $g->setCitationId($stu_accal->getId()); $g->save(); $cg = new Criteria(); $cg->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $cg->add(StudentRaportPeer::GRADE_SPEC_ID, 22); $cg->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cg->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cg->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cg->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $praktek_uts = StudentRaportPeer::doSelectOne($cg); $cf = new Criteria(); $cf->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $cf->add(StudentRaportPeer::GRADE_SPEC_ID, 23); $cf->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cf->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cf->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cf->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $teori_uts = StudentRaportPeer::doSelectOne($cf); if ($praktek_uts != null && $teori_uts != null) { $score_uts = round(($praktek_uts->getGrade() + $teori_uts->getGrade()) / 2); $f = new Criteria(); $f->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $f->add(StudentRaportPeer::GRADE_SPEC_ID, 14); $f->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $f->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $f->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $f->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $uts = StudentRaportPeer::doSelectOne($f); if ($uts == null) { $uts = new StudentRaport(); } $uts->setStudentId($ids[0]); $uts->setGradeSpecId(14); $uts->setGrade($score_uts); $uts->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uts->setClassGroupId($course_schedule->getClassGroupId()); $uts->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uts->setCitationId($stu_accal->getId()); $uts->save(); } elseif ($praktek_uts != null && $teori_uts == null) { $score_uts = $praktek_uts->getGrade(); $f = new Criteria(); $f->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $f->add(StudentRaportPeer::GRADE_SPEC_ID, 14); $f->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $f->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $f->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $f->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $uts = StudentRaportPeer::doSelectOne($f); if ($uts == null) { $uts = new StudentRaport(); } $uts->setStudentId($ids[0]); $uts->setGradeSpecId(14); $uts->setGrade($score_uts); $uts->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uts->setClassGroupId($course_schedule->getClassGroupId()); $uts->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uts->setCitationId($stu_accal->getId()); $uts->save(); } elseif ($praktek_uts == null && $teori_uts != null) { $score_uts = $teori_uts->getGrade(); $f = new Criteria(); $f->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $f->add(StudentRaportPeer::GRADE_SPEC_ID, 14); $f->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $f->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $f->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $f->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $uts = StudentRaportPeer::doSelectOne($f); if ($uts == null) { $uts = new StudentRaport(); } $uts->setStudentId($ids[0]); $uts->setGradeSpecId(14); $uts->setGrade($score_uts); $uts->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uts->setClassGroupId($course_schedule->getClassGroupId()); $uts->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uts->setCitationId($stu_accal->getId()); $uts->save(); } # Praktek UAS dan Teori UAS $ct = new Criteria(); $ct->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $ct->add(StudentRaportPeer::GRADE_SPEC_ID, 27); $ct->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $ct->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $ct->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $praktek_uas = StudentRaportPeer::doSelectOne($ct); $ch = new Criteria(); $ch->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $ch->add(StudentRaportPeer::GRADE_SPEC_ID, 28); $ch->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $ch->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $ch->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $teori_uas = StudentRaportPeer::doSelectOne($ch); if ($praktek_uas != null && $teori_uas != null) { $score_uas = round(($praktek_uas->getGrade() + $teori_uas->getGrade()) / 2); $fg = new Criteria(); $fg->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $fg->add(StudentRaportPeer::GRADE_SPEC_ID, 15); $fg->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $fg->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $fg->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $fg->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $uas = StudentRaportPeer::doSelectOne($fg); if ($uas == null) { $uas = new StudentRaport(); } $uas->setStudentId($ids[0]); $uas->setGradeSpecId(15); $uas->setGrade($score_uas); $uas->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uas->setClassGroupId($course_schedule->getClassGroupId()); $uas->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uas->setCitationId($stu_accal->getId()); $uas->save(); } elseif ($praktek_uas != null && $teori_uas == null) { $score_uas = $praktek_uas->getGrade(); $fg = new Criteria(); $fg->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $fg->add(StudentRaportPeer::GRADE_SPEC_ID, 15); $fg->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $fg->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $fg->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $fg->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $uas = StudentRaportPeer::doSelectOne($fg); if ($uas == null) { $uas = new StudentRaport(); } $uas->setStudentId($ids[0]); $uas->setGradeSpecId(15); $uas->setGrade($score_uas); $uas->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uas->setClassGroupId($course_schedule->getClassGroupId()); $uas->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uas->setCitationId($stu_accal->getId()); $uas->save(); } elseif ($praktek_uas == null && $teori_uas != null) { $score_uas = $teori_uas->getGrade(); $fg = new Criteria(); $fg->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $fg->add(StudentRaportPeer::GRADE_SPEC_ID, 15); $fg->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $fg->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $fg->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $fg->add(StudentRaportPeer::CITATION_ID, $stu_accal->getId()); $uas = StudentRaportPeer::doSelectOne($fg); if ($uas == null) { $uas = new StudentRaport(); } $uas->setStudentId($ids[0]); $uas->setGradeSpecId(15); $uas->setGrade($score_uas); $uas->setSubjectCurrId($course_schedule->getSubjectCurrId()); $uas->setClassGroupId($course_schedule->getClassGroupId()); $uas->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $uas->setCitationId($stu_accal->getId()); $uas->save(); } } } else { $ids = split('_', $k); $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $c->add(StudentRaportPeer::GRADE_SPEC_ID, $ids[1]); $c->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $g = StudentRaportPeer::doSelectOne($c); if ($g != null) { $g->delete(); } } } } $cw = new Criteria(); $cw->add(CourseRegulationPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $cw->add(CourseRegulationPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cw->add(CourseRegulationPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c_regulation = CourseRegulationPeer::doSelectOne($cw); if ($c_regulation) { #Nilai Remedial $remeds = $this->getRequestParameter('remed'); foreach ($remeds as $k => $remed) { if ($remed != null) { if ($remed != '-') { $ids = split('_', $k); $cd = new Criteria(); $cd->add(StudentAccalPeer::STUDENT_ID, $ids[0]); $cd->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cd->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $stu_accal = StudentAccalPeer::doSelectOne($cd); $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $c->add(StudentRaportPeer::GRADE_SPEC_ID, $ids[1]); $c->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $g = StudentRaportPeer::doSelectOne($c); if ($g == null) { $g = new StudentRaport(); } $g->setStudentId($ids[0]); $g->setGradeSpecId($ids[1]); $g->setGrade($remed); $g->setSubjectCurrId($course_schedule->getSubjectCurrId()); $g->setClassGroupId($course_schedule->getClassGroupId()); $g->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $g->setCitationId($stu_accal->getId()); $g->save(); $grade_spec = GradeSpecPeer::retrieveByPK($ids[1]); $cg = new Criteria(); $cg->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $cg->add(StudentRaportPeer::GRADE_SPEC_ID, $grade_spec->getId()); $cg->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cg->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cg->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $nr = StudentRaportPeer::doSelectOne($cg); $f = new Criteria(); $f->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $f->add(StudentRaportPeer::GRADE_SPEC_ID, $grade_spec->getParent()); $f->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $f->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $f->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $nu = StudentRaportPeer::doSelectOne($f); if ($nr->getGrade() >= $c_regulation->getKkm()) { $score_atas = $nr->getGrade() - $c_regulation->getKkm(); $score_bawah = round(0.1 * (100 - $c_regulation->getKkm())); $score = round($c_regulation->getKkm() + $score_atas / $score_bawah); if ($nu == null) { $nu = new StudentRaport(); } $nu->setStudentId($ids[0]); $nu->setGradeSpecId($grade_spec->getParent()); $nu->setGrade($score); $nu->setSubjectCurrId($course_schedule->getSubjectCurrId()); $nu->setClassGroupId($course_schedule->getClassGroupId()); $nu->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $nu->setCitationId($stu_accal->getId()); $nu->save(); } } else { $ids = split('_', $k); $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $c->add(StudentRaportPeer::GRADE_SPEC_ID, $ids[1]); $c->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $g = StudentRaportPeer::doSelectOne($c); if ($g != null) { $g->delete(); } } } } $allAVGs = $this->getRequestParameter('allAVG'); foreach ($allAVGs as $k => $all) { $ids = split('_', $k); #$ids[0] = Student ID #$ids[1] = RUH #$ids[2] = RTGS #$ids[3] = UTS #$ids[4] = UAS #$ids[5] = Kehadiran #$all = RUH+RTGS $cd = new Criteria(); $cd->add(StudentAccalPeer::STUDENT_ID, $ids[0]); $cd->add(StudentAccalPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cd->add(StudentAccalPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $stu_accal = StudentAccalPeer::doSelectOne($cd); $c = new Criteria(); $c->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $c->add(StudentRaportPeer::GRADE_SPEC_ID, 16); $c->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $g = StudentRaportPeer::doSelectOne($c); ## Format 2 (RUH+UTS+UAS)/3 if ($c_regulation->getFormulaId() == 2) { $scoreBLP = round(($ids[1] + $ids[3] + $ids[4]) / 3); ## Format 3 (3RUH+UTS+UAS)/5 } elseif ($c_regulation->getFormulaId() == 3) { $scoreBLP = round((3 * $ids[1] + $ids[3] + $ids[4]) / 5); ## Format 4 (2RUH+RTGS+UTS+UAS)/5 } elseif ($c_regulation->getFormulaId() == 4) { $scoreBLP = round((2 * $ids[1] + $ids[2] + $ids[3] + $ids[4]) / 5); ## Format 5 (2RUH+RTGS+UAS)/4 } elseif ($c_regulation->getFormulaId() == 5) { $scoreBLP = round((2 * $ids[1] + $ids[2] + $ids[4]) / 4); ## Format 6 (2RUH+UAS)/3 } elseif ($c_regulation->getFormulaId() == 6) { $scoreBLP = round((2 * $ids[1] + $ids[4]) / 3); ## Format 7 (50%RUH+10%RTGS+20%UTS+20%UAS) } elseif ($c_regulation->getFormulaId() == 7) { $scoreBLP = round(0.5 * $ids[1] + 0.1 * $ids[2] + 0.2 * $ids[3] + 0.2 * $ids[4]); ## Format 8 (2NH+UTS+UAS)/4 } elseif ($c_regulation->getFormulaId() == 8) { #$nh = round((7 * $ids [1] + 3 * $ids [2]) / 10); $nh = round((3 * $ids[1] + $ids[2]) / 4); $scoreBLP = round((2 * $nh + $ids[3] + $ids[4]) / 4); ## Format 9 (3NH+NUTS+NUKK)/5 } elseif ($c_regulation->getFormulaId() == 9) { #$nh = round((3*$ids [1]+$ids [2])/5); $nh = round(0.6 * $ids[1] + 0.4 * $ids[2]); $scoreBLP = round((3 * $nh + $ids[3] + $ids[4]) / 5); ## Format 10 (70%*NH+30%*(UTS+UAS)) } elseif ($c_regulation->getFormulaId() == 10) { #$nh = round($ids[1] + 2 * $ids[2]); #$scoreBLP = round(0.7 * $nh + 0.3 * ($ids[3] + $ids[4])); $nh = round(0.6 * $ids[1] + 0.4 * $ids[2]); $scoreBLP = round(0.6 * $nh + 0.4 * ($ids[3] + $ids[4])); ## Format 8 (2NH+UTS+UAS)/4 } elseif ($c_regulation->getFormulaId() == 11) { #$nh = round((7 * $ids [1] + 3 * $ids [2]) / 10); $nh = round((3 * $ids[1] + $ids[2]) / 4); $scoreBLP = round((2 * $nh + $ids[3] + $ids[4]) / 4); ## Format 1 atau Lainnya (RTGS+RUH+UTS+UAS)/4 } else { $scoreBLP = round(($ids[1] + $ids[2] + $ids[3] + $ids[4]) / 4); } if ($g == null) { $g = new StudentRaport(); } $g->setStudentId($ids[0]); $g->setGradeSpecId(16); $g->setGrade($scoreBLP); $g->setSubjectCurrId($course_schedule->getSubjectCurrId()); $g->setClassGroupId($course_schedule->getClassGroupId()); $g->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $g->setCitationId($stu_accal->getId()); $g->save(); ## Menyimpan Nilai Raport Murni $ii = new Criteria(); $ii->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $ii->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $ii->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $ii->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $ii->add(StudentRaportPeer::GRADE_SPEC_ID, 88); $gi = StudentRaportPeer::doSelectOne($ii); if ($gi == null) { $gi = new StudentRaport(); } $gi->setStudentId($ids[0]); $gi->setGradeSpecId(88); $gi->setGrade($scoreBLP); $gi->setSubjectCurrId($course_schedule->getSubjectCurrId()); $gi->setClassGroupId($course_schedule->getClassGroupId()); $gi->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $gi->setCitationId($stu_accal->getId()); $gi->save(); $cgi = new Criteria(); $cgi->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $cgi->add(StudentRaportPeer::GRADE_SPEC_ID, 88); $cgi->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cgi->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cgi->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $raport_murni = StudentRaportPeer::doSelectOne($cgi); $cfi = new Criteria(); $cfi->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $cfi->add(StudentRaportPeer::GRADE_SPEC_ID, 89); $cfi->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $cfi->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $cfi->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $raport_pleno = StudentRaportPeer::doSelectOne($cfi); if ($raport_pleno != null) { if ($raport_murni->getGrade() < $raport_pleno->getGrade()) { $im = new Criteria(); $im->add(StudentRaportPeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $im->add(StudentRaportPeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $im->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $im->add(StudentRaportPeer::STUDENT_ID, $ids[0]); $im->add(StudentRaportPeer::GRADE_SPEC_ID, 16); $gm = StudentRaportPeer::doSelectOne($im); if ($gm == null) { $gm = new StudentRaport(); } $gm->setStudentId($ids[0]); $gm->setGradeSpecId(16); $gm->setGrade($raport_pleno->getGrade()); $gm->setSubjectCurrId($course_schedule->getSubjectCurrId()); $gm->setClassGroupId($course_schedule->getClassGroupId()); $gm->setAcademicCalendarId($course_schedule->getAcademicCalendarId()); $gm->setCitationId($stu_accal->getId()); $gm->save(); } } } } return $this->redirect('course_score_new/listAll?course_id=' . $course_schedule->getId()); }
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = GradeSpecKkmPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setCourseScheduleId($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setGradeSpecId($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setKkm($arr[$keys[3]]); } }
public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(GradeSpecKkmPeer::ID, $pks, Criteria::IN); $objs = GradeSpecKkmPeer::doSelect($criteria, $con); } return $objs; }