<tr> <td></td> <td walign="left" style="font-size: 12px; font-weight: bold;"> <?php $cw = new Criteria(); $cw->add(StudentDetailPeer::SEX, 'L'); $cw->addJoin(VStudentActivePeer::STUDENT_DETAIL_ID, StudentDetailPeer::ID); $cw->add(VStudentActivePeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cw->add(VStudentActivePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $men = VStudentActivePeer::doCount($cw); $cm = new Criteria(); $cm->add(StudentDetailPeer::SEX, 'P'); $cm->addJoin(VStudentActivePeer::STUDENT_DETAIL_ID, StudentDetailPeer::ID); $cm->add(VStudentActivePeer::CLASS_GROUP_ID, $counseling->getClassGroupId()); $cm->add(VStudentActivePeer::ACADEMIC_CALENDAR_ID, $counseling->getAcademicCalendarId()); $women = VStudentActivePeer::doCount($cm); ?> Jumlah Murid<br> 1. Laki-laki : <?php echo $men . ' Anak'; ?> <br> 2. Perempuan : <?php echo $women . ' Anak'; ?> <br> Total : <?php echo $men + $women . ' Anak'; ?> <br><br> Wali Kelas<br><br><br><br>
echo ' even'; } ?> "> <td><?php echo $i + ($pager->getPage() - 1) * $pager->getMaxPerPage(); ?> </td> <td class='first'><?php echo $department->getName() ? $department->getName() : '-'; ?> </td> <td align="left"> <?php $c = new Criteria(); $c->add(AcademicCalendarPeer::DEPARTMENT_ID, $department->getId()); $c->addJoin(VStudentActivePeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); $member_count = VStudentActivePeer::doCount($c); echo $member_count > 0 ? $member_count : '-'; ?> </td> </tr> <?php } ?> <?php } ?> </tbody> </table> </center>
public function countVStudentActives($criteria = null, $distinct = false, $con = null) { include_once 'lib/model/om/BaseVStudentActivePeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } $criteria->add(VStudentActivePeer::TEST_APPLICANT_ID, $this->getId()); return VStudentActivePeer::doCount($criteria, $distinct, $con); }
public function executeEditAbsence() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $course_schedule = CourseSchedulePeer::retrieveByPk($this->getRequestParameter('course_id')); $this->forward404Unless($course_schedule); $tanggal = $this->getRequestParameter('time'); $attendance_class = AttendanceClassPeer::retrieveByPk($this->getRequestParameter('id')); $this->forward404Unless($attendance_class); $c = new Criteria(); $c->add(VStudentActivePeer::ACADEMIC_CALENDAR_ID, $course_schedule->getAcademicCalendar()->getParent()); $c->add(VStudentActivePeer::CLASS_GROUP_ID, $course_schedule->getClassGroupId()); $c->addAscendingOrderByColumn(VStudentActivePeer::CLASS_NAME); $students = VStudentActivePeer::doSelect($c); $count = VStudentActivePeer::doCount($c); $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('VStudentActive', $rpp); $pager->setCriteria($c); $page = $this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'student_active')); $this->getUser()->setAttribute('page', $page, 'student_active'); $pager->setPage($page); $pager->init(); $this->pager = $pager; $actions = array(array('name' => 'save', 'type' => 'submit', 'options' => array('class' => 'save_button', 'onclick' => "action_type.value=this.value"))); array_unshift($actions, array('name' => 'batal', 'url' => 'course_absence/listShow?course_id=' . $course_schedule->getId(), 'color' => 'black')); $this->actions = $actions; $actions2 = array(array('name' => '<span>Agenda Kelas</span>', 'url' => 'course_agenda/list?course_id=' . $course_schedule->getId(), 'color' => 'sun')); if ($course_schedule->getAcademicCalendar()->getCourseModel() == 'A') { array_unshift($actions2, array('name' => '<span>' . $course_schedule->getAcademicCalendar()->getName() . '</span>', 'url' => 'course/listScore', 'color' => 'sun')); } else { array_unshift($actions2, array('name' => '<span>' . $course_schedule->getAcademicCalendar()->getName() . '</span>', 'url' => 'course/listScore2', 'color' => 'sun')); } array_push($actions2, array('name' => '<span>Absensi Kelas</span>', 'url' => 'course_absence/listShow?course_id=' . $course_schedule->getId(), 'color' => 'sun', 'type' => 'direct')); array_push($actions2, array('name' => '<span>Jadwal Tugas / Ulangan / PR</span>', 'url' => 'course_test/list?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Bimbingan Konseling</span>', 'url' => 'course_counseling/list?course_id=' . $course_schedule->getId(), 'color' => 'sun')); $this->actions2 = $actions2; $this->subtitle = $course_schedule->getSubjectCurr()->getSubject()->getName() . ' - ' . $course_schedule->getClassGroup()->toString(); $this->course_schedule = $course_schedule; $this->employee = $employee; $this->tanggal = $tanggal; $this->students = $students; $this->course_schedule_id = $course_schedule->getId(); $this->attendance_class = $attendance_class; $this->count = $count; }
public function executeListShow() { $employee_id = sfContext::getInstance()->getUser()->getAttribute('user_id', null, 'bo'); $employee = EmployeePeer::retrieveByPK($employee_id); $this->forward404Unless($employee); $this->employee_id = $employee_id; $c = new Criteria(); $c->add(StudentRaportPeer::ACADEMIC_CALENDAR_ID, $this->getRequestParameter('accal_id')); $c->add(StudentCoursePeer::SUBJECT_CURR_ID, $this->getRequestParameter('subject_id')); $c->add(StudentCoursePeer::CLASS_GROUP_ID, $this->getRequestParameter('class_id')); $c->addJoin(VStudentActivePeer::ID, StudentCoursePeer::STUDENT_ID); $c->addAscendingOrderByColumn(VStudentActivePeer::NAME); $this->students = VStudentActivePeer::doSelect($c); $this->student_count = VStudentActivePeer::doCount($c); $subject_curr = SubjectCurrPeer::retrieveByPk($this->getRequestParameter('subject_id')); $this->forward404Unless($subject_curr); $class_group = ClassGroupPeer::retrieveByPk($this->getRequestParameter('class_id')); $this->forward404Unless($class_group); $academic_calendar = AcademicCalendarPeer::retrieveByPk($this->getRequestParameter('accal_id')); $this->forward404Unless($academic_calendar); $cw = new Criteria(); $cw->add(CourseSchedulePeer::SUBJECT_CURR_ID, $subject_curr->getId()); $cw->add(CourseSchedulePeer::CLASS_GROUP_ID, $class_group->getId()); $cw->add(CourseSchedulePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getId()); $course_schedule = CourseSchedulePeer::doSelectOne($cw); $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 1); $this->grade1 = GradeSpecPeer::doSelect($cr); $this->count1 = GradeSpecPeer::doCount($cr); $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 7); $this->grade2 = GradeSpecPeer::doSelect($cr); $this->count2 = GradeSpecPeer::doCount($cr); $cr = new Criteria(); $cr->add(GradeSpecPeer::PARENT, 30); $this->grade3 = GradeSpecPeer::doSelect($cr); $this->count3 = GradeSpecPeer::doCount($cr); $this->subject_curr = $subject_curr; $this->academic_calendar = $academic_calendar; $this->class_group = $class_group; $rpp = $this->getRequestParameter('max_per_page', 999); $pager = new sfPropelPager('Student', $rpp); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); $this->pager = $pager; $actions2 = array(array('name' => '<span>Daftar Guru Kelas</span>', 'url' => 'employee_agenda/list', 'color' => 'sun')); array_push($actions2, array('name' => '<span>Agenda Kelas</span>', 'url' => 'employee_agenda/listAgenda?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Absensi</span>', 'url' => 'employee_agenda/listAbsence?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Jadwal Tugas/Ulangan/PR</span>', 'url' => 'employee_agenda/listTest?course_id=' . $course_schedule->getId(), 'color' => 'sun')); array_push($actions2, array('name' => '<span>Penilaian</span>', 'url' => 'course_detail/listShow?subject_id=' . $course_schedule->getSubjectCurrId() . '&class_id=' . $course_schedule->getClassGroupId() . '&accal_id=' . $course_schedule->getAcademicCalendarId(), 'color' => 'sun', 'type' => 'direct')); if ($course_schedule->getClassGroup()->getParent() == 70 || $course_schedule->getClassGroup()->getParent() == 85 || $course_schedule->getClassGroup()->getParent() == 117) { array_push($actions2, array('name' => '<span>Penilaian Tryout</span>', 'url' => 'course_detail/listTryout?subject_id=' . $course_schedule->getSubjectCurrId() . '&class_id=' . $course_schedule->getClassGroupId() . '&accal_id=' . $course_schedule->getAcademicCalendarId(), 'color' => 'sun')); } $this->actions2 = $actions2; }