问题描述
我选择了两个表格:团队和成员.这些模型通过n:m关系连接,在我的团队视图中,我将进行一个foreach循环,以使该团队的成员像这样:
I have two tables conected: Team and member. The models are connected by a n:m relationship and in my team views I will make a foreach loop to get the members of said team like this:
@foreach( $team->teammember as $member )
{{ $member->firstname }} {{ $member->lastname }}
@endforeach
到目前为止,一切都很好并且可以正常工作,我的问题是,如何获取按姓氏排序的成员列表?在我的控制器中,我没有得到成员,因为连接是通过模型完成的,所以我只能对团队进行排序,而不能对成员进行排序.
So far everything is great and working, my issue is, how do I get the members list sorted by lastname? In my controller I'm not getting the members, since the connection is done via the model, I can only sort the teams but not the members.
推荐答案
基本上,您可以这样做:
Essentially, you can do this:
@foreach( $team->teammember()->orderBy('last_name')->get() as $member )
{{ $member->firstname }} {{ $member->lastname }}
@endforeach
但是,最好将其抽象到模型中,或者如果您打算大量使用它的话.
However, might be best to abstract this into the Model or something if you plan on doing it alot.
这篇关于如何对雄辩的子查询进行排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!