summaryrefslogtreecommitdiff
path: root/app/queries/searches
diff options
context:
space:
mode:
Diffstat (limited to 'app/queries/searches')
-rw-r--r--app/queries/searches/base_search.rb12
-rw-r--r--app/queries/searches/product_search.rb16
-rw-r--r--app/queries/searches/scope_filters/product_scope_filter.rb65
3 files changed, 93 insertions, 0 deletions
diff --git a/app/queries/searches/base_search.rb b/app/queries/searches/base_search.rb
new file mode 100644
index 0000000..b8c49d4
--- /dev/null
+++ b/app/queries/searches/base_search.rb
@@ -0,0 +1,12 @@
+# frozen_string_literal: true
+
+module Searches
+ # BaseSearch
+ class BaseSearch
+ def initialize(scope, params)
+ @scope = scope
+ @params = params
+ @scope_filter = ScopeFilters::ProductScopeFilter.new(scope, @params)
+ end
+ end
+end
diff --git a/app/queries/searches/product_search.rb b/app/queries/searches/product_search.rb
new file mode 100644
index 0000000..d426211
--- /dev/null
+++ b/app/queries/searches/product_search.rb
@@ -0,0 +1,16 @@
+# frozen_string_literal: true
+
+module Searches
+ # ProductSearch
+ class ProductSearch < BaseSearch
+ def call
+ @scope_filter.by_name
+ .by_company
+ .by_category
+ .order_by_available_quantity
+ .order_by_price
+ .order_by_bulk_price
+ .query_result
+ end
+ end
+end
diff --git a/app/queries/searches/scope_filters/product_scope_filter.rb b/app/queries/searches/scope_filters/product_scope_filter.rb
new file mode 100644
index 0000000..d6f254d
--- /dev/null
+++ b/app/queries/searches/scope_filters/product_scope_filter.rb
@@ -0,0 +1,65 @@
+# frozen_string_literal: true
+
+module Searches
+ module ScopeFilters
+ # ProductScopeFilter
+ class ProductScopeFilter
+ def initialize(scope, params)
+ @scope = scope
+ @params = params
+ end
+
+ def query_result
+ @scope
+ end
+
+ def order_by_price
+ return self unless invalid_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)
+ self
+ end
+
+ def by_category
+ return self unless @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)
+ self
+ end
+
+ def by_company
+ return self unless @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]}%")
+ self
+ end
+
+ private
+
+ def invalid_order_by_param(param_symbol)
+ @params[param_symbol].present? || %w[asc desc].include?(@params[param_symbol])
+ end
+ end
+ end
+end