/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params, $mode = false) { if ($this->getScenario() === 'forSalon') { $query = UsersData::find()->forSalon(); } elseif ($this->getScenario() === 'inBlack' or $this->getScenario() === 'inBlack-moderate') { $query = UsersData::find()->inBlack(); } elseif ($this->getScenario() === 'inBlack-notmoderate') { $query = UsersData::find()->inBlackNotModerated(); } else { $query = UsersData::find(); } if ($this->getScenario() === 'inBlack-notmoderate') { } $dataProviderParam = ['query' => $query]; if ($this->getScenario() === 'inBlack') { $dataProviderParam['sort'] = false; } $dataProvider = new ActiveDataProvider($dataProviderParam); $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'); if ($this->getScenario() === 'inBlack' or $this->getScenario() === 'inBlack-notmoderate') { $query->where('0=1'); } return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'account_id' => $this->account_id, 'salon_account_id' => $this->salon_account_id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'document_num' => $this->document_num, 'is_black' => $this->is_black, 'city_id' => $this->city_id]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'full_name', $this->full_name])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'is_organization', $this->is_organization])->andFilterWhere(['like', 'passport_number', $this->passport_number])->andFilterWhere(['like', 'passport_serion', $this->passport_serion])->andFilterWhere(['like', 'birth_date', $this->birth_date])->andFilterWhere(['like', 'address_reg', $this->address_reg])->andFilterWhere(['like', 'address_fact', $this->address_fact])->andFilterWhere(['like', 'license_number', $this->license_number])->andFilterWhere(['like', 'license_date', $this->license_date])->andFilterWhere(['like', 'image_passport_photo', $this->image_passport_photo])->andFilterWhere(['like', 'image_passport_reg', $this->image_passport_reg])->andFilterWhere(['like', 'image_drive_licence', $this->image_drive_licence])->andFilterWhere(['like', 'inn', $this->inn])->andFilterWhere(['like', 'kpp', $this->kpp])->andFilterWhere(['like', 'ogrn', $this->ogrn])->andFilterWhere(['like', 'okpo', $this->okpo])->andFilterWhere(['like', 'r_sch', $this->r_sch])->andFilterWhere(['like', 'bank', $this->bank])->andFilterWhere(['like', 'k_sch', $this->k_sch])->andFilterWhere(['like', 'bik', $this->bik])->andFilterWhere(['like', 'director', $this->director])->andFilterWhere(['like', 'is_confirmed', $this->is_confirmed])->andFilterWhere(['like', 'images', $this->images])->andFilterWhere(['like', 'passport_give', $this->passport_give]); return $dataProvider; }
public static function getCountInBlack() { return UsersData::find()->inBlack()->count(); }