为即时加载查询添加额外的约束

Question

我有一个名为vehicles的表，它与名为fuels的表有一对多的关系。fuels表中的一列标题为cost。当我得到车辆模型时，我如何得到在两天内累积的总燃料cost ?

我试过了:

$vehicles = Vehicle::withSum([
    'fuels',
    'cost' => function ($query) use ($start, $end) {
        $query->whereBetween('date', [$start, $end]);
    }
])->get();

Answer 1

$vehicles = Vehicle::withSum(
    ['fuels' => fn($q) => $q->whereBetween('date', [$start, $end])],
    'cost'
)->get();