| @@ -1,53 +1,53 | |||
|
|
1 | 1 | # Redmine - project management software |
|
|
2 | 2 | # Copyright (C) 2006-2016 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_action :find_project |
|
|
20 | 20 | |
|
|
21 | 21 | def issues |
|
|
22 | 22 | @issues = [] |
|
|
23 | 23 | q = (params[:q] || params[:term]).to_s.strip |
|
|
24 | 24 | status = params[:status].to_s |
|
|
25 | 25 | issue_id = params[:issue_id].to_s |
|
|
26 | 26 | if q.present? |
|
|
27 | 27 | scope = Issue.cross_project_scope(@project, params[:scope]).visible |
|
|
28 | 28 | if status.present? |
|
|
29 | 29 | scope = scope.open(status == 'o') |
|
|
30 | 30 | end |
|
|
31 | 31 | if issue_id.present? |
|
|
32 |
scope = scope.where( |
|
|
|
32 | scope = scope.where.not(:id => issue_id.to_i) | |
|
|
33 | 33 | end |
|
|
34 | 34 | if q.match(/\A#?(\d+)\z/) |
|
|
35 | 35 | @issues << scope.find_by_id($1.to_i) |
|
|
36 | 36 | end |
|
|
37 | 37 | |
|
|
38 |
@issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order( |
|
|
|
38 | @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order(:id => :desc).limit(10).to_a | |
|
|
39 | 39 | @issues.compact! |
|
|
40 | 40 | end |
|
|
41 | 41 | render :layout => false |
|
|
42 | 42 | end |
|
|
43 | 43 | |
|
|
44 | 44 | private |
|
|
45 | 45 | |
|
|
46 | 46 | def find_project |
|
|
47 | 47 | if params[:project_id].present? |
|
|
48 | 48 | @project = Project.find(params[:project_id]) |
|
|
49 | 49 | end |
|
|
50 | 50 | rescue ActiveRecord::RecordNotFound |
|
|
51 | 51 | render_404 |
|
|
52 | 52 | end |
|
|
53 | 53 | end |
General Comments 0
You need to be logged in to leave comments.
Login now