Is it possible to sort the result of the parent model by the child model?

Question

Controller

$menu       = MenuLoginPermission::with('submenu')
            ->where('id_empresa_login', '=', $idUser)
            ->get();

Model Menuloginpermission

class MenuLoginPermission extends Model
{
    public function menu(){
        return $this->belongsTo('App\Menu', 'id_menu', 'id');
    }
    public function submenu(){
        return $this->hasMany('App\Submenu', 'id_menu', 'id_menu');
    }
}

I’m not getting the Model Pai ordination through a field ORDER of Model Filho.

That’s possible ?

I tried with Wherehas and Eager Loading, but it didn’t work out.

As a last resort Leftjoin. But first I’d like to know if there’s any other way.

Model Pai = Menuloginpermission

Model Filho = Menu

Table Field Menu = Order

Answer 1

Is there a way to sort with the collection result, that is to say, Collection class, with the command Sort

Example:

Code:

$collect = collect(['d' => 2, 'a' => 1, 'z' => 0]);
return $collect->sort(function($a, $b){
    return $a == $b ? 0: ($a > $b ? 1 : -1);
})->toArray();

Exit:

{ "z": 0, "a": 1, "d": 2}

---

In your code:

  MenuLoginPermission::with('submenu')
   ->where('id_empresa_login', '=', $idUser)
   ->get();
   ->sort(function($p1,$p2)
     {
        $a = $p1->menu->order;
        $b = $p2->menu->order;
        return $a == $b ? 0: ($a > $b ? 1 : -1);
     }, SORT_REGULAR, false)
    ->toArray();

---

The most natural way would be with leftJoin

MenuLoginPermission::with('submenu')
  ->where('id_empresa_login', '=', $idUser)
  ->leftJoin('submenu', 'submenu.id_menu','=','menuloginpermission.id_menu')  
  ->orderBy('submenu.order','asc')
  ->select('menuloginpermission.*')
  ->get();

There is a way to write an anonymous item with the command with, but the result of the ordering does not influence the main item.