本文介紹了Laravel Eloquent:如何對(duì)相關(guān)模型的結(jié)果進(jìn)行排序?的處理方法，對(duì)大家解決問題具有一定的參考價(jià)值，需要的朋友們下面隨著小編來一起學(xué)習(xí)吧！
問題描述
我有一個(gè)名為學(xué)校的模型，它有很多學(xué)生.
I have a model called School and it has many Students .
這是我的模型中的代碼:
Here is the code in my model:
public function students()
{
return $this->hasMany('Student');
}
我讓所有學(xué)生都在我的控制器中使用此代碼:
I am getting all the students with this code in my controller:
$school = School::find($schoolId);
并在視圖中:
@foreach ($school->students as $student)
現(xiàn)在我想按 students 表中的某個(gè)字段對(duì) Students 進(jìn)行排序.我該怎么做?
Now I want to order the Students by some field in the students table. How can I do that?
推薦答案
您有幾種方法可以實(shí)現(xiàn):
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();
這篇關(guān)于Laravel Eloquent:如何對(duì)相關(guān)模型的結(jié)果進(jìn)行排序?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！
【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題，如果有圖片或者內(nèi)容侵犯了您的權(quán)益，請(qǐng)聯(lián)系我們刪除處理，感謝您的支持！