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