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