By workonwomen on

So my site is up and runing, but on my site is some information about a hotel.
What I want is that the registered users could reserve rooms on my site.

I searched already the net to find a drupal solution for that, but I found only some discussions about that.

So what is the latest state, it is still a good begin point the event module, but what shall I add? (Signup???)

⋅ Categories: Drupal 4.6.x

Comments

adam.skinner’s picture

adam.skinner commented

Seems to me like you want to build a custom database and use drupal to access it.

You may want to tie it in with CiviCRM as well (for the contact management).

I'd have tables like:
* rooms (individual room data, whether it's occupied or not, what floor it is on, the class of the room, extra notes, smoking or not)
* room classes (single or double bed, size, etc. If not enough info, just detail in room table)

Also, you should have representitive pictures inside the rooms, the outside of your establishment, and prominent staff (this'd just be normal website stuff though, no need to tie it into the module)

You should also have an overview of available rooms, and a booking schedule table for when rooms are reserved (I suppose that this would be instead of an OCCUPIED_FLAG in the rooms table).

You might also consider making rooms a node type, so you could create rooms.

These are all just a bunch of ideas I'm throwing out. You might do better to work with an existing system, if you can find one, and simply slipline it into Drupal if you require.

kae’s picture

kae commented

and you'd want to integrate with ecommerce, right?

workonwomen’s picture

workonwomen commented

Basically this service would be very simple:
There will be no ecomerce (not now), what I need is that there is a some room with pictures how they are looking and a calendar in which is marked what date is free and what not.
And some registered users can only mark dates and edit their own reservations and some can manage everything in the calendar...

What I am looking for is some solution which are already working somewhere and are avaible as module...
But I am open for any solution!

Martin Frank’s picture

Martin Frank commented

Did you do it? and how? I have to do the same thing for a tiny hotel. I'd be glad to know how you solved it.

Thanks

Martin

summit’s picture

summit commented

Hi,
Did you succeed.
I would like to install a reservation module on www.eandrium.com for development aid (Nepalese hotelowners pay high prises for booking engines..).
Please respond.

Thanks in advance,
greetings,
Martijn

kulfi’s picture

kulfi commented

Use webform to collect reservation requests?

Or cck to create a 'available/occupied' field and add it to a new content type, and views to show only available rooms/nodes; and another field to allow 'reserve/book'-ing?

summit’s picture

summit commented

Hi,

Did you or somebody build allready such reservation system?

Thanks in advance for your reply.

greetings,
Martijn

Snow Valley Consulting’s picture

Snow Valley Consulting commented

Are you still looking for a reservation module? we are developing one that is soon to be released to the community... you can see it in action on the site below.

---
Fernie Accommodation information and reservations

waynedrupal’s picture

waynedrupal commented

Your module looks great. When are you planning on releasing this module and are you releasing it to the community open source?

Thanks!

Snow Valley Consulting’s picture

Snow Valley Consulting commented

We are looking into a few different ways of releasing at least certain parts of the code opensource to the community... hopefully sooner than later. I will update this post as I get new info

---
Fernie Accommodation information and reservations

youssefr’s picture

youssefr commented

Hi every one,
I am new to Drupal. I started to use it about a week ago. I used Joomla a lot before.
I was wondering if anyone could tell me if what are the required component for this kind of reservation system.
-inventory availability (a certain number of seats for a particular trip are available only: once, twice or three times a week but not everyday)
-prices difference between : first class or coach
-price difference between: adults and children
...
can CCK do such a booking capability?

Thank you.

mediashock’s picture

mediashock commented

does this system search other sites or your site only? when are you going to release it?

Snow Valley Consulting’s picture

Snow Valley Consulting commented

Hi everyone, we are pleased to announce the launch of Drupal's first booking engine - http://drupal.org/project/openresort

---
Fernie Accommodation information and reservations

maustyle’s picture

maustyle commented

Thanks guys,
I am new at Drupal, I got introduced to it by the Sustainable Living Foundation team (http://www.slf.org.au/) to produce a new portal (http://www.sustainabilityconvergence.org.au/) as a volunteer. It's all Drupal.
I was working with major companies in Italy before, but I left my permanent job because I felt I was not doing enough for environment.
I also decided to switch my Croatian residence hotel site (www.vacanzecroate.com) from ASP to PHP/Drupal.
Thank you,
Sincerely,
Mauro Mazzerioli

mauro

splashworx’s picture

splashworx commented

I have installed openresort (tremendous thanks to the developers) but I'm struggling to make heads or tails of it all. It's quite complicated to setup so, my question is, has anyone set this up on their own site? I would appreciate some advice - I'm no idiot but I can't work this darn thing out! I installed the auto-install download from openresort (after an unsuccessful install of the module - it crashed my site), so I assume all modules are pre-configured (as stated in the openresort documentation).

Anyone have this operating apart from the developer?

Tim

summit’s picture

summit commented

Hi Tim,

Yes I have it working. Especially the ammidities selecting was for me why I am using this great peace of modules.
I also know that Marc at Openresort.org is very helpfull, so please be patient.
This module is still somewhat in development. It hasn't have view support on business subtype, but it is a great module already!
May be you can file a issue on openresort.org if you don't get the installation fullfilled.
Greetings,
Martijn

judef’s picture

judef commented

When will the drupal6 version of openresort be released. I want to use it for my current project. Is anybody working on it? Any help would be greatly appreciated.
Regards,
Judef

mcsolas’s picture

mcsolas commented

I am also interested in seeing if this gets over to drupal 6.

agill’s picture

agill commented

I am working on a 2 in 1 solution for drupal 6:
Hotelwebsite for anonymous users with Infos about the hotel and the city i.e. and online booking and registering
on the frontend. And a Hotelreservationsoftware with Reservations-Calender
showing which rooms are booked/reserved on a certain day (already in function) and different lists
(stay list, departure list, arrival list...)
Demo is running here: hoteldemo.mightech.de and is under active development.
Integration of ecommerce or ubercart is planned. I don´t know yet which of the 2 to use.

Some backroundinfo: The software is build as a module with direct dependencies on: calendar and MERCI modules. hotelguestmanagement
is currently done by civicrm. The preprocessors of the calendarmodule are overwritten
by my module (agreservations) to provide a room/reservations calendar to the Rezeptionist.
Actually everything is achieved without kernel-hacking and without hacking the modules directly, which
got me some serious headache ;-)

So hopefully i can provide the community with a usefull module for roomreservation.

Andreas

summit’s picture

summit commented

Hi Andreas,
Very interested in your development. The module will come under www.drupal.org/project/agreservations?
Greetings, Martijn

agill’s picture

agill commented

when its ready and running in some hotels (which i hopefully will find).
Then i will publish a module for the community which will allow building room occupancy calendars.
So if in this direction nothing else (i.e. build in their modules by the maintainers of the Calendar or the MERCI module),
at least 1 module will be there in a few months handling resource occupancy calendars.
A problem could be, how much the 2 modules on which my module depends (calendar and MERCI) will change
over time. Especially the MERCI module is in permanent development. And as i mentioned above
maybe the maintainers of the MERCI module plan to implement a solution for making resource occupancy visible in a calendarview already.

However...there will be a solution and its all doable with Drupal.

mcsolas’s picture

mcsolas commented

>when its ready and running in some hotels (which i hopefully will find).

I help run a boutique inn beach front in Costa Rica that has 5 total rooms to track. Maybe this one will present a nice test subject.

I was thinking to rebuild our current site (www.surfinnhermosa.com) into drupal. when doing my research I saw this gap. Seems there was some solutions for d5 that didn't yet make it to this version. Either way, I am hoping that the solution can integrate our availability with popular hotel search engines.

I have an existing site running that works fine... so I could setup a testing location and work on v2 behind the scenes.

agill’s picture

agill commented

Hello mcsolas, thanks for the offer. i will contact you, when i have a
version ready for a test on a little hotel. (nice hotel by the way and nice surfing pictures).
Also maybe you should keep an eye on the Reservations modul currently being developed
they say its based on open resort.
See my demosite mentioned above from time to time
and in a few weeks you can choose which 1 you prefer.
will do my best to be quick.

Andreas

giorgosk’s picture

giorgosk
Location Chios, Greece 🇬🇷
commented

Very interested in this module

willing to test/debug code once the module get its own project page

take a look at this thread for something similar to your efforts
http://www.ubercart.org/forum/development/9166/hotel_module

Giorgos Kontopoulos
http://geoland.org

------
GiorgosK
Web Development

agill’s picture

agill commented

Hello, yes the uc_hotel module is indeed an interesting aproach.
Howerver it is seems to be more intended for the
frontend of a hotelwebsite only. You can see which roomtypes are available,
but you don´t know which room (roomnumber) is actually ocupied and which isnt.
I am using some of the uc_hotelcode (for interacting with ubercart) which was posted in the thread you
mentioned (going to update the demosite this weekend).
The difference between the 2 modules is: in my aproach you have each room as a node (i.e. room 1...50)
And with the bookingcalendar (log in as Rezeptionist pw: demo and click on Bookingcalendar on the left)
you can tell which room is ocupied and which isnt, add rooms, make reservations...

The anonymous visitor of the hotelwebsite on the other hand needs only to be able
to search for "smoker/nonsmoker room double or single with n adults" and when there are free rooms
a reservation can be made. But the anonymous user will not know which roomnumber he has until he
arrives in the hotel. The last part reservation for anonymous visitors is not yet ready, i hope
i get it done the next 3 weeks.

Greetings
Andreas

ramones79’s picture

ramones79 commented

I'm looking for such a solution /hotel module or system/ too. I'll be watching this thread for further info :)

mcsolas’s picture

mcsolas commented

your approach will work with how the rooms are typically charged.

also the rooms often vary with high and low season rates, holidays. how will it handle searching room rates depending on the date.

giorgosk’s picture

giorgosk
Location Chios, Greece 🇬🇷
commented

Andeas,
if you create a drupal project we can all help easily debug and even design/model such a module

I surely have plenty of ideas on necessary features but don't know if I should include then in a forum message

------
GiorgosK
Web Development

parrottvision’s picture

parrottvision commented

+1

hwks’s picture

hwks commented

Hi all,
Does anyone have an update on this solution/module? I'm interested in working on this as well.

Appreciate any further comments/responses.

Thanks

giorgosk’s picture

giorgosk
Location Chios, Greece 🇬🇷
commented

there is a new module in town

http://drupal.org/project/uc_hotel

please evaluate and send comments patches improvements etc

------
GiorgosK
Web Development

meandrew’s picture

meandrew commented

Is there a solution without having to install ubercart?

I just need a simple reservation system for a small bed and breakfast

Andrew

agill’s picture

agill commented

I am sorry for the delay... i was very busy the last weeks and i still am.
But i finally manged to make an update of http://hoteldemo.mightech.de
It is now possible to make bookings as logged in Receptionist AND to
buy Reservations online with ubercart as anonymous website-visitor.
The Rooms are then booked automatically. I activated the ubercard testpaymentgateway.
(just use the dummy creditcardnumber 41111).
There is still a lot of plausibilitychecks missing, but thats the easy part.
All i now have to do before the first release is:

1.:add routine plausibility checks.
2.: use some more ubercard_hooks for a better display of the cart and
checkoutpanes.
3.: Clean up my code.
4.: write some instructions
5.: Release the modules on drupal.org

So i will not build in any more features , until what i have by now
is released on Drupal.org. When that is done, everybody is
invited to download the modules and test them and give feedback.
I will release the modules before my vacations in december (with luck in november)so i can enjoy my
free time with a free mind for a few weeks.

Andreas

summit’s picture

summit commented

Hi Andreas,

This is looking great! Looking forward to it!
greetings, Martijn

szczym’s picture

szczym commented

Helo Andreas,

Looks very promising, let me know when i can alpha-test your module, i really appreciate your work !

greetings, Szczym

summit’s picture

summit commented

Hi Andreas,

May be making a install profile of it related to ubercart would be a great thing!

Greetings, Martijn

flashdelux’s picture

flashdelux commented

Hi Andreas ,

Really nice demo, just wondering if you had plan for a beta release any-time soon ?

Well done, sir.

cheers

Martin

agill’s picture

agill commented

Hi Martin,

yes there will be a non-dev release on drupal.org as soon as possible.
I think it will be in April. As long as there are only dev versions of
agreservations on drupal, i would not recommend it for a live hotelwebsite yet.

However, the non dev of April will include the basicfeatures
which are currently visible on the demosite.

But after that there is so much more needed. like POS, catering list,....
plus the adjustements to different countries...

The dev versions i released for other Drupalers to test/check the module and make suggestions
or even provide a patch in the issuequeue of the project.

@Martijn an installationprofile with all the necessary and needful modules
to setup a hotelwebsite quickly sounds like a good idea to me.

cheers

Andreas

summit’s picture

summit commented

Hi Andreas, great to hear.
Looking forward to the installation profile, but assume only after 1.0 release is finished!
Could help you test and talk about the modules for the installation profile if you want.
Greetings, Martijn

momper’s picture

momper commented

great ...