By johnnoc on

This is what I am thinking of doing for a restaurant website:

User registers at site (user.module and profile.module)
Admin creates contenttype (CCK nodetype: Reservations)
User can then create content: Reservations (with all the custom fields like phone number, time of table reservation, contact info, etc)
Auto sending of confirmation e-mail once the node (reservation) has been created.
Admin creates views (table style?)with all the fields.
Node Access will only be by node author and admin.

When the day comes, the manager wants to just look on the Drupal site and not the reservation book so he has views like:
23 Feb 2008
8pm

Smith ------- 8 ppl ----cellphone # ---- special wishes
Kennedy ---- 6 ppl ----cellphone # ---- special wishes
Pitt --------- 4 ppl ----cellphone # ---- special wishes
Bush ------- 28 ppl ----cellphone # ---- special wishes

9pm

Jane ------- 8 ppl ----cellphone # ---- special wishes
Eric -------- 6 ppl ----cellphone # ---- special wishes
John ------- 4 ppl ----cellphone # ---- special wishes
James ---- 28 ppl ----cellphone # ---- special wishes

10pm

etc....

Do i need extra useful modules like calendar, or event, or something? Weekly view? Monthly view?

They've been using the webforms module and it's dissatisfactory for them and me. :-(

How would you do it? I'm still in the process of cenceptualization of this feature. So ALL possible ideas are very much welcome for me to plan my course of action :-) Thanks in advance for input! :-)

⋅ Categories: Drupal 5.x

Comments

nevets’s picture

nevets commented

It seems you need someway of telling if the restaurant can even handle the reservation. At the simple level you need to know the total number of seats but that is probably not enough. For example you might have 2 table of 2 open (4 seats) but that does not mean you handle a reservation for 4. Also there is the question of timing. If the average seating time is 2 hours and the restraunt is full at 8pm it is pretty hard to handle a 7pm reservation. Also large reservation typically need special handling. In short as a customer I would expect my reservation to be honered so the system needs some sort of smarts to determine if can grant a given reservation.

powrslave’s picture

powrslave commented

http://drupal.org/project/calendar

johnnoc’s picture

johnnoc
Primary language Norwegian Bokmål
Location Oslo
commented

Does the calendar project handle hours? 8:00, 8:15, 8:30, 8:45 and 9:00 for example? And multiple entries per given time?

John
---------------------------------
http://www.drupalnorge.no
hvor oversettere, utviklere, leverandører, og brukere av Drupal i Norge samles!

johnnoc’s picture

johnnoc
Primary language Norwegian Bokmål
Location Oslo
commented

Thanks for your reply. In terms of handling reservations, the restaurant has a seating capacity of 200 with tables for 2,4,6,10,12up to 40. I can have the auto-mail as "Your reservation is being processed, we'll get back to you at the latest 48 hours" and just let the manager (after receiving the reservation notice by e-mail) reply by e-mail for human contact (human contact is a gem with regards to HUGE restaurants....personal service!) so the "sort of smarts" can be done manually by the PR manager or reservations officer. Besides, online reservation deadline is 3 days before or guests are encouraged to call instead, if reservation is less than 3 days before.

Any ideas? :-) Well, if you also have any ideas on automating what you mentioned, then you're heaven sent :-)

John
---------------------------------
http://www.drupalnorge.no
hvor oversettere, utviklere, leverandører, og brukere av Drupal i Norge samles!

elsphinc’s picture

elsphinc commented

I've been tweaking with this myself. Would love to hear how its coming for you.

drugasy’s picture

drugasy commented

Hi! Use http://drupal.org/project/reservation