public function loadModel($j_id, $c_id)
{
$model = JobProfile::model()->findByPk(array('j_id' => $j_id, 'c_id' => $c_id));
if ($model == null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionSave($j_id, $c_id)
{
if (Yii::app()->session['role'] == 1) {
if (!(isset($_POST['cv_id']) && isset($j_id) && isset($c_id))) {
Yii::app()->user->setFlash('error', 'Error');
$this->redirect(array('index'));
}
$studinfo = Student::model()->findByPk(Yii::App()->user->id);
$dept = $studinfo->getAttribute("dept");
$cpi = $studinfo->getAttribute("cpi");
$sqlcount = Yii::app()->db->createCommand("select count(*) from job_profile_branches as jpb where j_id =\n " . $j_id . " and c_id = " . $c_id . " and dept = '" . $dept . "'")->queryScalar();
$jobinfo = JobProfile::model()->find('j_id = ? and c_id = ? and CURRENT_TIMESTAMP<deadline', array($j_id, $c_id));
if (count($jobinfo)) {
$cutoff = $jobinfo->getAttribute("cpi_cutoff");
if ($sqlcount && $cpi >= $cutoff) {
try {
$st_id = Yii::App()->user->id;
$connection = Yii::App()->db;
$sql = "INSERT INTO apply (j_id,c_id,cv_id,st_id) values(:j_id,:c_id,:cv_id,:st_id)";
$command = $connection->createCommand($sql);
$command->bindParam(":j_id", $j_id, PDO::PARAM_STR);
$command->bindParam(":c_id", $c_id, PDO::PARAM_STR);
$command->bindParam(":cv_id", $_POST['cv_id'], PDO::PARAM_STR);
$command->bindParam(":st_id", $st_id, PDO::PARAM_STR);
$command->execute();
Yii::app()->user->setFlash('success', 'Successfully Applied ');
} catch (Exception $e) {
Yii::app()->user->setFlash('error', 'You are trying to reapply');
}
} else {
Yii::app()->user->setFlash('error', 'CPI cutoff not satisfied ');
}
} else {
Yii::app()->user->setFlash('error', 'Deadline has been expired');
}
$this->redirect(array('site/index'));
}
}
