Hello all,

I have a site that books apartments for rent using the OpenResort package in Drupal. It has turned out to be way too complex and "stiff" for our needs. So - I have to start all over!

The plan is to use UberCart for ecommerce coupled with custom content types for the apartments/products. The real question is how to deal with availability and booking. In OpenResort, when the availability is set for apartments, it creates a record for each day and each apartment.. which seems like a bit of a waste to me.

I was thinking that its actually easier to simply record which days AREN'T available either because they are booked (thru UberCart) or because they have been marked unavailable for whatever reason. My thinking here is that this will keep the database a bit cleaner and hopefully less complex.

So how do I do this?

1) A simple table in the database should be fine with the date, nodeid, invoice number and some unique key. Can you think of any others?

2) I can create a tool/module to add dates that the apartment is NOT available, so thats not too tough.

It seems that the tough part will be coming up with a search for days that are available (maybe have the php build a calendar with checkboxes for each available day?). Also, how can I get UberCart to add the dates that are reserved after checkout? Is that part of the workflow?

FYI - I will post a modified version of this under bounties also - if I can get help to figure this out, thats great... but I have no problem paying someone to create a module!

Ron