Level 24
Are you using models and relationships?
Aug 13, 2018
4
Level 1
Two counts with multiple inner join
I have 3 tables with relationships
Projects ProjectEvaluations => project_id Observations => project_id
I need to generate two counts, one for qty of project evaluations and other one for observations
Like this
How can I do?
-----------.------------
count 1 | count 2 |
10 3
------------------------
Level 1
@staudenmeir yes
// Project
public function EvaluationProject()
{
return $this->hasMany('App\EvaluationProject');
}
public function Observation()
{
return $this->hasOne('App\Observation');
}
// EvaluationProject
public function Project()
{
return $this->belongsTo('App\Project');
}
// Observation
public function Project()
{
return $this->belongsTo('App\Observation');
}
Level 24
You can use withCount():
$projects = Project::withCount('evaluations', 'observations')->get();
foreach($projects as $project) {
// $project->evaluations_count
// $project->observations_count
}
Level 67
Please or to participate in this conversation.