CODEWITHSUNDEEP
phplaravel
tarikul
tarikul

Reputation: 19

Return employee count based on relationship

I have a employees table and a attendances table

In employees Model

public function Attendance(){
    return $this->hasMany(Attendance::class, 'employees_id', 'id');
}

Attendances table i have these column id, employees_id, in_time, out_time, attendance_status_id, remarks

I want return those employee who has al least one attendance for a specific month which i will input in month field and it will filter based on in_time column

Upvotes: 0

Views: 61

Answers (1)

wiwek chauhan
wiwek chauhan

Reputation: 667

You can use the has() function when getting the Employee details. The has will only return those records if the Employee has any relational data in the Attendance table. You can also refer this link.

$employees = Employee::has('Attendance')->get();

Now you can simply use the count() function the display the total Attendance of the Employee. For the count please refer this link.

@foreach ($employees as $employee)
    Total attendance: {{ $employee->Attendance->count() }}
@endforeach

Upvotes: 1

Related Questions