@forelse($data as $key => $value) @php $paidLeaves = \Modules\HRM\Entities\EmployeeLeave::where('employee_id', $value->employee_id )->where('start_date', '>=', $request->from_date) ->where('start_date', '<=', $request->to_date) ->where('status', '=', '2') ->where('is_paid', '=', '1')->sum('duration'); $unpaidLeaves = \Modules\HRM\Entities\EmployeeLeave::where('employee_id', $value->employee_id )->where('start_date', '>=', $request->from_date) ->where('start_date', '<=', $request->to_date) ->where('status', '=', '2') ->where('is_paid', '=', '2')->sum('duration'); @endphp @empty @endforelse

{{__('file.Employee Name')}}	{{__('file.Designation')}}	{{__('file.Department')}}	{{__('file.Branch')}}	{{__('file.Total Attended')}}	{{__('file.Total Paid Leave')}}	{{__('file.Total Un-Paid Leave')}}	{{__('file.Working Hour')}}	{{__('file.Over Time(Hours)')}}
{{ $value->employee_name }}	{{ $value->designation_name }}	{{ $value->department_name }}	{{ $value->branch_name }}	{{ $value->total_attended }}	{{ $paidLeaves }}	{{ $unpaidLeaves }}	{{ $value->total_attended_hour }}	{{ $value->total_overtime_hour }}
No data Found