TripOn

This module allows assigning facilities to a specific hotel along with a tariff (price).
Each hotel can have multiple facilities (example: Badam Milk, Cake, Spa, Swimming Pool), and each facility can have a different tariff per hotel.

This is a mapping table between hotel and facility with tariff.

Table

hotel_facility_mapping

• id (PK) INT Unique mapping ID
• enterprise_id (FK) INT References enterprise_master.enterprise_id
• hotel_id (FK) INT References hotel_master.id
• facility_id (FK) INT References facility_master.id
• tariff DECIMAL(10,2) Price of facility for that hotel
• is_active BOOLEAN Active / Inactive
• added_date DATETIME Created date
• updated_date DATETIME Last updated date

Validation

Add Facility to Hotel

Mandatory:

• Hotel ID required
• Facility required
• Tariff required
• enterprise_id required

Duplicate

Prevent duplicate:

• Same hotel_id + facility_id + enterprise_id

Tariff Validation

• Must be numeric
• Must be >= 0
• Cannot be empty

Enterprise Validation

• enterprise_id must match hotel_master.enterprise_id
• Cannot assign facility from another enterprise

Edit

Allow editing:

• Tariff
• is_active

Do NOT allow editing:

• hotel_id
• facility_id

Active / Inactive Rule

• is_active = TRUE → Facility usable
• is_active = FALSE → Facility hidden but not deleted

Soft delete only.

• One hotel can have multiple facilities
• One facility can be used in multiple hotels
• Tariff can be different per hotel