##// END OF EJS Templates
jro_apps » redmine
RSS
Fixes #possible_values for version custom field....
Jean-Philippe Lang -
r5233:406aa946e52d
parent child
Show More
Side by Side Unified
Context file:
r5233:406aa946e52d Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,149 +1,149
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2011 Jean-Philippe Lang
3 3 #
4 4 # This program is free software; you can redistribute it and/or
5 5 # modify it under the terms of the GNU General Public License
6 6 # as published by the Free Software Foundation; either version 2
7 7 # of the License, or (at your option) any later version.
8 8 #
9 9 # This program is distributed in the hope that it will be useful,
10 10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 12 # GNU General Public License for more details.
13 13 #
14 14 # You should have received a copy of the GNU General Public License
15 15 # along with this program; if not, write to the Free Software
16 16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17 17
18 18 class CustomField < ActiveRecord::Base
19 19 has_many :custom_values, :dependent => :delete_all
20 20 acts_as_list :scope => 'type = \'#{self.class}\''
21 21 serialize :possible_values
22 22
23 23 validates_presence_of :name, :field_format
24 24 validates_uniqueness_of :name, :scope => :type
25 25 validates_length_of :name, :maximum => 30
26 26 validates_inclusion_of :field_format, :in => Redmine::CustomFieldFormat.available_formats
27 27
28 28 def initialize(attributes = nil)
29 29 super
30 30 self.possible_values ||= []
31 31 end
32 32
33 33 def before_validation
34 34 # make sure these fields are not searchable
35 35 self.searchable = false if %w(int float date bool).include?(field_format)
36 36 true
37 37 end
38 38
39 39 def validate
40 40 if self.field_format == "list"
41 41 errors.add(:possible_values, :blank) if self.possible_values.nil? || self.possible_values.empty?
42 42 errors.add(:possible_values, :invalid) unless self.possible_values.is_a? Array
43 43 end
44 44
45 45 # validate default value
46 46 v = CustomValue.new(:custom_field => self.clone, :value => default_value, :customized => nil)
47 47 v.custom_field.is_required = false
48 48 errors.add(:default_value, :invalid) unless v.valid?
49 49 end
50 50
51 51 def possible_values_options(obj=nil)
52 52 case field_format
53 53 when 'user', 'version'
54 54 if obj.respond_to?(:project) && obj.project
55 55 case field_format
56 56 when 'user'
57 57 obj.project.users.sort.collect {|u| [u.to_s, u.id.to_s]}
58 58 when 'version'
59 59 obj.project.versions.sort.collect {|u| [u.to_s, u.id.to_s]}
60 60 end
61 61 else
62 62 []
63 63 end
64 64 else
65 65 read_attribute :possible_values
66 66 end
67 67 end
68 68
69 69 def possible_values(obj=nil)
70 70 case field_format
71 when 'user'
71 when 'user', 'version'
72 72 possible_values_options(obj).collect(&:last)
73 73 else
74 74 read_attribute :possible_values
75 75 end
76 76 end
77 77
78 78 # Makes possible_values accept a multiline string
79 79 def possible_values=(arg)
80 80 if arg.is_a?(Array)
81 81 write_attribute(:possible_values, arg.compact.collect(&:strip).select {|v| !v.blank?})
82 82 else
83 83 self.possible_values = arg.to_s.split(/[\n\r]+/)
84 84 end
85 85 end
86 86
87 87 def cast_value(value)
88 88 casted = nil
89 89 unless value.blank?
90 90 case field_format
91 91 when 'string', 'text', 'list'
92 92 casted = value
93 93 when 'date'
94 94 casted = begin; value.to_date; rescue; nil end
95 95 when 'bool'
96 96 casted = (value == '1' ? true : false)
97 97 when 'int'
98 98 casted = value.to_i
99 99 when 'float'
100 100 casted = value.to_f
101 101 when 'user', 'version'
102 102 casted = (value.blank? ? nil : field_format.classify.constantize.find_by_id(value.to_i))
103 103 end
104 104 end
105 105 casted
106 106 end
107 107
108 108 # Returns a ORDER BY clause that can used to sort customized
109 109 # objects by their value of the custom field.
110 110 # Returns false, if the custom field can not be used for sorting.
111 111 def order_statement
112 112 case field_format
113 113 when 'string', 'text', 'list', 'date', 'bool'
114 114 # COALESCE is here to make sure that blank and NULL values are sorted equally
115 115 "COALESCE((SELECT cv_sort.value FROM #{CustomValue.table_name} cv_sort" +
116 116 " WHERE cv_sort.customized_type='#{self.class.customized_class.name}'" +
117 117 " AND cv_sort.customized_id=#{self.class.customized_class.table_name}.id" +
118 118 " AND cv_sort.custom_field_id=#{id} LIMIT 1), '')"
119 119 when 'int', 'float'
120 120 # Make the database cast values into numeric
121 121 # Postgresql will raise an error if a value can not be casted!
122 122 # CustomValue validations should ensure that it doesn't occur
123 123 "(SELECT CAST(cv_sort.value AS decimal(60,3)) FROM #{CustomValue.table_name} cv_sort" +
124 124 " WHERE cv_sort.customized_type='#{self.class.customized_class.name}'" +
125 125 " AND cv_sort.customized_id=#{self.class.customized_class.table_name}.id" +
126 126 " AND cv_sort.custom_field_id=#{id} AND cv_sort.value <> '' AND cv_sort.value IS NOT NULL LIMIT 1)"
127 127 else
128 128 nil
129 129 end
130 130 end
131 131
132 132 def <=>(field)
133 133 position <=> field.position
134 134 end
135 135
136 136 def self.customized_class
137 137 self.name =~ /^(.+)CustomField$/
138 138 begin; $1.constantize; rescue nil; end
139 139 end
140 140
141 141 # to move in project_custom_field
142 142 def self.for_all
143 143 find(:all, :conditions => ["is_for_all=?", true], :order => 'position')
144 144 end
145 145
146 146 def type_name
147 147 nil
148 148 end
149 149 end
General Comments 0
You need to be logged in to leave comments. Login now