Advanced Reports

[ilerna]

Is there any module to configure advanced reports via queries?

 

I like the SQL Manager, but I need to use conditional queries (that are not allowed).

 

And is there any module or other way to configure the data charts displayed in the dashboard?

 

Thanks in advantage

[Eolia]

phpmyadmin is a better way^^

Create a module, and use 150 lines of code + requests for 1 request it's really useless...

[ilerna]

Thanks for the answer Eolia,

 

For a webmaster is ok to use the phpmyadmin, but Prestashop SQL Manager is a good tool for employees who doesn't know SQL.

I want to create some queries so employees can view those reports, but I find it limited because I can't use IF statements, or generate reports from an input.

 

The AdminStats controller looks a good way to do it, is it possible to add custom reports there?

 

Thank you

[Eolia]

You can install php-report for your employees : https://github.com/jdorn/php-reports

just prepare and save your requests, and then, employees will be able to use it in few clicks^^