From c8be59728089ccbf34a72fee709f742de11f2acf Mon Sep 17 00:00:00 2001
From: Xinhui
Date: Wed, 30 Nov 2016 11:40:33 +0100
Subject: Stop_area search is now case insensitive

Refs #2119
---
 app/controllers/autocomplete_stop_areas_controller.rb | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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
 
-- 
cgit v1.2.3