someone on cf-talk said this would be a better place to go for an OO type question. I'm new to CF and I want to learn how to do OO as I learn CF so that I don't carry over my bad habits from my ASP days. (I gave it up. I swear!)

I'm not sure how to handle a situation. Does it go in the model? Does it go in a custom tag?

I'm gearing up with a simple time tracking application for developers working on different projects.

Managers own Projects (many to many)
Workers are assigned to Projects (many to many via Assignments)
Assignments (Worker, Project, StartDate, Percent Effort) are completed by Effort (Assignment, WorkDate, regEffort, otEffort)

I've got all of the data entry done. Now I'm working on the report.

I figure most of the time, people are just interested in the summary. "How is this worker doing on Working the appropriate PercentEffort for this Project?"

So it would be something like this:
Worker
   Project
      Assignment (start date, percent effort)
         totalRegEffort   totalOTEffort   %Effort   HoursOver/Short


There are also times I want to display all of the information
Worker
   Project
      Assignment (start date, percent effort)
         regEffort           otEffort            %Effort
            ..                        ..                        ..
            ..                        ..                        ..
            ..                        ..                        ..
         totalRegEffort   totalOTEffort   %Effort   HoursOver/Short


I'm thinking totalRegEffort, totalOTEffort, etc are more efficiently retrieved from the database, right?

So does Assignment.cfm have getTotalRegEffort, getTotalOTEffort, etc? do I do this in a custom tag by looping the effort?

Sorry if this is really basic, I'm still trying to wrap my head around this.

Thanks
Joelle


----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to 
[email protected] with the words 'unsubscribe cfcdev' as the subject of the 
email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting 
(www.cfxhosting.com).

An archive of the CFCDev list is available at 
www.mail-archive.com/[email protected]


Reply via email to