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