Changes between Version 3 and Version 4 of ManageTripUseCase

Timestamp:

01/13/25 16:26:51 (42 hours ago)

Author:

221514

Comment:

--

ManageTripUseCase

@@ -7 +7 @@
  3. The transport organizer selects the ‘From destination’ and enters a location.
  4. The transport organizer selects the ‘To destination’ and enters a location.
- 5. (Optional) The transport organizer selects a date range in which their trips were completed. By default, all trips with an **UPCOMING** status are displayed.
+ 5. (Optional) The transport organizer selects a date range to filter their trips. By default, all trips with a **NOT_STARTED** status are displayed.
+ 6. (Optional) The transport organizer selects the status to filter their trips. By default, all trips with an **NOT_STARTED** status are displayed.
 
 {{{#!sql
@@ -29 +30 @@
 JOIN location as lt on r.to_location_id = lt.location_id
 JOIN trip_stops as stop on lf.location_id = stop.location_id
-WHERE status = 'NOT_STARTED' 
-AND date > {date_after} AND date < {date_before} -- Optional
+WHERE ({selected_status} IS NULL OR tick.status = {selected_status})
+AND ({before_date} IS NULL OR trip.date < {before_date})
+AND ({after_date} IS NULL OR trip.date > {after_date})
 ORDER BY date, stop_time;
 }}}