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:

1. Add the package to your Laravel project using Composer:

   composer require devforest/laravel-dynamic-report-generator

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

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

3. Publish the package assets:

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

4. 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.