jro_apps/redmine Commit - r11063:8585cda7b1b0

1

# Redmine - project management software

1

# Redmine - project management software

2

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

18

class AutoCompletesController < ApplicationController

18

class AutoCompletesController < ApplicationController

19

before_filter :find_project

19

before_filter :find_project

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

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

35

private

35

private

36

37

def find_project

37

def find_project

38

if params[:project_id].present?

38

if params[:project_id].present?

39

@project = Project.find(params[:project_id])

39

@project = Project.find(params[:project_id])

40

end

40

end

41

rescue ActiveRecord::RecordNotFound

41

rescue ActiveRecord::RecordNotFound

42

render_404

42

render_404

43

end

43

end

44

end

44

end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             # Redmine - project management software
             # Copyright (C) 2006-2013  Jean-Philippe Lang
             #
             # This program is free software; you can redistribute it and/or
             # modify it under the terms of the GNU General Public License
             # as published by the Free Software Foundation; either version 2
             # of the License, or (at your option) any later version.
             #
             # This program is distributed in the hope that it will be useful,
             # but WITHOUT ANY WARRANTY; without even the implied warranty of
             # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
             # GNU General Public License for more details.
             #
             # You should have received a copy of the GNU General Public License
             # along with this program; if not, write to the Free Software
             # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
             class AutoCompletesController < ApplicationController
               before_filter :find_project
               def issues
                 @issues = []
                 q = (params[:q] || params[:term]).to_s.strip
                 if q.present?
                   scope = (params[:scope] == "all" || @project.nil? ? Issue : @project.issues).visible
-                  if q.match(/^\d+$/)
+                  if q.match(/\A#?(\d+)\z/)
-                    @issues << scope.find_by_id(q.to_i)
+                    @issues << scope.find_by_id($1.to_i)
                   end
-                  @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE ?", "%#{q.downcase}%").order("#{Issue.table_name}.id DESC").limit(10).all
+                  @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order("#{Issue.table_name}.id DESC").limit(10).all
                   @issues.compact!
                 end
                 render :layout => false
               end
               private
               def find_project
                 if params[:project_id].present?
                   @project = Project.find(params[:project_id])
                 end
               rescue ActiveRecord::RecordNotFound
                 render_404
               end
             end