bool readRCFfromXMLDoc( QValueList<MyMoneyReport>& list, QDomDocument* doc )
{
bool result = false;
QDomElement rootElement = doc->documentElement();
if(!rootElement.isNull())
{
QDomNode child = rootElement.firstChild();
while(!child.isNull() && child.isElement())
{
QDomElement childElement = child.toElement();
if("REPORTS" == childElement.tagName())
{
result = true;
QDomNode subchild = child.firstChild();
while(!subchild.isNull() && subchild.isElement())
{
MyMoneyReport filter;
if ( filter.read(subchild.toElement()))
{
list += filter;
}
subchild = subchild.nextSibling();
}
}
child = child.nextSibling();
}
}
return result;
}
void QueryTableTest::testTaxReport()
{
try {
TransactionHelper t1q1( QDate(2004,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q1( QDate(2004,2,1), MyMoneySplit::ActionWithdrawal, moParent1, acChecking, acTax );
unsigned cols;
MyMoneyReport filter;
filter.setRowType( MyMoneyReport::eCategory );
filter.setName("Tax Transactions");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCaccount;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) );
filter.setTax(true);
XMLandback(filter);
QueryTable qtbl_3(filter);
writeTabletoHTML(qtbl_3,"Tax Transactions.html");
QValueList<ListTable::TableRow> rows = qtbl_3.rows();
QString html = qtbl_3.renderHTML();
CPPUNIT_ASSERT(rows.count() == 1);
} catch(MyMoneyException *e) {
CPPUNIT_FAIL(e->what());
delete e;
}
}
void KForecastView::loadChartView()
{
MyMoneyReport::EDetailLevel detailLevel[4] = { MyMoneyReport::eDetailAll, MyMoneyReport::eDetailTop, MyMoneyReport::eDetailGroup, MyMoneyReport::eDetailTotal };
MyMoneyReport reportCfg = MyMoneyReport(
MyMoneyReport::eAssetLiability,
MyMoneyReport::eMonths,
MyMoneyTransactionFilter::userDefined, // overridden by the setDateFilter() call below
detailLevel[m_comboDetail->currentIndex()],
i18n("Net Worth Forecast"),
i18n("Generated Report"));
reportCfg.setChartByDefault(true);
reportCfg.setChartGridLines(false);
reportCfg.setChartType(MyMoneyReport::eChartLine);
reportCfg.setIncludingSchedules(false);
// FIXME: this causes a crash
//reportCfg.setColumnsAreDays( true );
reportCfg.setChartDataLabels(false);
reportCfg.setConvertCurrency(true);
reportCfg.setIncludingForecast(true);
reportCfg.setDateFilter(QDate::currentDate(), QDate::currentDate().addDays(m_forecastDays->value()));
reports::PivotTable table(reportCfg);
table.drawChart(*m_forecastChart);
// Adjust the size
m_forecastChart->resize(m_tab->width() - 10, m_tab->height());
//m_forecastChart->show();
m_forecastChart->update();
}
//this is to prevent me from making mistakes again when modifying balances - asoliverez
//this case tests only the opening and ending balance of the accounts
void QueryTableTest::testBalanceColumn()
{
try
{
TransactionHelper t1q1( QDate(2004,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q1( QDate(2004,2,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3q1( QDate(2004,3,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4y1( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
TransactionHelper t1q2( QDate(2004,4,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q2( QDate(2004,5,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3q2( QDate(2004,6,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4q2( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
TransactionHelper t1y2( QDate(2005,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2y2( QDate(2005,5,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3y2( QDate(2005,9,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4y2( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
unsigned cols;
MyMoneyReport filter;
filter.setRowType( MyMoneyReport::eAccount );
filter.setName("Transactions by Account");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCcategory | MyMoneyReport::eQCbalance;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
XMLandback(filter);
QueryTable qtbl_3(filter);
writeTabletoHTML(qtbl_3,"Transactions by Account.html");
QString html = qtbl_3.renderHTML();
QValueList<ListTable::TableRow> rows = qtbl_3.rows();
CPPUNIT_ASSERT(rows.count() == 16);
//this is to make sure that the dates of closing and opening balances and the balance numbers are ok
QString openingDate = KGlobal::locale()->formatDate(QDate(2004,1,1), true);
QString closingDate = KGlobal::locale()->formatDate(QDate(2005,9,1), true);
CPPUNIT_ASSERT( html.find(openingDate + "</td><td class=\"left\"></td><td class=\"left\">"+i18n("Opening Balance")) > 0);
CPPUNIT_ASSERT( html.find(closingDate + "</td><td class=\"left\"></td><td class=\"left\">"+i18n("Closing Balance")+"</td><td class=\"left\"></td><td class=\"value\"></td><td> -702.36</td></tr>") > 0);
CPPUNIT_ASSERT( html.find(closingDate + "</td><td class=\"left\"></td><td class=\"left\">"+i18n("Closing Balance")+"</td><td class=\"left\"></td><td class=\"value\"></td><td> -705.69</td></tr>") > 0);
}
catch(MyMoneyException *e)
{
CPPUNIT_FAIL(e->what());
delete e;
}
}
void writeRCFtoXMLDoc( const MyMoneyReport& filter, QDomDocument* doc )
{
QDomProcessingInstruction instruct = doc->createProcessingInstruction(QString("xml"), QString("version=\"1.0\" encoding=\"utf-8\""));
doc->appendChild(instruct);
QDomElement root = doc->createElement("KMYMONEY-FILE");
doc->appendChild(root);
QDomElement reports = doc->createElement("REPORTS");
root.appendChild(reports);
QDomElement report = doc->createElement("REPORT");
filter.write(report,doc);
reports.appendChild(report);
}
void QueryTableTest::testQueryBasics()
{
try
{
TransactionHelper t1q1( QDate(2004,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q1( QDate(2004,2,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3q1( QDate(2004,3,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4y1( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
TransactionHelper t1q2( QDate(2004,4,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q2( QDate(2004,5,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3q2( QDate(2004,6,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4q2( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
TransactionHelper t1y2( QDate(2005,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2y2( QDate(2005,5,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3y2( QDate(2005,9,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4y2( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
unsigned cols;
MyMoneyReport filter;
filter.setRowType( MyMoneyReport::eCategory );
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCaccount;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
filter.setName("Transactions by Category");
XMLandback(filter);
QueryTable qtbl_1(filter);
writeTabletoHTML(qtbl_1,"Transactions by Category.html");
QValueList<ListTable::TableRow> rows = qtbl_1.rows();
CPPUNIT_ASSERT(rows.count() == 12);
CPPUNIT_ASSERT(rows[0]["categorytype"]=="Expense");
CPPUNIT_ASSERT(rows[0]["category"]=="Parent");
CPPUNIT_ASSERT(rows[0]["postdate"]=="2004-02-01");
CPPUNIT_ASSERT(rows[11]["categorytype"]=="Expense");
CPPUNIT_ASSERT(rows[11]["category"]=="Solo");
CPPUNIT_ASSERT(rows[11]["postdate"]=="2005-01-01");
QString html = qtbl_1.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Parent") == -(moParent1 + moParent2) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Parent: Child") == -(moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Solo") == -(moSolo) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Expense") == -(moParent1 + moParent2 + moSolo + moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == -(moParent1 + moParent2 + moSolo + moChild) * 3 + moCheckingOpen + moCreditOpen );
filter.setRowType( MyMoneyReport::eTopCategory );
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCaccount;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
filter.setName("Transactions by Top Category");
XMLandback(filter);
QueryTable qtbl_2(filter);
writeTabletoHTML(qtbl_2,"Transactions by Top Category.html");
rows = qtbl_2.rows();
CPPUNIT_ASSERT(rows.count() == 12);
CPPUNIT_ASSERT(rows[0]["categorytype"]=="Expense");
CPPUNIT_ASSERT(rows[0]["topcategory"]=="Parent");
CPPUNIT_ASSERT(rows[0]["postdate"]=="2004-02-01");
CPPUNIT_ASSERT(rows[8]["categorytype"]=="Expense");
CPPUNIT_ASSERT(rows[8]["topcategory"]=="Parent");
CPPUNIT_ASSERT(rows[8]["postdate"]=="2005-09-01");
CPPUNIT_ASSERT(rows[11]["categorytype"]=="Expense");
CPPUNIT_ASSERT(rows[11]["topcategory"]=="Solo");
CPPUNIT_ASSERT(rows[11]["postdate"]=="2005-01-01");
html = qtbl_2.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Parent") == -(moParent1 + moParent2 + moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Solo") == -(moSolo) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Expense") == -(moParent1 + moParent2 + moSolo + moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == -(moParent1 + moParent2 + moSolo + moChild) * 3 + moCheckingOpen + moCreditOpen);
filter.setRowType( MyMoneyReport::eAccount );
filter.setName("Transactions by Account");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCcategory;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
XMLandback(filter);
QueryTable qtbl_3(filter);
writeTabletoHTML(qtbl_3,"Transactions by Account.html");
rows = qtbl_3.rows();
#if 1
CPPUNIT_ASSERT(rows.count() == 16);
CPPUNIT_ASSERT(rows[1]["account"]=="Checking Account");
CPPUNIT_ASSERT(rows[1]["category"]=="Solo");
CPPUNIT_ASSERT(rows[1]["postdate"]=="2004-01-01");
CPPUNIT_ASSERT(rows[14]["account"]=="Credit Card");
CPPUNIT_ASSERT(rows[14]["category"]=="Parent");
CPPUNIT_ASSERT(rows[14]["postdate"]=="2005-09-01");
#else
CPPUNIT_ASSERT(rows.count() == 12);
CPPUNIT_ASSERT(rows[0]["account"]=="Checking Account");
CPPUNIT_ASSERT(rows[0]["category"]=="Solo");
CPPUNIT_ASSERT(rows[0]["postdate"]=="2004-01-01");
CPPUNIT_ASSERT(rows[11]["account"]=="Credit Card");
CPPUNIT_ASSERT(rows[11]["category"]=="Parent");
CPPUNIT_ASSERT(rows[11]["postdate"]=="2005-09-01");
#endif
html = qtbl_3.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Checking Account") == -(moSolo) * 3 + moCheckingOpen);
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Credit Card") == -(moParent1 + moParent2 + moChild) * 3 + moCreditOpen );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == -(moParent1 + moParent2 + moSolo + moChild) * 3 + moCheckingOpen + moCreditOpen);
filter.setRowType( MyMoneyReport::ePayee );
filter.setName("Transactions by Payee");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCmemo | MyMoneyReport::eQCcategory;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
XMLandback(filter);
QueryTable qtbl_4(filter);
writeTabletoHTML(qtbl_4,"Transactions by Payee.html");
rows = qtbl_4.rows();
CPPUNIT_ASSERT(rows.count() == 12);
CPPUNIT_ASSERT(rows[0]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[0]["category"]=="Solo");
CPPUNIT_ASSERT(rows[0]["postdate"]=="2004-01-01");
CPPUNIT_ASSERT(rows[8]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[8]["category"]=="Parent: Child");
CPPUNIT_ASSERT(rows[8]["postdate"]=="2004-11-07");
CPPUNIT_ASSERT(rows[11]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[11]["category"]=="Parent");
CPPUNIT_ASSERT(rows[11]["postdate"]=="2005-09-01");
html = qtbl_4.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Test Payee") == -(moParent1 + moParent2 + moSolo + moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == -(moParent1 + moParent2 + moSolo + moChild) * 3 + moCheckingOpen + moCreditOpen);
filter.setRowType( MyMoneyReport::eMonth );
filter.setName("Transactions by Month");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCcategory;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
XMLandback(filter);
QueryTable qtbl_5(filter);
writeTabletoHTML(qtbl_5,"Transactions by Month.html");
rows = qtbl_5.rows();
CPPUNIT_ASSERT(rows.count() == 12);
CPPUNIT_ASSERT(rows[0]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[0]["category"]=="Solo");
CPPUNIT_ASSERT(rows[0]["postdate"]=="2004-01-01");
CPPUNIT_ASSERT(rows[8]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[8]["category"]=="Parent: Child");
CPPUNIT_ASSERT(rows[8]["postdate"]=="2004-11-07");
CPPUNIT_ASSERT(rows[11]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[11]["category"]=="Parent");
CPPUNIT_ASSERT(rows[11]["postdate"]=="2005-09-01");
html = qtbl_5.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Month of 2004-01-01") == -moSolo );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Month of 2004-11-01") == -(moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Month of 2004-05-01") == -moParent1 + moCheckingOpen );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == -(moParent1 + moParent2 + moSolo + moChild) * 3 + moCheckingOpen + moCreditOpen);
filter.setRowType( MyMoneyReport::eWeek );
filter.setName("Transactions by Week");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCcategory;
filter.setQueryColumns( static_cast<MyMoneyReport::EQueryColumns>(cols) ); //
XMLandback(filter);
QueryTable qtbl_6(filter);
writeTabletoHTML(qtbl_6,"Transactions by Week.html");
rows = qtbl_6.rows();
CPPUNIT_ASSERT(rows.count() == 12);
CPPUNIT_ASSERT(rows[0]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[0]["category"]=="Solo");
CPPUNIT_ASSERT(rows[0]["postdate"]=="2004-01-01");
CPPUNIT_ASSERT(rows[11]["payee"]=="Test Payee");
CPPUNIT_ASSERT(rows[11]["category"]=="Parent");
CPPUNIT_ASSERT(rows[11]["postdate"]=="2005-09-01");
html = qtbl_6.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Week of 2003-12-29") == -moSolo );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Week of 2004-11-01") == -(moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" Week of 2005-08-29") == -moParent2 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == -(moParent1 + moParent2 + moSolo + moChild) * 3 + moCheckingOpen + moCreditOpen);
}
catch(MyMoneyException *e)
{
CPPUNIT_FAIL(e->what());
delete e;
}
// Test querytable::TableRow::operator> and operator==
QueryTable::TableRow low;
low["first"] = "A";
low["second"] = "B";
low["third"] = "C";
QueryTable::TableRow high;
high["first"] = "A";
high["second"] = "C";
high["third"] = "B";
QueryTable::TableRow::setSortCriteria("first,second,third");
CPPUNIT_ASSERT( low < high );
CPPUNIT_ASSERT( low <= high );
CPPUNIT_ASSERT( high > low );
CPPUNIT_ASSERT( high <= high );
CPPUNIT_ASSERT( high == high );
}
void QueryTableTest::testAccountQuery()
{
try
{
QString htmlcontext = QString("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0//EN\">\n<html><head><link rel=\"stylesheet\" type=\"text/css\" href=\"html/kmymoney2.css\"></head><body>\n%1\n</body></html>\n");
//
// No transactions, opening balances only
//
MyMoneyReport filter;
filter.setRowType( MyMoneyReport::eInstitution );
filter.setName("Accounts by Institution (No transactions)");
XMLandback(filter);
QueryTable qtbl_1(filter);
writeTabletoHTML(qtbl_1,"Accounts by Institution (No transactions).html");
QValueList<ListTable::TableRow> rows = qtbl_1.rows();
CPPUNIT_ASSERT(rows.count() == 2);
CPPUNIT_ASSERT(rows[0]["account"]=="Checking Account");
CPPUNIT_ASSERT(MyMoneyMoney(rows[0]["value"])==moCheckingOpen);
CPPUNIT_ASSERT(rows[0]["equitytype"].isEmpty());
CPPUNIT_ASSERT(rows[1]["account"]=="Credit Card");
CPPUNIT_ASSERT(MyMoneyMoney(rows[1]["value"])==moCreditOpen);
CPPUNIT_ASSERT(rows[1]["equitytype"].isEmpty());
QString html = qtbl_1.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" None") == moCheckingOpen+moCreditOpen );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == moCheckingOpen+moCreditOpen );
//
// Adding in transactions
//
TransactionHelper t1q1( QDate(2004,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q1( QDate(2004,2,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3q1( QDate(2004,3,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4y1( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
TransactionHelper t1q2( QDate(2004,4,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2q2( QDate(2004,5,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3q2( QDate(2004,6,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4q2( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
TransactionHelper t1y2( QDate(2005,1,1), MyMoneySplit::ActionWithdrawal, moSolo, acChecking, acSolo );
TransactionHelper t2y2( QDate(2005,5,1), MyMoneySplit::ActionWithdrawal, moParent1, acCredit, acParent );
TransactionHelper t3y2( QDate(2005,9,1), MyMoneySplit::ActionWithdrawal, moParent2, acCredit, acParent );
TransactionHelper t4y2( QDate(2004,11,7), MyMoneySplit::ActionWithdrawal, moChild, acCredit, acChild );
filter.setRowType( MyMoneyReport::eInstitution );
filter.setName("Accounts by Institution (With Transactions)");
XMLandback(filter);
QueryTable qtbl_2(filter);
rows = qtbl_2.rows();
CPPUNIT_ASSERT(rows.count() == 2);
CPPUNIT_ASSERT(rows[0]["account"]=="Checking Account");
CPPUNIT_ASSERT(MyMoneyMoney(rows[0]["value"])==(moCheckingOpen-moSolo*3));
CPPUNIT_ASSERT(rows[1]["account"]=="Credit Card");
CPPUNIT_ASSERT(MyMoneyMoney(rows[1]["value"])==(moCreditOpen-(moParent1 + moParent2 + moChild) * 3));
html = qtbl_2.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == moCheckingOpen+moCreditOpen-(moParent1 + moParent2 + moSolo + moChild) * 3 );
//
// Account TYPES
//
filter.setRowType( MyMoneyReport::eAccountType );
filter.setName("Accounts by Type");
XMLandback(filter);
QueryTable qtbl_3(filter);
rows = qtbl_3.rows();
CPPUNIT_ASSERT(rows.count() == 2);
CPPUNIT_ASSERT(rows[0]["account"]=="Checking Account");
CPPUNIT_ASSERT(MyMoneyMoney(rows[0]["value"])==(moCheckingOpen-moSolo*3));
CPPUNIT_ASSERT(rows[1]["account"]=="Credit Card");
CPPUNIT_ASSERT(MyMoneyMoney(rows[1]["value"])==(moCreditOpen-(moParent1 + moParent2 + moChild) * 3));
html = qtbl_3.renderHTML();
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" "+i18n("Checking")) == moCheckingOpen-moSolo*3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Total")+" "+i18n("Credit Card")) == moCreditOpen-(moParent1 + moParent2 + moChild) * 3 );
CPPUNIT_ASSERT( searchHTML(html,i18n("Grand Total")) == moCheckingOpen+moCreditOpen-(moParent1 + moParent2 + moSolo + moChild) * 3 );
}
catch(MyMoneyException *e)
{
CPPUNIT_FAIL(e->what());
delete e;
}
}
void QueryTableTest::testBalanceColumnWithMultipleCurrencies()
{
try {
MyMoneyMoney moJpyOpening(0.0, 1);
MyMoneyMoney moJpyPrice(0.010, 100);
MyMoneyMoney moJpyPrice2(0.011, 100);
MyMoneyMoney moJpyPrice3(0.024, 100);
MyMoneyMoney moTransaction(100, 1);
MyMoneyMoney moJpyTransaction(100, 1);
QString acJpyChecking = makeAccount(QString("Japanese Checking"), MyMoneyAccount::Checkings, moJpyOpening, QDate(2003, 11, 15), acAsset, "JPY");
makePrice("JPY", QDate(2004, 1, 1), MyMoneyMoney(moJpyPrice));
makePrice("JPY", QDate(2004, 5, 1), MyMoneyMoney(moJpyPrice2));
makePrice("JPY", QDate(2004, 6, 30), MyMoneyMoney(moJpyPrice3));
QDate openingDate(2004, 2, 20);
QDate intermediateDate(2004, 5, 20);
QDate closingDate(2004, 7, 20);
TransactionHelper t1(openingDate, MyMoneySplit::ActionTransfer, MyMoneyMoney(moJpyTransaction), acJpyChecking, acChecking, "JPY");
TransactionHelper t4(openingDate, MyMoneySplit::ActionDeposit, MyMoneyMoney(moTransaction), acCredit, acChecking);
TransactionHelper t2(intermediateDate, MyMoneySplit::ActionTransfer, MyMoneyMoney(moJpyTransaction), acJpyChecking, acChecking, "JPY");
TransactionHelper t5(intermediateDate, MyMoneySplit::ActionDeposit, MyMoneyMoney(moTransaction), acCredit, acChecking);
TransactionHelper t3(closingDate, MyMoneySplit::ActionTransfer, MyMoneyMoney(moJpyTransaction), acJpyChecking, acChecking, "JPY");
TransactionHelper t6(closingDate, MyMoneySplit::ActionDeposit, MyMoneyMoney(moTransaction), acCredit, acChecking);
// test that an income/expense transaction that involves a currency exchange is properly reported
TransactionHelper t7(intermediateDate, MyMoneySplit::ActionWithdrawal, MyMoneyMoney(moJpyTransaction), acJpyChecking, acSolo, "JPY");
unsigned cols;
MyMoneyReport filter;
filter.setRowType(MyMoneyReport::eAccount);
filter.setName("Transactions by Account");
cols = MyMoneyReport::eQCnumber | MyMoneyReport::eQCpayee | MyMoneyReport::eQCcategory | MyMoneyReport::eQCbalance;
filter.setQueryColumns(static_cast<MyMoneyReport::EQueryColumns>(cols));
// don't convert values to the default currency
filter.setConvertCurrency(false);
XMLandback(filter);
QueryTable qtbl_3(filter);
writeTabletoHTML(qtbl_3, "Transactions by Account (multiple currencies).html");
QString html = qtbl_3.renderBody();
QList<ListTable::TableRow> rows = qtbl_3.rows();
QVERIFY(rows.count() == 19);
//this is to make sure that the dates of closing and opening balances and the balance numbers are ok
QString openingDateString = QLocale().toString(openingDate, QLocale::ShortFormat);
QString intermediateDateString = QLocale().toString(intermediateDate, QLocale::ShortFormat);
QString closingDateString = QLocale().toString(closingDate, QLocale::ShortFormat);
// check the opening and closing balances
QVERIFY(html.indexOf(openingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Opening Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> 0.00</td></tr>") > 0);
QVERIFY(html.indexOf(closingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Closing Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> 304.00</td></tr>") > 0);
QVERIFY(html.indexOf(closingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Closing Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> -300.00</td></tr>") > 0);
QVERIFY(html.indexOf(closingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Closing Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td>JPY -400.00</td></tr>") > 0);
// after a transfer of 100 JPY the balance should be 1.00 - price is 0.010 (precision of 2)
QVERIFY(html.indexOf("<a href=ledger?id=A000001&tid=T000000000000000001>" + openingDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer from Japanese Checking</td><td class=\"value\"> 1.00</td><td> 1.00</td></tr>") > 0);
// after a transfer of 100 the balance should be 101.00
QVERIFY(html.indexOf("<a href=ledger?id=A000001&tid=T000000000000000002>" + openingDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer from Credit Card</td><td class=\"value\"> 100.00</td><td> 101.00</td></tr>") > 0);
// after a transfer of 100 JPY the balance should be 102.00 - price is 0.011 (precision of 2)
QVERIFY(html.indexOf("<a href=ledger?id=A000001&tid=T000000000000000003>" + intermediateDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer from Japanese Checking</td><td class=\"value\"> 1.00</td><td> 102.00</td></tr>") > 0);
// after a transfer of 100 the balance should be 202.00
QVERIFY(html.indexOf("<a href=ledger?id=A000001&tid=T000000000000000004>" + intermediateDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer from Credit Card</td><td class=\"value\"> 100.00</td><td> 202.00</td></tr>") > 0);
// after a transfer of 100 JPY the balance should be 204.00 - price is 0.024 (precision of 2)
QVERIFY(html.indexOf("<a href=ledger?id=A000001&tid=T000000000000000005>" + closingDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer from Japanese Checking</td><td class=\"value\"> 2.00</td><td> 204.00</td></tr>") > 0);
// after a transfer of 100 the balance should be 304.00
QVERIFY(html.indexOf("<a href=ledger?id=A000001&tid=T000000000000000006>" + closingDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer from Credit Card</td><td class=\"value\"> 100.00</td><td> 304.00</td></tr>") > 0);
// a 100.00 JPY withdrawal should be displayed as such even if the expense account uses another currency
QVERIFY(html.indexOf("<a href=ledger?id=A000008&tid=T000000000000000007>" + intermediateDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Solo</td><td class=\"value\">JPY -100.00</td><td>JPY -300.00</td></tr>") > 0);
// now run the same report again but this time convert all values to the base currency and make sure the values are correct
filter.setConvertCurrency(true);
XMLandback(filter);
QueryTable qtbl_4(filter);
writeTabletoHTML(qtbl_4, "Transactions by Account (multiple currencies converted to base).html");
html = qtbl_4.renderBody();
rows = qtbl_4.rows();
QVERIFY(rows.count() == 19);
// check the opening and closing balances
QVERIFY(html.indexOf(openingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Opening Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> 0.00</td></tr>") > 0);
QVERIFY(html.indexOf(closingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Closing Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> 304.00</td></tr>") > 0);
QVERIFY(html.indexOf(closingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Closing Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> -300.00</td></tr>") > 0);
// although the balance should be -5.00 it's -8.00 because the foreign currency balance is converted using the closing date price (0.024)
QVERIFY(html.indexOf(closingDateString + "</td><td class=\"left\"></td><td class=\"left\">" + i18n("Closing Balance") + "</td><td class=\"left\"></td><td class=\"value\"></td><td> -8.00</td></tr>") > 0);
// a 100.00 JPY transfer should be displayed as -1.00 when converted to the base currency using the opening date price
QVERIFY(html.indexOf("<a href=ledger?id=A000008&tid=T000000000000000001>" + openingDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer to Checking Account</td><td class=\"value\"> -1.00</td><td> -1.00</td></tr>") > 0);
// a 100.00 JPY transfer should be displayed as -1.00 when converted to the base currency using the intermediate date price
QVERIFY(html.indexOf("<a href=ledger?id=A000008&tid=T000000000000000003>" + intermediateDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer to Checking Account</td><td class=\"value\"> -1.00</td><td> -2.00</td></tr>") > 0);
// a 100.00 JPY withdrawal should be displayed as -1.00 when converted to the base currency using the intermediate date price
QVERIFY(html.indexOf("<a href=ledger?id=A000008&tid=T000000000000000007>" + intermediateDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Solo</td><td class=\"value\"> -1.00</td><td> -3.00</td></tr>") > 0);
// a 100.00 JPY transfer should be displayed as -2.00 when converted to the base currency using the closing date price (notice the balance is -5.00)
QVERIFY(html.indexOf("<a href=ledger?id=A000008&tid=T000000000000000005>" + closingDateString + "</a></td><td class=\"left\"></td><td class=\"left\">Test Payee</td><td class=\"left\">Transfer to Checking Account</td><td class=\"value\"> -2.00</td><td> -5.00</td></tr>") > 0);
} catch (const MyMoneyException &e) {
QFAIL(qPrintable(e.what()));
}
}
void KReportChartView::drawPivotChart(const PivotGrid &grid, const MyMoneyReport &config, int numberColumns, const QStringList& columnHeadings, const QList<ERowType>& rowTypeList, const QStringList& columnTypeHeaderList)
{
//set the number of columns
setNumColumns(numberColumns);
//set skipZero
m_skipZero = config.isSkippingZero();
//remove existing headers
while (headerFooters().count() > 0) {
HeaderFooter* delHeader = headerFooters().at(0);
takeHeaderFooter(delHeader);
delete delHeader;
}
//make sure the model is clear
m_model.removeColumns(0, m_model.columnCount());
m_model.removeRows(0, m_model.rowCount());
//set the new header
HeaderFooter* header = new HeaderFooter(this);
header->setText(config.name());
header->setType(HeaderFooter::Header);
header->setPosition(Position::North);
TextAttributes headerTextAttr(header->textAttributes());
headerTextAttr.setPen(m_foregroundBrush.color());
header->setTextAttributes(headerTextAttr);
addHeaderFooter(header);
// whether to limit the chart to use series totals only. Used for reports which only
// show one dimension (pie).
setSeriesTotals(false);
// whether series (rows) are accounts (true) or months (false). This causes a lot
// of complexity in the charts. The problem is that circular reports work best with
// an account in a COLUMN, while line/bar prefer it in a ROW.
setAccountSeries(true);
switch (config.chartType()) {
case MyMoneyReport::eChartNone:
case MyMoneyReport::eChartEnd:
case MyMoneyReport::eChartLine: {
KDChart::LineDiagram* diagram = new KDChart::LineDiagram;
if (config.isSkippingZero()) {
LineAttributes attributes = diagram->lineAttributes();
attributes.setMissingValuesPolicy(LineAttributes::MissingValuesAreBridged);
diagram->setLineAttributes(attributes);
}
CartesianCoordinatePlane* cartesianPlane = new CartesianCoordinatePlane;
replaceCoordinatePlane(cartesianPlane);
coordinatePlane()->replaceDiagram(diagram);
break;
}
case MyMoneyReport::eChartBar: {
KDChart::BarDiagram* diagram = new KDChart::BarDiagram;
CartesianCoordinatePlane* cartesianPlane = new CartesianCoordinatePlane;
replaceCoordinatePlane(cartesianPlane);
coordinatePlane()->replaceDiagram(diagram);
break;
}
case MyMoneyReport::eChartStackedBar: {
KDChart::BarDiagram* diagram = new KDChart::BarDiagram;
CartesianCoordinatePlane* cartesianPlane = new CartesianCoordinatePlane;
replaceCoordinatePlane(cartesianPlane);
diagram->setType(BarDiagram::Stacked);
coordinatePlane()->replaceDiagram(diagram);
break;
}
case MyMoneyReport::eChartPie: {
KDChart::PieDiagram* diagram = new KDChart::PieDiagram;
PolarCoordinatePlane* polarPlane = new PolarCoordinatePlane;
replaceCoordinatePlane(polarPlane);
coordinatePlane()->replaceDiagram(diagram);
setAccountSeries(false);
setSeriesTotals(true);
break;
}
case MyMoneyReport::eChartRing: {
KDChart::RingDiagram* diagram = new KDChart::RingDiagram;
PolarCoordinatePlane* polarPlane = new PolarCoordinatePlane;
replaceCoordinatePlane(polarPlane);
polarPlane->replaceDiagram(diagram);
//chartView.params()->setRelativeRingThickness( true );
setAccountSeries(false);
break;
}
}
//get the diagram for later use
AbstractDiagram* planeDiagram = coordinatePlane()->diagram();
//set grid attributes
GridAttributes gridAttr(coordinatePlane()->globalGridAttributes());
gridAttr.setGridVisible(config.isChartGridLines());
coordinatePlane()->setGlobalGridAttributes(gridAttr);
//the palette - we set it here because it is a property of the diagram
switch (KMyMoneySettings::chartsPalette()) {
case 0:
planeDiagram->useDefaultColors();
break;
case 1:
planeDiagram->useRainbowColors();
break;
case 2:
default:
planeDiagram->useSubduedColors();
break;
}
//the legend will be used later
Legend* legend = new Legend(planeDiagram, this);
legend->setTitleText(i18nc("Chart legend title", "Legend"));
//set up the axes for cartesian diagrams
if (config.chartType() == MyMoneyReport::eChartLine ||
config.chartType() == MyMoneyReport::eChartBar ||
config.chartType() == MyMoneyReport::eChartStackedBar) {
//set x axis
CartesianAxis *xAxis = new CartesianAxis();
xAxis->setPosition(CartesianAxis::Bottom);
xAxis->setTitleText(i18n("Time"));
TextAttributes xAxisTitleTextAttr(xAxis->titleTextAttributes());
xAxisTitleTextAttr.setMinimalFontSize(KGlobalSettings::generalFont().pointSize());
xAxisTitleTextAttr.setPen(m_foregroundBrush.color());
xAxis->setTitleTextAttributes(xAxisTitleTextAttr);
TextAttributes xAxisTextAttr(xAxis->textAttributes());
xAxisTextAttr.setPen(m_foregroundBrush.color());
xAxis->setTextAttributes(xAxisTextAttr);
RulerAttributes xAxisRulerAttr(xAxis->rulerAttributes());
xAxisRulerAttr.setTickMarkPen(m_foregroundBrush.color());
xAxisRulerAttr.setShowRulerLine(true);
xAxis->setRulerAttributes(xAxisRulerAttr);
// Set up X axis labels (ie "abscissa" to use the technical term)
QStringList abscissaNames;
if (accountSeries()) { // if not, we will set these up while putting in the chart values.
int column = 1;
while (column < numColumns()) {
abscissaNames += QString(columnHeadings[column++]).replace(" ", " ");
}
xAxis->setLabels(abscissaNames);
}
//set y axis
KBalanceAxis *yAxis = new KBalanceAxis();
yAxis->setPosition(CartesianAxis::Left);
// TODO
// if the chart shows prices and no balance
// the axis title should be 'Price'
if (config.isIncludingPrice()) {
yAxis->setTitleText(i18n("Price"));
} else {
yAxis->setTitleText(i18n("Balance"));
}
TextAttributes yAxisTitleTextAttr(yAxis->titleTextAttributes());
yAxisTitleTextAttr.setMinimalFontSize(KGlobalSettings::generalFont().pointSize());
yAxisTitleTextAttr.setPen(m_foregroundBrush.color());
yAxis->setTitleTextAttributes(yAxisTitleTextAttr);
TextAttributes yAxisTextAttr(yAxis->textAttributes());
yAxisTextAttr.setPen(m_foregroundBrush.color());
yAxis->setTextAttributes(yAxisTextAttr);
RulerAttributes yAxisRulerAttr(yAxis->rulerAttributes());
yAxisRulerAttr.setTickMarkPen(m_foregroundBrush.color());
yAxisRulerAttr.setShowRulerLine(true);
yAxis->setRulerAttributes(yAxisRulerAttr);
//add the axes to the corresponding diagram
if (config.chartType() == MyMoneyReport::eChartLine) {
KDChart::LineDiagram* lineDiagram = qobject_cast<LineDiagram*>(planeDiagram);
lineDiagram->addAxis(xAxis);
lineDiagram->addAxis(yAxis);
} else if (config.chartType() == MyMoneyReport::eChartBar ||
config.chartType() == MyMoneyReport::eChartStackedBar) {
KDChart::BarDiagram* barDiagram = qobject_cast<BarDiagram*>(planeDiagram);
barDiagram->addAxis(xAxis);
barDiagram->addAxis(yAxis);
}
}
switch (config.detailLevel()) {
case MyMoneyReport::eDetailNone:
case MyMoneyReport::eDetailEnd:
case MyMoneyReport::eDetailAll: {
int rowNum = 0;
// iterate over outer groups
PivotGrid::const_iterator it_outergroup = grid.begin();
while (it_outergroup != grid.end()) {
// iterate over inner groups
PivotOuterGroup::const_iterator it_innergroup = (*it_outergroup).begin();
while (it_innergroup != (*it_outergroup).end()) {
//
// Rows
//
QString innergroupdata;
PivotInnerGroup::const_iterator it_row = (*it_innergroup).begin();
while (it_row != (*it_innergroup).end()) {
//Do not include investments accounts in the chart because they are merely container of stock and other accounts
if (it_row.key().accountType() != MyMoneyAccount::Investment) {
//iterate row types
for (int i = 0; i < rowTypeList.size(); ++i) {
//skip the budget difference rowset
if (rowTypeList[i] != eBudgetDiff) {
QString legendText;
//only show the column type in the header if there is more than one type
if (rowTypeList.size() > 1) {
legendText = QString(columnTypeHeaderList[i] + " - " + it_row.key().name());
} else {
legendText = QString(it_row.key().name());
}
//set the cell value and tooltip
rowNum = drawPivotRowSet(rowNum, it_row.value(), rowTypeList[i], legendText, 1, numColumns());
//set the legend text
legend->setText(rowNum - 1, legendText);
}
}
}
++it_row;
}
++it_innergroup;
}
++it_outergroup;
}
}
break;
case MyMoneyReport::eDetailTop: {
int rowNum = 0;
// iterate over outer groups
PivotGrid::const_iterator it_outergroup = grid.begin();
while (it_outergroup != grid.end()) {
// iterate over inner groups
PivotOuterGroup::const_iterator it_innergroup = (*it_outergroup).begin();
while (it_innergroup != (*it_outergroup).end()) {
//iterate row types
for (int i = 0; i < rowTypeList.size(); ++i) {
//skip the budget difference rowset
if (rowTypeList[i] != eBudgetDiff) {
QString legendText;
//only show the column type in the header if there is more than one type
if (rowTypeList.size() > 1) {
legendText = QString(columnTypeHeaderList[i] + " - " + it_innergroup.key());
} else {
legendText = QString(it_innergroup.key());
}
//set the cell value and tooltip
rowNum = drawPivotRowSet(rowNum, (*it_innergroup).m_total, rowTypeList[i], legendText, 1, numColumns());
//set the legend text
legend->setText(rowNum - 1, legendText);
}
}
++it_innergroup;
}
++it_outergroup;
}
}
break;
case MyMoneyReport::eDetailGroup: {
int rowNum = 0;
// iterate over outer groups
PivotGrid::const_iterator it_outergroup = grid.begin();
while (it_outergroup != grid.end()) {
//iterate row types
for (int i = 0; i < rowTypeList.size(); ++i) {
//skip the budget difference rowset
if (rowTypeList[i] != eBudgetDiff) {
QString legendText;
//only show the column type in the header if there is more than one type
if (rowTypeList.size() > 1) {
legendText = QString(columnTypeHeaderList[i] + " - " + it_outergroup.key());
} else {
legendText = QString(it_outergroup.key());
}
//set the cell value and tooltip
rowNum = drawPivotRowSet(rowNum, (*it_outergroup).m_total, rowTypeList[i], legendText, 1, numColumns());
//set the legend
legend->setText(rowNum - 1, legendText);
}
}
++it_outergroup;
}
//if selected, show totals too
if (config.isShowingRowTotals()) {
//iterate row types
for (int i = 0; i < rowTypeList.size(); ++i) {
//skip the budget difference rowset
if (rowTypeList[i] != eBudgetDiff) {
QString legendText;
//only show the column type in the header if there is more than one type
if (rowTypeList.size() > 1) {
legendText = QString(columnTypeHeaderList[i] + " - " + i18nc("Total balance", "Total"));
} else {
legendText = QString(i18nc("Total balance", "Total"));
}
//set the cell value
rowNum = drawPivotRowSet(rowNum, grid.m_total, rowTypeList[i], legendText, 1, numColumns());
//set the legend
legend->setText(rowNum - 1, legendText);
}
}
}
}
break;
case MyMoneyReport::eDetailTotal: {
int rowNum = 0;
//iterate row types
for (int i = 0; i < rowTypeList.size(); ++i) {
//skip the budget difference rowset
if (rowTypeList[i] != eBudgetDiff) {
QString legendText;
//only show the column type in the header if there is more than one type
if (rowTypeList.size() > 1) {
legendText = QString(columnTypeHeaderList[i] + " - " + i18nc("Total balance", "Total"));
} else {
legendText = QString(i18nc("Total balance", "Total"));
}
if (config.isMixedTime() && (rowTypeList[i] == eActual || rowTypeList[i] == eForecast)) {
if (rowTypeList[i] == eActual) {
rowNum = drawPivotRowSet(rowNum, grid.m_total, rowTypeList[i], legendText, 1, config.currentDateColumn());
} else if (rowTypeList[i] == eForecast) {
rowNum = drawPivotRowSet(rowNum, grid.m_total, rowTypeList[i], legendText, config.currentDateColumn(), numColumns());
} else {
rowNum = drawPivotRowSet(rowNum, grid.m_total, rowTypeList[i], legendText, 1, numColumns());
}
} else {
//set cell value
rowNum = drawPivotRowSet(rowNum, grid.m_total, rowTypeList[i], legendText, 1, numColumns());
}
//set legend text
legend->setText(rowNum - 1, legendText);
}
}
}
break;
}
//assign model to the diagram
planeDiagram->setModel(&m_model);
//set the legend basic attributes
//this is done after adding the legend because the values are overridden when adding the legend to the chart
for (uint i = static_cast<uint>(KMyMoneyGlobalSettings::maximumLegendItems()); i < legend->datasetCount(); ++i) {
legend->setDatasetHidden(i, true);
}
legend->setTitleText(i18nc("Chart lines legend", "Legend"));
legend->setUseAutomaticMarkerSize(false);
FrameAttributes legendFrameAttr(legend->frameAttributes());
legendFrameAttr.setPen(m_foregroundBrush.color());
// leave some space between the content and the frame
legendFrameAttr.setPadding(2);
legend->setFrameAttributes(legendFrameAttr);
legend->setPosition(Position::East);
legend->setTextAlignment(Qt::AlignLeft);
legend->setLegendStyle(KDChart::Legend::MarkersAndLines);
replaceLegend(legend);
// set the text attributes after calling replaceLegend() otherwise fon sizes will get overwritten
qreal generalFontSize = KGlobalSettings::generalFont().pointSizeF();
if (generalFontSize == -1)
generalFontSize = 8; // this is a fallback if the fontsize was specified in pixels
TextAttributes legendTextAttr(legend->textAttributes());
legendTextAttr.setPen(m_foregroundBrush.color());
legendTextAttr.setFontSize(KDChart::Measure(generalFontSize, KDChartEnums::MeasureCalculationModeAbsolute));
legend->setTextAttributes(legendTextAttr);
TextAttributes legendTitleTextAttr(legend->titleTextAttributes());
legendTitleTextAttr.setPen(m_foregroundBrush.color());
legendTitleTextAttr.setFontSize(KDChart::Measure(generalFontSize + 4, KDChartEnums::MeasureCalculationModeAbsolute));
legend->setTitleTextAttributes(legendTitleTextAttr);
//this sets the line width only for line diagrams
setLineWidth(config.chartLineWidth());
//set data value attributes
//make sure to show only the required number of fractional digits on the labels of the graph
DataValueAttributes dataValueAttr(planeDiagram->dataValueAttributes());
MarkerAttributes markerAttr(dataValueAttr.markerAttributes());
markerAttr.setVisible(true);
markerAttr.setMarkerStyle(MarkerAttributes::MarkerCircle);
markerAttr.setMarkerSize(QSize(8, 8));
dataValueAttr.setMarkerAttributes(markerAttr);
TextAttributes dataValueTextAttr(dataValueAttr.textAttributes());
dataValueTextAttr.setPen(m_foregroundBrush.color());
dataValueAttr.setTextAttributes(dataValueTextAttr);
dataValueAttr.setVisible(config.isChartDataLabels());
dataValueAttr.setDecimalDigits(MyMoneyMoney::denomToPrec(MyMoneyFile::instance()->baseCurrency().smallestAccountFraction()));
planeDiagram->setDataValueAttributes(dataValueAttr);
planeDiagram->setAllowOverlappingDataValueTexts(true);
if (qMin(static_cast<uint>(KMyMoneyGlobalSettings::maximumLegendItems()), legend->datasetCount()) < 2) {
// the legend is needed only if at least two data sets are rendered
removeLegend();
}
}
void MyMoneyStorageXML::writeReport(QDomElement& report, const MyMoneyReport& r)
{
r.writeXML(*m_doc, report);
}
