Class: Effective::Datatables::Orders

Inherits:
Effective::Datatable
  • Object
show all
Defined in:
app/models/effective/datatables/orders.rb

Instance Method Summary collapse

Instance Method Details

#collection ⇒ Object 



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 
# File 'app/models/effective/datatables/orders.rb', line 41

def collection
  collection = Effective::Order.unscoped
    .joins(:user, :order_items)
    .group('users.email, orders.id')
    .select('orders.*, users.email AS email')
    .select("#{query_subtotal} AS subtotal, #{query_tax} AS tax, #{query_total} AS total")
    .select("string_agg(order_items.title, '!!SEP!!') AS order_items")

  if EffectiveOrders.require_billing_address && defined?(EffectiveAddresses)
    addresses_tbl = EffectiveAddresses.addresses_table_name

    collection = collection
      .joins("LEFT JOIN (SELECT addressable_id, string_agg(#{addresses_tbl}.full_name, '!!SEP!!') AS buyer_name FROM #{addresses_tbl} WHERE #{addresses_tbl}.category = 'billing' AND #{addresses_tbl}.addressable_type = 'Effective::Order' GROUP BY #{addresses_tbl}.addressable_id) #{addresses_tbl} ON orders.id = #{addresses_tbl}.addressable_id")
      .group("#{addresses_tbl}.buyer_name")
      .select("#{addresses_tbl}.buyer_name AS buyer_name")
  end

  attributes[:user_id].present? ? collection.where(user_id: attributes[:user_id]) : collection
end

#query_subtotal ⇒ Object 



61
62
63
 
# File 'app/models/effective/datatables/orders.rb', line 61

def query_subtotal
  'SUM(order_items.price * order_items.quantity)'
end

#query_tax ⇒ Object 



65
66
67
 
# File 'app/models/effective/datatables/orders.rb', line 65

def query_tax
  'SUM(CASE order_items.tax_exempt WHEN true THEN 0 ELSE ((order_items.price * order_items.quantity) * order_items.tax_rate) END)'
end

#query_total ⇒ Object 



69
70
71
 
# File 'app/models/effective/datatables/orders.rb', line 69

def query_total
  'SUM((order_items.price * order_items.quantity) + (CASE order_items.tax_exempt WHEN true THEN 0 ELSE ((order_items.price * order_items.quantity) * order_items.tax_rate) END))'
end

#search_column(collection, table_column, search_term) ⇒ Object 



73
74
75
76
77
78
79
80
81
82
83
84
85
 
# File 'app/models/effective/datatables/orders.rb', line 73

def search_column(collection, table_column, search_term)
  if table_column[:name] == 'subtotal'
    collection.having("#{query_subtotal} = ?", (search_term.gsub(/[^0-9.]/, '').to_f * 100.0).to_i)
  elsif table_column[:name] == 'tax'
    collection.having("#{query_tax} = ?", (search_term.gsub(/[^0-9.]/, '').to_f * 100.0).to_i)
  elsif table_column[:name] == 'total'
    collection.having("#{query_total} = ?", (search_term.gsub(/[^0-9.]/, '').to_f * 100.0).to_i)
  elsif table_column[:name] == 'purchase_state' && search_term == 'abandoned'
    collection.where(purchase_state: nil)
  else
    super
  end
end