Sha256: 3d5cae4cd741960c0f085aa49caa503000f1610f016594ae2519b091cd7d3eb2
Contents?: true
Size: 1.43 KB
Versions: 6
Compression:
Stored size: 1.43 KB
Contents
if defined?(EffectiveDatatables)
module Effective
module Datatables
class Customers < Effective::Datatable
datatable do
default_order :email, :asc
table_column :id, visible: false
table_column(:email, column: 'users.email') { |user| mail_to user.email, user.email }
if EffectiveOrders.stripe_enabled
table_column :stripe_customer_id
table_column :stripe_active_card
end
if EffectiveOrders.stripe_connect_enabled
table_column :stripe_connect_access_token
end
table_column :subscription_types, column: 'subscription_types'
actions_column partial: 'admin/customers/actions'
end
def collection
Effective::Customer.customers.uniq
.joins(:user, :subscriptions)
.select('customers.*, users.email AS email')
.select("array_to_string(array(#{Effective::Subscription.purchased.select('subscriptions.stripe_plan_id').where('subscriptions.customer_id = customers.id').to_sql}), ' ,') AS subscription_types")
.group('customers.id, subscriptions.stripe_plan_id, users.email')
end
def search_column(collection, table_column, search_term)
return collection.where('subscriptions.stripe_plan_id ILIKE ?', "%#{search_term}%") if table_column[:name] == 'subscription_types'
super
end
end
end
end
end
Version data entries
6 entries across 6 versions & 1 rubygems