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));
}
