public function create() { $question = new Question(); $question->setAttributes(['subject' => $this->subject, 'content' => $this->content, 'author_id' => $this->author_id]); if (($result = $question->save()) && ($result = $question->setActive())) { $tags = Tag::findAll(['name' => is_array($this->tags) ? $this->tags : explode(',', $this->tags)]); foreach ($tags as $tag) { $tagItem = new TagItem(); $tagItem->setAttributes(['target_id' => $question->id, 'target_type' => $question::TYPE]); $tag->addItem($tagItem); } } return $result ? $question : false; }
/** * 收藏问题 * @param User $user * @param Question $question */ public static function question(User $user, Question $model) { $data = ['target_id' => $model->id, 'target_type' => $model::TYPE, 'author_id' => $user->id, 'status' => static::STATUS_ACTIVE]; if (!static::deleteAll($data + ['type' => static::TYPE])) { // 删除数据有行数则代表有数据,无行数则添加数据 $favorite = new static(); $favorite->setAttributes($data); $result = $favorite->save(); if ($result) { $model->updateCounters(['favorite_count' => 1]); } return [$result, $favorite]; } $model->updateCounters(['favorite_count' => -1]); return [true, null]; }
public function run() { // Get list category of module question $model = \app\modules\category\models\Category::getCategory('question', '- '); // Get question quan tam nhieu nhat $concernedQuestion = Question::find()->where(['status' => 1])->andWhere(['stats.comment_count' => ['$gt' => 0]])->orderBy(['stats.comment_count' => -1])->limit(5)->all(); return $this->render('sidebar', ['model' => $model, 'concernedQuestion' => $concernedQuestion]); }
public function actionDoctor($id) { $query = Question::find(); $query->orderBy('_id ASC'); $query->where(['category' => $id, 'need_answer' => 1]); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]); return $this->render('doctor', ['model' => $dataProvider]); }
/** * 通过ID获取指定问题 */ protected function findQuestion($id, \Closure $callback = null) { $query = Question::find(); $callback !== null && $callback($query); if (($model = $query->andWhere(['id' => $id])->one()) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Question::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'pid' => $this->pid, 'author_id' => $this->author_id, 'view_count' => $this->view_count, 'comment_count' => $this->comment_count, 'favorite_count' => $this->favorite_count, 'like_count' => $this->like_count, 'hate_count' => $this->hate_count, 'status' => $this->status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'subject', $this->subject])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'type', $this->type]); return $dataProvider; }
public function run() { switch ($this->type) { case '': $questions = Question::find()->where(['category' => $this->cat_id])->limit(10)->orderBy('rand()')->all(); break; case 'comment': $questions = Question::find()->where(['count_comment' => ['$gt' => 0]])->limit(10)->orderBy('rand()')->all(); break; case 'cat': $questions = Category::find()->where(['lft' => ['$gt' => 1], 'module' => 'question'])->limit(4)->orderBy('rand()')->all(); default: break; } $assign = ['questions' => $questions, 'name' => $this->name]; return $this->render($this->view, $assign); }
/** * 获取问题 */ public function getQuestion() { return $this->hasOne(Question::className(), ['id' => 'pid']); }
/** * 创建新回答 * @param $question * @return Answer */ protected function newAnswer(Question $question) { $model = new Answer(); if ($model->load(Yii::$app->request->post())) { $model->author_id = Yii::$app->user->id; if ($question->addAnswer($model)) { return $this->message('回答发表成功!', 'success', $this->refresh(), 'flash'); } } return $model; }
/** * 获取用户发表的问题 * @return \yii\db\ActiveQuery */ public function getQuestion($id) { return $this->hasOne(Question::className(), ['author_id' => 'id'])->andWhere(['id' => $id]); }