##// END OF EJS Templates
Use database LOWER instead of #downcase....
Jean-Philippe Lang -
r11063:8585cda7b1b0
parent child
Show More
@@ -1,44 +1,44
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2013 Jean-Philippe Lang
3 3 #
4 4 # This program is free software; you can redistribute it and/or
5 5 # modify it under the terms of the GNU General Public License
6 6 # as published by the Free Software Foundation; either version 2
7 7 # of the License, or (at your option) any later version.
8 8 #
9 9 # This program is distributed in the hope that it will be useful,
10 10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 12 # GNU General Public License for more details.
13 13 #
14 14 # You should have received a copy of the GNU General Public License
15 15 # along with this program; if not, write to the Free Software
16 16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 17
18 18 class AutoCompletesController < ApplicationController
19 19 before_filter :find_project
20 20
21 21 def issues
22 22 @issues = []
23 23 q = (params[:q] || params[:term]).to_s.strip
24 24 if q.present?
25 25 scope = (params[:scope] == "all" || @project.nil? ? Issue : @project.issues).visible
26 if q.match(/^\d+$/)
27 @issues << scope.find_by_id(q.to_i)
26 if q.match(/\A#?(\d+)\z/)
27 @issues << scope.find_by_id($1.to_i)
28 28 end
29 @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE ?", "%#{q.downcase}%").order("#{Issue.table_name}.id DESC").limit(10).all
29 @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order("#{Issue.table_name}.id DESC").limit(10).all
30 30 @issues.compact!
31 31 end
32 32 render :layout => false
33 33 end
34 34
35 35 private
36 36
37 37 def find_project
38 38 if params[:project_id].present?
39 39 @project = Project.find(params[:project_id])
40 40 end
41 41 rescue ActiveRecord::RecordNotFound
42 42 render_404
43 43 end
44 44 end
General Comments 0
You need to be logged in to leave comments. Login now