Re: Add search by sku

[Александр Бобров]

ок!!!. Thanks!!

пятница, 9 ноября 2012 г., 3:29:16 UTC+6 пользователь Washington Luiz написал:

Take a look https://gist.github.com/93b60823c67586bfc22c

On Thursday, November 8, 2012 4:37:27 AM UTC-3, Александр Бобров wrote:

I add decorator

 module Spree

  module Core

    Search::Base.class_eval do

   def get_products_conditions_for(base_scope, query)

        unless query.blank?

          base_scope = base_scope.like_any([:name, :description], query.split)

          base_scope = base_scope.joins(:master).where("spree_variants.sku='#{query}'")

        end

        base_scope

      end

    end

  end

end

but no one products found  ok ...

when comment string base_scope = base_scope.like_any([:name, :description], query.split)

works fine !!!! but only for search by sku, how to do for sku and products?

[Robert Maj]

 base_scope = base_scope.joins(:master).where("spree_variants.sku ILIKE '%#{query}%'
                or spree_products.name ILIKE '%#{query}%' or spree_products.description ILIKE '%#{query}%' ")
this work better

[Robert Maj]

 base_scope = base_scope.joins(:master).where("spree_variants.sku ILIKE '%#{query}%'
                or spree_products.name ILIKE '%#{query}%' or spree_products.description ILIKE '%#{query}%' ")

W dniu poniedziałek, 19 listopada 2012 15:44:34 UTC+1 użytkownik Александр Бобров napisał: