Contents

if Gem::Version.new(EffectiveDatatables::VERSION) < Gem::Version.new('3.0')
  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

2 entries across 2 versions & 1 rubygems

Version	Path
effective_orders-2.2.4	app/models/effective/datatables/customers.rb
effective_orders-2.2.3	app/models/effective/datatables/customers.rb