TripOn

This module is used to configure weekend room rates for hotels based on room category and room type within a defined weekend date range. The weekend date range is already defined in the existing hotel_weekend_master table. This allows assigning specific rates for each room category and room type combination during those weekend periods. These rates will be used for enquiry pricing, quotation, and booking calculations.

This module uses the existing weekend configuration and links it with hotel, room category, and room type to define weekend-specific pricing.

Table

hotel_weekend_rate

• id INT (PK) Unique ID
• weekend_id INT (FK) References hotel_weekend_master.id
• hotel_id INT (FK) References hotel_master.id
• room_category_id INT (FK) References room_category_master.id
• room_type_id INT (FK) References room_type_master.id
• rate DECIMAL(10,2) Weekend room rate
• enterprise_id INT (FK) Enterprise reference
• is_active BOOLEAN Active / inactive
• created_at DATETIME Created date
• updated_at DATETIME Updated date

Validations

Mandatory

• weekend_id required
• hotel_id required
• room_category_id required
• room_type_id required
• rate required
• enterprise_id required

Rate

• Must be numeric
• Must be ≥ 0
• Cannot be empty

Duplicate

Prevent duplicate combination:

Same:

• weekend_id
• hotel_id
• room_category_id
• room_type_id
• enterprise_id

cannot be added twice.

Enterprise

enterprise_id must match hotel_master.enterprise_id

Edit

Allow edit:

• rate
• is_active

Do NOT allow edit:

• weekend_id
• hotel_id
• room_category_id
• room_type_id