vendor.rb

# == Schema Information
#
# Table name: vendors
#
#  id              :bigint           not null, primary key
#  active          :boolean          default(TRUE)
#  address         :string
#  business_name   :string
#  comment         :string
#  contact_name    :string
#  email           :string
#  latitude        :float
#  longitude       :float
#  phone           :string
#  created_at      :datetime         not null
#  updated_at      :datetime         not null
#  organization_id :integer
#

class Vendor < ApplicationRecord
  has_paper_trail
  include Provideable
  include Geocodable
  include Filterable

  has_many :purchases, inverse_of: :vendor, dependent: :destroy

  validates :business_name, presence: true

  scope :alphabetized, -> { order(:business_name) }
  scope :active, -> { where(active: true) }
  scope :with_volumes, -> {
    left_joins(purchases: :line_items)
      .select("vendors.*, SUM(COALESCE(line_items.quantity, 0)) AS volume")
      .group(:id)
  }

  before_destroy :check_for_purchases, prepend: true

  def volume
    LineItem.where(
      itemizable_type: "Purchase",
      itemizable_id: purchase_ids
    ).sum(:quantity)
  end

  def deactivate!
    update!(active: false)
  end

  def reactivate!
    update!(active: true)
  end

  private

  def check_for_purchases
    return if purchases.empty?

    errors.add(:base, "Vendor has purchase items")
    throw(:abort)
  end
end