Esempio n. 1
0
 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);
 }
Esempio n. 2
0
 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;
     }
 }