Download the PHP package rudi97277/export-db without Composer
On this page you can find all versions of the php package rudi97277/export-db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download rudi97277/export-db
More information about rudi97277/export-db
Files in rudi97277/export-db
Download rudi97277/export-db
More information about rudi97277/export-db
Files in rudi97277/export-db
Vendor rudi97277
Package export-db
Short Description Export report as collection using query or function from database
License MIT
Package export-db
Short Description Export report as collection using query or function from database
License MIT
Please rate this library. Is it a good library?
Informations about the package export-db
How to Use This Package
-
Run the Migration
- Execute the migration to create the necessary database structure.
-
Table Creation
- A new table named
export_configs
will be generated.
- A new table named
-
Insert Data
- Insert new data into the
export_configs
table to create a new report.
- Insert new data into the
-
Create a New Route
- Define a new route that creates an instance of the
Rudi9277/ExportDb/GenerateReport
class and calls thegenerate
function. Pass therequest
as a parameter.
Example route definition:
- Define a new route that creates an instance of the
-
Run Symlink
- If you never run a symlink command before, please run it
php artisan storage:link
- If you never run a symlink command before, please run it
Note:
- Available
export_type
arexlsx
andcsv
. - You can create a new module in the database.
Table columns:
- module: The name of the module that will be exported.
- title: The title of the sheet in the Excel that will be generated.
- query: The query that will be used to generate the Excel.
-
formatter: JSON object that will help format the data the way you want.
Example:
Note:
- The
"name"
key is the header in the Excel that will be generated. {product_name}
is the column name in the SQL query result.
- The
-
validator: JSON object that will help to validate the required data for the query. The validator is from Laravel Validator.
Example:
-
default: A default JSON object that sets what the default value of the validator in No. 5 is.
Example:
All versions of export-db with dependencies
PHP Build Version
Package Version
Requires
maatwebsite/excel Version
^3.1
illuminate/database Version ^10.48
illuminate/http Version ^10.48
illuminate/database Version ^10.48
illuminate/http Version ^10.48
The package rudi97277/export-db contains the following files
Loading the files please wait ....