Download the PHP package freebuu/laravel-filterable without Composer

Laravel Filterable

Simple filter and paginate index data. Main idea - KISS.

Example query:

In code this query reflects:

• search_description=some%20text - $builder->where('description', 'like', '%some%text%')
• sort_id=desc - $builder->sortBy('id', 'desc')
• where_publisher_id=1,23 - $builder->whereIn('publisher_id', [1,23])
• where_has_groups__id=30,40 - $builder->whereHas('groups', fn($builder) => $builder->whereIn('id', [30,40]))
• limit=10 - $builder->limit(10)
• offset=20 - $builder->offset(20)

Installation

Requires laravel >= 9 and php ^8.1

Basic usage (pagination only)

Add HasRequestFilter trait to Model - that's all.

Example result for query /api/posts/?limit=25&offset=10

• meta - object with pagination data
• data - array with model data, wrapped in PostResource

  Filtration

  For filtration, you need to create a filter class for each model. Filter class must extend AbstractFilter. Best place for these classes is App\Http\Filters.

In method getFilterableFields() you specify which fields can be filtered in each filter case.

HINT - always add default state because filter cases may be supplemented.

To set this filter for Model - add property requestFilter

Filter case

Filterable query params contains four parts separated with _. Let's see example with where_has_groups__id=30,40

• $case - where_has
• $field - groups
• $fieldValue - id (optional, mandatory only with where_has)
• $value - 30,40

In code, they are presented as FilterCaseEnum.php and they work like this

• FROM
  • Accepts only int
  • $builder->where($field, '>=', $value)
• TO
  • Accepts only int
  • $builder->where($field, '<=', $value)-
• SORT - sorting
  • Accepts only asc, desc
  • $builder->sortBy($field, $value)
• SEARCH - search with like operator
  • Accept string with spaces. Add % at start, end and instead of all spaces
  • $builder->where($field', 'like', $value)
• START_WITH - all strings starts with passed value
  • Accept string without spaces. Add % at end of value
  • $builder->where($field', 'like', $value)
• WHERE_HAS - filter by relation with array of values
  • Accept comma separated array of values.
  • For this filter fieldValue fields must be set (see in example in PostFilter)
  • $builder->whereHas($field, fn($builder) => $builder->whereIn($fieldValue, $value))
• WHERE - filter by array of values
  • Accept comma separated array of values.
  • $builder->whereIn($fieldValue, $value)
• FILTER - uses for custom filters, see below

Custom filters

In filter class you can make custom filter by creating a method like filterCustom - it must begin with filter. Then yoy can use it in query like ?filter_custom=123

HINT - you can use fieldValue here like ?filter_custom__alias=123 - it pass as third parameter in filter method.

Advanced usage

Limit

For security reasons, the limit field is set to a maximum value. If the request specifies a value greater, it will be reset to the default value.

• Default it set to 30
• You can override this value in Filter class - overwrite the maxLimit property.
• Or you can override it system-wide in AppServiceProvider

Query callbacks

Sometimes you need to set up query condition situational—e.g. filter only for auth user

Or just use Builder mixin: