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();
?>
role_id)->value('akses');
?>
Program                            
@if($getStatus == 'administrator')
Dashboard
@endif
Data Viz Tableau
@foreach($module_parent as $parent)
{{$parent->module_name}}
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();
?>
@foreach($module_childs as $child)
@endforeach
@endforeach