Class: EffectiveOrderItemsDatatable

Inherits:
Effective::Datatable
  • Object
show all
Defined in:
app/datatables/effective_order_items_datatable.rb

Instance Method Summary collapse

Instance Method Details

#query_subtotal ⇒ Object 



71
72
73
 
# File 'app/datatables/effective_order_items_datatable.rb', line 71

def query_subtotal
  'SUM(price * quantity)'
end

#query_tax ⇒ Object 



79
80
81
 
# File 'app/datatables/effective_order_items_datatable.rb', line 79

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

#query_total ⇒ Object 



75
76
77
 
# File 'app/datatables/effective_order_items_datatable.rb', line 75

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