Geek Answers Handbook

Dynamic reporting in laravel

I am trying to develop my own generation of reports for my application, in which the user will dynamically enter the model and its associated model. And it will select the appropriate columns for which a report is required, and will have conditional statements for 'AND' and 'OR'.

The same functions are performed as vtiger, Zoho CRM and sales force.

My doubt is an effective way to do this.

1. Or by creating tables for each module and defining its column in the 2.Or database, providing a configuration file for all configured 3.Or, creating a model class for all reports and defining the model attributes associated with it and linking the data using the getter and setter (accessors and mutators). 4. Offer me any other preferred method or any packages with minimal functionality related to this.

I know this is difficult, but please offer me some tips from your point of view.

Please find below for flow. enter image description here enter image description here

+8
php laravel reporting-services report crm
source share
3 answers

You can use Querybuilder to generate queries by users themselves. then use something similar to JSReport to allow users to create reports. There are very good web report designers, but most of them are priced. if you still want to make your own, contact them; JSReports seal reports for reference what you are looking for -)

use jQueryQueryBuilder and customize according to your needs. use the Laravel Boilerplate or something to get you started. use Handlebars.js / Mustache.js or Blade as a template engine. be creative ...

Hooray!!!

+4
source share

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

  • You can get all your tables from your database dynamically:

    DB::select('SHOW TABLES');

  • You can also get column names for tables:

    Schema::getColumnListing('users');

  • Try to find a way to link related tables to the ones that users select.

  • Get the requested request from the user form. (with terms and meaning)

  • profit.

0
source share

For similar requirements, I came across Reportico

Although I have not started to implement it yet, but it seems really nice.

They also have a Laravel module supporting Laravel 5.1.

It seems that the command is saving the update.

Although their user interface is not very good, they also have a report builder.

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

0
source share

More articles:


All Articles