Class: OldSql::ReportProcessor::Base

Inherits:
Object
  • Object
show all
Defined in:
lib/old_sql/report_processor/base.rb

Constant Summary collapse

ROUND_PRECISION =
OldSql.rounding_precision

Instance Method Summary collapse

Instance Method Details

#execute_query(report_config, start_date, end_date, query_vars = nil, sql_query = nil, db_class = nil) ⇒ Object



17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
# File 'lib/old_sql/report_processor/base.rb', line 17

def execute_query(report_config, start_date, end_date, query_vars = nil, sql_query = nil, db_class = nil)
  Rails.logger.info "debug 1"
  execute(report_config, start_date, end_date, query_vars, sql_query, db_class)
  
  return nil if @rec.nil?
  return parse(@resultset) if report_config.nil?
  
  @report_type = report_config['report_view']
  report_design = report_config['report_design']
  
  if report_design
    parse_design(report_design, @resultset) if report_design =~ /csv/
    parse_chart_design(report_design, @resultset) if report_design =~ /yml/
  else
    loaded_sub_processor = load_sub_processor(report_config['report_processor'])
    
    if loaded_sub_processor.nil?
      parse(@resultset)
    else
      @data = loaded_sub_processor.parse(@resultset)
    end
  end
  
  @data
end

#fields(report_config, start_date, end_date, query_vars = nil, sql_query = nil, db_class = nil) ⇒ Object



43
44
45
46
47
48
49
50
# File 'lib/old_sql/report_processor/base.rb', line 43

def fields(report_config, start_date, end_date, query_vars = nil, sql_query = nil, db_class = nil)
  return report_config['fields'] unless report_config.nil?
  
  execute(report_config, start_date, end_date, query_vars, sql_query, db_class)
  return humanize_fields(@rec.keys) unless @rec.nil?
  
  nil
end