Re: [fw-general] Reporting in Zend Framework MVC applications

2009-03-26 Thread keith Pope
I think for any reporting you want to run your queries in one single query (as much as possible) as down the road lots of separate quires will become slow. IMHO databases are generally well designed to handle the calculations and moving the load from app to database makes sense. Generally when

[fw-general] Reporting in Zend Framework MVC applications

2009-03-25 Thread Cameron
Hi guys, this is probably more of a general OO question than specific to ZF, but I thought I'd throw it out there to see if there's some really good solutions out there. I've written a pretty extensive application in ZF, it's all MVC driven, uses Dojo and AJAX, it's pretty cool, and generic and

Re: [fw-general] Reporting in Zend Framework MVC applications

2009-03-25 Thread keith Pope
Maybe a decorator? You could then start with a base report and build it up. $report = new ReportMetricOne(new ReportMetricTwo(new Report())); $report could then be processed by a generic reporting class/model: $reportModel-generate($report); downside = complexity, decorators can be confusing

Re: [fw-general] Reporting in Zend Framework MVC applications

2009-03-25 Thread Cameron
A decorator hey... And so each ReportMetric would return... Hrm. Part of the issue is trying to generate say, a report that lists all the staff members, and their stats for the week along side them all. Ordinarily for something like that, I would just write a big query that selects all the staff