syntilista: src/main.cpp annotate

annotate src/main.cpp @ 272:d18f1a8cb4df

Add alt+enter key shortcut for toggling fullscreen window.

author	Matti Hamalainen <ccr@tnsp.org>
date	Fri, 17 Mar 2023 13:11:47 +0200
parents	df3f902588af
children	d8a32eb1f0e9

rev	line source
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1 //
140 783417da6da3 Change the program description to english etc. Matti Hamalainen <ccr@tnsp.org> parents: 139 diff changeset	2 // Syntilista - debt list/management database program
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	3 // Programmed and designed by Matti Hämäläinen <ccr@tnsp.org>
217 58af72da7f60 Update copyrights. Matti Hamalainen <ccr@tnsp.org> parents: 216 diff changeset	4 // (C) Copyright 2017-2018 Tecnic Software productions (TNSP)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	5 //
57 893f69fcf050 Add license. Matti Hamalainen <ccr@tnsp.org> parents: 47 diff changeset	6 // Distributed under 3-clause BSD style license, refer to
893f69fcf050 Add license. Matti Hamalainen <ccr@tnsp.org> parents: 47 diff changeset	7 // included file "COPYING" for exact terms.
893f69fcf050 Add license. Matti Hamalainen <ccr@tnsp.org> parents: 47 diff changeset	8 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	9 #include <QApplication>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	10 #include <QMessageBox>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	11 #include <QSettings>
129 f6685c2eb75d Store SQLite database and log file in application data directory instead of Matti Hamalainen <ccr@tnsp.org> parents: 128 diff changeset	12 #include <QStandardPaths>
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	13 #include "main.h"
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	14 #include "ui_mainwindow.h"
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	15 #include "ui_aboutwindow.h"
228 37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	16 #include "runguard.h"
246 43a5e09bb832 Split some utility functions to util.{h,cpp} Matti Hamalainen <ccr@tnsp.org> parents: 242 diff changeset	17 #include "util.h"
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	18
240 14c6a4d40232 Move settings struct definition to main.h Matti Hamalainen <ccr@tnsp.org> parents: 239 diff changeset	19
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	20 //
240 14c6a4d40232 Move settings struct definition to main.h Matti Hamalainen <ccr@tnsp.org> parents: 239 diff changeset	21 // Global struct for settings
14c6a4d40232 Move settings struct definition to main.h Matti Hamalainen <ccr@tnsp.org> parents: 239 diff changeset	22 //
14c6a4d40232 Move settings struct definition to main.h Matti Hamalainen <ccr@tnsp.org> parents: 239 diff changeset	23 SLAppSettings settings;
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	24
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	25
239 9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	26 //
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	27 // SQL schema / table definitions
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	28 //
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	29 static const SLSQLSchemaDef slSQLSchemaData[] =
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	30 {
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	31 {
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	32 QStringLiteral("people"),
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	33 QStringLiteral(
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	34 "id INTEGER PRIMARY KEY,"
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	35
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	36 "first_name VARCHAR(" SL_STR(SQL_LEN_FIRST_NAME) ") NOT NULL,"
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	37 "last_name VARCHAR(" SL_STR(SQL_LEN_LAST_NAME) ") NOT NULL,"
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	38 "extra_info VARCHAR(" SL_STR(SQL_LEN_EXTRA_INFO) "),"
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	39
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	40 "added DATETIME NOT NULL,"
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	41 "updated DATETIME NOT NULL"
253 eadffc38ab43 Add support for initial INSERT statements for database creation in schema array. Matti Hamalainen <ccr@tnsp.org> parents: 252 diff changeset	42 ),
eadffc38ab43 Add support for initial INSERT statements for database creation in schema array. Matti Hamalainen <ccr@tnsp.org> parents: 252 diff changeset	43 { }
239 9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	44 },
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	45 {
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	46 QStringLiteral("transactions"),
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	47 QStringLiteral(
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	48 "id INTEGER PRIMARY KEY, "
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	49 "person INT NOT NULL, "
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	50 "value REAL, "
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	51 "added DATETIME NOT NULL"
253 eadffc38ab43 Add support for initial INSERT statements for database creation in schema array. Matti Hamalainen <ccr@tnsp.org> parents: 252 diff changeset	52 ),
eadffc38ab43 Add support for initial INSERT statements for database creation in schema array. Matti Hamalainen <ccr@tnsp.org> parents: 252 diff changeset	53 { }
239 9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	54 },
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	55 };
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	56
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	57 static const int nslSQLSchemaData = sizeof(slSQLSchemaData) / sizeof(slSQLSchemaData[0]);
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	58
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	59
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	60 void SLPersonInfo::dump()
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	61 {
126 b51cee929416 Add program debug logging. Matti Hamalainen <ccr@tnsp.org> parents: 125 diff changeset	62 printf(
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	63 "SLPersonInfo() #%lld '%s %s' (added=%s, updated=%s, balance %1.2f)\n#%s#\n",
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	64 id,
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	65 firstName.toUtf8().constData(),
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	66 lastName.toUtf8().constData(),
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	67 slDateTimeToStr(added).toUtf8().constData(),
7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	68 slDateTimeToStr(updated).toUtf8().constData(),
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	69 balance,
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	70 extraInfo.toUtf8().constData());
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	71 }
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	72
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	73
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	74 //
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	75 // Get SLPersonInfo record from SQL query object
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	76 //
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	77 void slGetPersonInfoRec(QSqlQuery &query, SLPersonInfo &info)
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	78 {
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	79 info.id = query.value(0).toInt();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	80 info.firstName = query.value(1).toString();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	81 info.lastName = query.value(2).toString();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	82 info.extraInfo = query.value(3).toString();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	83 info.added = query.value(4).toDateTime();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	84 info.updated = query.value(5).toDateTime();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	85 info.balance = query.value(6).toDouble();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	86 }
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	87
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	88
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	89 //
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	90 // Get SLPersonInfo record from SQL database for specified person ID #
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	91 //
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	92 bool slGetPersonInfo(qint64 id, SLPersonInfo &info)
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	93 {
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	94 QSqlQuery query;
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	95 query.prepare(QStringLiteral(
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	96 "SELECT id,first_name,last_name,extra_info,added,updated, "
107 8ceaafde9b52 Use total() instead of sum() in the SQL queries for better accuracy. Matti Hamalainen <ccr@tnsp.org> parents: 104 diff changeset	97 "(SELECT TOTAL(value) FROM transactions WHERE transactions.person=people.id) AS balance "
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	98 "FROM people WHERE id=?"));
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	99
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	100 query.addBindValue(id);
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	101 query.exec();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	102 if (!query.next())
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	103 return false;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	104
102 064138b6d34e Rename getPersonInfo() to slGetPersonInfo(). Matti Hamalainen <ccr@tnsp.org> parents: 101 diff changeset	105 slGetPersonInfoRec(query, info);
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	106 query.finish();
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	107 return true;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	108 }
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	109
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	110
156 afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	111 //
afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	112 // Set stylesheet for given QWidget, and scale fonts etc.
afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	113 // for some elements based on current UI scale factor.
afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	114 //
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	115 void slSetCommonStyleSheet(QWidget *widget)
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	116 {
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	117 // Clamp scale value
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	118 if (settings.uiScale < 0.5f)
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	119 settings.uiScale = 0.5f;
103 ce86ea4b08aa Comment. Matti Hamalainen <ccr@tnsp.org> parents: 102 diff changeset	120
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	121 if (settings.uiScale > 3.0f)
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	122 settings.uiScale = 3.0f;
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	123
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	124 // Set the stylesheet
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	125 widget->setStyleSheet(
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	126 QStringLiteral(
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	127 "* { font-size: %1pt; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	128 "QPushButton { font-size: %2pt; padding: 0.25em; }"
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	129 "#button_AddDebt[enabled='true'] { font-size: %3pt; background-color: #900; color: white; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	130 "#button_PayDebt[enabled='true'] { font-size: %3pt; background-color: #090; color: white; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	131 "#button_PayFullDebt[enabled='true'] { background-color: #060; color: white; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	132
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	133 "#button_AddDebt[enabled='false'] { font-size: %3pt; background-color: #622; color: black; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	134 "#button_PayDebt[enabled='false'] { font-size: %3pt; background-color: #262; color: black; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	135 "#button_PayFullDebt[enabled='false'] { background-color: #131; color: black; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	136
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	137 "#label_PersonName { font-size: %5pt; font-weight: bold; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	138 "#label_BalanceValue { font-size: %4pt; font-weight: bold; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	139 "#label_EUR { font-size: %4pt; font-weight: bold; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	140 "#edit_Amount { font-size: %4pt; margin: 0.5em; padding: 0.5em; }"
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	141 "#label_NumPeopleValue { color: green; }"
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	142 ).
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	143 arg(12 * settings.uiScale).
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	144 arg(14 * settings.uiScale).
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	145 arg(16 * settings.uiScale).
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	146 arg(18 * settings.uiScale).
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	147 arg(20 * settings.uiScale)
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	148 );
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	149 }
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	150
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	151
156 afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	152 //
afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	153 // Main program begins
afadc1380fb1 Add few misc. comments. Matti Hamalainen <ccr@tnsp.org> parents: 155 diff changeset	154 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	155 int main(int argc, char *argv[])
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	156 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	157 QApplication sapp(argc, argv);
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	158 QSettings tmpst(APP_VENDOR, APP_ID);
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	159
228 37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	160 // Check for multiple instances
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	161 RunGuard guard(QStringLiteral(APP_VENDOR) + QStringLiteral(APP_ID));
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	162 if (!guard.tryToRun())
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	163 {
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	164 slErrorMsg(0,
228 37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	165 QObject::tr("Virhe!"),
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	166 QObject::tr(
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	167 "Syntilista-sovellus on jo käynnissä. Sulje tämä ikkuna ja "
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	168 "etsi ajossa oleva Syntilista-sovellus tehtäväpalkista."
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	169 )
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	170 );
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	171 return 1;
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	172 }
37d5f4329449 Implement single running instance check to prevent problems with the SQLite database. Matti Hamalainen <ccr@tnsp.org> parents: 226 diff changeset	173
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	174 // Read configuration settings
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	175 settings.uiPos = tmpst.value("pos", QPoint(100, 100)).toPoint();
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	176 settings.uiSize = tmpst.value("size", QSize(1000, 600)).toSize();
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	177 settings.uiScale = tmpst.value("scale", 1.0f).toDouble();
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	178 settings.uiFullScreen = tmpst.value("fullscreen", false).toBool();
151 753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	179 settings.dbBackupMode = tmpst.value("dbBackupMode", BACKUP_NONE).toInt();
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	180 settings.dbBackupURL = tmpst.value("dbBackupURL", QString()).toString();
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	181 settings.dbBackupSecret = tmpst.value("dbBackupSecret", QString()).toString();
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	182 settings.dbLastBackup = tmpst.value("dbLastBackup", QDateTime::fromSecsSinceEpoch(0)).toDateTime();
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	183
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	184 // Check commandline arguments for configuring backup settings
169 d9b9be9c4788 Make 'config' commandline option's backup location and secret settings Matti Hamalainen <ccr@tnsp.org> parents: 157 diff changeset	185 if (argc >= 2 && strcmp(argv[1], "config") == 0)
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	186 {
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	187 settings.dbBackupMode = QString(argv[2]).toInt();
169 d9b9be9c4788 Make 'config' commandline option's backup location and secret settings Matti Hamalainen <ccr@tnsp.org> parents: 157 diff changeset	188 if (argc >= 5)
d9b9be9c4788 Make 'config' commandline option's backup location and secret settings Matti Hamalainen <ccr@tnsp.org> parents: 157 diff changeset	189 {
d9b9be9c4788 Make 'config' commandline option's backup location and secret settings Matti Hamalainen <ccr@tnsp.org> parents: 157 diff changeset	190 settings.dbBackupURL = QString(argv[3]);
d9b9be9c4788 Make 'config' commandline option's backup location and secret settings Matti Hamalainen <ccr@tnsp.org> parents: 157 diff changeset	191 settings.dbBackupSecret = QString(argv[4]);
d9b9be9c4788 Make 'config' commandline option's backup location and secret settings Matti Hamalainen <ccr@tnsp.org> parents: 157 diff changeset	192 }
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	193 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	194
148 665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	195 // Also possibility of resetting the UI settings
665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	196 if (argc >= 2 && strcmp(argv[1], "reset") == 0)
665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	197 {
665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	198 settings.uiPos = QPoint(100, 100);
665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	199 settings.uiSize = QSize(1000, 600);
665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	200 settings.uiScale = 1.0f;
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	201 settings.uiFullScreen = false;
148 665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	202 }
665421937ec8 Add another commandline option "reset" for reseting the UI position, size and scale to default values. Matti Hamalainen <ccr@tnsp.org> parents: 147 diff changeset	203
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	204 //
170 7edbfb2c0089 Add error message dialogs for cases when SQL tables could not be created, Matti Hamalainen <ccr@tnsp.org> parents: 169 diff changeset	205 // Create logfile and data directory if they do not already exist
129 f6685c2eb75d Store SQLite database and log file in application data directory instead of Matti Hamalainen <ccr@tnsp.org> parents: 128 diff changeset	206 //
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	207 settings.dataPath = QStandardPaths::writableLocation(QStandardPaths::AppDataLocation);
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	208 QDir path(settings.dataPath);
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	209 if (!path.exists(settings.dataPath))
45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	210 path.mkpath(settings.dataPath);
129 f6685c2eb75d Store SQLite database and log file in application data directory instead of Matti Hamalainen <ccr@tnsp.org> parents: 128 diff changeset	211
f6685c2eb75d Store SQLite database and log file in application data directory instead of Matti Hamalainen <ccr@tnsp.org> parents: 128 diff changeset	212 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	213 // Initialize / open SQL database connection
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	214 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	215 QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	216 db.setDatabaseName(settings.dataPath + QDir::separator() + APP_SQLITE_FILE);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	217
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	218 if (!db.open())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	219 {
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	220 slErrorMsg(0,
9 1f442052d332 Oops, 10L. Matti Hamalainen <ccr@tnsp.org> parents: 8 diff changeset	221 QObject::tr("Tietokantaa ei voitu avata"),
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	222 QObject::tr("Yhteyttä SQL-tietokantaan ei saatu.<br><br>Virhe: %1<br><br>").
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	223 arg(db.lastError().text())
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	224 );
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	225 return 1;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	226 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	227
239 9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	228 //
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	229 // Create tables
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	230 //
252 4d2b37a0acf2 Move SQL table creation from schema array to util-module. Matti Hamalainen <ccr@tnsp.org> parents: 249 diff changeset	231 if (!slConditionallyCreateSQLTables(db, slSQLSchemaData, nslSQLSchemaData))
44 8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	232 {
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	233 slErrorMsg(0,
252 4d2b37a0acf2 Move SQL table creation from schema array to util-module. Matti Hamalainen <ccr@tnsp.org> parents: 249 diff changeset	234 QObject::tr("Tietokantataulua ei voitu luoda"),
4d2b37a0acf2 Move SQL table creation from schema array to util-module. Matti Hamalainen <ccr@tnsp.org> parents: 249 diff changeset	235 QObject::tr("Virhe: %1<br><br>").
4d2b37a0acf2 Move SQL table creation from schema array to util-module. Matti Hamalainen <ccr@tnsp.org> parents: 249 diff changeset	236 arg(db.lastError().text())
4d2b37a0acf2 Move SQL table creation from schema array to util-module. Matti Hamalainen <ccr@tnsp.org> parents: 249 diff changeset	237 );
4d2b37a0acf2 Move SQL table creation from schema array to util-module. Matti Hamalainen <ccr@tnsp.org> parents: 249 diff changeset	238 return 1;
44 8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	239 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	240
239 9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	241 //
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	242 // Execute main app
9626307f3eeb Streamline SQL table creation. Matti Hamalainen <ccr@tnsp.org> parents: 237 diff changeset	243 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	244 SyntilistaMainWindow swin;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	245 swin.show();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	246 return sapp.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	247 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	248
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	249
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	250 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251 // Main application window code
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	253 SyntilistaMainWindow::SyntilistaMainWindow(QWidget *parent) :
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254 QMainWindow(parent),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	255 ui(new Ui::SyntilistaMainWindow)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	256 {
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	257 // Setup UI
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	258 ui->setupUi(this);
47 08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	259
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	260 // Restore window size and position
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	261 move(settings.uiPos);
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	262 resize(settings.uiSize);
47 08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	263
122 f0db8267911b Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 121 diff changeset	264 // Setup application icon and window title
203 5c3e3967bdf3 Use Qt resource aliases. Matti Hamalainen <ccr@tnsp.org> parents: 202 diff changeset	265 setWindowIcon(QIcon(QPixmap(":/icon")));
64 73fd86778014 Version number display etc. changes. Matti Hamalainen <ccr@tnsp.org> parents: 63 diff changeset	266 setWindowTitle(tr("%1 versio %3").
39 2cc7c89ab649 Version information, etc. Matti Hamalainen <ccr@tnsp.org> parents: 35 diff changeset	267 arg(tr(APP_NAME)).
204 fd115ca75ce8 Do not use tr() for APP_VERSION. Matti Hamalainen <ccr@tnsp.org> parents: 203 diff changeset	268 arg(APP_VERSION));
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	269
122 f0db8267911b Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 121 diff changeset	270 // Setup large logo in the main window
203 5c3e3967bdf3 Use Qt resource aliases. Matti Hamalainen <ccr@tnsp.org> parents: 202 diff changeset	271 QPixmap logoImage(":/logo");
60 d7a2a48ebe24 Add a separate "About" button, don't use the logo as one. Change logo widget Matti Hamalainen <ccr@tnsp.org> parents: 58 diff changeset	272 ui->button_LogoImage->setPixmap(logoImage);
d7a2a48ebe24 Add a separate "About" button, don't use the logo as one. Change logo widget Matti Hamalainen <ccr@tnsp.org> parents: 58 diff changeset	273 ui->button_LogoImage->setAlignment(Qt::AlignCenter);
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	274
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	275 slSetCommonStyleSheet(this);
22 c23241a3e160 UI polishing. Matti Hamalainen <ccr@tnsp.org> parents: 19 diff changeset	276
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	277 if (settings.uiFullScreen)
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	278 showFullScreen();
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	279
68 597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	280 // Validator for amount input
597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	281 QRegExp vregex("\\d{0,4}[,.]\\d{0,2}\|\\d{0,4}");
597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	282 ui->edit_Amount->setValidator(new QRegExpValidator(vregex, this));
597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	283
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	284 // Setup person list filtering and sorting
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	285 peopleSortIndex = 1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	286 peopleSortOrder = Qt::AscendingOrder;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	287 peopleFilter = "";
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	288
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	289 model_People = new SLPersonSQLModel();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	290 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	291
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	292 ui->tableview_People->setModel(model_People);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	293 ui->tableview_People->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	294 ui->tableview_People->setItemDelegate(new QSqlRelationalDelegate(ui->tableview_People));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	295 ui->tableview_People->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	296 ui->tableview_People->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	297 ui->tableview_People->setSortingEnabled(true);
25 a7e746642599 Fix initial sorting. Matti Hamalainen <ccr@tnsp.org> parents: 24 diff changeset	298 ui->tableview_People->sortByColumn(peopleSortIndex, peopleSortOrder);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	299
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	300 connect(
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	301 ui->tableview_People->selectionModel(),
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	302 SIGNAL(currentChanged(const QModelIndex &, const QModelIndex &)),
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	303 this,
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	304 SLOT(selectedPersonChanged(const QModelIndex &, const QModelIndex &)));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	305
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	306 connect(
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	307 ui->tableview_People->horizontalHeader(),
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	308 SIGNAL(sortIndicatorChanged(int, Qt::SortOrder)),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	309 this,
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	310 SLOT(updateSortOrder(int, Qt::SortOrder)));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	311
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	312 ui->tableview_People->horizontalHeader()->setSortIndicator(1, Qt::AscendingOrder);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	313
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	314 model_Latest = new SLTransactionSQLModel();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	315 ui->tableview_Latest->setModel(model_Latest);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	316 ui->tableview_Latest->setItemDelegate(new QSqlRelationalDelegate(ui->tableview_Latest));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	317 ui->tableview_Latest->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	318 ui->tableview_Latest->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	319
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	320 setActivePerson(-1);
17 d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	321
d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	322 // Keyboard shortcuts
63 fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	323 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_Q), this, SLOT(on_button_Quit_clicked()));
178 2155e05bf61c Use QShortcuts() instead of setShortcut(). Matti Hamalainen <ccr@tnsp.org> parents: 174 diff changeset	324 new QShortcut(QKeySequence(Qt::Key_F10), this, SLOT(on_button_Quit_clicked()));
63 fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	325
178 2155e05bf61c Use QShortcuts() instead of setShortcut(). Matti Hamalainen <ccr@tnsp.org> parents: 174 diff changeset	326 new QShortcut(QKeySequence(Qt::Key_F5), this, SLOT(on_button_AddPerson_clicked()));
2155e05bf61c Use QShortcuts() instead of setShortcut(). Matti Hamalainen <ccr@tnsp.org> parents: 174 diff changeset	327 new QShortcut(QKeySequence(Qt::Key_F6), this, SLOT(on_button_EditPerson_clicked()));
2155e05bf61c Use QShortcuts() instead of setShortcut(). Matti Hamalainen <ccr@tnsp.org> parents: 174 diff changeset	328 new QShortcut(QKeySequence(Qt::Key_F8), this, SLOT(on_button_DeletePerson_clicked()));
2155e05bf61c Use QShortcuts() instead of setShortcut(). Matti Hamalainen <ccr@tnsp.org> parents: 174 diff changeset	329 new QShortcut(QKeySequence(Qt::Key_F1), this, SLOT(on_button_About_clicked()));
2155e05bf61c Use QShortcuts() instead of setShortcut(). Matti Hamalainen <ccr@tnsp.org> parents: 174 diff changeset	330 new QShortcut(QKeySequence(Qt::Key_Escape), this, SLOT(on_button_ClearFilter_clicked()));
63 fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	331
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	332 new QShortcut(QKeySequence(QKeySequence::ZoomIn), this, SLOT(changeUIZoomIn()));
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	333 new QShortcut(QKeySequence(QKeySequence::ZoomOut), this, SLOT(changeUIZoomOut()));
191 79da81b9e184 Move a line cosmetic. Matti Hamalainen <ccr@tnsp.org> parents: 190 diff changeset	334 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_0), this, SLOT(changeUIZoomReset()));
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	335 new QShortcut(QKeySequence(Qt::CTRL + Qt::KeypadModifier + Qt::Key_Plus), this, SLOT(changeUIZoomIn()));
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	336 new QShortcut(QKeySequence(Qt::CTRL + Qt::KeypadModifier + Qt::Key_Minus), this, SLOT(changeUIZoomOut()));
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	337 new QShortcut(QKeySequence(Qt::CTRL + Qt::KeypadModifier + Qt::Key_0), this, SLOT(changeUIZoomReset()));
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	338
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	339 new QShortcut(QKeySequence(Qt::ALT + Qt::Key_Return), this, SLOT(toggleFullScreen()));
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	340
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	341 new QShortcut(QKeySequence(Qt::Key_PageUp), this, SLOT(selectRowPrev()));
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	342 new QShortcut(QKeySequence(Qt::Key_PageDown), this, SLOT(selectRowNext()));
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	343
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	344 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_Return), this, SLOT(focusDebtEdit()));
114 a5c8741b8662 Initial prototype support for printing list of users + print preview dialog. Matti Hamalainen <ccr@tnsp.org> parents: 113 diff changeset	345
a5c8741b8662 Initial prototype support for printing list of users + print preview dialog. Matti Hamalainen <ccr@tnsp.org> parents: 113 diff changeset	346 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_P), this, SLOT(on_button_Print_clicked()));
222 5406b8664f00 Add keyboard shortcut ctrl+t for opening the transactions list. Matti Hamalainen <ccr@tnsp.org> parents: 218 diff changeset	347 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_T), this, SLOT(on_button_ViewTransactions_clicked()));
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	348
194 ff25f4855afc Better comment. Matti Hamalainen <ccr@tnsp.org> parents: 191 diff changeset	349 // Check for latest successful backup time
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	350 qint64 threshold = 7;
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	351 qint64 delta = settings.dbLastBackup.msecsTo(QDateTime::currentDateTimeUtc());
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	352 if (settings.dbBackupMode != BACKUP_NONE &&
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	353 QDateTime::fromSecsSinceEpoch(0).msecsTo(settings.dbLastBackup) > 0 &&
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	354 delta > (1000 * 60 * 60 * 24) * threshold)
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	355 {
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	356 slErrorMsg(this,
195 930191210416 Improve the notice/warning message about last backup having been too long ago. Matti Hamalainen <ccr@tnsp.org> parents: 194 diff changeset	357 tr("<h1>Huomio!</h1>"),
930191210416 Improve the notice/warning message about last backup having been too long ago. Matti Hamalainen <ccr@tnsp.org> parents: 194 diff changeset	358 tr(
930191210416 Improve the notice/warning message about last backup having been too long ago. Matti Hamalainen <ccr@tnsp.org> parents: 194 diff changeset	359 "<p>Edellisestä onnistuneesta tietokannan varmuuskopioinnista on kulunut <b>%1</b> päivää.</p>"
930191210416 Improve the notice/warning message about last backup having been too long ago. Matti Hamalainen <ccr@tnsp.org> parents: 194 diff changeset	360 "<p>On suositeltavaa että kytket laitteen Kampuksen kiinteään verkkoon, että "
930191210416 Improve the notice/warning message about last backup having been too long ago. Matti Hamalainen <ccr@tnsp.org> parents: 194 diff changeset	361 "varmuuskopiointi voidaan suorittaa. Varmuuskopiointia ei voida tehdä langattoman verkon kautta.</p>"
930191210416 Improve the notice/warning message about last backup having been too long ago. Matti Hamalainen <ccr@tnsp.org> parents: 194 diff changeset	362 ).
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	363 arg(delta / (1000 * 60 * 60 * 24)));
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	364 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	365 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	366
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	367
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	368 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	369 // Application main window destructor
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	370 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	371 SyntilistaMainWindow::~SyntilistaMainWindow()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	372 {
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	373 QSettings tmpst(APP_VENDOR, APP_ID);
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	374
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	375 // Save settings
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	376 tmpst.setValue("pos", pos());
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	377 tmpst.setValue("size", size());
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	378 tmpst.setValue("fullscreen", settings.uiFullScreen);
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	379 tmpst.setValue("scale", settings.uiScale);
151 753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	380 tmpst.setValue("dbBackupMode", settings.dbBackupMode);
139 d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	381 tmpst.setValue("dbBackupURL", settings.dbBackupURL);
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	382 tmpst.setValue("dbBackupSecret", settings.dbBackupSecret);
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	383
d5d1549e47fb Change how settings are restored and saved. Matti Hamalainen <ccr@tnsp.org> parents: 138 diff changeset	384 // Free resources
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	385 delete ui;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	386 delete model_People;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	387 delete model_Latest;
134 478ce4c94f6b Commit and close() the database at exit, just in case. Matti Hamalainen <ccr@tnsp.org> parents: 133 diff changeset	388
478ce4c94f6b Commit and close() the database at exit, just in case. Matti Hamalainen <ccr@tnsp.org> parents: 133 diff changeset	389 // Commit and close database
478ce4c94f6b Commit and close() the database at exit, just in case. Matti Hamalainen <ccr@tnsp.org> parents: 133 diff changeset	390 QSqlDatabase::database().commit();
478ce4c94f6b Commit and close() the database at exit, just in case. Matti Hamalainen <ccr@tnsp.org> parents: 133 diff changeset	391 QSqlDatabase::database().close();
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	392
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	393 // Back up the database
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	394 if (settings.dbBackupMode != BACKUP_NONE)
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	395 {
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	396 backupDatabase();
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	397 }
151 753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	398 else
201 ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	399 {
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	400 slLog("INFO",
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	401 QStringLiteral("Database backup mode is NONE, not performing backup."));
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	402 }
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	403 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	404
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	405
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	406 void SyntilistaMainWindow::backupSuccess()
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	407 {
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	408 QSettings tmpst(APP_VENDOR, APP_ID);
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	409 slLog("INFO", QStringLiteral("Backup successful."));
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	410
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	411 tmpst.setValue("dbLastBackup", QDateTime::currentDateTimeUtc());
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	412 }
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	413
76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	414
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	415 void SyntilistaMainWindow::backupDatabase()
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	416 {
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	417 QString dbFilename = settings.dataPath + QDir::separator() + APP_SQLITE_FILE;
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	418 QString backupFilename = APP_SQLITE_FILE;
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	419 backupDialog = NULL;
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	420
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	421 if (settings.dbBackupURL == QString() \|\| settings.dbBackupURL == "")
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	422 {
201 ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	423 slLog("ERROR",
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	424 QStringLiteral("Database backup URL not set in configuration."));
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	425 return;
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	426 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	427
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	428 if (settings.dbBackupSecret == QString() \|\| settings.dbBackupSecret == "")
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	429 {
201 ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	430 slLog("ERROR",
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	431 QStringLiteral("Database backup secret key not set in configuration."));
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	432 return;
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	433 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	434
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	435 if (settings.dbBackupMode == BACKUP_HTTP)
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	436 {
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	437 #ifdef USE_QTHTTP
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	438 // Check for network access
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	439 httpBackupReply = NULL;
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	440
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	441 QNetworkAccessManager *manager = new QNetworkAccessManager();
154 ef4edd798a45 Disable network availability check for now, it seems to return false values in some cases. Matti Hamalainen <ccr@tnsp.org> parents: 153 diff changeset	442 /*
155 6187c36de250 Add a comment. Matti Hamalainen <ccr@tnsp.org> parents: 154 diff changeset	443 // NOTE XXX! For some reason the manager returns not accessible under Wine
6187c36de250 Add a comment. Matti Hamalainen <ccr@tnsp.org> parents: 154 diff changeset	444 // and possibly some version(s) of Windows .. not sure why, thus commented
6187c36de250 Add a comment. Matti Hamalainen <ccr@tnsp.org> parents: 154 diff changeset	445 // out for now.
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	446 if (manager->networkAccessible() != QNetworkAccessManager::Accessible)
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	447 {
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	448 slLog("ERROR", QStringLiteral("Network not available, cannot backup the database."));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	449 return;
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	450 }
154 ef4edd798a45 Disable network availability check for now, it seems to return false values in some cases. Matti Hamalainen <ccr@tnsp.org> parents: 153 diff changeset	451 */
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	452
199 597a75429818 Stray whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 197 diff changeset	453 // Attempt to open the database file
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	454 QFile *file = new QFile(dbFilename);
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	455 if (!file->open(QIODevice::ReadOnly))
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	456 {
201 ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	457 slLog("ERROR",
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	458 QStringLiteral("Failed to open database file '%1' for backup.").
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	459 arg(dbFilename));
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	460 return;
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	461 }
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	462
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	463 // Okay, we seem to be "go" ..
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	464 slLog("INFO",
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	465 QStringLiteral("Attempting database backup from '%1' to '%2'.").
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	466 arg(dbFilename).arg(settings.dbBackupURL));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	467
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	468 // Create the HTTP POST request
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	469 QHttpMultiPart *multiPart = new QHttpMultiPart(QHttpMultiPart::FormDataType);
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	470
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	471 // The "secret" key as POST parameter
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	472 QHttpPart postPart;
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	473 postPart.setHeader(QNetworkRequest::ContentDispositionHeader,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	474 QVariant("form-data; name=\"secret\";"));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	475 postPart.setBody(QByteArray(settings.dbBackupSecret.toUtf8()));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	476
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	477 // Actual data as binary octet-stream
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	478 QHttpPart dataPart;
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	479 dataPart.setHeader(QNetworkRequest::ContentTypeHeader,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	480 QVariant("binary/octet-stream"));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	481
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	482 dataPart.setHeader(QNetworkRequest::ContentDispositionHeader,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	483 QVariant("form-data; name=\"file\"; filename=\""+ backupFilename +"\""));
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	484
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	485 dataPart.setBodyDevice(file);
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	486 file->setParent(multiPart); // we cannot delete the QFile object now, so delete it with the multiPart
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	487
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	488 multiPart->append(postPart);
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	489 multiPart->append(dataPart);
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	490
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	491 // Attempt to POST the whole thing
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	492 QUrl url(settings.dbBackupURL);
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	493 QNetworkRequest request(url);
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	494 httpBackupReply = manager->post(request, multiPart);
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	495 multiPart->setParent(httpBackupReply);
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	496
153 794a2387e92a Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 152 diff changeset	497 // Connect signals
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	498 connect(
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	499 httpBackupReply,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	500 SIGNAL(finished()),
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	501 this,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	502 SLOT(httpBackupFinished()));
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	503
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	504 connect(
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	505 httpBackupReply,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	506 SIGNAL(uploadProgress(qint64, qint64)),
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	507 this,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	508 SLOT(httpBackupProgress(qint64, qint64)));
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	509
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	510 connect(
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	511 httpBackupReply,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	512 SIGNAL(error(QNetworkReply::NetworkError)),
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	513 this,
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	514 SLOT(httpBackupError(QNetworkReply::NetworkError)));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	515 #else
153 794a2387e92a Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 152 diff changeset	516 // Disabled
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	517 slLog("ERROR", QStringLiteral("Backup method is HTTP/HTTPS, but support is not compiled in!"));
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	518 return;
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	519 #endif
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	520 }
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	521 else
151 753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	522 {
753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	523 slLog("ERROR", QStringLiteral("Database backup mode is INVALID! Not performing backup!"));
753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	524 return;
753ae3569cb7 Actually save the backup mode setting to configuration, and add some error checks. Matti Hamalainen <ccr@tnsp.org> parents: 150 diff changeset	525 }
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	526
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	527 // Create progress dialog
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	528 backupDialog = new QProgressDialog(
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	529 tr("Varmuuskopioidaan tietokantaa ..."),
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	530 QString(),
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	531 0,
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	532 100,
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	533 this);
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	534
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	535 backupDialog->setAttribute(Qt::WA_DeleteOnClose);
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	536 backupDialog->setAutoClose(false);
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	537 backupDialog->setWindowModality(Qt::ApplicationModal);
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	538 backupDialog->exec();
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	539 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	540
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	541
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	542 #ifdef USE_QTHTTP
2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	543 void SyntilistaMainWindow::httpBackupProgress(qint64 bytesSent, qint64 bytesTotal)
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	544 {
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	545 if (bytesTotal > 0)
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	546 {
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	547 slLog("INFO",
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	548 QStringLiteral("Backup sent %1 / %2 bytes.").
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	549 arg(bytesSent).
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	550 arg(bytesTotal));
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	551
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	552 backupDialog->setValue((bytesSent * 100) / bytesTotal);
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	553 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	554 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	555
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	556
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	557 void SyntilistaMainWindow::httpBackupError(QNetworkReply::NetworkError code)
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	558 {
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	559 slLog("ERROR",
147 c722cb0b6662 Remove useless linefeed in an error log message. Matti Hamalainen <ccr@tnsp.org> parents: 145 diff changeset	560 QStringLiteral("Backup failed with network error %1.").
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	561 arg(code)
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	562 );
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	563 }
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	564
36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	565
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	566 void SyntilistaMainWindow::httpBackupFinished()
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	567 {
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	568 if (httpBackupReply)
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	569 {
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	570 QVariant status = httpBackupReply->attribute(QNetworkRequest::HttpStatusCodeAttribute);
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	571 if (status.isValid())
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	572 {
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	573 int code = status.toInt();
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	574 switch (code)
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	575 {
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	576 case 200:
190 76afbf6508c8 Add check for last successful database backup, and show a warning dialog at Matti Hamalainen <ccr@tnsp.org> parents: 187 diff changeset	577 backupSuccess();
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	578 break;
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	579
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	580 case 403:
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	581 slLog("ERROR",
4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	582 QStringLiteral("Backup server authentication failed. Wrong secret or other invalid settings."));
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	583 break;
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	584
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	585 default:
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	586 slLog("ERROR",
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	587 QStringLiteral("Backup server responded with error:\n")+
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	588 QString::fromUtf8(httpBackupReply->readAll()));
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	589 break;
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	590 }
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	591 }
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	592 }
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	593 else
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	594 {
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	595 slLog("WARNING",
4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	596 QStringLiteral("Backup finished prematurely (failed)."));
144 75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	597 }
75a4faa219a9 Improve backup process error handling. Matti Hamalainen <ccr@tnsp.org> parents: 142 diff changeset	598
142 36c9cb759326 Implement simple SQLite database backup at program exit using Qt HTTP/HTTPS Matti Hamalainen <ccr@tnsp.org> parents: 140 diff changeset	599 backupDialog->close();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	600 }
150 2a8c97753381 Make the backup stuff compile-time optional. Matti Hamalainen <ccr@tnsp.org> parents: 148 diff changeset	601 #endif
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	602
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	603
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	604 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	605 // Helper function for showing messages in the statusbar/line
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	606 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	607 void SyntilistaMainWindow::statusMsg(const QString &msg)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	608 {
133 df03ab8b6413 Improve logging. Matti Hamalainen <ccr@tnsp.org> parents: 132 diff changeset	609 slLog("STATUS", msg);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	610 ui->statusbar->showMessage(msg);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	611 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	612
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	613
122 f0db8267911b Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 121 diff changeset	614 //
272 d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	615 //
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	616 //
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	617 void SyntilistaMainWindow::toggleFullScreen()
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	618 {
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	619 settings.uiFullScreen = !settings.uiFullScreen;
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	620
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	621 if (settings.uiFullScreen)
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	622 {
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	623 showFullScreen();
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	624 }
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	625 else
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	626 {
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	627 showMaximized();
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	628 }
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	629 }
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	630
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	631
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	632
d18f1a8cb4df Add alt+enter key shortcut for toggling fullscreen window. Matti Hamalainen <ccr@tnsp.org> parents: 271 diff changeset	633 //
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	634 // Window scale / zoom changing
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	635 //
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	636 void SyntilistaMainWindow::changeUIZoomIn()
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	637 {
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	638 settings.uiScale += 0.1f;
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	639 slSetCommonStyleSheet(this);
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	640 }
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	641
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	642
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	643 void SyntilistaMainWindow::changeUIZoomOut()
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	644 {
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	645 settings.uiScale -= 0.1f;
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	646 slSetCommonStyleSheet(this);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	647 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	648
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	649
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	650 void SyntilistaMainWindow::changeUIZoomReset()
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	651 {
135 45e17cdde93a Move application global settings to a struct. Matti Hamalainen <ccr@tnsp.org> parents: 134 diff changeset	652 settings.uiScale = 1.0f;
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	653 slSetCommonStyleSheet(this);
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	654 }
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	655
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	656
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	657 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	658 // Slot for changed selection of person entry
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	659 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	660 void SyntilistaMainWindow::selectedPersonChanged(const QModelIndex &curr, const QModelIndex &prev)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	661 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	662 (void) prev;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	663 int row = curr.row();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	664 if (row >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	665 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	666 const QAbstractItemModel *model = curr.model();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	667 setActivePerson(model->data(model->index(row, 0)).toInt());
89 8ec1eb6b00b6 Automatically set focus to debt value edit field after selecting a person. Matti Hamalainen <ccr@tnsp.org> parents: 84 diff changeset	668 focusDebtEdit();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	669 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	670 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	671 setActivePerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	672 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	673
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	674
122 f0db8267911b Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 121 diff changeset	675 //
f0db8267911b Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 121 diff changeset	676 // Set currently active person to given SQL id
f0db8267911b Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 121 diff changeset	677 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	678 void SyntilistaMainWindow::setActivePerson(qint64 id)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	679 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	680 currPerson.id = id;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	681
1 db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	682 ui->button_EditPerson->setEnabled(id >= 0);
db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	683
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	684 if (id >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	685 {
102 064138b6d34e Rename getPersonInfo() to slGetPersonInfo(). Matti Hamalainen <ccr@tnsp.org> parents: 101 diff changeset	686 if (!slGetPersonInfo(id, currPerson))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	687 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	688 statusMsg(tr("Virhe! Ei henkilöä ID:llä #%1").arg(id));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	689 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	690 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	691 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	692 ui->personGB->setEnabled(true);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	693 ui->label_PersonName->setText(currPerson.lastName +", "+ currPerson.firstName);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	694
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	695 ui->label_BalanceValue->setText(slMoneyValueToStr(currPerson.balance));
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	696 ui->label_BalanceValue->setStyleSheet(currPerson.balance < 0 ? "color: red;" : "color: green;");
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	697 ui->button_PayFullDebt->setEnabled(currPerson.balance < 0);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	698
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	699 QSqlQuery query;
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	700 query.prepare(QStringLiteral("SELECT id,value,added FROM transactions WHERE person=? ORDER BY added DESC LIMIT 5"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	701 query.addBindValue(id);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	702 query.exec();
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	703 slCheckAndReportSQLError(query, "SELECT transactions for tableview_Latest");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	704
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	705 model_Latest->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	706
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	707 model_Latest->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	708 model_Latest->setHeaderData(1, Qt::Horizontal, tr("Summa"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	709 model_Latest->setHeaderData(2, Qt::Horizontal, tr("Aika"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	710
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	711 ui->tableview_Latest->setModel(model_Latest);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	712 ui->tableview_Latest->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	713 ui->tableview_Latest->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	714 ui->tableview_Latest->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	715
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	716 slSetCommonStyleSheet(this);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	717 return; // Ugly
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	718 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	719 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	720
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	721 // In case of id < 0 or errors ..
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	722 ui->personGB->setEnabled(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	723 ui->edit_Amount->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	724 ui->label_BalanceValue->setText("--");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	725 ui->label_BalanceValue->setStyleSheet(NULL);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	726 ui->label_PersonName->setText("???");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	727 ui->tableview_Latest->setModel(NULL);
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	728 slSetCommonStyleSheet(this);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	729 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	730
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	731
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	732 //
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	733 // Slot for changing person list sort order
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	734 //
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	735 void SyntilistaMainWindow::updateSortOrder(int index, Qt::SortOrder order)
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	736 {
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	737 peopleSortIndex = index;
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	738 peopleSortOrder = order;
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	739 updatePersonList();
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	740 }
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	741
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	742
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	743 void SyntilistaMainWindow::on_button_Quit_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	744 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	745 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	746 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	747
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	748
60 d7a2a48ebe24 Add a separate "About" button, don't use the logo as one. Change logo widget Matti Hamalainen <ccr@tnsp.org> parents: 58 diff changeset	749 void SyntilistaMainWindow::on_button_About_clicked()
47 08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	750 {
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	751 new AboutWindow(this);
74 cc8fbf9a61b2 Add a help dialog. Matti Hamalainen <ccr@tnsp.org> parents: 71 diff changeset	752 }
cc8fbf9a61b2 Add a help dialog. Matti Hamalainen <ccr@tnsp.org> parents: 71 diff changeset	753
cc8fbf9a61b2 Add a help dialog. Matti Hamalainen <ccr@tnsp.org> parents: 71 diff changeset	754
218 c3f47d489097 Implement global transactions viewer dialog. Matti Hamalainen <ccr@tnsp.org> parents: 217 diff changeset	755 void SyntilistaMainWindow::on_button_ViewTransactions_clicked()
c3f47d489097 Implement global transactions viewer dialog. Matti Hamalainen <ccr@tnsp.org> parents: 217 diff changeset	756 {
c3f47d489097 Implement global transactions viewer dialog. Matti Hamalainen <ccr@tnsp.org> parents: 217 diff changeset	757 new ViewTransactions(this);
c3f47d489097 Implement global transactions viewer dialog. Matti Hamalainen <ccr@tnsp.org> parents: 217 diff changeset	758 }
c3f47d489097 Implement global transactions viewer dialog. Matti Hamalainen <ccr@tnsp.org> parents: 217 diff changeset	759
c3f47d489097 Implement global transactions viewer dialog. Matti Hamalainen <ccr@tnsp.org> parents: 217 diff changeset	760
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	761 void SyntilistaMainWindow::on_button_DeletePerson_clicked()
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	762 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	763 if (currPerson.id <= 0)
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	764 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	765 statusMsg(tr("Ei valittua henkilöä!"));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	766 return;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	767 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	768
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	769 // Internal sanity check
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	770 SLPersonInfo info;
102 064138b6d34e Rename getPersonInfo() to slGetPersonInfo(). Matti Hamalainen <ccr@tnsp.org> parents: 101 diff changeset	771 if (!slGetPersonInfo(currPerson.id, info))
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	772 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	773 statusMsg(tr("Virhe! Ei henkilöä ID:llä #%1").arg(currPerson.id));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	774 return;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	775 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	776
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	777 // Ask for confirmation
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	778 QMessageBox dlg(this);
132 dc9fe580da42 Rename setCommonStyleSheet() to slSetCommonStyleSheet(). Matti Hamalainen <ccr@tnsp.org> parents: 130 diff changeset	779 slSetCommonStyleSheet(&dlg);
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	780
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	781 dlg.setText(tr("Varmistus"));
201 ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	782 dlg.setInformativeText(tr(
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	783 "<h3>Haluatko varmasti poistaa henkilön:</h3>"
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	784 "<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	785 "<b>'%1, %2'</b> <i>(ID #%3)</i>?<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	786 "<br>"
186 cc3d7745e798 Cosmetic adjustments to the delete person confirmation dialog. Matti Hamalainen <ccr@tnsp.org> parents: 180 diff changeset	787 "<span style='color:#f00;'>Tämä poistaa sekä henkilön ja hänen koko tapahtumahistoriansa PYSYVÄSTI!</span>"
cc3d7745e798 Cosmetic adjustments to the delete person confirmation dialog. Matti Hamalainen <ccr@tnsp.org> parents: 180 diff changeset	788 "<br>").
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	789 arg(info.lastName).arg(info.firstName).arg(info.id));
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	790
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	791 dlg.setTextFormat(Qt::RichText);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	792 dlg.setIcon(QMessageBox::Question);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	793 dlg.setStandardButtons(QMessageBox::Yes \| QMessageBox::No);
71 2d12c12a7b89 More UI improvements. Matti Hamalainen <ccr@tnsp.org> parents: 68 diff changeset	794 dlg.setButtonText(QMessageBox::Yes, tr("Kyllä"));
2d12c12a7b89 More UI improvements. Matti Hamalainen <ccr@tnsp.org> parents: 68 diff changeset	795 dlg.setButtonText(QMessageBox::No, tr("Ei / peruuta"));
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	796 dlg.setDefaultButton(QMessageBox::No);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	797
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	798 if (dlg.exec() == QMessageBox::Yes)
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	799 {
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	800 int rv = model_People->deletePerson(info.id);
14 8a6a90ce0e0f Fixes. Matti Hamalainen <ccr@tnsp.org> parents: 13 diff changeset	801 updatePersonList();
24 0e0948aec438 De-select active person when deleting. Matti Hamalainen <ccr@tnsp.org> parents: 23 diff changeset	802 setActivePerson(-1);
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	803 if (rv != 0)
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	804 {
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	805 slErrorMsg(this,
df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	806 tr("SQL-tietokantavirhe"),
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	807 tr("Henkilön tietoja poistettaessa tapahtui virhe #%1.").
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	808 arg(rv));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	809 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	810 else
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	811 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	812 statusMsg(tr("Henkilö '%1 %2' (ID #%3) poistettu.").
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	813 arg(info.firstName).arg(info.lastName).
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	814 arg(info.id));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	815 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	816 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	817 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	818
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	819
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	820 void SyntilistaMainWindow::on_button_AddPerson_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	821 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	822 EditPerson *person = new EditPerson(this);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	823 person->setPerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	824 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	825
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	826
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	827 void SyntilistaMainWindow::on_button_EditPerson_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	828 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	829 if (currPerson.id >= 0)
1 db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	830 {
db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	831 EditPerson *person = new EditPerson(this);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	832 person->setPerson(currPerson.id);
1 db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	833 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	834 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	835
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	836
249 cfaf03d8d23e Disable doubleclick edit of users for now. Matti Hamalainen <ccr@tnsp.org> parents: 248 diff changeset	837 /*
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	838 void SyntilistaMainWindow::on_tableview_People_doubleClicked(const QModelIndex &curr)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	839 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	840 int row = curr.row();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	841 if (row >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	842 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	843 const QAbstractItemModel *model = curr.model();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	844 setActivePerson(model->data(model->index(row, 0)).toInt());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	845
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	846 EditPerson *person = new EditPerson(this);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	847 person->setPerson(currPerson.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	848 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	849 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	850 setActivePerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	851 }
249 cfaf03d8d23e Disable doubleclick edit of users for now. Matti Hamalainen <ccr@tnsp.org> parents: 248 diff changeset	852 */
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	853
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	854
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	855 void SyntilistaMainWindow::on_button_ClearFilter_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	856 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	857 ui->edit_PersonFilter->clear();
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	858 ui->edit_PersonFilter->setFocus(Qt::ShortcutFocusReason);
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	859 }
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	860
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	861
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	862 void SyntilistaMainWindow::focusDebtEdit()
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	863 {
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	864 if (currPerson.id >= 0)
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	865 ui->edit_Amount->setFocus(Qt::ShortcutFocusReason);
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	866 }
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	867
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	868
211 6585cac42b75 Rename selectRowDelta() to clearer void changeSelectedRow(). Matti Hamalainen <ccr@tnsp.org> parents: 210 diff changeset	869 void SyntilistaMainWindow::changeSelectedRow(const int delta)
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	870 {
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	871 QItemSelectionModel *sel = ui->tableview_People->selectionModel();
209 6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	872 int prow = sel->currentIndex().row();
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	873 int nrow = prow + delta;
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	874 if (nrow < 0)
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	875 nrow = 0;
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	876 else
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	877 if (nrow >= model_People->rowCount())
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	878 nrow = model_People->rowCount() - 1;
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	879
209 6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	880 if (nrow != prow)
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	881 {
212 70317bb39f05 Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 211 diff changeset	882 // If row changed, set current index
209 6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	883 sel->setCurrentIndex(model_People->index(nrow, 0),
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	884 QItemSelectionModel::ClearAndSelect\|QItemSelectionModel::Rows);
210 02aae61e807e Scroll along with the currently selected person in the person list, Matti Hamalainen <ccr@tnsp.org> parents: 209 diff changeset	885
212 70317bb39f05 Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 211 diff changeset	886 // The column must be a visible one (not set "hidden", as the ID field is)
70317bb39f05 Add comments. Matti Hamalainen <ccr@tnsp.org> parents: 211 diff changeset	887 // thus we use column index of 1 here for the QModelIndex()
210 02aae61e807e Scroll along with the currently selected person in the person list, Matti Hamalainen <ccr@tnsp.org> parents: 209 diff changeset	888 ui->tableview_People->scrollTo(model_People->index(nrow, 1));
209 6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	889 }
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	890 }
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	891
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	892
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	893 void SyntilistaMainWindow::selectRowPrev()
6f404158ce8c Get rid of tiny bit of code duplication. Matti Hamalainen <ccr@tnsp.org> parents: 207 diff changeset	894 {
211 6585cac42b75 Rename selectRowDelta() to clearer void changeSelectedRow(). Matti Hamalainen <ccr@tnsp.org> parents: 210 diff changeset	895 changeSelectedRow(-1);
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	896 }
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	897
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	898
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	899 void SyntilistaMainWindow::selectRowNext()
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	900 {
211 6585cac42b75 Rename selectRowDelta() to clearer void changeSelectedRow(). Matti Hamalainen <ccr@tnsp.org> parents: 210 diff changeset	901 changeSelectedRow(1);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	902 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	903
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	904
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	905 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	906 // Update visible person list/query based on the current
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	907 // filtering and sorting settings.
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	908 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	909 void SyntilistaMainWindow::updatePersonList()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	910 {
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	911 static const QString queryBase =
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	912 QStringLiteral("SELECT id,last_name,first_name,"
107 8ceaafde9b52 Use total() instead of sum() in the SQL queries for better accuracy. Matti Hamalainen <ccr@tnsp.org> parents: 104 diff changeset	913 "(SELECT TOTAL(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	914 "updated FROM people");
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	915
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	916 QString queryOrderDir, queryOrderBy;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	917
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	918 // Sort order
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	919 if (peopleSortOrder == Qt::AscendingOrder)
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	920 queryOrderDir = QStringLiteral("ASC");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	921 else
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	922 queryOrderDir = QStringLiteral("DESC");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	923
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	924 // Sort by which column
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	925 switch (peopleSortIndex)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	926 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	927 case 1:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	928 case 2:
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	929 queryOrderBy =
416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	930 QStringLiteral(" ORDER BY last_name ") + queryOrderDir +
416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	931 QStringLiteral(",first_name ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	932 break;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	933
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	934 case 3:
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	935 queryOrderBy =
416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	936 QStringLiteral(" ORDER BY balance ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	937 break;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	938
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	939 case 4:
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	940 queryOrderBy =
416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	941 QStringLiteral(" ORDER BY updated ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	942 break;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	943
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	944 default:
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	945 queryOrderBy = "";
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	946 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	947
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	948 // Are we filtering or not?
126 b51cee929416 Add program debug logging. Matti Hamalainen <ccr@tnsp.org> parents: 125 diff changeset	949 QSqlQuery query;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	950 if (peopleFilter != "")
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	951 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	952 // Filter by name(s)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	953 QString tmp = "%"+ peopleFilter +"%";
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	954 query.prepare(queryBase + QStringLiteral(" WHERE first_name LIKE ? OR last_name LIKE ?") + queryOrderBy);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	955
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	956 query.addBindValue(tmp);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	957 query.addBindValue(tmp);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	958 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	959 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	960 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	961 // No filter
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	962 query.prepare(queryBase + queryOrderBy);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	963 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	964
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	965 // Execute the query and update model
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	966 slCheckAndReportSQLError(query, "updatePersonList() before exec");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	967 query.exec();
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	968 slCheckAndReportSQLError(query, "updatePersonList() after exec");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	969
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	970 model_People->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	971
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	972 model_People->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	973 model_People->setHeaderData(1, Qt::Horizontal, tr("Sukunimi"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	974 model_People->setHeaderData(2, Qt::Horizontal, tr("Etunimi"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	975 model_People->setHeaderData(3, Qt::Horizontal, tr("Tase"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	976 model_People->setHeaderData(4, Qt::Horizontal, tr("Muutettu"));
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	977
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	978 updateMiscValues();
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	979 }
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	980
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	981
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	982 //
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	983 // Update some values in the UI
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	984 //
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	985 void SyntilistaMainWindow::updateMiscValues()
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	986 {
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	987 // Update total balance value
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	988 QSqlQuery query;
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	989 query.prepare(QStringLiteral("SELECT TOTAL(value) FROM transactions AS balance"));
10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	990 query.exec();
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	991 if (slCheckAndReportSQLError(query, "updateMiscValues() get total balance query") &&
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	992 query.next())
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	993 {
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	994 totalBalance = query.value(0).toDouble();;
636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	995 ui->label_TotalBalanceValue->setText(slMoneyValueToStr(totalBalance));
636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	996 ui->label_TotalBalanceValue->setStyleSheet(totalBalance < 0 ? "color: red;" : "color: green;");
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	997 }
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	998
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	999 // Update number of people
9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1000 query.finish();
9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1001 query.prepare(QStringLiteral("SELECT COUNT(*) FROM people"));
9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1002 query.exec();
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	1003 if (slCheckAndReportSQLError(query, "updateMiscValues() get people count") &&
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1004 query.next())
9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1005 {
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	1006 totalPeople = query.value(0).toInt();
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1007 ui->label_NumPeopleValue->setText(query.value(0).toString());
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	1008 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1009 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1010
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1011
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1012 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1013 // Update the list of people when filter parameter changes
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1014 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1015 void SyntilistaMainWindow::on_edit_PersonFilter_textChanged(const QString &str)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1016 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1017 peopleFilter = slCleanupStr(str);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1018 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1019 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1020
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1021
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1022 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1023 // Add one transaction to given person id
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1024 //
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	1025 int SyntilistaMainWindow::addTransaction(qint64 id, double value, SLPersonInfo &info)
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1026 {
179 a2f11e6665d6 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 178 diff changeset	1027 // Sanity check: Check if the given person ID exists
102 064138b6d34e Rename getPersonInfo() to slGetPersonInfo(). Matti Hamalainen <ccr@tnsp.org> parents: 101 diff changeset	1028 if (!slGetPersonInfo(id, info))
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1029 return -1;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1030
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1031 QSqlDatabase::database().transaction();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1032
179 a2f11e6665d6 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 178 diff changeset	1033 // Add transaction entry
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1034 QSqlQuery query;
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	1035 query.prepare(QStringLiteral("INSERT INTO transactions (person,value,added) VALUES (?,?,?)"));
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1036 query.addBindValue(id);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1037 query.addBindValue(value);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1038 query.addBindValue(QDateTime::currentDateTimeUtc());
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1039 query.exec();
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	1040 if (!slCheckAndReportSQLError(query, QStringLiteral("addTransaction(%1, %2)").arg(id).arg(value), true))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1041 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1042 QSqlDatabase::database().rollback();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1043 return -2;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1044 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1045
179 a2f11e6665d6 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 178 diff changeset	1046 // Update person record timestamp
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	1047 query.prepare(QStringLiteral("UPDATE people SET updated=? WHERE id=?"));
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1048 query.addBindValue(QDateTime::currentDateTimeUtc());
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1049 query.addBindValue(id);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1050 query.exec();
255 55581d90c55d Change API for slCheckAndReportSQLError(). Matti Hamalainen <ccr@tnsp.org> parents: 253 diff changeset	1051 if (!slCheckAndReportSQLError(query, "addTransaction update timestamp", true))
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1052 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1053 QSqlDatabase::database().rollback();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1054 return -3;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1055 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1056
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1057 QSqlDatabase::database().commit();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1058
145 9f3c0a99bcb1 Add display for total number of people on the database. Matti Hamalainen <ccr@tnsp.org> parents: 144 diff changeset	1059 updateMiscValues();
130 10c6bd84eb32 Add "total balance" information in the UI, which displays the total sum balance of all people. Matti Hamalainen <ccr@tnsp.org> parents: 129 diff changeset	1060
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1061 return 0;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1062 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1063
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1064
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1065 int SyntilistaMainWindow::addTransactionGUI(qint64 id, bool debt, double value)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1066 {
174 636a24c76232 Rename some classes to add a SL prefix to their names. Matti Hamalainen <ccr@tnsp.org> parents: 170 diff changeset	1067 SLPersonInfo info;
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1068
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1069 // Check if person is selected
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1070 if (id <= 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1071 return -1;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1072
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1073 // Check value
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1074 if (value == 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1075 {
202 4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	1076 QString tmp = debt ? tr("lisätty") : tr("vähennetty");
4e25db3327a7 Use QStringLiteral() some more. Matti Hamalainen <ccr@tnsp.org> parents: 201 diff changeset	1077 statusMsg(tr("Velkaa ei %1 koska summaa ei määritetty.").arg(tmp));
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1078 return 1;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1079 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1080
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1081 // Perform transaction insert
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1082 int ret = addTransaction(id, debt ? -value : value, info);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1083 if (ret == 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1084 {
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1085 // All ok, clear amount entry and update person data
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1086 ui->edit_Amount->clear();
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	1087 if (info.id == currPerson.id)
07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	1088 setActivePerson(info.id);
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1089
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	1090 model_People->updateModel();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1091
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1092 if (debt)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1093 {
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	1094 // Debt was added
216 8b9d55fb8988 Remove one temporary variable. Matti Hamalainen <ccr@tnsp.org> parents: 213 diff changeset	1095 statusMsg(
8b9d55fb8988 Remove one temporary variable. Matti Hamalainen <ccr@tnsp.org> parents: 213 diff changeset	1096 tr("Lisättiin velkaa %1 EUR henkilölle '%2 %3' (#%4).").
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1097 arg(slMoneyValueToStr(value)).
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1098 arg(info.firstName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1099 arg(info.lastName).
216 8b9d55fb8988 Remove one temporary variable. Matti Hamalainen <ccr@tnsp.org> parents: 213 diff changeset	1100 arg(info.id));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1101 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1102 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1103 {
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	1104 // Debt was reduced
216 8b9d55fb8988 Remove one temporary variable. Matti Hamalainen <ccr@tnsp.org> parents: 213 diff changeset	1105 statusMsg(
8b9d55fb8988 Remove one temporary variable. Matti Hamalainen <ccr@tnsp.org> parents: 213 diff changeset	1106 tr("Vähennettiin velkaa %1 EUR henkilöltä '%2 %3' (#%4).").
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1107 arg(slMoneyValueToStr(value)).
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1108 arg(info.firstName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1109 arg(info.lastName).
216 8b9d55fb8988 Remove one temporary variable. Matti Hamalainen <ccr@tnsp.org> parents: 213 diff changeset	1110 arg(info.id));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1111 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1112 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1113 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1114 {
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	1115 slErrorMsg(this,
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1116 tr("SQL-tietokantavirhe"),
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1117 tr("Tietokantaan tapahtumaa lisättäessa tapahtui virhe #%1.").
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1118 arg(ret));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1119 }
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1120
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	1121 return ret;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1122 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1123
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1124
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1125 void SyntilistaMainWindow::on_button_AddDebt_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1126 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1127 addTransactionGUI(currPerson.id, true, slMoneyStrToValue(ui->edit_Amount->text()));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1128 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1129
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1130
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	1131 void SyntilistaMainWindow::on_button_PayDebt_clicked()
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1132 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1133 addTransactionGUI(currPerson.id, false, slMoneyStrToValue(ui->edit_Amount->text()));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1134 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1135
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1136
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	1137 void SyntilistaMainWindow::on_button_PayFullDebt_clicked()
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	1138 {
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	1139 // Sanity check that there is a selected person
187 7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1140 if (currPerson.id <= 0)
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1141 {
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1142 statusMsg(tr("Ei valittua henkilöä!"));
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1143 return;
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1144 }
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1145
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	1146 // Check the balance ..
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1147 if (currPerson.balance < 0)
187 7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1148 {
196 416868143486 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 195 diff changeset	1149 // And ask confirmation that user really wants to clear the full debt
271 df3f902588af Add parent window argument to slErrorMsg() and use it. Matti Hamalainen <ccr@tnsp.org> parents: 255 diff changeset	1150 QMessageBox dlg(this);
187 7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1151 slSetCommonStyleSheet(&dlg);
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1152 dlg.setText(tr("Varmistus"));
201 ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	1153 dlg.setInformativeText(tr(
ea0247fab5a4 Cosmetics/indentation. Matti Hamalainen <ccr@tnsp.org> parents: 200 diff changeset	1154 "<h3>Haluatko maksaa henkilön koko velan?</h3>"
187 7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1155 "<br>"
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1156 "<b>'%1, %2'</b>, velka <span style='color:#f00;'><b>%4 EUR</b></span>"
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1157 "<br>").
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1158 arg(currPerson.lastName).arg(currPerson.firstName).
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1159 arg(slMoneyValueToStr(currPerson.balance)));
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1160
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1161 dlg.setTextFormat(Qt::RichText);
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1162 dlg.setIcon(QMessageBox::Question);
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1163 dlg.setStandardButtons(QMessageBox::Yes \| QMessageBox::No);
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1164 dlg.setButtonText(QMessageBox::Yes, tr("Kyllä"));
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1165 dlg.setButtonText(QMessageBox::No, tr("Ei / peruuta"));
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1166 dlg.setDefaultButton(QMessageBox::No);
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1167
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1168 if (dlg.exec() == QMessageBox::Yes)
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1169 {
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1170 addTransactionGUI(currPerson.id, false, -currPerson.balance);
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1171 }
7f0a4d5010d1 Add confirmation dialog to "pay full debt". Matti Hamalainen <ccr@tnsp.org> parents: 186 diff changeset	1172 }
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	1173 else
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1174 {
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1175 statusMsg(
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1176 tr("Valitulla henkilöllä '%1, %2' ei ole velkaa.").
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1177 arg(currPerson.lastName).
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1178 arg(currPerson.firstName));
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	1179 }
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	1180 }

Mercurial > hg > syntilista

annotate src/main.cpp @ 272:d18f1a8cb4df