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; }
/** * Get the associated Department object * * @param PropelPDO Optional Connection object. * @return Department The associated Department object. * @throws PropelException */ public function getDepartment(PropelPDO $con = null) { if ($this->aDepartment === null && $this->department_id !== null) { $c = new Criteria(DepartmentPeer::DATABASE_NAME); $c->add(DepartmentPeer::ID, $this->department_id); $this->aDepartment = DepartmentPeer::doSelectOne($c, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aDepartment->addEmployees($this); */ } return $this->aDepartment; }
p.subheader { font-size: 10px; } table.list_content { border-collapse: collapse; width: auto; margin: auto; margin-top: 20px; } table.list_content td, table.list_content th { border: 1px solid black; padding: 2px 4px; vertical-align: top; } .list_content th { font-style: italic; background-color: #F7E859; text-align: left; } .even td { background-color: #F4F4F2; } center.title { font-weight: bold; font-size: 14px; } center.subtitle { font-weight: bold; font-size: 10px; margin-bottom: 0px; } .pager_top { width: 100%; text-align: left; } .pager_record, .pager_page { display: none; } td.list { text-align: center; } </style> <?php $c = new Criteria(); $c->add(DepartmentPeer::PARENT, 0, Criteria::EQUAL); $dept = DepartmentPeer::doSelectOne($c); $c = new Criteria(); $c->add(DepartmentDetailPeer::DEPARTMENT_ID, $dept->getId()); $department_detail = DepartmentDetailPeer::doSelectOne($c); ?> <?php if (isset($note)) { ?> <table width="100%"> <tr> <td width="50%" style="text-align: left; vertical-align: middle;"> <img src='<?php echo image_path('logoBig_00.jpg', true); ?>