MF
Size: a a a
MF
D
A
AH
A
AH
DB::raw('SELECT w.id as w_id, w.first_name as first_name, SUM(worktime) as summary FROM workers as w LEFT JOIN work_times as wt ON wt.worker_id=w.id GROUP BY w_id, first_name');
MF
MF
AH
AH
public function workTimes()В нужном месте кода:
{
return $this->hasMany(WorkTime::class);
}
$workers = Worker::get();Ещё лучше через жадную загрузку:
$workers->each(function (Worker $worker) {
$worker->workTimes()->sum('worktime');
});
$workers= Worker::with('workTimes')->get();
$workers->each(function (Worker $worker) {
$worker->workTimes->sum('worktime');
});
D
AH
D
D
AH
D
D