public function countStudentCourses($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BaseStudentCoursePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(StudentCoursePeer::SUBJECT_CURR_ID, $this->getId()); return StudentCoursePeer::doCount($criteria, $distinct, $con); }
echo __('Subject'); ?> ","<?php echo __('Credit'); ?> ","<?php echo __('Subject group'); ?> " <?php $i = 0; foreach ($pager->getResults() as $subject_curr) { $c = new Criteria(); $c->addJoin(StudentCoursePeer::SUBJECT_ACCAL_ID, SubjectAccalPeer::ID); $c->add(SubjectAccalPeer::SUBJECT_ID, $subject_curr->getSubjectId()); $sc = StudentCoursePeer::doCount($c); ++$i; ?> "<?php echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage(); ?> ","<?php echo $subject_curr->getSubject() && strlen($subject_curr->getSubject()->toString()) > 0 ? $subject_curr->getSubject()->toString() : 'n/a'; ?> ","<?php echo $subject_curr->getSubject()->getCredit(); ?> ","<?php echo $subject_curr->getSubject()->getSubjectGroup() ? $subject_curr->getSubject()->getSubjectGroup()->toString() : '-'; ?> "
public function executeList() { $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_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $student_id = $this->getContext()->getUser()->getAttribute('user_id', '', 'bo'); $student = StudentPeer::retrieveByPK($student_id); $this->forward404Unless($student); $c = new Criteria(); $c->add(StudentCoursePeer::STUDENT_ID, $student->getId()); $this->student = $student; $this->sort($c); if ($this->getRequest()->hasParameter('filters')) { $filters = $this->getRequestParameter('filters'); if ($filters == 'clear') { $this->filters = null; } else { $defined_filter = false; foreach ($filters as $f) { if (is_array($f)) { if (strlen($f['from']) > 0 || strlen($f['to']) > 0) { $defined_filter = true; break; } } else { if ($f != null && $f != '') { $defined_filter = true; break; } } } if ($defined_filter) { $this->filters = $filters; $this->filter($c, $this->getRequestParameter('filters')); } } } $rpp = $this->getRequestParameter('max_per_page', $this->getUser()->getAttribute('max_per_page', ParamsPeer::retrieveByCode('row_per_page')->getValue(), 'student_course_s')); $this->getUser()->setAttribute('max_per_page', $rpp, 'student_course_s'); $pager = new sfPropelPager('StudentCourse', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student_course_s')); $this->getUser()->setAttribute('page', $page, 'student_course_s'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'filter', 'color' => 'white')); if ($acl->getAddPriv()) { array_unshift($actions, array('name' => 'add', 'url' => 'student_course_s/create?student_id=' . $student->getId(), 'color' => 'green')); } $filter_string = ""; if ($this->filters) { foreach ($this->filters as $key => $val) { $filter_string .= "&filters[{$key}]={$val}"; } $filter_string = preg_replace('/^&/', '', $filter_string); } array_unshift($actions, array('name' => '_AS_CSV_', 'url' => "student_course_s/listAsCSV?student_id={$student_id}&{$filter_string}", 'color' => 'white', 'type' => 'direct')); array_unshift($actions, array('name' => '_AS_PDF_', 'url' => "student_course_s/listAsPDF?student_id={$student_id}&{$filter_string}", 'color' => 'white', 'type' => 'direct')); $this->actions = $actions; // do we need to display bank_transfer_confirmation link? $c = new Criteria(); $c->add(StudentCoursePeer::STATUS, StudentCourse::STATUS_APPROVED); $this->approved_sc = StudentCoursePeer::doCount($c) > 0; }
$c->add(CourseScheduleDetailPeer::COURSE_SCHEDULE_ID, $cd->getId()); $c->addDescendingOrderByColumn(CourseScheduleDetailPeer::ID); $cs_details = CourseScheduleDetailPeer::doSelect($c); foreach ($cs_details as $detail) { echo '·' . $detail->getDayString() . ' - ' . $detail->getLocation()->toString() . ' <br> <font style="color: #017FC0;">(' . $detail->getClassSession()->getBegin() . ' - ' . $detail->getClassSession()->getEnd() . ')</font><br>'; } } ?> </td> <td> <?php $c = new Criteria(); $c->add(StudentCoursePeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendarId()); $c->add(StudentCoursePeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentCoursePeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $total = StudentCoursePeer::doCount($c); ?> <?php echo link_to_remote($total, array('url' => 'course_detail/list?subject_id=' . $course_schedule->getSubjectCurrId() . '&class_id=' . $course_schedule->getClassGroupId() . '&accal_id=' . $course_schedule->getAcademicCalendarId(), 'update' => 'content', 'script' => 'true', 'loading' => "showIndicator('content', 'snakebig_black');", 'complete' => "hideIndicator()"), array('class' => 'white', 'title' => __('Jumlah Siswa'))); ?> </td> </tr> <?php } ?> <?php } ?> </tbody> </table> <?php
public function executeListDevelopment() { $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_edit = $acl->getEditPriv() == 1; $this->can_remove = $acl->getRemovePriv() == 1; $student_id = $this->getRequestParameter('student_id'); $student = StudentPeer::retrieveByPK($student_id); $this->student = $student; $this->forward404Unless($student); $c = new Criteria(); $c->add(GradeComponentPeer::GRADE_SPEC_ID, '20'); $c->add(GradeComponentPeer::PUBLISHED, '1'); $c->addAscendingOrderByColumn(GradeComponentPeer::NAME); $this->components = GradeComponentPeer::doSelect($c); $this->component_count = GradeComponentPeer::doCount($c); $c = new Criteria(); $c->add(VCoursePeer::CLASS_GROUP_ID, $student->getClassGroupId()); $c->add(VCoursePeer::ACADEMIC_CALENDAR_ID, $student->getAcademicCalendarId()); $subjects = VCoursePeer::doSelectOne($c); $this->subject_count = VCoursePeer::doCount($c); if ($subject_count > 1) { $actions2 = array(array('name' => 'add', 'url' => 'student_score/createDev?student_id=' . $student->getId(), 'color' => 'black')); } #array_unshift($actions, array('name'=>'edit','url'=>'student_score/editDev?student_id='.$student->getId(), 'color'=>'black')); $c = new Criteria(); $c->add(GradeComponentPeer::GRADE_SPEC_ID, '20'); $c->add(GradeComponentPeer::PUBLISHED, '1'); $c->addAscendingOrderByColumn(GradeComponentPeer::NAME); $comps = GradeComponentPeer::doSelect($c); $comp_ids = array(); foreach ($comps as $comp) { $comp_ids[] = $comp->getId(); } $c = new Criteria(); $cton1 = $c->getNewCriterion(StudentCoursePeer::STUDENT_ID, $student->getId(), Criteria::IN); $cton2 = $c->getNewCriterion(StudentCoursePeer::CLASS_GROUP_ID, $student->getClassGroupId(), Criteria::IN); $cton3 = $c->getNewCriterion(StudentCoursePeer::ACADEMIC_CALENDAR_ID, $student->getAcademicCalendarId(), Criteria::IN); $cton4 = $c->getNewCriterion(StudentCoursePeer::GRADE_COMPONENT_ID, $comp_ids, Criteria::NOT_IN); $cton5 = $c->getNewCriterion(StudentCoursePeer::GRADE_COMPONENT_ID, '0', Criteria::NOT_IN); $cton1->addAnd($cton2); $cton2->addAnd($cton3); $cton3->addAnd($cton4); $cton4->addAnd($cton5); $c->add($cton4); $stu_courses = StudentCoursePeer::doSelect($c); $stu_count = StudentCoursePeer::doCount($c); $rpp = $this->getRequestParameter('max_per_page', 999); $pager2 = new sfPropelPager('GradeComponent', $rpp); $pager2->setCriteria($c); $pager2->setPage($this->getRequestParameter('page', 1)); $pager2->init(); $this->pager2 = $pager2; $this->actions2 = $actions2; }
public function executeSavePreview() { $class_id = $this->getRequestParameter('class_group_id'); $accal_id = $this->getRequestParameter('academic_calendar_id'); $c = new Criteria(); $c->add(StudentPeer::CLASS_GROUP_ID, $this->getRequestParameter('class_group_id')); $students = StudentPeer::doSelect($c); $counts = StudentPeer::doCount($c); $c = new Criteria(); $c->add(GradeComponentPeer::GRADE_SPEC_ID, '20'); $c->add(GradeComponentPeer::PUBLISHED, '1'); $components = GradeComponentPeer::doSelect($c); $accal = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('academic_calendar_id')); $c = new Criteria(); $c->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $accal_id); $c->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_id); $course_schedules = CourseSchedulePeer::doSelect($c); $counts = CourseSchedulePeer::doCount($c); if ($accal->getCurriculum()->getCourseModel() == Curriculum::CM_PACKAGED || $accal->getCurriculum()->getCourseModel() == Curriculum::CM_PACKAGED_CUSTOM) { #if ($counts > 1) { foreach ($course_schedules as $course_schedule) { foreach ($students as $student) { $c = new Criteria(); $c->add(StudentCoursePeer::SUBJECT_CURR_ID, $course_schedule->getSubjectCurrId()); $c->add(StudentCoursePeer::STUDENT_ID, $student->getId()); $stu_courses = StudentCoursePeer::doCount($c); if ($stu_courses < 1) { $student_course = new StudentCourse(); $student_course->setStudentId($student->getId()); $student_course->setSubjectCurrId($course_schedule->getSubjectCurrId()); $student_course->setStatus(1); $student_course->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $student_course->setClassGroupId($this->getRequestParameter('class_group_id')); $student_course->save(); } } } foreach ($students as $student) { foreach ($components as $component) { $c = new Criteria(); $c->add(StudentCoursePeer::STUDENT_ID, $student->getId()); $c->add(StudentCoursePeer::GRADE_COMPONENT_ID, $component->getId()); $com_courses = StudentCoursePeer::doCount($c); if ($com_courses < 1) { $student_course = new StudentCourse(); $student_course->setStudentId($student->getId()); $student_course->setStatus(1); $student_course->setAcademicCalendarId($this->getRequestParameter('academic_calendar_id')); $student_course->setClassGroupId($this->getRequestParameter('class_group_id')); $student_course->setGradeComponentId($component->getId()); $student_course->save(); } } } #} } return $this->redirect('course_schedule/list'); }