README

A dynamic report generator package for Laravel with a drag-and-drop interface. This package allows users to generate SQL queries by dragging and dropping tables and columns, and then displays the results.

Drag-and-drop interface

Saved Reports

Display query results

Features

Drag-and-drop interface for selecting tables and columns
Join multiple tables using foreign key relationships
Generate SQL queries dynamically
Display query results in a table format

Installation

To install the package, follow these steps:

Add the package to your Laravel project using Composer:

composer require iidestiny/laravel-dynamic-report-generator

If not automatically registered, add the service provider to config/app.php:

'providers' => [
    // ...
    DevForest\\ReportGeneratorServiceProvider::class,
];

Publish the package assets:

php artisan vendor:publish --provider="DevForest\ReportGeneratorServiceProvider"

Migrations:
```
php artisan migrate
```

Usage

After installing and setting up the package, you can access the report generator interface at:

http://your-app-url/report-generator

From here, you can:

Select tables from the list
Drag columns to the selected columns area
Configure table joins and conditions
Generate and view the SQL query results

Contributing

Contributions are welcome! Please feel free to submit a pull request or open an issue on GitHub.

License

This package is open-source software licensed under the MIT license.

iidestiny / laravel-dynamic-report-generator

Maintainers

Details