aboutsummaryrefslogtreecommitdiffstats
path: root/app/models
diff options
context:
space:
mode:
authorTeddy Wing2017-05-04 15:14:44 +0200
committerTeddy Wing2017-05-04 17:09:14 +0200
commit4c12a6632907d5d24b654791db994bfb830c7e37 (patch)
tree45d98a55e95b3ead1c8773d773cd916bb0420938 /app/models
parentdcab1737ff8618fb94bc2fb379502292e260f44f (diff)
downloadchouette-core-4c12a6632907d5d24b654791db994bfb830c7e37.tar.bz2
VehicleJourneysCtl#collection: Sort journeys by departure time ascending
Correctly sort journeys. They used to be sorted correctly this way, but after d7c6d5ce602219b9bfa47686542dd575f1fe2e50 or c3d207301d17538b65d2a1239ce0acf642942ce9, the sorting got messed up because of the join. Here we leverage `journey_patterns.departure_stop_point_id` in order to get the first stop and sort by that stop's departure time. Query solution thanks to Luc and Alban, who remembered that a reference to the first stop point is stored so we can leverage that for complex things like this. Refs #3268
Diffstat (limited to 'app/models')
0 files changed, 0 insertions, 0 deletions