Mercurial > hg > syntilista
diff src/main.cpp @ 145:9f3c0a99bcb1
Add display for total number of people on the database.
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Fri, 25 Aug 2017 01:21:27 +0300 |
parents | 75a4faa219a9 |
children | c722cb0b6662 |
line wrap: on
line diff
--- a/src/main.cpp Thu Aug 24 18:06:11 2017 +0300 +++ b/src/main.cpp Fri Aug 25 01:21:27 2017 +0300 @@ -226,6 +226,7 @@ "#label_BalanceValue { font-size: %4pt; font-weight: bold; }" "#label_EUR { font-size: %4pt; font-weight: bold; }" "#edit_Amount { font-size: %4pt; margin: 0.5em; padding: 0.5em; }" + "#label_NumPeopleValue { color: green; }" ). arg(12 * settings.uiScale). arg(14 * settings.uiScale). @@ -1157,42 +1158,35 @@ model_People->setHeaderData(3, Qt::Horizontal, tr("Tase")); model_People->setHeaderData(4, Qt::Horizontal, tr("Muutettu")); - updateTotalBalance(); + updateMiscValues(); } // -// Update total balance value in the UI +// Update some values in the UI // -void SyntilistaMainWindow::updateTotalBalance() +void SyntilistaMainWindow::updateMiscValues() { // Update total balance value QSqlQuery query; query.prepare(QStringLiteral("SELECT TOTAL(value) FROM transactions AS balance")); query.exec(); - if (!slCheckAndReportSQLError("updatePersonList() get total balance query", query.lastError())) - { - slErrorMsg( - tr("SQL-tietokantavirhe"), - tr("Tietokantaa kyseltäessä tapahtui virhe.")); - } - else + if (slCheckAndReportSQLError("updateMiscValues() get total balance query", query.lastError()) && + query.next()) { - double balance; - QString tmp ; - if (query.next()) - { - balance = query.value(0).toDouble();; - tmp = slMoneyValueToStr(balance); - } - else - { - balance = -1; - tmp = "?"; - } + double balance = query.value(0).toDouble();; + ui->label_TotalBalanceValue->setText(slMoneyValueToStr(balance)); + ui->label_TotalBalanceValue->setStyleSheet(balance < 0 ? "color: red;" : "color: green;"); + } - ui->label_TotalBalanceValue->setText(tmp); - ui->label_TotalBalanceValue->setStyleSheet(balance < 0 ? "color: red;" : "color: green;"); + // Update number of people + query.finish(); + query.prepare(QStringLiteral("SELECT COUNT(*) FROM people")); + query.exec(); + if (slCheckAndReportSQLError("updateMiscValues() get people count", query.lastError()) && + query.next()) + { + ui->label_NumPeopleValue->setText(query.value(0).toString()); } } @@ -1241,7 +1235,7 @@ QSqlDatabase::database().commit(); - updateTotalBalance(); + updateMiscValues(); return 0; }