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
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
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
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