/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { // Если админ, то выбираем все опросы. if ($isAdmin = Users::findOne(['profile_id' => Yii::$app->user->identity->username, 'profile_office_role' => 'admin'])) { $officeIds = ArrayHelper::map(Office::find()->all(), 'id', 'id'); } elseif ($isCommercialDirector = Users::findAll(['profile_id' => Yii::$app->user->identity->username, 'profile_office_role' => 'commercial_director'])) { // берем ID отделений, где регион отделения === региону, где пользователь коммерч.директор $regionIds = ArrayHelper::map($isCommercialDirector, 'region_id', 'region_id'); $officeIds = ArrayHelper::map(Office::findAll(['region_id' => $regionIds]), 'id', 'id'); } else { // берем ID отделений, где пользователь является управляющим, или где он назначен им. $officeIds = $this->getOffiсeIds(Yii::$app->user->identity->username); } $query = AnswerList::find()->joinWith('questionList')->where(['do_id' => $officeIds]); //$query = AnswerList::find()->innerJoinWith('questionList'); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $sort = $dataProvider->getSort(); $sort->attributes['officeName'] = ['asc' => ['questionlist_office.name' => SORT_ASC], 'desc' => ['questionlist_office.name' => SORT_DESC], 'label' => 'Отделение']; $sort->attributes['statusName'] = ['asc' => ['status' => SORT_ASC], 'desc' => ['status' => SORT_DESC], 'label' => 'Статус']; $dataProvider->setSort($sort); $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'); $query->joinWith(['questionlist_office']); return $dataProvider; } $query->andFilterWhere(['questionlist_answer_list.id' => $this->id, 'question_list_id' => $this->question_list_id, 'scores' => $this->scores]); $query->andFilterWhere(['>=', 'date_from', $this->date_from])->andFilterWhere(['<=', 'date_to', $this->date_to]); if ($this->statusName) { $query->andFilterWhere(['like', 'status', $this->statusName]); } else { $query->andFilterWhere(['not like', 'status', 'archive']); } $query->joinWith(['office' => function ($q) { $q->andFilterWhere(['like', 'questionlist_office.name', $this->officeName]); }]); return $dataProvider; }