diff options
| author | Xinhui | 2016-11-30 11:40:33 +0100 |
|---|---|---|
| committer | Xinhui | 2016-11-30 11:41:07 +0100 |
| commit | c8be59728089ccbf34a72fee709f742de11f2acf (patch) | |
| tree | ff4b18f8aebe46cbf0f5989e7abe393024ac1f95 | |
| parent | 3d1c3d054130b6a02cfa6135108f03a84e294b5d (diff) | |
| download | chouette-core-c8be59728089ccbf34a72fee709f742de11f2acf.tar.bz2 | |
Stop_area search is now case insensitive
Refs #2119
| -rw-r--r-- | app/controllers/autocomplete_stop_areas_controller.rb | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/app/controllers/autocomplete_stop_areas_controller.rb b/app/controllers/autocomplete_stop_areas_controller.rb index 1e43f3968..b653e6cb5 100644 --- a/app/controllers/autocomplete_stop_areas_controller.rb +++ b/app/controllers/autocomplete_stop_areas_controller.rb @@ -26,7 +26,8 @@ class AutocompleteStopAreasController < InheritedResources::Base else result = referential.stop_areas end - @stop_areas = result.where("name LIKE '%#{params[:q]}%' OR registration_number LIKE '%#{params[:q]}%' OR objectid LIKE '%#{params[:q]}%' ").limit(50) + args = [].tap{|arg| 3.times{arg << "%#{params[:q]}%"}} + @stop_areas = result.where("name ILIKE ? OR registration_number ILIKE ? OR objectid ILIKE ?", *args).limit(50) @stop_areas end |
