public function actionEducation()
{
$userdetails = \Yii::$app->user->identity;
$model = Education::find()->where(['user_id' => $userdetails->id])->one();
if (empty($model)) {
$model = new Education();
}
$userprofile = UserProfile::find()->where(['user_id' => $userdetails->id])->one();
if (empty($userprofile)) {
$userprofile = new UserProfile();
}
$user = Userform::find()->where(['id' => $userdetails->id])->one();
if (empty($user)) {
$user = new Userform();
}
//echo "<pre>";print_r($user->competitiveExamDestails);die;
if (isset($_POST['Education'])) {
$model->attributes = $_POST['Education'];
$model->user_id = $userdetails->id;
$model->course_name = $_POST['Education']['course_name'];
$model->branch = $_POST['Education']['course_name'];
$model->school_college = $_POST['Education']['school_college'];
$model->university_board = $_POST['Education']['university_board'];
$model->is_passed = $_POST['Education']['is_passed'];
$model->backlog = $_POST['Education']['backlog'];
$model->total_marks = $_POST['Education']['total_marks'];
$model->obtained_marks = $_POST['Education']['obtained_marks'];
$attend_date = explode('/', $_POST['Education']['attend_date']);
$model->attend_date = $attend_date[2] . '-' . $attend_date[1] . '-' . $attend_date[0];
$passing_year = explode('/', $_POST['Education']['passing_year']);
$model->passing_year = $passing_year[2] . '-' . $passing_year[1] . '-' . $passing_year[0];
$model->description = $_POST['Education']['description'];
if ($model->validate()) {
if (isset($_POST['isnew'])) {
\Yii::$app->db->createCommand()->insert('tlb_education', ['course_name' => $model->course_name, 'branch' => $model->branch, 'school_college' => $model->school_college, 'university_board' => $model->university_board, 'is_passed' => $model->is_passed, 'backlog' => $model->backlog, 'total_marks' => $model->total_marks, 'obtained_marks' => $model->obtained_marks, 'attend_date' => $model->attend_date, 'passing_year' => $model->passing_year, 'description' => $model->description, 'created' => new \yii\db\Expression('NOW()'), 'user_id' => $userdetails->id])->execute();
} else {
$model->save();
}
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
return ['data' => $model];
}
}
return $this->render('education', ['model' => $model, 'user' => $user, 'userprofile' => $userprofile]);
}
