public static function doSelectFilter() { $depts = sfContext::getInstance()->getUser()->getAttribute('department', null, 'bo'); $c = new Criteria(); $c->add(DepartmentDetailPeer::DEPARTMENT_ID, $depts->getId()); $dept_detail = DepartmentDetailPeer::doSelectOne($c); $criteria = new Criteria(); #$criteria->add(SubjectPeer::DEPARTMENT_ID, $depts->getChildRecurs(), Criteria::IN); #$criteria->addJoin(SubjectCurrPeer::SUBJECT_ID, SubjectPeer::ID); $criteria->add(CurriculumPeer::DEPARTMENT_ID, $dept_detail->getAccreditation(), Criteria::IN); $criteria->addJoin(SubjectCurrPeer::CURRICULUM_ID, CurriculumPeer::ID); $criteria->addAscendingOrderByColumn(SubjectPeer::NAME); return SubjectCurrPeer::doSelect($criteria); }
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(SubjectCurrPeer::ID, $pks, Criteria::IN); $objs = SubjectCurrPeer::doSelect($criteria, $con); } return $objs; }
public static function doSelectByCurriculumFromAccal($accal_id) { $accal = AcademicCalendarPeer::retrieveByPK($accal_id); if ($accal == null) { return array(); } $curr = CurriculumPeer::retrieveByPK($accal->getCurriculumId()); #$subject_curriculums = $curr->getSubjectCurrs(); #$subject_ids = array(); #foreach ($subject_curriculums as $subject_curriculum) { # $subject_ids[] = $subject_curriculum->getSubjectId(); #} #$depts = $curr->getDepartment()->getIdRecurs(); #$depts = explode(',', $depts); #$c = new Criteria(); #$c->add(SubjectPeer::DEPARTMENT_ID, $depts, Criteria::IN); #$c->add(SubjectPeer::ID, $subject_ids, Criteria::IN); #$c->addJoin(SubjectCurrPeer::SUBJECT_ID, SubjectPeer::ID); #$c->addJoin(SubjectCurrPeer::CURRICULUM_ID, CurriculumPeer::ID); #$c->addAscendingOrderByColumn(SubjectPeer::NAME); #return SubjectPeer::doSelect($c); $c = new Criteria(); $c->add(SubjectCurrPeer::CURRICULUM_ID, $curr->getId(), Criteria::IN); #$c->addJoin(SubjectCurrPeer::SUBJECT_ID, SubjectPeer::ID); $c->addAscendingOrderByColumn(SubjectCurrPeer::ID); return SubjectCurrPeer::doSelect($c); }
public function executeEditSubject() { $rule_id = $this->getRequestParameter('rule_id'); $score_rule = ScoreRulePeer::retrieveByPK($rule_id); $this->forward404Unless($score_rule); $curr = CurriculumPeer::retrieveByPK($score_rule->getAcademicCalendar()->getCurriculumId()); $this->curr = $curr; $subject_curriculums = $curr->getSubjectCurrs(); $subject_ids = array(); foreach ($subject_curriculums as $subject_curriculum) { $subject_ids[] = $subject_curriculum->getSubjectId(); } $c = new Criteria(); $c->add(SubjectPeer::DEPARTMENT_ID, $curr->getDepartmentId(), Criteria::IN); $c->add(SubjectPeer::ID, $subject_ids, Criteria::IN); $c->addJoin(SubjectCurrPeer::SUBJECT_ID, SubjectPeer::ID); $c->addAscendingOrderByColumn(SubjectCurrPeer::SUBJECT_ID); $subject_currs = SubjectCurrPeer::doSelect($c); $subj_ids = array(); foreach ($subject_currs as $subject_curr) { $subj_ids[$subject_curr->getId()] = $subject_curr->getSubject()->getName(); } $this->subj_ids = $subj_ids; /* foreach ($subject_currs as $sc) { $cm = new Criteria(); $cm->add(ScoreRuleSubjectPeer::SUBJECT_CURR_ID, $sc->getId()); $sc->rule = ScoreRuleSubjectPeer::doSelectOne($cm); } */ $sub_ids = array(); foreach ($subject_currs as $sub_curr) { $sub_ids = $sub_curr->getId(); } $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); array_push($actions, array('name' => 'cancel', 'url' => 'score_rule_new/listSubject?rule_id=' . $score_rule->getId(), 'color' => 'white')); $subtitle = $score_rule->toName(); $this->subtitle = $subtitle; $this->actions = $actions; $this->subject_currs = $subject_currs; $this->type = 'add'; $this->sub_ids = $sub_ids; $this->score_rule = $score_rule; $actions2 = array(array('name' => '<span>Aturan Penilaian</span>', 'url' => 'score_rule_new/list', 'color' => 'sun')); array_push($actions2, array('name' => '<span>Daftar Mata Pelajaran</span>', 'url' => 'score_rule_new/listSubject?rule_id=' . $score_rule->getId(), 'color' => 'sky', 'type' => 'direct')); array_push($actions2, array('name' => '<span>Daftar Kategori Penilaian</span>', 'url' => 'score_rule_new/listObject?rule_id=' . $score_rule->getId(), 'color' => 'sun')); $this->actions2 = $actions2; }
public function getSubjectCurrs($criteria = null, $con = null) { include_once 'lib/model/om/BaseSubjectCurrPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collSubjectCurrs === null) { if ($this->isNew()) { $this->collSubjectCurrs = array(); } else { $criteria->add(SubjectCurrPeer::SUBJECT_ID, $this->getId()); SubjectCurrPeer::addSelectColumns($criteria); $this->collSubjectCurrs = SubjectCurrPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(SubjectCurrPeer::SUBJECT_ID, $this->getId()); SubjectCurrPeer::addSelectColumns($criteria); if (!isset($this->lastSubjectCurrCriteria) || !$this->lastSubjectCurrCriteria->equals($criteria)) { $this->collSubjectCurrs = SubjectCurrPeer::doSelect($criteria, $con); } } } $this->lastSubjectCurrCriteria = $criteria; return $this->collSubjectCurrs; }
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; }
public function executeSelectByAccal() { $accal_id = $this->getRequestParameter('accal_id'); $accal = AcademicCalendarPeer::retrieveByPK($accal_id); $content = array(); $c = new Criteria(); $c->add(SubjectCurrPeer::CURRICULUM_ID, $accal->getCurriculumId()); $c->addJoin(SubjectPeer::ID, SubjectCurrPeer::SUBJECT_ID); $c->addAscendingOrderByColumn(SubjectPeer::NAME); $objs = SubjectCurrPeer::doSelect($c); foreach ($objs as $o) { if ($o->getSubject()->getDepartmentId() == 40) { $content[$o->getId()] = $o->getSubject()->getDescription(); } else { $content[$o->getId()] = $o->toStringSubject(); } } $this->content = $content; $this->disabled = $disabled; }
public function executeEditSched() { $group_id = $this->getContext()->getUser()->getAttribute('group_id', null, 'bo'); $c = new Criteria(); $c->add(JobPeer::CODE, 'schedule/listSched'); $job = JobPeer::doSelectOne($c); $acl = AclPeer::retrieveByPK($group_id, $job->getId()); if (!$acl) { $this->forward('default', 'error404'); } $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $schedule = SchedulePeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($schedule); $this->setTemplate('editSched'); $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'schedule/deleteSched?id=' . $schedule->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'schedule/listSched', 'color' => 'black')); $this->subtitle = $schedule->toString() . ' - id:' . $schedule->getId(); $this->type = 'edit'; $this->schedule = $schedule; $this->actions = $actions; $c = new Criteria(); $c->add(TeachingCompetencyPeer::SUBJECT_ID, $schedule->getSubjectCurr()->getSubjectId()); $c->addJoin(TeachingCompetencyPeer::EMPLOYEE_ID, EmployeePeer::ID); $objs = EmployeePeer::doSelect($c); $lectors = array(); foreach ($objs as $o) { $lectors[$o->getId()] = $o->getName(); } $this->coordinators = $lectors; $this->lectors = $lectors; $this->selected_lector = $schedule->getEmployeeId(); $subject_currs_options = array(); $c = new Criteria(); $c->add(SubjectCurrPeer::CURRICULUM_ID, $schedule->getSubjectCurr()->getCurriculumId()); $subject_currs = SubjectCurrPeer::doSelect($c); foreach ($subject_currs as $sa) { $subject_currs_options[$sa->getId()] = $sa->getSubject()->getName(); } $this->subject_currs = $subject_currs_options; $this->selected_subject_curr = $schedule->getSubjectCurrId(); }
public function executeEdit() { $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()); $this->can_add = $acl->getAddPriv() == 1; $this->can_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $course_regulation = CourseRegulationPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($course_regulation); $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); if ($acl->getRemovePriv()) { array_push($actions, array('name' => 'delete', 'url' => 'course_regulation/delete?id=' . $course_regulation->getId(), 'color' => 'red')); } array_push($actions, array('name' => 'cancel', 'url' => 'course_regulation/list', 'color' => 'black')); $this->subtitle = $course_regulation->toString() . ' - id:' . $course_regulation->getId(); $this->type = 'edit'; $this->course_regulation = $course_regulation; $this->actions = $actions; $c = new Criteria(); $c->add(SubjectGradingPeer::SUBJECT_CURR_ID, $course_regulation->getSubjectCurrId()); $objs = SubjectGradingPeer::doSelect($c); $subject_grades = array(); foreach ($objs as $o) { $subject_grades[$o->getId()] = $o->getGradeComponent()->getName(); } $this->subject_grades = $subject_grades; $this->selected_subject_grade = $course_regulation->getSubjectGradingId(); $subject_currs_options = array(); $c = new Criteria(); $c->add(SubjectCurrPeer::CURRICULUM_ID, $course_regulation->getSubjectCurr()->getCurriculumId()); $subject_currs = SubjectCurrPeer::doSelect($c); foreach ($subject_currs as $sa) { $subject_currs_options[$sa->getId()] = $sa->getSubject()->getName(); } $this->subject_currs = $subject_currs_options; $this->selected_subject_curr = $course_regulation->getSubjectCurrId(); }