Dynamic Reports Generation in laravel

Question

I'm trying to develop a custom reports generation for my application, in which the user will dynamically input the model and its related model.And will select the related columns for which the report is needed and will have conditional statements for 'AND' and 'OR' conditions.

The same functionality is done is vtiger ,Zoho CRM and sales force .

My doubt is which is the efficient way of doing it.

1.Either by creating tables for each modules and defining its column in database 2.Or by providing a config file for all the set up 3.Or by creating a model class for all reports and defining its related model attributes and binding data using getter and setter(accessors and mutators). 4.Or suggest me any other preferrable method or any packages with have minimal functionalities relating this

I know is complex but please suggest me few hints from your point of view.

Please find the below for the flow.

Ninepins

I would also be very interested in this. I have looked to see if their are packages for this and their are not. – Harter

Answer 1

you can use a Querybuilder to generate queries by users themselves. then use something similar to JSReport to allow users to design reports. There are very good web report designers out there, but most of them are for a price. if you still wanna make your own, refer these; Seal reports JSReports for reference what you looking for is real ;-)

use JQueryQueryBuilder and customize according to your need. use Laravel Boilerplate or something to start-off with. use Handlebars.js / Mustache.js or Blade as the template engine. be creative...

cheers!!!

Disjunctive

Answer 2

For similar requirement, I have come across Reportico

Though I have not started implementing it yet, but it seems really nice.

They have Laravel module as well, supporting Laravel 5.1

Seems the team keeps the thing updated.

Although their UI is not good, they have got report builder as well.

Their Github link: https://github.com/reportico-web/

Taddeo

Answer 3

Although not a complete solution, I think this can help you on your way to creating your own:

1. You can get all your tables from your DB dynamically:

   DB::select('SHOW TABLES');

2. You can get column names for tables as well:

   Schema::getColumnListing('users');

3. Try an find a way to get related tables to the one the users selects.

4. get intended query from user form. ( with conditions and value )

5. profit.

Zingg

Answer 4

If you're looking to dynamically generate reports in Laravel with an intuitive drag-and-drop interface for selecting table columns and joining multiple tables, you might want to check out the package I recently developed: Laravel Dynamic Report Generator

This package provides a user-friendly interface that allows you to:

• Drag and drop table columns
• Join multiple tables
• Generate dynamic SQL queries
• View and paginate query results

Toothy