@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 @if($column === 'from_date') @endif	To Date @if($column === 'to_date') @endif	Days	EL Available	EL Taken	CL Available	CL Taken	MEL Available	MEL Taken	Approval Status	Remark	View Document	Action
{{ ++$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) Approver - {{ $hierarchy->status == 0 ? 'Pending' : 'Approved' }} @endforeach	{{ Str::limit($request->remark, 60) }}	View	{{-- @if($type_const == 'pending') --}} @if ($request->is_approved == 0) Pending @elseif ($request->is_approved == 1) Approved @else Rejected @endif {{-- @endif --}} @if($isAdmin) @endif