コード例 #1
0
 /**
  * @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')];
 }
コード例 #2
0
ファイル: BookmarkList.php プロジェクト: jc21/snippets-site
 /**
  * @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')];
 }
コード例 #3
0
ファイル: SearchSnippets.php プロジェクト: jc21/snippets-site
 /**
  * @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')];
 }
コード例 #4
0
 /**
  * @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')];
 }