main_logo {{ @$setup_app->appname }}
    {{-- LOOPING GMENU --}} @foreach ($gmenu as $g) @if ($g->gmenu == 'blankx') {{-- Query DMenu --}} @php $querydmenu = DB::table('sys_dmenu') ->join('sys_auth', 'sys_dmenu.dmenu', '=', 'sys_auth.dmenu') ->where('sys_auth.idroles', session('user')->idroles) ->where('sys_dmenu.isactive', '1') ->where('sys_dmenu.show', '1') ->where('sys_auth.isactive', '1') ->where('sys_dmenu.gmenu', $g->gmenu) ->select('sys_dmenu.*') ->orderBy('sys_dmenu.urut', 'asc') ->get(); @endphp @foreach ($querydmenu as $d)
  • {{ $d->name }} {{-- check query notif --}} @if ($d->notif != '') @php // get notif $data_notif = DB::select($d->notif); foreach ($data_notif as $n) { $notif = $n->notif; } @endphp {{ $notif }} @endif
    • @endforeach @else
  • name == $title_group ? 'aria-expanded=true' : '' }}>
    {{ $g->name }}
      {{-- Query DMenu --}} @php $idroles = session('user')->idroles; $querydmenu = DB::table('sys_dmenu') ->join('sys_auth', 'sys_dmenu.dmenu', '=', 'sys_auth.dmenu') ->where('sys_auth.idroles', $idroles) ->where('sys_dmenu.isactive', '1') ->where('sys_dmenu.show', '1') ->where('sys_auth.isactive', '1') ->where('sys_dmenu.gmenu', $g->gmenu) ->select('sys_dmenu.*') ->orderBy('sys_dmenu.urut', 'asc') ->get(); @endphp @foreach ($querydmenu as $d) @php $_notif = 0; @endphp
    • {{ $d->name }} @if ($d->dmenu == 'rqlist' || $d->dmenu == 'mtlist' || $d->dmenu == 'trreqs' || $d->dmenu == 'trmuts') @php $respond = ($d->dmenu == 'rqlist' || $d->dmenu == 'mtlist') ? '-1' : '1'; if ($d->dmenu == 'trmuts') { $_notif = DB::table($d->tabel) ->where('respond', $respond) ->where(function ($query) { $query->where('user_create', Session::get('username')) ->orWhere('spv2_name', Session::get('username')); }) ->count(); } elseif ($d->dmenu == 'rqlist' || $d->dmenu == 'mtlist') { if ($d->dmenu == 'rqlist') { $_notif = DB::table($d->tabel)->where('respond', $respond)->where('isactive', '1')->count(); } elseif ($d->dmenu == 'mtlist') { $_notif1 = DB::table($d->tabel)->where('respond', $respond)->count(); $_notif2 = DB::table($d->tabel)->where('respond', '1')->where('request_type', '2')->count(); $_notif = $_notif1 + $_notif2; } } else { $_notif = DB::table($d->tabel)->where('respond', $respond)->where('user_create', Session::get('username'))->where('isactive', '1')->count(); } @endphp @endif @if ($_notif > 0) {{ $_notif }} @endif {{-- check query notif --}} @if ($d->notif != '') @php // get notif $data_notif = DB::select($d->notif); foreach ($data_notif as $n) { $notif = $n->notif; } @endphp {{ $notif }} @endif
      • @endforeach
    • @endif @endforeach