summaryrefslogtreecommitdiff
path: root/app/queries
diff options
context:
space:
mode:
Diffstat (limited to 'app/queries')
-rw-r--r--app/queries/searches/scope_filters/product_scope_filter.rb22
1 files changed, 8 insertions, 14 deletions
diff --git a/app/queries/searches/scope_filters/product_scope_filter.rb b/app/queries/searches/scope_filters/product_scope_filter.rb
index d6f254d..941fdfd 100644
--- a/app/queries/searches/scope_filters/product_scope_filter.rb
+++ b/app/queries/searches/scope_filters/product_scope_filter.rb
@@ -14,51 +14,45 @@ module Searches
end
def order_by_price
- return self unless invalid_order_by_param(:price)
+ @scope = @scope.order(unitary_price: @params[:price].to_sym) if valid_order_by_param(:price)
- @scope = @scope.order(unitary_price: @params[:price].to_sym)
self
end
def order_by_bulk_price
- return self unless invalid_order_by_param(:bulk_price)
+ @scope = @scope.order(bulk_price: @params[:bulk_price].to_sym) if valid_order_by_param(:bulk_price)
- @scope = @scope.order(bulk_price: @params[:bulk_price].to_sym)
self
end
def by_category
- return self unless @params[:category].present?
+ @scope = @scope.where("'categories' LIKE ?", "%#{@params[:category]}%") if @params[:category].present?
- @scope = @scope.where("'categories' LIKE ?", "%#{@params[:category]}%")
self
end
def order_by_available_quantity
- return self unless invalid_order_by_param(:quantity)
+ @scope = @scope.order(available_quantity: @params[:quantity].to_sym) if valid_order_by_param(:quantity)
- @scope = @scope.order(available_quantity: @params[:quantity].to_sym)
self
end
def by_company
- return self unless @params[:company].present?
+ @scope = @scope.where('companies.short_name = ?', @params[:company]) if @params[:company].present?
- @scope = @scope.where('companies.short_name = ?', "#{@params[:company]}")
self
end
def by_name
- return self unless @params[:name].present?
+ @scope = @scope.where('LOWER(products.name) LIKE ?', "%#{@params[:name]}%") if @params[:name].present?
- @scope = @scope.where('LOWER(products.name) LIKE ?', "%#{@params[:name]}%")
self
end
private
- def invalid_order_by_param(param_symbol)
- @params[param_symbol].present? || %w[asc desc].include?(@params[param_symbol])
+ def valid_order_by_param(param_symbol)
+ @params[param_symbol].present? && %w[asc desc].include?(@params[param_symbol])
end
end
end