Class: Redmine::FieldFormat::RecordList

Inherits:
List
  • Object
show all
Defined in:
lib/redmine/field_format.rb

Overview

Since:

  • 2.5.0

Direct Known Subclasses

EnumerationFormat, UserFormat, VersionFormat

Instance Method Summary collapse

Methods inherited from List

#bulk_edit_tag, #edit_tag, #query_filter_options

Methods inherited from Base

#before_custom_field_save, #bulk_edit_tag, #cast_custom_value, #cast_value, #edit_tag, field_attributes, #formatted_custom_value, #formatted_value, #label, #name, #possible_values_options, #query_filter_options, #validate_custom_field, #validate_custom_value, #validate_single_value, #value_from_keyword

Methods included from Helpers::URL

#uri_with_safe_scheme?

Methods included from I18n

#current_language, #day_letter, #day_name, #find_language, #format_date, #format_time, #l, #l_hours, #l_hours_short, #l_or_humanize, #languages_options, #ll, #lu, #month_name, #set_language_if_valid, #valid_languages

Instance Method Details

#cast_single_value(custom_field, value, customized = nil) ⇒ Object



656
657
658
# File 'lib/redmine/field_format.rb', line 656

def cast_single_value(custom_field, value, customized=nil)
  target_class.find_by_id(value.to_i) if value.present?
end

#group_statement(custom_field) ⇒ Object



683
684
685
# File 'lib/redmine/field_format.rb', line 683

def group_statement(custom_field)
  "COALESCE(#{join_alias custom_field}.value, '')"
end

#join_for_order_statement(custom_field) ⇒ Object



687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
# File 'lib/redmine/field_format.rb', line 687

def join_for_order_statement(custom_field)
  alias_name = join_alias(custom_field)

  "LEFT OUTER JOIN #{CustomValue.table_name} #{alias_name}" +
    " ON #{alias_name}.customized_type = '#{custom_field.class.customized_class.base_class.name}'" +
    " AND #{alias_name}.customized_id = #{custom_field.class.customized_class.table_name}.id" +
    " AND #{alias_name}.custom_field_id = #{custom_field.id}" +
    " AND (#{custom_field.visibility_by_project_condition})" +
    " AND #{alias_name}.value <> ''" +
    " AND #{alias_name}.id = (SELECT max(#{alias_name}_2.id) FROM #{CustomValue.table_name} #{alias_name}_2" +
      " WHERE #{alias_name}_2.customized_type = #{alias_name}.customized_type" +
      " AND #{alias_name}_2.customized_id = #{alias_name}.customized_id" +
      " AND #{alias_name}_2.custom_field_id = #{alias_name}.custom_field_id)" +
    " LEFT OUTER JOIN #{target_class.table_name} #{value_join_alias custom_field}" +
    " ON CAST(CASE #{alias_name}.value WHEN '' THEN '0' ELSE #{alias_name}.value END AS decimal(30,0)) = #{value_join_alias custom_field}.id"
end

#order_statement(custom_field) ⇒ Object



677
678
679
680
681
# File 'lib/redmine/field_format.rb', line 677

def order_statement(custom_field)
  if target_class.respond_to?(:fields_for_order_statement)
    target_class.fields_for_order_statement(value_join_alias(custom_field))
  end
end

#possible_custom_value_options(custom_value) ⇒ Object



668
669
670
671
672
673
674
675
# File 'lib/redmine/field_format.rb', line 668

def possible_custom_value_options(custom_value)
  options = possible_values_options(custom_value.custom_field, custom_value.customized)
  missing = [custom_value.value_was].flatten.reject(&:blank?) - options.map(&:last)
  if missing.any?
    options += target_class.where(:id => missing.map(&:to_i)).map {|o| [o.to_s, o.id.to_s]}
  end
  options
end

#reset_target_classObject

Since:

  • 2.6.0



664
665
666
# File 'lib/redmine/field_format.rb', line 664

def reset_target_class
  @target_class = nil
end

#target_classObject



660
661
662
# File 'lib/redmine/field_format.rb', line 660

def target_class
  @target_class ||= self.class.name[/^(.*::)?(.+)Format$/, 2].constantize rescue nil
end