/PHP/Laravel/User order by role spatie laravel

User order by role spatie laravel

$values = Team::query()
      ->leftJoin('users', 'users.team_id', '=', 'teams.id')
      ->leftJoin('model_has_roles', function ($join) {
          $join->on('model_has_roles.model_id', '=', 'users.id')
               ->where('model_has_roles.model_type', '=', 'appModelsUser');
      })
      ->leftJoin('roles', 'roles.id', '=', 'model_has_roles.role_id')
      ->orderBy('roles.name')
      ->get();

Source: coderedirect.com

Similar codes

3 votes162 views1 answer
Laravel validation pdf
PHP Laravel
0 vote168 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote164 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
0 vote197 views6 answers
Use varable on all site pages laravel
PHP Laravel
1 vote162 views2 answers
Re migrate laravel
PHP Laravel
18 votes168 views4 answers
Use if in laravel blade
PHP Laravel
0 vote176 views2 answers
Laravel get request in blade
PHP Laravel
9 votes174 views5 answers
Laravel password hash decrypt online
PHP Laravel
3 votes169 views1 answer
Laravel send post request from controller
PHP Laravel
0 vote180 views10 answers
Laravel sanctum
PHP Laravel