##// END OF EJS Templates
jro_apps » redmine
RSS
Removed default values on custom field min and max length....
Jean-Philippe Lang -
r12130:e715c4b847a8
parent child
Show More
Side by Side Unified
Context file:
r12130:e715c4b847a8 Loading diff...:
Show file before | Show file after | Hide comments
@@ -0,0 +1,15
1 class RemoveCustomFieldsMinMaxLengthDefaultValues < ActiveRecord::Migration
2 def up
3 change_column :custom_fields, :min_length, :int, :default => nil, :null => true
4 change_column :custom_fields, :max_length, :int, :default => nil, :null => true
5 CustomField.where(:min_length => 0).update_all(:min_length => nil)
6 CustomField.where(:max_length => 0).update_all(:max_length => nil)
7 end
8
9 def self.down
10 CustomField.where(:min_length => nil).update_all(:min_length => 0)
11 CustomField.where(:max_length => nil).update_all(:max_length => 0)
12 change_column :custom_fields, :min_length, :int, :default => 0, :null => false
13 change_column :custom_fields, :max_length, :int, :default => 0, :null => false
14 end
15 end
Show file before | Show file after | Hide comments
@@ -1,10 +1,9
1 1 <p>
2 2 <label for="custom_field_min_length"><%=l(:label_min_max_length)%></label>
3 3 <%= f.text_field :min_length, :size => 5, :no_label => true %> -
4 4 <%= f.text_field :max_length, :size => 5, :no_label => true %>
5 <em class="info"><%= l(:text_min_max_length_info) %></em>
6 5 </p>
7 6 <p>
8 7 <%= f.text_field :regexp, :size => 50 %>
9 8 <em class="info"><%= l(:text_regexp_info) %></em>
10 9 </p>
Show file before | Show file after | Hide comments
@@ -1,43 +1,43
1 1 api.array :custom_fields do
2 2 @custom_fields.each do |field|
3 3 api.custom_field do
4 4 api.id field.id
5 5 api.name field.name
6 6 api.customized_type field.class.customized_class.name.underscore if field.class.customized_class
7 7 api.field_format field.field_format
8 8 api.regexp field.regexp
9 api.min_length (field.min_length == 0 ? nil : field.min_length)
10 api.max_length (field.max_length == 0 ? nil : field.max_length)
9 api.min_length field.min_length
10 api.max_length field.max_length
11 11 api.is_required field.is_required?
12 12 api.is_filter field.is_filter?
13 13 api.searchable field.searchable
14 14 api.multiple field.multiple?
15 15 api.default_value field.default_value
16 16 api.visible field.visible?
17 17
18 18 values = field.possible_values_options
19 19 if values.present?
20 20 api.array :possible_values do
21 21 values.each do |label, value|
22 22 api.possible_value do
23 23 api.value value || label
24 24 end
25 25 end
26 26 end
27 27 end
28 28
29 29 if field.is_a?(IssueCustomField)
30 30 api.trackers do
31 31 field.trackers.each do |tracker|
32 32 api.tracker :id => tracker.id, :name => tracker.name
33 33 end
34 34 end
35 35 api.roles do
36 36 field.roles.each do |role|
37 37 api.role :id => role.id, :name => role.name
38 38 end
39 39 end
40 40 end
41 41 end
42 42 end
43 43 end
Show file before | Show file after | Hide comments
@@ -1,650 +1,650
1 1 # Redmine - project management software
2 2 # Copyright (C) 2006-2013 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 module Redmine
19 19 module FieldFormat
20 20 def self.add(name, klass)
21 21 all[name.to_s] = klass.instance
22 22 end
23 23
24 24 def self.delete(name)
25 25 all.delete(name.to_s)
26 26 end
27 27
28 28 def self.all
29 29 @formats ||= Hash.new(Base.instance)
30 30 end
31 31
32 32 def self.available_formats
33 33 all.keys
34 34 end
35 35
36 36 def self.find(name)
37 37 all[name.to_s]
38 38 end
39 39
40 40 # Return an array of custom field formats which can be used in select_tag
41 41 def self.as_select(class_name=nil)
42 42 formats = all.values.select do |format|
43 43 format.class.customized_class_names.nil? || format.class.customized_class_names.include?(class_name)
44 44 end
45 45 formats.map {|format| [::I18n.t(format.label), format.name] }.sort_by(&:first)
46 46 end
47 47
48 48 class Base
49 49 include Singleton
50 50 include Redmine::I18n
51 51 include ERB::Util
52 52
53 53 class_attribute :format_name
54 54 self.format_name = nil
55 55
56 56 # Set this to true if the format supports multiple values
57 57 class_attribute :multiple_supported
58 58 self.multiple_supported = false
59 59
60 60 # Set this to true if the format supports textual search on custom values
61 61 class_attribute :searchable_supported
62 62 self.searchable_supported = false
63 63
64 64 # Restricts the classes that the custom field can be added to
65 65 # Set to nil for no restrictions
66 66 class_attribute :customized_class_names
67 67 self.customized_class_names = nil
68 68
69 69 # Name of the partial for editing the custom field
70 70 class_attribute :form_partial
71 71 self.form_partial = nil
72 72
73 73 def self.add(name)
74 74 self.format_name = name
75 75 Redmine::FieldFormat.add(name, self)
76 76 end
77 77 private_class_method :add
78 78
79 79 def self.field_attributes(*args)
80 80 CustomField.store_accessor :format_store, *args
81 81 end
82 82
83 83 def name
84 84 self.class.format_name
85 85 end
86 86
87 87 def label
88 88 "label_#{name}"
89 89 end
90 90
91 91 def cast_custom_value(custom_value)
92 92 cast_value(custom_value.custom_field, custom_value.value, custom_value.customized)
93 93 end
94 94
95 95 def cast_value(custom_field, value, customized=nil)
96 96 if value.blank?
97 97 nil
98 98 elsif value.is_a?(Array)
99 99 value.map do |v|
100 100 cast_single_value(custom_field, v, customized)
101 101 end.sort
102 102 else
103 103 cast_single_value(custom_field, value, customized)
104 104 end
105 105 end
106 106
107 107 def cast_single_value(custom_field, value, customized=nil)
108 108 value.to_s
109 109 end
110 110
111 111 def target_class
112 112 nil
113 113 end
114 114
115 115 def possible_custom_value_options(custom_value)
116 116 possible_values_options(custom_value.custom_field, custom_value.customized)
117 117 end
118 118
119 119 def possible_values_options(custom_field, object=nil)
120 120 []
121 121 end
122 122
123 123 # Returns the validation errors for custom_field
124 124 # Should return an empty array if custom_field is valid
125 125 def validate_custom_field(custom_field)
126 126 []
127 127 end
128 128
129 129 # Returns the validation error messages for custom_value
130 130 # Should return an empty array if custom_value is valid
131 131 def validate_custom_value(custom_value)
132 132 errors = Array.wrap(custom_value.value).reject(&:blank?).map do |value|
133 133 validate_single_value(custom_value.custom_field, value, custom_value.customized)
134 134 end
135 135 errors.flatten.uniq
136 136 end
137 137
138 138 def validate_single_value(custom_field, value, customized=nil)
139 139 []
140 140 end
141 141
142 142 def formatted_custom_value(view, custom_value, html=false)
143 143 formatted_value(view, custom_value.custom_field, custom_value.value, custom_value.customized, html)
144 144 end
145 145
146 146 def formatted_value(view, custom_field, value, customized=nil, html=false)
147 147 cast_value(custom_field, value, customized)
148 148 end
149 149
150 150 def edit_tag(view, tag_id, tag_name, custom_value, options={})
151 151 view.text_field_tag(tag_name, custom_value.value, options.merge(:id => tag_id))
152 152 end
153 153
154 154 def bulk_edit_tag(view, tag_id, tag_name, custom_field, objects, value, options={})
155 155 view.text_field_tag(tag_name, value, options.merge(:id => tag_id)) +
156 156 bulk_clear_tag(view, tag_id, tag_name, custom_field, value)
157 157 end
158 158
159 159 def bulk_clear_tag(view, tag_id, tag_name, custom_field, value)
160 160 if custom_field.is_required?
161 161 ''.html_safe
162 162 else
163 163 view.content_tag('label',
164 164 view.check_box_tag(tag_name, '__none__', (value == '__none__'), :id => nil, :data => {:disables => "##{tag_id}"}) + l(:button_clear),
165 165 :class => 'inline'
166 166 )
167 167 end
168 168 end
169 169 protected :bulk_clear_tag
170 170
171 171 def query_filter_options(custom_field, query)
172 172 {:type => :string}
173 173 end
174 174
175 175 def before_custom_field_save(custom_field)
176 176 end
177 177
178 178 # Returns a ORDER BY clause that can used to sort customized
179 179 # objects by their value of the custom field.
180 180 # Returns nil if the custom field can not be used for sorting.
181 181 def order_statement(custom_field)
182 182 # COALESCE is here to make sure that blank and NULL values are sorted equally
183 183 "COALESCE(#{join_alias custom_field}.value, '')"
184 184 end
185 185
186 186 # Returns a GROUP BY clause that can used to group by custom value
187 187 # Returns nil if the custom field can not be used for grouping.
188 188 def group_statement(custom_field)
189 189 nil
190 190 end
191 191
192 192 # Returns a JOIN clause that is added to the query when sorting by custom values
193 193 def join_for_order_statement(custom_field)
194 194 alias_name = join_alias(custom_field)
195 195
196 196 "LEFT OUTER JOIN #{CustomValue.table_name} #{alias_name}" +
197 197 " ON #{alias_name}.customized_type = '#{custom_field.class.customized_class.base_class.name}'" +
198 198 " AND #{alias_name}.customized_id = #{custom_field.class.customized_class.table_name}.id" +
199 199 " AND #{alias_name}.custom_field_id = #{custom_field.id}" +
200 200 " AND (#{custom_field.visibility_by_project_condition})" +
201 201 " AND #{alias_name}.value <> ''" +
202 202 " AND #{alias_name}.id = (SELECT max(#{alias_name}_2.id) FROM #{CustomValue.table_name} #{alias_name}_2" +
203 203 " WHERE #{alias_name}_2.customized_type = #{alias_name}.customized_type" +
204 204 " AND #{alias_name}_2.customized_id = #{alias_name}.customized_id" +
205 205 " AND #{alias_name}_2.custom_field_id = #{alias_name}.custom_field_id)"
206 206 end
207 207
208 208 def join_alias(custom_field)
209 209 "cf_#{custom_field.id}"
210 210 end
211 211 protected :join_alias
212 212 end
213 213
214 214 class Unbounded < Base
215 215 def validate_single_value(custom_field, value, customized=nil)
216 216 errs = super
217 217 if value.present?
218 218 unless custom_field.regexp.blank? or value =~ Regexp.new(custom_field.regexp)
219 219 errs << ::I18n.t('activerecord.errors.messages.invalid')
220 220 end
221 if custom_field.min_length > 0 and value.length < custom_field.min_length
221 if custom_field.min_length && value.length < custom_field.min_length
222 222 errs << ::I18n.t('activerecord.errors.messages.too_short', :count => custom_field.min_length)
223 223 end
224 if custom_field.max_length > 0 and value.length > custom_field.max_length
224 if custom_field.max_length && custom_field.max_length > 0 && value.length > custom_field.max_length
225 225 errs << ::I18n.t('activerecord.errors.messages.too_long', :count => custom_field.max_length)
226 226 end
227 227 end
228 228 errs
229 229 end
230 230 end
231 231
232 232 class StringFormat < Unbounded
233 233 add 'string'
234 234 self.searchable_supported = true
235 235 self.form_partial = 'custom_fields/formats/string'
236 236 field_attributes :text_formatting
237 237
238 238 def formatted_value(view, custom_field, value, customized=nil, html=false)
239 239 if html && custom_field.text_formatting == 'full'
240 240 view.textilizable(value, :object => customized)
241 241 else
242 242 value.to_s
243 243 end
244 244 end
245 245 end
246 246
247 247 class TextFormat < Unbounded
248 248 add 'text'
249 249 self.searchable_supported = true
250 250 self.form_partial = 'custom_fields/formats/text'
251 251
252 252 def formatted_value(view, custom_field, value, customized=nil, html=false)
253 253 if html
254 254 if custom_field.text_formatting == 'full'
255 255 view.textilizable(value, :object => customized)
256 256 else
257 257 view.simple_format(html_escape(value))
258 258 end
259 259 else
260 260 value.to_s
261 261 end
262 262 end
263 263
264 264 def edit_tag(view, tag_id, tag_name, custom_value, options={})
265 265 view.text_area_tag(tag_name, custom_value.value, options.merge(:id => tag_id, :rows => 3))
266 266 end
267 267
268 268 def bulk_edit_tag(view, tag_id, tag_name, custom_field, objects, value, options={})
269 269 view.text_area_tag(tag_name, value, options.merge(:id => tag_id, :rows => 3)) +
270 270 '<br />'.html_safe +
271 271 bulk_clear_tag(view, tag_id, tag_name, custom_field, value)
272 272 end
273 273
274 274 def query_filter_options(custom_field, query)
275 275 {:type => :text}
276 276 end
277 277 end
278 278
279 279 class LinkFormat < StringFormat
280 280 add 'link'
281 281 self.searchable_supported = false
282 282 self.form_partial = 'custom_fields/formats/link'
283 283 field_attributes :url_pattern
284 284
285 285 def formatted_value(view, custom_field, value, customized=nil, html=false)
286 286 if html
287 287 if custom_field.url_pattern.present?
288 288 url = custom_field.url_pattern.to_s.dup
289 289 url.gsub!('%value%') {value.to_s}
290 290 url.gsub!('%id%') {customized.id.to_s}
291 291 url.gsub!('%project_id%') {(customized.respond_to?(:project) ? customized.project.try(:id) : nil).to_s}
292 292 if custom_field.regexp.present?
293 293 url.gsub!(%r{%m(\d+)%}) do
294 294 m = $1.to_i
295 295 matches ||= value.to_s.match(Regexp.new(custom_field.regexp))
296 296 matches[m].to_s if matches
297 297 end
298 298 end
299 299 else
300 300 url = value.to_s
301 301 unless url =~ %r{\A[a-z]+://}i
302 302 # no protocol found, use http by default
303 303 url = "http://" + url
304 304 end
305 305 end
306 306 view.link_to value.to_s, url
307 307 else
308 308 value.to_s
309 309 end
310 310 end
311 311 end
312 312
313 313 class Numeric < Unbounded
314 314 self.form_partial = 'custom_fields/formats/numeric'
315 315
316 316 def order_statement(custom_field)
317 317 # Make the database cast values into numeric
318 318 # Postgresql will raise an error if a value can not be casted!
319 319 # CustomValue validations should ensure that it doesn't occur
320 320 "CAST(CASE #{join_alias custom_field}.value WHEN '' THEN '0' ELSE #{join_alias custom_field}.value END AS decimal(30,3))"
321 321 end
322 322 end
323 323
324 324 class IntFormat < Numeric
325 325 add 'int'
326 326
327 327 def label
328 328 "label_integer"
329 329 end
330 330
331 331 def cast_single_value(custom_field, value, customized=nil)
332 332 value.to_i
333 333 end
334 334
335 335 def validate_single_value(custom_field, value, customized=nil)
336 336 errs = super
337 337 errs << ::I18n.t('activerecord.errors.messages.not_a_number') unless value =~ /^[+-]?\d+$/
338 338 errs
339 339 end
340 340
341 341 def query_filter_options(custom_field, query)
342 342 {:type => :integer}
343 343 end
344 344
345 345 def group_statement(custom_field)
346 346 order_statement(custom_field)
347 347 end
348 348 end
349 349
350 350 class FloatFormat < Numeric
351 351 add 'float'
352 352
353 353 def cast_single_value(custom_field, value, customized=nil)
354 354 value.to_f
355 355 end
356 356
357 357 def validate_single_value(custom_field, value, customized=nil)
358 358 errs = super
359 359 errs << ::I18n.t('activerecord.errors.messages.invalid') unless (Kernel.Float(value) rescue nil)
360 360 errs
361 361 end
362 362
363 363 def query_filter_options(custom_field, query)
364 364 {:type => :float}
365 365 end
366 366 end
367 367
368 368 class DateFormat < Unbounded
369 369 add 'date'
370 370 self.form_partial = 'custom_fields/formats/date'
371 371
372 372 def cast_single_value(custom_field, value, customized=nil)
373 373 value.to_date rescue nil
374 374 end
375 375
376 376 def validate_single_value(custom_field, value, customized=nil)
377 377 if value =~ /^\d{4}-\d{2}-\d{2}$/ && (value.to_date rescue false)
378 378 []
379 379 else
380 380 [::I18n.t('activerecord.errors.messages.not_a_date')]
381 381 end
382 382 end
383 383
384 384 def edit_tag(view, tag_id, tag_name, custom_value, options={})
385 385 view.text_field_tag(tag_name, custom_value.value, options.merge(:id => tag_id, :size => 10)) +
386 386 view.calendar_for(tag_id)
387 387 end
388 388
389 389 def bulk_edit_tag(view, tag_id, tag_name, custom_field, objects, value, options={})
390 390 view.text_field_tag(tag_name, value, options.merge(:id => tag_id, :size => 10)) +
391 391 view.calendar_for(tag_id) +
392 392 bulk_clear_tag(view, tag_id, tag_name, custom_field, value)
393 393 end
394 394
395 395 def query_filter_options(custom_field, query)
396 396 {:type => :date}
397 397 end
398 398
399 399 def group_statement(custom_field)
400 400 order_statement(custom_field)
401 401 end
402 402 end
403 403
404 404 class List < Base
405 405 self.multiple_supported = true
406 406 field_attributes :edit_tag_style
407 407
408 408 def edit_tag(view, tag_id, tag_name, custom_value, options={})
409 409 if custom_value.custom_field.edit_tag_style == 'check_box'
410 410 check_box_edit_tag(view, tag_id, tag_name, custom_value, options)
411 411 else
412 412 select_edit_tag(view, tag_id, tag_name, custom_value, options)
413 413 end
414 414 end
415 415
416 416 def bulk_edit_tag(view, tag_id, tag_name, custom_field, objects, value, options={})
417 417 opts = []
418 418 opts << [l(:label_no_change_option), ''] unless custom_field.multiple?
419 419 opts << [l(:label_none), '__none__'] unless custom_field.is_required?
420 420 opts += possible_values_options(custom_field, objects)
421 421 view.select_tag(tag_name, view.options_for_select(opts, value), options.merge(:multiple => custom_field.multiple?))
422 422 end
423 423
424 424 def query_filter_options(custom_field, query)
425 425 {:type => :list_optional, :values => possible_values_options(custom_field, query.project)}
426 426 end
427 427
428 428 protected
429 429
430 430 # Renders the edit tag as a select tag
431 431 def select_edit_tag(view, tag_id, tag_name, custom_value, options={})
432 432 blank_option = ''.html_safe
433 433 unless custom_value.custom_field.multiple?
434 434 if custom_value.custom_field.is_required?
435 435 unless custom_value.custom_field.default_value.present?
436 436 blank_option = view.content_tag('option', "--- #{l(:actionview_instancetag_blank_option)} ---", :value => '')
437 437 end
438 438 else
439 439 blank_option = view.content_tag('option', '&nbsp;'.html_safe, :value => '')
440 440 end
441 441 end
442 442 options_tags = blank_option + view.options_for_select(possible_custom_value_options(custom_value), custom_value.value)
443 443 s = view.select_tag(tag_name, options_tags, options.merge(:id => tag_id, :multiple => custom_value.custom_field.multiple?))
444 444 if custom_value.custom_field.multiple?
445 445 s << view.hidden_field_tag(tag_name, '')
446 446 end
447 447 s
448 448 end
449 449
450 450 # Renders the edit tag as check box or radio tags
451 451 def check_box_edit_tag(view, tag_id, tag_name, custom_value, options={})
452 452 opts = []
453 453 unless custom_value.custom_field.multiple? || custom_value.custom_field.is_required?
454 454 opts << ["(#{l(:label_none)})", '']
455 455 end
456 456 opts += possible_custom_value_options(custom_value)
457 457 s = ''.html_safe
458 458 tag_method = custom_value.custom_field.multiple? ? :check_box_tag : :radio_button_tag
459 459 opts.each do |label, value|
460 460 value ||= label
461 461 checked = (custom_value.value.is_a?(Array) && custom_value.value.include?(value)) || custom_value.value.to_s == value
462 462 tag = view.send(tag_method, tag_name, value, checked, :id => tag_id)
463 463 # set the id on the first tag only
464 464 tag_id = nil
465 465 s << view.content_tag('label', tag + ' ' + label)
466 466 end
467 467 css = "#{options[:class]} check_box_group"
468 468 view.content_tag('span', s, options.merge(:class => css))
469 469 end
470 470 end
471 471
472 472 class ListFormat < List
473 473 add 'list'
474 474 self.searchable_supported = true
475 475 self.form_partial = 'custom_fields/formats/list'
476 476
477 477 def possible_custom_value_options(custom_value)
478 478 options = possible_values_options(custom_value.custom_field)
479 479 missing = [custom_value.value].flatten.reject(&:blank?) - options
480 480 if missing.any?
481 481 options += missing
482 482 end
483 483 options
484 484 end
485 485
486 486 def possible_values_options(custom_field, object=nil)
487 487 custom_field.possible_values
488 488 end
489 489
490 490 def validate_custom_field(custom_field)
491 491 errors = []
492 492 errors << [:possible_values, :blank] if custom_field.possible_values.blank?
493 493 errors << [:possible_values, :invalid] unless custom_field.possible_values.is_a? Array
494 494 errors
495 495 end
496 496
497 497 def validate_custom_value(custom_value)
498 498 invalid_values = Array.wrap(custom_value.value) - Array.wrap(custom_value.value_was) - custom_value.custom_field.possible_values
499 499 if invalid_values.select(&:present?).any?
500 500 [::I18n.t('activerecord.errors.messages.inclusion')]
501 501 else
502 502 []
503 503 end
504 504 end
505 505
506 506 def group_statement(custom_field)
507 507 order_statement(custom_field)
508 508 end
509 509 end
510 510
511 511 class BoolFormat < List
512 512 add 'bool'
513 513 self.multiple_supported = false
514 514 self.form_partial = 'custom_fields/formats/bool'
515 515
516 516 def label
517 517 "label_boolean"
518 518 end
519 519
520 520 def cast_single_value(custom_field, value, customized=nil)
521 521 value == '1' ? true : false
522 522 end
523 523
524 524 def possible_values_options(custom_field, object=nil)
525 525 [[::I18n.t(:general_text_Yes), '1'], [::I18n.t(:general_text_No), '0']]
526 526 end
527 527
528 528 def group_statement(custom_field)
529 529 order_statement(custom_field)
530 530 end
531 531 end
532 532
533 533 class RecordList < List
534 534 self.customized_class_names = %w(Issue TimeEntry Version Project)
535 535
536 536 def cast_single_value(custom_field, value, customized=nil)
537 537 target_class.find_by_id(value.to_i) if value.present?
538 538 end
539 539
540 540 def target_class
541 541 @target_class ||= self.class.name[/^(.*::)?(.+)Format$/, 2].constantize rescue nil
542 542 end
543 543
544 544 def possible_custom_value_options(custom_value)
545 545 options = possible_values_options(custom_value.custom_field, custom_value.customized)
546 546 missing = [custom_value.value_was].flatten.reject(&:blank?) - options.map(&:last)
547 547 if missing.any?
548 548 options += target_class.find_all_by_id(missing.map(&:to_i)).map {|o| [o.to_s, o.id.to_s]}
549 549 #TODO: use #sort_by! when ruby1.8 support is dropped
550 550 options = options.sort_by(&:first)
551 551 end
552 552 options
553 553 end
554 554
555 555 def order_statement(custom_field)
556 556 if target_class.respond_to?(:fields_for_order_statement)
557 557 target_class.fields_for_order_statement(value_join_alias(custom_field))
558 558 end
559 559 end
560 560
561 561 def group_statement(custom_field)
562 562 "COALESCE(#{join_alias custom_field}.value, '')"
563 563 end
564 564
565 565 def join_for_order_statement(custom_field)
566 566 alias_name = join_alias(custom_field)
567 567
568 568 "LEFT OUTER JOIN #{CustomValue.table_name} #{alias_name}" +
569 569 " ON #{alias_name}.customized_type = '#{custom_field.class.customized_class.base_class.name}'" +
570 570 " AND #{alias_name}.customized_id = #{custom_field.class.customized_class.table_name}.id" +
571 571 " AND #{alias_name}.custom_field_id = #{custom_field.id}" +
572 572 " AND (#{custom_field.visibility_by_project_condition})" +
573 573 " AND #{alias_name}.value <> ''" +
574 574 " AND #{alias_name}.id = (SELECT max(#{alias_name}_2.id) FROM #{CustomValue.table_name} #{alias_name}_2" +
575 575 " WHERE #{alias_name}_2.customized_type = #{alias_name}.customized_type" +
576 576 " AND #{alias_name}_2.customized_id = #{alias_name}.customized_id" +
577 577 " AND #{alias_name}_2.custom_field_id = #{alias_name}.custom_field_id)" +
578 578 " LEFT OUTER JOIN #{target_class.table_name} #{value_join_alias custom_field}" +
579 579 " ON CAST(CASE #{alias_name}.value WHEN '' THEN '0' ELSE #{alias_name}.value END AS decimal(30,0)) = #{value_join_alias custom_field}.id"
580 580 end
581 581
582 582 def value_join_alias(custom_field)
583 583 join_alias(custom_field) + "_" + custom_field.field_format
584 584 end
585 585 protected :value_join_alias
586 586 end
587 587
588 588 class UserFormat < RecordList
589 589 add 'user'
590 590 self.form_partial = 'custom_fields/formats/user'
591 591 field_attributes :user_role
592 592
593 593 def possible_values_options(custom_field, object=nil)
594 594 if object.is_a?(Array)
595 595 projects = object.map {|o| o.respond_to?(:project) ? o.project : nil}.compact.uniq
596 596 projects.map {|project| possible_values_options(custom_field, project)}.reduce(:&) || []
597 597 elsif object.respond_to?(:project) && object.project
598 598 scope = object.project.users
599 599 if custom_field.user_role.is_a?(Array)
600 600 role_ids = custom_field.user_role.map(&:to_s).reject(&:blank?).map(&:to_i)
601 601 if role_ids.any?
602 602 scope = scope.where("#{Member.table_name}.id IN (SELECT DISTINCT member_id FROM #{MemberRole.table_name} WHERE role_id IN (?))", role_ids)
603 603 end
604 604 end
605 605 scope.sorted.collect {|u| [u.to_s, u.id.to_s]}
606 606 else
607 607 []
608 608 end
609 609 end
610 610
611 611 def before_custom_field_save(custom_field)
612 612 super
613 613 if custom_field.user_role.is_a?(Array)
614 614 custom_field.user_role.map!(&:to_s).reject!(&:blank?)
615 615 end
616 616 end
617 617 end
618 618
619 619 class VersionFormat < RecordList
620 620 add 'version'
621 621 self.form_partial = 'custom_fields/formats/version'
622 622 field_attributes :version_status
623 623
624 624 def possible_values_options(custom_field, object=nil)
625 625 if object.is_a?(Array)
626 626 projects = object.map {|o| o.respond_to?(:project) ? o.project : nil}.compact.uniq
627 627 projects.map {|project| possible_values_options(custom_field, project)}.reduce(:&) || []
628 628 elsif object.respond_to?(:project) && object.project
629 629 scope = object.project.shared_versions
630 630 if custom_field.version_status.is_a?(Array)
631 631 statuses = custom_field.version_status.map(&:to_s).reject(&:blank?)
632 632 if statuses.any?
633 633 scope = scope.where(:status => statuses.map(&:to_s))
634 634 end
635 635 end
636 636 scope.sort.collect {|u| [u.to_s, u.id.to_s]}
637 637 else
638 638 []
639 639 end
640 640 end
641 641
642 642 def before_custom_field_save(custom_field)
643 643 super
644 644 if custom_field.version_status.is_a?(Array)
645 645 custom_field.version_status.map!(&:to_s).reject!(&:blank?)
646 646 end
647 647 end
648 648 end
649 649 end
650 650 end
Show file before | Show file after | Hide comments
@@ -1,165 +1,147
1 1 ---
2 2 custom_fields_001:
3 3 name: Database
4 min_length: 0
5 4 regexp: ""
6 5 is_for_all: true
7 6 is_filter: true
8 7 type: IssueCustomField
9 max_length: 0
10 8 possible_values:
11 9 - MySQL
12 10 - PostgreSQL
13 11 - Oracle
14 12 id: 1
15 13 is_required: false
16 14 field_format: list
17 15 default_value: ""
18 16 editable: true
19 17 position: 2
20 18 custom_fields_002:
21 19 name: Searchable field
22 20 min_length: 1
23 21 regexp: ""
24 22 is_for_all: true
25 23 is_filter: true
26 24 type: IssueCustomField
27 25 max_length: 100
28 26 possible_values: ""
29 27 id: 2
30 28 is_required: false
31 29 field_format: string
32 30 searchable: true
33 31 default_value: "Default string"
34 32 editable: true
35 33 position: 1
36 34 custom_fields_003:
37 35 name: Development status
38 min_length: 0
39 36 regexp: ""
40 37 is_for_all: false
41 38 is_filter: true
42 39 type: ProjectCustomField
43 max_length: 0
44 40 possible_values:
45 41 - Stable
46 42 - Beta
47 43 - Alpha
48 44 - Planning
49 45 id: 3
50 46 is_required: false
51 47 field_format: list
52 48 default_value: ""
53 49 editable: true
54 50 position: 1
55 51 custom_fields_004:
56 52 name: Phone number
57 min_length: 0
58 53 regexp: ""
59 54 is_for_all: false
60 55 type: UserCustomField
61 max_length: 0
62 56 possible_values: ""
63 57 id: 4
64 58 is_required: false
65 59 field_format: string
66 60 default_value: ""
67 61 editable: true
68 62 position: 1
69 63 custom_fields_005:
70 64 name: Money
71 min_length: 0
72 65 regexp: ""
73 66 is_for_all: false
74 67 type: UserCustomField
75 max_length: 0
76 68 possible_values: ""
77 69 id: 5
78 70 is_required: false
79 71 field_format: float
80 72 default_value: ""
81 73 editable: true
82 74 position: 2
83 75 custom_fields_006:
84 76 name: Float field
85 min_length: 0
86 77 regexp: ""
87 78 is_for_all: true
88 79 type: IssueCustomField
89 max_length: 0
90 80 possible_values: ""
91 81 id: 6
92 82 is_required: false
93 83 field_format: float
94 84 default_value: ""
95 85 editable: true
96 86 position: 3
97 87 custom_fields_007:
98 88 name: Billable
99 min_length: 0
100 89 regexp: ""
101 90 is_for_all: false
102 91 is_filter: true
103 92 type: TimeEntryActivityCustomField
104 max_length: 0
105 93 possible_values: ""
106 94 id: 7
107 95 is_required: false
108 96 field_format: bool
109 97 default_value: ""
110 98 editable: true
111 99 position: 1
112 100 custom_fields_008:
113 101 name: Custom date
114 min_length: 0
115 102 regexp: ""
116 103 is_for_all: true
117 104 is_filter: false
118 105 type: IssueCustomField
119 max_length: 0
120 106 possible_values: ""
121 107 id: 8
122 108 is_required: false
123 109 field_format: date
124 110 default_value: ""
125 111 editable: true
126 112 position: 4
127 113 custom_fields_009:
128 114 name: Project 1 cf
129 min_length: 0
130 115 regexp: ""
131 116 is_for_all: false
132 117 is_filter: true
133 118 type: IssueCustomField
134 max_length: 0
135 119 possible_values: ""
136 120 id: 9
137 121 is_required: false
138 122 field_format: date
139 123 default_value: ""
140 124 editable: true
141 125 position: 5
142 126 custom_fields_010:
143 127 name: Overtime
144 min_length: 0
145 128 regexp: ""
146 129 is_for_all: false
147 130 is_filter: false
148 131 type: TimeEntryCustomField
149 max_length: 0
150 132 possible_values: ""
151 133 id: 10
152 134 is_required: false
153 135 field_format: bool
154 136 default_value: 0
155 137 editable: true
156 138 position: 1
157 139 custom_fields_011:
158 140 id: 11
159 141 name: Binary
160 142 type: CustomField
161 143 possible_values:
162 144 - !binary |
163 145 SGXDqWzDp2prc2Tigqw2NTTDuQ==
164 146 - Other value
165 147 field_format: list
General Comments 0
You need to be logged in to leave comments. Login now