edjames/pivot_table

module PivotTable
  module CellCollection

    ACCESSORS = %i[header data value_name orthogonal_headers]

    ACCESSORS.each do |a|
      self.send(:attr_accessor, a)
    end

    def initialize(options = {})
      ACCESSORS.each do |a|
        next unless options.has_key?(a)
        self.send("#{a}=", options[a])
      end
    end

    def total
      data.inject(0) { |t, x| t + (x ? x.send(value_name) : 0) }
    end

  private

    def find_data(by_header_name)
      index = orthogonal_headers.find_index{ |header| by_header_name.to_s == header.to_s }
      data[index]
    rescue TypeError
      nil
    end

  end
end