# app/controllers/queries_controller.rb
  def new
    # ...
    params[:fields].each do |field|
      @query.add_filter(field, params[:operators][field], params[:values][field])
    end if params[:fields]
    @query.group_by ||= params[:group_by]
    # ...
  end
  
  def edit
      # ...
      params[:fields].each do |field|
        @query.add_filter(field, params[:operators][field], params[:values][field])
      end if params[:fields]
      @query.attributes = params[:query]
      # ...
  end

# app/models/query.rb
class Query < ActiveRecord::Base
  # ...
end

# app/controllers/queries_controller.rb
class QueriesController < ApplicationController
  def new
    # ...
    @query.add_filters(params[:fields], params[:operators], params[:values]) if params[:fields]
    @query.group_by ||= params[:group_by]
    # ...
  end
  
  def edit
      # ...
      @query.add_filters(params[:fields], params[:operators], params[:values]) if params[:fields]
      @query.attributes = params[:query]
      # ...
  end
end

class Query < ActiveRecord::Base
  # Add multiple filters using +add_filter+
  def add_filters(fields, operators, values)
    fields.each do |field|
      add_filter(field, operators[field], values[field])
    end
  end
end

# app/models/custom_field.rb
class CustomField < ActiveRecord::Base
  FIELD_FORMATS = { "string" => { :name => :label_string, :order => 1 },
                    "text" => { :name => :label_text, :order => 2 },
                    "int" => { :name => :label_integer, :order => 3 },
                    "float" => { :name => :label_float, :order => 4 },
                    "list" => { :name => :label_list, :order => 5 },
                    "date" => { :name => :label_date, :order => 6 },
                    "bool" => { :name => :label_boolean, :order => 7 }
  }.freeze

  validates_inclusion_of :field_format, :in => FIELD_FORMATS.keys
end

# lib/redmine/custom_field_format.rb
module Redmine
  class CustomFieldFormat
    include Redmine::I18n

    cattr_accessor :available
    @@available = {}

    attr_accessor :name, :order, :label

    def initialize(name, options={})
      self.name = name
      self.label = options[:label]
      self.order = options[:order]
    end

    class << self
      def map(&block)
        yield self
      end
      
      # Registers a custom field format
      def register(custom_field_format, options={})
        @@available[custom_field_format.name] = custom_field_format unless @@available.keys.include?(custom_field_format.name)
      end

      def available_formats
        @@available.keys
      end
    end
  end 
end

# lib/redmine.rb
Redmine::CustomFieldFormat.map do |fields|
  fields.register Redmine::CustomFieldFormat.new('string', :label => :label_string, :order => 1)
  fields.register Redmine::CustomFieldFormat.new('text', :label => :label_text, :order => 2)
  fields.register Redmine::CustomFieldFormat.new('int', :label => :label_integer, :order => 3)
  fields.register Redmine::CustomFieldFormat.new('float', :label => :label_float, :order => 4)
  fields.register Redmine::CustomFieldFormat.new('list', :label => :label_list, :order => 5)
  fields.register Redmine::CustomFieldFormat.new('date', :label => :label_date, :order => 6)
  fields.register Redmine::CustomFieldFormat.new('bool', :label => :label_boolean, :order => 7)
end

# app/models/custom_field.rb
class CustomField < ActiveRecord::Base
  validates_inclusion_of :field_format, :in => Redmine::CustomFieldFormat.available_formats
end

# app/models/kanban_pane/active_pane.rb
class KanbanPane::ActivePane < KanbanPane
  def get_issues(options={})
    users = options.delete(:users)

    issues = {}
    users.each do |user|
      issues[user] = KanbanIssue.find_active(user.id)
    end unless users.blank?
    issues
  end
end

# app/models/kanban_pane/active_pane.rb
class KanbanPane::ActivePane < KanbanPane
  def get_issues(options={})
    users = options.delete(:users)

    users.inject({}) do |result, user|
      result[user] = KanbanIssue.find_active(user.id)
      result
    end
  end
end

# app/helpers/kanbans_helper.rb
module KanbansHelper
  def pane_configured?(pane)
    (@settings['panes'] && @settings['panes'][pane] && !@settings['panes'][pane]['status'].blank?)
  end

  def display_pane?(pane)
    if pane == 'quick-tasks'
      pane_configured?('backlog') &&
        @settings['panes']['quick-tasks']['limit'].present? &&
        @settings['panes']['quick-tasks']['limit'].to_i > 0
    else
      pane_configured?(pane)
    end
  end

  def column_configured?(column)
    case column
    when :unstaffed
      pane_configured?('incoming') || pane_configured?('backlog')
    when :selected
      display_pane?('quick-tasks') || pane_configured?('selected')
    when :staffed
      true # always
    end
  end

  # Calculates the width of the column.  Max of 96 since they need
  # some extra for the borders.
  def staffed_column_width(column)
    # weights of the columns
    column_ratios = {
      :user => 1,
      :active => 2,
      :testing => 2,
      :finished => 2,
      :canceled => 2
    }
    return 0.0 if column == :active && !pane_configured?(:active)
    return 0.0 if column == :testing && !pane_configured?(:testing)
    return 0.0 if column == :finished && !pane_configured?(:finished)
    return 0.0 if column == :canceled && !pane_configured?(:canceled)

    visible = 0
    visible += column_ratios[:user]
    visible += column_ratios[:active] if pane_configured?(:active)
    visible += column_ratios[:testing] if pane_configured?(:testing)
    visible += column_ratios[:finished] if pane_configured?(:finished)
    visible += column_ratios[:canceled] if pane_configured?(:canceled)
    
    return ((column_ratios[column].to_f / visible) * 96).round(2)
  end
end

# app/models/kanban_pane.rb
class KanbanPane
  # ...
end

# app/views/kanbans/show.html.erb
  <% if pane_configured?('incoming') || pane_configured?('backlog') %>
  <div id="unstaffed-requests" class="column" style="width: <%= column_width(:unstaffed) %>%">
    <% if pane_configured?('incoming') %>
    # ...
    <% end %>
    <% if pane_configured?('backlog') %>
    # ...
    <% end %>
  </div>
  <% end %>
  <% if display_pane?('quick-tasks') || pane_configured?('selected') %>
  <div id="selected-requests" class="column" style="width: <%= column_width(:selected) %>%">
    <% if display_pane?('quick-tasks') %>
    # ...
    <% end %>
    <% if pane_configured?('selected') %>
    # ...
    <% end %>
  </div>
  <% end %>

# app/helpers/kanbans_helper.rb
module KanbansHelper
  # pane_configured? removed

  # display_pane? removed

  def column_configured?(column)
    case column
    when :unstaffed
      KanbanPane::IncomingPane.configured? || KanbanPane::BacklogPane.configured?
    when :selected
      KanbanPane::QuickPane.configured? || KanbanPane::SelectedPane.configured?
    when :staffed
      true # always
    end
  end

  # Calculates the width of the column.  Max of 96 since they need
  # some extra for the borders.
  def staffed_column_width(column)
    # weights of the columns
    column_ratios = {
      :user => 1,
      :active => 2,
      :testing => 2,
      :finished => 2,
      :canceled => 2
    }
    return 0.0 if column == :active && !KanbanPane::ActivePane.configured?
    return 0.0 if column == :testing && !KanbanPane::TestingPane.configured?
    return 0.0 if column == :finished && !KanbanPane::FinishedPane.configured?
    return 0.0 if column == :canceled && !KanbanPane::CanceledPane.configured?

    visible = 0
    visible += column_ratios[:user]
    visible += column_ratios[:active] if KanbanPane::ActivePane.configured?
    visible += column_ratios[:testing] if KanbanPane::TestingPane.configured?
    visible += column_ratios[:finished] if KanbanPane::FinishedPane.configured?
    visible += column_ratios[:canceled] if KanbanPane::CanceledPane.configured?
    
    return ((column_ratios[column].to_f / visible) * 96).round(2)
  end
end

# app/models/kanban_pane.rb
class KanbanPane
  def self.pane_name
    self.to_s.demodulize.gsub(/pane/i, '').downcase
  end

  def self.configured?
    pane = self.pane_name
    (settings['panes'] && settings['panes'][pane] && !settings['panes'][pane]['status'].blank?)
  end
end

# app/views/kanbans/show.html.erb
  <% if KanbanPane::IncomingPane.configured? || KanbanPane::BacklogPane.configured? %>
  <div id="unstaffed-requests" class="column" style="width: <%= column_width(:unstaffed) %>%">
    <% if KanbanPane::IncomingPane.configured? %>
    <div id="incoming" class="pane">
      <%= render :partial => 'incoming' %>
    </div>
    <% end %>
    <% if KanbanPane::BacklogPane.configured? %>
    # ...
    <% end %>
  </div>
  <% end %>
  <% if KanbanPane::QuickPane.configured? || KanbanPane::SelectedPane.configured? %>
  <div id="selected-requests" class="column" style="width: <%= column_width(:selected) %>%">
    <% if KanbanPane::QuickPane.configured? %>
    # ...
    <% end %>
    <% if KanbanPane::SelectedPane.configured? %>
    # ...
    <% end %>
  </div>
  <% end %>

# app/models/kanban.rb
class Kanban
  # Sort and group a set of issues based on IssuePriority#position
  def group_by_priority_position(issues)
    return issues.group_by {|issue|
      issue.priority
    }.sort {|a,b|
      a[0].position <=> b[0].position
    }
  end

end

# app/models/kanban_pane.rb
class KanbanPane
  # ...
end

# app/models/kanban_pane/backlog_pane.rb
class KanbanPane::BacklogPane < KanbanPane
  def get_issues(options={})
    # ...

    # TODO: Remove wrapper
    kanban = Kanban.new
    return kanban.send(:group_by_priority_position, issues)
  end
end

# app/models/kanban_pane/quick_pane.rb
class KanbanPane::QuickPane < KanbanPane
  def get_issues(options={})
    # ...

    # TODO: Remove wrapper
    kanban = Kanban.new
    return kanban.send(:group_by_priority_position, issues)
  end
end

# app/models/kanban.rb
class Kanban
  # ...
end

# app/models/kanban_pane.rb
class KanbanPane
  # Sort and group a set of issues based on IssuePriority#position
  def group_by_priority_position(issues)
    return issues.group_by {|issue|
      issue.priority
    }.sort {|a,b|
      a[0].position <=> b[0].position
    }
  end
end

# app/models/kanban_pane/backlog_pane.rb
class KanbanPane::BacklogPane < KanbanPane
  def get_issues(options={})
    # ...
    return group_by_priority_position(issues)
  end
end

# app/models/kanban_pane/quick_pane.rb
class KanbanPane::QuickPane < KanbanPane
  def get_issues(options={})
    # ...
    return group_by_priority_position(issues)
  end
end

# app/models/kanban.rb
class Kanban
  def missing_settings(pane, options={})
    skip_status = options.delete(:skip_status)

    @settings.blank? ||
      @settings['panes'].blank? ||
      @settings['panes'][pane].blank? ||
      @settings['panes'][pane]['limit'].blank? ||
      (@settings['panes'][pane]['status'].blank? && !skip_status)
  end
end

# app/models/kanban_pane.rb
class KanbanPane
  # TODO: Wrapper until moved from Kanban
  def missing_settings(pane, options={})
    kanban = Kanban.new
    kanban.settings = Setting.plugin_redmine_kanban
    kanban.send(:missing_settings, pane, options)
  end
end

# app/models/kanban.rb
class Kanban
  # ...
end

# app/models/kanban_pane.rb
class KanbanPane
  def missing_settings(pane, options={})
    skip_status = options.delete(:skip_status)

    settings.blank? ||
      settings['panes'].blank? ||
      settings['panes'][pane].blank? ||
      settings['panes'][pane]['limit'].blank? ||
      (settings['panes'][pane]['status'].blank? && !skip_status)
  end
end

# app/models/kanban.rb
class Kanban
  def self.find
    Kanban.new
  end
end

# app/models/kanban.rb
class Kanban
  # ...
end

# app/models/kanban.rb
class Kanban
  def initialize
    @incoming_pane = KanbanPane::IncomingPane.new
    @backlog_pane = KanbanPane::BacklogPane.new
    @quick_pane = KanbanPane::QuickPane.new
    @canceled_pane = KanbanPane::CanceledPane.new
    @finished_pane = KanbanPane::FinishedPane.new
    @active_pane = KanbanPane::ActivePane.new
    @testing_pane = KanbanPane::TestingPane.new
  end

  def self.find
    kanban = Kanban.new
    kanban.settings = Setting.plugin_redmine_kanban
    kanban.users = kanban.get_users
    kanban.incoming_issues = kanban.incoming_pane.get_issues
    kanban.quick_issues = kanban.quick_pane.get_issues
    kanban.backlog_issues = kanban.backlog_pane.get_issues(:exclude_ids => kanban.quick_issue_ids)
    kanban.selected_issues = KanbanIssue.find_selected
    kanban.active_issues = kanban.active_pane.get_issues(:users => kanban.users)
    kanban.testing_issues = kanban.testing_pane.get_issues(:users => kanban.users)
    kanban.finished_issues = kanban.finished_pane.get_issues
    kanban.canceled_issues = kanban.canceled_pane.get_issues
    kanban
  end
end

# app/models/kanban.rb
class Kanban
  def initialize
    @incoming_pane = KanbanPane::IncomingPane.new
    @backlog_pane = KanbanPane::BacklogPane.new
    @quick_pane = KanbanPane::QuickPane.new
    @canceled_pane = KanbanPane::CanceledPane.new
    @finished_pane = KanbanPane::FinishedPane.new
    @active_pane = KanbanPane::ActivePane.new
    @testing_pane = KanbanPane::TestingPane.new

    @settings = Setting.plugin_redmine_kanban
    @users = get_users
  end

  def self.find
    Kanban.new
  end

  def incoming_issues
    @incoming_issues ||= incoming_pane.get_issues
  end

  def quick_issues
    @quick_issues ||= quick_pane.get_issues
  end

  def backlog_issues
    quick_issues # Needs to load quick_issues
    @backlog_issues ||= backlog_pane.get_issues(:exclude_ids => quick_issue_ids)
  end

  def selected_issues
    @selected_issues ||= KanbanIssue.find_selected
  end

  def active_issues
    @active_issues ||= active_pane.get_issues(:users => get_users)
  end

  def testing_issues
    @testing_issues ||= testing_pane.get_issues(:users => get_users)
  end

  def finished_issues
    @finished_issues ||= finished_pane.get_issues
  end

  def canceled_issues
    @canceled_issues ||= canceled_pane.get_issues
  end

end