PHP app Menu::whereHas Exemples

Exemple #1

Fichier : routes.php Projet : meccado/acl-admin-control-panel

        Route::get('profiles', ['as' => 'admin.profiles', 'uses' => 'Admin\\AdminController@profile']);
        Route::resource('menus', 'Admin\\MenuController');
        //Route::resource('profiles', 'Admin\ProfileController', ['only' => ['index', 'edit', 'update']]);
    });
    Route::group(['prefix' => 'admin'], function () {
        //Route::get('profile', ['as' => 'profile.show', 'uses' => 'Admin\ProfileController@showProfile']);
        Route::patch('profile/{profile}', ['as' => 'profile.update', 'uses' => 'Admin\\ProfileController@updateProfile']);
        Route::get('profile/{profile?}', ['as' => 'profile.show', 'uses' => 'Admin\\ProfileController@show']);
        Route::patch('profile/{profile}/upload', ['as' => 'profile.avatar', 'uses' => 'Admin\\ProfileController@updateImage']);
    });
});
View::composer('acl::*', function ($view) {
    $menus = [];
    $menu_items = [];
    $user = [];
    if (Auth::check()) {
        $menus = \App\Menu::whereHas('roles', function ($q) {
            $roles = Auth::user()->roles->lists('id');
            $q->whereIn('id', $roles)->where('parent_id', 0);
        })->orderBy('sort_order', 'ASC')->distinct()->get();
        $menu_items = \App\Menu::whereHas('roles', function ($q) {
            $roles = Auth::user()->roles->lists('id');
            $q->whereIn('id', $roles);
            //->where('parent_id', 0);
        })->orderBy('sort_order', 'ASC')->distinct()->paginate();
        //dd(count($menu_items));
        $userId = \Auth::user()->id;
        $user = \App\User::with('profile')->findOrFail($userId);
    }
    $view->with(compact('menus', 'menu_items', 'user'));
});