summaryrefslogtreecommitdiff
path: root/app/queries
diff options
context:
space:
mode:
authorHombreLaser <sebastian-440@live.com>2023-04-16 13:02:26 -0600
committerHombreLaser <sebastian-440@live.com>2023-04-16 13:02:26 -0600
commit62ebfcb0901002c1377d5677ed1a0d062ab94ff0 (patch)
treee6eb92f5d1fe2dc618e02f577c43ef0b4d256f79 /app/queries
parentf158d350f10ae6850c7ee168f0345197c3265d5c (diff)
Añade búsqueda de productos
Diffstat (limited to 'app/queries')
-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