/**
  * 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]);
 }