Download the PHP package always-open/report-engine without Composer
On this page you can find all versions of the php package always-open/report-engine. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download always-open/report-engine
More information about always-open/report-engine
Files in always-open/report-engine
Package report-engine
Short Description General reporting engine for Laravel
License MIT
Homepage https://github.com/always-open/report-engine
Informations about the package report-engine
General reporting engine for Laravel
General reporting engine for Laravel
Installation
You can install the package via composer:
Usage
Create a report
Create a report that extends the ReportBase. Within this class you will define the query to fetch the data as well as the columns which will be output.
Create a controller
Create a controller to output the report
Create a route
When creating a route ensure you include multiformat
as this will handle things like .sql
and .json
endpoint calls.
Routes
Multiformat adds handling multiple formats to the url which can give the following output building upon the above examples.
This will output an HTML page that will contain a tabulator table and make ajax requests to get the data needed.
This will output a JSON payload of the data
This will output the entire SQL query, useful for debugging
This will return the output of the explain command for the query, useful for debugging
Filters
Here are the possible filters for the default types. To build a filter follow this format:
DateTime
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
Decimal
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
Dollar
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
Enum
- equals
Html
- contains
- does_not_contain
Integer
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
NullableDecimal
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- is_empty
- is_not_empty
- less_than
- less_than_or_equal
NullableInteger
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- is_empty
- is_not_empty
- less_than
- less_than_or_equal
Number
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
NumericHtml
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
Percentage
- does_not_equal
- equals
- greater_than
- greater_than_or_equal
- less_than
- less_than_or_equal
Text
- contains
- does_not_contain
- does_not_equal
- equals
Url
- contains
- does_not_contain
YesNo
- is_true
- is_false
YesNoShort
- is_true
- is_false
Testing
Changelog
Please see CHANGELOG for more information on what has changed recently.
Contributing
Please see CONTRIBUTING for details.
Security Vulnerabilities
Please review our security policy on how to report security vulnerabilities.
Credits
- AlwaysOpen
- All Contributors
License
The MIT License (MIT). Please see License File for more information.
All versions of report-engine with dependencies
spatie/laravel-package-tools Version ^1.4.3
illuminate/contracts Version ^9.0
always-open/sidekick Version ^4.0
brick/money Version ^0.5.0
laravelcollective/html Version ^6.2