@php use App\Models\menus; // $menu_single=menus::whereNull('dropdown')->get(); $rol = auth()->user()->role; $menu_single = DB::table('menuses') ->join('permissions', 'menuses.id', '=', 'permissions.menus') ->whereNull('menuses.deleted_at') ->where('permissions.role', $rol) ->where('permissions.view', 1) ->whereNull('menuses.dropdown') ->select('menuses.*') ->get(); $menu_headers = DB::table('menuses') ->join('permissions', 'menuses.id', '=', 'permissions.menus') ->whereNull('menuses.deleted_at') ->where('permissions.role', $rol) ->where('permissions.view', 1) ->whereNotNull('menuses.dropdown') ->select('menuses.*') ->get() ->groupBy('menu_header_id'); // dd($menu_headers); // dd($rol); @endphp