public function actionAddTrainingLog() { $action_url = $_POST['action_url']; $action_name = $_POST['action_name']; $action_datetime = date('Y-m-d H:i:s'); $user_id = Yii::app()->user->id; $modelTrainingLog = WTrainingLog::model()->find('action_url ="' . $action_url . '" AND user_id=' . $user_id . ' AND action_name="' . $action_name . '"'); if (empty($modelTrainingLog)) { $modelTrainingLog = new WTrainingLog(); } else { $where = ''; if (!empty($modelTrainingLog->action_url)) { $course_lecture_id = str_replace('r=wlecture/lectureview&course_lecture_id=', '', strtolower($modelTrainingLog->action_url)); $where = ' AND course_lecture_id=' . $course_lecture_id; } Yii::app()->db->createCommand()->delete('pls_training_randomquestion', 'training_log_id=' . $modelTrainingLog->id . ' AND trainee_id=' . Yii::app()->user->id . $where); } $modelTrainingLog->action_url = $action_url; $modelTrainingLog->action_datetime = $action_datetime; $modelTrainingLog->action_name = $action_name; $modelTrainingLog->user_id = $user_id; if ($modelTrainingLog->save()) { echo json_encode(array('status' => 'true', 'idTrainingLog' => $modelTrainingLog->id)); } else { echo json_encode(array('status' => 'false')); } }