Chris@909
|
1 # Redmine - project management software
|
Chris@1494
|
2 # Copyright (C) 2006-2014 Jean-Philippe Lang
|
Chris@0
|
3 #
|
Chris@0
|
4 # This program is free software; you can redistribute it and/or
|
Chris@0
|
5 # modify it under the terms of the GNU General Public License
|
Chris@0
|
6 # as published by the Free Software Foundation; either version 2
|
Chris@0
|
7 # of the License, or (at your option) any later version.
|
Chris@909
|
8 #
|
Chris@0
|
9 # This program is distributed in the hope that it will be useful,
|
Chris@0
|
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
|
Chris@0
|
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
Chris@0
|
12 # GNU General Public License for more details.
|
Chris@909
|
13 #
|
Chris@0
|
14 # You should have received a copy of the GNU General Public License
|
Chris@0
|
15 # along with this program; if not, write to the Free Software
|
Chris@0
|
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
|
Chris@0
|
17
|
Chris@0
|
18 class IssueCustomField < CustomField
|
Chris@0
|
19 has_and_belongs_to_many :projects, :join_table => "#{table_name_prefix}custom_fields_projects#{table_name_suffix}", :foreign_key => "custom_field_id"
|
Chris@0
|
20 has_and_belongs_to_many :trackers, :join_table => "#{table_name_prefix}custom_fields_trackers#{table_name_suffix}", :foreign_key => "custom_field_id"
|
Chris@0
|
21 has_many :issues, :through => :issue_custom_values
|
Chris@909
|
22
|
Chris@0
|
23 def type_name
|
Chris@0
|
24 :label_issue_plural
|
Chris@0
|
25 end
|
Chris@1464
|
26
|
Chris@1464
|
27 def visible_by?(project, user=User.current)
|
Chris@1464
|
28 super || (roles & user.roles_for_project(project)).present?
|
Chris@1464
|
29 end
|
Chris@1464
|
30
|
Chris@1517
|
31 def visibility_by_project_condition(project_key=nil, user=User.current, id_column=nil)
|
Chris@1464
|
32 sql = super
|
Chris@1517
|
33 id_column ||= id
|
Chris@1517
|
34 tracker_condition = "#{Issue.table_name}.tracker_id IN (SELECT tracker_id FROM #{table_name_prefix}custom_fields_trackers#{table_name_suffix} WHERE custom_field_id = #{id_column})"
|
Chris@1517
|
35 project_condition = "EXISTS (SELECT 1 FROM #{CustomField.table_name} ifa WHERE ifa.is_for_all = #{connection.quoted_true} AND ifa.id = #{id_column})" +
|
Chris@1517
|
36 " OR #{Issue.table_name}.project_id IN (SELECT project_id FROM #{table_name_prefix}custom_fields_projects#{table_name_suffix} WHERE custom_field_id = #{id_column})"
|
Chris@1517
|
37
|
Chris@1517
|
38 "((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}))"
|
Chris@1464
|
39 end
|
Chris@1464
|
40
|
Chris@1464
|
41 def validate_custom_field
|
Chris@1464
|
42 super
|
Chris@1464
|
43 errors.add(:base, l(:label_role_plural) + ' ' + l('activerecord.errors.messages.blank')) unless visible? || roles.present?
|
Chris@1464
|
44 end
|
Chris@0
|
45 end
|