@php $i = 0; @endphp @foreach ($users as $user) @php // Available leave days per type $elAvailable = $user->userLeaves->where('leave_type_id', 5)->first()?->leave_days ?? 0; $clAvailable = $user->userLeaves->where('leave_type_id', 6)->first()?->leave_days ?? 0; $melAvailable = $user->userLeaves->where('leave_type_id', 7)->first()?->leave_days ?? 0; // Leave taken (approved only) $elTaken = $user->leaveRequests->where('leave_type_id', 5)->where('is_approved', 1)->sum('no_of_days'); $clTaken = $user->leaveRequests->where('leave_type_id', 6)->where('is_approved', 1)->sum('no_of_days'); $melTaken = $user->leaveRequests->where('leave_type_id', 7)->where('is_approved', 1)->sum('no_of_days'); @endphp @if ($user->leaveRequests->count()) @foreach ($user->leaveRequests as $request) @endforeach @else @endif @endforeach

Sr No.	Emp Code	Emp Name	Department	Office	Class	Leave Type	From Date	To Date	Days	EL Available	EL Taken	CL Available	CL Taken	MEL Available	MEL Taken	Approval Status	Remark	View Document	Action
{{ ++$i }}	{{ $user->emp_code }}	{{ $user->name }}	{{ $user->department?->name }}	{{ $user->ward?->name }}	{{ $user->clas?->name }}	{{ $request->leaveType?->name ?? 'Half Day' }}	{{ $request->from_date }}	{{ $request->to_date }}	{{ $request->no_of_days }}	{{ $elAvailable - $elTaken }}	{{ $elTaken }}	{{ $clAvailable }}	{{ $clTaken }}	{{ $melAvailable }}	{{ $melTaken }}	@foreach ($request->approvalHierarchy as $hierarchy) {{ $loop->iteration }} Approver - {{ $hierarchy->status == 0 ? 'Pending' : 'Approved' }} @endforeach	{{ Str::limit($request->remark, 60) }}	@if ($request->document) View @else N/A @endif	@if ($request->is_approved == 0) Pending @elseif ($request->is_approved == 1) Approved @else Rejected @endif @if ($isAdmin) @endif
{{ ++$i }}	{{ $user->emp_code }}	{{ $user->name }}	{{ $user->department?->name }}	{{ $user->ward?->name }}	{{ $user->clas?->name }}	No leave requests			0	{{ $elAvailable }}	0	{{ $clAvailable }}	0	{{ $melAvailable }}	0	-