<?php

namespace backend\models;

use yii\base\Model;
use yii\data\ActiveDataProvider;
use backend\models\AllUser;


/**
 * AllUserSearch represents the model behind the search form of `\backend\models\AllUser`.
 */
class AllUserSearch extends AllUser
{
    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['id', 'status', 'created_at', 'updated_at', 'parent_id'], 'integer'],
            [['username', 'auth_key', 'password_hash', 'password_reset_token', 'email', 'phone', 'name', 'phone_dispech', 'inn', 'ogrn', 'bank', 'bik', 'schet', 'korschet', 'adress_fakt', 'adress_yr', 'boss', 'kv'], 'safe'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function scenarios()
    {
        // bypass scenarios() implementation in the parent class
        return Model::scenarios();
    }

    /**
     * Creates data provider instance with search query applied
     *
     * @param array $params
     *
     * @return ActiveDataProvider
     */
    public function search($params)
    {
        $query = AllUser::find();

        // add conditions that should always apply here

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
             'query' => $query,
            'pagination' => [
                 'forcePageParam' => false,
                 'pageSizeParam' => false,
                'pageSize' => 10
            ]
        ]);

        $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;
        }

        // grid filtering conditions
        $query->andFilterWhere([
            'id' => $this->id,
            'status' => $this->status,
            'created_at' => $this->created_at,
            'updated_at' => $this->updated_at,
            'parent_id' => $this->parent_id,
        ]);

        $query->andFilterWhere(['like', 'username', $this->username])
            ->andFilterWhere(['like', 'auth_key', $this->auth_key])
            ->andFilterWhere(['like', 'password_hash', $this->password_hash])
            ->andFilterWhere(['like', 'password_reset_token', $this->password_reset_token])
            ->andFilterWhere(['like', 'email', $this->email])
            ->andFilterWhere(['like', 'phone', $this->phone])
            ->andFilterWhere(['like', 'name', $this->name])
            ->andFilterWhere(['like', 'phone_dispech', $this->phone_dispech])
            ->andFilterWhere(['like', 'inn', $this->inn])
            ->andFilterWhere(['like', 'ogrn', $this->ogrn])
            ->andFilterWhere(['like', 'bank', $this->bank])
            ->andFilterWhere(['like', 'bik', $this->bik])
            ->andFilterWhere(['like', 'schet', $this->schet])
            ->andFilterWhere(['like', 'korschet', $this->korschet])
            ->andFilterWhere(['like', 'adress_fakt', $this->adress_fakt])
            ->andFilterWhere(['like', 'adress_yr', $this->adress_yr])
            ->andFilterWhere(['like', 'boss', $this->boss])
            ->andFilterWhere(['like', 'kv', $this->kv]);

    return $dataProvider;
}
$query = AllUser::find()
    ->select('user.*')
    ->leftJoin('auth_assignment', '`auth_assignment`.`user_id` = `user`.`id`')
    ->andWhere(['auth_assignment.item_name'=>'admin']);
    return $query;
}