@foreach ($dateArr as $dates) @if ($time) @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) @if (!isset($atSummary[$date])) @if ($time) @endif @continue; @endif @php $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null; $overtime += intval(substr($attendance->overtime, 0, -6)) * 60 + intval(substr($attendance->overtime, -5, -3)); $totalovertime = round($overtime / 60, 2); $actualOvertime += intval(substr($attendance->actual_overtime, 0, -6)) * 60 + intval(substr($attendance->actual_overtime, -5, -3)); $totalActualOvertime = round($actualOvertime / 60, 2); $totalPaidDays += $attendance->day_count ?: 0; if ($attendance->attendance_type == 'present' && $attendance->on_duty == 1) { $totalPresent = $totalPresent + $attendance->day_count; } @endphp @if ($time) @endif @endforeach @endforeach

{{ $organization->name }} Day Summary Report - {{ $month_name }} {{ $year_id }}
S.No	{{trans('employee/employee.device_person')}}	{{ trans('employee/employee.employee_code') }}	{{ trans('employee/employee.employee_name') }}	{{ trans('employee/employee.work_station_id') }}	{{ trans('master/master.department') }}	{{ trans('master/master.employee_type') }}	{{ trans('employee/employee.date_of_joining') }}	{{ trans('employee/employee.designation') }}	{{ trans('employee/employee.aadhar_number') }}	{{ trans('master/master.status') }}	{{ date('d', strtotime($dates)) }}		{{ trans('master/master.working_hour_time') }}	{{ trans('master/master.working_hour_hrs') }}	{{ trans('master/master.actual_ot_time') }}	{{ trans('master/master.actual_ot_hrs') }}	{{ trans('master/master.approved_ot_time') }}	{{ trans('master/master.approved_ot_hrs') }}	{{ trans('master/master.final_status') }}	{{ trans('master/master.total_paid_days') }}	{{ trans('master/master.total_duty') }}	{{ trans('master/master.total_actual_ot') }}({{ trans('master/master.hours') }})	{{ trans('master/master.total_ot') }}({{ trans('master/master.hours') }})
{{ $loop->iteration }}	{{ $value->device_person_id }}	{{ $value->employee_code }}	{{ $value->name }}	{{ @$value->workstation->name }}	{{ @$value->department->name }}	{{ $value->employee_type }}	{{ ($value->date_of_joining) ? date('d-m-Y',strtotime($value->date_of_joining)): '' }}	{{ @$value->designation->name }}	{{ $value->aadhar_number }}	{{ $value->status }}	-	-	-	-	-	-	-	-	-	{{ $time && $attendance->in_time != '00:00:00' ? date('H:i', strtotime($attendance->in_time)) : $attendance->first_half_status }} @if ($attendance->first_half_status == 'L')({{ strtoupper($attendance->leave_type)}}) @endif	{{ $time && $attendance->out_time != '00:00:00' ? date('H:i', strtotime($attendance->out_time)) : $attendance->second_half_status }} @if ($attendance->second_half_status == 'L')({{ strtoupper($attendance->leave_type)}}) @endif	{{ $attendance->working_time && $attendance->working_time != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->working_time) : '-' }}	{{ $attendance->working_time && $attendance->working_time != '00:00:00' ? App\Helpers\GeneralHelper::convertTimeToHours($attendance->working_time) : '-' }}	{{ $attendance->actual_overtime && $attendance->actual_overtime != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->actual_overtime) : '-' }}	{{ $attendance->actual_overtime && $attendance->actual_overtime != '00:00:00' ? App\Helpers\GeneralHelper::convertTimeToHours($attendance->actual_overtime) : '-' }}	{{ $attendance->overtime && $attendance->overtime != '00:00:00' ? \App\Helpers\GeneralHelper::formatToHi($attendance->overtime) : '-' }}	{{ $attendance->overtime && $attendance->overtime != '00:00:00' ? App\Helpers\GeneralHelper::convertTimeToHours($attendance->overtime) : '-' }}	{{ $attendance->status ? $attendance->status : '-' }}	{{ $totalPaidDays }}	{{ $totalPresent }}	{{ $totalActualOvertime }}	{{ $totalovertime }}