How to pass condition in laravel 5 relation model

Question

I am trying to get the data from group model but i am relate the student table new_group_id to group table id if it not null else connect the group_id to group table id.

public function grade(Builder $query)
{
    return $query
        ->when($this->new_group_id != 0, function ($q) {
            return $q->with('new_group_id');
        })
        ->when($this->new_group_id === 0, function ($q) {
            return $q->with('group_id');
        });
}

But given the error is

Argument 1 passed to App\Students::grade() must be an instance of App\Builder

please help me to solve these error

The error is from the call of the method `grade()` not the method itself. — N69S, Aug 19 '21 at 09:23
You have two relations named `newGroupId()` and `groupId()` in your model ? — N69S, Aug 19 '21 at 09:23
doing like these return $this->hasone('App\Groups','id','group_id'); else return $this->hasone('App\Groups','id','new_group_id'); — Maitrik Thakkar, Aug 19 '21 at 09:28
Read these two documentation on relation and eager loading https://laravel.com/docs/8.x/eloquent-relationships#eager-loading -- https://laravel.com/docs/8.x/eloquent-relationships#one-to-many — N69S, Aug 19 '21 at 10:15

score 0 · Answer 1 · answered Aug 19 '21 at 09:31

0

It looks as though you're using a query scope which Laravel will resolve and inject an instance of Builder into your function via the service container.

For this to happen though you need to follow the Laravel convention of prefixing your local scope with the word scope:

public function scopeGrade($query)
{
    return $query
      ->when($this->new_group_id != 0,function($q){
          return $q->with('new_group_id');
      })
      ->when($this->new_group_id === 0,function($q){
          return $q->with('group_id');
      });
}

answered Aug 19 '21 at 09:31

Peppermintology

9,343
3
27
51

given error Call to undefined method Illuminate\Database\Query\Builder::addEagerConstraints(). – Maitrik Thakkar Aug 19 '21 at 09:34
how to match this with group table id?? – Maitrik Thakkar Aug 19 '21 at 09:35
@MaitrikThakkar You'll want to use a `where` clause rather than a `with`. – Peppermintology Aug 19 '21 at 09:39

How to pass condition in laravel 5 relation model

1 Answers1