TripOn

This module allows a logged-in transporter to add and manage vehicles. Each vehicle includes details such as vehicle name, seating capacity, pricing (per km and per day), maximum km allowed per day, and extra km rate. These vehicles will be used in tour planning and transport allocation. Each vehicle is linked to the logged-in transporter.

Table

c2b_vehicle_master (Updated for Transporter Login)

• vehicle_id (PK) INT AUTO_INCREMENT Unique vehicle ID
• transporter_id (FK) INT References c2b_transporter_master.transporter_id
• vehicle_name VARCHAR(150) Name/model of the vehicle
• km_rate DECIMAL(10,2) Rate per kilometer
• seat_capacity INT Number of seats
• daily_rent DECIMAL(10,2) Daily rent
• max_km_per_day DECIMAL(10,2) Maximum km allowed per day
• extra_km_rate DECIMAL(10,2) Extra km rate
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated date

Validations

Mandatory

• transporter_id required (from login session)
• vehicle_name required
• km_rate required
• seat_capacity required
• daily_rent required
• max_km_per_day required
• extra_km_rate required

Vehicle Name

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

KM Rate

• Must be numeric
• Must be ≥ 0

Seat Capacity

• Must be integer
• Must be greater than 0

Daily Rent Validation

• Must be numeric
• Must be greater than 0

Max KM/Day

• Must be numeric
• Must be greater than 0

Extra KM Rate

• Must be numeric
• Must be ≥ 0

Duplicate

• Prevent duplicate vehicle for same transporter.

Transporter Validation

• transporter_id must come from login session
• User should NOT manually select transporter

Edit

Allow edit:

• vehicle_name
• km_rate
• seat_capacity
• daily_rent
• max_km_per_day
• extra_km_rate
• is_active

Do NOT allow edit:

• transporter_id

Delete Rule

• Soft delete only.
• is_active = FALSE