Class: LedgerWeb::Report

Inherits:
Object
  • Object
show all
Defined in:
lib/ledger_web/report.rb

Constant Summary collapse

@@session = 
{}
@@params = 
{}

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize ⇒ Report

Returns a new instance of Report.



74
75
76
77
 
# File 'lib/ledger_web/report.rb', line 74

def initialize
  @fields = []
  @rows = []
end

Instance Attribute Details

#error ⇒ Object

Returns the value of attribute error.



18
19
20
 
# File 'lib/ledger_web/report.rb', line 18

def error
  @error
end

#fields ⇒ Object

Returns the value of attribute fields.



18
19
20
 
# File 'lib/ledger_web/report.rb', line 18

def fields
  @fields
end

#rows ⇒ Object

Returns the value of attribute rows.



18
19
20
 
# File 'lib/ledger_web/report.rb', line 18

def rows
  @rows
end

Class Method Details

.from_query(query) ⇒ Object 



39
40
41
42
43
44
45
46
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
72
 
# File 'lib/ledger_web/report.rb', line 39

def self.from_query(query)
  params = {
    :from => Report.session[:from],
    :to => Report.session[:to]
  }

  @@params.each do |key, val|
    params[key.to_sym] = val
  end

  ds = LedgerWeb::Database.handle.fetch(query, params)
  report = self.new
  begin
    row = ds.first
    if row.nil?
      raise "No data"
    end
    ds.columns.each do |col|
      report.add_field col.to_s
    end

    ds.each do |row|
      vals = []
      ds.columns.each do |col|
        vals << Cell.new(col.to_s, row[col])
      end
      report.add_row(vals)
    end
  rescue Exception => e
    report.error = e
  end

  return report
end

.params ⇒ Object 



35
36
37
 
# File 'lib/ledger_web/report.rb', line 35

def self.params
  @@params
end

.params=(params) ⇒ Object 



31
32
33
 
# File 'lib/ledger_web/report.rb', line 31

def self.params=(params)
  @@params = params
end

.session ⇒ Object 



27
28
29
 
# File 'lib/ledger_web/report.rb', line 27

def self.session
  @@session
end

.session=(session) ⇒ Object 



23
24
25
 
# File 'lib/ledger_web/report.rb', line 23

def self.session=(session)
  @@session = session
end

Instance Method Details

#add_field(field) ⇒ Object 



79
80
81
 
# File 'lib/ledger_web/report.rb', line 79

def add_field(field)
  @fields << field
end

#add_row(row) ⇒ Object 



83
84
85
86
87
88
 
# File 'lib/ledger_web/report.rb', line 83

def add_row(row)
  if row.length != @fields.length
    raise "row length not equal to fields length"
  end
  @rows << row
end

#each ⇒ Object 



90
91
92
93
94
 
# File 'lib/ledger_web/report.rb', line 90

def each
  @rows.each do |row|
    yield row
  end
end

#pivot(column, sort_order) ⇒ Object 



96
97
98
99
100
101
102
103
104
105
106
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
141
142
143
144
 
# File 'lib/ledger_web/report.rb', line 96

def pivot(column, sort_order)
  new_report = self.class.new

  bucket_column_index = 0
  self.fields.each_with_index do |f, i|
    if f == column
      bucket_column_index = i
      break
    else
      new_report.add_field(f)
    end
  end

  buckets = {}
  new_rows = {}

  self.each do |row|
    key = row[0, bucket_column_index].map { |r| r.value }
    bucket_name = row[bucket_column_index].value
    bucket_value = row[bucket_column_index + 1].value

    if not buckets.has_key? bucket_name
      buckets[bucket_name] = bucket_name
    end

    new_rows[key] ||= {}
    new_rows[key][bucket_name] = bucket_value
  end

  bucket_keys = buckets.keys.sort
  if sort_order && sort_order == 'desc'
    bucket_keys = bucket_keys.reverse
  end

  bucket_keys.each do |bucket|
    new_report.add_field(buckets[bucket])
  end

  new_rows.each do |key, value|
    row = key.each_with_index.map { |k,i| Cell.new(new_report.fields[i], k) }
    bucket_keys.each do |b|
      row << Cell.new(b.to_s, value[b])
    end

    new_report.add_row(row)
  end

  return new_report
end