# frozen_string_literal: true

class CustomerRelations::IssueContact < ApplicationRecord
  self.table_name = "issue_customer_relations_contacts"

  belongs_to :issue, optional: false, inverse_of: :customer_relations_contacts
  belongs_to :contact, optional: false, inverse_of: :issue_contacts

  validate :contact_belongs_to_root_group

  def self.find_contact_ids_by_emails(issue_id, emails)
    raise ArgumentError, "Cannot lookup more than #{MAX_PLUCK} emails" if emails.length > MAX_PLUCK

    joins(:contact)
      .where(issue_id: issue_id, customer_relations_contacts: { email: emails })
      .pluck(:contact_id)
  end

  def self.delete_for_project(project_id)
    joins(:issue)
      .where(issues: { project_id: project_id })
      .delete_all
  end

  private

  def contact_belongs_to_root_group
    return unless contact&.group_id
    return unless issue&.project&.namespace_id
    return if issue.project.root_ancestor&.id == contact.group_id

    errors.add(:base, _("The contact does not belong to the issue group's root ancestor"))
  end
end