djid_siput/resources/views/dev/core/menu.blade.php

<?php
$module_parent = DB::table('role_acl')
->select('module_parent','module_name','pathParent','menu_icon')
->join('modules','role_acl.module_parent','=','modules.id')
->where('role_id', Auth::user()->role_id)
->where(function ($query){
  $query->where('create_acl','<>',0)
  ->orWhere('read_acl','<>',0)
  ->orWhere('update_acl','<>',0)
  ->orWhere('delete_acl','<>',0);
})
->groupBy('module_parent')
->groupBy('module_name')
->groupBy('pathParent')
->groupBy('menu_icon')
->orderBy('module_parent','asc')
->get();
?>

<?php 
  $getStatus = App\Model\Privillage\Role::where('id',Auth::user()->role_id)->value('akses');
?>

<li class="nav-item">
  <a class=" nav-link curved-btn {{ (Request::url() === url('/program')) ? 'active' : '' }} " href=" {{url('/program')}}"> <i class="ni ni-bullet-list-67 text-whiteX"></i> Program &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 
  </a>
</li>

@if($getStatus == 'administrator')
  <li class="nav-item  class=" active>
    <a class=" nav-link curved-btn {{ (Request::url() === url('/')) ? 'active' : '' }} " href=" {{url('/')}}"> <i class="ni ni-tv-2 text-whiteX"></i> Dashboard
    </a>
  </li>
@endif

<li class="nav-item  class=" active>
  <a class=" nav-link curved-btn {{ (Request::url() === url('/data-viz')) ? 'active' : '' }} " href=" {{url('/data-viz')}}"> <i class="fa fa-table text-whiteX"></i> Data Viz Tableau
  </a>
</li>

@foreach($module_parent as $parent)
<li class="nav-item">
  <a class="nav-link curved-btn {{ Request::is($parent->pathParent.'/*') ? 'active' : '' }}" data-toggle="collapse" href="#col{{$parent->module_parent}}" role="button" aria-expanded="false" aria-controls="col2">
    <i class="{{$parent->menu_icon}} text-whiteX"></i> {{$parent->module_name}}
  </a>
</li>
<?php
$module_childs = DB::table('role_acl')
->join('modules','role_acl.module_id','=','modules.kdModule')
->where('module_parent',$parent->module_parent)
->where('role_id', Auth::user()->role_id)
->where(function ($query) {
  $query->where('create_acl','<>',0)
  ->orWhere('read_acl','<>',0)
  ->orWhere('update_acl','<>',0)
  ->orWhere('delete_acl','<>',0);
})
->orderBy('menu_order','asc')
->get();
?>
<div class="collapse {{ Request::is($parent->pathParent.'/*') ? 'show' : '' }} multi-collapse" id="col{{$parent->module_parent}}">
  @foreach($module_childs as $child)
  <div class="card card-body list-menus">
    <ul style="padding-right: 0px;">
      <li class="nav-item"><a class="nav-link {{ str_contains(URL::current(),$child->menu_path) ? 'active curved-btn' : '' }} lk-subs" href="{{url($child->menu_path)}}">{{$child->module_name}}</a></li>
    </ul>
  </div>
  @endforeach
</div>
@endforeach