Actually, it can do what you request, except you can't limit the number of
'trainers' and you can't have 2 'trainers' assigned to the same event .. so
... i gues it *doesn't* do quite what you request, heh. Technically, those
are the only 2 limitations in the whole thing, though the multiple
'trainers' for a single event might not be a bad idea, now that you mention
it, and shouldn't be hard to implement. What it *can* handle is something
like this.
Take a 'class' for example:
Class: ColdFusion 101
Total number of seats: 30
Seats remaining: 15
Minimum Age: N/A, Maximum Age: N/A
Location: UNC Charlotte. Room 3-A
Schedule: Monday 5-7pm, Wednesday 5-7pm, Thursday 5:30 - 7:15pm (Except for
the last week of class when Thursday's class will be moved to Teusday)
Start date: 12-01-2000 End date: 04-01-2000 (This repeats yearly)
No class on Dec. 25 or Jan. 1
Trainer(s): Monday, Wednesday - Bob Dobbs: Thursday - Sue Dobbs (Except for
the second week in Jan. when Bob will teach all 3 classes)
Tuition: $1,200
You can have an infinite number of such events scheduled all at the same
time if you like. The app can store all of this information and manages it
nicely ... so far ;) You wouldn't believe the convoluted database structure
... just think about all the "what-ifs" above. :(
I know it might be overkill, but the scheduling is just 1 part of a much
larger intranet/extranet for a niche market we are diving into that requires
that kind of flexibility. Still, we designed the scheduling part to work
separately from the rest of the app.
As far as cost, I have no idea. The entire app is going to be sold as part
of an "Application Service Provider" package and we haven't priced the
individual components. I will toss it up on the Allaire DevEx for free if
the boss will let me. :)
Todd Ashworth
----- Original Message -----
From: "Kent A. Orso" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 12:18 PM
Subject: Re: Appointment Applicaton
| Todd,
| Thanks for writing me about your developing application. I have checked
out
| the Allaire Developer's Gallery and I found one that is close (SIBER) that
| might work.
|
| The problem is it won't allow for the scheduling of more than one
| appointment in the same timeframe. For instance, I need to be able to have
| two trainers booked at 9:00AM to 10:00AM with two different clients, or
have
| them both booked to workout with one client. The owner has a restriction
| that he only wants two of the four Full time Personal Trainers in the
| facility during an appointment.
|
| So in a perfect world, I could book a one hour session at 10:00AM with
| Robert
| and another customer could book a 10:00AM session in the same gym with
| Lauren and the system would not allow for any additional bookings because
| the maximum number of trainers for that timeframe for that specific gym
has
| been reached.
|
| Any chance you application could possibly handle this? If it can, it would
| be nice if it was a configuration change from 2, to 4, or 6, or 8 trainers
| in case he decides to expand. Any idea how much you app might run? I would
| give you all the copyright credit and exposure if it can do the job.
|
| Kent A. Orso
| Vice-President
| I M A G E N E T
| http://www.imagenet2000.com
| http://www.imagenet.cc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
