Laravel雄辩：如何订购相关型号的结果？

问题描述

我有一个名为学校的模型，它有很多学生。

I have a model called School and it has many Students .

这是我的代码模型：

public function students()
{
    return $this->hasMany('Student');
}

我在控制器中收到所有学生使用此代码：

I am getting all the students with this code in my controller:

$school = School::find($schoolId);

在视图中：

@foreach ($school->students as $student)

现在，我想通过学生表中的某个字段订购学生。如何做到这一点？

Now I want to order the Students by some field in the students table. How can I do that?

推荐答案

你有几种方法可以实现：

You have a few ways of achieving this:

// when eager loading
$school = School::with(['students' => function ($q) {
  $q->orderBy('whateverField', 'asc/desc');
}])->find($schoolId);

// when lazy loading
$school = School::find($schoolId);
$school->load(['students' => function ($q) {
  $q->orderBy('whateverField', 'asc/desc');
}]);

// or on the collection
$school = School::find($schoolId);
// asc
$school->students->sortBy('whateverProperty');
// desc
$school->students->sortByDesc('whateverProperty');


// or querying students directly
$students = Student::whereHas('school', function ($q) use ($schoolId) {
  $q->where('id', $schoolId);
})->orderBy('whateverField')->get();

这篇关于Laravel雄辩：如何订购相关型号的结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！