/** * @param \yii\db\ActiveRecord $member * @return array */ public static function get($member) { $request =& Yii::$app->request; $offset = (int) $request->getQueryParam('o', 0); $query = Snippet::find()->where(['isHidden' => 0, 'memberId' => $member->id]); $count = $query->count(); $snippets = $query->orderBy('createdTime DESC')->offset($offset)->limit(10)->all(); return ['snippets' => $snippets, 'pagination' => Util::getPagination($offset, $count, 20, 'o')]; }
/** * @param \yii\db\ActiveRecord $member * @return array */ public static function get($member) { $request =& Yii::$app->request; $offset = (int) $request->getQueryParam('o', 0); $query = Bookmark::find()->where(['memberId' => $member->id]); $count = $query->count(); $bookmarks = $query->orderBy('createdTime DESC')->offset($offset)->limit(20)->all(); return ['bookmarks' => $bookmarks, 'pagination' => Util::getPagination($offset, $count, 20, 'o')]; }
/** * @param string $searchString * @return array */ public static function get($searchString) { $request =& Yii::$app->request; $offset = (int) $request->getQueryParam('o', 0); $query = Snippet::find()->where(['isHidden' => 0]); $query->andFilterWhere(['like', 'name', $searchString]); $count = $query->count(); $snippets = $query->orderBy('createdTime DESC')->offset($offset)->limit(20)->all(); return ['snippets' => $snippets, 'pagination' => Util::getPagination($offset, $count, 20, 'o')]; }
/** * @param \yii\db\ActiveRecord $language * @return array */ public static function get($language = null) { $request =& Yii::$app->request; $offset = (int) $request->getQueryParam('o', 0); $where = ['isHidden' => 0]; if ($language) { $where['languageId'] = $language->id; } $query = Snippet::find()->where($where); $count = $query->count(); $snippets = $query->orderBy('views DESC')->offset($offset)->limit(20)->all(); return ['snippets' => $snippets, 'pagination' => Util::getPagination($offset, $count, 20, 'o')]; }