public static function doFiltered(Criteria $criteria, $con = null)
{
$id = sfContext::getInstance()->getRequest()->getParameter('ng_reg_period_id');
$nrp = NgRegPeriodPeer::retrieveByPK($id);
$criteria->add(NgRegTestPeriodPeer::NG_REG_PERIOD_ID, $nrp->getId());
$criteria->add(NgRegTestPeriodPeer::REG_TYPE, NgRegTestPeriod::TEST);
$criteria->addDescendingOrderByColumn(NgRegTestPeriodPeer::ID);
return NgRegTestPeriodPeer::doSelect($criteria);
}
public function executeUpdateScore()
{
$this->ng_reg_period = NgRegPeriodPeer::retrieveByPK($this->getRequestParameter('ng_reg_period_id'));
$this->forward404Unless($this->ng_reg_period);
$scores = $this->getRequestParameter('score');
foreach ($scores as $m => $score) {
$ids = split('_', $m);
$ng_test_applicant = NgTestApplicantPeer::retrieveByPK($ids[1]);
$ng_test_applicant->setNgStatusApplicantId(4);
$ng_test_applicant->save();
}
return $this->redirect('ng_reg_detail/list?id=' . $this->ng_reg_period->getId());
}
public function getNgRegPeriod($con = null)
{
include_once 'lib/model/om/BaseNgRegPeriodPeer.php';
if ($this->aNgRegPeriod === null && $this->ng_reg_period_id !== null) {
$this->aNgRegPeriod = NgRegPeriodPeer::retrieveByPK($this->ng_reg_period_id, $con);
}
return $this->aNgRegPeriod;
}
public static function doSelectByTestPeriod(Criteria $criteria, $con = null)
{
$ng_reg_period_id = sfContext::getInstance()->getRequest()->getParameter('ng_reg_period_id');
$ng_reg_period = NgRegPeriodPeer::retrieveByPK($ng_reg_period_id);
if ($ng_reg_period == null) {
return array();
}
$criteria->add(LocationPeer::DEPARTMENT_ID, $ng_reg_period->getAcademicCalendar()->getDepartmentId(), Criteria::IN);
$tmp_depts = LocationPeer::doSelect($criteria);
$depts = array();
foreach ($tmp_depts as $key => $val) {
$pi = $val->getParentalIndex();
$prefix = '';
for ($i = 0; $i < $val->level - 1; $i++) {
$prefix .= ParamsPeer::retrieveByCode('tree_node_mark')->getValue();
}
$val->setCampus($prefix . $val->getCampus());
$val->setCode($prefix . $val->getCode());
$depts[$pi] = $val;
}
ksort($depts);
$result = array();
foreach ($depts as $r) {
$result[] = $r;
}
return $result;
}
