class Quickbooks::Model::Report

def all_rows
  @all_rows ||= xml.css("ColData:first-child").map {|node| parse_row(node.parent) }
end

def columns
  @columns ||= begin
    nodes = xml.css('Column')
    nodes.map do |node|
      # There is also a ColType field, but it does not seem valuable to capture
      node.at('ColTitle').content
    end
  end
end

def find_row(label)
  all_rows.find {|r| r[0] == label }
end

def parse_row(row_node)
  row_node.elements.map.with_index do |el, i|
    value = el.attr('value')
    next nil if value.blank?
    parse_row_value(value)
  end
end

def parse_row_value(value)
  # does it look like a number?
  if value =~ /\A\-?[0-9\.]+\Z/
    BigDecimal(value)
  else
    value
  end
rescue ArgumentError
  value
end