[RFC] Goals

[attilabukor]

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!

[BallisticPain]

Just throwing it out here where you mentioned the HTML5/JS charts above, this is the best package I have found: http://d3js.org/

[dizda]

This will support MongoDB ODM ?

[attilabukor]

@BallisticPain thanks

@dizda I'm planning to support it too, but first I want to create some basic functionality with ORM and then add support for ODM too.

[dizda]

Ok i see :), maybe i'll can help you if u want.

[attilabukor]

@dizda that would be great :) watch the repo and you'll notice when we decide it's time to start implementing ODM :)

[dizda]

Ok, great ;)

[inspiran]

Some attention points:

• Typically you want to have some export functionality, say .csv, excel, whatever
• How are you going to deal with large result sets? eg. "download all products". I've once implemented it as a background job which mailed the user the result set.
• I like how the latest SAP CRM software deals with dynamic search criteria. Using a + button the user can enter values for predefined search criteria. Check http://www.sapdesignguild.org/editions/edition10/crm_images/03_Advanced_Search.gif