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