TripOn

This module is used to define different vehicle pricing based on season periods (Example: Peak Season, Off Season, Holiday Season).
Each vehicle can have multiple seasonal rates, where the rate per day, km rate, and extra km rate vary depending on the season date range.
This allows flexible pricing based on tourism demand.

Table

vehicle_season_rate

• id (PK) INT Unique season rate ID
• vehicle_id (FK) INT References vehicle_master.id
• enterprise_id (FK) INT References enterprise_master.enterprise_id
• season_name VARCHAR(100) Season name (Peak, Off, Festival, etc.)
• start_date DATE Season start date
• end_date DATE Season end date
• rate_per_day DECIMAL(10,2) Vehicle daily rate for this season
• km_rate DECIMAL(10,2) Rate per km within allowed limit
• extra_km_rate DECIMAL(10,2) Rate per km beyond allowed limit
• added_date DATETIME Record creation date

Validation

Add

• Vehicle must be selected (mandatory)
• Season Name is mandatory
• Season Name minimum 3 characters
• Start Date is mandatory
• End Date is mandatory
• End Date must be ≥ Start Date
• Rate per Day must be positive (> 0)
• KM Rate must be ≥ 0
• Extra KM Rate must be ≥ 0

Edit

• Must allow editing:
  • Season Name
  • Start Date
  • End Date
  • Rates
• Must still enforce overlap validation