Add a filter function on laravel query builder

Question

I am getting some data from a model like:

public function getExternalCodes()
{
    return ExternalService::get()->pluck('add_id')->toArray();
}

Now before this I want to apply a function to filter the data by date:

public function getExternalCodes()
{
    $query =  ExternalService::get()->pluck('add_id')->toArray();

    return $query->filterByDate($query, new ExternalServce);
}

My filter by date function

private function filterByDate(Builder $query, Model $model)
    {

        if (!request()->has('interval')) {

            return $query;
        }

        $period = json_decode(request()->get('interval'));

        if ($period->from) {

            $query->where("{$model->getTable()}.created_at", ">=", Carbon::parse($period->from)->startOfDay());
        }

        if ($period->to) {

            $query->where("{$model->getTable()}.created_at", "<=", Carbon::parse($period->to)->endOfDay());
        }

        return $query;
    }

However I can not do it right now since I am calling get() before applying the filter. Any idea how to go about it ?

And yes dont add a question to filter with where since I can not do that

Alexey Mezenin · Accepted Answer · 2018-02-08 10:45:48Z

3

Since you're using Eloquent models, use a local scope for that:

private function scopeFilterByDate($query)
{
    ....
}

Then use the scope with:

public function getExternalCodes()
{
    return ExternalService::filterByDate()->pluck('add_id')->toArray();
}

answered Feb 8, 2018 at 10:45

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

6 Comments

PrStandup Over a year ago

the issue with that is that this filter is on repositories and its being used with 10 different other models. So I cant do that

Alexey Mezenin Over a year ago

@PrStandup put it into a trait or create a base model class.

PrStandup Over a year ago

hmm do you think is okay to place it on base eloquent model ?

Alexey Mezenin Over a year ago

@PrStandup I mean create some kind of base model class which extends Model. I would use trait.

Alexey Mezenin Over a year ago

@PrStandup yes it does.

|

Collectives™ on Stack Overflow

Add a filter function on laravel query builder

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related