1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
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
145
146
147
148
149
150
|
/***************************************************************************
pivotgrid.h
-------------------
begin : Sat May 22 2004
copyright : (C) 2004-2005 by Ace Jones
email : <[email protected]>
Thomas Baumgart <[email protected]>
***************************************************************************/
/***************************************************************************
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
***************************************************************************/
#ifndef PIVOTGRID_H
#define PIVOTGRID_H
// ----------------------------------------------------------------------------
// TQt Includes
#include <tqmap.h>
#include <tqvaluelist.h>
// ----------------------------------------------------------------------------
// TDE Includes
// ----------------------------------------------------------------------------
// Project Includes
#include "reportaccount.h"
namespace reports {
enum ERowType {eActual, eBudget, eBudgetDiff, eForecast, eAverage, ePrice };
/**
* The fundamental data construct of this class is a 'grid'. It is organized as follows:
*
* A 'Row' is a row of money values, each column is a month. The first month corresponds to
* m_beginDate.
*
* A 'Row Pair' is two rows of money values. Each column is the SAME month. One row is the
* 'actual' values for the period, the other row is the 'budgetted' values for the same
* period. For ease of implementation, a Row Pair is implemented as a Row which contains
* another Row. The inherited Row is the 'actual', the contained row is the 'Budget'.
*
* An 'Inner Group' contains a rows for each subordinate account within a single top-level
* account. It also contains a mapping from the account descriptor for the subordinate account
* to its row data. So if we have an Expense account called "Computers", with sub-accounts called
* "Hardware", "Software", and "Peripherals", there will be one Inner Group for "Computers"
* which contains three Rows.
*
* An 'Outer Group' contains Inner Row Groups for all the top-level accounts in a given
* account class. Account classes are Expense, Income, Asset, Liability. In the case above,
* the "Computers" Inner Group is contained within the "Expense" Outer Group.
*
* A 'Grid' is the set of all Outer Groups contained in this report.
*
*/
class PivotCell: public MyMoneyMoney
{
public:
PivotCell() : m_stockSplit(MyMoneyMoney(1,1)), m_cellUsed(false) {}
PivotCell(const MyMoneyMoney& value);
static PivotCell stockSplit(const MyMoneyMoney& factor);
PivotCell operator += (const PivotCell& right);
PivotCell operator += (const MyMoneyMoney& value);
const TQString formatMoney(int fraction, bool showThousandSeparator = true) const;
const TQString formatMoney(const TQString& currency, const int prec, bool showThousandSeparator = true) const;
MyMoneyMoney calculateRunningSum(const MyMoneyMoney& runningSum);
MyMoneyMoney cellBalance(const MyMoneyMoney& _balance);
bool isUsed(void) const { return m_cellUsed; }
private:
MyMoneyMoney m_stockSplit;
MyMoneyMoney m_postSplit;
bool m_cellUsed;
};
class PivotGridRow: public TQValueList<PivotCell>
{
public:
PivotGridRow( unsigned _numcolumns = 0 )
{
if ( _numcolumns )
insert( end(), _numcolumns, PivotCell() );
}
MyMoneyMoney m_total;
};
class PivotGridRowSet: public TQMap<ERowType, PivotGridRow>
{
public:
PivotGridRowSet( unsigned _numcolumns = 0 );
};
class PivotInnerGroup: public TQMap<ReportAccount,PivotGridRowSet>
{
public:
PivotInnerGroup( unsigned _numcolumns = 0 ): m_total(_numcolumns) {}
PivotGridRowSet m_total;
};
class PivotOuterGroup: public TQMap<TQString,PivotInnerGroup>
{
public:
PivotOuterGroup( unsigned _numcolumns = 0, unsigned _sort=m_kDefaultSortOrder, bool _inverted=false): m_total(_numcolumns), m_inverted(_inverted), m_sortOrder(_sort) {}
int operator<( const PivotOuterGroup& _right )
{
if ( m_sortOrder != _right.m_sortOrder )
return m_sortOrder < _right.m_sortOrder;
else
return m_displayName < _right.m_displayName;
}
PivotGridRowSet m_total;
// An inverted outergroup means that all values placed in subordinate rows
// should have their sign inverted from typical cash-flow notation. Also it
// means that when the report is summed, the values should be inverted again
// so that the grand total is really "non-inverted outergroup MINUS inverted outergroup".
bool m_inverted;
// The localized name of the group for display in the report. Outergoups need this
// independently, because they will lose their association with the TGrid when the
// report is rendered.
TQString m_displayName;
// lower numbers sort toward the top of the report. defaults to 100, which is a nice
// middle-of-the-road value
unsigned m_sortOrder;
// default sort order
static const unsigned m_kDefaultSortOrder;
};
class PivotGrid: public TQMap<TQString,PivotOuterGroup>
{
public:
PivotGridRowSet rowSet (TQString id);
PivotGridRowSet m_total;
};
}
#endif
// PIVOTGRID_H
|
