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