{{ $reportHeading['report_label'] }}

Branch: {{ $reportHeading['branch_name'] }}, Project: {{ $reportHeading['project_name'] }}

@foreach ($leaveTags as $tag) @if ($tag->slug == 'annual' || $tag->slug == 'npl' || $tag->slug == 'casual') @else @endif @endforeach @php $sl = 1; @endphp @foreach ($employees as $employee) @foreach ($leaveTags as $tag) @if ($tag->slug == 'annual' || $tag->slug == 'npl' || $tag->slug == 'casual') @php $numberOfLeave = $leave_applications->where('emp_id_fk', $employee->id)->where('hr_leave_type_tag_id_fk', $tag->id)->sum('counted_leave'); $numberOfLeave = $numberOfLeave == 0 ? '-' : $numberOfLeave; $lateLeave = $late_leaves->where('emp_id_fk', $employee->id)->where('hr_leave_type_tag_id_fk', $tag->id)->sum('day'); $lateLeave = $lateLeave == 0 ? '-' : $lateLeave; @endphp @else @php $numberOfLeave = $leave_applications->where('emp_id_fk', $employee->id)->where('hr_leave_type_tag_id_fk', $tag->id)->sum('counted_leave'); $numberOfLeave = $numberOfLeave == 0 ? '-' : $numberOfLeave; @endphp @endif @endforeach @endforeach

SL	Employee Name	ID	Designation	Consumed On {{ date('d-m-Y', strtotime($start_date)) }} to {{ date('d-m-Y', strtotime($end_date)) }}
				{{ $tag->short_name }}		{{ $tag->short_name }}
				Reg	Late	{{ $tag->short_name }}	Reg	Late	Reg	Late
{{ $sl++ }}	{{ $employee->emp_name_english }}	{{ $employee->emp_id }}	{{ $employee->position_name }}	{{ $numberOfLeave }}	{{ $lateLeave }}	{{ $numberOfLeave }}

Prepared By

Checked By

Reviewed By

Approved By

{{ $reportHeading['company_name'] }}