我有这样的User和Holiday模型:
User model:个
class User extends Authenticatable
{
public function holidays(): HasMany
{
return $this->hasMany(Holiday::class);
}
Holiday model:
class Holiday
{
protected $fillable = [
'dayoff', // DATE YYYY-MM-DD
'user_id',
];
public function user(): BelongsTo
{
return $this->belongsTo(User::class);
}
给定$month
和$year
,我希望获得所有用户及其相关假期(dayoff
).
我怎样才能做到这一点呢?
Edit:个
我这样重写了下面的answer条:
use Illuminate\Database\Eloquent\Builder;
$users = User::whereHas('holidays', function (Builder $query) use ($year, $month) {
$query->whereYear('dayoff', $year)->whereMonth('dayoff', $month);
})->get();
但这给出了没有相关假期的用户列表(每个用户的dayoff
个列表)