Ubercart

I had thought of that as well, but for my specific purpose currently I need a hotel booking system. I may revisit it later and change it to a general reservation system. The problem with focusing on that now is that A) I don't have time to implement all of the requisite functionality and B) it would require being able to establish different time periods rather than a full day -- which brings us back to issue A.

Some of that functionality already exists with events, and the other things can be accomplished with regular products/product classes. I am doing ticket sales on this same site, and am using product classes for the various ticket types. Each date will have its own ticket product assigned, because pricing varies more. While it could likely be handled with this same module, it's not my plan currently to do it that way. Mainly because the Hotel Room node the availability and quantity information is tied to isn't a product itself, just a regular node, and the product node will be created on the fly when a user goes to book a room.

So, it's something that I will consider for the future, but at least initially this is specifically to be a hotel room booking system.

redben,

To address your concerns...

While a number of existing modules could probably be hacked together to get some kind of workable solution, a custom module makes everything much cleaner and easier to work with from an end-user stand point.

As an end user (and the admin side) when I want to add rooms and set rates, I don't want to have to go to 5 different sections to do so.

This module provides a list of rates, creates a Hotel Room-type node type, associates a calendar to hotel room-type nodes...

There's a bunch more, but lets pause here.

Ok, so The room types of the hotel aren't likely to change very often, hence it makes sense to have a room type that stays persistent rather than creating them over and over again as new products. By attaching a calendar to each of the room type nodes, you can then assign availability per room type, with a separate rate (from that list of rates) for every day of the year.

Since the availability is handled by these calendars, the existing stock module cannot handle that, but that's really not an issue.

When a customer chooses to book a room from the results of their search of available rooms, a custom product of a 'hotel-booking' type will be created and added to their cart. When this product is created, the number of available rooms of the type they're booking is decremented from the availability calendar tied to the node for that hotel room type from each of the dates for nights they will be staying.

So, example. If I were going to check in on Friday March 6th, and check out on Monday March 10th, that's a 3 night stay, so the available number of rooms will be decreased for Friday, Saturday, and Sunday.

If the user abandons their order, or removes the product from their cart, those nights will be credited back to the availability calendar and that product node will be deleted. This will be handled by either a cron task, or a hook into the remove_cart_item function depending on the circumstance.

The end result is that it keeps the database tidy, without a bunch of excess nodes laying around.

While I'm painfully behind schedule on this project, I've been making some good progress and anticipate it being completed and ready for testing by the end of the day today or tomorrow.

Dubs: That functionality will be there already.

I know I said this would be available on the first, but as with all programming.. There have been delays.

PepeMty:

This module will not be a full management package, actual room assignment would still have to be done offline, or with a different package. It's intended as a way to allow a hotel to take reservations online and then plug those into their management system. If that is all you need, then hopefully this module will suit your purposes.

I'd love to see it get used by a number of people, makes all of my effort a bit more worthwhile.

Hi TC,

Do you have any updates on when this might be available? I have a client who needs the very same thing and it seems silly to duplicate this module. However, if you're too busy, I'm happy to help with the coding.

Thanks,

Dubs