@php $wfhCount = \App\Models\Wfh::where('is_replied', '0')->count(); $leaveCount = \App\Models\Leave::where('is_replied', '0')->count(); $permissionCount = \App\Models\Permission::where('is_replied', '0')->count(); $totalRequest = $wfhCount + $leaveCount + $permissionCount; // Birthday count - Today + next 7 days $today = \Carbon\Carbon::today(); $birthdayCount = \App\Models\User::where('role', 'staff') ->whereNotNull('dob') ->get() ->filter(function ($user) use ($today) { $dob = \Carbon\Carbon::parse($user->dob); $birthday = \Carbon\Carbon::create( $today->year, $dob->month, $dob->day ); // If birthday already passed this year, // consider next year's birthday if ($birthday->lt($today)) { $birthday->addYear(); } $birthdayDays = $today->diffInDays($birthday); return $birthdayDays <= 7; }) ->count(); @endphp
@yield('content')