custom_field.rb
121 lines
| 4.2 KiB
| text/x-ruby
|
RubyLexer
Jean-Philippe Lang
|
r330 | # redMine - project management software | ||
| # Copyright (C) 2006 Jean-Philippe Lang | ||||
| # | ||||
| # 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 CustomField < ActiveRecord::Base | ||||
| 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 | ||
| 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 | ||
|
Jean-Philippe Lang
|
r1759 | validates_format_of :name, :with => /^[\w\s\.\'\-]*$/i | ||
Eric Davis
|
r3558 | validates_inclusion_of :field_format, :in => Redmine::CustomFieldFormat.available_formats | ||
|
Jean-Philippe Lang
|
r330 | |||
| def initialize(attributes = nil) | ||||
| super | ||||
| self.possible_values ||= [] | ||||
|
Jean-Philippe Lang
|
r10 | end | ||
|
Jean-Philippe Lang
|
r330 | |||
| def before_validation | ||||
|
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
|
r983 | true | ||
|
Jean-Philippe Lang
|
r330 | end | ||
| def validate | ||||
| 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 | ||
|
Jean-Philippe Lang
|
r1076 | |||
| # validate default value | ||||
|
Jean-Philippe Lang
|
r1157 | v = CustomValue.new(:custom_field => self.clone, :value => default_value, :customized => nil) | ||
|
Jean-Philippe Lang
|
r1076 | v.custom_field.is_required = false | ||
|
Jean-Philippe Lang
|
r2430 | errors.add(:default_value, :invalid) unless v.valid? | ||
|
Jean-Philippe Lang
|
r330 | end | ||
|
Jean-Philippe Lang
|
r2255 | |||
|
Jean-Philippe Lang
|
r2265 | # Makes possible_values accept a multiline string | ||
| def possible_values=(arg) | ||||
| if arg.is_a?(Array) | ||||
| write_attribute(:possible_values, arg.compact.collect(&:strip).select {|v| !v.blank?}) | ||||
| else | ||||
| self.possible_values = arg.to_s.split(/[\n\r]+/) | ||||
| end | ||||
| end | ||||
|
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 | ||||
| end | ||||
| end | ||||
| casted | ||||
| end | ||||
|
Jean-Philippe Lang
|
r2255 | # Returns a ORDER BY clause that can used to sort customized | ||
| # objects by their value of the custom field. | ||||
| # Returns false, if the custom field can not be used for sorting. | ||||
| def order_statement | ||||
| 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 | ||
| "COALESCE((SELECT cv_sort.value FROM #{CustomValue.table_name} cv_sort" + | ||||
| " WHERE cv_sort.customized_type='#{self.class.customized_class.name}'" + | ||||
| " 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 | ||||
| "(SELECT CAST(cv_sort.value AS decimal(60,3)) FROM #{CustomValue.table_name} cv_sort" + | ||||
| " WHERE cv_sort.customized_type='#{self.class.customized_class.name}'" + | ||||
| " 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
|
r2255 | else | ||
| nil | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r330 | |||
|
Jean-Philippe Lang
|
r888 | def <=>(field) | ||
| position <=> field.position | ||||
| end | ||||
|
Jean-Philippe Lang
|
r2255 | def self.customized_class | ||
| self.name =~ /^(.+)CustomField$/ | ||||
| begin; $1.constantize; rescue nil; end | ||||
| end | ||||
|
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 | ||
| def type_name | ||||
| nil | ||||
| end | ||||
| end | ||||