work_package_custom_field.rb

#-- copyright
# OpenProject is an open source project management software.
# Copyright (C) the OpenProject GmbH
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License version 3.
#
# OpenProject is a fork of ChiliProject, which is a fork of Redmine. The copyright follows:
# Copyright (C) 2006-2013 Jean-Philippe Lang
# Copyright (C) 2010-2013 the ChiliProject Team
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
#
# See COPYRIGHT and LICENSE files for more details.
#++

class WorkPackageCustomField < CustomField
  has_and_belongs_to_many :projects,
                          join_table: "#{table_name_prefix}custom_fields_projects#{table_name_suffix}",
                          foreign_key: "custom_field_id"
  has_and_belongs_to_many :types,
                          join_table: "#{table_name_prefix}custom_fields_types#{table_name_suffix}",
                          foreign_key: "custom_field_id"
  has_many :work_packages,
           through: :custom_values,
           source: :customized,
           source_type: "WorkPackage"

  scope :manageable_by_user, ->(user) {
    if user.allowed_in_any_project?(:select_custom_fields)
      all
    else
      visible_by_user(user)
    end
  }

  scope :visible_by_user, ->(user) {
    # Prefer a subquery to a join to avoid the database query returning
    # the cross product of projects, types and custom fields.
    where(id:
      unscoped
        .where(projects: { id: Project.visible(user) })
        .where(types: { id: Type.enabled_in(Project.visible(user)) })
        .or(unscoped.where(is_for_all: true))
        .includes(:projects, :types)
        .select(:id))
  }

  scope :usable_as_custom_action, -> {
    where.not(field_format: %w[hierarchy])
         .order(:name)
  }

  def self.summable
    where(field_format: %w[int float])
  end

  def summable?
    %w[int float].include?(field_format)
  end

  def type_name
    :label_work_package_plural
  end
end