== Actors == * **Transport Organizer** == Steps == 1. The transport organizer logs into the system. 2. The transport organizer selects the ‘Our Routes’ tab. {{{#!sql SELECT r.route_id, l1.name AS from_location, l2.name AS to_location, tr.company_name AS organizer_name FROM route r JOIN location l1 ON r.from_location_id = l1.location_id JOIN location l2 ON r.to_location_id = l2.location_id JOIN transport_organizer tr ON r.transport_organizer_id = tr.transport_organizer_id WHERE l1.name ILIKE '%from_location%' AND l2.name ILIKE '%to_location%' }}} 3. The transport organizer selects a Route they want to add trip to. 4. The transport organizer clicks on the ‘Add Trip’ button. 5. The transport organizer fills out a form with the following details: * Time for the trip. * Stop locations along the route, including estimated time of arrival (ETA) for each stop. 6. The transport organizer submits the form. {{{#!sql INSERT INTO trip (route_id, transport_organizer_id, free_seats, date, status) VALUES (selected_route_id, logged_in_transport_organizer_id, total_seats, 'trip_date', 'NOT_STARTED') }}} {{{#!sql INSERT INTO trip_stops (trip_id, location_id, stop_time) VALUES (returned_trip_id, stop_location_id, 'stop_time') }}} 7. The transport organizer is redirected to the route page.