class Eco::API::Common::People::DefaultParsers::XLSParser < Eco::API::Common::Loaders::Parser
  attribute :xls

  attr_accessor :already_required
  attr_reader   :file

  def parser(file, _deps)
    @file = file
    rows.tap do |rws|
      @file = nil
      rws.each do |row|
        to_string!(row)
      end
    end
  end

  def serializer(_array_hash, _deps)
    raise "Not implemented. TODO: using axlsx or rubyXL gems. See: https://spin.atomicobject.com/2017/03/22/parsing-excel-files-ruby/"
  end

  private

  def to_string!(row)
    row.transform_values! do |val|
      next nil unless val
      next val if val.is_a?(String)
      val.to_s
    end
  end

  def headers
    logger.warn("Headers detection is using your fields_map.json file (native behaviour)")
    session.fields_mapper.list(:external).uniq
  end

  def sheet_name
    0
  end

  def workbook
    require_reading_libs!
    Roo::Spreadsheet.open(file)
  end

  def spreadheet(name_or_index = sheet_name)
    workbook.sheet(name_or_index)
  end

  def rows(target = headers)
    spreadheet.parse(header_search: target, clean: true)
  rescue Roo::HeaderRowNotFoundError => e
    missing = JSON.parse(e.message)
    logger.warn("The input file is missing these headers: #{missing}")
    present = target - missing
    rows(present)
  end

  def require_reading_libs!
    return if already_required
    require 'roo'
    require 'roo-xls'
    self.already_required = true
  end
end