class Twb::Analysis::SheetFiltersAnalyzerA

Attributes

localEmit[RW]

Public Class Methods

new() click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 28
def initialize
  init
  @funcdoc     = {:class=>self.class, :blurb=>'Analyze Worksheet filters.', :description=>'Documents Quick Filters and the values they employ, if any. Work in progess.',}
  #--
  docFileName  = docFile('WorksheetFiltersA.csv')
  $sheetFieldsCSV  = CSV.open( docFileName  ,'w')
  $sheetFieldsCSV  << ['Workbook','Worksheet','Filter Type','Operation','Data Source','Field','Value','Alias', 'Alias?']
  addDocFile docFileName, "Workbooks, Worksheets and the sheets' Quick Filters"
  #--
  @sheetCount  = 0
  @filterCount = 0
end

Public Instance Methods

metrics() click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 41
def metrics
  {
    '# of Worksheets'        => @sheetCount,
    '# of Worksheet Filters' => @filterCount
  }
end
parseFilters() click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 56
def parseFilters
  @worksheets  = @twb.worksheets
  @worksheets.each do |sheet|
    emit "\n\nSHEET: #{sheet.name}"
    filters = sheet.filters
    filters.each do |filter|
      filter.emit "-----------------------------\nWORKSHEET:: #{sheet.name}\n-----------------------------"
      if filter.values.empty?
      # $sheetFieldsCSV  << ['Workbook','Worksheet','Filter Type','Operation'     ,'Data Source','Field','Value','Alias', 'Alias?']
        $sheetFieldsCSV  << [@twbName  ,sheet.name, filter.type  ,filter.inexclude, filter.dataSource.uiname, filter.uiname,nil,nil,nil]
      end
      filter.values.each do |valueMap|
        value  = valueMap[:value]
        valias = valueMap[:alias]
        same   = value.eql? valias
        # puts "RECORDING FILTER VALUES:  %-25s  --  %-25s  same? %s " % [value,valias,same]
        $sheetFieldsCSV  << [@twbName  ,sheet.name, filter.type  ,filter.inexclude, filter.dataSource.uiname, filter.uiname, value, valias, same]
      end
    end
  end
end
processTWB(twb) click to toggle source
# File lib/twb/analysis/Sheets/sheetfiltersanalyzera.rb, line 48
def processTWB twb
   @twb     = twb
   @twbName = @twb.name
   emit "   -- #{@twbName}"
   @twbDomainsLoaded = false
   parseFilters
end