[RFC] Goals #1
Description
The administrators of some sites obviously need some reports of the sales, visits and many other things. Now every developer whose customers need such features has to code these reports from scratch. This bundle's main goal is to provide the developers an easy way to create these reports.
- Developers should be able to write predefined queries, letting the users (site admins) select some values (like "from" and "to" dates, "manufacturer" and "model" on a notebook-webshop).
- Developers should be able to let the users type their own DQL or SQL queries if they are familiar with one of them to make their own query (both needs to be validated so no inserts, drops, deletes or updates could be submitted through that input box, only selects).
- There should be generic Twig templates which would be capable of rendering tables or charts (maybe HTML5/JS with some cool features?) for all sorts of data sets.
- There should be a simple query builder interface with which the users could create their own queries without being nerds.
- Developers should be able to restrict some entities in configuration which would be invisible for the users (and restrict them in query input box and query builder too).
- It should work together with SonataAdminBundle, so the main dashboard should be integrated to the Sonata dashboard.
Please comment if you like the idea, what else should be added or what should be done somehow else!