按 created_at 排序 Eloquent 集合

2022-01-08 00:00:00 collections php laravel laravel-4 eloquent

我有一个名为posts"的表，其中包含以下列:post_id int primary increments"、poster_id int"和status text"，还有一个名为friends"的数组，其列:user_id int primary"和friend_ids"文本'.

I have a table named 'posts' with the columns: 'post_id int primary increments', 'poster_id int' and 'status text' as well as an array named friends with the columns: 'user_id int primary' and 'friend_ids text'.

我需要获取朋友文本列中的所有 ID，这很容易使用:

I need to grab all the IDs in the friends text column which is easy enough using:

$friends = explode(',', Friend::where('user_id', Sentry::getUser()->id)->first()->friend_ids);

文本列中的数据看起来像1、2、3"等.

Where the data in the text column would look like '1,2,3,' etc.

然后我创建一个 Eloquent Collection 对象，这也很容易通过以下方式完成:

Then I create an Eloquent Collection object which is also easily done via:

$posts = new IlluminateDatabaseEloquentCollection();

但问题是我不知道如何填充集合并按 Post 对象的created_at"列对其内容进行排序.

But the problem is I can't figure out how to populate the collection and sort its contents by the Post object's 'created_at' column.

这是我目前所拥有的:

foreach ($friends as $id) {
    $posts_ = Post::where('poster_id', $id)->getQuery()
        ->orderBy('created_at', 'desc')
        ->get();
    foreach($posts_ as $post) {
        $posts->add($post);
    }
}

我不知道这段代码是否适用于按created_at"列对整个帖子集合进行排序.我还需要能够轻松地对整个集合进行分页.

I can't figure out if this code would work or not for sorting the entire collection of posts by the 'created_at' column. I would also need to be able to paginate the entire collection easily.

推荐的收藏排序方式是什么?

What is the recommended way of sorting the collection?

推荐答案

如果要对 collection 进行排序，可以使用 sortBy 方法按给定键

If you want to sort a collection you can use the sortBy method by given key

$sorted = $posts->sortBy('created_at');

您还可以在 collection

$sorted = $posts->sortBy(function($post)
{
  return $post->created_at;
});

希望这会有所帮助.有关 collections 的更多信息，您可以阅读 docs

Hope this helps. For more information on collections you can read the docs

相关文章