void KForecastView::loadBudgetView()
{
MyMoneyFile* file = MyMoneyFile::instance();
MyMoneyForecast forecast = KMyMoneyGlobalSettings::forecast();
//get the settings from current page and calculate this year based on last year
QDate historyEndDate = QDate(QDate::currentDate().year() - 1, 12, 31);
QDate historyStartDate = historyEndDate.addDays(-m_accountsCycle->value() * m_forecastCycles->value());
QDate forecastStartDate = QDate(QDate::currentDate().year(), 1, 1);
QDate forecastEndDate = QDate::currentDate().addDays(m_forecastDays->value());
forecast.setHistoryMethod(m_historyMethod->checkedId());
MyMoneyBudget budget;
forecast.createBudget(budget, historyStartDate, historyEndDate, forecastStartDate, forecastEndDate, false);
m_budgetList->clear();
m_budgetList->setIconSize(QSize(22, 22));
m_budgetList->setSortingEnabled(true);
m_budgetList->sortByColumn(0, Qt::AscendingOrder);
//add columns
QStringList headerLabels;
headerLabels << i18n("Account");
{
QDate forecastStartDate = forecast.forecastStartDate();
QDate forecastEndDate = forecast.forecastEndDate();
//add cycle interval columns
QDate f_date = forecastStartDate;
for (; f_date <= forecastEndDate; f_date = f_date.addMonths(1)) {
headerLabels << QDate::longMonthName(f_date.month());
}
}
//add total column
headerLabels << i18nc("Total balance", "Total");
//set the columns
m_budgetList->setHeaderLabels(headerLabels);
//add default rows
addTotalRow(m_budgetList, forecast);
addIncomeExpenseRows(forecast);
//load income and expense budget accounts
loadAccounts(forecast, file->income(), m_incomeItem, eBudget);
loadAccounts(forecast, file->expense(), m_expenseItem, eBudget);
adjustHeadersAndResizeToContents(m_budgetList);
}
void KForecastView::loadListView()
{
MyMoneyForecast forecast = KMyMoneyGlobalSettings::forecast();
MyMoneyFile* file = MyMoneyFile::instance();
//get the settings from current page
forecast.setForecastDays(m_forecastDays->value());
forecast.setAccountsCycle(m_accountsCycle->value());
forecast.setBeginForecastDay(m_beginDay->value());
forecast.setForecastCycles(m_forecastCycles->value());
forecast.setHistoryMethod(m_historyMethod->checkedId());
forecast.doForecast();
m_forecastList->clear();
m_forecastList->setColumnCount(0);
m_forecastList->setIconSize(QSize(22, 22));
m_forecastList->setSortingEnabled(true);
m_forecastList->sortByColumn(0, Qt::AscendingOrder);
//add columns
QStringList headerLabels;
headerLabels << i18n("Account");
//add cycle interval columns
headerLabels << i18nc("Today's forecast", "Current");
for (int i = 1; i <= forecast.forecastDays(); ++i) {
QDate forecastDate = QDate::currentDate().addDays(i);
headerLabels << QLocale().toString(forecastDate, QLocale::LongFormat);
}
//add variation columns
headerLabels << i18n("Total variation");
//set the columns
m_forecastList->setHeaderLabels(headerLabels);
//add default rows
addTotalRow(m_forecastList, forecast);
addAssetLiabilityRows(forecast);
//load asset and liability forecast accounts
loadAccounts(forecast, file->asset(), m_assetItem, eDetailed);
loadAccounts(forecast, file->liability(), m_liabilityItem, eDetailed);
adjustHeadersAndResizeToContents(m_forecastList);
// add the fixed column only if the horizontal scroll bar is visible
m_fixedColumnView.reset(m_forecastList->horizontalScrollBar()->isVisible() ? new FixedColumnTreeView(m_forecastList) : 0);
}
MyMoneyForecast KMyMoneyGlobalSettings::forecast()
{
MyMoneyForecast forecast;
// override object defaults with those of the application
forecast.setForecastCycles(KMyMoneyGlobalSettings::forecastCycles());
forecast.setAccountsCycle(KMyMoneyGlobalSettings::forecastAccountCycle());
forecast.setHistoryStartDate(QDate::currentDate().addDays(-forecast.forecastCycles()*forecast.accountsCycle()));
forecast.setHistoryEndDate(QDate::currentDate().addDays(-1));
forecast.setForecastDays(KMyMoneyGlobalSettings::forecastDays());
forecast.setBeginForecastDay(KMyMoneyGlobalSettings::beginForecastDay());
forecast.setForecastMethod(KMyMoneyGlobalSettings::forecastMethod());
forecast.setHistoryMethod(KMyMoneyGlobalSettings::historyMethod());
forecast.setIncludeFutureTransactions(KMyMoneyGlobalSettings::includeFutureTransactions());
forecast.setIncludeScheduledTransactions(KMyMoneyGlobalSettings::includeScheduledTransactions());
return forecast;
}
void KForecastView::loadAdvancedView()
{
MyMoneyFile* file = MyMoneyFile::instance();
QList<MyMoneyAccount> accList;
MyMoneySecurity baseCurrency = file->baseCurrency();
MyMoneyForecast forecast = KMyMoneyGlobalSettings::forecast();
int daysToBeginDay;
//get the settings from current page
forecast.setForecastDays(m_forecastDays->value());
forecast.setAccountsCycle(m_accountsCycle->value());
forecast.setBeginForecastDay(m_beginDay->value());
forecast.setForecastCycles(m_forecastCycles->value());
forecast.setHistoryMethod(m_historyMethod->checkedId());
forecast.doForecast();
//Get all accounts of the right type to calculate forecast
m_nameIdx.clear();
accList = forecast.accountList();
QList<MyMoneyAccount>::const_iterator accList_t = accList.constBegin();
for (; accList_t != accList.constEnd(); ++accList_t) {
MyMoneyAccount acc = *accList_t;
if (m_nameIdx[acc.id()] != acc.id()) { //Check if the account is there
m_nameIdx[acc.id()] = acc.id();
}
}
//clear the list, including columns
m_advancedList->clear();
m_advancedList->setColumnCount(0);
m_advancedList->setIconSize(QSize(22, 22));
QStringList headerLabels;
//add first column of both lists
headerLabels << i18n("Account");
//if beginning of forecast is today, set the begin day to next cycle to avoid repeating the first cycle
if (QDate::currentDate() < forecast.beginForecastDate()) {
daysToBeginDay = QDate::currentDate().daysTo(forecast.beginForecastDate());
} else {
daysToBeginDay = forecast.accountsCycle();
}
//add columns
for (int i = 1; ((i * forecast.accountsCycle()) + daysToBeginDay) <= forecast.forecastDays(); ++i) {
headerLabels << i18n("Min Bal %1", i);
headerLabels << i18n("Min Date %1", i);
}
for (int i = 1; ((i * forecast.accountsCycle()) + daysToBeginDay) <= forecast.forecastDays(); ++i) {
headerLabels << i18n("Max Bal %1", i);
headerLabels << i18n("Max Date %1", i);
}
headerLabels << i18nc("Average balance", "Average");
m_advancedList->setHeaderLabels(headerLabels);
QTreeWidgetItem *advancedItem = 0;
QMap<QString, QString>::ConstIterator it_nc;
for (it_nc = m_nameIdx.constBegin(); it_nc != m_nameIdx.constEnd(); ++it_nc) {
const MyMoneyAccount& acc = file->account(*it_nc);
QString amount;
MyMoneyMoney amountMM;
MyMoneySecurity currency;
//change currency to deep currency if account is an investment
if (acc.isInvest()) {
MyMoneySecurity underSecurity = file->security(acc.currencyId());
currency = file->security(underSecurity.tradingCurrency());
} else {
currency = file->security(acc.currencyId());
}
advancedItem = new QTreeWidgetItem(m_advancedList, advancedItem, false);
advancedItem->setText(0, acc.name());
advancedItem->setIcon(0, acc.accountPixmap());
int it_c = 1; // iterator for the columns of the listview
//get minimum balance list
QList<QDate> minBalanceList = forecast.accountMinimumBalanceDateList(acc);
QList<QDate>::Iterator t_min;
for (t_min = minBalanceList.begin(); t_min != minBalanceList.end() ; ++t_min) {
QDate minDate = *t_min;
amountMM = forecast.forecastBalance(acc, minDate);
amount = MyMoneyUtils::formatMoney(amountMM, acc, currency);
advancedItem->setText(it_c, amount);
advancedItem->setTextAlignment(it_c, Qt::AlignRight | Qt::AlignVCenter);
if (amountMM.isNegative()) {
advancedItem->setForeground(it_c, KMyMoneyGlobalSettings::listNegativeValueColor());
}
it_c++;
QString dateString = QLocale().toString(minDate, QLocale::ShortFormat);
advancedItem->setText(it_c, dateString);
advancedItem->setTextAlignment(it_c, Qt::AlignRight | Qt::AlignVCenter);
if (amountMM.isNegative()) {
advancedItem->setForeground(it_c, KMyMoneyGlobalSettings::listNegativeValueColor());
}
it_c++;
}
//get maximum balance list
QList<QDate> maxBalanceList = forecast.accountMaximumBalanceDateList(acc);
QList<QDate>::Iterator t_max;
for (t_max = maxBalanceList.begin(); t_max != maxBalanceList.end() ; ++t_max) {
QDate maxDate = *t_max;
amountMM = forecast.forecastBalance(acc, maxDate);
amount = MyMoneyUtils::formatMoney(amountMM, acc, currency);
advancedItem->setText(it_c, amount);
advancedItem->setTextAlignment(it_c, Qt::AlignRight | Qt::AlignVCenter);
if (amountMM.isNegative()) {
advancedItem->setForeground(it_c, KMyMoneyGlobalSettings::listNegativeValueColor());
}
it_c++;
QString dateString = QLocale().toString(maxDate, QLocale::ShortFormat);
advancedItem->setText(it_c, dateString);
advancedItem->setTextAlignment(it_c, Qt::AlignRight | Qt::AlignVCenter);
if (amountMM.isNegative()) {
advancedItem->setForeground(it_c, KMyMoneyGlobalSettings::listNegativeValueColor());
}
it_c++;
}
//get average balance
amountMM = forecast.accountAverageBalance(acc);
amount = MyMoneyUtils::formatMoney(amountMM, acc, currency);
advancedItem->setText(it_c, amount);
advancedItem->setTextAlignment(it_c, Qt::AlignRight | Qt::AlignVCenter);
if (amountMM.isNegative()) {
advancedItem->setForeground(it_c, KMyMoneyGlobalSettings::listNegativeValueColor());
}
it_c++;
}
// make sure all data is shown
adjustHeadersAndResizeToContents(m_advancedList);
m_advancedList->show();
}
void KForecastView::loadSummaryView()
{
MyMoneyForecast forecast = KMyMoneyGlobalSettings::forecast();
QList<MyMoneyAccount> accList;
int dropMinimum;
int dropZero;
MyMoneyFile* file = MyMoneyFile::instance();
//get the settings from current page
forecast.setForecastDays(m_forecastDays->value());
forecast.setAccountsCycle(m_accountsCycle->value());
forecast.setBeginForecastDay(m_beginDay->value());
forecast.setForecastCycles(m_forecastCycles->value());
forecast.setHistoryMethod(m_historyMethod->checkedId());
forecast.doForecast();
//add columns
QStringList headerLabels;
headerLabels << i18n("Account");
headerLabels << i18nc("Today's forecast", "Current");
//if beginning of forecast is today, set the begin day to next cycle to avoid repeating the first cycle
int daysToBeginDay;
if (QDate::currentDate() < forecast.beginForecastDate()) {
daysToBeginDay = QDate::currentDate().daysTo(forecast.beginForecastDate());
} else {
daysToBeginDay = forecast.accountsCycle();
}
for (int i = 0; ((i*forecast.accountsCycle()) + daysToBeginDay) <= forecast.forecastDays(); ++i) {
int intervalDays = ((i * forecast.accountsCycle()) + daysToBeginDay);
headerLabels << i18np("1 day", "%1 days", intervalDays);
}
//add variation columns
headerLabels << i18n("Total variation");
m_summaryList->clear();
//set the columns
m_summaryList->setHeaderLabels(headerLabels);
m_summaryList->setIconSize(QSize(22, 22));
m_summaryList->setSortingEnabled(true);
m_summaryList->sortByColumn(0, Qt::AscendingOrder);
//add default rows
addTotalRow(m_summaryList, forecast);
addAssetLiabilityRows(forecast);
loadAccounts(forecast, file->asset(), m_assetItem, eSummary);
loadAccounts(forecast, file->liability(), m_liabilityItem, eSummary);
adjustHeadersAndResizeToContents(m_summaryList);
//Add comments to the advice list
m_adviceText->clear();
//Get all accounts of the right type to calculate forecast
m_nameIdx.clear();
accList = forecast.accountList();
QList<MyMoneyAccount>::const_iterator accList_t = accList.constBegin();
for (; accList_t != accList.constEnd(); ++accList_t) {
MyMoneyAccount acc = *accList_t;
if (m_nameIdx[acc.id()] != acc.id()) { //Check if the account is there
m_nameIdx[acc.id()] = acc.id();
}
}
QMap<QString, QString>::ConstIterator it_nc;
for (it_nc = m_nameIdx.constBegin(); it_nc != m_nameIdx.constEnd(); ++it_nc) {
const MyMoneyAccount& acc = file->account(*it_nc);
MyMoneySecurity currency;
//change currency to deep currency if account is an investment
if (acc.isInvest()) {
MyMoneySecurity underSecurity = file->security(acc.currencyId());
currency = file->security(underSecurity.tradingCurrency());
} else {
currency = file->security(acc.currencyId());
}
//Check if the account is going to be below zero or below the minimal balance in the forecast period
QString minimumBalance = acc.value("minimumBalance");
MyMoneyMoney minBalance = MyMoneyMoney(minimumBalance);
//Check if the account is going to be below minimal balance
dropMinimum = forecast.daysToMinimumBalance(acc);
//Check if the account is going to be below zero in the future
dropZero = forecast.daysToZeroBalance(acc);
// spit out possible warnings
QString msg;
// if a minimum balance has been specified, an appropriate warning will
// only be shown, if the drop below 0 is on a different day or not present
if (dropMinimum != -1
&& !minBalance.isZero()
&& (dropMinimum < dropZero
|| dropZero == -1)) {
switch (dropMinimum) {
case -1:
break;
case 0:
msg = QString("<font color=\"%1\">").arg(KMyMoneyGlobalSettings::listNegativeValueColor().name());
msg += i18n("The balance of %1 is below the minimum balance %2 today.", acc.name(), MyMoneyUtils::formatMoney(minBalance, acc, currency));
msg += QString("</font>");
break;
default:
msg = QString("<font color=\"%1\">").arg(KMyMoneyGlobalSettings::listNegativeValueColor().name());
msg += i18np("The balance of %2 will drop below the minimum balance %3 in %1 day.",
"The balance of %2 will drop below the minimum balance %3 in %1 days.",
dropMinimum - 1, acc.name(), MyMoneyUtils::formatMoney(minBalance, acc, currency));
msg += QString("</font>");
}
if (!msg.isEmpty()) {
m_adviceText->append(msg);
}
}
// a drop below zero is always shown
msg.clear();
switch (dropZero) {
case -1:
break;
case 0:
if (acc.accountGroup() == MyMoneyAccount::Asset) {
msg = QString("<font color=\"%1\">").arg(KMyMoneyGlobalSettings::listNegativeValueColor().name());
msg += i18n("The balance of %1 is below %2 today.", acc.name(), MyMoneyUtils::formatMoney(MyMoneyMoney(), acc, currency));
msg += QString("</font>");
break;
}
if (acc.accountGroup() == MyMoneyAccount::Liability) {
msg = i18n("The balance of %1 is above %2 today.", acc.name(), MyMoneyUtils::formatMoney(MyMoneyMoney(), acc, currency));
break;
}
break;
default:
if (acc.accountGroup() == MyMoneyAccount::Asset) {
msg = QString("<font color=\"%1\">").arg(KMyMoneyGlobalSettings::listNegativeValueColor().name());
msg += i18np("The balance of %2 will drop below %3 in %1 day.",
"The balance of %2 will drop below %3 in %1 days.",
dropZero, acc.name(), MyMoneyUtils::formatMoney(MyMoneyMoney(), acc, currency));
msg += QString("</font>");
break;
}
if (acc.accountGroup() == MyMoneyAccount::Liability) {
msg = i18np("The balance of %2 will raise above %3 in %1 day.",
"The balance of %2 will raise above %3 in %1 days.",
dropZero, acc.name(), MyMoneyUtils::formatMoney(MyMoneyMoney(), acc, currency));
break;
}
}
if (!msg.isEmpty()) {
m_adviceText->append(msg);
}
//advice about trends
msg.clear();
MyMoneyMoney accCycleVariation = forecast.accountCycleVariation(acc);
if (accCycleVariation < MyMoneyMoney()) {
msg = QString("<font color=\"%1\">").arg(KMyMoneyGlobalSettings::listNegativeValueColor().name());
msg += i18n("The account %1 is decreasing %2 per cycle.", acc.name(), MyMoneyUtils::formatMoney(accCycleVariation, acc, currency));
msg += QString("</font>");
}
if (!msg.isEmpty()) {
m_adviceText->append(msg);
}
}
m_adviceText->show();
}