How to use OFBiz to provide room reservation

[X Gylee <x....@gmail.com>]

I'm currently exploring the possibility of using OFBiz for a hotel room
reservation system. The system will have several types of rooms, each with
its own number of available rooms for a date period.

For example:

Room 1 => Jan 1 - Jan 10 => 3 rooms.
Room 1 => Jan 11 - Jan 17 => 2 rooms.
Room 1 => Jan 18- Jan 31 => 3 rooms.

Room 2 => Jan 1 - Jan 20 => 1 room.
Room 2 => Jan 21 - Jan 31 => 2 rooms.

If a customer books a room in a certain date range the available quantities
in the corresponding periods will be subtracted.

For example:

A customer books one "Room 1" from Jan 10 to Jan 12. Then the availabilities
of Room 1 would be updated to:

Room 1 => Jan 1 - Jan 9 => 3 rooms.
Room 1 => Jan 10 - Jan 10 => 2 rooms.
Room 1 => Jan 11- Jan 12 => 1 room.
Room 1 => Jan 12 - Jan 17 => 2 rooms.
Room 1 => Jan 18- Jan 31 => 3 rooms.

I try to use OFBiz for such scenarios, but I do not know how to define the
products, pricings, and inventories for it. The provided OFBiz sample data
does not seem to be tailored for a purchase that spans accross a date range.

I could manipulate OFBiz by creating a single product for each date, such as
"Room 1 Jan 1", "Room 1 Jan 2", "Room 1 Jan 3", etc., and allocate pricings
and an inventory for each. But, this would be a very tedious process.

I see the existence a product type "Fixed Asset Usage", but I do not know
how to take advantage of it to fit the scenarios above.

Could anybody provide a suggestion on how one could best use OFBiz to handle
such scenario?

Re: How to use OFBiz to provide room reservation

[Amine AZZI <ba...@gmail.com>]

did you look into http://opentravelsystem.org ?

Regards
Amine.

2009/1/9 X Gylee <x....@gmail.com>

> I'm currently exploring the possibility of using OFBiz for a hotel room
> reservation system. The system will have several types of rooms, each with
> its own number of available rooms for a date period.
>
> For example:
>
> Room 1 => Jan 1 - Jan 10 => 3 rooms.
> Room 1 => Jan 11 - Jan 17 => 2 rooms.
> Room 1 => Jan 18- Jan 31 => 3 rooms.
>
> Room 2 => Jan 1 - Jan 20 => 1 room.
> Room 2 => Jan 21 - Jan 31 => 2 rooms.
>
> If a customer books a room in a certain date range the available quantities
> in the corresponding periods will be subtracted.
>
> For example:
>
> A customer books one "Room 1" from Jan 10 to Jan 12. Then the
> availabilities
> of Room 1 would be updated to:
>
> Room 1 => Jan 1 - Jan 9 => 3 rooms.
> Room 1 => Jan 10 - Jan 10 => 2 rooms.
> Room 1 => Jan 11- Jan 12 => 1 room.
> Room 1 => Jan 12 - Jan 17 => 2 rooms.
> Room 1 => Jan 18- Jan 31 => 3 rooms.
>
> I try to use OFBiz for such scenarios, but I do not know how to define the
> products, pricings, and inventories for it. The provided OFBiz sample data
> does not seem to be tailored for a purchase that spans accross a date
> range.
>
> I could manipulate OFBiz by creating a single product for each date, such
> as
> "Room 1 Jan 1", "Room 1 Jan 2", "Room 1 Jan 3", etc., and allocate pricings
> and an inventory for each. But, this would be a very tedious process.
>
> I see the existence a product type "Fixed Asset Usage", but I do not know
> how to take advantage of it to fit the scenarios above.
>
> Could anybody provide a suggestion on how one could best use OFBiz to
> handle
> such scenario?
>