Hi,
I have company website, with many offices around the world (around 50 offices).
The company want to create a gift giveaway with the employees in a specific company each specific day.
For example:
Office 1: will do the giveaway the days: 1/1/2010, 7/1/2010, 15/1/2010, etc...
Office 2: the days: 2/1/2010, 9/1/2010, 19/1/2010, etc...
Office 3: ....
Office 50: ...
(the days are setup manually to specific offices, no need of an algorithm here)
I have a node per Office, with details of each office (location, phone, email, etc), now I need to assign those days to the offices.
But my problem here is that I don't need to create events (or at least node events) because I don't need to store any data in the event. Just need to say: Office 1? Yes, days 1/1/2010, 7/1/2010, etc...
Nothing else, just to know the dates.
And, if possible, display them in the calendar module.
What is your suggestion?
Comments
_
What about using a simple multivalue date field?
_
The problem is that I need around 200 dates per year, per Office. Select from a select box will be a pain :S
Imagine 50 offices * 200 (or so) dates assigned * every year, and then I need to sort by date too, it will be really hard to maintain, I think.
_
The only other thing i can think of is to create a 'giveaway' content type with a nodereference field for the 'office' content type and use views_attach to display the giveaway days related to an office right on the office node type.
With a 200 to 1 ratio, it's going to be awkward to manage no matter what you do-- unless you don't display giveaway dates that occur in the past.
.
Ok, I think I've a good solution for that, three content types:
Office: with data of the office
Days: with a node per day (365 * year)
and Giveaway: with two node-reference fields, one for Office and another for Day.
Then I can fill only Giveaway content type, and that's enough.
And next only the views are remaining.
Thank you for the tip!