TripOn

This module allows a logged-in hotel to manage its room categories. Each hotel can define different room categories such as Single, Double, or Suite along with their respective rates. These room categories will be used in tour planning, booking, and pricing calculations. Each record is specific to a hotel.

Table

c2b_hotel_room_category

• id (PK) INT AUTO_INCREMENT Unique ID
• hotel_id (FK) INT References c2b_hotel_master.hotel_id
• room_category_name VARCHAR(150) Name of the room category
• room_type VARCHAR(50) Type (Single / Double / Suite)
• rate DECIMAL(10,2) Room rate
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated date

Validations

Mandatory

• hotel_id required (from login session)
• room_category_name required
• room_type required
• rate required

Room Category

• Minimum 2 characters
• Maximum 150 characters
• Cannot be empty

Room Type

Must be selected from:

• Single
• Double
• Suite

Rate

• Must be numeric
• Must be greater than or equal to 0
• Cannot be empty

Duplicate

Prevent duplicate room category within same hotel.

Hotel

• hotel_id must come from logged-in hotel session
• User should NOT manually select hotel
• Edit Validation

Allow edit:

• room_category_name
• room_type
• rate
• is_active

Do NOT allow edit:

• hotel_id

Delete Rule

• Soft delete only.
• is_active = FALSE