/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Artikel::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'author' => $this->author, 'categori_id' => $this->categori_id, 'schedule_date' => $this->schedule_date, 'status' => $this->status, 'viewed' => $this->viewed, 'user_create' => $this->user_create, 'user_update' => $this->user_update, 'date_create' => $this->date_create, 'date_update' => $this->date_update]);
$query->andFilterWhere(['like', 'judul', $this->judul])->andFilterWhere(['like', 'summary', $this->summary])->andFilterWhere(['like', 'deskripsi', $this->deskripsi])->andFilterWhere(['like', 'author_name', $this->author_name])->andFilterWhere(['like', 'categori_name', $this->categori_name])->andFilterWhere(['like', 'sumber', $this->sumber])->andFilterWhere(['like', 'image1', $this->image1])->andFilterWhere(['like', 'image2', $this->image2])->andFilterWhere(['like', 'image3', $this->image3])->andFilterWhere(['like', 'image4', $this->image4])->andFilterWhere(['like', 'image5', $this->image5])->andFilterWhere(['like', 'image6', $this->image6])->andFilterWhere(['like', 'image7', $this->image7])->andFilterWhere(['like', 'image8', $this->image8])->andFilterWhere(['like', 'image9', $this->image9])->andFilterWhere(['like', 'video', $this->video])->andFilterWhere(['like', 'user_by', $this->user_by]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getArtikel()
{
return $this->hasOne(Artikel::className(), ['id' => 'artikel_id']);
}
