backlogs/redmine_backlogs

class RbQueriesController < RbApplicationController
  unloadable

  def show
    @query = __IssueQueryClass.new(:name => "_")
    @query.project = @project
    group_by = nil

    if params[:sprint_id]
      @query.add_filter("status_id", '*', ['']) # All statuses
      @query.add_filter("fixed_version_id", '=', [params[:sprint_id]])
      @query.add_filter("backlogs_issue_type", '=', ['any'])
    elsif params[:release_id]
      @query.add_filter("status_id", '*', ['']) # All status
      @query.add_filter("release_id", '=', [params[:release_id]])
      @query.add_filter("backlogs_issue_type", '=', ['story'])
      group_by = 'fixed_version'
    else
      @query.add_filter("status_id", 'o', ['']) # only open
      @query.add_filter("fixed_version_id", '!*', ['']) # only unassigned
      @query.add_filter("backlogs_issue_type", '=', ['story'])
      @query.add_filter("release_id", '!*',['']) # only unassigned
    end

    column_names = @query.columns.collect{|col| col.name}
    column_names = column_names + ['position'] unless column_names.include?('position')

    session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :column_names => column_names, :group_by => group_by}
    redirect_to :controller => 'issues', :action => 'index', :project_id => @project.id, :sort => 'position'
  end

  def impediments
    @query = __IssueQueryClass.new(:name => "_")
    @query.project = @project
    @query.add_filter("status_id", 'o', ['']) # only open
    @query.add_filter("fixed_version_id", '=', [params[:sprint_id]])
    @query.add_filter("backlogs_issue_type", '=', ['impediment'])
    session[:query] = {:project_id => @query.project_id, :filters => @query.filters }
    redirect_to :controller => 'issues', :action => 'index', :project_id => @project.id
  end

  private

  def __IssueQueryClass
    if (Redmine::VERSION::MAJOR > 2) || (Redmine::VERSION::MAJOR == 2 && Redmine::VERSION::MINOR >= 3)
      IssueQuery
    else
      Query
    end
  end

end