Marketplace - Marketplace - Search by rate & tags - Model

product.rb

# frozen_string_literal: true

# == Schema Information
#
# Table name: products
#
#  id            :bigint           not null, primary key
#  user_id       :bigint
#  title         :string
#  description   :text
#  is_listed     :boolean
#  created_at    :datetime         not null
#  updated_at    :datetime         not null
#

class Product < ApplicationRecord

  # ...

  scope :filter_on_rate, lambda {|rate|
    min, max = rate
    joins(:rates).where('rates.amount': (min.to_f..max.to_f))
  }

  scope :filter_on_tags, lambda {|kinds, params|
    query = joins(:taggables)
            .where('taggables.tag_id': kinds.map {|kind| params[kind] }.flatten)
            .group("products.id")

    kinds.each do |kind|
      query = query.having("ARRAY_AGG(taggables.tag_id) && ARRAY[?]::bigint[]", params[kind].map(&:to_i))
    end
    query
  }

  # ...

  def self.index
    select(%(
      products.id,
      products.user_id,
      products.is_listed,
      products.title,
      products.description,
      ARRAY_AGG(DISTINCT taggables.tag_id) AS tag_ids,
      MIN(rates.amount) AS amount,
      (ARRAY_AGG(attachments.picture))[1] AS attachment
))
      .listed
      .left_outer_joins([:rates, :taggables, :attachment])
      .group("products.id")
      .order("products.created_at DESC").limit(100)
  end
end