Class: Oddb2xml::SwissmedicExtractor

Inherits:

Extractor

• Object
• Extractor
• Oddb2xml::SwissmedicExtractor

Defined in:

lib/oddb2xml/extractor.rb

Instance Attribute Summary

Attributes inherited from Extractor

#xml

Instance Method Summary

• #initialize(filename, type) ⇒ SwissmedicExtractor constructor

  A new instance of SwissmedicExtractor.

• #to_arry ⇒ Object
• #to_hash ⇒ Object

  Packungen.xlsx COLUMNS_JULY_2015.

Constructor Details

#initialize(filename, type) ⇒ SwissmedicExtractor

Returns a new instance of SwissmedicExtractor.

# File 'lib/oddb2xml/extractor.rb', line 217

def initialize(filename, type)
  @filename = File.join(Downloads, File.basename(filename))
  @filename = File.join(SpecData, File.basename(filename)) if defined?(RSpec) and not File.exists?(@filename)
  @type  = type
  Oddb2xml.log("SwissmedicExtractor #{@filename} #{File.size(@filename)} bytes")
  return unless File.exists?(@filename)
  @sheet = RubyXL::Parser.parse(File.expand_path(@filename)).worksheets[0]
end

Instance Method Details

#to_arry ⇒ Object

# File 'lib/oddb2xml/extractor.rb', line 225

def to_arry
  data = []
  return data unless @sheet
  case @type
  when :orphan
    i = 1
    col_zulassung = 5
    raise "Could not find Zulassungsnummer in column #{col_zulassung} of #{@filename}" unless /Zulassungs.*nummer/.match(@sheet[3][col_zulassung].value)
    @sheet.each do |row|
      next unless row[col_zulassung]
      number = row[col_zulassung].value.to_i
      if number != 0
        data << sprintf("%05d", number)
      end
    end
  end
  cleanup_file
  # puts "found #{data.uniq.size} entities for type #{@type}"
  data.uniq
end

#to_hash ⇒ Object

Packungen.xlsx COLUMNS_JULY_2015

# File 'lib/oddb2xml/extractor.rb', line 246

def to_hash # Packungen.xlsx COLUMNS_JULY_2015
  data = {}
  return data unless @sheet
  case @type
  when :package
    Oddb2xml.check_column_indices(@sheet)
    ith       = COLUMNS_JULY_2015.keys.index(:index_therapeuticus)
    i_5       = COLUMNS_JULY_2015.keys.index(:iksnr)
    seq_name  = COLUMNS_JULY_2015.keys.index(:name_base)
    i_3       = COLUMNS_JULY_2015.keys.index(:ikscd)
    p_1_2     = COLUMNS_JULY_2015.keys.index(:seqnr)
    cat       = COLUMNS_JULY_2015.keys.index(:ikscat)
    siz       = COLUMNS_JULY_2015.keys.index(:size)
    atc       = COLUMNS_JULY_2015.keys.index(:atc_class)
    list_code = COLUMNS_JULY_2015.keys.index(:production_science)
    eht       = COLUMNS_JULY_2015.keys.index(:unit)
    sub       = COLUMNS_JULY_2015.keys.index(:substances)
    comp      = COLUMNS_JULY_2015.keys.index(:composition)

    # production_science Heilmittelcode, possible values are
    # Allergene
    # Anthroposophika
    # ayurvedische Arzneimittel
    # Bakterien- und Hefepräparate
    # Biotechnologika
    # Blutprodukte
    # Generator
    # Heilmittelcode
    # Homöopathika
    # Impfstoffe
    # Phytotherapeutika
    # Radiopharmazeutika
    # Synthetika human
    # tibetische Arzneimittel
    # Tierarzneimittel
    # Transplantat: Gewebeprodukt
    @sheet.each_with_index do |row, i|

      next if (i <= 1)
      next unless row and row[i_5] and row[i_3]
      next unless row[i_5].value.to_i > 0 and row[i_3].value.to_i > 0
      no8 = sprintf('%05d',row[i_5].value.to_i) + sprintf('%03d',row[i_3].value.to_i)
      prodno = sprintf('%05d',row[i_5].value.to_i) + sprintf('%02d', row[p_1_2].value.to_i).to_s
      unless no8.empty?
        next if no8.to_i == 0
        ean_base12 = "7680#{no8}"
        data[no8] = {
          :ean13                => (ean_base12.ljust(12, '0') + Oddb2xml.calc_checksum(ean_base12)),
          :prodno               => prodno ? prodno : '',
          :ith_swissmedic       => row[ith] ? row[ith].value.to_s : '',
          :swissmedic_category  => row[cat].value.to_s,
          :atc_code             => row[atc] ? Oddb2xml.add_epha_changes_for_ATC(row[i_5].value.to_s, row[atc].value.to_s) : '',
          :list_code            => row[list_code] ? row[list_code].value.to_s : '',
          :package_size         => row[siz] ? row[siz].value.to_s : '',
          :einheit_swissmedic   => row[eht] ? row[eht].value.to_s : '',
          :substance_swissmedic => row[sub] ? row[sub].value.to_s : '',
          :composition_swissmedic => row[comp] ? row[comp].value.to_s : '',
          :sequence_name        => row[seq_name] ? row[seq_name].value.to_s : '',
          :is_tier              => (row[list_code] == 'Tierarzneimittel' ? true : false),
          :gen_production       => row[COLUMNS_JULY_2015.keys.index(:gen_production)].value.to_s,
          :insulin_category     => row[COLUMNS_JULY_2015.keys.index(:insulin_category)].value.to_s,
          :drug_index           => row[COLUMNS_JULY_2015.keys.index(:drug_index)].value.to_s,
          :data_origin          => 'swissmedic_package',
          :expiry_date          => row[COLUMNS_JULY_2015.keys.index(:expiry_date)].value.to_s,
          :company_name         => row[COLUMNS_JULY_2015.keys.index(:company)].value.to_s,
          :size                 => row[COLUMNS_JULY_2015.keys.index(:size)].value.to_s,
          :unit                 => row[COLUMNS_JULY_2015.keys.index(:unit)].value.to_s,
        }
      end
    end
  end
  cleanup_file
  data
end