From 01d99506319cfb3db301afb476e3f124a71871b0 Mon Sep 17 00:00:00 2001
From: cedricnjanga
Date: Tue, 22 May 2018 07:24:03 -0700
Subject: Refs #7004 Lower params[:sort] to avoid sort bugs

---
 app/controllers/companies_controller.rb | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/app/controllers/companies_controller.rb b/app/controllers/companies_controller.rb
index 2c32ed3a5..c359dfd6d 100644
--- a/app/controllers/companies_controller.rb
+++ b/app/controllers/companies_controller.rb
@@ -44,9 +44,9 @@ class CompaniesController < ChouetteController
     ids = @q.result(:distinct => true).pluck(:id)
     scope = scope.where(id: ids)
     if sort_column && sort_direction
-      @companies ||= scope.order(sort_column + ' ' + sort_direction).paginate(:page => params[:page])
+      @companies ||= scope.order("lower(#{sort_column})" + ' ' + sort_direction).paginate(:page => params[:page])
     else
-      @companies ||= scope.order(:name).paginate(:page => params[:page])
+      @companies ||= scope.order('lower(name)').paginate(:page => params[:page])
     end
   end
 
-- 
cgit v1.2.3