Download the PHP package coliving/eloquent-filter without Composer

Eloquent Filter

Eloquent Filter adds custom filters to your Eloquent Models in Laravel. It's easy to use and fully dynamic.

Table of Content

• Introduction
• Installation
• Basic Usage
  • Config Model
  • Use in Controller
  • Simple Examples
  • Custom Query Filter
  • Custom Detection Condition
• Configuring
  • Publish Config
  • Config
• Magic Methods
  • Request Filter
  • Response Filter

Requirements

• PHP 7.2+, 8.0, 8.1 (new version)
• Laravel 5.8+,6.x,7.x,8.x,9.x(prefer-stable)

:microphone: Introduction

Let's say we want to make an advanced search page with multiple filter option params.

A simple implementation without Eloquent Filter

The Request URI could look like this:

http://localhost:8000/users/index?age_more_than=25&gender=male&created_at=25-09-2019

And a simple implementation in the Controller would look like this:

This solution is simple ,but that works fine. But you'd have to add a condition for each filter you need. Especially with more complex filtering, your code can become a Monster very fast! :boom:

A simple implementation with Eloquent Filter

Eloquent Filter can help you to fix that problem. Just you will set query string to work with that. It will save you time and minimize the complexity of your code.

After installing Eloquent Filter the request URI could look like this:

http://localhost:8000/users/list?age_more_than[operator]=>&age[value]=35&gender=male&created_at[operator]==>&created_at[value]=25-09-2019

And in the controller you'd just need that one line:

With this Eloquent filter implementation, you can use all the documented filters!

:electric_plug: Installation

1- Run this Composer command to install the latest version

  $ composer require coliving/eloquent-filter

• Note for Laravel versions older than 5.8 you should install version 2.2.5

  $ composer require mehdi-fathi/eloquent-filter:2.2.5

2- Add eloquentFilter\ServiceProvider::class to provider app.php

3- Add Facade 'EloquentFilter' => eloquentFilter\Facade\EloquentFilter::class to aliases app.php

That's it enjoy! :boom:

:book: Basic Usage

Config Model and set whitelist

Add The Filterable trait to your models and set fields that you will want to filter in the whitelist array. as well You can override this method in your models.

You can set * char for that filter in all fields aslike below example:

You can add or set $whiteListFilter on the fly in your method.For example:

Set array to WhiteListFilter

• Note This method override $whiteListFilter array

Add new field to WhiteListFilter

Use in Controller

Change your code the controller of the laravel project as like below example:

-Note The Eloquent Filter config by default uses the query string to make queries in Laravel. Although, you can set the array to the filter method Model for making your own custom condition without query string.

-Note Therefore you must unset yourself param as perpage. Just you can set page param for paginate this param ignore from the filter.

• You can ignore some of the request params by use of the bellow code.

Call ignoreRequest that will ignore some requests that you don't want to use in conditions eloquent filter. For example, the perpage param will never be in the conditions eloquent filter. it's related to the paginate method. page param ignore by default in Eloquent Filter of Laravel.

• You can filter some of the request params for using in Eloquent Filter.

Call AcceptRequest will accept requests which you want to use in conditions Eloquent Filter. For example username and id param will be in the conditions eloquent filter. Just notice you must set $whiteListFilter in Model. This method is useful for query string manipulation by a user.

• Another example use of a filter eloquent filter.

• EloquentFilter::filterRequests() get all params that used by the Eloquent Filter. You can set key to get specific index. For example EloquentFilter::filterRequests('username') it's getting username index.

• EloquentFilter::getAcceptedRequest() get all params that set by the AcceptRequest method.

• EloquentFilter::getIgnoredRequest() get all ignored params that set by the getIgnoreRequest method.

Simple Examples

You just pass data blade form to query string or generate query string in the Controller method. For example:

Simple Where

Where In

This example make method whereIn.

OrWhere (New feature :fire:)

This example make method orWhere.

Where like

If you are going to make a query by like conditions. You can do that by this example.

Where by operator

You can set any operator mysql in the queries string.

Where the nested relation Model (New feature :fire:)

You can set all nested relation in the query string just by the array of query string. For example, The user model has a relation with posts. And posts table has a relation with orders table. You can make query conditions by set 'posts[count_post]' and 'posts[orders][name]' in the query string. Just be careful you must set 'posts.count_post' and 'posts.orders.name' in the User model.

• The above example is the same code that you use without the eloquent filter. Check it under code.

Where array the nested relation Model

You can pass array to make whereIn condition.

Special Params

You can set special params limit and orderBy in the query string to make a query by that.

Where between

If you are going to make a query based on date, You must fill keys, start, and end in the query string. Hence You can set it as a query string. These params are used for the filter by date.

Advanced Where

Therefore fields of query string are same rows table database in $whiteListFilter in your model or declare the method in your model as override method. The overridden method can be considered a custom query filter.

Custom Query Filter

Eloquent Filter doesn't support all of the conditions by default. For this situation, you can make an overridden method. If you are going to make yourself a query filter, you can do it easily.

You should run the command to make a trait and use it on the model:

php artisan eloquentFilter:filter users

-Note These fields of query string are the same methods of the trait. Use trait in your model:

Custom Detection Condition

Sometimes you want to make your custom condition to make a new query that Eloquent Filter doesn't support that by default. The good news is you can make a custom condition in the eloquent filter from now on.

You can make conditions to generate a new query after checking by that. (New feature :fire: ). For example :

We must have two classes. The First detects conditions second class generates the query.

• Step 1: Create a class to detect some of the conditions

• Step 2: After that create a class to generate a query. In this example we make WhereRelationLikeConditionQuery class:

• Step 3: You make the method EloquentFilterCustomDetection for return array detections of the condition in the model.

• Each of the query params is used to detect in WhereRelationLikeCondition for the first time after that check by default detection eloquent filter.

Make method EloquentFilterCustomDetection in the above example and return array conditions class.

You just run code User::filter(); for see result.

-Note Also you can set custom detection on the fly by use of the method SetCustomDetection. For example :

-Note You can disable EloquentFilterCustomDetection on the fly by this code :

-Note You can set many detection conditions. for example:

• EloquentFilter::getInjectedDetections() gets all of your customs injected detection.

-Note Every custom detection will run before any detections by default eloquent filter.

Configuring

You can generate a config file to configure Eloquent Filter.

Publish Config

php artisan vendor:publish --provider="eloquentFilter\ServiceProvider"

Config

• You can disable/enable Eloquent Filter in the config file (eloquentFilter.php).

  'enabled' => env('EloquentFilter_ENABLED', true),

• Eloquent Filter recognizes every param of the queries string. Maybe you have a query string that you don't want to recognize by Eloquent Filter. You can use ignoreRequest for his purpose. But we have a clean solution to this problem. You can set param request_filter_key in the config file. Therefore every query string will recognize by the request_filter_key param.

  'request_filter_key' => '', // filter

For example, if you set 'request_filter_key' => 'filter', that Eloquent Filter recognizes filter query string.

/users/list?filter[email][email protected]

• You can disable/enable all of the custom detection of Eloquent Filter in the config file (eloquentFilter.php).

  'enabled_custom_detection' => env('EloquentFilter_Custom_Detection_ENABLED', true),

• You should set the index array in ignore_request to ignore by in all filters.

  'ignore_request' => [] //[ 'show_query','new_trend' ],

Magic Methods

Magic methods are a collection of methods that you can use as a wrapper in the Eloquent Filter. For example, serialize data before filtering or changing data in response and others. Now Eloquent Filter have serializeRequestFilter,ResponseFilter.

Request Filter

Eloquent Filter has a magic method for just change requests injected before handling by eloquent filter. This method is SerializeRequestFilter. You just implement SerializeRequestFilter method in your Model. For example

As above code, you can modify every query params of the Model in the method serializeRequestFilter before running by Eloquent Filter. That is a practical method when you want to set user_id or convert date or remove space and others.

Response Filter

Response Filter is a magic method for just changing response after handling by Eloquent Filter. The method called ResponseFilter You should implement the method ResponseFilter in your Model. For example

• If you have any idea about the Eloquent Filter, I will be glad to hear that.