issue_query.rb 21.4 KB
Newer Older
1
# Redmine - project management software
jplang's avatar
jplang committed
2
# Copyright (C) 2006-2016  Jean-Philippe Lang
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
#
# 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 IssueQuery < Query

20
  self.queried_class = Issue
jplang's avatar
jplang committed
21
  self.view_permission = :view_issues
22

23
  self.available_columns = [
24
    QueryColumn.new(:id, :sortable => "#{Issue.table_name}.id", :default_order => 'desc', :caption => '#', :frozen => true),
25 26 27 28 29 30 31 32 33 34 35 36 37
    QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true),
    QueryColumn.new(:tracker, :sortable => "#{Tracker.table_name}.position", :groupable => true),
    QueryColumn.new(:parent, :sortable => ["#{Issue.table_name}.root_id", "#{Issue.table_name}.lft ASC"], :default_order => 'desc', :caption => :field_parent_issue),
    QueryColumn.new(:status, :sortable => "#{IssueStatus.table_name}.position", :groupable => true),
    QueryColumn.new(:priority, :sortable => "#{IssuePriority.table_name}.position", :default_order => 'desc', :groupable => true),
    QueryColumn.new(:subject, :sortable => "#{Issue.table_name}.subject"),
    QueryColumn.new(:author, :sortable => lambda {User.fields_for_order_statement("authors")}, :groupable => true),
    QueryColumn.new(:assigned_to, :sortable => lambda {User.fields_for_order_statement}, :groupable => true),
    QueryColumn.new(:updated_on, :sortable => "#{Issue.table_name}.updated_on", :default_order => 'desc'),
    QueryColumn.new(:category, :sortable => "#{IssueCategory.table_name}.name", :groupable => true),
    QueryColumn.new(:fixed_version, :sortable => lambda {Version.fields_for_order_statement}, :groupable => true),
    QueryColumn.new(:start_date, :sortable => "#{Issue.table_name}.start_date"),
    QueryColumn.new(:due_date, :sortable => "#{Issue.table_name}.due_date"),
38
    QueryColumn.new(:estimated_hours, :sortable => "#{Issue.table_name}.estimated_hours", :totalable => true),
39 40 41 42
    QueryColumn.new(:total_estimated_hours,
      :sortable => "COALESCE((SELECT SUM(estimated_hours) FROM #{Issue.table_name} subtasks" +
        " WHERE subtasks.root_id = #{Issue.table_name}.root_id AND subtasks.lft >= #{Issue.table_name}.lft AND subtasks.rgt <= #{Issue.table_name}.rgt), 0)",
      :default_order => 'desc'),
43 44
    QueryColumn.new(:done_ratio, :sortable => "#{Issue.table_name}.done_ratio", :groupable => true),
    QueryColumn.new(:created_on, :sortable => "#{Issue.table_name}.created_on", :default_order => 'desc'),
45
    QueryColumn.new(:closed_on, :sortable => "#{Issue.table_name}.closed_on", :default_order => 'desc'),
46 47 48 49 50 51 52 53 54
    QueryColumn.new(:relations, :caption => :label_related_issues),
    QueryColumn.new(:description, :inline => false)
  ]

  def initialize(attributes=nil, *args)
    super attributes
    self.filters ||= { 'status_id' => {:operator => "o", :values => [""]} }
  end

55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79
  def draw_relations
    r = options[:draw_relations]
    r.nil? || r == '1'
  end

  def draw_relations=(arg)
    options[:draw_relations] = (arg == '0' ? '0' : nil)
  end

  def draw_progress_line
    r = options[:draw_progress_line]
    r == '1'
  end

  def draw_progress_line=(arg)
    options[:draw_progress_line] = (arg == '1' ? '1' : nil)
  end

  def build_from_params(params)
    super
    self.draw_relations = params[:draw_relations] || (params[:query] && params[:query][:draw_relations])
    self.draw_progress_line = params[:draw_progress_line] || (params[:query] && params[:query][:draw_progress_line])
    self
  end

80 81
  def initialize_available_filters
    add_available_filter "status_id",
82 83 84 85 86
      :type => :list_status, :values => lambda { IssueStatus.sorted.collect{|s| [s.name, s.id.to_s] } }

    add_available_filter("project_id",
      :type => :list, :values => lambda { project_values }
    ) if project.nil?
87 88 89

    add_available_filter "tracker_id",
      :type => :list, :values => trackers.collect{|s| [s.name, s.id.to_s] }
90

91 92
    add_available_filter "priority_id",
      :type => :list, :values => IssuePriority.all.collect{|s| [s.name, s.id.to_s] }
93

94
    add_available_filter("author_id",
95 96
      :type => :list, :values => lambda { author_values }
    )
97 98

    add_available_filter("assigned_to_id",
99 100
      :type => :list_optional, :values => lambda { assigned_to_values }
    )
101

102
    add_available_filter("member_of_group",
103 104
      :type => :list_optional, :values => lambda { Group.givable.visible.collect {|g| [g.name, g.id.to_s] } }
    )
105

106
    add_available_filter("assigned_to_role",
107 108
      :type => :list_optional, :values => lambda { Role.givable.collect {|r| [r.name, r.id.to_s] } }
    )
109

110
    add_available_filter "fixed_version_id",
111
      :type => :list_optional, :values => lambda { fixed_version_values }
112

113 114 115 116 117 118 119
    add_available_filter "fixed_version.due_date",
      :type => :date,
      :name => l(:label_attribute_of_fixed_version, :name => l(:field_effective_date))

    add_available_filter "fixed_version.status",
      :type => :list,
      :name => l(:label_attribute_of_fixed_version, :name => l(:field_status)),
120
      :values => Version::VERSION_STATUSES.map{|s| [l("version_status_#{s}"), s] }
121

122 123
    add_available_filter "category_id",
      :type => :list_optional,
124
      :values => lambda { project.issue_categories.collect{|s| [s.name, s.id.to_s] } } if project
125 126

    add_available_filter "subject", :type => :text
127
    add_available_filter "description", :type => :text
128 129
    add_available_filter "created_on", :type => :date_past
    add_available_filter "updated_on", :type => :date_past
130
    add_available_filter "closed_on", :type => :date_past
131 132 133 134 135
    add_available_filter "start_date", :type => :date
    add_available_filter "due_date", :type => :date
    add_available_filter "estimated_hours", :type => :float
    add_available_filter "done_ratio", :type => :integer

136 137
    if User.current.allowed_to?(:set_issues_private, nil, :global => true) ||
      User.current.allowed_to?(:set_own_issues_private, nil, :global => true)
138 139
      add_available_filter "is_private",
        :type => :list,
140 141
        :values => [[l(:general_text_yes), "1"], [l(:general_text_no), "0"]]
    end
142 143 144 145 146 147

    if User.current.logged?
      add_available_filter "watcher_id",
        :type => :list, :values => [["<< #{l(:label_me)} >>", "me"]]
    end

148
    if project && !project.leaf?
149 150
      add_available_filter "subproject_id",
        :type => :list_subprojects,
151
        :values => lambda { subproject_values }
152 153
    end

154 155

    issue_custom_fields = project ? project.all_issue_custom_fields : IssueCustomField.where(:is_for_all => true)
156 157 158 159 160
    add_custom_fields_filters(issue_custom_fields)

    add_associations_custom_fields_filters :project, :author, :assigned_to, :fixed_version

    IssueRelation::TYPES.each do |relation_type, options|
161
      add_available_filter relation_type, :type => :relation, :label => options[:name], :values => lambda {all_projects_values}
162
    end
163 164
    add_available_filter "parent_id", :type => :tree, :label => :field_parent_issue
    add_available_filter "child_id", :type => :tree, :label => :label_subtask_plural
165

jplang's avatar
jplang committed
166 167
    add_available_filter "issue_id", :type => :integer, :label => :label_issue

168
    Tracker.disabled_core_fields(trackers).each {|field|
169
      delete_available_filter field
170 171 172 173 174 175 176 177
    }
  end

  def available_columns
    return @available_columns if @available_columns
    @available_columns = self.class.available_columns.dup
    @available_columns += (project ?
                            project.all_issue_custom_fields :
178 179
                            IssueCustomField
                           ).visible.collect {|cf| QueryCustomFieldColumn.new(cf) }
180 181

    if User.current.allowed_to?(:view_time_entries, project, :global => true)
182
      index = @available_columns.find_index {|column| column.name == :total_estimated_hours}
183
      index = (index ? index + 1 : -1)
184
      # insert the column after total_estimated_hours or at the end
185
      @available_columns.insert index, QueryColumn.new(:spent_hours,
186
        :sortable => "COALESCE((SELECT SUM(hours) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id), 0)",
187
        :default_order => 'desc',
188 189
        :caption => :label_spent_time,
        :totalable => true
190
      )
191 192 193 194 195 196
      @available_columns.insert index+1, QueryColumn.new(:total_spent_hours,
        :sortable => "COALESCE((SELECT SUM(hours) FROM #{TimeEntry.table_name} JOIN #{Issue.table_name} subtasks ON subtasks.id = #{TimeEntry.table_name}.issue_id" +
          " WHERE subtasks.root_id = #{Issue.table_name}.root_id AND subtasks.lft >= #{Issue.table_name}.lft AND subtasks.rgt <= #{Issue.table_name}.rgt), 0)",
        :default_order => 'desc',
        :caption => :label_total_spent_time
      )
197 198 199 200 201 202 203 204 205 206 207 208 209 210 211
    end

    if User.current.allowed_to?(:set_issues_private, nil, :global => true) ||
      User.current.allowed_to?(:set_own_issues_private, nil, :global => true)
      @available_columns << QueryColumn.new(:is_private, :sortable => "#{Issue.table_name}.is_private")
    end

    disabled_fields = Tracker.disabled_core_fields(trackers).map {|field| field.sub(/_id$/, '')}
    @available_columns.reject! {|column|
      disabled_fields.include?(column.name.to_s)
    }

    @available_columns
  end

212 213 214 215 216 217 218 219
  def default_columns_names
    @default_columns_names ||= begin
      default_columns = Setting.issue_list_default_columns.map(&:to_sym)

      project.present? ? default_columns : [:project] | default_columns
    end
  end

jplang's avatar
jplang committed
220 221 222 223
  def default_totalable_names
    Setting.issue_list_default_totals.map(&:to_sym)
  end

224 225 226 227
  def base_scope
    Issue.visible.joins(:status, :project).where(statement)
  end

228 229
  # Returns the issue count
  def issue_count
230
    base_scope.count
231 232 233 234
  rescue ::ActiveRecord::StatementInvalid => e
    raise StatementInvalid.new(e.message)
  end

235 236 237 238 239
  # Returns the issue count by group or nil if query is not grouped
  def issue_count_by_group
    grouped_query do |scope|
      scope.count
    end
240 241
  end

242 243
  # Returns sum of all the issue's estimated_hours
  def total_for_estimated_hours(scope)
244
    map_total(scope.sum(:estimated_hours)) {|t| t.to_f.round(2)}
245 246
  end

247 248
  # Returns sum of all the issue's time entries hours
  def total_for_spent_hours(scope)
249
    total = if group_by_column.try(:name) == :project
250 251 252 253 254 255 256 257
      # TODO: remove this when https://github.com/rails/rails/issues/21922 is fixed
      # We have to do a custom join without the time_entries.project_id column
      # that would trigger a ambiguous column name error
      scope.joins("JOIN (SELECT issue_id, hours FROM #{TimeEntry.table_name}) AS joined_time_entries ON joined_time_entries.issue_id = #{Issue.table_name}.id").
        sum("joined_time_entries.hours")
    else
      scope.joins(:time_entries).sum("#{TimeEntry.table_name}.hours")
    end
258
    map_total(total) {|t| t.to_f.round(2)}
259 260 261 262 263
  end

  # Returns the issues
  # Valid options are :order, :offset, :limit, :include, :conditions
  def issues(options={})
264
    order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)
265

266
    scope = Issue.visible.
267 268 269 270 271 272 273
      joins(:status, :project).
      where(statement).
      includes(([:status, :project] + (options[:include] || [])).uniq).
      where(options[:conditions]).
      order(order_option).
      joins(joins_for_order_statement(order_option.join(','))).
      limit(options[:limit]).
274 275
      offset(options[:offset])

276
    scope = scope.preload(:custom_values)
277 278 279
    if has_column?(:author)
      scope = scope.preload(:author)
    end
280

jplang's avatar
jplang committed
281
    issues = scope.to_a
282 283 284 285

    if has_column?(:spent_hours)
      Issue.load_visible_spent_hours(issues)
    end
286 287 288
    if has_column?(:total_spent_hours)
      Issue.load_visible_total_spent_hours(issues)
    end
289 290 291 292 293 294 295 296 297 298
    if has_column?(:relations)
      Issue.load_visible_relations(issues)
    end
    issues
  rescue ::ActiveRecord::StatementInvalid => e
    raise StatementInvalid.new(e.message)
  end

  # Returns the issues ids
  def issue_ids(options={})
299
    order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)
300

301 302 303 304
    Issue.visible.
      joins(:status, :project).
      where(statement).
      includes(([:status, :project] + (options[:include] || [])).uniq).
jplang's avatar
jplang committed
305
      references(([:status, :project] + (options[:include] || [])).uniq).
306 307 308 309 310
      where(options[:conditions]).
      order(order_option).
      joins(joins_for_order_statement(order_option.join(','))).
      limit(options[:limit]).
      offset(options[:offset]).
jplang's avatar
jplang committed
311
      pluck(:id)
312 313 314 315 316 317 318
  rescue ::ActiveRecord::StatementInvalid => e
    raise StatementInvalid.new(e.message)
  end

  # Returns the journals
  # Valid options are :order, :offset, :limit
  def journals(options={})
319 320 321 322 323 324 325
    Journal.visible.
      joins(:issue => [:project, :status]).
      where(statement).
      order(options[:order]).
      limit(options[:limit]).
      offset(options[:offset]).
      preload(:details, :user, {:issue => [:project, :author, :tracker, :status]}).
jplang's avatar
jplang committed
326
      to_a
327 328 329 330 331 332 333
  rescue ::ActiveRecord::StatementInvalid => e
    raise StatementInvalid.new(e.message)
  end

  # Returns the versions
  # Valid options are :conditions
  def versions(options={})
334 335 336 337
    Version.visible.
      where(project_statement).
      where(options[:conditions]).
      includes(:project).
jplang's avatar
jplang committed
338 339
      references(:project).
      to_a
340 341 342
  rescue ::ActiveRecord::StatementInvalid => e
    raise StatementInvalid.new(e.message)
  end
343 344 345 346 347 348 349 350 351

  def sql_for_watcher_id_field(field, operator, value)
    db_table = Watcher.table_name
    "#{Issue.table_name}.id #{ operator == '=' ? 'IN' : 'NOT IN' } (SELECT #{db_table}.watchable_id FROM #{db_table} WHERE #{db_table}.watchable_type='Issue' AND " +
      sql_for_field(field, '=', value, db_table, 'user_id') + ')'
  end

  def sql_for_member_of_group_field(field, operator, value)
    if operator == '*' # Any group
352
      groups = Group.givable
353 354
      operator = '=' # Override the operator since we want to find by assigned_to
    elsif operator == "!*"
355
      groups = Group.givable
356 357
      operator = '!' # Override the operator since we want to find by assigned_to
    else
jplang's avatar
jplang committed
358
      groups = Group.where(:id => value).to_a
359 360 361 362
    end
    groups ||= []

    members_of_groups = groups.inject([]) {|user_ids, group|
jplang's avatar
jplang committed
363 364
      user_ids + group.user_ids + [group.id]
    }.uniq.compact.sort.collect(&:to_s)
365 366 367 368 369 370 371 372 373 374 375 376 377

    '(' + sql_for_field("assigned_to_id", operator, members_of_groups, Issue.table_name, "assigned_to_id", false) + ')'
  end

  def sql_for_assigned_to_role_field(field, operator, value)
    case operator
    when "*", "!*" # Member / Not member
      sw = operator == "!*" ? 'NOT' : ''
      nl = operator == "!*" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : ''
      "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (SELECT DISTINCT #{Member.table_name}.user_id FROM #{Member.table_name}" +
        " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id))"
    when "=", "!"
      role_cond = value.any? ?
jplang's avatar
jplang committed
378
        "#{MemberRole.table_name}.role_id IN (" + value.collect{|val| "'#{self.class.connection.quote_string(val)}'"}.join(",") + ")" :
379 380 381 382 383 384 385 386 387
        "1=0"

      sw = operator == "!" ? 'NOT' : ''
      nl = operator == "!" ? "#{Issue.table_name}.assigned_to_id IS NULL OR" : ''
      "(#{nl} #{Issue.table_name}.assigned_to_id #{sw} IN (SELECT DISTINCT #{Member.table_name}.user_id FROM #{Member.table_name}, #{MemberRole.table_name}" +
        " WHERE #{Member.table_name}.project_id = #{Issue.table_name}.project_id AND #{Member.table_name}.id = #{MemberRole.table_name}.member_id AND #{role_cond}))"
    end
  end

388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403
  def sql_for_fixed_version_status_field(field, operator, value)
    where = sql_for_field(field, operator, value, Version.table_name, "status")
    version_ids = versions(:conditions => [where]).map(&:id)

    nl = operator == "!" ? "#{Issue.table_name}.fixed_version_id IS NULL OR" : ''
    "(#{nl} #{sql_for_field("fixed_version_id", "=", version_ids, Issue.table_name, "fixed_version_id")})"
  end

  def sql_for_fixed_version_due_date_field(field, operator, value)
    where = sql_for_field(field, operator, value, Version.table_name, "effective_date")
    version_ids = versions(:conditions => [where]).map(&:id)

    nl = operator == "!*" ? "#{Issue.table_name}.fixed_version_id IS NULL OR" : ''
    "(#{nl} #{sql_for_field("fixed_version_id", "=", version_ids, Issue.table_name, "fixed_version_id")})"
  end

404 405
  def sql_for_is_private_field(field, operator, value)
    op = (operator == "=" ? 'IN' : 'NOT IN')
jplang's avatar
jplang committed
406
    va = value.map {|v| v == '0' ? self.class.connection.quoted_false : self.class.connection.quoted_true}.uniq.join(',')
407 408 409 410

    "#{Issue.table_name}.is_private #{op} (#{va})"
  end

411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451
  def sql_for_parent_id_field(field, operator, value)
    case operator
    when "="
      "#{Issue.table_name}.parent_id = #{value.first.to_i}"
    when "~"
      root_id, lft, rgt = Issue.where(:id => value.first.to_i).pluck(:root_id, :lft, :rgt).first
      if root_id && lft && rgt
        "#{Issue.table_name}.root_id = #{root_id} AND #{Issue.table_name}.lft > #{lft} AND #{Issue.table_name}.rgt < #{rgt}"
      else
        "1=0"
      end
    when "!*"
      "#{Issue.table_name}.parent_id IS NULL"
    when "*"
      "#{Issue.table_name}.parent_id IS NOT NULL"
    end
  end

  def sql_for_child_id_field(field, operator, value)
    case operator
    when "="
      parent_id = Issue.where(:id => value.first.to_i).pluck(:parent_id).first
      if parent_id
        "#{Issue.table_name}.id = #{parent_id}"
      else
        "1=0"
      end
    when "~"
      root_id, lft, rgt = Issue.where(:id => value.first.to_i).pluck(:root_id, :lft, :rgt).first
      if root_id && lft && rgt
        "#{Issue.table_name}.root_id = #{root_id} AND #{Issue.table_name}.lft < #{lft} AND #{Issue.table_name}.rgt > #{rgt}"
      else
        "1=0"
      end
    when "!*"
      "#{Issue.table_name}.rgt - #{Issue.table_name}.lft = 1"
    when "*"
      "#{Issue.table_name}.rgt - #{Issue.table_name}.lft > 1"
    end
  end

jplang's avatar
jplang committed
452
  def sql_for_issue_id_field(field, operator, value)
453 454 455 456 457 458 459 460
    if operator == "="
      # accepts a comma separated list of ids
      ids = value.first.to_s.scan(/\d+/).map(&:to_i)
      if ids.present?
        "#{Issue.table_name}.id IN (#{ids.join(",")})"
      else
        "1=0"
      end
jplang's avatar
jplang committed
461
    else
462
      sql_for_field("id", operator, value, Issue.table_name, "id")
jplang's avatar
jplang committed
463 464 465
    end
  end

466 467 468 469 470 471 472 473 474 475 476 477 478 479
  def sql_for_relations(field, operator, value, options={})
    relation_options = IssueRelation::TYPES[field]
    return relation_options unless relation_options

    relation_type = field
    join_column, target_join_column = "issue_from_id", "issue_to_id"
    if relation_options[:reverse] || options[:reverse]
      relation_type = relation_options[:reverse] || relation_type
      join_column, target_join_column = target_join_column, join_column
    end

    sql = case operator
      when "*", "!*"
        op = (operator == "*" ? 'IN' : 'NOT IN')
jplang's avatar
jplang committed
480
        "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name} WHERE #{IssueRelation.table_name}.relation_type = '#{self.class.connection.quote_string(relation_type)}')"
481 482
      when "=", "!"
        op = (operator == "=" ? 'IN' : 'NOT IN')
jplang's avatar
jplang committed
483
        "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name} WHERE #{IssueRelation.table_name}.relation_type = '#{self.class.connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = #{value.first.to_i})"
484 485 486
      when "=p", "=!p", "!p"
        op = (operator == "!p" ? 'NOT IN' : 'IN')
        comp = (operator == "=!p" ? '<>' : '=')
jplang's avatar
jplang committed
487
        "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{self.class.connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.project_id #{comp} #{value.first.to_i})"
488 489 490
      when "*o", "!o"
        op = (operator == "!o" ? 'NOT IN' : 'IN')
        "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{self.class.connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.status_id IN (SELECT id FROM #{IssueStatus.table_name} WHERE is_closed=#{self.class.connection.quoted_false}))"
491 492 493 494
      end

    if relation_options[:sym] == field && !options[:reverse]
      sqls = [sql, sql_for_relations(field, operator, value, :reverse => true)]
495
      sql = sqls.join(["!", "!*", "!p"].include?(operator) ? " AND " : " OR ")
496
    end
497
    "(#{sql})"
498 499
  end

500 501 502 503 504
  def find_assigned_to_id_filter_values(values)
    Principal.visible.where(:id => values).map {|p| [p.name, p.id.to_s]}
  end
  alias :find_author_id_filter_values :find_assigned_to_id_filter_values

505 506 507
  IssueRelation::TYPES.keys.each do |relation_type|
    alias_method "sql_for_#{relation_type}_field".to_sym, :sql_for_relations
  end
508 509 510 511 512 513 514 515 516 517 518 519

  def joins_for_order_statement(order_options)
    joins = [super]

    if order_options
      if order_options.include?('authors')
        joins << "LEFT OUTER JOIN #{User.table_name} authors ON authors.id = #{queried_table_name}.author_id"
      end
    end

    joins.any? ? joins.join(' ') : nil
  end
520
end