@foreach ($dateArr as $dates) @endforeach @foreach ($employeeSummary as $key => $value) @php $totalPresent = $overtime = $actualOvertime = $totalActualOvertime = $totalovertime = 0; $totalWorkingDays = 0; $atSummary = $value->getAttendanceSummaryFilter($fromDate, $toDate); $salarySlip = @$value->salarySlip->select('id','employee_id','month','year','total_gross') ->where('employee_id',$value->id) ->where('month','=',$month_id) ->where('year','=',$year_id) ->first(); $totalGross = $salarySlip->total_gross? $salarySlip->total_gross:'-'; $overtimeIncentive = @$salarySlip->slipLogs->where('type_id', $overtimeIncentiveComponent->config_value)->first(); $overtimeIncentive = @$overtimeIncentive->calculate_salary?:0; $attendanceIncentive = @$salarySlip->slipLogs->where('type_id', $attendanceIncentiveComponent->config_value)->first(); $attendanceIncentive = @$attendanceIncentive->calculate_salary?:0; $multiAmount = @$salarySlip->slipLogs->where('type_id', $multiAmountComponent->config_value)->first(); $multiAmount = @$multiAmount->calculate_salary?:0; $nightShiftAmount = @$salarySlip->slipLogs->where('type_id', $nightShiftAmountComponent->config_value)->first(); $nightShiftAmount = @$nightShiftAmount->calculate_salary?:0; $totalAmount = $overtimeIncentive + $attendanceIncentive + $multiAmount + $nightShiftAmount; $totalFixedGross = @$salarySlip->slipLogs->where('type_id', $totalGrossComponent->config_value)->first(); $totalFixedGross = @$totalFixedGross->actual_salary ?:0; @endphp @endphp @foreach ($dateArr as $date) @if (!isset($atSummary[$date])) @continue; @endif @php $attendance = isset($atSummary[$date]) ? $atSummary[$date] : null; $overtime + $approverdOvertime = intval(substr($attendance->overtime, 0, -6)) * 60 + intval(substr($attendance->overtime, -5, -3)); $overtime = $overtime + $approverdOvertime; $totalovertime = round($overtime / 60, 2); $approverdOvertimeHour = round($approverdOvertime/60,2); $totalWorkingDays = $totalWorkingDays + $attendance->day_count; @endphp @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.total_ot') }}({{ trans('master/master.hours') }})	{{ trans('master/master.total_working_days') }}	{{ trans('payroll/payroll.total_gross_salary') }}	{{ trans('payroll/payroll.gross_salary') }}	{{ trans('master/master.attendance_incentive_amount') }}	{{ trans('master/master.overtime_incentive_amount') }}	{{ trans('master/master.multi_amount') }}	{{ trans('master/master.night_shift_amount') }}	{{ trans('payroll/payroll.total_amount') }}
{{ $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 }}	-	@if($approverdOvertimeHour>0) {{$approverdOvertimeHour}} @else - @endif	{{ $totalovertime?$totalovertime:'-' }}	{{ $totalWorkingDays? $totalWorkingDays:'-'}}	{{ $totalFixedGross }}	{{ $totalGross?$totalGross:'-'}}	{{$attendanceIncentive}}	{{$overtimeIncentive}}	{{$multiAmount}}	{{ $nightShiftAmount }}	{{$totalAmount}}