@foreach ($leaveTypes as $leaveType) @endforeach @forelse ($empList as $emp) @php $presentDays = $emp->punches->where('duration', '>=', $settings['MIN_COMPLETION_HOUR'])->count(); $halfDays = $emp->punches->where('duration', '>=', $settings['HALF_DAY_DURATION'])->where('duration', '<=', $settings['MIN_COMPLETION_HOUR'])->count(); $weekOffs = $emp->punches->where(['type'=> '4', 'is_paid'=> '1'])->count(); $weekOffs = $weekOffs == 0 ? $weekDays : $weekOffs; $latemark = $emp->punches->where('is_latemark', 1)->count(); $clLatemark = floor($latemark/3); $clHalfday = $emp->punches->where('type', '2')->count()/2; @endphp {{-- Leaves --}} {{-- Paid Leaves --}} @foreach ($leaveTypes as $leaveType) @if ($leaveType->id == '6') @else @endif @endforeach @empty @foreach ($leaveTypes as $leaveType) @endforeach @endforelse

Sr No	Emp Code	Emp Name	Department	Total Working Days	Late Marks	Half Day Punch	Half Day Leave	Week Offs	Holidays	Unpaid Leaves	Paid Leaves	{{ ucfirst($leaveType->name) }}	Present Days	Total Present Days	Absent Days
{{ $loop->iteration }}	{{ $emp?->emp_code }}	{{ $emp?->name }}	{{ $emp->department?->name }}	{{ $totalDays }}	{{ $latemark }}	{{ $halfDays }}	{{ $emp->punches->where('type', '2')->count() }}	{{ $weekOffs }}	{{ $holidays->count() }}	{{ $emp->punches->where('is_paid', '0')->count() }}	{{ $emp->punches->where('is_paid', '1')->whereIn('type', ['1','2', '3'])->count() }}	{{ $emp->punches->where('leave_type_id', $leaveType->id)->count()+$clHalfday+$clLatemark }}	{{ $emp->punches->where('leave_type_id', $leaveType->id)->count() }}	{{ $presentDays - ( $halfDays/2 ) }}	{{ $presentDays + $weekOffs + $holidays->count() - ( $halfDays/2 ) }}	{{ $totalDays - ($presentDays + $weekOffs + $holidays->count()) + ( $halfDays/2 ) }}