封装分页类

结合之前的 BaseObject 封装一个分页类

  1. <?php
  2. namespace common\web;
  4. use yii\base\BaseObject;
  5. use yii\data\Pagination;
  7. /**
  8.  * 分页类
  9.  *
  10.  * @author vogin
  11.  *
  12.  */
  13. class Paginator extends BaseObject
  14. {
  16.     // 分页对象
  17.     private $_page;
  19.     // 分页数据
  20.     private $_list;
  22.     // 页数
  23.     private $_pageSize;
  25.     // 默认页数
  26.     private $_defaultPageSize = 10;
  28.     public function setPage ($page)
  29.     {
  30.         $this->_page = $page;
  31.     }
  33.     public function getPage ()
  34.     {
  35.         return $this->_page;
  36.     }
  38.     public function setList ($list)
  39.     {
  40.         $this->_list = $list;
  41.     }
  43.     public function getList ()
  44.     {
  45.         return $this->_list;
  46.     }
  48.     public function setPageSize ($pageSize)
  49.     {
  50.         $this->_pageSize = $pageSize;
  51.     }
  53.     public function getPageSize ()
  54.     {
  55.         return $this->_pageSize;
  56.     }
  58.     /**
  59.      * 实例
  60.      */
  61.     public static function getInstance ()
  62.     {
  63.         return new Paginator();
  64.     }
  66.     /**
  67.      * 获取每页数量
  68.      *
  69.      * @return int
  70.      */
  71.     private function pageSize ()
  72.     {
  73.         if(is_null($this->_pageSize))
  74.         {
  75.             return $this->_defaultPageSize;
  76.         }
  77.         return $this->_pageSize;
  78.     }
  80.     /**
  81.      * 分页
  82.      */
  83.     public function pagination ($query)
  84.     {
  85.         // 总条数
  86.         $count = $query->count();
  87.         // 响应全部的datatable的参数内容
  88.         // 此内容由前端传递，为pageSize
  89.         $pageSize = Requestor::post('length', $this->pageSize());
  91.         // Yii自带分页类
  92.         $page = new Pagination([
  93.             'pageSize' => $pageSize,
  94.             'totalCount' => $count
  95.         ]);
  97.         // offset, limit
  98.         // offset 起始内容从前端传递
  99.         $offset = Requestor::post('start', - 1);
  100.         if(- 1 == $offset)
  101.         {
  102.             $offset = $page->offset;
  103.         }
  104.         $limit = $page->limit;
  105.         // 数据列表
  106.         $list = $query->offset($offset)->limit($limit)->all();
  108.         // 设置
  109.         $this->_page = $page;
  110.         $this->_list = $list;
  112.         return $this;
  113.     }
  114. }

逻辑方法

  1. <?php
  2. class Banner extends ActiveRecord {
  3.   public static function pager(){
  4.     // 查询数据
  5.     $query = new Query();
  6.     $query->from(Banner::tableName());
  8.     // 进行分页
  9.     $paginator = Paginator::getInstance();
  10.     $paginator->pagination($query);
  11.     return $paginator;
  12.   }
  13. }

使用

  1. <?php
  2. class BannerController extends Controller {
  3.     public function actionList() {
  4.       $paginator = Banner::pager();
  5.     return Result::success([
  6.       "count" => $paginator->page->totalCount,
  7.       "data" => $paginator->list
  8.     ]);
  9.   }
  10. }