Download the PHP package msantang/query-filters without Composer
On this page you can find all versions of the php package msantang/query-filters. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package query-filters
Laravel Eloquent/Query Filter
Filter Eloquent models in a simple and clean way.
You can filter model with url call´s like this
Just with
Features
- Input values validation
- Support multiple filters by fields
- Filter remote fields through relations
- Custom filter types through classes or closures
Install
Require with composer
Add service provider to config/app.php (If you want to use creator command)
Usage
Create Filter and InputFilter
By default this will create two files
App/QueryFilters/UserFilter.php:
and App/QueryFilters/UserFilterInput.php:
Add Filterable to your model
By default the model will look for App\QueryFilters{Model}Filter and App\QueryFilters{Model}FilterInput if you want to override this, just publish the package config and change namespace in queryfilter.php config file Or set the protected $filter_class and $filter_input_class propierties;
Use filter scope
Changing the operation for a field filter
If you have a filter like:
then you can change the operation dinamicaly like this:
sending a request parameter with name {mapping_name}_opt = operation
Using constructors
Filter Types
Numeric
Name | Operation | Accept |
---|---|---|
numeric:eq | Equal | numeric,array |
numeric:neq | Not Eequal | numeric,array |
numeric:gt | Grater | numeric |
numeric:lt | Less | numeric |
numeric:gte | Grater or Eq | numeric |
numeric:lte | Less or Eq | numeric |
String
Name | Operation | Accept |
---|---|---|
string:eq | Equal | string |
string:begin | Begin with | string |
string:end | End with | string |
string:contains | End with | string |
string:words | Search every word (space separated) | string |
Date
Name | Operation | Accept |
---|---|---|
date:eq | Equal | date |
date:neq | Not Eequal | date |
date:from | Grater or Eq | date |
date:to | Less or Eq | date |
date:after | Grater than | date |
date:before | Less than | date |
Datetime
Name | Operation | Accept |
---|---|---|
datetime:eq | Equal | datetime |
datetime:neq | Not Eequal | datetime |
datetime:from | Grater or Eq | datetime |
datetime:to | Less or Eq | datetime |
datetime:after | Grater than | datetime |
datetime:before | Less than | datetime |
Creating custom fields filters
Despite the build in field filters, you can add your own filters.
Closures
Classes
License
This project is licensed under the MIT License - see the LICENSE file for details
All versions of query-filters with dependencies
illuminate/support Version ~5.1
illuminate/console Version ~5.1
illuminate/validation Version ~5.1
illuminate/database Version ~5.1