/** * Lists all Client models. * @return mixed */ public function actionIndex() { $searchModel = new ClientSearch(); $query = Client::find(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); //$groups = Group::AllGroup(); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }
public function actionIndex() { $model = new Client(); $searchModel = new ClientSearch(); $id = Yii::$app->request->get('id_group'); if ($this->user->id_user_role == Dict::USER_ROLE_BETTERDEBT) { //betterdebt $query = Client::find(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); } elseif ($this->user->id_user_role == Dict::USER_ROLE_ADVISOR) { //advisor if (isset($id)) { if ($id != '') { $query = Client::find()->andWhere(['id_group' => $id]); //->orderBy(['id_client' => SORT_DESC]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); } } else { $advisor = Advisor::findOne(['id_user' => $this->user->id_user]); $ids_group = AdvisorGroup::find()->andWhere(['id_advisor' => $advisor->id_advisor])->all(); if (empty($ids_group)) { $query = Client::find()->andWhere(['id_group' => 0]); //->orderBy(['id_client' => SORT_DESC]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); } else { $ids = []; foreach ($ids_group as $value) { $ids[] = $value['id_group']; } $query = Client::find()->andWhere(['in', 'id_group', $ids]); //->orderBy(['id_client' => SORT_DESC]); $dataProvider = $searchModel->search(Yii::$app->request->queryParams, $query); } } } // $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('index', ['model' => $model, 'searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }