@php $colspan = 3; // IN, OUT, Working Hours if ($hideColumns) { if ($attendanceColumns['overtime']) { $colspan++; } if ($attendanceColumns['pr']) { $colspan++; } if ($attendanceColumns['status']) { $colspan++; } } @endphp @foreach ($dateArr as $dates) @endforeach @if($showColumns) @endif @if($hideColumns) @if($hideOtPRfromComplianceExcel) @endif @if (in_array('total_week_off', $showWoHoArr))@endif @if (in_array('week_off', $showWoHoArr))@endif @if (in_array('extra_week_off', $showWoHoArr))@endif @if (in_array('shut_down', $showWoHoArr))@endif @if (in_array('total_holiday', $showWoHoArr))@endif @if (in_array('holiday', $showWoHoArr))@endif @if (in_array('national_holiday', $showWoHoArr))@endif @if (in_array('restricted_holiday', $showWoHoArr))@endif @endif @foreach ($dateArr as $dates) @if($attendanceColumns['overtime']) @endif @if($attendanceColumns['pr']) @endif @if($attendanceColumns['status']) @endif @endforeach @foreach ($employeeSummary as $key => $value) @php $totalPaidDays = $totalPresent = $overtime = $actualOvertime = $totalActualOvertime = $totalovertime = 0; $atSummary = $value->getAttendanceSummaryFilter($fromDate, $toDate); @endphp @foreach ($dateArr as $date) @php $attendance = $atSummary[$date] ?? null; $boxColor = ''; $autoWeekClass = ''; if ($attendance) { if ($attendance->remarks == App\Helpers\ConstantHelper::AUTO_WEEK_OFF) { $autoWeekClass = 'autoweekoff'; } if ($attendance->entry_mode == App\Helpers\ConstantHelper::REGULARIZED) { $boxColor = '#90EE90'; } elseif ($attendance->entry_mode == App\Helpers\ConstantHelper::MODIFIED) { $boxColor = '#87CEFA'; } } @endphp @php $hideTime = $attendance && $hideWeekoffFromExport &&( $attendance->on_duty == 2 || ($attendance->on_duty == 3 && $attendance->is_week_off == 0) || in_array(strtolower($attendance->attendance_type ?? ''), ['week_off','week-off','holiday']) ); @endphp @if($hideColumns) @if($attendanceColumns['overtime']) @endif @if($attendanceColumns['pr']) @endif @if($attendanceColumns['status']) @endif @endif @endforeach @if($showColumns) @php $present = @$value->vwAttendanceSummary->total_present ?? 0; $holiday = (@$value->woHoCounts['total_holiday'] ?? 0) + (@$value->woHoCounts['total_week_off'] ?? 0); $workingDays = $present + $holiday; @endphp @endif @if($hideColumns) @if($hideOtPRfromComplianceExcel) @endif @if (in_array('total_week_off', $showWoHoArr))@endif @if (in_array('week_off', $showWoHoArr))@endif @if (in_array('extra_week_off', $showWoHoArr))@endif @if (in_array('shut_down', $showWoHoArr))@endif @if (in_array('total_holiday', $showWoHoArr))@endif @if (in_array('holiday', $showWoHoArr))@endif @if (in_array('national_holiday', $showWoHoArr))@endif @if (in_array('restricted_holiday', $showWoHoArr))@endif @endif @endforeach

S.NO	Emp. Code	Emp. Name	{{ trans('master/master.department') }}	{{ trans('master/master.category') }}	{{ trans('master/master.designation') }}	{{ date('d', strtotime($dates)) }}	PRESENT	HOLIDAY	Total Pay Days	TOTAL DUTY	PAY DAYS	TOTAL OT	TOTAL PR	Total Week Off	Week Off	Extra Week Off	Shut Down	Total Holiday	Holiday	National Holiday	Restricted Holiday
						IN																OUT	Working Hours	Overtime	PR	Status
{{$key + 1}}	{{ $value->employee_code }}	{{ $value->name }}	{{ @$value->department->name }}	{{ @$value->category->name }}	{{ @$value->designation->name }}	{{ $attendance && ( $showTimeOnWeekOffHolidayDuty || !( $attendance->on_duty == 2 || ($attendance->on_duty == 3 && $attendance->is_week_off == 0) ) ) && !empty($attendance->in_time) ? formatTime($attendance->in_time) : '-' }}	{{ $attendance && ( $showTimeOnWeekOffHolidayDuty || !( $attendance->on_duty == 2 || ($attendance->on_duty == 3 && $attendance->is_week_off == 0) ) ) && $attendance->out_time && $attendance->fact_out_time ? formatTime($attendance->fact_out_time) : '-' }}	{{ $attendance && ( $showTimeOnWeekOffHolidayDuty || !( $attendance->on_duty == 2 || ($attendance->on_duty == 3 && $attendance->is_week_off == 0) ) ) && $attendance->out_time && $attendance->fact_out_time && $attendance->fact_working_hour != '00:00:00' ? formatTime($attendance->fact_working_hour) : '-' }}	@php $attendanceOvertime = $configService->complianceOvertime($attendance); @endphp {{ $attendance && $attendanceOvertime ? number_format((int)explode(':', $attendanceOvertime)[0] + (int)explode(':', $attendanceOvertime)[1]/60, 2) : '' }}	{{ $attendance && $attendance->prformance_overtime ? number_format((int)explode(':', $attendance->prformance_overtime)[0] + (int)explode(':', $attendance->prformance_overtime)[1]/60, 2) : '' }}	@if($attendance) @if($attendance->on_duty == 2) W0 @elseif($attendance->on_duty == 3 && $attendance->is_week_off == 0) H @else {{ $attendance->status }} @endif @endif	{{ $present }}	{{ $holiday }}	{{ $workingDays }}	{{ @$value->vwAttendanceSummary->total_present}}	{{ @$value->vwAttendanceSummary->total_pay_days}}	{{ $configService->complianceTotalOvertime($value, $atSummary) }}	{{ @$value->vwAttendanceSummary->total_prformance_overtime}}	{{ @$value->woHoCounts['total_week_off']}}	{{ @$value->woHoCounts['week_off']}}	{{ @$value->woHoCounts['extra_week_off']}}	{{ @$value->woHoCounts['shut_down']}}	{{ @$value->woHoCounts['total_holiday']}}	{{ @$value->woHoCounts['holiday']}}	{{ @$value->woHoCounts['national_holiday']}}	{{ @$value->woHoCounts['restricted_holiday']}}