Mercurial > hg > syntilista

comparison src/main.cpp @ 145:9f3c0a99bcb1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
144:75a4faa219a9 145:9f3c0a99bcb1
224 224
225 "#label_PersonName { font-size: %5pt; font-weight: bold; }" 225 "#label_PersonName { font-size: %5pt; font-weight: bold; }"
226 "#label_BalanceValue { font-size: %4pt; font-weight: bold; }" 226 "#label_BalanceValue { font-size: %4pt; font-weight: bold; }"
227 "#label_EUR { font-size: %4pt; font-weight: bold; }" 227 "#label_EUR { font-size: %4pt; font-weight: bold; }"
228 "#edit_Amount { font-size: %4pt; margin: 0.5em; padding: 0.5em; }" 228 "#edit_Amount { font-size: %4pt; margin: 0.5em; padding: 0.5em; }"
229 "#label_NumPeopleValue { color: green; }"
229 ). 230 ).
230 arg(12 * settings.uiScale). 231 arg(12 * settings.uiScale).
231 arg(14 * settings.uiScale). 232 arg(14 * settings.uiScale).
232 arg(16 * settings.uiScale). 233 arg(16 * settings.uiScale).
233 arg(18 * settings.uiScale). 234 arg(18 * settings.uiScale).
1155 model_People->setHeaderData(1, Qt::Horizontal, tr("Sukunimi")); 1156 model_People->setHeaderData(1, Qt::Horizontal, tr("Sukunimi"));
1156 model_People->setHeaderData(2, Qt::Horizontal, tr("Etunimi")); 1157 model_People->setHeaderData(2, Qt::Horizontal, tr("Etunimi"));
1157 model_People->setHeaderData(3, Qt::Horizontal, tr("Tase")); 1158 model_People->setHeaderData(3, Qt::Horizontal, tr("Tase"));
1158 model_People->setHeaderData(4, Qt::Horizontal, tr("Muutettu")); 1159 model_People->setHeaderData(4, Qt::Horizontal, tr("Muutettu"));
1159 1160
1160 updateTotalBalance(); 1161 updateMiscValues();
1161 } 1162 }
1162 1163
1163 1164
1164 // 1165 //
1165 // Update total balance value in the UI 1166 // Update some values in the UI
1166 // 1167 //
1167 void SyntilistaMainWindow::updateTotalBalance() 1168 void SyntilistaMainWindow::updateMiscValues()
1168 { 1169 {
1169 // Update total balance value 1170 // Update total balance value
1170 QSqlQuery query; 1171 QSqlQuery query;
1171 query.prepare(QStringLiteral("SELECT TOTAL(value) FROM transactions AS balance")); 1172 query.prepare(QStringLiteral("SELECT TOTAL(value) FROM transactions AS balance"));
1172 query.exec(); 1173 query.exec();
1173 if (!slCheckAndReportSQLError("updatePersonList() get total balance query", query.lastError())) 1174 if (slCheckAndReportSQLError("updateMiscValues() get total balance query", query.lastError()) &&
1174 { 1175 query.next())
1175 slErrorMsg( 1176 {
1176 tr("SQL-tietokantavirhe"), 1177 double balance = query.value(0).toDouble();;
1177 tr("Tietokantaa kyseltäessä tapahtui virhe.")); 1178 ui->label_TotalBalanceValue->setText(slMoneyValueToStr(balance));
1178 }
1179 else
1180 {
1181 double balance;
1182 QString tmp ;
1183 if (query.next())
1184 {
1185 balance = query.value(0).toDouble();;
1186 tmp = slMoneyValueToStr(balance);
1187 }
1188 else
1189 {
1190 balance = -1;
1191 tmp = "?";
1192 }
1193
1194 ui->label_TotalBalanceValue->setText(tmp);
1195 ui->label_TotalBalanceValue->setStyleSheet(balance < 0 ? "color: red;" : "color: green;"); 1179 ui->label_TotalBalanceValue->setStyleSheet(balance < 0 ? "color: red;" : "color: green;");
1180 }
1181
1182 // Update number of people
1183 query.finish();
1184 query.prepare(QStringLiteral("SELECT COUNT(*) FROM people"));
1185 query.exec();
1186 if (slCheckAndReportSQLError("updateMiscValues() get people count", query.lastError()) &&
1187 query.next())
1188 {
1189 ui->label_NumPeopleValue->setText(query.value(0).toString());
1196 } 1190 }
1197 } 1191 }
1198 1192
1199 1193
1200 // 1194 //
1239 return -3; 1233 return -3;
1240 } 1234 }
1241 1235
1242 QSqlDatabase::database().commit(); 1236 QSqlDatabase::database().commit();
1243 1237
1244 updateTotalBalance(); 1238 updateMiscValues();
1245 1239
1246 return 0; 1240 return 0;
1247 } 1241 }
1248 1242
1249 1243