Class: MecsRatio

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
lib/earth/industry/mecs_ratio.rb

Class Method Summary collapse

Class Method Details

.find_by_naics_code(code) ⇒ Object

Find the first record whose naics_code matches code and whose energy per dollar shipment is present. If no record found chop off the last character of code and try again, and so on.



17
18
19
 
# File 'lib/earth/industry/mecs_ratio.rb', line 17

def self.find_by_naics_code(code)
  candidate = find_by_naics_code_and_census_region_number(code, nil)
end

.find_by_naics_code_and_census_region_number(code, number, original_number = number) ⇒ Object

Find the first record whose census_region_number matches number, whose naics_code matches code, and whose energy per dollar of shipments is present. If none found and we know census region number, try looking nationwide If none found and looking nationwide, chop off the last character of code and try again looking in census region And so on



25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 
# File 'lib/earth/industry/mecs_ratio.rb', line 25

def self.find_by_naics_code_and_census_region_number(code, number, original_number = number)
  if code.blank?
    record = nil
  else
    code = Industry.format_naics_code code
    candidate = where(:census_region_number => number, :naics_code => code).first
    
    if candidate.try(:energy_per_dollar_of_shipments).present?
      record = candidate
    elsif number.present?
      record = find_by_naics_code_and_census_region_number(code, nil, original_number)
    else
      record = find_by_naics_code_and_census_region_number(code[0..-2], original_number)
    end
  end
  record
end