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') ->whereIn('sys_auth.idroles', $users_rules) ->where('sys_dmenu.isactive', '1') ->where('sys_dmenu.show', '1') ->where('sys_auth.isactive', '1') ->where('sys_dmenu.gmenu', $g->gmenu) ->select('sys_dmenu.*') ->distinct() ->orderBy('sys_dmenu.urut', 'asc') ->get(); @endphp @foreach ($querydmenu as $d)
  • {{ $d->name }} @if ($d->dmenu == 'trappr') @php $user_login = DB::table('users') ->where('username', session('username')) ->first(); if (!$user_login) { abort(404, 'User not found'); } if ($user_login) { $firstname = $user_login->firstname; $lastname = $user_login->lastname; $idroles = $user_login->idroles; $mst_departemen = DB::table('mst_departemen') ->select('nama', 'kode') ->where('nama', $lastname) ->first(); $validDepartments = DB::table('users') ->where('firstname', $firstname) ->where('idroles', $idroles) ->pluck('lastname'); $status = request()->input('status'); if (empty($status)) { $status = ['belum_disetujui', 'telah_direvisi']; } if ($mst_departemen) { $notifCount = DB::table('tr_permintaan_h') ->where(function ($query) use ($status) { if (!is_array($status)) { $status = explode(',', $status); } foreach ($status as $stat) { $query->orWhere('status', $stat); } }) ->whereIn('dpt', $validDepartments) ->orderBy('id', 'desc') ->Count(); } else { $notifCount = 0; } } else { $notifCount = 0; } @endphp @if ($notifCount > 0) {{ $notifCount }} @endif @endif
    • @endforeach @else
  • name == $title_group ? 'aria-expanded=true' : '' }}>
    {{ $g->name }}
      @php $querydmenu = DB::table('sys_dmenu') ->join('sys_auth', 'sys_dmenu.dmenu', '=', 'sys_auth.dmenu') ->whereIn('sys_auth.idroles', $users_rules) ->where('sys_dmenu.isactive', '1') ->where('sys_dmenu.show', '1') ->where('sys_auth.isactive', '1') ->where('sys_dmenu.gmenu', $g->gmenu) ->select('sys_dmenu.*') ->distinct() ->orderBy('sys_dmenu.urut', 'asc') ->get(); @endphp @foreach ($querydmenu as $d)
    • {{ $d->name }}
      • @endforeach
    • @endif @endforeach