void MyMoneyAccountTest::testCopyConstructor()
{
QString id = "A000001";
QString institutionid = "B000001";
QString parent = "ParentAccount";
MyMoneyAccount r;
r.setAccountType(MyMoneyAccount::Expense);
r.setOpeningDate(QDate::currentDate());
r.setLastModified(QDate::currentDate());
r.setName("Account");
r.setInstitutionId("Inst1");
r.setDescription("Desc1");
r.setNumber("Number");
r.setParentAccountId(parent);
r.setValue("Key", "Value");
MyMoneyAccount a(id, r);
a.setInstitutionId(institutionid);
MyMoneyAccount b(a);
QVERIFY(b.name() == "Account");
QVERIFY(b.institutionId() == institutionid);
QVERIFY(b.accountType() == MyMoneyAccount::Expense);
QVERIFY(b.lastModified() == QDate::currentDate());
QVERIFY(b.openingDate() == QDate::currentDate());
QVERIFY(b.description() == "Desc1");
QVERIFY(b.number() == "Number");
QVERIFY(b.parentAccountId() == "ParentAccount");
QVERIFY(b.value("Key") == "Value");
}
void MyMoneyAccountTest::testHasReferenceTo()
{
MyMoneyAccount a;
a.setInstitutionId("I0001");
a.addAccountId("A_001");
a.addAccountId("A_002");
a.setParentAccountId("A_Parent");
a.setCurrencyId("Currency");
QVERIFY(a.hasReferenceTo("I0001") == true);
QVERIFY(a.hasReferenceTo("I0002") == false);
QVERIFY(a.hasReferenceTo("A_001") == false);
QVERIFY(a.hasReferenceTo("A_Parent") == true);
QVERIFY(a.hasReferenceTo("Currency") == true);
}
QString CsvUtil::nameToId(const QString& name, MyMoneyAccount& parent)
{
// Adapted from KMyMoneyApp::createAccount(MyMoneyAccount& newAccount, MyMoneyAccount& parentAccount, MyMoneyAccount& brokerageAccount, MyMoneyMoney openingBal)
// Needed to find/create category:sub-categories
MyMoneyFile* file = MyMoneyFile::instance();
QString id = file->categoryToAccount(name, MyMoneyAccount::UnknownAccountType);
// if it does not exist, we have to create it
if (id.isEmpty()) {
MyMoneyAccount newAccount;
MyMoneyAccount parentAccount = parent;
newAccount.setName(name) ;
int pos;
// check for ':' in the name and use it as separator for a hierarchy
while ((pos = newAccount.name().indexOf(MyMoneyFile::AccountSeperator)) != -1) {
QString part = newAccount.name().left(pos);
QString remainder = newAccount.name().mid(pos + 1);
const MyMoneyAccount& existingAccount = file->subAccountByName(parentAccount, part);
if (existingAccount.id().isEmpty()) {
newAccount.setName(part);
newAccount.setAccountType(parentAccount.accountType());
file->addAccount(newAccount, parentAccount);
parentAccount = newAccount;
} else {
parentAccount = existingAccount;
}
newAccount.setParentAccountId(QString()); // make sure, there's no parent
newAccount.clearId(); // and no id set for adding
newAccount.removeAccountIds(); // and no sub-account ids
newAccount.setName(remainder);
}//end while
newAccount.setAccountType(parentAccount.accountType());
// make sure we have a currency. If none is assigned, we assume base currency
if (newAccount.currencyId().isEmpty())
newAccount.setCurrencyId(file->baseCurrency().id());
file->addAccount(newAccount, parentAccount);
id = newAccount.id();
}
return id;
}
void MyMoneyAccountTest::testConstructor()
{
QString id = "A000001";
QString institutionid = "B000001";
QString parent = "Parent";
MyMoneyAccount r;
MyMoneySplit s;
r.setAccountType(MyMoneyAccount::Asset);
r.setOpeningDate(QDate::currentDate());
r.setLastModified(QDate::currentDate());
r.setDescription("Desc");
r.setNumber("465500");
r.setParentAccountId(parent);
r.setValue(QString("key"), "value");
s.setShares(MyMoneyMoney::ONE);
r.adjustBalance(s);
QVERIFY(r.m_kvp.count() == 1);
QVERIFY(r.value("key") == "value");
MyMoneyAccount a(id, r);
QVERIFY(a.id() == id);
QVERIFY(a.institutionId().isEmpty());
QVERIFY(a.accountType() == MyMoneyAccount::Asset);
QVERIFY(a.openingDate() == QDate::currentDate());
QVERIFY(a.lastModified() == QDate::currentDate());
QVERIFY(a.number() == "465500");
QVERIFY(a.description() == "Desc");
QVERIFY(a.accountList().count() == 0);
QVERIFY(a.parentAccountId() == "Parent");
QVERIFY(a.balance() == MyMoneyMoney::ONE);
QMap<QString, QString> copy;
copy = r.pairs();
QVERIFY(copy.count() == 1);
QVERIFY(copy[QString("key")] == "value");
}
void MyMoneyAccountTest::testWriteXML()
{
QString id = "A000001";
QString institutionid = "B000001";
QString parent = "Parent";
MyMoneyAccount r;
r.setAccountType(MyMoneyAccount::Asset);
r.setOpeningDate(QDate::currentDate());
r.setLastModified(QDate::currentDate());
r.setDescription("Desc");
r.setName("AccountName");
r.setNumber("465500");
r.setParentAccountId(parent);
r.setInstitutionId(institutionid);
r.setValue(QString("key"), "value");
r.addAccountId("A000002");
r.addReconciliation(QDate(2011, 1, 1), MyMoneyMoney(123, 100));
r.addReconciliation(QDate(2011, 2, 1), MyMoneyMoney(456, 100));
QCOMPARE(r.m_kvp.count(), 2);
QCOMPARE(r.value("key"), QLatin1String("value"));
QCOMPARE(r.value("reconciliationHistory"), QLatin1String("2011-01-01:123/100;2011-02-01:114/25"));
MyMoneyAccount a(id, r);
QDomDocument doc("TEST");
QDomElement el = doc.createElement("ACCOUNT-CONTAINER");
doc.appendChild(el);
a.writeXML(doc, el);
QCOMPARE(doc.doctype().name(), QLatin1String("TEST"));
QDomElement accountContainer = doc.documentElement();
QVERIFY(accountContainer.isElement());
QCOMPARE(accountContainer.tagName(), QLatin1String("ACCOUNT-CONTAINER"));
QVERIFY(accountContainer.childNodes().size() == 1);
QVERIFY(accountContainer.childNodes().at(0).isElement());
QDomElement account = accountContainer.childNodes().at(0).toElement();
QCOMPARE(account.tagName(), QLatin1String("ACCOUNT"));
QCOMPARE(account.attribute("id"), QLatin1String("A000001"));
QCOMPARE(account.attribute("lastreconciled"), QString());
QCOMPARE(account.attribute("institution"), QLatin1String("B000001"));
QCOMPARE(account.attribute("name"), QLatin1String("AccountName"));
QCOMPARE(account.attribute("number"), QLatin1String("465500"));
QCOMPARE(account.attribute("description"), QLatin1String("Desc"));
QCOMPARE(account.attribute("parentaccount"), QLatin1String("Parent"));
QCOMPARE(account.attribute("opened"), QDate::currentDate().toString(Qt::ISODate));
QCOMPARE(account.attribute("type"), QLatin1String("9"));
QCOMPARE(account.attribute("lastmodified"), QDate::currentDate().toString(Qt::ISODate));
QCOMPARE(account.attribute("id"), QLatin1String("A000001"));
QCOMPARE(account.childNodes().size(), 2);
QVERIFY(account.childNodes().at(0).isElement());
QDomElement subAccounts = account.childNodes().at(0).toElement();
QCOMPARE(subAccounts.tagName(), QLatin1String("SUBACCOUNTS"));
QCOMPARE(subAccounts.childNodes().size(), 1);
QVERIFY(subAccounts.childNodes().at(0).isElement());
QDomElement subAccount = subAccounts.childNodes().at(0).toElement();
QCOMPARE(subAccount.tagName(), QLatin1String("SUBACCOUNT"));
QCOMPARE(subAccount.attribute("id"), QLatin1String("A000002"));
QCOMPARE(subAccount.childNodes().size(), 0);
QDomElement keyValuePairs = account.childNodes().at(1).toElement();
QCOMPARE(keyValuePairs.tagName(), QLatin1String("KEYVALUEPAIRS"));
QCOMPARE(keyValuePairs.childNodes().size(), 2);
QVERIFY(keyValuePairs.childNodes().at(0).isElement());
QDomElement keyValuePair1 = keyValuePairs.childNodes().at(0).toElement();
QCOMPARE(keyValuePair1.tagName(), QLatin1String("PAIR"));
QCOMPARE(keyValuePair1.attribute("key"), QLatin1String("key"));
QCOMPARE(keyValuePair1.attribute("value"), QLatin1String("value"));
QCOMPARE(keyValuePair1.childNodes().size(), 0);
QVERIFY(keyValuePairs.childNodes().at(1).isElement());
QDomElement keyValuePair2 = keyValuePairs.childNodes().at(1).toElement();
QCOMPARE(keyValuePair2.tagName(), QLatin1String("PAIR"));
QCOMPARE(keyValuePair2.attribute("key"), QLatin1String("reconciliationHistory"));
QCOMPARE(keyValuePair2.attribute("value"), QLatin1String("2011-01-01:123/100;2011-02-01:114/25"));
QCOMPARE(keyValuePair2.childNodes().size(), 0);
}
void MyMoneyAccountTest::testEquality()
{
MyMoneyAccount a;
a.setLastModified(QDate::currentDate());
a.setName("Name");
a.setNumber("Number");
a.setDescription("Desc");
a.setInstitutionId("I-ID");
a.setOpeningDate(QDate::currentDate());
a.setLastReconciliationDate(QDate::currentDate());
a.setAccountType(MyMoneyAccount::Asset);
a.setParentAccountId("P-ID");
a.setId("A-ID");
a.setCurrencyId("C-ID");
a.setValue("Key", "Value");
MyMoneyAccount b;
b = a;
QVERIFY(b == a);
a.setName("Noname");
QVERIFY(!(b == a));
b = a;
a.setLastModified(QDate::currentDate().addDays(-1));
QVERIFY(!(b == a));
b = a;
a.setNumber("Nonumber");
QVERIFY(!(b == a));
b = a;
a.setDescription("NoDesc");
QVERIFY(!(b == a));
b = a;
a.setInstitutionId("I-noID");
QVERIFY(!(b == a));
b = a;
a.setOpeningDate(QDate::currentDate().addDays(-1));
QVERIFY(!(b == a));
b = a;
a.setLastReconciliationDate(QDate::currentDate().addDays(-1));
QVERIFY(!(b == a));
b = a;
a.setAccountType(MyMoneyAccount::Liability);
QVERIFY(!(b == a));
b = a;
a.setParentAccountId("P-noID");
QVERIFY(!(b == a));
b = a;
a.setId("A-noID");
QVERIFY(!(b == a));
b = a;
a.setCurrencyId("C-noID");
QVERIFY(!(b == a));
b = a;
a.setValue("Key", "noValue");
QVERIFY(!(b == a));
b = a;
a.setValue("noKey", "Value");
QVERIFY(!(b == a));
b = a;
}
void CsvUtil::createAccount(MyMoneyAccount& newAccount, MyMoneyAccount& parentAccount, MyMoneyAccount& brokerageAccount, MyMoneyMoney openingBal)
{
MyMoneyFile* file = MyMoneyFile::instance();
// make sure we have a currency. If none is assigned, we assume base currency
if (newAccount.currencyId().isEmpty())
newAccount.setCurrencyId(file->baseCurrency().id());
MyMoneyFileTransaction ft;
try {
int pos;
// check for ':' in the name and use it as separator for a hierarchy
while ((pos = newAccount.name().indexOf(MyMoneyFile::AccountSeperator)) != -1) {
QString part = newAccount.name().left(pos);
QString remainder = newAccount.name().mid(pos + 1);
const MyMoneyAccount& existingAccount = file->subAccountByName(parentAccount, part);
if (existingAccount.id().isEmpty()) {
newAccount.setName(part);
file->addAccount(newAccount, parentAccount);
parentAccount = newAccount;
} else {
parentAccount = existingAccount;
}
newAccount.setParentAccountId(QString()); // make sure, there's no parent
newAccount.clearId(); // and no id set for adding
newAccount.removeAccountIds(); // and no sub-account ids
newAccount.setName(remainder);
}
const MyMoneySecurity& sec = file->security(newAccount.currencyId());
// Check the opening balance
if (openingBal.isPositive() && newAccount.accountGroup() == MyMoneyAccount::Liability) {
QString message = i18n("This account is a liability and if the "
"opening balance represents money owed, then it should be negative. "
"Negate the amount?\n\n"
"Please click Yes to change the opening balance to %1,\n"
"Please click No to leave the amount as %2,\n"
"Please click Cancel to abort the account creation."
, MyMoneyUtils::formatMoney(-openingBal, newAccount, sec)
, MyMoneyUtils::formatMoney(openingBal, newAccount, sec));
int ans = KMessageBox::questionYesNoCancel(0, message);
if (ans == KMessageBox::Yes) {
openingBal = -openingBal;
} else if (ans == KMessageBox::Cancel)
return;
}
file->addAccount(newAccount, parentAccount);
if (newAccount.accountType() == MyMoneyAccount::Investment
&& !brokerageAccount.name().isEmpty()) {
file->addAccount(brokerageAccount, parentAccount);
// set a link from the investment account to the brokerage account
file->modifyAccount(newAccount);
file->createOpeningBalanceTransaction(brokerageAccount, openingBal);
} else
file->createOpeningBalanceTransaction(newAccount, openingBal);
ft.commit();
} catch (const MyMoneyException &e) {
KMessageBox::information(0, i18n("Unable to add account: %1", e.what()));
}
}
const QString CsvUtil::checkCategory(const QString& name, const MyMoneyMoney& value, const MyMoneyMoney& value2)
{
// Borrowed from MyMoneyQifReader::checkCategory()
QString accountId;
MyMoneyFile *file = MyMoneyFile::instance();
MyMoneyAccount account;
bool found = true;
if (!name.isEmpty()) {
// The category might be constructed with an arbitraty depth (number of
// colon delimited fields). We try to find a parent account within this
// hierarchy by searching the following sequence:
//
// aaaa:bbbb:cccc:ddddd
//
// 1. search aaaa:bbbb:cccc:dddd, create nothing
// 2. search aaaa:bbbb:cccc , create dddd
// 3. search aaaa:bbbb , create cccc:dddd
// 4. search aaaa , create bbbb:cccc:dddd
// 5. don't search , create aaaa:bbbb:cccc:dddd
account.setName(name);
QString accName; // part to be created (right side in above list)
QString parent(name); // a possible parent part (left side in above list)
do {
accountId = file->categoryToAccount(parent);
if (accountId.isEmpty()) {
found = false;
// prepare next step
if (!accName.isEmpty())
accName.prepend(':');
accName.prepend(parent.section(':', -1));
account.setName(accName);
parent = parent.section(':', 0, -2);
} else if (!accName.isEmpty()) {
account.setParentAccountId(accountId);
}
} while (!parent.isEmpty() && accountId.isEmpty());
// if we did not find the category, we create it
if (!found) {
MyMoneyAccount parent;
if (account.parentAccountId().isEmpty()) {
if (!value.isNegative() && value2.isNegative())
parent = file->income();
else
parent = file->expense();
} else {
parent = file->account(account.parentAccountId());
}
account.setAccountType((!value.isNegative() && value2.isNegative()) ? MyMoneyAccount::Income : MyMoneyAccount::Expense);
MyMoneyAccount brokerage;
// clear out the parent id, because createAccount() does not like that
account.setParentAccountId(QString());
createAccount(account, parent, brokerage, MyMoneyMoney());
accountId = account.id();
}
}
return accountId;
}
