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 



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

def query_subtotal
  'SUM(price * quantity)'
end

#query_tax ⇒ Object 



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

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

#query_total ⇒ Object 



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

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