Hello, I want to generate the menu items from a database table.

Dynamic Generation from database about menus HOT 2 CLOSED

caffeinated commented on August 22, 2024

Dynamic Generation from database

from menus.

Comments (2)

kaidesu commented on August 22, 2024

I would take a step back and simplify the code, slowly making additions to it to find out what the issue is.

First step is to simply load your items from the database and add them to a menu - don't worry about the options for now. Once you've got that working, then move on to implementing the menu options.

There's a few ways you can go about things. Maybe try and simply create your menu instance (with no items), and then add your items to it:

$menu = Menu::make('backend', function($menu) {
    $menu->add('Dashboard', 'admin');
});

$items = NavigationAdmin::all();

foreach ($items as $item) {
    $menu->add($item->title, '#');
}

Or this should even work:

$items = NavigationAdmin::all();

Menu::make('backend', function($menu) use ($items) {
    foreach ($items as $item) {
        $menu->add($item->title, '#');
    }
});

from menus.

twitnic commented on August 22, 2024

Hey,

that works, but when I gerate Submenus it say: Call to a member function add() on a non-object

My File:
<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Support\Facades\DB;
use Menu;

    class MenuMiddleware
    {
    /**
     * Run the request filter.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure                  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
        $stops = DB::table('pictures')
            ->leftJoin('gallery', 'pictures.gallery_id', '=', 'gallery.id')
            ->select(DB::raw('pictures.gallery_id, gallery.name, COUNT(DISTINCT pictures.slide) as AnzahlSlides'))
            ->groupBy('pictures.gallery_id')
        ->get();

    Menu::make('backend', function($menu) use ($stops) {

        foreach ($stops as $stop) {

            $menu
                ->add($stop->name, ['route' => ['getGalleryVenue', $stop->gallery_id]])
                ->active('admin/backend/gallery/' . $stop->gallery_id)
                ->icon('fa-picture-o');

            $lowerName = strtolower($stop->name);

            for($i = 1; $i <= $stop->AnzahlSlides; $i++) {
                $menu->$lowerName->add($i, ['route' => ['getGallerySlide', $stop->gallery_id, $i]]);
                }
            }
        });

        return $next($request);
    }
}

Could anyone maybe help?
Thanks

from menus.

Related Issues (20)

Recommend Projects