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