Multiple priority sort in laravel

Question

I've read a lot about this on internet, but it seams like it is a different problem. So ... what I have is:

$students = User::with('user_profile')
             ->whereHas('roles', function($query){
                 return $query->where('slug', 'student');
             })->get()
             ->sortBy(function($user){
                 return $user->user_profile->country;
             });

Yes this would work to sort students by their country, but if they have same country, the second field I want to sort is their first name, so I tried this:

$students = User::with('user_profile')
                 ->whereHas('roles', function($query){
                     return $query->where('slug', 'student');
                 })->get()
                 ->sortBy(function($user){
                     return $user->user_profile->country;
                 })
                 ->sortBy(function($user){
                     return $user->user_profile->first_name;
                 });

Then tried to change the country, and now, it can only sort the first name and not the country (which is my priority field to sort before the first name).

BTW, I'm using Laravel 5.1

Cheers!

Duplicated: https://stackoverflow.com/questions/17006309/how-to-use-order-by-for-multiple-columns-in-laravel-4 — marco_nz, Apr 23 '18 at 06:25
@marco_nz Please read my whole question. That is not the same with this — Blues Clues, Apr 23 '18 at 06:33
What if you put `->sortBy($user->user_profile->country)->sortBy($user->user_profile->first_name)` right after `->get()` ? — Ahsan, Apr 23 '18 at 06:42

Daniel Alexandrov · Accepted Answer · 2018-04-23T07:14:33.383

-1

It is a bit counter-intuitive, but when you are chaining sortBy in Eloquent, they are applied in reverse. So your example code actually says "Sort by first name and then by country".

Other possible solution will be to concatenate both fields you want to sort on:

$students = User::with('user_profile')
             ->whereHas('roles', function($query){
                 return $query->where('slug', 'student');
             })->get()
             ->sortBy(function($user){
                 return $user->user_profile->country . "-". $user->user_profile->first_name;
             })

edited Apr 23 '18 at 07:14

answered Apr 23 '18 at 06:43

Daniel Alexandrov

1,299
8
13

Hi @Daniel . I've also tried to reverse the sort, but the priority is the first name. – Blues Clues Apr 23 '18 at 06:55
Can you provide an example? maybe? – Blues Clues Apr 23 '18 at 06:57
Strange, can you provide the resulting SQL in both cases? If you don't know how to do it, search for "Listening For Query Events" on this page - https://laravel.com/docs/5.1/database – Daniel Alexandrov Apr 23 '18 at 07:08

Multiple priority sort in laravel

1 Answers1