laravel 分页器查询 封装

laravel 分页器查询 封装

 /**
     * 分页查找数据||全部查找数据（$page_size < 0）
     * @param $where 要查询的条件
     * @param array $select 查询的字段
     * @param array $with 关联表
     * @param array $whereHas 关联的whereHas
     * @param array $whereIn 关联的whereIn
     * @param array $whereHasIn 关联的whereHasIn
     * @param array $sort 排序字段
     * @param null $page_size 页数显示条数 （-1为全部显示）
     * @return \Illuminate\Contracts\Pagination\Paginator|\Illuminate\Database\Eloquent\Collection|static[]
     */
    public function pageList($where,$select=['*'],$with=[],$whereHas=[],$sort=[], $page_size=null,$whereIn=[],$whereHasIn=[],$orwhere=[]){
        foreach ($with as $k=>$v){
            $this->model = $this->model->with($v);
        }
        foreach($whereHas as $key=>$val){
            $this->model = $this->model->whereHas($key,function($query)use($val){$query->where($val);});
        }
        foreach($whereHasIn as $key=>$val){
            $this->model = $this->model->whereHas($key,function($query)use($val){
                foreach ($val as $v){
                    $query->whereIn($v[0],$v[1]);
                }
            });
        }
        foreach($whereIn as $val){
            $this->model = $this->model->whereIn($val[0],$val[1]);
        }
        if (!empty($sort) && isset($sort[0]) && isset($sort[1])) $this->model=$this->model->orderBy($sort[0],$sort[1]);

        $this->model = $this->model->where($where);

        foreach ($orwhere as $value){

            $this->model = $this->model->where($value);
        }

        if ($page_size < 0) return $this->model->get($select);

        return $this->model->select($select)->paginate($page_size??Common::PAGE_SIZE);
    }