Laravel eloquent query with multiple child relations

Question

I am working on a query but can't find the solution to this one.

The structure i have at the moment is:

A project has 1 machine, but a machine can belong to multiple projects. A machine can have multiple issues.

Now i want to get all projects with the issues created after the project got created.

The query that i have at the moment, but doesn't work:

        $allProjects = Project::with(['machine',
        'machine.issues' => function ($query) {
                $query->where('created_at', '>=', 'project.created_at');
            }
        ])
        ->orderBy('id')
        ->get();

I am not getting the issues at all by using this query, when i switch the operator to: < then i get all the issues even the ones after project.created_at

Can you provide the laravel version you are running?

Riliwan Balogun
– Riliwan Balogun

2022-02-07 11:49:57 +00:00
Commented Feb 7, 2022 at 11:49 — Riliwan Balogun
– Riliwan Balogun, Commented Feb 7, 2022 at 11:49

Riliwan Balogun · Accepted Answer · 2022-02-08 09:17:14Z

1

You can have a pivot do most of the work for you. I tried reproducing your problem statement as below.

 <?php

 class Project extends Model
 {
    use HasFactory;

    public function machine()
    {
       return $this->hasOneThrough(Machine::class, MachineProject::class, 'machine_id', 'id', 'id', 'project_id');
    }

    public function issues()
    {
       return $this->hasManyThrough(Issue::class, Machine::class, 'id', 'machine_id')->whereDate('issues.created_at', '<=', $this->created_at);
    }
}


class Machine extends Model
{
    use HasFactory;

    public $with = ['issues'];

    public function projects()
    {
        return $this->belongsToMany(Project::class);
    }

    public function issues()
    {
        return $this->hasMany(Issue::class);
    }
}


class Issue extends Model
{
    use HasFactory;

    public function machine()
    {
        return $this->belongsTo(Machine::class);
    }
}


class MachineProject extends Pivot
{
    //
}

To retrieve the Project with issues, you just do

$allProjects = Project::with(['machine' => function ($machine) {
    $machine->with('issues');
}])->get();

edited Feb 8, 2022 at 9:17

answered Feb 7, 2022 at 12:56

Riliwan Balogun

3081 gold badge2 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lesley Peters Over a year ago

At the moment i can get the projects with all the machine issues, but i only need to get issues with created_at >= project->created_at

Riliwan Balogun Over a year ago

@LesleyPeters You can achieve this on the model easily. I updated the answer. Check the issues method on the Project model.

Collectives™ on Stack Overflow

Laravel eloquent query with multiple child relations

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related