Class: Oddb2xml::MigelExtractor

Inherits:
Extractor show all
Defined in:
lib/oddb2xml/extractor.rb

Instance Attribute Summary

Attributes inherited from Extractor

#xml

Instance Method Summary collapse

Constructor Details

#initialize(bin) ⇒ MigelExtractor

Returns a new instance of MigelExtractor.



361
362
363
364
365
# File 'lib/oddb2xml/extractor.rb', line 361

def initialize(bin)
  Oddb2xml.log("MigelExtractor #{io} #{File.size(io)} bytes")
  book = Spreadsheet.open(io, 'rb')
  @sheet = book.worksheet(0)
end

Instance Method Details

#to_hashObject



366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
# File 'lib/oddb2xml/extractor.rb', line 366

def to_hash
  data = {}
  @sheet.each_with_index do |row, i|
    next if i.zero?
    phar = row[1]
    next if phar == 0
    ean13 = row[0]
    ean13 = phar unless ean13.to_s.length == 13
    data[ean] = {
      :refdata         => true,
      :ean13           => ean13,
      :pharmacode      => phar,
      :desc_de         => row[3],
      :desc_fr         => row[4],
      :quantity        => row[5], # quantity
      :company_name    => row[6],
      :company_ean     => row[7],
      :data_origin     => 'migel'
    }
  end
  data
end