Model::all() but return Eloquent Builder instead of Collection

Is there an equivalent of the all() scope that returns an instance of Eloquent Builder instead of Collection. I need to chain some queries together and end with pagination, like this:

$users = User::where('id','!=', 0); // not very beautiful

if($filterA){
    $users = $users->whereHas('thing');
}

if($filterB){
    $users = $users->where('other_thing', 'some_value');
}

$users->paginate(5);

I used a hacky solution to return an instance of Eloquent Builder that contains all the models. If I went with $users->User::all() the whereHas() and paginate() would fail.

Is there a more Laravel to achieve what I'm doing?

vipin93

9 years ago

Level 13

u can use

get() instead of all()

and here is union method

https://laravel.com/docs/5.4/queries#unions

ricardoarg

9 years ago

Level 8

you should do something like:

$users = User::where('id','!=', 0)
            ->when($filterA, function($query) {
                $query->whereHas('thing');
            })
            ->when($filterB, function($query) {
                $query->where('other_thing', 'some_value');
            })
            ->paginate(5);

SpuriouslyAwake

9 years ago

Level 1

@vipin93 Unfortunately using get() blocks me from chaining ->paginate().

@ricardoarg Thanks for this, I'll try to refactor my code to use the when() function

vipin93

9 years ago

Level 13

yes for paginate you can not use get() because it will give all record