Wanted: experienced coder for reservation module for a ski-resort

[Zeddy]

Hi,

what i want is something a bit more advanced then a simple reservation form.

I own a ski resort, and we offer our customers private lections and courses for down hill skiing and snowboarding.

I want the user to be able to make the reservation using a form on our website which is running cmsms, when the reservation is made it has to be confirmed, when that happends the customer is sent a confirmation email. This sounds simple, but there is a catch (main reason why im not even trying to do it myself) we have around 30 different teachers, and i want to have a calendar where i set which teacher is working which dates and what hours, also i want there to be set if the teacher teaches down hill skiing, snowboard or telemark, or all of them.

So when a reservation is made by the customer, the girl in charge of approving the reservation recieves the date and time and type of lection that has been reserved and gets a list of teachers that are going to be working those hours and do teach the specific type (downhill/snowboard/telemark).

So the database would look something like this

customer: name surname
adults: 3
children: 2
total: 5
type: snowboard
date: 21.11.2008
time: 4pm - 5pm
reservationID
----------------->
Is there any snowboard teachers working that date and time which do not have any confirmed reservations for that time?
if not found -> ask client to choose another time/date/type
found: TeacherID
----------------->
insert reservationID to teacherID's personal calendar
send confirmation e-mail to client
send "new reservation" e-mail to teacher so that he/she knows there is something new in their calendar

Is this possible? I would be prepared to pay for such work, but it has to be a really robust and fail-safe module.

[liudaz]

I wrote you a personal message. I think we would be interested.