public function getTestApplicant() { $c = new Criteria(); $c->add(TestApplicantPeer::ID, $this->getPayer()); $ta = TestApplicantPeer::doSelectOne($c); return $ta; }
public function executeDoLogin() { if ($this->hasRequestParameter('login_user') && $this->hasRequestParameter('login_password')) { // check if the user exists $c = new Criteria(); $c->add(TestApplicantPeer::CODE, $this->getRequestParameter('login_user')); $user = TestApplicantPeer::doSelectOne($c); if ($user) { // check if the password is correct $password = $this->getRequestParameter('login_password'); $crypted = sha1(sfConfig::get('app_salt') . $password); if ($crypted == $user->getPassword()) { // sign in $this->getContext()->getUser()->signInApplicant($user); // proceed to home page $this->setTemplate('index'); return; } } // an error was found $this->getRequest()->setError('login_error_title', 'Login failed'); $this->getRequest()->setError('login_error_msg', 'Your username or password are not correct. Please try again.'); $this->getRequest()->setParameter('login_submit', null); return $this->forward('default', 'login'); } else { $this->forward('default', 'login'); } }
private function getThisApplicant() { $c = new Criteria(); $c->add(TestApplicantPeer::ENQUIRER_ID, $this->user->getId(), Criteria::EQUAL); $applicant = TestApplicantPeer::doSelectOne($c); return $applicant; }
public function executeUpdateApplicantGrade() { $grades = $this->getRequestParameter('grade'); foreach ($grades as $k => $grade) { if ($grade != null) { $ids = split('_', $k); $c = new Criteria(); $c->add(TestScorePeer::TEST_APPLICANT_ID, $ids[0]); $c->add(TestScorePeer::TEST_SUBJECT_ID, $ids[1]); $g = TestScorePeer::doSelectOne($c); if ($g == null) { $g = new TestScore(); } $g->setTestApplicantId($ids[0]); $g->setTestSubjectId($ids[1]); $g->setGrade($grade); $g->save(); } } $ts = TestSchedulePeer::retrieveByPK($this->getRequestParameter('id')); $avgGrades = $this->getRequestParameter('avgGrade'); foreach ($avgGrades as $appl_id => $avgGrade) { $c = new Criteria(); $c->add(TestApplSchedPeer::TEST_APPLICANT_ID, $appl_id); $c->add(TestApplSchedPeer::TEST_SCHEDULE_ID, $ts->getId()); $g = TestApplSchedPeer::doSelectOne($c); #if ($g == null) $g = new TestGrade(); $g->setTestApplicantId($appl_id); $g->setTestScheduleId($ts->getId()); $g->setAvgGrade($avgGrade); $g->save(); } $ranks = $this->getRequestParameter('rank'); foreach ($ranks as $appl_id => $rank) { $c = new Criteria(); $c->add(TestApplSchedPeer::TEST_APPLICANT_ID, $appl_id); $c->add(TestApplSchedPeer::TEST_SCHEDULE_ID, $ts->getId()); $g = TestApplSchedPeer::doSelectOne($c); #if ($g == null) $g = new TestGrade(); $g->setTestApplicantId($appl_id); $g->setTestScheduleId($ts->getId()); $g->setRank($rank); $g->save(); } $status_ = $this->getRequestParameter('status'); if ($status_) { foreach ($status_ as $appl_id => $status) { $c = new Criteria(); $c->add(TestApplicantPeer::ID, $appl_id); $ta = TestApplicantPeer::doSelectOne($c); #if ($g == null) $g = new TestGrade(); $ta->setId($appl_id); $ta->setStatus($status); $ta->save(); } } /** $location1_ = $this->getRequestParameter('location1'); if ($location1_) { foreach ($location1_ as $appl_id => $location) { $c = new Criteria(); $c->add(TestApplicantPeer::ID, $appl_id); $ta = TestApplicantPeer::doSelectOne($c); $ta->setId($appl_id); $ta->setLocation1($location); $ta->save(); } } **/ return $this->redirect('test_schedule/listApplicant?id=' . $ts->getId() . '&dept_id=' . $this->getRequestParameter('department_id') . '&location_id=' . $this->getRequestParameter('location_id')); }
public function getApplicant($user) { $applicantCriteria = new Criteria(); $applicantCriteria->add(TestApplicantPeer::TEST_APPLICANT_ENQUIRER_ID, $user->getId(), Criteria::EQUAL); return TestApplicantPeer::doSelectOne($applicantCriteria); }