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 for selecting tables and columns
- Join multiple tables using foreign key relationships
- Generate SQL queries dynamically
- Display query results in a table format
To install the package, follow these steps:
- Add the package to your Laravel project using Composer:
composer require devforest/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
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
Contributions are welcome! Please feel free to submit a pull request or open an issue on GitHub.
This package is open-source software licensed under the MIT license.