How to implement a complex filter on the selection of goods from the database in Laravel?

Question

Laravel

While doing this:
Count the number of products that satisfy the filter:
$kol = \App\Good::select('id', 'name')->where(function ($query) {
if (...) {
$query-> where('id','>',0);
}
...
many conditions
...
})->count();
Get the product page by filter:
$sel = \App\Good::select('id', 'name')->where(function ($query) {
if (...) {
$query->where('id ','>',0);
}
...
many conditions
...
})->skip(($pg-1)*$max)->take($max)->get();
Is it possible to make a condition for the filter 1 time and then substitute it in the selection?
How to implement it?

Answer 1

For example, you can take a function into a variable.

$filter = function(query) {
    // ...
};

Good::select('id', 'name')->where($filter)->count();

Answer 2

Use scope:

public function scopeFilter($query) 
{
    if (...) {
        $query->where('id','>',0);
    }
    ...
    много условий
    ...
    })->skip(($pg-1)*$max)->take($max)
    return $query;
}

https://laravel.com/docs/5.6/eloquent#local-scopes

Answer 3

Can you do it like this

$good_query = Good::query();

if (...) {
    $good_query->where('id', '>', 0);
}

$result = $good_query->skip(($pg-1)*$max)->take($max)->get();

Answer 4

$kolQuery = \App\Good::select('id', 'name')->where(function ($query) {
if (...) {
$query->where('id','>', 0);
}
...
many conditions
...
});
$kol = $kolQuery->count();
$sel = $kolQuery->skip(($pg-1)*$max)->take($max)->get();