private function userSchoolInit() { /* Getting User School */ $schoolCriteria = new Criteria(); $schoolCriteria->add(ClassGroupPeer::DEPARTMENT_ID, $this->department->getId(), Criteria::EQUAL); $this->school = ClassGroupPeer::doSelectOne($schoolCriteria); /* Getting User Classes */ $classesCriteria = new Criteria(); $classesCriteria->add(ClassGroupPeer::PARENT, $this->school->getId(), Criteria::EQUAL); $classTemp = ClassGroupPeer::doSelect($classesCriteria); $classArray = array(); foreach ($classTemp as $temp) { $classArray[] = $temp->getId(); } $classesCriteria2 = new Criteria(); $classesCriteria2->add(ClassGroupPeer::PARENT, $classArray, Criteria::IN); $classesCriteria2->addAscendingOrderByColumn(ClassGroupPeer::NAME); $this->classes = ClassGroupPeer::doSelect($classesCriteria2); }
public function getStudents($classId) { $classCriteria = new Criteria(); $classCriteria->add(ClassGroupPeer::ID, $classId, Criteria::IN); $class = ClassGroupPeer::doSelectOne($classCriteria); $accal = $this->getAccal($class->getDepartmentId()); $criteria = new Criteria(); $criteria->add(StudentPeer::CLASS_GROUP_ID, $classId, Criteria::IN); $criteria->add(StudentPeer::STUDENT_DETAIL_ID, 0, Criteria::NOT_EQUAL); $criteria->add(StudentPeer::ACADEMIC_CALENDAR_ID, $accal->getId(), Criteria::EQUAL); $criteria->add(StudentPeer::STATUS, 1, Criteria::EQUAL); $criteria->addAscendingOrderByColumn(StudentPeer::NAME); $result = StudentPeer::doSelect($criteria); if (!$result) { return false; } else { return $result; } }