gistfile1.txt

class Organization < ApplicationRecord
  validates :name, presence: true, uniqueness: true
  validates :description, presence: true

  has_many :organization_categories
  has_many :categories, through: :organization_categories
  has_many :locations

  def self.categories_query(category_ids)
    if category_ids.count == 1
      joins(:organization_categories).where('organization_categories.category_id': category_ids.first)
    else
      joins(:organization_categories).where('organization_categories.organization_id': OrganizationCategory.select('organization_categories.organzation_id')
                                                                      .where(category_id: category_ids)
                                                                      .group('organization_categories.organization_id')
                                                                      .having("COUNT(organization_categories.organization_id) > #{category_ids.count - 1}"))
      .uniq
    end
  end
end