Chris@1517: # Redmine - project management software
Chris@1517: # Copyright (C) 2006-2014  Jean-Philippe Lang
Chris@1517: #
Chris@1517: # This program is free software; you can redistribute it and/or
Chris@1517: # modify it under the terms of the GNU General Public License
Chris@1517: # as published by the Free Software Foundation; either version 2
Chris@1517: # of the License, or (at your option) any later version.
Chris@1517: #
Chris@1517: # This program is distributed in the hope that it will be useful,
Chris@1517: # but WITHOUT ANY WARRANTY; without even the implied warranty of
Chris@1517: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
Chris@1517: # GNU General Public License for more details.
Chris@1517: #
Chris@1517: # You should have received a copy of the GNU General Public License
Chris@1517: # along with this program; if not, write to the Free Software
Chris@1517: # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
Chris@1517: 
Chris@1517: class IssueCustomField < CustomField
Chris@1517:   has_and_belongs_to_many :projects, :join_table => "#{table_name_prefix}custom_fields_projects#{table_name_suffix}", :foreign_key => "custom_field_id"
Chris@1517:   has_and_belongs_to_many :trackers, :join_table => "#{table_name_prefix}custom_fields_trackers#{table_name_suffix}", :foreign_key => "custom_field_id"
Chris@1517:   has_many :issues, :through => :issue_custom_values
Chris@1517: 
Chris@1517:   def type_name
Chris@1517:     :label_issue_plural
Chris@1517:   end
Chris@1517: 
Chris@1517:   def visible_by?(project, user=User.current)
Chris@1517:     super || (roles & user.roles_for_project(project)).present?
Chris@1517:   end
Chris@1517: 
Chris@1517:   def visibility_by_project_condition(project_key=nil, user=User.current, id_column=nil)
Chris@1517:     sql = super
Chris@1517:     id_column ||= id
Chris@1517:     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:     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:       " 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: 
Chris@1517:     "((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}))"
Chris@1517:   end
Chris@1517: 
Chris@1517:   def validate_custom_field
Chris@1517:     super
Chris@1517:     errors.add(:base, l(:label_role_plural) + ' ' + l('activerecord.errors.messages.blank')) unless visible? || roles.present?
Chris@1517:   end
Chris@1517: end