嵌套查询结果的拉拉维尔分页

Question

我想创建查询以输出属于一个类别的所有帖子，并带有帖子分页。我确实喜欢这样，但无论如何在输出上，我有简单的照明\数据库\雄辩\没有分页器的帖子集合。怎么做？

在我的模型中，我有关系 一个类别有很多帖子。一个帖子属于一个类别。

    public function getItemWithPostsWithSimplePaginator($slug, $perPage = null)
    {
        $columns = ['id', '_lft', '_rgt', 'parent_id', 'title', 'slug', 'icon', 'description', 'image', 'metatitle', 'metakey', 'metadesc'];

        $postcolumns = ['title','slug','category_id','image','fulltext','created_at'];

        $result = $this
            ->startConditions()
            ->whereSlug($slug)
            ->select($columns)
            ->with(['posts' => function($query) use(&$postcolumns, &$perPage) {
                $query->select($postcolumns)
                      ->wherePublished(true)
                      ->orderBy('created_at', 'ASC')
                      ->simplePaginate($perPage);
                }])
            ->first();

        return $result;
    }

如果我做 dd，我可以在输出集合中看到 11 个帖子，尽管 $perPage = 10 并且属于此类别的帖子总数为 24。所以它部分有效。我唯一想念的是分页对象。

如果我用分页替换简单分页，我可以看到有 10 个帖子的集合，但无论如何没有分页器的正常集合。

App\Models\NewsCategory {#838 ▼
  +timestamps: false
  #guarded: []
  #connection: "mysql"
  #table: "news_categories"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: false
  #attributes: array:12 [▶]
  #original: array:12 [▶]
  #changes: []
  #casts: []
  #classCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: array:1 [▼
    "posts" => Illuminate\Database\Eloquent\Collection {#905 ▼
      #items: array:11 [▼
        0 => App\Models\NewsPost {#925 ▶}
        1 => App\Models\NewsPost {#926 ▶}
        2 => App\Models\NewsPost {#927 ▶}
        3 => App\Models\NewsPost {#928 ▶}
        4 => App\Models\NewsPost {#929 ▶}
        5 => App\Models\NewsPost {#930 ▶}
        6 => App\Models\NewsPost {#931 ▶}
        7 => App\Models\NewsPost {#932 ▶}
        8 => App\Models\NewsPost {#933 ▶}
        9 => App\Models\NewsPost {#934 ▶}
        10 => App\Models\NewsPost {#935 ▶}
      ]
    }
  ]
  #touches: []
  #hidden: []
  #visible: []
  #fillable: []
  #pending: null
  #moved: false
}

Answer 1

您可以尝试的解决方案之一是使用 setRelation（） 方法。

$result = $result->setRelation(
    'posts', 
    YourPostModel::select($postcolumns)
        ->wherePublished(true)
        ->orderBy('created_at', 'ASC')
        ->simplePaginate($perPage)
);