Sha256: 6f79681803a33b71edac2e8f35001f13e940026f31d6b20f8853df12be2b962e
Contents?: true
Size: 1.48 KB
Versions: 6
Compression:
Stored size: 1.48 KB
Contents
# Revenue: Individual Transactions
module Admin
class ReportTransactionsDatatable < Effective::Datatable
filters do
filter :start_date, nil, as: :date
filter :end_date, nil, as: :date
end
datatable do
order :id, :desc
length 250
col :created_at, visible: false
col :id, label: 'Order' do |order|
link_to(order.to_param, effective_orders.admin_order_path(order))
end
col :purchased_at
col :user
col :order_items
col :subtotal, as: :price
col :tax, as: :price
col(:tax_rate) { |order| rate_to_percentage(order.tax_rate) }.aggregate { nil }
col :amount_owing, as: :price
if EffectiveOrders.surcharge?
col :surcharge, as: :price
col(:surcharge_percent) { |order| rate_to_percentage(order.surcharge_percent) }.aggregate { nil }
end
col :total, as: :price
col :start_date, as: :date, search: false, sort: false, visible: false do
date_range.begin&.strftime('%F')
end
col :end_date, as: :date, search: false, sort: false, visible: false do
date_range.end&.strftime('%F')
end
aggregate :total
actions_col
end
collection do
Effective::Order.purchased
.where(purchased_at: date_range)
.where('total != 0')
.includes(:user, [order_items: :purchasable])
end
def date_range
@date_range ||= (filters[:start_date].presence)..(filters[:end_date].presence)
end
end
end
Version data entries
6 entries across 6 versions & 1 rubygems