/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Joke::find()->where(['<>', 'joke.active', 3]); $query->joinWith(['person']); //$query->andWhere(['<>', 'joke.active', 3]); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['nick'] = ['asc' => ['person.nick' => SORT_ASC], 'desc' => ['person.nick' => SORT_DESC]]; if (!($this->load($params) && $this->validate())) { return $dataProvider; } /*$query->andFilterWhere(['id'=>$this->id]); $query->andFilterWhere(['person_id'=>$this->person_id]);*/ $query->andFilterWhere(['id' => $this->id, 'create_date' => $this->create_date, 'views' => $this->views, 'active' => $this->active]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'person_id', $this->person_id]); /*$query->joinWith(['person' => function ($q) { $q->where('person.nick LIKE "%' . $this->nick . '%"'); }]);*/ $query->andFilterWhere(['like', 'person.nick', $this->nick]); return $dataProvider; }
public function getJoke($joke_id) { return Joke::find()->where(['id' => $joke_id])->one(); }