@php $today = date('Y-m-d'); $attendances = App\Models\Attendance::select('gcp_attendances.*') ->join('gcp_users', 'gcp_users.UserID', '=', 'gcp_attendances.UserID') ->where('gcp_users.IsActive', 1) ->whereIn('gcp_users.roleID', [18, 19, 20, 21, 22, 23, 24, 25, 26, 27]) ->whereDate('gcp_attendances.AttendanceDate', $today) ->orderBy('gcp_users.FullName', 'asc') ->get(); $Group=DB::table('gcp_attendances') ->leftjoin('gcp_users','gcp_attendances.UserID','=','gcp_users.UserID') ->where('gcp_attendances.AttendanceDate',date('Y-m-d')) ->where('gcp_users.IsActive',true)->where('gcp_users.roleID','!=',16)->where('gcp_users.roleID','!=',17)->where('gcp_users.roleID','!=',28) ->orderBy('gcp_attendances.AttendanceDate')->select('gcp_attendances.Status', DB::raw('count(*) as total')) ->groupBy('gcp_attendances.Status') ->get(); @endphp {{-- attendance modal --}}

Select User

Select date and time

@foreach ($attendances as $attendance) @endforeach

User Name	Attendance Date	Day	Time In	Time Out	Total Time	Status	Comment
{{$attendance->user->FullName}}	{{ date('d-m-Y', strtotime($attendance->AttendanceDate)) }}	{{ date('l', strtotime($attendance->AttendanceDate)) }}				{!!hr_attendance_status($attendance->Status)!!}

STATUS COUNT

@foreach ($Group as $a) @php $color=DB::table('gcp_statuses')->where('Sno',$a->Status)->first(); @endphp @endforeach

STATUS	COUNT
{{$color->Status}}	{{$a->total}}

My Attendance

STATUS COUNT