public function executeSaveScoreEks()
{
$counsel_id = $this->getRequestParameter('counseling_id');
$counseling = CounselingPeer::retrieveByPK($counsel_id);
$this->forward404Unless($counseling);
$this->counseling = $counseling;
$accal_id = $this->getRequestParameter('accal_id');
$academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id);
$this->forward404Unless($academic_calendar);
$this->academic_calendar = $academic_calendar;
$schedule = SchedulePeer::retrieveByPk($this->getRequestParameter('schedule_id'));
$this->forward404Unless($schedule);
$this->schedule = $schedule;
$schedule_detail = ScheduleDetailPeer::retrieveByPk($this->getRequestParameter('detail_id'));
$this->forward404Unless($schedule_detail);
$this->schedule_detail = $schedule_detail;
$cj = new Criteria();
$cj->add(GradeConversionPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId());
$cj->add(GradeConversionPeer::GRADE_CONVERSION_TEMPLATE_ID, 19);
$cj->add(GradeConversionPeer::TYPE_CONVERSION, ScoreRule::FIVE);
$cj->addDescendingOrderByColumn(GradeConversionPeer::MAX_VALUE);
$grade_convs = GradeConversionPeer::doSelect($cj);
$scores = $this->getRequestParameter('score');
foreach ($scores as $k => $score) {
if ($score != null) {
if ($score != '-') {
$ids = split('_', $k);
## $ids[0] = Cur13 Ekskul Id
## $ids[1] = Grade Spec Id
$c = new Criteria();
$c->add(Cur13GradeEkskulPeer::CUR13_EKSKUL_ID, $ids[0]);
$c->add(Cur13GradeEkskulPeer::GRADE_SPEC_ID, $ids[1]);
$cur13_grade_ekskul = Cur13GradeEkskulPeer::doSelectOne($c);
if ($cur13_grade_ekskul == null) {
$cur13_grade_ekskul = new Cur13GradeEkskul();
}
$cur13_grade_ekskul->setCur13EkskulId($ids[0]);
$cur13_grade_ekskul->setGradeSpecId($ids[1]);
$cur13_grade_ekskul->setGrade($score);
$cur13_grade_ekskul->save();
$cc = new Criteria();
$cc->add(Cur13GradeEkskulPeer::CUR13_EKSKUL_ID, $ids[0]);
$cur13_grades = Cur13GradeEkskulPeer::doSelect($cc);
if ($cur13_grades) {
$total = 0;
$count = 0;
foreach ($cur13_grades as $cur13_grade) {
$count += 1;
$total += $cur13_grade->getGrade();
}
$avg = round($total / $count);
$scale = number_format($avg / 100 * 4, 2);
$remark = '';
foreach ($grade_convs as $gc) {
if ($avg >= $gc->getMinValue() && $avg < $gc->getMaxValue() + 1) {
$remark = $gc->getName();
}
}
$cur13_ekskul = Cur13EkskulPeer::retrieveByPK($ids[0]);
$cur13_ekskul->setGradeScale($scale);
$cur13_ekskul->setGrade($avg);
$cur13_ekskul->setRemark($remark);
$cur13_ekskul->save();
}
} else {
$ids = split('_', $k);
## $ids[0] = Cur13 Ekskul Id
## $ids[1] = Grade Spec Id
$c = new Criteria();
$c->add(Cur13GradeEkskulPeer::CUR13_EKSKUL_ID, $ids[0]);
$c->add(Cur13GradeEkskulPeer::GRADE_SPEC_ID, $ids[1]);
$cur13_grade_ekskul = Cur13GradeEkskulPeer::doSelectOne($c);
if ($cur13_grade_ekskul != null) {
$cur13_grade_ekskul->delete();
}
}
}
}
return $this->redirect('counseling_sd/listEksStu?id=' . $schedule->getId() . '&detail_id=' . $schedule_detail->getId() . '&accal_id=' . $academic_calendar->getId() . '&counseling_id=' . $counseling->getId());
}
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = Cur13EkskulPeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setStudentAccalId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setScheduleDetailId($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setGrade($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setRemark($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setGradeScale($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setTotalValue($arr[$keys[6]]);
}
if (array_key_exists($keys[7], $arr)) {
$this->setAvgValue($arr[$keys[7]]);
}
if (array_key_exists($keys[8], $arr)) {
$this->setCreatedAt($arr[$keys[8]]);
}
}
public function getCur13Ekskul($con = null)
{
include_once 'lib/model/om/BaseCur13EkskulPeer.php';
if ($this->aCur13Ekskul === null && $this->cur13_ekskul_id !== null) {
$this->aCur13Ekskul = Cur13EkskulPeer::retrieveByPK($this->cur13_ekskul_id, $con);
}
return $this->aCur13Ekskul;
}
public static function doSelectJoinAllExceptGradeSpec(Criteria $c, $con = null)
{
$c = clone $c;
if ($c->getDbName() == Propel::getDefaultDB()) {
$c->setDbName(self::DATABASE_NAME);
}
Cur13GradeEkskulPeer::addSelectColumns($c);
$startcol2 = Cur13GradeEkskulPeer::NUM_COLUMNS - Cur13GradeEkskulPeer::NUM_LAZY_LOAD_COLUMNS + 1;
Cur13EkskulPeer::addSelectColumns($c);
$startcol3 = $startcol2 + Cur13EkskulPeer::NUM_COLUMNS;
$c->addJoin(Cur13GradeEkskulPeer::CUR13_EKSKUL_ID, Cur13EkskulPeer::ID);
$rs = BasePeer::doSelect($c, $con);
$results = array();
while ($rs->next()) {
$omClass = Cur13GradeEkskulPeer::getOMClass();
$cls = Propel::import($omClass);
$obj1 = new $cls();
$obj1->hydrate($rs);
$omClass = Cur13EkskulPeer::getOMClass();
$cls = Propel::import($omClass);
$obj2 = new $cls();
$obj2->hydrate($rs, $startcol2);
$newObject = true;
for ($j = 0, $resCount = count($results); $j < $resCount; $j++) {
$temp_obj1 = $results[$j];
$temp_obj2 = $temp_obj1->getCur13Ekskul();
if ($temp_obj2->getPrimaryKey() === $obj2->getPrimaryKey()) {
$newObject = false;
$temp_obj2->addCur13GradeEkskul($obj1);
break;
}
}
if ($newObject) {
$obj2->initCur13GradeEkskuls();
$obj2->addCur13GradeEkskul($obj1);
}
$results[] = $obj1;
}
return $results;
}
echo __('C');
} elseif ($ekskul->getGrade() == '50') {
echo __('D');
}
} else {
echo '-';
}
?>
</th>
<th colspan="2" align="left" style="vertical-align: middle;">
<?php
$cm = new Criteria();
$cm->add(ScheduleDetailPeer::SCHEDULE_ID, $ekskul->getScheduleId());
$cm->addJoin(Cur13EkskulPeer::SCHEDULE_DETAIL_ID, ScheduleDetailPeer::ID);
$cm->add(Cur13EkskulPeer::STUDENT_ACCAL_ID, $student_accal_id);
$cur13_ekskul = Cur13EkskulPeer::doSelectOne($cm);
echo $cur13_ekskul ? $cur13_ekskul->getRemark() ? $cur13_ekskul->getRemark() : '' : '';
?>
</th>
</tr>
<?php
}
?>
<?php
}
?>
<?php
for ($n = $count_ekskul; $n < 3; $n++) {
?>
<tr>
public function executeSaveScoreSma()
{
$accal_id = $this->getRequestParameter('accal_id');
$academic_calendar = AcademicCalendarPeer::retrieveByPK($accal_id);
$this->forward404Unless($academic_calendar);
$this->academic_calendar = $academic_calendar;
$schedule = SchedulePeer::retrieveByPk($this->getRequestParameter('schedule_id'));
$this->forward404Unless($schedule);
$this->schedule = $schedule;
$schedule_detail = ScheduleDetailPeer::retrieveByPk($this->getRequestParameter('detail_id'));
$this->forward404Unless($schedule_detail);
$this->schedule_detail = $schedule_detail;
$cj = new Criteria();
$cj->add(GradeConversionPeer::DEPARTMENT_ID, $academic_calendar->getDepartmentId());
$cj->add(GradeConversionPeer::GRADE_CONVERSION_TEMPLATE_ID, 19);
$cj->add(GradeConversionPeer::TYPE_CONVERSION, ScoreRule::FIVE);
$cj->addDescendingOrderByColumn(GradeConversionPeer::MAX_VALUE);
$grade_convs = GradeConversionPeer::doSelect($cj);
$scores = $this->getRequestParameter('score');
foreach ($scores as $k => $score) {
if ($score != null) {
if ($score != '-') {
$ids = split('_', $k);
## $ids[0] = Cur13 Ekskul Id
## $ids[1] = Grade Spec Id
$cur13_ekskul = Cur13EkskulPeer::retrieveByPK($ids[0]);
$cur13_ekskul->setRemark($score);
$cur13_ekskul->save();
} else {
$ids = split('_', $k);
## $ids[0] = Cur13 Ekskul Id
## $ids[1] = Grade Spec Id
$cur13_ekskul = Cur13EkskulPeer::retrieveByPK($ids[0]);
if ($cur13_ekskul != null) {
$cur13_ekskul->delete();
}
}
}
}
return $this->redirect('extracurricular_new/listEksStu?id=' . $schedule->getId() . '&detail_id=' . $schedule_detail->getId() . '&accal_id=' . $academic_calendar->getId());
}
public static function getNilaiEkskul($studentAccal)
{
$c = new Criteria();
$c->add(Cur13EkskulPeer::STUDENT_ACCAL_ID, $studentAccal->getId(), Criteria::EQUAL);
return Cur13EkskulPeer::doSelect($c);
}
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(Cur13EkskulPeer::ID, $pks, Criteria::IN);
$objs = Cur13EkskulPeer::doSelect($criteria, $con);
}
return $objs;
}
