2.0.3 Study addTitle (ok)

C:\xampp82\htdocs\testvn\app\Http\Middleware\GetMenu.php

<?php
namespace App\Http\Middleware;
use App\Http\Menus\GetSidebarMenu;
use App\Models\Menulist;
use Closure;
use Illuminate\Http\Request;
class GetMenu
{
  /**
   * Handle an incoming request.
   *
   * @param  \Illuminate\Http\Request  $request
   * @param  \Closure(\Illuminate\Http\Request): (\Illuminate\Http\Response|\Illuminate\Http\RedirectResponse)  $next
   * @return \Illuminate\Http\Response|\Illuminate\Http\RedirectResponse
   */
  public function handle(Request $request, Closure $next)
  {
    $role = 'admin';
    $menulists = Menulist::all();
    $menus = new GetSidebarMenu();
    $result = [];
    foreach ($menulists as $menulist) {
      $result[$menulist->name] = $menus->get($role,$menulist->id);
    }
    view()->share('appMenus',$result);
    return $next($request);
  }
}

C:\xampp82\htdocs\testvn\resources\views\dashboard\shared\nav-builder.blade.php

<ul class="sidebar-nav aaa2">
    {{ dd($appMenus) }}
    @if (isset($appMenus['sidebar menu']))
    @endif
</ul>

C:\xampp82\htdocs\testvn\app\Http\Menus\GetSidebarMenu.php

<?php
namespace App\Http\Menus;
use App\MenuBuilder\MenuBuilder;
use App\MenuBuilder\RenderFromDatabaseData;
use App\Models\Menus;
class GetSidebarMenu implements MenuInterface
{
  private $menu;
  private function getMenuFromDB($role, $menuId)
  {
    $this->menu = Menus::join('menu_role', 'menus.id', '=', 'menu_role.menus_id')
      ->select('menus.*')
      ->where('menus.menu_id', '=', $menuId)
      ->where('menu_role.role_name', '=', $role)
      ->orderBy('menus.sequence', 'asc')->get();
  }
  public function get($role, $menuId = 2)
  {
    $this->getMenuFromDB($role, $menuId);
    $rfd = new RenderFromDatabaseData();
    return $rfd->render($this->menu);
  }
}

C:\xampp82\htdocs\testvn\app\Http\Menus\MenuInterface.php

<?php
namespace App\Http\Menus;
interface MenuInterface {
  public function get(string $role);
}

C:\xampp82\htdocs\testvn\database\seeders\MenusTableSeeder.php

<?php
namespace Database\Seeders;
use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
class MenusTableSeeder extends Seeder
{
  private $joinData = [];
  private $dropdown = false;
  private $menuId = null;
  private $dropdownId = [];
  private $sequence = 1;
  public function join($roles, $menuId)
  {
    $roles = explode(',', $roles);
    foreach ($roles as $role) {
      array_push($this->joinData, ['role_name' => $role, 'menus_id' => $menuId]);
    }
  }
  public function joinAllData()
  {
    foreach ($this->joinData as $data) {
      DB::table('menu_role')->insert($data);
    }
  }
  public function insertLink($roles, $name, $slug, $icon = null)
  {
    if ($this->dropdown == false) {
      DB::table('menus')->insert([
        'name' => $name,
        'icon' => $icon,
        'slug' => $slug,
        'target' => 'link',
        'menu_id' => $this->menuId,
        'parent_id' => null,
        'sequence' => $this->sequence
      ]);
    } else {
      DB::table('menus')->insert([
        'name' => $name,
        'icon' => $icon,
        'slug' => $slug,
        'target' => 'link',
        'menu_id' => $this->menuId,
        'parent_id' => $this->dropdownId[count($this->dropdownId) - 1],
        'sequence' => $this->sequence
      ]);
    }
    $this->sequence++;
    $lastId = DB::getPdo()->lastInsertId();
    $this->join($roles, $lastId);
    return $lastId;
  }
  public function insertTitle($roles, $name)
  {
    DB::table('menus')->insert([
      'name' => $name,
      'icon' => null,
      'slug' => null,
      'target' => 'text',
      'menu_id' => $this->menuId,
      'parent_id' => null,
      'sequence' => $this->sequence
    ]);
    $this->sequence++;
    $lastId = DB::getPdo()->lastInsertId();
    $this->join($roles, $lastId);
    return $lastId;
  }
  public function beginDropdown($roles, $name, $icon = null)
  {
    if (count($this->dropdownId)) {
      $parentId = $this->dropdownId[count($this->dropdownId) - 1];
    } else {
      $parentId = null;
    }
    DB::table('menus')->insert([
      'name' => $name,
      'icon' => $icon,
      'slug' => null,
      'target' => 'dropdown',
      'menu_id' => $this->menuId,
      'parent_id' => $parentId,
      'sequence' => $this->sequence
    ]);
    $this->sequence++;
    $lastId = DB::getPdo()->lastInsertId();
    array_push($this->dropdownId, $lastId);
    $this->dropdown = true;
    $this->join($roles, $lastId);
    return $lastId;
  }
  public function endDropdown()
  {
    $this->dropdown = false;
    array_pop($this->dropdownId);
  }
  /**
   * Run the database seeds.
   */
  public function run(): void
  {
    DB::table('menulist')->insert([
      'name' => 'sidebar menu'
    ]);
    $this->menuId = DB::getPdo()->lastInsertId();  //set menuId
    $this->insertLink('guest,user,admin', 'Dashboard', '/', 'cil-speedometer');
    $this->beginDropdown('admin', 'Settings', 'cil-calculator');
    $this->insertLink('admin', 'Notes',                   '/notes');
    $this->insertLink('admin', 'Users',                   '/users');
    $this->insertLink('admin', 'Edit menu',               '/menu/menu');
    $this->insertLink('admin', 'Edit menu elements',      '/menu/element');
    $this->insertLink('admin', 'Edit roles',              '/roles');
    $this->insertLink('admin', 'Media',                   '/media');
    $this->insertLink('admin', 'BREAD',                   '/bread');
    $this->insertLink('admin', 'Email',                   '/mail');
    $this->endDropdown();
    $this->insertLink('guest', 'Login', '/login', 'cil-account-logout');
    $this->insertLink('guest', 'Register', '/register', 'cil-account-logout');
    $this->insertTitle('user,admin', 'Theme');
    $this->insertLink('user,admin', 'Colors', '/colors', 'cil-drop1');
    $this->insertLink('user,admin', 'Typography', '/typography', 'cil-pencil');
    $this->beginDropdown('user,admin', 'Base', 'cil-puzzle');
    $this->insertLink('user,admin', 'Breadcrumb',    '/base/breadcrumb');
    $this->insertLink('user,admin', 'Cards',         '/base/cards');
    $this->insertLink('user,admin', 'Carousel',      '/base/carousel');
    $this->insertLink('user,admin', 'Collapse',      '/base/collapse');
    $this->insertLink('user,admin', 'Forms',         '/base/forms');
    $this->insertLink('user,admin', 'Jumbotron',     '/base/jumbotron');
    $this->insertLink('user,admin', 'List group',    '/base/list-group');
    $this->insertLink('user,admin', 'Navs',          '/base/navs');
    $this->insertLink('user,admin', 'Pagination',    '/base/pagination');
    $this->insertLink('user,admin', 'Popovers',      '/base/popovers');
    $this->insertLink('user,admin', 'Progress',      '/base/progress');
    $this->insertLink('user,admin', 'Scrollspy',     '/base/scrollspy');
    $this->insertLink('user,admin', 'Switches',      '/base/switches');
    $this->insertLink('user,admin', 'Tables',        '/base/tables');
    $this->insertLink('user,admin', 'Tabs',          '/base/tabs');
    $this->insertLink('user,admin', 'Tooltips',      '/base/tooltips');
    $this->endDropdown();
    $this->beginDropdown('user,admin', 'Buttons', 'cil-cursor');
    $this->insertLink('user,admin', 'Buttons',           '/buttons/buttons');
    $this->insertLink('user,admin', 'Buttons Group',     '/buttons/button-group');
    $this->insertLink('user,admin', 'Dropdowns',         '/buttons/dropdowns');
    $this->insertLink('user,admin', 'Brand Buttons',     '/buttons/brand-buttons');
    $this->endDropdown();
    $this->insertLink('user,admin', 'Charts', '/charts', 'cil-chart-pie');
    $this->beginDropdown('user,admin', 'Icons', 'cil-star');
    $this->insertLink('user,admin', 'CoreUI Icons',      '/icon/coreui-icons');
    $this->insertLink('user,admin', 'Flags',             '/icon/flags');
    $this->insertLink('user,admin', 'Brands',            '/icon/brands');
    $this->endDropdown();
    $this->beginDropdown('user,admin', 'Notifications', 'cil-bell');
    $this->insertLink('user,admin', 'Alerts',     '/notifications/alerts');
    $this->insertLink('user,admin', 'Badge',      '/notifications/badge');
    $this->insertLink('user,admin', 'Modals',     '/notifications/modals');
    $this->endDropdown();
    $this->insertLink('user,admin', 'Widgets', '/widgets', 'cil-calculator');
    $this->insertTitle('user,admin', 'Extras');
    $this->beginDropdown('user,admin', 'Pages', 'cil-star');
    $this->insertLink('user,admin', 'Login',         '/login');
    $this->insertLink('user,admin', 'Register',      '/register');
    $this->insertLink('user,admin', 'Error 404',     '/404');
    $this->insertLink('user,admin', 'Error 500',     '/500');
    $this->endDropdown();
    $this->insertLink('guest,user,admin', 'Download CoreUI', 'https://coreui.io', 'cil-cloud-download');
    $this->insertLink('guest,user,admin', 'Try CoreUI PRO', 'https://coreui.io/pro/', 'cil-layers');
    /* Create top menu */
    DB::table('menulist')->insert([
      'name' => 'top menu'
    ]);
    $this->menuId = DB::getPdo()->lastInsertId();  //set menuId
    $this->beginDropdown('guest,user,admin', 'Pages');
    $id = $this->insertLink('guest,user,admin', 'Dashboard',    '/');
    $id = $this->insertLink('user,admin', 'Notes',              '/notes');
    $id = $this->insertLink('admin', 'Users',                   '/users');
    $this->endDropdown();
    $id = $this->beginDropdown('admin', 'Settings');
    $id = $this->insertLink('admin', 'Edit menu',               '/menu/menu');
    $id = $this->insertLink('admin', 'Edit menu elements',      '/menu/element');
    $id = $this->insertLink('admin', 'Edit roles',              '/roles');
    $id = $this->insertLink('admin', 'Media',                   '/media');
    $id = $this->insertLink('admin', 'BREAD',                   '/bread');
    $this->endDropdown();
    $this->joinAllData();
  }
}

C:\xampp82\htdocs\testvn\app\MenuBuilder\MenuBuilder.php

<?php
namespace App\MenuBuilder;
class MenuBuilder
{
  private $menu = [];
  private function addRegularLink($id, $name, $slug, $icon, $iconType, $sequence = 0)
  {
    $hasIcon = ($icon === false || strlen($icon) === 0) ? false : true;
    if ($hasIcon) {
      array_push($this->menu, [
        'id' => $id,
        'target' => 'link',
        'name' => $name,
        'slug' => $slug,
        'hasIcon' => $hasIcon,
        'iconType' => $iconType,
        'sequence' => $sequence
      ]);
    } else {
      array_push($this->menu, [
        'id' => $id,
        'target' => 'link',
        'name' => $name,
        'slug' => $slug,
        'iconType' => $iconType,
        'sequence' => $sequence
      ]);
    }
  }
  public function addLink($id, $name, $slug, $icon = false, $iconType = 'coreui', $sequence = 0)
  {
    $this->addRegularLink($id, $name, $slug, $icon, $iconType, $sequence);
  }
  public function addTitle($id, $name, $icon = false, $iconType = 'coreui', $sequence = 0)
  {
    $hasIcon = ($icon === false || strlen($icon) === 0) ? false : true;
    if ($hasIcon) {
      array_push($this->menu, [
        'id' => $id,
        'target' => 'title',
        'name' => $name,
        'hasIcon' => $hasIcon,
        'iconType' => $iconType,
        'sequence' => $sequence
      ]);
    } else {
      array_push($this->menu, [
        'id' => $id,
        'target' => 'title',
        'name' => $name,
        'iconType' => $iconType,
        'sequence' => $sequence
      ]);
    }
  }
  public function getResult()
  {
    return $this->menu;
  }
}

C:\xampp82\htdocs\testvn\app\MenuBuilder\RenderFromDatabaseData.php

<?php
namespace App\MenuBuilder;
class RenderFromDatabaseData
{
  private $mb;
  private $data;
  public function __construct()
  {
    $this->mb = new MenuBuilder();
  }
  private function addLink($data)
  {
    if ($data['parent_id'] === NULL) {
      $this->mb->addLink($data["id"], $data['name'], $data['slug'], false, 'coreui', $data['sequence']);
    }
  }
  private function addTitle($data)
  {
    $this->mb->addTitle($data['id'], $data['name'], false, 'coreui', $data['sequence']);
  }
  private function loopMain()
  {
    for ($i = 0; $i < count($this->data); $i++) {
      switch ($this->data[$i]['target']) {
        case 'link':
          $this->addLink($this->data[$i]);
          break;
        case 'text':
          $this->addTitle($this->data[$i]);
          break;
      }
    }
  }
  public function render($data)
  {
    if (!empty($data)) {
      $this->data = $data;
      $this->loopMain();
    }
    return $this->mb->getResult();
  }
}

C:\xampp82\htdocs\testvn\routes\web.php

<?php
use App\Http\Controllers\BannerController;
use App\Http\Controllers\HomeController;
use Illuminate\Support\Facades\Route;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
Route::group(['middleware' => 'get.menu'],function(){
  Route::get('/', function () {
    return view('dashboard.homepage');
  });
});