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