We need to have a feature for booking seats for a performance. A visitor should be able to book some seats where he wants to watch the performance.
It is like a cinema-booking system. Choose the seats of your choice and get the tickets later at the counter. Already booked seats are marked in a special way.

In normal we would not have any problems coding this down in php, but we have no clue doing this with drupal. Our thoughts:
# A cck-widget would be able to show the room with its tables or seat-rows.
-> But there would be no chance to click single seats to book them, because it does not provide a form, right?

# The webform-module could handle this by providing checkboxes and giving a nice list of reservations for the cash desk. The effort for this is enourmous, though.
-> There are several performances a week or so, and building a single webform for every performance presentation is just overkill. But I think node_clone would provide a weak workaround for this.

Right now, we are lost in nowhere. :(
Any hints on solving this are appreciated!

Comments

maulwuff’s picture

no one?

ericg’s picture

I think the reason you have not had many replies is that you group a lot of issues into your question.

there is no module that will do what you want out of the box; there are any number of ways to approach a solution.

My company has been building a reservations system for Public Access TV centers, and I can tell you that what you are looking to do is very complex. the system we're building is nearly complete (it will be released as part of the larger set of 'pegspace' drupal modules soon) but has taken over a year to fully spec, code and test

Issues as complex as what you are asking about need to be broken down into small specific questions as you experiment with drupal / work on your module, or should be combined into a larger RFP so you can hire an experienced consultant.

maulwuff’s picture

thanks for your reply.

sounds like a lot of work :)

we started building up a content-type module which only deals with booking.
With the help of cck node-reference field, we can combine descriptive nodes and add a booking-node to it if needed -- that's the plan.
Let's see how far we can get.

ericg’s picture

although it's gone through a couple rounds of testing and modification since, and will be released in a final version in a few months, I thought you might find it useful to check out the alpha version of the peg-reservation module (PEG is the acronym used to refer to Public Access, Educational and Governmental TV stations). announcement of the alpha module, some description and a link to the code is at http://groups.drupal.org/node/5737

updates on the status of the peg related modules can be found at http://groups.drupal.org/pegspace

maulwuff’s picture

thanks for your links!
I'll post more information on the further development here.

maulwuff’s picture

2 months later, the module is done:

http://drupal.org/project/reservation

;)