public function actionDoFocus() { if (!Yii::app()->request->isAjaxRequest) { $this->error('非法请求'); } $id = $_POST['id']; //首先查找问题是否存在 if (QuestionFocus::model()->exists('uid=:uid AND question_id=:question_id', array(':uid' => Yii::app()->user->id, ':question_id' => $id))) { $is_focus = true; } else { $is_focus = false; } $data = array(); if (!$is_focus) { $transaction = Yii::app()->db->beginTransaction(); try { //执行插入 $qf_model = new QuestionFocus(); $qf_model->question_id = $id; $qf_model->uid = Yii::app()->user->id; $qf_model->add_time = time(); if (!$qf_model->save()) { throw new ErrorException('关注失败'); } $this->incFocusCount($id); $transaction->commit(); $data['mesg'] = '关注成功'; $data['status'] = true; } catch (Exception $e) { $transaction->rollBack(); $data['mesg'] = '关注失败'; $data['status'] = false; } //取消关注 } else { $transaction = Yii::app()->db->beginTransaction(); try { //执行取消插入 if (!QuestionFocus::model()->deleteAll('question_id=:question_id AND uid=:uid', array(':question_id' => $id, ':uid' => Yii::app()->user->id))) { throw new Exception('取消关注失败'); } $this->DecFocusCount($id); $transaction->commit(); $data['mesg'] = '取消关注成功'; $data['status'] = true; } catch (Exception $e) { $transaction->rollBack(); $data['mesg'] = '取消关注失败'; $data['status'] = false; } } echo json_encode($data); }