/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = UserInfo::find()->from(UserInfo::tableName() . ' t')->joinWith(['userinfo' => function ($q) {
$q->from(UserInfo::tableName() . ' parent');
}]);
if (Yii::$app->user->can('manager')) {
$query->where(array('t.manager' => Yii::$app->user->id));
}
if (Yii::$app->user->can('hrm')) {
$query->leftJoin('auth_assignment', 't.user_id = auth_assignment.user_id');
$query->where('auth_assignment.item_name <> "admin" ');
}
$dataProvider = new ActiveDataProvider(['query' => $query]);
$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(['user_id' => $this->user_id, 'manager' => $this->manager]);
$query->andFilterWhere(['like', 't.first_name', $this->first_name])->andFilterWhere(['like', 't.last_name', $this->last_name])->andFilterWhere(['like', 't.full_name', $this->full_name])->andFilterWhere(['like', 't.phone', $this->phone])->andFilterWhere(['like', 't.email', $this->email])->andFilterWhere(['like', 't.position', $this->position]);
return $dataProvider;
}
