This is the documentation for v2 but the latest version is v3 . You can switch versions in the menu on the left/at the top. Check your current version with the following command:
composer show lacodix/laravel-model-filter
Numeric Filter
On this page
Create the filter
php artisan make:filter TestNumericFilter -t numeric -f fieldname
this creates a filter class that extends NumericFilter
<?php
namespace App\Models\Filters;
use Lacodix\LaravelModelFilter\Filters\NumericFilter;
class TestNumericFilter extends NumericFilter
{
protected string $field = 'fieldname';
}
A fieldname must be set, this will apply a where query to the model-query where fieldname equals the given value.
Filter Modes
Default mode is EQUAL
Change filter mode:
<?php
namespace App\Models\Filters;
use Lacodix\LaravelModelFilter\Enums\FilterMode;
use Lacodix\LaravelModelFilter\Filters\NumericFilter;
class TestNumericFilter extends NumericFilter
{
public FilterMode $mode = FilterMode::LOWER;
protected string $field = 'fieldname';
}
Allowed modes are
- FilterMode::LOWER
- FilterMode::GREATER
- FilterMode::LOWER_OR_EQUAL
- FilterMode::GREATER_OR_EQUAL
- FilterMode::EQUAL (default)
- FilterMode::BETWEEN
- FilterMode::BETWEEN_EXCLUSIVE
- FilterMode::NOT_BETWEEN
- FilterMode::NOT_BETWEEN_INCLUSIVE
Modes with two values
For using between and not between filters you have to provide two values to the filter. You can omit one of the values, if it shall not be applied. You can offer a between filter and only fill in the first or second value to get behaviour like a lower or greater filter.
For providing multiple values use the following query parameters
# For FilterMode::BETWEEN
# finds all between 100 and 1000
https://.../posts?test_numeric_filter[]=100&test_date_filter[]=1000
https://.../posts?test_numeric_filter[0]=100&test_date_filter[1]=1000
# finds all greater or equal than 100
https://.../posts?test_date_filter[0]=100&test_date_filter[1]=
# finds all smaller or equal than 1000
https://.../posts?test_date_filter[0]=&test_date_filter[1]=1000
or programmatically
Post::filter(['test_numeric_filter' => [100, 1000]])->get();
Post::filter(['test_numeric_filter' => ['', 1000]])->get();
FilterMode::BETWEEN will include both values, FilterMode::BETWEEN_EXCLUSIVE will exclude both values.
FilterMode::NOT_BETWEEN will also exclude posts, that have one of the both values in the selected field,
FilterMode::NOT_BETWEEN_INCLUSIVE will include posts that have these values.