@unlessrole(['admin', 'super_admin'])

Data Konfirmasi

Aproval Pengajuan

{{ App\Models\pengajuankebutuhan::where('author', auth()->user()->id)->count() }}
{{ App\Models\pengajuankebutuhan::where('author', auth()->user()->id)->whereHas('confirmation', function ($query) {$query->where('status', 'proses');})->count() }}
{{ App\Models\pengajuankebutuhan::where('author', auth()->user()->id)->whereHas('confirmation', function ($query) {$query->where('status', 'terima');})->count() }}
{{ App\Models\pengajuankebutuhan::where('author', auth()->user()->id)->whereHas('confirmation', function ($query) {$query->where('status', 'tolak');})->count() }}

Data Rencana belanja

{{ App\Models\codeproduk::where('lokasi_id', auth()->user()->roles->first()->id)->where('status_rencana_belanja', '!=', null)->count() }}
{{ App\Models\codeproduk::where('lokasi_id', auth()->user()->roles->first()->id)->where('status_rencana_belanja', 'proses')->count() }}
{{ App\Models\codeproduk::where('lokasi_id', auth()->user()->roles->first()->id)->where('status_rencana_belanja', 'selesai')->count() }}

Aproval Rusak / Hilang

{{ App\Models\pengajuankerusakan::where('author', auth()->user()->id)->count() }}
{{ App\Models\pengajuankerusakan::where('author', auth()->user()->id)->whereHas('confirmation', function ($query) {$query->where('status', 'proses');})->count() }}
{{ App\Models\pengajuankerusakan::where('author', auth()->user()->id)->whereHas('confirmation', function ($query) {$query->where('status', 'terima');})->count() }}
{{ App\Models\pengajuankerusakan::where('author', auth()->user()->id)->whereHas('confirmation', function ($query) {$query->where('status', 'tolak');})->count() }}
@foreach ($role as $r) @if ($r->name == auth()->user()->roles->first()->name)

({{ $r->users->count() }} User)

{{ str(str()->title($r->name))->replace('_', ' ') }}

Jumlah Jenis Produk : {{ App\Models\codeproduk::where('lokasi_id', $r->id)->count() }} Jenis
Jumlah : {{ App\Models\codeproduk::where('lokasi_id', $r->id)->sum('jumlah_awal') }} Unit {{ App\Models\codeproduk::where('lokasi_id', $r->id)->sum('jumlah_akhir') }} Unit
@endif @endforeach @endunlessrole