Class: ExcelImport::Adapters::Program

Inherits:
DataShift::Excel
  • Object
show all
Defined in:
lib/excel_import/adapters/program.rb

Constant Summary collapse

HEADERS =

HEADERS = [:loan_purpose, :loan_size, :loan_type, :team, :interest_rate, :lock_period, :fannie_mae, :base_rate, :adjustment_rate]

[:base_rate, :adjustment_rate, :loan_size, :loan_type, :term, :fannie_mae]

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize ⇒ Program

Returns a new instance of Program.



9
10
11
12
 
# File 'lib/excel_import/adapters/program.rb', line 9

def initialize
  super
  @headers = HEADERS
end

Instance Attribute Details

#headers ⇒ Object

Returns the value of attribute headers.



7
8
9
 
# File 'lib/excel_import/adapters/program.rb', line 7

def headers
  @headers
end

#reached_end ⇒ Object

Returns the value of attribute reached_end.



7
8
9
 
# File 'lib/excel_import/adapters/program.rb', line 7

def reached_end
  @reached_end
end

#start_index ⇒ Object

Returns the value of attribute start_index.



7
8
9
 
# File 'lib/excel_import/adapters/program.rb', line 7

def start_index
  @start_index
end

Instance Method Details

#get_single_row ⇒ Object 



21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/excel_import/adapters/program.rb', line 21

def get_single_row
  extractor = ProgramExtractor.new @current_sheet
  base_rate = extractor.base_rate.to_json
  adjustment_rate = extractor.adjustment_rate.to_json
  loan_size = extractor.loan_size
  loan_type = extractor.loan_type
  term = extractor.term
  fannie_mae = true

  return [base_rate, adjustment_rate, loan_size, loan_type, term, fannie_mae]
end

#sheet_final ⇒ Object 



14
15
16
17
18
19
 
# File 'lib/excel_import/adapters/program.rb', line 14

def sheet_final
  @current_sheet = self.worksheets.first
  ret = []
  ret << get_single_row
  ret
end