Class: RsrGroup::Inventory

Inherits:
Base
  • Object
show all
Defined in:
lib/rsr_group/inventory.rb

Constant Summary collapse

KEYDEALER_DIR = 
'keydealer'.freeze
INVENTORY_DIR = 
'ftpdownloads'.freeze
QTY_FILENAME = 
'IM-QTY-CSV.csv'.freeze
MAP_FILENAME = 
'retail-map.csv'.freeze
INVENTORY_FILENAME = 
'rsrinventory-new.txt'.freeze
KEYDEALER_FILENAME = 
'rsrinventory-keydlr-new.txt'.freeze
DEFAULT_SMART_OPTS = 
{
  chunk_size: 500,
  convert_values_to_numeric: false,
  col_sep: ";",
  quote_char: "|",
  headers_in_file: false,
  user_provided_headers: [
    :item_identifier, :upc, :short_description, :department_number, :manufacturer_id, :retail_price,
    :price, :weight, :quantity, :model, :manufacturer, :mfg_number, :allocated_closeout_deleted, :long_description,
    :image_name, 51.times.map { |i| "state_#{i}".to_sym }, :ships_ground_only, :signature_required, :blocked_from_drop_ship,
    :date_entered, :map_price, :image_disclaimer, :length, :width, :height, :null
  ].flatten,
  remove_unmapped_keys: true,
}

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from Base

connect

Constructor Details

#initialize(options = {}) ⇒ Inventory 



26
27
28
29
30
 
# File 'lib/rsr_group/inventory.rb', line 26

def initialize(options = {})
  requires!(options, :username, :password)

  @options = options
end

Class Method Details

.all(options = {}, &block) ⇒ Object 



42
43
44
45
 
# File 'lib/rsr_group/inventory.rb', line 42

def self.all(options = {}, &block)
  requires!(options, :username, :password)
  new(options).all &block
end

.get_quantity_file(options = {}) ⇒ Object 



32
33
34
35
 
# File 'lib/rsr_group/inventory.rb', line 32

def self.get_quantity_file(options = {})
  requires!(options, :username, :password)
  new(options).get_quantity_file
end

.quantity(options = {}, &block) ⇒ Object 



37
38
39
40
 
# File 'lib/rsr_group/inventory.rb', line 37

def self.quantity(options = {}, &block)
  requires!(options, :username, :password)
  new(options).quantity &block
end

Instance Method Details

#all(&block) ⇒ Object 



47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
 
# File 'lib/rsr_group/inventory.rb', line 47

def all(&block)
  connect(@options) do |ftp|
    tempfile = Tempfile.new

    # Is this a key dealer?
    if ftp.nlst.include?(KEYDEALER_DIR)
      ftp.chdir(KEYDEALER_DIR)
      # Pull from the FTP and save as a temp file
      ftp.getbinaryfile(KEYDEALER_FILENAME, tempfile.path)
    else
      ftp.chdir(INVENTORY_DIR)
      # Pull from the FTP and save as a temp file
      ftp.getbinaryfile(INVENTORY_FILENAME, tempfile.path)
    end

    SmarterCSV.process(tempfile, DEFAULT_SMART_OPTS) do |chunk|
      chunk.each do |item|
        yield(item)
      end
    end

    tempfile.unlink
    ftp.close
  end
end

#get_quantity_file ⇒ Object 



73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
 
# File 'lib/rsr_group/inventory.rb', line 73

def get_quantity_file
  connect(@options) do |ftp|
    quantity_tempfile = Tempfile.new
    tempfile          = Tempfile.new(['quantity-', '.csv'])

    # Is this a key dealer?
    if ftp.nlst.include?(KEYDEALER_DIR)
      ftp.chdir(KEYDEALER_DIR)
      # Pull from the FTP and save as a temp file
      ftp.getbinaryfile(QTY_FILENAME, quantity_tempfile.path)
    else
      ftp.chdir(INVENTORY_DIR)
      # Pull from the FTP and save as a temp file
      ftp.getbinaryfile(QTY_FILENAME, quantity_tempfile.path)
    end

    ftp.close

    SmarterCSV.process(quantity_tempfile.open, {
      chunk_size: 100,
      force_utf8: true,
      convert_values_to_numeric: false,
      user_provided_headers: [:item_identifier, :quantity]
    }) do |chunk|
      chunk.each do |item|
        tempfile.puts("#{item[:item_identifier]},#{item[:quantity].to_i}")
      end
    end

    quantity_tempfile.unlink
    tempfile.path
  end
end

#quantity(&block) ⇒ Object 



107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
 
# File 'lib/rsr_group/inventory.rb', line 107

def quantity(&block)
  connect(@options) do |ftp|
    tempfile = Tempfile.new

    # Is this a key dealer?
    if ftp.nlst.include?(KEYDEALER_DIR)
      ftp.chdir(KEYDEALER_DIR)
      # Pull from the FTP and save as a temp file
      ftp.getbinaryfile(QTY_FILENAME, tempfile.path)
    else
      ftp.chdir(INVENTORY_DIR)
      # Pull from the FTP and save as a temp file
      ftp.getbinaryfile(QTY_FILENAME, tempfile.path)
    end
    ftp.close

    smart_opts = { 
      col_sep: ",",
      headers_in_file: false,
      user_provided_headers: [
        :item_identifier,
        :quantity
      ]
    }

    SmarterCSV.process(tempfile, smart_opts) do |chunk|
      chunk.each do |item|
        yield(item)
      end
    end

    tempfile.unlink
  end
end