custom_field.rb
292 lines
| 9.8 KiB
| text/x-ruby
|
RubyLexer
Jean-Philippe Lang
|
r5152 | # Redmine - project management software | ||
|
Jean-Philippe Lang
|
r8597 | # Copyright (C) 2006-2012 Jean-Philippe Lang | ||
|
Jean-Philippe Lang
|
r330 | # | ||
| # 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. | ||||
Toshi MARUYAMA
|
r6393 | # | ||
|
Jean-Philippe Lang
|
r330 | # 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. | ||||
|
Toshi MARUYAMA
|
r6393 | # | ||
|
Jean-Philippe Lang
|
r330 | # 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 CustomField < ActiveRecord::Base | ||||
|
Jean-Philippe Lang
|
r8063 | include Redmine::SubclassFactory | ||
|
Jean-Philippe Lang
|
r330 | has_many :custom_values, :dependent => :delete_all | ||
|
Jean-Philippe Lang
|
r888 | acts_as_list :scope => 'type = \'#{self.class}\'' | ||
|
Jean-Philippe Lang
|
r330 | serialize :possible_values | ||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r330 | validates_presence_of :name, :field_format | ||
|
Jean-Philippe Lang
|
r1729 | validates_uniqueness_of :name, :scope => :type | ||
|
Jean-Philippe Lang
|
r590 | validates_length_of :name, :maximum => 30 | ||
Eric Davis
|
r3558 | validates_inclusion_of :field_format, :in => Redmine::CustomFieldFormat.available_formats | ||
|
Jean-Philippe Lang
|
r330 | |||
|
Jean-Philippe Lang
|
r8597 | validate :validate_custom_field | ||
|
Toshi MARUYAMA
|
r8071 | before_validation :set_searchable | ||
|
Toshi MARUYAMA
|
r6792 | |||
|
Toshi MARUYAMA
|
r8071 | def set_searchable | ||
|
Jean-Philippe Lang
|
r981 | # make sure these fields are not searchable | ||
| self.searchable = false if %w(int float date bool).include?(field_format) | ||||
|
Jean-Philippe Lang
|
r8601 | # make sure only these fields can have multiple values | ||
| self.multiple = false unless %w(list user version).include?(field_format) | ||||
|
Jean-Philippe Lang
|
r983 | true | ||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r8597 | def validate_custom_field | ||
|
Jean-Philippe Lang
|
r330 | if self.field_format == "list" | ||
|
Jean-Philippe Lang
|
r2430 | errors.add(:possible_values, :blank) if self.possible_values.nil? || self.possible_values.empty? | ||
| errors.add(:possible_values, :invalid) unless self.possible_values.is_a? Array | ||||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r6178 | if regexp.present? | ||
| begin | ||||
| Regexp.new(regexp) | ||||
| rescue | ||||
| errors.add(:regexp, :invalid) | ||||
| end | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r8602 | if default_value.present? && !valid_field_value?(default_value) | ||
|
Jean-Philippe Lang
|
r8597 | errors.add(:default_value, :invalid) | ||
| end | ||||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r5152 | def possible_values_options(obj=nil) | ||
| case field_format | ||||
| when 'user', 'version' | ||||
|
Jean-Philippe Lang
|
r5153 | if obj.respond_to?(:project) && obj.project | ||
|
Jean-Philippe Lang
|
r5152 | case field_format | ||
| when 'user' | ||||
| obj.project.users.sort.collect {|u| [u.to_s, u.id.to_s]} | ||||
| when 'version' | ||||
|
Jean-Philippe Lang
|
r7652 | obj.project.shared_versions.sort.collect {|u| [u.to_s, u.id.to_s]} | ||
|
Jean-Philippe Lang
|
r5152 | end | ||
|
Jean-Philippe Lang
|
r5234 | elsif obj.is_a?(Array) | ||
|
Jean-Philippe Lang
|
r8707 | obj.collect {|o| possible_values_options(o)}.reduce(:&) | ||
|
Jean-Philippe Lang
|
r5152 | else | ||
| [] | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8704 | when 'bool' | ||
| [[l(:general_text_Yes), '1'], [l(:general_text_No), '0']] | ||||
|
Jean-Philippe Lang
|
r5152 | else | ||
|
Jean-Philippe Lang
|
r9346 | possible_values || [] | ||
|
Jean-Philippe Lang
|
r5152 | end | ||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r5152 | def possible_values(obj=nil) | ||
| case field_format | ||||
|
Jean-Philippe Lang
|
r5233 | when 'user', 'version' | ||
|
Jean-Philippe Lang
|
r5152 | possible_values_options(obj).collect(&:last) | ||
|
Jean-Philippe Lang
|
r8704 | when 'bool' | ||
| ['1', '0'] | ||||
|
Jean-Philippe Lang
|
r5152 | else | ||
|
Jean-Philippe Lang
|
r9346 | values = super() | ||
| if values.is_a?(Array) | ||||
| values.each do |value| | ||||
| value.force_encoding('UTF-8') if value.respond_to?(:force_encoding) | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r9723 | values || [] | ||
|
Jean-Philippe Lang
|
r5152 | end | ||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r2265 | # Makes possible_values accept a multiline string | ||
| def possible_values=(arg) | ||||
| if arg.is_a?(Array) | ||||
|
Jean-Philippe Lang
|
r9346 | super(arg.compact.collect(&:strip).select {|v| !v.blank?}) | ||
|
Jean-Philippe Lang
|
r2265 | else | ||
| self.possible_values = arg.to_s.split(/[\n\r]+/) | ||||
| end | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r2998 | def cast_value(value) | ||
| casted = nil | ||||
| unless value.blank? | ||||
| case field_format | ||||
| when 'string', 'text', 'list' | ||||
| casted = value | ||||
| when 'date' | ||||
| casted = begin; value.to_date; rescue; nil end | ||||
| when 'bool' | ||||
| casted = (value == '1' ? true : false) | ||||
| when 'int' | ||||
| casted = value.to_i | ||||
| when 'float' | ||||
| casted = value.to_f | ||||
|
Jean-Philippe Lang
|
r5152 | when 'user', 'version' | ||
| casted = (value.blank? ? nil : field_format.classify.constantize.find_by_id(value.to_i)) | ||||
|
Jean-Philippe Lang
|
r2998 | end | ||
| end | ||||
| casted | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r9974 | def value_from_keyword(keyword, customized) | ||
| possible_values_options = possible_values_options(customized) | ||||
| if possible_values_options.present? | ||||
| keyword = keyword.to_s.downcase | ||||
| possible_values_options.detect {|text, id| text.downcase == keyword}.try(:last) | ||||
| else | ||||
| keyword | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r2255 | # Returns a ORDER BY clause that can used to sort customized | ||
| # objects by their value of the custom field. | ||||
|
Jean-Philippe Lang
|
r9888 | # Returns nil if the custom field can not be used for sorting. | ||
|
Jean-Philippe Lang
|
r2255 | def order_statement | ||
|
Jean-Philippe Lang
|
r8601 | return nil if multiple? | ||
|
Jean-Philippe Lang
|
r2255 | case field_format | ||
|
Jean-Philippe Lang
|
r2256 | when 'string', 'text', 'list', 'date', 'bool' | ||
|
Jean-Philippe Lang
|
r2255 | # COALESCE is here to make sure that blank and NULL values are sorted equally | ||
|
Toshi MARUYAMA
|
r6393 | "COALESCE((SELECT cv_sort.value FROM #{CustomValue.table_name} cv_sort" + | ||
Etienne Massip
|
r9697 | " WHERE cv_sort.customized_type='#{self.class.customized_class.base_class.name}'" + | ||
|
Jean-Philippe Lang
|
r2255 | " AND cv_sort.customized_id=#{self.class.customized_class.table_name}.id" + | ||
| " AND cv_sort.custom_field_id=#{id} LIMIT 1), '')" | ||||
|
Jean-Philippe Lang
|
r2256 | when 'int', 'float' | ||
| # Make the database cast values into numeric | ||||
| # Postgresql will raise an error if a value can not be casted! | ||||
| # CustomValue validations should ensure that it doesn't occur | ||||
|
Toshi MARUYAMA
|
r6393 | "(SELECT CAST(cv_sort.value AS decimal(60,3)) FROM #{CustomValue.table_name} cv_sort" + | ||
|
Etienne Massip
|
r9697 | " WHERE cv_sort.customized_type='#{self.class.customized_class.base_class.name}'" + | ||
|
Jean-Philippe Lang
|
r2256 | " AND cv_sort.customized_id=#{self.class.customized_class.table_name}.id" + | ||
| " AND cv_sort.custom_field_id=#{id} AND cv_sort.value <> '' AND cv_sort.value IS NOT NULL LIMIT 1)" | ||||
|
Jean-Philippe Lang
|
r9890 | when 'user', 'version' | ||
| value_class.fields_for_order_statement(value_join_alias) | ||||
|
Jean-Philippe Lang
|
r2255 | else | ||
| nil | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r330 | |||
|
Jean-Philippe Lang
|
r9888 | # Returns a GROUP BY clause that can used to group by custom value | ||
| # Returns nil if the custom field can not be used for grouping. | ||||
| def group_statement | ||||
| return nil if multiple? | ||||
| case field_format | ||||
| when 'list', 'date', 'bool', 'int' | ||||
| order_statement | ||||
|
Jean-Philippe Lang
|
r9890 | when 'user', 'version' | ||
| "COALESCE((SELECT cv_sort.value FROM #{CustomValue.table_name} cv_sort" + | ||||
| " WHERE cv_sort.customized_type='#{self.class.customized_class.base_class.name}'" + | ||||
| " AND cv_sort.customized_id=#{self.class.customized_class.table_name}.id" + | ||||
| " AND cv_sort.custom_field_id=#{id} LIMIT 1), '')" | ||||
| else | ||||
| nil | ||||
| end | ||||
| end | ||||
| def join_for_order_statement | ||||
| case field_format | ||||
| when 'user', 'version' | ||||
| "LEFT OUTER JOIN #{CustomValue.table_name} #{join_alias}" + | ||||
| " ON #{join_alias}.customized_type = '#{self.class.customized_class.base_class.name}'" + | ||||
| " AND #{join_alias}.customized_id = #{self.class.customized_class.table_name}.id" + | ||||
| " AND #{join_alias}.custom_field_id = #{id}" + | ||||
| " AND #{join_alias}.value <> ''" + | ||||
| " AND #{join_alias}.id = (SELECT max(#{join_alias}_2.id) FROM #{CustomValue.table_name} #{join_alias}_2" + | ||||
| " WHERE #{join_alias}_2.customized_type = #{join_alias}.customized_type" + | ||||
| " AND #{join_alias}_2.customized_id = #{join_alias}.customized_id" + | ||||
| " AND #{join_alias}_2.custom_field_id = #{join_alias}.custom_field_id)" + | ||||
| " LEFT OUTER JOIN #{value_class.table_name} #{value_join_alias}" + | ||||
| " ON CAST(#{join_alias}.value as decimal(60,0)) = #{value_join_alias}.id" | ||||
|
Jean-Philippe Lang
|
r9888 | else | ||
| nil | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r9890 | def join_alias | ||
| "cf_#{id}" | ||||
| end | ||||
| def value_join_alias | ||||
| join_alias + "_" + field_format | ||||
| end | ||||
|
Jean-Philippe Lang
|
r888 | def <=>(field) | ||
| position <=> field.position | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r9890 | # Returns the class that values represent | ||
| def value_class | ||||
| case field_format | ||||
| when 'user', 'version' | ||||
| field_format.classify.constantize | ||||
| else | ||||
| nil | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r2255 | def self.customized_class | ||
| self.name =~ /^(.+)CustomField$/ | ||||
| begin; $1.constantize; rescue nil; end | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r330 | # to move in project_custom_field | ||
| def self.for_all | ||||
|
Jean-Philippe Lang
|
r1730 | find(:all, :conditions => ["is_for_all=?", true], :order => 'position') | ||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Toshi MARUYAMA
|
r6393 | |||
|
Jean-Philippe Lang
|
r330 | def type_name | ||
| nil | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8597 | |||
|
Jean-Philippe Lang
|
r8601 | # Returns the error messages for the given value | ||
|
Jean-Philippe Lang
|
r8597 | # or an empty array if value is a valid value for the custom field | ||
| def validate_field_value(value) | ||||
| errs = [] | ||||
|
Jean-Philippe Lang
|
r8601 | if value.is_a?(Array) | ||
| if !multiple? | ||||
| errs << ::I18n.t('activerecord.errors.messages.invalid') | ||||
| end | ||||
| if is_required? && value.detect(&:present?).nil? | ||||
| errs << ::I18n.t('activerecord.errors.messages.blank') | ||||
| end | ||||
| value.each {|v| errs += validate_field_value_format(v)} | ||||
| else | ||||
| if is_required? && value.blank? | ||||
| errs << ::I18n.t('activerecord.errors.messages.blank') | ||||
| end | ||||
| errs += validate_field_value_format(value) | ||||
|
Jean-Philippe Lang
|
r8597 | end | ||
| errs | ||||
| end | ||||
| # Returns true if value is a valid value for the custom field | ||||
| def valid_field_value?(value) | ||||
| validate_field_value(value).empty? | ||||
| end | ||||
|
Jean-Philippe Lang
|
r9980 | def format_in?(*args) | ||
| args.include?(field_format) | ||||
| end | ||||
|
Jean-Philippe Lang
|
r8597 | protected | ||
| # Returns the error message for the given value regarding its format | ||||
| def validate_field_value_format(value) | ||||
| errs = [] | ||||
| if value.present? | ||||
| errs << ::I18n.t('activerecord.errors.messages.invalid') unless regexp.blank? or value =~ Regexp.new(regexp) | ||||
| errs << ::I18n.t('activerecord.errors.messages.too_short', :count => min_length) if min_length > 0 and value.length < min_length | ||||
| errs << ::I18n.t('activerecord.errors.messages.too_long', :count => max_length) if max_length > 0 and value.length > max_length | ||||
| # Format specific validations | ||||
| case field_format | ||||
| when 'int' | ||||
| errs << ::I18n.t('activerecord.errors.messages.not_a_number') unless value =~ /^[+-]?\d+$/ | ||||
| when 'float' | ||||
| begin; Kernel.Float(value); rescue; errs << ::I18n.t('activerecord.errors.messages.invalid') end | ||||
| when 'date' | ||||
| errs << ::I18n.t('activerecord.errors.messages.not_a_date') unless value =~ /^\d{4}-\d{2}-\d{2}$/ && begin; value.to_date; rescue; false end | ||||
| when 'list' | ||||
| errs << ::I18n.t('activerecord.errors.messages.inclusion') unless possible_values.include?(value) | ||||
| end | ||||
| end | ||||
| errs | ||||
| end | ||||
|
Jean-Philippe Lang
|
r330 | end | ||