");
report += QString("%1").arg(QLocale().toString(date, QLocale::ShortFormat));
report += QString("
\n");
report += QString("");
report += i18n("All values shown in %1", file->baseCurrency().name());
report += QString("
\n");
report += QString("\n\n";
// row 1
report += "| ";
report += i18n("Starting balance on bank statement");
report += " | ";
report += MyMoneyUtils::formatMoney(startingBalance, currency);
report += " |
";
// row 2
report += "| ";
report += i18np("%1 cleared payment", "%1 cleared payments in total", clearedPayments);
report += " | ";
report += MyMoneyUtils::formatMoney(clearedPaymentAmount, currency);
report += " |
";
// row 3
report += "| ";
report += i18np("%1 cleared deposit", "%1 cleared deposits in total", clearedDeposits);
report += " | ";
report += MyMoneyUtils::formatMoney(clearedDepositAmount, currency);
report += " |
";
// row 4
report += "| ";
report += i18n("Ending balance on bank statement");
report += " | ";
report += MyMoneyUtils::formatMoney(endingBalance, currency);
report += " |
";
// separator
report += "| |
";
// row 5
report += "| ";
report += i18n("Cleared balance");
report += " | ";
report += MyMoneyUtils::formatMoney(clearedBalance, currency);
report += " |
";
// row 6
report += "| ";
report += i18np("%1 outstanding payment", "%1 outstanding payments in total", outstandingPayments);
report += " | ";
report += MyMoneyUtils::formatMoney(outstandingPaymentAmount, currency);
report += " |
";
// row 7
report += "| ";
report += i18np("%1 outstanding deposit", "%1 outstanding deposits in total", outstandingDeposits);
report += " | ";
report += MyMoneyUtils::formatMoney(outstandingDepositAmount, currency);
report += " |
";
// row 8
report += "| ";
report += i18n("Register balance as of %1", QLocale().toString(date, QLocale::ShortFormat));
report += " | ";
report += MyMoneyUtils::formatMoney(MyMoneyFile::instance()->balance(account.id(), date), currency);
report += " |
";
// retrieve list of all transactions after the reconciliation date that are not reconciled or cleared
QList > afterTransactionList;
MyMoneyTransactionFilter filter(account.id());
filter.addState((int)eMyMoney::TransactionFilter::State::Cleared);
filter.addState((int)eMyMoney::TransactionFilter::State::NotReconciled);
filter.setDateFilter(date.addDays(1), QDate());
filter.setConsiderCategory(false);
filter.setReportAllSplits(true);
file->transactionList(afterTransactionList, filter);
MyMoneyMoney afterDepositAmount, afterPaymentAmount;
int afterDeposits = 0;
int afterPayments = 0;
for (it = afterTransactionList.constBegin(); it != afterTransactionList.constEnd(); ++it) {
// if this split is a stock split, we can't just add the amount of shares
if ((*it).second.reconcileFlag() == eMyMoney::Split::State::NotReconciled) {
if ((*it).second.shares().isNegative()) {
afterPayments++;
afterPaymentAmount += (*it).second.shares();
} else {
afterDeposits++;
afterDepositAmount += (*it).second.shares();
}
}
}
// row 9
report += "| ";
report += i18np("%1 payment after %2", "%1 payments after %2", afterPayments, QLocale().toString(date, QLocale::ShortFormat));
report += " | ";
report += MyMoneyUtils::formatMoney(afterPaymentAmount, currency);
report += " |
";
// row 10
report += "| ";
report += i18np("%1 deposit after %2", "%1 deposits after %2", afterDeposits, QLocale().toString(date, QLocale::ShortFormat));
report += " | ";
report += MyMoneyUtils::formatMoney(afterDepositAmount, currency);
report += " |
";
// row 11
report += "| ";
report += i18n("Register ending balance");
report += " | ";
report += MyMoneyUtils::formatMoney(MyMoneyFile::instance()->balance(account.id()), currency);
report += " |
";
// end of the table
report += "
\n";
QString detailsTableHeader;
detailsTableHeader += "\n\n";
QString detailsReport = QString("%1
\n").arg(i18n("Outstanding payments"));
detailsReport += detailsTableHeader;
auto index = 0;
foreach (const auto transaction, transactionList) {
if (transaction.second.reconcileFlag() == eMyMoney::Split::State::NotReconciled && transaction.second.shares().isNegative()) {
QString category;
foreach (const auto split, transaction.first.splits()) {
if (split.accountId() != account.id()) {
if (!category.isEmpty())
category += ", "; // this is a split transaction
category = file->account(split.accountId()).name();
}
}
detailsReport += QString("| ").arg((index++ % 2 == 1) ? "row-odd" : "row-even");
detailsReport += QString("%1").arg(QLocale().toString(transaction.first.entryDate(), QLocale::ShortFormat));
detailsReport += " | ";
detailsReport += QString("%1").arg(transaction.second.number());
detailsReport += " | ";
detailsReport += QString("%1").arg(file->payee(transaction.second.payeeId()).name());
detailsReport += " | ";
detailsReport += QString("%1").arg(transaction.first.memo());
detailsReport += " | ";
detailsReport += QString("%1").arg(category);
detailsReport += " | ";
detailsReport += QString("%1").arg(MyMoneyUtils::formatMoney(transaction.second.shares(), file->currency(account.currencyId())));
detailsReport += " |
";
}
}
detailsReport += "").arg(i18np("One outstanding payment of", "Total of %1 outstanding payments amounting to", outstandingPayments)).arg(MyMoneyUtils::formatMoney(outstandingPaymentAmount, currency));
detailsReport += "
\n";
- detailsReport += QString("| ").arg((index++ % 2 == 1) ? "row-odd" : "row-even")
+ QString("%1").arg(QLocale().toString((*it).first.entryDate(), QLocale::ShortFormat))
+ " | "
+ QString("%1").arg((*it).second.number())
+ " | "
+ QString("%1").arg(file->payee((*it).second.payeeId()).name())
+ " | "
+ QString("%1").arg((*it).first.memo())
+ " | "
+ QString("%1").arg(category)
+ " | "
+ QString("%1").arg(MyMoneyUtils::formatMoney((*it).second.shares(), file->currency(account.currencyId())))
+ " |
";
}
}
detailsReport += "").arg(i18np("One outstanding deposit of", "Total of %1 outstanding deposits amounting to", outstandingDeposits)).arg(MyMoneyUtils::formatMoney(outstandingDepositAmount, currency))
+ + QString("