Contents

module SpreeMobility::CoreExt::Spree
  module VariantDecorator
    module ClassMethods
      def product_name_or_sku_cont(query)
        helper =
          SpreeMobility::TranslationQuery.new(
            ::Spree::Product.mobility_backend_class(:name))

        helper.add_joins(self.joins(:product)).
        where(
          "(LOWER(#{helper.col_name(:name)}) LIKE :query) OR (LOWER(#{::Spree::Variant.table_name}.sku) LIKE :query)", query: "%#{query&.downcase}%").distinct
      end

      def search_by_product_name_or_sku(query)
        product_name_or_sku_cont(query)
      end
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
spree_mobility-1.4.0	lib/spree_mobility/core_ext/spree/variant_decorator.rb
spree_mobility-1.3.0	lib/spree_mobility/core_ext/spree/variant_decorator.rb
spree_mobility-1.2.0	lib/spree_mobility/core_ext/spree/variant_decorator.rb
spree_mobility-1.1.0	lib/spree_mobility/core_ext/spree/variant_decorator.rb