我有可以工作的代码,但不需要急于加载嵌套关系。
$projects = Project::with('organization')
->leftJoin('stages', 'stages.project_id', '=', 'projects.id')
->leftJoin('activities', 'activities.stage_id', '=', 'stages.id')
->leftJoin('tasks', 'tasks.activity_id', '=', 'activities.id')
->select('projects.*', DB::raw('SUM(IF(tasks.status = 4, score, 0)) AS score'),
DB::raw('SUM(tasks.score) AS total_score'))
->groupBy('projects.id')
->get();
我想用热切加载嵌套关系来实现这一点,如果我没有这些自定义选择(total_score和score),我会进行
$projects = Project::with('stages.activities.tasks');
但问题出现在那些自定义选择(score和total_score)上。我试过类似的方法,但没有成功
$projects = Project::with(['stages', 'activities', 'tasks' => function($q) {
$q->select( DB::raw('SUM(IF(tasks.status = 4, score, 0)) AS score'),
DB::raw('SUM(tasks.score) AS total_score'));
}])->get();
类似的东西应该会起作用:
$projects = $project::with(array('stages' => function($q)
{
$q->with(array('activities' => function($q)
{
$q->with(array('tasks' => function($q)
{
$q->groupBy('tasks.id');
$q->addselect([
DB::raw('SUM(IF(tasks.status = 4, score, 0)) AS score'),
DB::raw('SUM(tasks.score) AS total_score')
]);
}));
}));
}))
->get();
如果您的函数function($q) use ($arg)
需要更多的参数。