@php $i = $leaveRequests->perPage() * ($leaveRequests->currentPage() -1 ); @endphp @foreach ($leaveRequests as $request) @php $user = $request->user; $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; $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 @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
{{ ++$i }}	{{ $request->user?->emp_code }}	{{ $request->user?->name }}	{{ $request->user?->department?->name }}	{{ $request->user?->ward?->name }}	{{ $request->user?->clas?->name }}	{{ $request->leaveType ? $request->leaveType->name : 'Half Day' }}	{{ $request->from_date }}	{{ $request->to_date }}	{{ $request->no_of_days }}	{{ $elAvailable }}	{{ $elTaken }}	{{ $clAvailable }}	{{ $clTaken }}	{{ $melAvailable }}	{{ $melTaken }}	@foreach ($request->approvalHierarchy as $hierarchy) {{ $loop->iteration }} Approver - {{ $hierarchy->status == 0 ? 'Pending' : 'Approved' }} @endforeach	{{ Str::limit($request->remark, 60) }}