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