abrahamgarcia27 Posted November 5, 2014 Share Posted November 5, 2014 Have you guys ever build a smart queries for users too generate reports basically on anything they may want. I am looking on making something very user friendly. I do not have any ideas where to start Quote Link to comment https://forums.phpfreaks.com/topic/292277-query-builder-reports/ Share on other sites More sharing options...
Barand Posted November 5, 2014 Share Posted November 5, 2014 Yes but, unfortunately, mine wasn't as ambitious as yours basically on anything they may want I restricted them to items in the database Quote Link to comment https://forums.phpfreaks.com/topic/292277-query-builder-reports/#findComment-1495758 Share on other sites More sharing options...
abrahamgarcia27 Posted November 19, 2014 Author Share Posted November 19, 2014 Do you have a working example of what you made? Quote Link to comment https://forums.phpfreaks.com/topic/292277-query-builder-reports/#findComment-1497015 Share on other sites More sharing options...
Barand Posted November 19, 2014 Share Posted November 19, 2014 It was a bespoke application targeted specifically for the client's database and table relationships. It would not be of general use. Quote Link to comment https://forums.phpfreaks.com/topic/292277-query-builder-reports/#findComment-1497016 Share on other sites More sharing options...
gizmola Posted November 19, 2014 Share Posted November 19, 2014 There is an entire product category ("Business Intelligence tools") with a number of products that will work with structured data sets, typically your SQL data. Just a few off the top of my head: Crystal Reports, Cognos, Tableux, Hyperion and Business Objects. Like Barand I've been involved in the design and development of integrated query tools, but these were for large corporations that had very specific business tools and the budget to accomodate the development of these tools. There are 2 fairly mature ORM's in the PHP world: Propel which is an active record pattern implementation and Doctrine2 which is a Data Mapper pattern. Each has its own query builder, which would provide a nice foundation for a custom query tool. At the end of the day, its typically the UI that offers all the complexity, as you're providing a thin layer above SQL. You really have to have a significant amount of time, some fairly good requirements, and an interest in investing in a sophisticated UI to pull something like this off successfully. Also as Barand pointed out in his typical pithy manner, if you're giving them the ability to query "everything" then why not just point them to one of the reporting tools and get them setup. I'd also point out that many a company has pointed some analysts at a production transaction database and lived to regret it, when a report they'd just designed takes down the entire transaction system. This is the reason Datamarts and Data warehouses exist. Quote Link to comment https://forums.phpfreaks.com/topic/292277-query-builder-reports/#findComment-1497021 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.