public function actionUserHistory() { $user = Yii::$app->user->identity; $query = UserHistory::find()->where(['status' => UserHistory::STATUS_IN_USE, 'user_id' => $user->getId()])->orderBy('created_at DESC'); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]); return $this->render('user-history', ['dataProvider' => $dataProvider]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = UserHistory::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'game_id' => $this->game_id, 'server_id' => $this->server_id, 'created_at' => $this->created_at, 'status' => $this->status]); return $dataProvider; }
public static function getRecentUserHistory($id) { return UserHistory::find()->where(['status' => UserHistory::STATUS_IN_USE, 'user_id' => $id])->orderBy('created_at DESC')->limit(5)->all(); }