did you look into http://opentravelsystem.org ?
Regards Amine. 2009/1/9 X Gylee <[email protected]> > 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? >
