/**
* Creates data provider instance with search query applied.
*
* @param array $params Search params
*
* @return ActiveDataProvider DataProvider
*/
public function search($params)
{
$query = self::find()->joinWith(['profile']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->sort->attributes['name'] = ['asc' => [Profile::tableName() . '.name' => SORT_ASC], 'desc' => [Profile::tableName() . '.name' => SORT_DESC]];
$dataProvider->sort->attributes['surname'] = ['asc' => [Profile::tableName() . '.surname' => SORT_ASC], 'desc' => [Profile::tableName() . '.surname' => SORT_DESC]];
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'status_id' => $this->status_id, 'role' => $this->role, 'FROM_UNIXTIME(created_at, "%d.%m.%Y")' => $this->created_at, 'FROM_UNIXTIME(updated_at, "%d.%m.%Y")' => $this->updated_at]);
$query->andFilterWhere(['like', Profile::tableName() . '.name', $this->name]);
$query->andFilterWhere(['like', Profile::tableName() . '.surname', $this->surname]);
$query->andFilterWhere(['like', 'username', $this->username]);
$query->andFilterWhere(['like', 'email', $this->email]);
return $dataProvider;
}
