public static function doSelectFiltered() { $criteria = new Criteria(); $depts = sfContext::getInstance()->getUser()->getAttribute('department', null, 'bo'); $criteria->add(DepartmentPeer::ID, $depts->getChildRecurs(), Criteria::IN); $criteria->addJoin(AcademicCalendarPeer::DEPARTMENT_ID, DepartmentPeer::ID); $criteria->addJoin(RegPeriodPeer::ACADEMIC_CALENDAR_ID, AcademicCalendarPeer::ID); return RegPeriodPeer::doSelect($criteria); }
public function getRegPeriods($criteria = null, $con = null) { include_once 'lib/model/om/BaseRegPeriodPeer.php'; if ($criteria === null) { $criteria = new Criteria(); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collRegPeriods === null) { if ($this->isNew()) { $this->collRegPeriods = array(); } else { $criteria->add(RegPeriodPeer::ACADEMIC_CALENDAR_ID, $this->getId()); RegPeriodPeer::addSelectColumns($criteria); $this->collRegPeriods = RegPeriodPeer::doSelect($criteria, $con); } } else { if (!$this->isNew()) { $criteria->add(RegPeriodPeer::ACADEMIC_CALENDAR_ID, $this->getId()); RegPeriodPeer::addSelectColumns($criteria); if (!isset($this->lastRegPeriodCriteria) || !$this->lastRegPeriodCriteria->equals($criteria)) { $this->collRegPeriods = RegPeriodPeer::doSelect($criteria, $con); } } } $this->lastRegPeriodCriteria = $criteria; return $this->collRegPeriods; }
public static function retrieveByPKs($pks, $con = null) { if ($con === null) { $con = Propel::getConnection(self::DATABASE_NAME); } $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(); $criteria->add(RegPeriodPeer::ID, $pks, Criteria::IN); $objs = RegPeriodPeer::doSelect($criteria, $con); } return $objs; }