Contents

Spree::Variant.class_eval do

  def self.favourites_by_user(user)
    Spree::Variant.joins(line_items: [order: [:user]])
    .where(['spree_users.id = ?', user.id])
    .where(['spree_orders.completed_at IS NOT NULL'])
    .references(:orders)
    .group('spree_variants.id')
    .order('COUNT(spree_line_items.id) DESC')
    .select('spree_variants.*')
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
spree_my_favourites-2.2.7	app/models/spree/variant_decorator.rb
spree_my_favourites-2.2.6	app/models/spree/variant_decorator.rb