| Age | Commit message (Collapse) | Author |
|
|
|
5878 Add ComplianceCheck#show
|
|
#5878 @1
|
|
ComplianceControl
|
|
Refs #6040
|
|
|
|
|
|
|
|
|
|
|
|
In the exported csv, add a BOM at the beginning to tell Excdel we use
UTF-8
|
|
|
|
We were getting this errorwhen filtering by purchase window on the
`ReferentialVehicleJourneys#index` page.
An example of a filter query that triggered the error:
http://stif-boiv.dev:3000/referentials/4/vehicle_journeys?utf8=✓&q[published_journey_name_or_objectid_cont]=&q[company_id_eq_any][]=&q[route_line_id_eq]=&q[published_journey_name_gteq]=&q[published_journey_name_lteq]=&q[stop_area_ids][]=&q[purchase_window][start_date(3i)]=12&q[purchase_window][start_date(2i)]=1&q[purchase_window][start_date(1i)]=2018&q[purchase_window][end_date(3i)]=15&q[purchase_window][end_date(2i)]=1&q[purchase_window][end_date(1i)]=2019&q[time_table][start_date(3i)]=&q[time_table][start_date(2i)]=&q[time_table][start_date(1i)]=&q[time_table][end_date(3i)]=&q[time_table][end_date(2i)]=&q[time_table][end_date(1i)]=&commit=Filtrer
ActiveRecord::StatementInvalid in ReferentialVehicleJourneys#index
Showing stif-boiv/app/views/referential_vehicle_journeys/_filters.html.slim where line #24 raised:
PG::AmbiguousColumn: ERROR: column reference "id" is ambiguous
LINE 1: ...RE "vehicle_journeys"."journey_category" = 0 AND (id IN (SEL...
^
: SELECT "public"."lines".* FROM "public"."lines" WHERE (id IN (SELECT routes.line_id FROM "vehicle_journeys" INNER JOIN "routes" ON "routes"."id" = "vehicle_journeys"."route_id" WHERE "vehicle_journeys"."journey_category" = 0 AND (id IN (SELECT DISTINCT vehicle_journeys.id FROM "purchase_windows" INNER JOIN "purchase_windows_vehicle_journeys" ON "purchase_windows_vehicle_journeys"."purchase_window_id" = "purchase_windows"."id" INNER JOIN "vehicle_journeys" ON "vehicle_journeys"."id" = "purchase_windows_vehicle_journeys"."vehicle_journey_id" AND "vehicle_journeys"."journey_category" = 0 WHERE (daterange('2018-01-12', '2019-01-16') && any (date_ranges)))) ORDER BY "vehicle_journeys"."published_journey_name" ASC LIMIT 10 OFFSET 0))
Extracted source (around line #24):
class: 'control-label'
.form-inline.filter_menu
= f.input :route_line_id_eq,
as: :select,
include_blank: t(".all"),
collection: @vehicle_journeys.lines,
Trace of template inclusion: app/views/referential_vehicle_journeys/index.html.slim
We're trying to match `VehicleJourney`s here, so qualify the `id` column
with the table name to fix the error.
Refs #5943
|
|
Avoid problem with numeric in slug. Refs #5609
|
|
|
|
|
|
|
|
doing so
I also changed the way 403 errors are handled, to properly respond with
a 403 HTTP code
|
|
|
|
|
|
|
|
af83/5911-stops-filter-on-referential-journeys-index
Better stops filters on ReferentialVJs#index. Refs #5911
|
|
5863 Remove workbench id from the querystring
|
|
Infer it when possible, and use a nested otherwise
|
|
|
|
|
|
|
|
- The checksum computing for VehicleJourneyAtStops
- Offsets calculation in VehicleJourneys
|
|
Mostly add a way to override the default behaviour and process each row
its own way
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Make ReferentialVJs#index sortable. Refs #5919
|
|
|
|
5416 checksum attribute
|
|
|
|
4963 import cron should abort old imports
|
|
|
|
af83/4758-cron-job-to-finalise-compliance_check_set-validations--
4758 cron job to finalise compliance check set validations
|
|
5815 add required fields for cc
|
|
|
|
Make `#checksum_replace_nil_or_empty_values` more readable.
Refs #5416
|
|
Add Johan's suggestion for simplifying this line. This allows us to get
rid of one of the `#map` calls.
Refs #5416
|
|
Copy over the `Import.abort_old` method to this class. For now I haven't
bothered with moving it to a consolidated module. We'll see, maybe
that's a better approach. For now I'm going with a relaxed copy-paste
solution until we decide that the increased complexity of the module is
worth the deduplication.
We need this method to be able to abort stale imports. We'll be doing
this, similarly to imports, in a regular cron job.
Refs #4758
|