diff options
| author | Luc Donnet | 2017-12-19 12:10:35 +0100 |
|---|---|---|
| committer | GitHub | 2017-12-19 12:10:35 +0100 |
| commit | bb2713b33296c857ce807e0237bf8095b65070ad (patch) | |
| tree | 7ad6067405da4d75b508af62ef2debd90fbffd5b /app | |
| parent | 1835256469af5f72ec50d986018554722b3b05cb (diff) | |
| parent | e24fa05b277224ae5bd70b95c22b9386555ea72b (diff) | |
| download | chouette-core-bb2713b33296c857ce807e0237bf8095b65070ad.tar.bz2 | |
Merge pull request #149 from af83/5305_autocomplete_stop_area_unaccent
5305 autocomplete stop area unaccent
Diffstat (limited to 'app')
| -rw-r--r-- | app/controllers/autocomplete_stop_areas_controller.rb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/controllers/autocomplete_stop_areas_controller.rb b/app/controllers/autocomplete_stop_areas_controller.rb index 233012028..be1badff0 100644 --- a/app/controllers/autocomplete_stop_areas_controller.rb +++ b/app/controllers/autocomplete_stop_areas_controller.rb @@ -18,7 +18,7 @@ class AutocompleteStopAreasController < ChouetteController scope = scope.possible_parents if relation_children? end args = [].tap{|arg| 4.times{arg << "%#{params[:q]}%"}} - @stop_areas = scope.where("name ILIKE ? OR city_name ILIKE ? OR registration_number ILIKE ? OR objectid ILIKE ?", *args).limit(50) + @stop_areas = scope.where("unaccent(name) ILIKE unaccent(?) OR unaccent(city_name) ILIKE unaccent(?) OR registration_number ILIKE ? OR objectid ILIKE ?", *args).limit(50) @stop_areas end |