/**
  * Lists all Users models.
  * @return mixed
  */
 public function actionIndex()
 {
     $AllUsers = Users::find();
     if ($AllUsers) {
         $pagination = new Pagination(['defaultPageSize' => 2, 'totalCount' => $AllUsers->count()]);
         $users = $AllUsers->offset($pagination->offset)->limit($pagination->limit)->all();
         return $this->render('index', ['users' => $users, 'pagination' => $pagination]);
     }
 }
Example #2
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Users::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $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;
     }
     $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id]);
     $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'password', $this->password]);
     return $dataProvider;
 }