Download the PHP package ensi/laravel-query-builder-helpers without Composer
On this page you can find all versions of the php package ensi/laravel-query-builder-helpers. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download ensi/laravel-query-builder-helpers
More information about ensi/laravel-query-builder-helpers
Files in ensi/laravel-query-builder-helpers
Package laravel-query-builder-helpers
Short Description This package contains extensions for laravel-query-builder
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package laravel-query-builder-helpers
laravel-query-builder-helpers
The laravel-query-builder-helper package is a set of classes that simplify the creation of available filters for the laravel-query-builder package from Spatie.
Installation
You can install the package via composer:
Version Compatibility
| Laravel query builder helpers | Laravel | PHP |
|---|---|---|
| ^0.1.0 | ^9.x | ^8.1 |
| ^0.1.4 | ^9.x || ^10.x | ^8.1 |
| ^0.1.7 | ^9.x || ^10.x || ^11.x | ^8.1 |
Basic Usage
Creating a filter
Filters are created by applying the static make method and then calling the chain of filter methods.
The following filter classes are currently available:
- StringFilter
- NumericFilter
- DateFilter
- PlugFilter (a stub for passing additional parameters to another filter)
- ExtraFilter (described in the section "Additional filters")
Each filter type has its own suffix, which is added to the name passed to the make method. For example, by default, the filter empty has the suffix _empty, and the filter gt is _gt:
As a result, we will get four filtering options available for search queries.
- rank
- rank_empty
- rank_gt
- rank_lt
Passing filters to the allowed Filters method
To transfer the received filters to the allowedFilters method of the Spatie package, the array will need to be destructured.
Additional filters
The ExtraFilter class is used by the aforementioned classes, but can also be used separately.
Useful methods include:
- nested (registers a set of nested filters)
- predefined (creates a predefined filter that includes complex filtering)
- and others
Configuration
In the file config.php you can customize the applied suffixes. You can also set up the like operator used in search queries there.
Contributing
Please see CONTRIBUTING for details.
Testing
- composer install
- composer test
By default, testing takes place using in-memory DataBase SQLite.
SQLite does not support some functions, for example: json_contains.
To test these functions, copy phpunit.xml.dist to phpunit.xml and specify the configuration with connection to another database in the php section.
When writing such tests, use the skip function to skip tests using the default connection.
Security Vulnerabilities
Please review our security policy on how to report security vulnerabilities.
License
The MIT License (MIT). Please see License File for more information.
All versions of laravel-query-builder-helpers with dependencies
laravel/framework Version ^9.0 || ^10.0 || ^11.0
spatie/laravel-query-builder Version ^5.0