Han
WOW, a few years out.
Don't know how much help this will be but a few suggestions.
I would start with these tables
1) Individual (ID,name, etc)
2) Exemptions (ID, exemption - Leave, Other duty, etc)
3) Dates (IndividualID, ExemptionID, startdate, enddate)
?4) Roster list ( the control number of when Individual last
had
duty)
(Normally high number is up next- could possibly be added
to Individual table)
There are a number of calendar generators. You need to just find
one
that fits you best.
You would generate the calendar.
Loop through control numbers find highest one.
Review exemptions if none for the date, place individual on duty
(possibly rest to 1 at this time, you might need to have another table
to
temporally hold the information to accommodate changes).
if individual exempt don't reset control number, go to next highest
and repeat.
When the roster is completed (monthly, quarterly) you could create
temp tables to hold each time period.
I have manually ran a number of duty rosters, but have never tried
to completely automate one.
Good luck,
Rodney
-----Original Message-----
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 7:31 PM
To: CF-Talk
Subject: Help on Duty Roster
Help help!!
hi anyone tried to code a duty roster before..??
anyone can shed some light to how to get it up using a cost effective
way?
sigh.. i can only think of putting every single day, mth, year with its
relevant fields into a table.
but its going to be tedious if the duty roster need to be done up a few
years in advance..
stressed
han
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
