public function executeCreatePackaged()
{
$student_id = $this->getRequestParameter('student_id');
$student = StudentPeer::retrieveByPK($student_id);
$this->forward404Unless($student);
$this->student = $student;
$group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo');
$c = new Criteria();
$c->add(JobPeer::CODE, $this->getModuleName());
$job = JobPeer::doSelectOne($c);
$acl = AclPeer::retrieveByPK($group_id, $job->getId());
if (!$acl) {
$this->forward('default', 'error404');
}
$this->can_add = $acl->getAddPriv() == 1;
$this->can_edit = $acl->getEditPriv() == 1;
$this->can_remove = $acl->getRemovePriv() == 1;
$accal_options = array();
$accals = $student->getAcademicCalendar()->getCurriculum()->getAcademicCalendars();
foreach ($accals as $accal) {
if ($accal->getParent() != null) {
$accal_options[$accal->getId()] = ' . ' . $accal->toString();
} else {
$accal_options[$accal->getId()] = $accal->toString();
}
}
$this->accal_options = $accal_options;
$c = new Criteria();
$c->add(AcademicCalendarPeer::ID, $student->getAcademicCalendarId());
$c->addJoin(CurriculumPeer::ID, AcademicCalendarPeer::CURRICULUM_ID);
$c->addJoin(SubjectCurrPeer::CURRICULUM_ID, CurriculumPeer::ID);
$c->addJoin(SubjectCurrPeer::SUBJECT_ID, SubjectPeer::ID);
$c->addAscendingOrderByColumn(CurriculumPeer::CODE);
$c->addAscendingOrderByColumn(SubjectPeer::CODE);
$c->addAscendingOrderByColumn(SubjectPeer::NAME);
$c->setDistinct();
$subject_currs = SubjectCurrPeer::doSelect($c);
$sas = array();
$all_sa = array();
foreach ($subject_currs as $sa) {
$sas[] = $sa->getId();
if ($sa->getSubject()) {
$all_sa[$sa->getId()] = $sa->toString();
}
}
$saved_sas = array();
$saved_student_courses = $student->getStudentCourses();
foreach ($saved_student_courses as $ssc) {
$saved_sas[] = $ssc->getSubjectCurrId();
}
$disabled_sa = array_intersect($sas, $saved_sas);
// calculate sc rules
$objs = SubjectCurrPeer::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);
$this->disabled_sa = $disabled_sa;
$this->selected_sa = $selected_sa;
$this->all_sa = $all_sa;
$this->subject_accals = $subject_accals;
$c = new Criteria();
$c->add(CourseSchedulePeer::CLASS_GROUP_ID, $student->getClassGroupId());
$c->add(CourseSchedulePeer::SUBJECT_ACCAL_ID, $selected_sa, Criteria::IN);
$c->addJoin(CourseSchedulePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID);
$c->addJoin(SubjectAccalPeer::SUBJECT_ID, SubjectPeer::ID);
$c->addJoin(CourseSchedulePeer::CLASS_SESSION_ID, ClassSessionPeer::ID);
$c->addAscendingOrderByColumn(SubjectPeer::CODE);
$c->addAscendingOrderByColumn(CourseSchedulePeer::EMPLOYEE_ID);
$c->addAscendingOrderByColumn(CourseSchedulePeer::LOCATION_ID);
$c->addAscendingOrderByColumn(CourseSchedulePeer::DAY);
$c->addAscendingOrderByColumn(ClassSessionPeer::CODE);
$c->setDistinct();
$css = CourseSchedulePeer::doSelect($c);
$this->student_course = new StudentCourse();
$this->setTemplate('editPackaged');
$this->actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value")), array('name' => 'cancel', 'url' => 'student_course/list?student_id=' . $student->getId(), 'color' => 'white'));
if ($student->getAcademicCalendar()->getCourseModelRecurs() == AcademicCalendar::CM_PACKAGED_CUSTOM) {
array_unshift($this->actions, array('name' => 'add custom course', 'url' => 'student_course/create?student_id=' . $student->getId() . '&custom=1', 'color' => 'green'));
}
$this->subtitle = $student->toString();
$this->type = 'add';
$this->schedules = $css;
}
