Laravel 5.4 -如何从表中统计员工的缺勤情况

// Employee.php 模型类
namespace App;

use Illuminate\Database\Eloquent\Model;

class Employee extends Model
{
    protected $table = 'employees';

    public function attendances()
    {
        return $this->hasMany('App\Attendance');
    }

    public function getAbsenceCount()
    {
        return $this->attendances()->where('status', 'absent')->count();
    }
}

// Attendance.php 模型类
namespace App;

use Illuminate\Database\Eloquent\Model;

class Attendance extends Model
{
    protected $table = 'attendance';

    public function employee()
    {
        return $this->belongsTo('App\Employee');
    }
}

// EmployeesController.php 控制器
namespace App\Http\Controllers;

use App\Employee;

class EmployeesController extends Controller
{
    public function showAbsence($id)
    {
        $employee = Employee::find($id);
        $absenceCount = $employee->getAbsenceCount();

        return view('employees.absence', compact('employee', 'absenceCount'));
    }
}

// absence.blade.php 视图
<h1>{{ $employee->name }}的缺勤情况</h1>
<p>缺勤次数：{{ $absenceCount }}</p>