public static function doSelectByRegPeriod(Criteria $c = null, $rpi = null) { $tsi = null; if ($rpi == null) { $tsi = sfContext::getInstance()->getRequest()->getParameter('id'); } if ($rpi == null && $tsi == null) { return array(); } $ids = ''; if ($rpi != null) { $c = new Criteria(); $c->addJoin(RegPeriodPeer::CURRICULUM_ID, CurriculumPeer::ID); $c->addJoin(CurriculumPeer::DEPARTMENT_ID, DepartmentPeer::ID); $c->add(RegPeriodPeer::ID, $rpi); $dept = DepartmentPeer::doSelectOne($c); $ids = $dept->getIdRecurs(); } if ($tsi != null) { $c = new Criteria(); $c->addJoin(RegPeriodPeer::CURRICULUM_ID, CurriculumPeer::ID); $c->addJoin(CurriculumPeer::DEPARTMENT_ID, DepartmentPeer::ID); $c->addJoin(TestSchedulePeer::REG_TEST_PERIOD_ID, RegTestPeriodPeer::ID); $c->add(TestSchedulePeer::ID, $tsi); $dept = DepartmentPeer::doSelectOne($c); $ids = $dept->getIdRecurs(); } $sql = "select * from test_subject where department_id in ({$ids})"; $connection = Propel::getConnection(); $statement = $connection->createStatement(); $result = $statement->executeQuery($sql, ResultSet::FETCHMODE_NUM); $objs = TestSubjectPeer::populateObjects($result); return $objs; }
public static function doSelect(Criteria $criteria, $con = null) { return TestSubjectPeer::populateObjects(TestSubjectPeer::doSelectRS($criteria, $con)); }