Contents

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

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
effective_orders-2.2.2	app/models/effective/datatables/customers.rb
effective_orders-2.2.1	app/models/effective/datatables/customers.rb
effective_orders-2.2.0	app/models/effective/datatables/customers.rb