@if ($aadhar) @endif @if ($doj) @endif @if (!$hideColumnsInMonthlyExcel) @endif @foreach ($dateArr as $dates) @endforeach @foreach ($attendanceSummary as $key => $value) @php $perPage = 3; @endphp @php $rowSpan = 7; if ($user->can_role('Performance Incentive Hours')) { $rowSpan += 1; } $tolalDays = $aadhar + $doj + count($dateArr); @endphp @if ($doj) @endif @if ($doj) @endif @if (!$hideColumnsInMonthlyExcel) @endif @php $atSummary = $value->getAttendanceSummaryFilter($fromDate, $toDate); @endphp @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; $boxColor = '#198754'; $boxColor = 'none'; if (@$attendance->entry_mode == \App\Helpers\ConstantHelper::REGULARIZED) { $boxColor = '#198754'; } elseif (@$attendance->entry_mode == \App\Helpers\ConstantHelper::MODIFIED) { $boxColor = '#0dcaf0'; } @endphp @endif @endforeach @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach @if (!$hideColumnsInMonthlyExcel) @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach @if ($user->can_role('Performance Incentive Hours')) @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach @endif @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach @endif @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; $status = (bool) $convertHDtoLt && strtoupper(trim($attendance->status)) === 'HD' ? 'Lt' : $attendance->status; @endphp @endif @endforeach @endforeach

{{ $organization->name }} Performance Register - {{ \Carbon\Carbon::parse($from_date)->format('d-m-Y') }} to {{ \Carbon\Carbon::parse($to_date)->format('d-m-Y') }}
{{ trans('master/master.sr_no') }}	{{ trans('master/master.name') }}	{{ trans('master/master.employee_code') }}	Aadhar	DOJ	{{ trans('master/master.designation') }}	{{ trans('master/master.sub_department') }}	{{ trans('master/master.department') }}	{{ trans('master/master.workstation') }}	{{ trans('master/master.employee_type') }}		{{ date('d', strtotime($dates)) }} ({{ date('D', strtotime($dates)) }})
{{ $key + 1 }}	{{ @$value->name }}	{{ @$value->employee_code }}	{{ @$value->aadhar_number }}	{{ $value->date_of_joining ? date('d-M-Y', strtotime($value->date_of_joining)) : '' }}	{{ @$value->designation->name }}	{{ @$value->subDepartment->name }}	{{ @$value->department->name }}	{{ @$value->workstation->name }}	{{ ucwords(@$value->employee_type) }}	{{ trans('master/master.in') }}:	-	{{ $attendance->in_time ? date('H:i', strtotime($attendance->in_time)) : '-' }}
{{ trans('master/master.out') }}:	-	{{ $attendance->out_time ? date('H:i', strtotime($attendance->out_time)) : '-' }}
{{ trans('attendance/admin.working_hours') }}:	-	{{ $attendance->working_time && $attendance->working_time != '00:00:00' ? date('H:i', strtotime($attendance->working_time)) : '-' }}
{{ trans('master/master.actual_overtime') }}:	-	{{ $attendance->actual_overtime && $attendance->actual_overtime != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->actual_overtime) : '-' }}
{{ trans('master/master.approved_overtime') }}:	-	{{ $attendance->overtime && $attendance->overtime != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->overtime) : '-' }}
{{ trans('master/master.incentive_hours') }}:	-	{{ $attendance->incentive_hours && $attendance->incentive_hours != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->incentive_hours) : '-' }}
{{ trans('master/master.status') }}:	-	@php $firstHalfstatus = (bool) $convertHDtoLt && strtoupper(trim($attendance->first_half_status)) === 'HD' ? 'Lt' : $attendance->first_half_status; $secondHalfstatus = (bool) $convertHDtoLt && strtoupper(trim($attendance->second_half_status)) === 'HD' ? 'Lt' : $attendance->second_half_status; @endphp {{ $firstHalfstatus }} @if ($attendance->first_half_status == 'L') ({{ strtoupper($attendance->leave_type) }}) @endif {{ $secondHalfstatus }} @if ($attendance->second_half_status == 'L') ({{ strtoupper($attendance->leave_type) }}) @endif
{{ trans('master/master.final_status') }}:	-	{{ $status }}{{ $attendance->is_wfh ? '(WFH)' : '' }}