当前位置 主页 > 网站技术 > 代码类 >

    thinkphp5框架前后端分离项目实现分页功能的方法分析

    栏目:代码类 时间:2019-10-14 09:03

    本文实例讲述了thinkphp5框架前后端分离项目实现分页功能的方法。分享给大家供大家参考,具体如下:

    方法一

    利用tp5提供的paginate方法实现自动分页

    参数

    page第几页,paginate分页方法会自动获取

    size  每页数量

    代码

    /**
    * Notes:消费记录
    * Date: 2019/6/25
    * Time: 15:43
    * @param Request $request
    * @return \think\response\Json
    */
    public function getMyConsumeLog(Request $request)
    {
        global $_W;
        $size = $request->param('size', 6);
        $list = $this->model->getListByMid($_W['user']['id'],$size);
        return json(['data' => $list, 'error' => 0, 'message' => 'success']);
    }
    public function getListByMid($mid,$size = 10){
        $res = $this
          ->alias('c')
          ->field('c.*,b.book_name,b.book_flash,s.section_title')
          ->leftJoin('booksection s','c.chapter_id = s.id')
          ->leftJoin('book b','s.book_id = b.id')
          ->where('c.mid',$mid)
          ->order('c.id desc')
          ->paginate($size);
        return $res;
    }
    
    

    返回数据

    {
        "data": {
            "total": 1,
            "per_page": 1,
            "current_page": 1,
            "last_page": 1,
            "data": [
                {
                    "id": 105,
                    "mid": 55,
                    "book_id": 31,
                    "chapter_id": 46046,
                    "score": 27,
                    "create_time": 1561447448,
                    "book_name": "桃运村支书",
                    "book_flash": "https://cdnxiaoshuo.t.com/FiO6TM0N4kpzKB7tqrDko64ZS4H4",
                    "section_title": "第29章 康庄大道"
                }
            ]
        },
        "error": 0,
        "message": "success"
    }

    方法二

    利用limit方法

    $curr_page = $request->param('page', 1);
        $size = $request->param('size', 6);
    $list = $consume_model->getListByWhere($curr_page, $size, $where);
        $num = $consume_model->getListByWhereCount($where);
        return json(['data' => $list,'num' => $num,'error' => 0, 'message' => 'success']);
    public function getListByWhere($curr_page,$limit = 10,$where = null){
        $res = $this
          ->alias('c')
          ->field('c.*,b.book_name,s.section_title')
          ->leftJoin('booksection s','c.chapter_id = s.id')
          ->leftJoin('book b','s.book_id = b.id')
          ->where($where)
          ->order('c.id desc')
          ->limit($limit*($curr_page - 1),$limit)
          ->select()
          ->toArray();
        return $res;
    }
    public function getListByWhereCount($where = null){
        $count = $this
          ->alias('c')
          ->where($where)
          ->count();
        return $count;
    }