TripOn

This module is used to manage transporter details in the system. A transporter represents a vehicle service provider responsible for transportation services. Each transporter belongs to a specific district and location. When a transporter is created, the system automatically generates login credentials (username and password). These credentials are sent to the transporter’s email so they can access the system.

Table

transporter_master

• transporter_id (PK) INT AUTO_INCREMENT Unique transporter ID
• transporter_name VARCHAR(150) Name of the transporter
• district_id (FK) INT References district_master.id
• loc_id (FK) INT References loc_master.loc_id
• email VARCHAR(150) Transporter email address
• username VARCHAR(200) Auto-generated login username
• password VARCHAR(255) Auto-generated password (stored encrypted)
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated date

Validations

Mandatory

• transporter_name required
• district_id required
• loc_id required
• email required

Transporter Name

• Minimum 2 Characters
• Maximum !50 Characters
• Cannot be empty

Duplicate

• Prevent duplicate transporter under same location

District

• district_id must exist in district_master
• district must be active

Location

• loc_id must exist in loc_master
• location must belong to selected district

Email

• Must be valid email format

Username

• Username must be auto generated
• Must be unique
• Cannot be edited manually

Password

• Must be auto generated
• Must be encrypted before saving
• Cannot store plain password

Edit

Allow edit:

• transporter_name
• email
• is_active

Do NOT allow edit:

• username
• password
• transporter_id
• district_id
• loc_id

Delete

• Soft delete only
• Do not delete record permanently