Module: Spree::Variant::Scopes

Included in:
Spree::Variant
Defined in:
app/models/spree/variant/scopes.rb

Class Method Summary collapse

Class Method Details

.prepended(base) ⇒ Object



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# File 'app/models/spree/variant/scopes.rb', line 6

def self.prepended(base)
  base.class_eval do
    # FIXME: WARNING tested only under sqlite and postgresql
    scope :descend_by_popularity, -> {
      order(Arel.sql("COALESCE((SELECT COUNT(*) FROM  #{Spree::LineItem.quoted_table_name} GROUP BY #{Spree::LineItem.quoted_table_name}.variant_id HAVING #{Spree::LineItem.quoted_table_name}.variant_id = #{Spree::Variant.quoted_table_name}.id), 0) DESC"))
    }

    scope :by_stock_location, ->(stock_location_id) {
      joins(:stock_locations).where(spree_stock_locations: { id: stock_location_id })
    }

    class << self
      # Returns variants that match a given option value
      #
      # Example:
      #
      # product.variants_including_master.has_option(OptionType.find_by(name: 'shoe-size'), OptionValue.find_by(name: '8'))
      def has_option(option_type, *option_values)
        option_types = Spree::OptionType.table_name

        option_type_conditions = case option_type
                                 when OptionType then { "#{option_types}.name" => option_type.name }
                                 when String     then { "#{option_types}.name" => option_type }
                                 else { "#{option_types}.id" => option_type }
                                 end

        relation = joins(option_values: :option_type).where(option_type_conditions)

        option_values.each do |option_value|
          option_value_conditions = case option_value
                                    when OptionValue then { "#{Spree::OptionValue.table_name}.name" => option_value.name }
                                    when String      then { "#{Spree::OptionValue.table_name}.name" => option_value }
                                    else { "#{Spree::OptionValue.table_name}.id" => option_value }
                                    end
          relation = relation.where(option_value_conditions)
        end

        relation
      end

      alias_method :has_options, :has_option
    end
  end
end