Skip to content

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.

License

Notifications You must be signed in to change notification settings

md-sazzadul-islam/laravel-dynamic-report-generator

Repository files navigation

Laravel Dynamic Report Generator

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

Drag-and-drop interface

Saved Reports

Saved Reports

Display query results

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.

About

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.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published