@forelse($data as $key => $value) @php $overtime = \Modules\HRM\Entities\Overtime::where(['employee_id' => $value->employee_id, 'start_date' => $value->check_in_date])->groupBy('employee_id','start_date')->sum('working_hour'); @endphp @empty @endforelse

{{__('file.Employee Name')}}	{{__('file.Designation')}}	{{__('file.Department')}}	{{__('file.Branch')}}	{{__('file.Shift')}}	{{__('file.Check In Date')}}	{{__('file.Check In Time')}}	{{__('file.Check Out Date')}}	{{__('file.Check Out Time')}}	{{__('file.Over Time(Hours)')}}	{{__('file.Working Hour')}}	{{__('file.approved_by')}}	{{__('file.approval_status')}}	{{__('file.Notes')}}
{{ $value->employee->name }}	{{ $value->employee->designation->name }}	{{ $value->employee->department->name }}	{{ $value->employee->branch->name }}	{{ $value->shift->name }}	{{ date("d-m-Y",strtotime($value->check_in_date)) }}	{{ date("H:i:s a",strtotime($value->check_in_time)) }}	{{ date("d-m-Y",strtotime($value->check_out_date)) }}	{{ date("H:i:s a",strtotime($value->check_out_time)) }}	{{ $overtime }}	{{ $value->working_hour+$overtime }}	{{ $value->approved_by }}	{!! DAILY_ATTENDENCE_LABEL[$value->approval_status] !!}	{{ $value->approve_remarks }}
No data Found