aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorXinhui2016-11-30 11:40:33 +0100
committerXinhui2016-11-30 11:41:07 +0100
commitc8be59728089ccbf34a72fee709f742de11f2acf (patch)
treeff4b18f8aebe46cbf0f5989e7abe393024ac1f95
parent3d1c3d054130b6a02cfa6135108f03a84e294b5d (diff)
downloadchouette-core-c8be59728089ccbf34a72fee709f742de11f2acf.tar.bz2
Stop_area search is now case insensitive
Refs #2119
-rw-r--r--app/controllers/autocomplete_stop_areas_controller.rb3
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