if defined?(EffectiveDatatables)
  module Effective
    module Datatables
      class Orders < Effective::Datatable
        default_order :purchased_at, :desc

        table_column :id

        table_column :email, :column => 'users.email', :label => 'Buyer Email', :if => Proc.new { attributes[:user_id].blank? } do |order|
          link_to order[:email], (edit_admin_user_path(order.user_id) rescue admin_user_path(order.user_id) rescue '#')
        end

        if EffectiveOrders.require_billing_address
          table_column :full_name, :sortable => false, :label => 'Buyer Name', :if => Proc.new { attributes[:user_id].blank? } do |order|
            (order[:full_name] || '').split('!!SEP!!').find { |name| name.present? }
          end
        end

        table_column :order_items, :sortable => false, :column => 'order_items.title' do |order|
          content_tag(:ul) do
            (order[:order_items] || '').split('!!SEP!!').map { |oi| content_tag(:li, oi) }.join().html_safe
          end
        end

        table_column :purchased_at

        table_column :purchase_state, :filter => {:type => :select, :values => [['abandoned', 'abandoned'], [EffectiveOrders::PURCHASED, EffectiveOrders::PURCHASED], [EffectiveOrders::DECLINED, EffectiveOrders::DECLINED]], :selected => EffectiveOrders::PURCHASED} do |order|
          order.purchase_state || 'abandoned'
        end

        table_column :total do |order|
          price_to_currency(order[:total].to_i)
        end

        table_column :actions, :sortable => false, :filter => false do |order|
          content_tag(:span, :style => 'white-space: nowrap;') do
            [
              link_to('View', (datatables_admin_path? ? effective_orders.admin_order_path(order) : effective_orders.order_path(order))),
              (link_to('Resend Receipt', effective_orders.resend_buyer_receipt_path(order), {'data-confirm' => 'This action will resend a copy of the original email receipt.  Send receipt now?'}) if order.try(:purchased?))
            ].compact.join(' - ').html_safe
          end
        end

        def collection
          collection = Effective::Order.unscoped
            .joins(:user)
            .joins(:order_items)
            .group('users.email')
            .group('orders.id')
            .select('users.email AS email')
            .select('orders.*')
            .select("#{query_total} AS total")
            .select("string_agg(order_items.title, '!!SEP!!') AS order_items")

          if EffectiveOrders.require_billing_address
            collection = collection
              .joins("LEFT OUTER JOIN addresses ON addresses.addressable_id = orders.id AND addresses.addressable_type = 'Effective::Order'")
              .select("string_agg(addresses.full_name, '!!SEP!!') AS full_name")
              .where("addresses IS NULL OR addresses.category = 'billing'")
          end

          if attributes[:user_id].present?
            collection.where(:user_id => attributes[:user_id])
          else
            collection
          end

        end

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

        def search_column(collection, table_column, search_term)
          if table_column[:name] == 'total'
            collection.having("#{query_total} = ?", (search_term.gsub(/[^0-9.]/, '').to_f * 100.0).to_i)
          elsif table_column[:name] == 'purchase_state' && search_term == 'abandoned'
            collection.where(:purchase_state => nil)
          else
            super
          end
        end

      end
    end
  end
end