Class: Oddb2xml::SwissmedicExtractor
- Defined in:
- lib/oddb2xml/extractor.rb
Instance Attribute Summary
Attributes inherited from Extractor
Instance Method Summary collapse
-
#initialize(filename, type) ⇒ SwissmedicExtractor
constructor
A new instance of SwissmedicExtractor.
- #to_arry ⇒ Object
-
#to_hash ⇒ Object
Packungen.xls.
Methods inherited from Extractor
Constructor Details
#initialize(filename, type) ⇒ SwissmedicExtractor
Returns a new instance of SwissmedicExtractor.
199 200 201 202 203 204 205 206 207 |
# File 'lib/oddb2xml/extractor.rb', line 199 def initialize(filename, type) @type = type if type == :orphan book = Spreadsheet.open(filename, 'rb') @sheet = book.worksheet(0) else @sheet = RubyXL::Parser.parse(File.(filename)).worksheets[0] end end |
Instance Method Details
#to_arry ⇒ Object
208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 |
# File 'lib/oddb2xml/extractor.rb', line 208 def to_arry data = [] case @type when :orphan i = 1 @sheet.each do |row| number = row[1].to_i if number != 0 data << sprintf("%05d", number) end end when :fridge i,c = 1,7 @sheet.each do |row| if row[i] and number = row[i].value and row[c] and row[c].value.to_s.downcase == 'x' data << sprintf("%05d", number) end end end data.uniq end |
#to_hash ⇒ Object
Packungen.xls
229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 |
# File 'lib/oddb2xml/extractor.rb', line 229 def to_hash # Packungen.xls data = {} case @type when :package typ = 6 # Heilmittelcode i_5,i_3 = 0,10 # :swissmedic_numbers p_5,p_1_2 = 0,1 # :prodno cat = 13 # :swissmedic_category ith = 4 # :ith_swissmedic IT-Code (swissmedic-diff) atc = 5 # :atc_code siz = 11 # :package_size eht = 12 # :einheit_swissmedic sub = 14 # :substance_swissmedic @sheet.each_with_index do |row, i| next if (i <= 1) next unless row[i_5] and row[i_3] 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) + row[p_1_2].value.to_i.to_s unless no8.empty? next if no8.to_i == 0 ean_base12 = "7680#{no8}" data[no8.intern] = { :ean => (ean_base12.ljust(12, '0') + 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] ? row[atc].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 : '', :is_tier => (row[typ] == 'Tierarzneimittel' ? true : false), } end end end data end |