Laravel scope method error when call on variable

Question

I have a method scoup scopeCalculateMaxPositionSelectedCategory in my Model Category

class Category extends Model
{
    use HasFactory;

    protected $fillable = [
        'parent_id',
        'name',
        'slug',
        'description',
        'position',
        'quantity_available_offers',
    ];

    public function scopeCalculateMaxPositionSelectedCategory($query, $cat_id = null) {
        return $query->where('parent_id', $cat_id)->max('position');
    }
}

When i call like that it's work fine:

 Category::CalculateMaxPositionSelectedCategory();

But i want do this that way:

$this->categories->CalculateMaxPositionSelectedCategory();

After this are error: "BadMethodCallException Method Illuminate\Database\Eloquent\Collection::CalculateMaxPositionSelectedCategory does not exist. "

Show me why I want to do that, because i want to use this in component Livewire:

    public $selCategory = '';
    public $categories;
    public $selPosition;

    public function render()
    {
        $this->categories = Category::all();
        $this->selPosition = $this->categories->CalculateMaxPositionSelectedCategory() + 1;

        return view('livewire.form-stor-category');
    }

It supposes the error is due to all () calling get (). But I have no idea how to solve it.

if all() is an issue, you can always use query()

Tipu Sultan Eiko
– Tipu Sultan Eiko

2022-01-10 02:34:25 +00:00
Commented Jan 10, 2022 at 2:34 — Tipu Sultan Eiko
– Tipu Sultan Eiko, Commented Jan 10, 2022 at 2:34

Eden Dowling-Mitchell · Accepted Answer · 2022-01-10 02:29:08Z

2

$this->categories->CalculateMaxPositionSelectedCategory();

^ This line gets the categories as a collection, and then you can't call a query scope on a collection.

Try this:

$this->categories()->CalculateMaxPositionSelectedCategory()->get();

The () after categories will continue building the query but won't run it yet. When you call $this->categories without the () it runs the query straight away and your opportunity to use the scope is gone.

answered Jan 10, 2022 at 2:29

Eden Dowling-Mitchell

2711 silver badge5 bronze badges

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

1 Comment

Łukasz Okaj Over a year ago

When i use $this->categories()->CalculateMaxPositionSelectedCategory()->get(); get error Method App\Http\Livewire\FormStorCategory::categories does not exist. it's a little closer but still doesn't work

Collectives™ on Stack Overflow

Laravel scope method error when call on variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related