@if ($doj) @endif @if ($doj) @endif @foreach ($dateArr as $dates) @endforeach {{-- @for ($i = 0; $i < 100; $i++) --}} @foreach ($attendanceSummary as $key => $value) {{-- @if ($key > 0 && $key % 4 == 0) @endif --}} @php $value->load([ 'vwAttendanceSummary' => function ($q) use ($month_id, $year_id) { $q->where('month', '=', $month_id)->where('year', '=', $year_id); }, ]); @endphp {{-- @if (!empty($value->vwAttendanceSummary)) --}} {{-- @endif --}} @php $rowSpan = 7; if($user->can_role('Performance Incentive Hours')){ $rowSpan++; } $tolalDays = $aadhar + $doj + count($dateArr); $value->load([ 'vwAttendanceSummary' => function ($q) use ($month_id, $year_id) { $q->where('month', '=', $month_id)->where('year', '=', $year_id); }, ]); @endphp @if ($doj) @endif @if ($doj) @endif @php $atSummary = $value->getAttendanceSummaryList($month_id, $year_id); @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 @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 @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @else @php $attendance = $atSummary[$date]; @endphp @endif @endforeach {{-- @if (($key + 1) % 6 == 0) @endif --}} @endforeach {{-- @endfor --}}

{{ $organization->name }} Performance Register - {{ $month_name }} {{ $year_id }}
{{ trans('master/master.sr_no') }}	{{ trans('master/master.name') }}	{{ trans('master/master.employee_code') }}	Aadhar	DOJ	{{ trans('master/master.designation') }}	{{ trans('master/master.department') }}	{{ trans('master/master.workstation') }}	{{ trans('master/master.employee_type') }}		{{ date('d', strtotime($dates)) }} ({{ date('D', strtotime($dates)) }})
{{ trans('master/master.present') }}: {{ $value->vwAttendanceSummary->total_present ?? '-' }}   {{ trans('master/master.absent') }}: {{ $value->vwAttendanceSummary->total_absent ?? '-' }}   {{ trans('master/master.leave') }}: {{ $value->vwAttendanceSummary->total_leave ?? '-' }}   {{ trans('master/master.paid_leave') }}: {{ $value->vwAttendanceSummary->paid_leave }}   {{ trans('master/master.unpaid_leave') }}: {{ $value->vwAttendanceSummary->unpaid_leave }}   {{ trans('master/master.holiday') }}: {{ $value->vwAttendanceSummary->total_holiday ?? '-' }}   {{ trans('master/master.week_off') }}: {{ $value->vwAttendanceSummary->total_week_off ?? '-' }}   {{ trans('master/master.fine_days') }}: {{ number_format(@$value->vwAttendanceSummary->total_fine_days, 2) }}   Total Penalty Minutes: {{ number_format(@$value->vwAttendanceSummary->total_penalty_minutes, 2) }}   {{ trans('master/master.pay_days') }}: {{ number_format(@$value->vwAttendanceSummary->total_pay_days, 2) }}   {{ trans('attendance/admin.working_hours') }}: {{ round(@$value->vwAttendanceSummary->total_working_time, 2) }} ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds($value->vwAttendanceSummary->total_working_time) }})   {{ trans('master/master.actual_ot_hours') }}: {{ round(@$value->vwAttendanceSummary->actual_overtime ?: 0, 2) }} ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds(@$value->vwAttendanceSummary->actual_overtime ?: 0) }})   {{ trans('master/master.approved_ot_hours') }}: {{ round(@$value->vwAttendanceSummary->total_overtime, 2) }} ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds($value->vwAttendanceSummary->total_overtime) }})   {{ trans('master/master.ot') }} %: {{ @$value->vwAttendanceSummary->total_overtime > 0 && $value->vwAttendanceSummary->total_working_time > 0 ? round(($value->vwAttendanceSummary->total_overtime / $value->vwAttendanceSummary->total_working_time) * 100, 2) : 0 }} {{ trans('master/master.productive_hour') }} : {{ round(@$value->vwAttendanceSummary->total_productive_hours ?: 0, 2) }} ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds(@$value->vwAttendanceSummary->total_productive_hours ?: 0) }}) @if ($user->can_role('Performance Incentive Hours')) {{ trans('master/master.incentive_hours') }} : {{ round(@$value->vwAttendanceSummary->total_incentive_hours ?: 0, 2) }} ({{ \App\Helpers\GeneralHelper::decimalToHoursMinutesSeconds(@$value->vwAttendanceSummary->total_incentive_hours ?: 0) }}) @endif
{{ $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->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') }}:	-	{{ $attendance->first_half_status }} @if ($attendance->first_half_status == 'L') ({{ strtoupper($attendance->leave_type) }}) @endif {{ $attendance->second_half_status }} @if ($attendance->second_half_status == 'L') ({{ strtoupper($attendance->leave_type) }}) @endif
{{ trans('master/master.final_status') }}:	-	{{ $attendance->status }}{{ $attendance->is_wfh ? '(WFH)' : '' }}