##// END OF EJS Templates
jro_apps » redmine
RSS
Clean up SQL....
Jean-Philippe Lang -
r15862:30493d542188
parent child
Show More
Side by Side Unified
Context file:
r15862:30493d542188 Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,53 +1,53
1 # Redmine - project management software
1 # Redmine - project management software
2 # Copyright (C) 2006-2016 Jean-Philippe Lang
2 # Copyright (C) 2006-2016 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.
8 #
8 #
9 # This program is distributed in the hope that it will be useful,
9 # This program is distributed in the hope that it will be useful,
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 # GNU General Public License for more details.
12 # GNU General Public License for more details.
13 #
13 #
14 # You should have received a copy of the GNU General Public License
14 # You should have received a copy of the GNU General Public License
15 # along with this program; if not, write to the Free Software
15 # along with this program; if not, write to the Free Software
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17
17
18 class AutoCompletesController < ApplicationController
18 class AutoCompletesController < ApplicationController
19 before_action :find_project
19 before_action :find_project
20
20
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 status = params[:status].to_s
24 status = params[:status].to_s
25 issue_id = params[:issue_id].to_s
25 issue_id = params[:issue_id].to_s
26 if q.present?
26 if q.present?
27 scope = Issue.cross_project_scope(@project, params[:scope]).visible
27 scope = Issue.cross_project_scope(@project, params[:scope]).visible
28 if status.present?
28 if status.present?
29 scope = scope.open(status == 'o')
29 scope = scope.open(status == 'o')
30 end
30 end
31 if issue_id.present?
31 if issue_id.present?
32 scope = scope.where("#{Issue.table_name}.id <> ?", issue_id.to_i)
32 scope = scope.where.not(:id => issue_id.to_i)
33 end
33 end
34 if q.match(/\A#?(\d+)\z/)
34 if q.match(/\A#?(\d+)\z/)
35 @issues << scope.find_by_id($1.to_i)
35 @issues << scope.find_by_id($1.to_i)
36 end
36 end
37
37
38 @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order("#{Issue.table_name}.id DESC").limit(10).to_a
38 @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order(:id => :desc).limit(10).to_a
39 @issues.compact!
39 @issues.compact!
40 end
40 end
41 render :layout => false
41 render :layout => false
42 end
42 end
43
43
44 private
44 private
45
45
46 def find_project
46 def find_project
47 if params[:project_id].present?
47 if params[:project_id].present?
48 @project = Project.find(params[:project_id])
48 @project = Project.find(params[:project_id])
49 end
49 end
50 rescue ActiveRecord::RecordNotFound
50 rescue ActiveRecord::RecordNotFound
51 render_404
51 render_404
52 end
52 end
53 end
53 end
General Comments 0
You need to be logged in to leave comments. Login now