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?
