QString makeAccount( const QString& _name, MyMoneyAccount::accountTypeE _type, MyMoneyMoney _balance, const QDate& _open, const QString& _parent, QString _currency, bool _taxReport )
{
MyMoneyAccount info;
MyMoneyFileTransaction ft;
info.setName(_name);
info.setAccountType(_type);
info.setOpeningDate(_open);
if ( _currency != "" )
info.setCurrencyId(_currency);
else
info.setCurrencyId(MyMoneyFile::instance()->baseCurrency().id());
if(_taxReport)
info.setValue("Tax", "Yes");
MyMoneyAccount parent = MyMoneyFile::instance()->account(_parent);
MyMoneyFile::instance()->addAccount( info, parent );
// create the opening balance transaction if any
if(!_balance.isZero()) {
MyMoneySecurity sec = MyMoneyFile::instance()->currency(info.currencyId());
MyMoneyFile::instance()->openingBalanceAccount(sec);
MyMoneyFile::instance()->createOpeningBalanceTransaction(info, _balance);
}
ft.commit();
return info.id();
}
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::testAssignmentConstructor()
{
MyMoneyAccount a;
a.setAccountType(MyMoneyAccount::Checkings);
a.setName("Account");
a.setInstitutionId("Inst1");
a.setDescription("Bla");
a.setNumber("assigned Number");
a.setValue("Key", "Value");
a.addAccountId("ChildAccount");
MyMoneyAccount b;
b.setLastModified(QDate::currentDate());
b = a;
QVERIFY(b.name() == "Account");
QVERIFY(b.institutionId() == "Inst1");
QVERIFY(b.accountType() == MyMoneyAccount::Checkings);
QVERIFY(b.lastModified() == QDate());
QVERIFY(b.openingDate() == a.openingDate());
QVERIFY(b.description() == "Bla");
QVERIFY(b.number() == "assigned Number");
QVERIFY(b.value("Key") == "Value");
QVERIFY(b.accountList().count() == 1);
QVERIFY(b.accountList()[0] == "ChildAccount");
}
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::testSubAccounts()
{
MyMoneyAccount a;
a.setAccountType(MyMoneyAccount::Checkings);
a.addAccountId("Subaccount1");
QVERIFY(a.accountList().count() == 1);
a.addAccountId("Subaccount1");
QVERIFY(a.accountList().count() == 1);
a.addAccountId("Subaccount2");
QVERIFY(a.accountList().count() == 2);
}
void onlineJobAdministrationTest::initTestCase()
{
file = MyMoneyFile::instance();
storage = new MyMoneySeqAccessMgr;
file->attachStorage(storage);
try {
MyMoneyAccount account = MyMoneyAccount();
account.setName("Test Account");
account.setAccountType(MyMoneyAccount::Savings);
MyMoneyAccount asset = file->asset();
MyMoneyFileTransaction transaction;
file->addAccount(account , asset);
accountId = account.id();
transaction.commit();
} catch (const MyMoneyException& ex) {
QFAIL(qPrintable("Unexpected exception " + ex.what()));
}
}
void CsvUtil::scanCategories(QString& id, const MyMoneyAccount& invAcc, const MyMoneyAccount& parentAccount, const QString& defaultName)
{
if (!m_scannedCategories) {
previouslyUsedCategories(invAcc.id(), m_feeId, m_interestId);
m_scannedCategories = true;
}
if (id.isEmpty()) {
MyMoneyFile* file = MyMoneyFile::instance();
MyMoneyAccount acc = file->accountByName(defaultName);
// if it does not exist, we have to create it
if (acc.id().isEmpty()) {
MyMoneyAccount parent = parentAccount;
acc.setName(defaultName);
acc.setAccountType(parent.accountType());
acc.setCurrencyId(parent.currencyId());
file->addAccount(acc, parent);
}
id = acc.id();
}
}
bool MyMoneyTemplate::createAccounts(MyMoneyAccount& parent, QDomNode account)
{
bool rc = true;
while (rc == true && !account.isNull()) {
MyMoneyAccount acc;
if (account.isElement()) {
QDomElement accountElement = account.toElement();
if (accountElement.tagName() == "account") {
signalProgress(++m_accountsRead, 0);
QList<MyMoneyAccount> subAccountList;
QList<MyMoneyAccount>::ConstIterator it;
it = subAccountList.constEnd();
if (!parent.accountList().isEmpty()) {
MyMoneyFile::instance()->accountList(subAccountList, parent.accountList());
for (it = subAccountList.constBegin(); it != subAccountList.constEnd(); ++it) {
if ((*it).name() == accountElement.attribute("name")) {
acc = *it;
break;
}
}
}
if (it == subAccountList.constEnd()) {
// not found, we need to create it
acc.setName(accountElement.attribute("name"));
acc.setAccountType(static_cast<MyMoneyAccount::_accountTypeE>(accountElement.attribute("type").toUInt()));
setFlags(acc, account.firstChild());
try {
MyMoneyFile::instance()->addAccount(acc, parent);
} catch (const MyMoneyException &) {
}
}
createAccounts(acc, account.firstChild());
}
}
account = account.nextSibling();
}
return rc;
}
void MyMoneyAccountTest::testSetFunctions()
{
MyMoneyAccount a;
QDate today(QDate::currentDate());
QVERIFY(a.name().isEmpty());
QVERIFY(a.lastModified() == QDate());
QVERIFY(a.description().isEmpty());
a.setName("Account");
a.setInstitutionId("Institution1");
a.setLastModified(today);
a.setDescription("Desc");
a.setNumber("123456");
a.setAccountType(MyMoneyAccount::MoneyMarket);
QVERIFY(a.name() == "Account");
QVERIFY(a.institutionId() == "Institution1");
QVERIFY(a.lastModified() == today);
QVERIFY(a.description() == "Desc");
QVERIFY(a.number() == "123456");
QVERIFY(a.accountType() == MyMoneyAccount::MoneyMarket);
}
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::testIsLoan()
{
MyMoneyAccount a;
a.setAccountType(MyMoneyAccount::UnknownAccountType);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Checkings);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Savings);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Cash);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::CreditCard);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Loan);
QVERIFY(a.isLoan() == true);
a.setAccountType(MyMoneyAccount::CertificateDep);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Investment);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::MoneyMarket);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Asset);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Liability);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Currency);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Income);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Expense);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::AssetLoan);
QVERIFY(a.isLoan() == true);
a.setAccountType(MyMoneyAccount::Stock);
QVERIFY(a.isLoan() == false);
a.setAccountType(MyMoneyAccount::Equity);
QVERIFY(a.isLoan() == false);
}
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;
}
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;
}
