comparison app/controllers/auto_completes_controller.rb @ 1464:261b3d9a4903 redmine-2.4

Update to Redmine 2.4 branch rev 12663
author Chris Cannam
date Tue, 14 Jan 2014 14:37:42 +0000
parents 433d4f72a19b
children e248c7af89ec
comparison
equal deleted inserted replaced
1296:038ba2d95de8 1464:261b3d9a4903
1 # Redmine - project management software 1 # Redmine - project management software
2 # Copyright (C) 2006-2012 Jean-Philippe Lang 2 # Copyright (C) 2006-2013 Jean-Philippe Lang
3 # 3 #
4 # This program is free software; you can redistribute it and/or 4 # This program is free software; you can redistribute it and/or
5 # modify it under the terms of the GNU General Public License 5 # modify it under the terms of the GNU General Public License
6 # as published by the Free Software Foundation; either version 2 6 # as published by the Free Software Foundation; either version 2
7 # of the License, or (at your option) any later version. 7 # of the License, or (at your option) any later version.
21 def issues 21 def issues
22 @issues = [] 22 @issues = []
23 q = (params[:q] || params[:term]).to_s.strip 23 q = (params[:q] || params[:term]).to_s.strip
24 if q.present? 24 if q.present?
25 scope = (params[:scope] == "all" || @project.nil? ? Issue : @project.issues).visible 25 scope = (params[:scope] == "all" || @project.nil? ? Issue : @project.issues).visible
26 if q.match(/^\d+$/) 26 if q.match(/\A#?(\d+)\z/)
27 @issues << scope.find_by_id(q.to_i) 27 @issues << scope.find_by_id($1.to_i)
28 end 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 @issues.compact! 30 @issues.compact!
31 end 31 end
32 render :layout => false 32 render :layout => false
33 end 33 end
34 34