product_drive.rb

# == Schema Information
#
# Table name: product_drives
#
#  id              :bigint           not null, primary key
#  end_date        :date
#  name            :string
#  start_date      :date
#  virtual         :boolean          default(FALSE), not null
#  created_at      :datetime         not null
#  updated_at      :datetime         not null
#  organization_id :bigint
#

class ProductDrive < ApplicationRecord
  has_paper_trail
  belongs_to :organization, optional: true
  include Filterable

  scope :by_name, ->(name_filter) { where(name: name_filter) }
  scope :by_item_category_id, ->(item_category_id) {
    joins(donations: {line_items: :item})
      .where(item: { item_category_id: item_category_id })
  }

  scope :within_date_range, ->(search_range) {
    search_dates = search_date_range(search_range)
    where('(end_date >= ? OR end_date IS NULL) AND start_date <= ?',
          search_dates[:start_date],
          search_dates[:end_date])
  }

  has_many :donations, dependent: :nullify
  has_many :product_drive_participants, -> { distinct }, through: :donations
  validates :name, presence:
    { message: "A name must be chosen." }
  validates :start_date, presence:
    { message: "Please enter a start date." }
  scope :alphabetized, -> { order(:name) }

  validate :end_date_is_bigger_of_end_date

  def end_date_is_bigger_of_end_date
    return if start_date.nil? || end_date.nil?

    if end_date < start_date
      errors.add(:end_date, 'End date must be after the start date')
    end
  end

  def donation_quantity
    donations.joins(:line_items).sum('line_items.quantity')
  end

  def distinct_items_count
    donations.joins(:line_items).select('line_items.item_id').distinct.count
  end

  def in_kind_value
    donations.sum(&:value_per_itemizable)
  end

  def donation_source_view
    "#{name} (product drive)"
  end

  def self.search_date_range(dates)
    dates = dates.split(" - ")
    @search_date_range = { start_date: dates[0], end_date: dates[1] }
  end

  # quantities are FILTERED by date then SORTED by name
  #
  # @param date_range [Range]
  # @return [Array<Integer>]
  def item_quantities_by_name_and_date(date_range)
    quantities = donations.joins(:line_items)
      .during(date_range)
      .group('line_items.item_id')
      .sum('line_items.quantity')

    organization.items.order(:name).map do |item|
      quantities[item.id] || 0
    end
  end

  def donation_quantity_by_date(date_range, item_category_id = nil)
    query = donations.during(date_range)
    query = if item_category_id.present?
      query.joins(line_items: :item).where(item: {item_category_id: item_category_id})
    else
      query.joins(:line_items)
    end
    query.sum('line_items.quantity')
  end

  def distinct_items_count_by_date(date_range, item_category_id = nil)
    query = donations.during(date_range)
    query = if item_category_id.present?
      query.joins(line_items: :item).where(item: {item_category_id: item_category_id})
    else
      query.joins(:line_items)
    end
    query.select('line_items.item_id').distinct.count
  end
end