{{ $organization->name }} Day Summary Report - {{ $month_name }} {{ $year_id }}
@if(!$time) @endif @if(!$time) @endif {{-- Dynamic Dates --}} @foreach($dateList as $date) @if($time) @endif @endforeach @php $i = 1; @endphp @foreach($employeeSummary as $employee) @php $attendanceData = $payrollProcess->getPayrollAttendanceData( $organization, $employee, $month_id, $year_id ); $totalPaidDays = 0; $totalPresent = 0; $totalOT = 0; @endphp @if(!$time) @endif @if(!$time) @endif @foreach($dateList as $date) @php $attendance = $employee->attendanceSummary->where('attendance_date', $date)->first(); if($attendance){ $attendanceColors = [ 'present' => '#28C76F', 'absent' => '#F8D7DA', 'week-off' => '#FFF2CC', 'holiday' => '#E7E6E6', 'leave' => '#D9EAF7', ]; $boxColor = $attendanceColors[$attendance->attendance_type] ?? ''; if (round($attendance->day_count, 2) == 0.50 && $attendance->attendance_type =='present') { $boxColor = '#FCE4D6'; } $entryModeColors = [ App\Helpers\ConstantHelper::REGULARIZED => '#E2F0D9', App\Helpers\ConstantHelper::MODIFIED => '#DDEBF7', ]; $boxColor = $entryModeColors[$attendance->entry_mode] ?? $boxColor; } @endphp @if(!$attendance) @if($time) @endif @else @if($time) @endif @php $totalPaidDays += $attendance->day_count ?? 0; @endphp @endif @endforeach @endforeach
S.No Device Emp Code NameManagerWorkstation Department Sub Dept Type DOJ Designation AadharPresent Absent LeaveStatus{{ date('d', strtotime($date)) }} WH(T) WH(H) OT(T) OT(H) AOT(T) AOT(H) StatusTotal Paid Total Duty Total OT
{{ $i++ }} {{ $employee->device_person_id }} {{ $employee->employee_code }} {{ $employee->name }}{{ $employee->hod->name ?? '' }}{{ $employee->workstation->name ?? '' }} {{ $employee->department->name ?? '' }} {{ $employee->subDepartment->name ?? '' }} {{ $employee->employee_type }} {{ $employee->date_of_joining ? date('d-m-Y', strtotime($employee->date_of_joining)) : '' }} {{ $employee->designation->name ?? '' }} {{ $employee->aadhar_number }}{{ $attendanceData['present'] ?? 0 }} {{ $attendanceData['absent'] ?? 0 }} {{ $attendanceData['leaves'] ?? 0 }}{{ $employee->status }}- -------- {{ $time ? date('H:i', strtotime($attendance->in_time)) : $attendance->first_half_status }} {{ $time ? date('H:i', strtotime($attendance->out_time)) : $attendance->second_half_status }} {{ $attendance->working_time ?? '-' }} {{ $attendance->working_time ?? '-' }} {{ $attendance->overtime ?? '-' }} {{ $attendance->overtime ?? '-' }} {{ $attendance->actual_overtime ?? '-' }} {{ $attendance->actual_overtime ?? '-' }} {{ $attendance->status ?? '-' }}{{ $totalPaidDays }} {{ $totalPresent }} {{ $totalOT }}