public function executeUpdatePackaged()
{
$student_id = $this->getRequestParameter('student_id');
$student = StudentPeer::retrieveByPK($student_id);
$this->forward404Unless($student);
$this->student = $student;
$academic_calendar_id = $this->getRequestParameter('academic_calendar_id');
$academic_calendar = AcademicCalendarPeer::retrieveByPK($academic_calendar_id);
$this->forward404Unless($academic_calendar);
$class_group_id = $this->getRequestParameter('class_group_id');
$class_group = ClassGroupPeer::retrieveByPK($class_group_id);
$this->forward404Unless($class_group);
$status = $this->getRequestParameter('status');
$this->forward404Unless($status);
$subject_accals = $academic_calendar->getSubjectAccals();
$sas = array();
foreach ($subject_accals as $sa) {
if ($sa->getSubject()) {
$sas[] = $sa->getId();
}
}
$saved_sas = array();
$saved_student_courses = $student->getStudentCourses();
foreach ($saved_student_courses as $ssc) {
$saved_sas[] = $ssc->getSubjectAccalId();
}
$disabled_sa = array_intersect($sas, $saved_sas);
// calculate sc rules
$objs = SubjectAccalPeer::doSelectByAccal();
foreach ($objs as $o) {
$content[$o->getId()] = $o->toStringWithLector();
$c = new Criteria();
$c->add(SubjectAccalPeer::ID, $o->getId());
$c->add(SubjectCurrPeer::SUBJECT_ID, $o->getSubjectId());
$c->addJoin(AcademicCalendarPeer::ID, SubjectAccalPeer::ACADEMIC_CALENDAR_ID);
$c->addJoin(AcademicCalendarPeer::CURRICULUM_ID, SubjectCurrPeer::CURRICULUM_ID);
$c->addJoin(SubjectCurrPeer::ID, SubjectPrereqPeer::SUBCURR);
$sps = SubjectPrereqPeer::doSelect($c);
foreach ($sps as $sp) {
$s = $sp->getSubjectCurrRelatedBySubcurrPrereq()->getSubject();
// prereq subject must be in closed state
$c = new Criteria();
$c->add(SubjectAccalPeer::SUBJECT_ID, $s->getId());
$c->add(StudentCoursePeer::STUDENT_ID, $student_id);
$c->add(StudentCoursePeer::STATUS, StudentCourse::STATUS_CLOSED);
$c->addJoin(StudentCoursePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID);
$scs = StudentCoursePeer::doSelect($c);
$isPassGrade = false;
$isPassCredit = true;
$isPassIndex = true;
foreach ($scs as $sc) {
$grade = $sc->getFinalGrade();
$gc = GradeConversionPeer::retrieveByName($grade[0]);
// check prereq subject grade
if ($gc && $gc->getGrade() >= $sp->getGradeConversion()->getGrade()) {
$isPassGrade = true;
} else {
$isPassGrade = false;
}
// check credit requirement
if ($sp->getTotalCredit() > 0) {
if ($sc->getTotalCreditClosed() >= $sp->getTotalCredit()) {
$isPassCredit = true;
} else {
$isPassCredit = false;
}
}
// check index requirement
if ($sp->getPerformanceIndex() > 0) {
if ($sc->getPerformanceIndex() >= $sp->getPerformanceIndex()) {
$isPassIndex = true;
} else {
$isPassIndex = false;
}
}
}
$s0 = $sp->getSubjectCurrRelatedBySubcurrPrereq()->getSubject()->toString();
$s1 = $sp->getSubjectCurrRelatedBySubcurr()->getSubject()->toString();
if (!$isPassGrade || !$isPassCredit || !$isPassIndex) {
$disabled_sa[] = $o->getId();
}
}
}
$selected_sa = array_diff($sas, $disabled_sa);
foreach ($selected_sa as $sa_id) {
$student_course = new StudentCourse();
$student_course->setStudentId($student_id);
$student_course->setSubjectAccalId($sa_id);
$student_course->setStatus($status);
$student_course->setClassGroupId($class_group_id);
$student_course->save();
}
return $this->redirect('student_course_s/list?student_id=' . $student->getId());
}
public function executeSelectByAccal()
{
$student_course_id = $this->getRequestParameter('student_course_id');
$student_course = StudentCoursePeer::retrieveByPK($student_course_id);
if (!$student_course) {
$student_course = new StudentCourse();
}
$student_id = $this->getRequestParameter('student_id');
$student = StudentPeer::retrieveByPK($student_id);
// $this->forward404Unless($student);
$accal_id = $this->getRequestParameter('accal_id');
$accal = AcademicCalendarPeer::retrieveByPK($accal_id);
$disabled = array();
if ($student) {
$student_courses = $student->getStudentCoursesJoinSubjectAccal();
foreach ($student_courses as $sc) {
if ($sc->getSubjectAccal()->getAcademicCalendarId() == $accal->getId() && $student_course->getSubjectAccalId() != $sc->getSubjectAccal()->getId()) {
$disabled[] = $sc->getSubjectAccal()->getId();
}
}
}
$content = array();
$objs = SubjectAccalPeer::doSelectByAccal();
if ($student) {
foreach ($objs as $o) {
$content[$o->getId()] = $o->toString();
$c = new Criteria();
$c->add(SubjectAccalPeer::ID, $o->getId());
$c->add(SubjectCurrPeer::SUBJECT_ID, $o->getSubjectId());
$c->addJoin(AcademicCalendarPeer::ID, SubjectAccalPeer::ACADEMIC_CALENDAR_ID);
$c->addJoin(AcademicCalendarPeer::CURRICULUM_ID, SubjectCurrPeer::CURRICULUM_ID);
$c->addJoin(SubjectCurrPeer::ID, SubjectPrereqPeer::SUBCURR);
$sps = SubjectPrereqPeer::doSelect($c);
foreach ($sps as $sp) {
$s = $sp->getSubjectCurrRelatedBySubcurrPrereq()->getSubject();
// prereq subject must be in closed state
$c = new Criteria();
$c->add(SubjectAccalPeer::SUBJECT_ID, $s->getId());
$c->add(StudentCoursePeer::STUDENT_ID, $student_id);
$c->add(StudentCoursePeer::STATUS, StudentCourse::STATUS_CLOSED);
$c->addJoin(StudentCoursePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID);
$scs = StudentCoursePeer::doSelect($c);
$isPassGrade = false;
$isPassCredit = true;
$isPassIndex = true;
foreach ($scs as $sc) {
$grade = $sc->getFinalGrade();
$gc = GradeConversionPeer::retrieveByName($grade[0]);
// check prereq subject grade
if ($gc && $gc->getGrade() >= $sp->getGradeConversion()->getGrade()) {
$isPassGrade = true;
} else {
$isPassGrade = false;
}
// check credit requirement
if ($sp->getTotalCredit() > 0) {
if ($sc->getTotalCreditClosed() >= $sp->getTotalCredit()) {
$isPassCredit = true;
} else {
$isPassCredit = false;
}
}
// check index requirement
if ($sp->getPerformanceIndex() > 0) {
if ($sc->getPerformanceIndex() >= $sp->getPerformanceIndex()) {
$isPassIndex = true;
} else {
$isPassIndex = false;
}
}
}
$s0 = $sp->getSubjectCurrRelatedBySubcurrPrereq()->getSubject()->toString();
$s1 = $sp->getSubjectCurrRelatedBySubcurr()->getSubject()->toString();
// echo "<div align=left><pre>";
// echo "$s1 -> $s0 | isPassGrade:$isPassGrade isPassCredit:$isPassCredit isPassIndex:$isPassIndex";
// echo "</pre></div>";
if (!$isPassGrade || !$isPassCredit || !$isPassIndex) {
$disabled[] = $o->getId();
}
}
}
} else {
foreach ($objs as $o) {
$content[$o->getId()] = $o->toString();
}
}
$this->content = $content;
$this->disabled = $disabled;
}
public function getPerformanceIndex()
{
$student = $this->getStudent();
$scs = $student->getVStudentCourses();
$total_credit = 0;
$total_grade = 0;
foreach ($scs as $sc) {
if ($sc->getStatus() == VStudentCourse::STATUS_CLOSED && $sc->isPass()) {
$grade = $sc->getFinalGrade();
$gc = GradeConversionPeer::retrieveByName($grade[0]);
$total_credit += $sc->getSubjectAccal()->getSubject()->getCredit();
$total_grade += $gc->getGrade() * $sc->getSubjectAccal()->getSubject()->getCredit();
}
}
if ($total_credit > 0 && $total_grade > 0) {
return $total_grade / $total_credit;
}
return 0;
}
<th><?php
echo __('Credit');
?>
</td>
<th><?php
echo __('Grade');
?>
</td>
</tr>
<?php
$i = 0;
$total_credit = 0;
$total_grade = 0;
foreach ($courses as $c) {
$grade = $c->getFinalGrade();
$gc = GradeConversionPeer::retrieveByName($grade[0]);
$total_credit += $c->getSubjectAccal()->getSubject()->getCredit();
$total_grade += $gc->getGrade() * $c->getSubjectAccal()->getSubject()->getCredit();
++$i;
?>
<tr <?php
echo $i % 2 == 0 ? 'style="background-color: #F4F4F2;"' : '';
?>
>
<td style="border: 1px solid black;padding: 2px 3px;" nowrap><?php
echo $i;
?>
</td>
<td style="border: 1px solid black;padding: 2px 3px;" nowrap><?php
echo $c->getSubjectAccal()->getSubject()->getCode();
?>
