Laravel orderBy 上的关系 [英] Laravel orderBy on a relationship

问题描述

我正在遍历特定帖子的作者发表的所有评论.

I am looping over all comments posted by the Author of a particular post.

foreach($post->user->comments as $comment)
{
    echo "<li>" . $comment->title . " (" . $comment->post->id . ")</li>";
}

这给了我

I love this post (3)
This is a comment (5)
This is the second Comment (3)

我将如何通过 post_id 进行排序，以便将上述列表排序为 3,3,5

How would I order by the post_id so that the above list is ordered as 3,3,5

推荐答案

可以用查询函数扩展关系:

It is possible to extend the relation with query functions:

<?php
public function comments()
{
    return $this->hasMany('Comment')->orderBy('column');
}

[评论后编辑]

<?php
class User
{
    public function comments()
    {
        return $this->hasMany('Comment');
    }
}

class Controller
{
    public function index()
    {
        $column = Input::get('orderBy', 'defaultColumn');
        $comments = User::find(1)->comments()->orderBy($column)->get();

        // use $comments in the template
    }
}

默认用户模型+简单控制器示例；获取评论列表时，只需应用基于 Input::get() 的 orderBy().(一定要进行一些输入检查；))

default User model + simple Controller example; when getting the list of comments, just apply the orderBy() based on Input::get(). (be sure to do some input-checking ;) )

这篇关于Laravel orderBy 上的关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！