syntilista: src/main.cpp annotate

annotate src/main.cpp @ 101:2477f46282c8

Split getPersonInfo() to getPersonInfoRec().

author	Matti Hamalainen <ccr@tnsp.org>
date	Wed, 28 Jun 2017 08:11:33 +0300
parents	7b8755801111
children	064138b6d34e

rev	line source
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	2 // Syntilista - velkalistasovellus Kampus-kahvilaan
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>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	4 // (C) Copyright 2017 Tecnic Software productions (TNSP)
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>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	12 #include "main.h"
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	13 #include "ui_mainwindow.h"
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	14 #include "ui_editperson.h"
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	15 #include "ui_aboutwindow.h"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	16
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	17
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	18 double setScale;
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	19
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	20
83 83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	21 //
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	22 // Display an error dialog with given title and message
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	23 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	24 int slErrorMsg(QString title, QString msg)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	25 {
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	26 QMessageBox dlg;
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	27
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	28 dlg.setText(title);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	29 dlg.setInformativeText(msg);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	30 dlg.setTextFormat(Qt::RichText);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	31 dlg.setIcon(QMessageBox::Critical);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	32 dlg.setStandardButtons(QMessageBox::Ok);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	33 dlg.setDefaultButton(QMessageBox::Ok);
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	34
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	35 return dlg.exec();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	36 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	37
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	38
83 83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	39 //
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	40 // Convert QString to a double value, replacing comma
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	41 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	42 double slMoneyStrToValue(const QString &str)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	43 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	44 QString str2 = str;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	45 return str2.replace(",", ".").toDouble();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	46 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	47
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	48
83 83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	49 //
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	50 // Convert double value to formatted QString
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	51 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	52 QString slMoneyValueToStr(double val)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	53 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	54 return QStringLiteral("%1").arg(val, 1, 'f', 2);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	55 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	56
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	57
83 83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	58 //
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	59 // Trim and cleanup given QString (removing double whitespace etc.)
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	60 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	61 QString slCleanupStr(const QString &str)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	62 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	63 return str.simplified().trimmed();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	64 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	65
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	66
84 00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	67 //
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	68 // Manipulate given QDateTime value to get desired
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	69 // correct timestamp.
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	70 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	71 const QDateTime slDateTimeToLocal(const QDateTime &val)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	72 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	73 QDateTime tmp = val;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	74 tmp.setOffsetFromUtc(0);
84 00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	75 return tmp.toLocalTime();
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	76 }
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	77
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	78
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	79 //
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	80 // Return a string representation of given QDateTime
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	81 // converted to local time.
00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	82 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	83 const QString slDateTimeToStr(const QDateTime &val)
84 00db2c012481 Add dateTimeToLocal() and some comments. Matti Hamalainen <ccr@tnsp.org> parents: 83 diff changeset	84 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	85 return slDateTimeToLocal(val).toString(QStringLiteral("yyyy-MM-dd hh:mm"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	86 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	87
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	88
83 83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	89 //
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	90 // Check if an SQL error has occured (for given QSqlError) and
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	91 // report it to stdout if so. Return "false" if error has occured,
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	92 // true otherwise.
83044206479e Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 80 diff changeset	93 //
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	94 bool slCheckAndReportSQLError(const QString where, const QSqlError &err)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	95 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	96 if (err.isValid())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	97 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	98 printf("SQL Error in %s: %s\n",
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	99 where.toUtf8().constData(),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	100 err.text().toUtf8().constData());
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	101 return false;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	102 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	103 else
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	104 return true;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	105 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	106
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	107
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	108 void PersonInfo::dump()
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 printf("PersonInfo() #%lld '%s %s' (added=%s, updated=%s, balance %1.2f)\n#%s#\n",
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	111 id,
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	112 firstName.toUtf8().constData(),
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	113 lastName.toUtf8().constData(),
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	114 slDateTimeToStr(added).toUtf8().constData(),
7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	115 slDateTimeToStr(updated).toUtf8().constData(),
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	116 balance,
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	117 extraInfo.toUtf8().constData());
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	118 }
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	119
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	120
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	121 //
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	122 // Get PersonInfo record from SQL query object
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	123 //
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	124 void getPersonInfoRec(QSqlQuery &query, PersonInfo &info)
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	125 {
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	126 info.id = query.value(0).toInt();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	127 info.firstName = query.value(1).toString();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	128 info.lastName = query.value(2).toString();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	129 info.extraInfo = query.value(3).toString();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	130 info.added = query.value(4).toDateTime();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	131 info.updated = query.value(5).toDateTime();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	132 info.balance = query.value(6).toDouble();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	133 }
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	134
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	135
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	136 //
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	137 // Get PersonInfo record from SQL database for specified person ID #
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	138 //
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	139 bool getPersonInfo(qint64 id, PersonInfo &info)
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	140 {
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	141 QSqlQuery query;
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	142 query.prepare(
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	143 "SELECT id,first_name,last_name,extra_info,added,updated, "
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	144 "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance "
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	145 "FROM people WHERE id=?");
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	146
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	147 query.addBindValue(id);
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	148 query.exec();
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	149 if (!query.next())
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	150 return false;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	151
101 2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	152 getPersonInfoRec(query, info);
2477f46282c8 Split getPersonInfo() to getPersonInfoRec(). Matti Hamalainen <ccr@tnsp.org> parents: 99 diff changeset	153 query.finish();
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	154 return true;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	155 }
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	156
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	157
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	158 void setCommonStyleSheet(QWidget *widget)
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	159 {
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	160 // Clamp scale value
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	161 if (setScale < 0.5f)
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	162 setScale = 0.5f;
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	163 if (setScale > 3.0f)
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	164 setScale = 3.0f;
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	165
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	166 // Set the stylesheet
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	167 widget->setStyleSheet(
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	168 QStringLiteral(
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	169 "* { font-size: %1pt; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	170 "QPushButton { font-size: %2pt; padding: 0.25em; }"
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	171 "#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	172 "#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	173 "#button_PayFullDebt[enabled='true'] { background-color: #060; color: white; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	174
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	175 "#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	176 "#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	177 "#button_PayFullDebt[enabled='false'] { background-color: #131; color: black; }"
d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	178
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	179 "#label_PersonName { font-size: %5pt; font-weight: bold; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	180 "#label_BalanceValue { font-size: %4pt; font-weight: bold; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	181 "#label_EUR { font-size: %4pt; font-weight: bold; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	182 "#edit_Amount { font-size: %4pt; margin: 0.5em; padding: 0.5em; }"
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	183 ).
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	184 arg(12 * setScale).
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	185 arg(14 * setScale).
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	186 arg(16 * setScale).
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	187 arg(18 * setScale).
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	188 arg(20 * setScale)
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	189 );
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	190 }
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	191
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	192
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	193 int main(int argc, char *argv[])
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	194 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	195 QApplication sapp(argc, argv);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	196
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	197 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	198 // Initialize / open SQL database connection
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	199 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	200 QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
42 60ffa45b4014 Use #define APP_SQLITE_FILE for the application Sqlite3 database filename. Matti Hamalainen <ccr@tnsp.org> parents: 40 diff changeset	201 db.setDatabaseName(qApp->applicationDirPath() +
60ffa45b4014 Use #define APP_SQLITE_FILE for the application Sqlite3 database filename. Matti Hamalainen <ccr@tnsp.org> parents: 40 diff changeset	202 QDir::separator() + APP_SQLITE_FILE);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	203
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	204 if (!db.open())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	205 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	206 slErrorMsg(
9 1f442052d332 Oops, 10L. Matti Hamalainen <ccr@tnsp.org> parents: 8 diff changeset	207 QObject::tr("Tietokantaa ei voitu avata"),
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	208 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	209 arg(db.lastError().text())
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	210 );
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	211 return 1;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	212 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	213
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	214 QSqlQuery query;
44 8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	215 if (!db.tables().contains("people"))
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	216 {
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	217 query.exec(QStringLiteral(
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	218 "CREATE TABLE people (id INTEGER PRIMARY KEY, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	219 "first_name VARCHAR(128) NOT NULL, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	220 "last_name VARCHAR(128) NOT NULL, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	221 "extra_info VARCHAR(2048), "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	222 "added DATETIME NOT NULL, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	223 "updated DATETIME NOT NULL)"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	224
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	225 slCheckAndReportSQLError("CREATE TABLE people", query.lastError());
44 8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	226 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	227
44 8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	228 if (!db.tables().contains("transactions"))
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	229 {
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	230 query.exec(QStringLiteral(
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	231 "CREATE TABLE transactions ("
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	232 "id INTEGER PRIMARY KEY, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	233 "person INT NOT NULL, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	234 "value REAL, "
8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	235 "added DATETIME NOT NULL)"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	236
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	237 slCheckAndReportSQLError("CREATE TABLE transactions", query.lastError());
44 8fb2230fe860 Do not attempt to create the SQL tables if they already exist. Matti Hamalainen <ccr@tnsp.org> parents: 42 diff changeset	238 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	239
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	240 SyntilistaMainWindow swin;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	241 swin.show();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	242 return sapp.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	243 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	244
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	245
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	246 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	247 // Main application window code
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 SyntilistaMainWindow::SyntilistaMainWindow(QWidget *parent) :
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	250 QMainWindow(parent),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251 ui(new Ui::SyntilistaMainWindow)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252 {
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	253 // Setup UI
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254 ui->setupUi(this);
47 08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	255
08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	256 // Read config
08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	257 readSettings();
08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	258
08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	259 // Setup other UI things
39 2cc7c89ab649 Version information, etc. Matti Hamalainen <ccr@tnsp.org> parents: 35 diff changeset	260 setWindowIcon(QIcon(QPixmap(":/img/icon-64.png")));
64 73fd86778014 Version number display etc. changes. Matti Hamalainen <ccr@tnsp.org> parents: 63 diff changeset	261 setWindowTitle(tr("%1 versio %3").
39 2cc7c89ab649 Version information, etc. Matti Hamalainen <ccr@tnsp.org> parents: 35 diff changeset	262 arg(tr(APP_NAME)).
2cc7c89ab649 Version information, etc. Matti Hamalainen <ccr@tnsp.org> parents: 35 diff changeset	263 arg(tr(APP_VERSION)));
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	264
47 08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	265 QPixmap logoImage(":/img/logo.png");
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	266 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	267 ui->button_LogoImage->setAlignment(Qt::AlignCenter);
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	268
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	269 setCommonStyleSheet(this);
22 c23241a3e160 UI polishing. Matti Hamalainen <ccr@tnsp.org> parents: 19 diff changeset	270
68 597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	271 // Validator for amount input
597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	272 //ui->edit_Amount->setValidator(new QDoubleValidator(0, 1000, 2, this));
597bf29c5898 Use a better validator (regexp) for the amount input field. Matti Hamalainen <ccr@tnsp.org> parents: 65 diff changeset	273 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	274 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	275
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	276 // Setup person list filtering and sorting
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	277 peopleSortIndex = 1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	278 peopleSortOrder = Qt::AscendingOrder;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	279 peopleFilter = "";
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	280
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	281 model_People = new PersonSQLModel();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	282 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	283
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	284 ui->tableview_People->setModel(model_People);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	285 ui->tableview_People->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	286 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	287 ui->tableview_People->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	288 ui->tableview_People->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	289 ui->tableview_People->setSortingEnabled(true);
25 a7e746642599 Fix initial sorting. Matti Hamalainen <ccr@tnsp.org> parents: 24 diff changeset	290 ui->tableview_People->sortByColumn(peopleSortIndex, peopleSortOrder);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	291
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	292 connect(
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	293 ui->tableview_People->selectionModel(),
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	294 SIGNAL(currentChanged(const QModelIndex &, const QModelIndex &)),
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	295 this,
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	296 SLOT(selectedPersonChanged(const QModelIndex &, const QModelIndex &)));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	297
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	298 connect(
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	299 ui->tableview_People->horizontalHeader(),
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	300 SIGNAL(sortIndicatorChanged(int, Qt::SortOrder)),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	301 this,
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	302 SLOT(updateSortOrder(int, Qt::SortOrder)));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	303
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	304 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	305
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	306 model_Latest = new TransactionSQLModel();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	307 ui->tableview_Latest->setModel(model_Latest);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	308 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	309 ui->tableview_Latest->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	310 ui->tableview_Latest->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
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 setActivePerson(-1);
17 d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	313
d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	314 // Keyboard shortcuts
63 fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	315 ui->button_Quit->setShortcut(QKeySequence(Qt::Key_F10));
fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	316 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_Q), this, SLOT(on_button_Quit_clicked()));
fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	317
fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	318 ui->button_AddPerson->setShortcut(QKeySequence(Qt::Key_F5));
fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	319 ui->button_DeletePerson->setShortcut(QKeySequence(Qt::Key_F8));
fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	320 ui->button_EditPerson->setShortcut(QKeySequence(Qt::Key_F6));
fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	321 ui->button_ClearFilter->setShortcut(QKeySequence(Qt::Key_Escape));
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	322 ui->button_About->setShortcut(QKeySequence(Qt::Key_F1));
63 fc633e7c83a9 Improve keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 60 diff changeset	323
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	324 new QShortcut(QKeySequence(QKeySequence::ZoomIn), this, SLOT(changeUIZoomIn()));
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	325 new QShortcut(QKeySequence(QKeySequence::ZoomOut), this, SLOT(changeUIZoomOut()));
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	326 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	327 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	328 new QShortcut(QKeySequence(Qt::CTRL + Qt::KeypadModifier + Qt::Key_0), this, SLOT(changeUIZoomReset()));
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	329 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_0), this, SLOT(changeUIZoomReset()));
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	330
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	331 new QShortcut(QKeySequence(Qt::Key_PageUp), this, SLOT(selectRowPrev()));
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	332 new QShortcut(QKeySequence(Qt::Key_PageDown), this, SLOT(selectRowNext()));
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	333
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	334 new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_Return), this, SLOT(focusDebtEdit()));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	335 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	336
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	337
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	338 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	339 // Application main window destructor
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	340 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	341 SyntilistaMainWindow::~SyntilistaMainWindow()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	342 {
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	343 // Save current settings and free resources
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	344 saveSettings();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	345
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	346 delete ui;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	347 delete model_People;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	348 delete model_Latest;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	349 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	350
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	351
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	352 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	353 // Helper function for showing messages in the statusbar/line
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	354 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	355 void SyntilistaMainWindow::statusMsg(const QString &msg)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	356 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	357 ui->statusbar->showMessage(msg);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	358 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	359
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	360
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	361 void SyntilistaMainWindow::readSettings()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	362 {
39 2cc7c89ab649 Version information, etc. Matti Hamalainen <ccr@tnsp.org> parents: 35 diff changeset	363 QSettings settings(APP_VENDOR, APP_ID);
97 65ffedde7dec Comments. Matti Hamalainen <ccr@tnsp.org> parents: 95 diff changeset	364
65ffedde7dec Comments. Matti Hamalainen <ccr@tnsp.org> parents: 95 diff changeset	365 // Restore window size and position
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	366 move(settings.value("pos", QPoint(100, 100)).toPoint());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	367 resize(settings.value("size", QSize(1000, 600)).toSize());
97 65ffedde7dec Comments. Matti Hamalainen <ccr@tnsp.org> parents: 95 diff changeset	368
65ffedde7dec Comments. Matti Hamalainen <ccr@tnsp.org> parents: 95 diff changeset	369 // Other settings
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	370 setScale = settings.value("scale", 1.0f).toDouble();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	371 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	372
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	373
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	374 void SyntilistaMainWindow::saveSettings()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	375 {
39 2cc7c89ab649 Version information, etc. Matti Hamalainen <ccr@tnsp.org> parents: 35 diff changeset	376 QSettings settings(APP_VENDOR, APP_ID);
97 65ffedde7dec Comments. Matti Hamalainen <ccr@tnsp.org> parents: 95 diff changeset	377
65ffedde7dec Comments. Matti Hamalainen <ccr@tnsp.org> parents: 95 diff changeset	378 // Save window size and position
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	379 settings.setValue("pos", pos());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	380 settings.setValue("size", size());
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	381 settings.setValue("scale", setScale);
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	382 }
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	383
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	384
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	385 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	386 // Window scale / zoom changing
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	387 //
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	388 void SyntilistaMainWindow::changeUIZoomIn()
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	389 {
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	390 setScale += 0.1f;
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	391 setCommonStyleSheet(this);
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	392 }
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	393
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	394
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	395 void SyntilistaMainWindow::changeUIZoomOut()
34 87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	396 {
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	397 setScale -= 0.1f;
87f098892804 Make the UI scale with undocumented hotkeys. Matti Hamalainen <ccr@tnsp.org> parents: 32 diff changeset	398 setCommonStyleSheet(this);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	399 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	400
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	401
46 372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	402 void SyntilistaMainWindow::changeUIZoomReset()
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	403 {
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	404 setScale = 1.0f;
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	405 setCommonStyleSheet(this);
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	406 }
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	407
372c1be58996 Improve shortcuts functionality a bit. Matti Hamalainen <ccr@tnsp.org> parents: 44 diff changeset	408
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	409 //
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	410 // Slot for changed selection of person entry
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	411 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	412 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	413 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	414 (void) prev;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	415 int row = curr.row();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	416 if (row >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	417 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	418 const QAbstractItemModel *model = curr.model();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	419 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	420 focusDebtEdit();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	421 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	422 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	423 setActivePerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	424 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	425
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	426
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	427 void SyntilistaMainWindow::setActivePerson(qint64 id)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	428 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	429 currPerson.id = id;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	430
1 db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	431 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	432
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	433 if (id >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	434 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	435 if (!getPersonInfo(id, currPerson))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	436 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	437 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	438 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	439 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	440 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	441 ui->personGB->setEnabled(true);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	442 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	443
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	444 ui->label_BalanceValue->setText(slMoneyValueToStr(currPerson.balance));
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	445 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	446 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	447
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	448 QSqlQuery query;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	449 query.prepare("SELECT id,value,added FROM transactions WHERE person=? ORDER BY added DESC LIMIT 5");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	450 query.addBindValue(id);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	451 query.exec();
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	452 slCheckAndReportSQLError("SELECT transactions for tableview_Latest", query.lastError());
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	453
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	454 model_Latest->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	455
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	456 model_Latest->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	457 model_Latest->setHeaderData(1, Qt::Horizontal, tr("Summa"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	458 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	459
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	460 ui->tableview_Latest->setModel(model_Latest);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	461 ui->tableview_Latest->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	462 ui->tableview_Latest->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	463 ui->tableview_Latest->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	464
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	465 setCommonStyleSheet(this);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	466 return; // Ugly
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	467 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	468 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	469
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	470 // In case of id < 0 or errors ..
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	471 ui->personGB->setEnabled(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	472 ui->edit_Amount->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	473 ui->label_BalanceValue->setText("--");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	474 ui->label_BalanceValue->setStyleSheet(NULL);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	475 ui->label_PersonName->setText("???");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	476 ui->tableview_Latest->setModel(NULL);
40 d565867f2b0b UI visual improvements. Matti Hamalainen <ccr@tnsp.org> parents: 39 diff changeset	477 setCommonStyleSheet(this);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	478 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	479
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	480
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	481 //
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	482 // 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	483 //
98 3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	484 void SyntilistaMainWindow::updateSortOrder(int index, Qt::SortOrder order)
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	485 {
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	486 peopleSortIndex = index;
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	487 peopleSortOrder = order;
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	488 updatePersonList();
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	489 }
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	490
3baea5b17dc9 Add some comments. Matti Hamalainen <ccr@tnsp.org> parents: 97 diff changeset	491
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	492 void SyntilistaMainWindow::on_button_Quit_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	493 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	494 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	495 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	496
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	497
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	498 void SyntilistaMainWindow::on_button_About_clicked()
47 08c0d5116e82 More work. Matti Hamalainen <ccr@tnsp.org> parents: 46 diff changeset	499 {
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	500 new AboutWindow(this);
74 cc8fbf9a61b2 Add a help dialog. Matti Hamalainen <ccr@tnsp.org> parents: 71 diff changeset	501 }
cc8fbf9a61b2 Add a help dialog. Matti Hamalainen <ccr@tnsp.org> parents: 71 diff changeset	502
cc8fbf9a61b2 Add a help dialog. Matti Hamalainen <ccr@tnsp.org> parents: 71 diff changeset	503
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	504 void SyntilistaMainWindow::on_button_DeletePerson_clicked()
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	505 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	506 if (currPerson.id <= 0)
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	507 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	508 statusMsg(tr("Ei valittua henkilöä!"));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	509 return;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	510 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	511
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	512 PersonInfo info;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	513 if (!getPersonInfo(currPerson.id, info))
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	514 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	515 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	516 return;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	517 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	518
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	519 QMessageBox dlg;
71 2d12c12a7b89 More UI improvements. Matti Hamalainen <ccr@tnsp.org> parents: 68 diff changeset	520 setCommonStyleSheet(&dlg);
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	521 dlg.setText(tr("Varmistus"));
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	522 dlg.setInformativeText(
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	523 tr("<br>Haluatko varmasti poistaa henkilön:<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	524 "<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	525 "<b>'%1, %2'</b> <i>(ID #%3)</i>?<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	526 "<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	527 "Tämä poistaa sekä henkilön ja hänen koko tapahtumahistoriansa PYSYVÄSTI!<br>").
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	528 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	529
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	530 dlg.setTextFormat(Qt::RichText);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	531 dlg.setIcon(QMessageBox::Question);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	532 dlg.setStandardButtons(QMessageBox::Yes \| QMessageBox::No);
71 2d12c12a7b89 More UI improvements. Matti Hamalainen <ccr@tnsp.org> parents: 68 diff changeset	533 dlg.setButtonText(QMessageBox::Yes, tr("Kyllä"));
2d12c12a7b89 More UI improvements. Matti Hamalainen <ccr@tnsp.org> parents: 68 diff changeset	534 dlg.setButtonText(QMessageBox::No, tr("Ei / peruuta"));
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	535 dlg.setDefaultButton(QMessageBox::No);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	536
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	537 if (dlg.exec() == QMessageBox::Yes)
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	538 {
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	539 int rv = model_People->deletePerson(info.id);
14 8a6a90ce0e0f Fixes. Matti Hamalainen <ccr@tnsp.org> parents: 13 diff changeset	540 updatePersonList();
24 0e0948aec438 De-select active person when deleting. Matti Hamalainen <ccr@tnsp.org> parents: 23 diff changeset	541 setActivePerson(-1);
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	542 if (rv != 0)
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	543 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	544 slErrorMsg(tr("SQL-tietokantavirhe"),
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	545 tr("Henkilön tietoja poistettaessa tapahtui virhe #%1.").
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	546 arg(rv));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	547 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	548 else
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	549 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	550 statusMsg(tr("Henkilö '%1 %2' (ID #%3) poistettu.").
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	551 arg(info.firstName).arg(info.lastName).
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	552 arg(info.id));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	553 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	554 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	555 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	556
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	557
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	558 void SyntilistaMainWindow::on_button_AddPerson_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	559 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	560 EditPerson *person = new EditPerson(this);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	561 person->setPerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	562 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	563
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	564
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	565 void SyntilistaMainWindow::on_button_EditPerson_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	566 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	567 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	568 {
db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	569 EditPerson *person = new EditPerson(this);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	570 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	571 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	572 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	573
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	574
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	575 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	576 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	577 int row = curr.row();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	578 if (row >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	579 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	580 const QAbstractItemModel *model = curr.model();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	581 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	582
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	583 EditPerson *person = new EditPerson(this);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	584 person->setPerson(currPerson.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	585 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	586 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	587 setActivePerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	588 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	589
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	590
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	591 void SyntilistaMainWindow::on_button_ClearFilter_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	592 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	593 ui->edit_PersonFilter->clear();
65 f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	594 ui->edit_PersonFilter->setFocus(Qt::ShortcutFocusReason);
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	595 }
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	596
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	597
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	598 void SyntilistaMainWindow::focusDebtEdit()
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	599 {
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	600 if (currPerson.id >= 0)
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	601 ui->edit_Amount->setFocus(Qt::ShortcutFocusReason);
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	602 }
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	603
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	604
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	605 void SyntilistaMainWindow::selectRowPrev()
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	606 {
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	607 QItemSelectionModel *sel = ui->tableview_People->selectionModel();
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	608 int row = sel->currentIndex().row() - 1;
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	609 if (row < 0)
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	610 row = 0;
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	611
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	612 sel->setCurrentIndex(model_People->index(row, 0),
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	613 QItemSelectionModel::ClearAndSelect\|QItemSelectionModel::Rows);
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	614 }
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	615
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	616
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	617 void SyntilistaMainWindow::selectRowNext()
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	618 {
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	619 QItemSelectionModel *sel = ui->tableview_People->selectionModel();
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	620 int row = sel->currentIndex().row() + 1;
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	621 if (row >= model_People->rowCount())
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	622 row = model_People->rowCount() - 1;
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	623
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	624 sel->setCurrentIndex(model_People->index(row, 0),
f9a1d33ed4a8 Add more keyboard controls. Matti Hamalainen <ccr@tnsp.org> parents: 64 diff changeset	625 QItemSelectionModel::ClearAndSelect\|QItemSelectionModel::Rows);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	626 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	627
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	628
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	629 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	630 // Update visible person list/query based on the current
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	631 // filtering and sorting settings.
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	632 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	633 void SyntilistaMainWindow::updatePersonList()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	634 {
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	635 static QString queryBase =
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	636 "SELECT id,last_name,first_name,"
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	637 "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	638 "updated FROM people";
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	639
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	640 QSqlQuery query;
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	641 QString queryOrderDir, queryOrderBy;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	642
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	643 // Sort order
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	644 if (peopleSortOrder == Qt::AscendingOrder)
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	645 queryOrderDir = QStringLiteral("ASC");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	646 else
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	647 queryOrderDir = QStringLiteral("DESC");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	648
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	649 // Sort by which column
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	650 switch (peopleSortIndex)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	651 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	652 case 1:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	653 case 2:
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	654 queryOrderBy = QStringLiteral(" ORDER BY last_name ") + queryOrderDir + QStringLiteral(",first_name ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	655 break;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	656
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	657 case 3:
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	658 queryOrderBy = QStringLiteral(" ORDER BY balance ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	659 break;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	660
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	661 case 4:
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	662 queryOrderBy = QStringLiteral(" ORDER BY updated ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	663 break;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	664
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	665 default:
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	666 queryOrderBy = "";
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	667 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	668
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	669 // Are we filtering or not?
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	670 if (peopleFilter != "")
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	671 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	672 // Filter by name(s)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	673 QString tmp = "%"+ peopleFilter +"%";
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	674 query.prepare(queryBase +" 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	675
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	676 query.addBindValue(tmp);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	677 query.addBindValue(tmp);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	678 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	679 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	680 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	681 // No filter
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	682 query.prepare(queryBase + queryOrderBy);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	683 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	684
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	685 // Execute the query and update model
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	686 slCheckAndReportSQLError("updatePersonList() before exec", query.lastError());
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	687 query.exec();
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	688 slCheckAndReportSQLError("updatePersonList() after exec", query.lastError());
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 model_People->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	691
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	692 model_People->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	693 model_People->setHeaderData(1, Qt::Horizontal, tr("Sukunimi"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	694 model_People->setHeaderData(2, Qt::Horizontal, tr("Etunimi"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	695 model_People->setHeaderData(3, Qt::Horizontal, tr("Tase"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	696 model_People->setHeaderData(4, Qt::Horizontal, tr("Muutettu"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	697 }
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
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	700 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	701 // Update the list of people when filter parameter changes
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	702 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	703 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	704 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	705 peopleFilter = slCleanupStr(str);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	706 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	707 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	708
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	709
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	710 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	711 // Add one transaction to given person id
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	712 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	713 int SyntilistaMainWindow::addTransaction(qint64 id, double value, PersonInfo &info)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	714 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	715 if (!getPersonInfo(id, info))
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	716 return -1;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	717
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	718 QSqlDatabase::database().transaction();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	719
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	720 QSqlQuery query;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	721 query.prepare("INSERT INTO transactions (person,value,added) VALUES (?,?,?)");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	722 query.addBindValue(id);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	723 query.addBindValue(value);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	724 query.addBindValue(QDateTime::currentDateTimeUtc());
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	725 query.exec();
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	726 if (!slCheckAndReportSQLError("addTransaction()", query.lastError()))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	727 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	728 QSqlDatabase::database().rollback();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	729 return -2;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	730 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	731
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	732 query.prepare("UPDATE people SET updated=? WHERE id=?");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	733 query.addBindValue(QDateTime::currentDateTimeUtc());
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	734 query.addBindValue(id);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	735 query.exec();
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	736 if (!slCheckAndReportSQLError("addTransaction update timestamp", query.lastError()))
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	737 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	738 QSqlDatabase::database().rollback();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	739 return -3;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	740 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	741
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	742 QSqlDatabase::database().commit();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	743
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	744 return 0;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	745 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	746
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	747
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	748 int SyntilistaMainWindow::addTransactionGUI(qint64 id, bool debt, double value)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	749 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	750 PersonInfo info;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	751
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	752 // Check if person is selected
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	753 if (id <= 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	754 return -1;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	755
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	756 // Check value
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	757 if (value == 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	758 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	759 QString tmp = (debt ? "lisätty" : "vähennetty");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	760 statusMsg("Velkaa ei "+ tmp +" koska summaa ei määritetty.");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	761 return 1;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	762 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	763
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	764 // Perform transaction insert
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	765 int ret = addTransaction(id, debt ? -value : value, info);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	766 if (ret == 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	767 {
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	768 // 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	769 ui->edit_Amount->clear();
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	770 if (info.id == currPerson.id)
07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	771 setActivePerson(info.id);
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	772
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	773 model_People->updateModel();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	774
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	775 QString str;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	776 if (debt)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	777 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	778 str = 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	779 arg(slMoneyValueToStr(value)).
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	780 arg(info.firstName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	781 arg(info.lastName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	782 arg(info.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	783 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	784 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	785 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	786 str = 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	787 arg(slMoneyValueToStr(value)).
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	788 arg(info.firstName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	789 arg(info.lastName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	790 arg(info.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	791 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	792 statusMsg(str);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	793 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	794 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	795 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	796 slErrorMsg(
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	797 tr("SQL-tietokantavirhe"),
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	798 tr("Tietokantaan tapahtumaa lisättäessa tapahtui virhe #%1.").
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	799 arg(ret));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	800 }
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	801
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	802 return ret;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	803 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	804
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	805
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	806 void SyntilistaMainWindow::on_button_AddDebt_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	807 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	808 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	809 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	810
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	811
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	812 void SyntilistaMainWindow::on_button_PayDebt_clicked()
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	813 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	814 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	815 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	816
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	817
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	818 void SyntilistaMainWindow::on_button_PayFullDebt_clicked()
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	819 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	820 if (currPerson.balance < 0)
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	821 addTransactionGUI(currPerson.id, false, -currPerson.balance);
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	822 else
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	823 {
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	824 statusMsg(
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	825 tr("Valitulla henkilöllä '%1, %2' ei ole velkaa.").
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	826 arg(currPerson.lastName).
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	827 arg(currPerson.firstName));
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	828 }
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	829 }
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	830
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	831
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	832 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	833 // Edit person dialog
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 EditPerson::EditPerson(QWidget *parent) :
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	836 QDialog(parent),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	837 ui(new Ui::EditPerson)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	838 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	839 ui->setupUi(this);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	840
32 7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	841 setCommonStyleSheet(this);
7fd15537b12d Commonize stylesheet code. Matti Hamalainen <ccr@tnsp.org> parents: 31 diff changeset	842
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	843 setModal(true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	844 setAttribute(Qt::WA_DeleteOnClose);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	845 show();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	846 activateWindow();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	847 raise();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	848 setFocus();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	849
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	850 model_Transactions = new TransactionSQLModel();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	851 ui->tableview_Transactions->setModel(model_Transactions);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	852 ui->tableview_Transactions->setItemDelegate(new QSqlRelationalDelegate(ui->tableview_Transactions));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	853 ui->tableview_Transactions->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	854 ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	855
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	856 validateForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	857 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	858
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	859
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	860 EditPerson::~EditPerson()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	861 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	862 delete ui;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	863 delete model_Transactions;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	864 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	865
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	866
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	867 void EditPerson::statusMsg(const QString &msg)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	868 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	869 dynamic_cast<SyntilistaMainWindow *>(parent())->statusMsg(msg);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	870 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	871
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	872
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	873 bool EditPerson::validateForm()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	874 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	875 selPerson.firstName = slCleanupStr(ui->edit_FirstName->text());
7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	876 selPerson.lastName = slCleanupStr(ui->edit_LastName->text());
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	877 selPerson.extraInfo = ui->textedit_ExtraInfo->document()->toPlainText();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	878
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	879 ui->edit_FirstName->setStyleSheet(selPerson.firstName == "" ? "background-color: red;" : NULL);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	880 ui->edit_LastName->setStyleSheet(selPerson.lastName == "" ? "background-color: red;" : NULL);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	881
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	882 return selPerson.firstName != "" && selPerson.lastName != "";
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	883 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	884
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	885
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	886 void EditPerson::on_button_Cancel_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	887 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	888 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	889 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	890
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	891
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	892 void EditPerson::on_button_OK_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	893 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	894 if (!validateForm())
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	895 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	896 slErrorMsg(
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	897 tr("Virhe!"),
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	898 tr("Vaaditut kentät (etunimi, sukunimi) eivät ole täytetty."));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	899
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	900 return;
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	901 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	902
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	903 if (selPerson.id >= 0)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	904 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	905 QSqlQuery person;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	906 person.prepare("SELECT * FROM people WHERE id <> ? AND first_name=? AND last_name=?");
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	907 person.addBindValue(selPerson.id);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	908 person.addBindValue(selPerson.firstName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	909 person.addBindValue(selPerson.lastName);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	910 person.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	911
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	912 slCheckAndReportSQLError("SELECT check for existing person by same name (UPDATE)", person.lastError());
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	913
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	914 if (person.next())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	915 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	916 slErrorMsg(
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	917 tr("Virhe!"),
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	918 tr("Ei pysty! Samalla nimellä '%1 %2' on olemassa jo henkilö!").
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	919 arg(selPerson.firstName).arg(selPerson.lastName));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	920 return;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	921 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	922
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	923 dynamic_cast<SyntilistaMainWindow *>(parent())->model_People->updatePerson(selPerson);
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	924 dynamic_cast<SyntilistaMainWindow *>(parent())->setActivePerson(selPerson.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	925
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	926 statusMsg(tr("Päivitettiin henkilö '%1 %2' (#%3).").
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	927 arg(selPerson.firstName).arg(selPerson.lastName).arg(selPerson.id));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	928 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	929 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	930 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	931 QSqlQuery person;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	932 person.prepare("SELECT * FROM people WHERE first_name=? AND last_name=?");
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	933 person.addBindValue(selPerson.firstName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	934 person.addBindValue(selPerson.lastName);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	935 person.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	936
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	937 slCheckAndReportSQLError("SELECT check for existing person by same name (ADD)", person.lastError());
0 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 if (person.next())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	940 {
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	941 slErrorMsg(
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	942 tr("Virhe!"),
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	943 tr("Ei pysty! Samalla nimellä '%1 %2' on olemassa jo henkilö!").
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	944 arg(selPerson.firstName).arg(selPerson.lastName));
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	945
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	946 return;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	947 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	948
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	949 dynamic_cast<SyntilistaMainWindow *>(parent())->model_People->addPerson(selPerson);
14 8a6a90ce0e0f Fixes. Matti Hamalainen <ccr@tnsp.org> parents: 13 diff changeset	950 dynamic_cast<SyntilistaMainWindow *>(parent())->updatePersonList();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	951
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	952 statusMsg(tr("Lisättiin uusi henkilö '%1 %2'.").
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	953 arg(selPerson.firstName).arg(selPerson.lastName));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	954 }
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 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	957 }
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	960 void EditPerson::on_edit_FirstName_textChanged(const QString &arg1)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	961 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	962 (void) arg1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	963 validateForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	964 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	965
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	966
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	967 void EditPerson::on_edit_LastName_textChanged(const QString &arg1)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	968 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	969 (void) arg1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	970 validateForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	971 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	972
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	973
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	974 void EditPerson::clearForm()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	975 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	976 ui->edit_FirstName->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	977 ui->edit_LastName->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	978 ui->textedit_ExtraInfo->document()->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	979 ui->edit_FirstName->setFocus();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	980 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	981
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	982
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	983 void EditPerson::setPerson(qint64 id)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	984 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	985 selPerson.id = id;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	986
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	987 if (id >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	988 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	989 PersonInfo pinfo;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	990 if (!getPersonInfo(id, pinfo))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	991 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	992 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	993 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	994 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	995 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	996 ui->edit_FirstName->setText(pinfo.firstName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	997 ui->edit_LastName->setText(pinfo.lastName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	998 ui->textedit_ExtraInfo->document()->setPlainText(pinfo.extraInfo);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	999
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1000 QSqlQuery query;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1001 query.prepare("SELECT id,value,added FROM transactions WHERE person=? ORDER BY added DESC");
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1002 query.addBindValue(pinfo.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1003 query.exec();
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1004 slCheckAndReportSQLError("SELECT transactions for tableview_Transactions", query.lastError());
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1005
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1006 model_Transactions->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1007
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1008 model_Transactions->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1009 model_Transactions->setHeaderData(1, Qt::Horizontal, tr("Summa"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1010 model_Transactions->setHeaderData(2, Qt::Horizontal, tr("Aika"));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1011
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1012 ui->tableview_Transactions->setModel(model_Transactions);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1013 ui->tableview_Transactions->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1014
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1015 return; // Ugly
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1016 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1017 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1018
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1019 // In case of id < 0 or errors ..
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1020 clearForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1021 ui->tableview_Transactions->setModel(NULL);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1022 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1023
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1024
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1025 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1026 // Custom SQL models
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1027 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1028 PersonSQLModel::PersonSQLModel(QObject *parent) : QSqlQueryModel(parent)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1029 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1030 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1031
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1032
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1033 QVariant PersonSQLModel::data(const QModelIndex &index, int role) const
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1034 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1035 QVariant value = QSqlQueryModel::data(index, role);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1036
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1037 if (value.isValid() && role == Qt::DisplayRole)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1038 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1039 switch (index.column())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1040 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1041 case 3:
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1042 return slMoneyValueToStr(value.toDouble());
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1043
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1044 case 4:
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1045 return slDateTimeToStr(value.toDateTime());
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1046 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1047 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1048
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1049 if (index.column() == 3 && role == Qt::ForegroundRole)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1050 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1051 double val = QSqlQueryModel::data(index, Qt::DisplayRole).toDouble();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1052 if (val < 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1053 return QVariant::fromValue(QColor(Qt::red));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1054 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1055 return QVariant::fromValue(QColor(Qt::green));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1056 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1057
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1058 return value;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1059 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1060
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1061
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1062 int PersonSQLModel::updatePerson(const PersonInfo &info)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1063 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1064 QSqlQuery np;
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1065
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1066 np.prepare("UPDATE people SET first_name=?,last_name=?,extra_info=?,updated=? WHERE id=?");
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1067 np.addBindValue(info.firstName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1068 np.addBindValue(info.lastName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1069 np.addBindValue(info.extraInfo);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1070 np.addBindValue(QDateTime::currentDateTimeUtc());
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1071 np.addBindValue(info.id);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	1072 np.exec();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1073
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1074 if (!slCheckAndReportSQLError("PersonSQLModel::updatePerson()", np.lastError()))
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1075 return -1;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1076
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1077 QSqlDatabase::database().commit();
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1078
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1079 updateModel();
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1080 return 0;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1081 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1082
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1083
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1084 int PersonSQLModel::addPerson(const PersonInfo &info)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1085 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1086 // beginInsertRows(QModelIndex(), rowCount(), rowCount());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1087
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1088 QSqlQuery np;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1089 np.prepare("INSERT INTO people (first_name,last_name,extra_info,added,updated) VALUES (?,?,?,?,?)");
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1090 np.addBindValue(info.firstName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1091 np.addBindValue(info.lastName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	1092 np.addBindValue(info.extraInfo);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1093 np.addBindValue(QDateTime::currentDateTimeUtc());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1094 np.addBindValue(QDateTime::currentDateTimeUtc());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1095 np.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1096
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1097 if (!slCheckAndReportSQLError("PersonSQLModel::addPerson()", np.lastError()))
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1098 return -1;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1099
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1100 QSqlDatabase::database().commit();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1101
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1102 // endInsertRows();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1103 updateModel();
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1104 return 0;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1105 }
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1106
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1107
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1108 int PersonSQLModel::deletePerson(qint64 id)
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1109 {
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1110 QSqlDatabase::database().transaction();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1111 QSqlQuery del;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1112
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1113 del.prepare("DELETE FROM people WHERE id=?");
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1114 del.addBindValue(id);
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1115 del.exec();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1116
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1117 if (!slCheckAndReportSQLError("delete user", del.lastError()))
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1118 {
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1119 QSqlDatabase::database().rollback();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1120 return -1;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1121 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1122
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1123 del.prepare("DELETE FROM transactions WHERE person=?");
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1124 del.addBindValue(id);
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1125 del.exec();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1126
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1127 if (!slCheckAndReportSQLError("delete user transactions", del.lastError()))
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1128 {
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1129 QSqlDatabase::database().rollback();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1130 return -2;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1131 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1132
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1133 QSqlDatabase::database().commit();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1134 updateModel();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	1135 return 0;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1136 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1137
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1138
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1139 void PersonSQLModel::updateModel()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1140 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1141 query().exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1142 emit dataChanged(index(0, 0), index(rowCount(), columnCount()));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1143 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1144
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1145
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1146 TransactionSQLModel::TransactionSQLModel(QObject *parent) : QSqlQueryModel(parent)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1147 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1148 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1149
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1150
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1151 QVariant TransactionSQLModel::data(const QModelIndex &index, int role) const
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1152 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1153 QVariant value = QSqlQueryModel::data(index, role);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1154
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1155 if (value.isValid() && role == Qt::DisplayRole)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1156 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1157 switch (index.column())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1158 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1159 case 1:
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1160 return slMoneyValueToStr(value.toDouble());
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	1161
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1162 case 2:
99 7b8755801111 Rename some utility functions. Matti Hamalainen <ccr@tnsp.org> parents: 98 diff changeset	1163 return slDateTimeToStr(value.toDateTime());
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1164 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1165 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1166
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1167 if (index.column() == 1 && role == Qt::ForegroundRole)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1168 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1169 double val = QSqlQueryModel::data(index, Qt::DisplayRole).toDouble();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1170 if (val < 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1171 return QVariant::fromValue(QColor(Qt::red));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1172 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1173 return QVariant::fromValue(QColor(Qt::green));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1174 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1175
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1176 return value;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1177 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1178
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1179
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1180 void TransactionSQLModel::updateModel()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1181 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1182 query().exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1183 emit dataChanged(QModelIndex(), QModelIndex());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	1184 }
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1185
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1186
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1187 //
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1188 // About window
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1189 //
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1190 AboutWindow::AboutWindow(QWidget *parent) :
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1191 QDialog(parent),
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1192 ui(new Ui::AboutWindow)
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1193 {
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1194 ui->setupUi(this);
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1195
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1196 ui->label_Logo->setPixmap(QPixmap(":/img/icon-64.png"));
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1197 ui->label_Logo->setAlignment(Qt::AlignCenter);
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1198
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1199 ui->label_About->setWordWrap(true);
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1200 ui->label_About->setTextFormat(Qt::RichText);
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1201 ui->label_About->setText(tr(
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1202 "<h1>%1 v%2</h1>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1203 "<p>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1204 "<b>Ohjelmoinut ja kehittänyt Matti Hämäläinen <ccr@tnsp.org><br>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1205 "(C) Copyright 2017 Tecnic Software productions (TNSP)</b>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1206 "</p>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1207 "<p>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1208 "Kehitetty Raahen kaupungin Hanketoiminta ja Kehittäminen -yksikön "
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1209 "alaisuudessa Café Kampuksen käyttöön."
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1210 "</p>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1211 "<p>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1212 "Ohjelma ja sen lähdekoodi ovat uudemman BSD-tyylisen lisenssin alaisia. "
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1213 "Lue ohjelman mukana tullut tiedosto \"COPYING\" (tai \"COPYING.txt\") "
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1214 "nähdäksesi täydelliset lisenssiehdot."
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1215 "</p>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1216 ).
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1217 arg(tr(APP_NAME)).
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1218 arg(APP_VERSION)
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1219 );
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1220
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1221 ui->label_ShortCuts->setText(tr(
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1222 "<h1>Pikanäppäimet</h1>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1223 "<table>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1224 "<tr><td><b>F1</b></td><td>Tämä tietoikkuna</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1225 "<tr><td><b>CTRL + Q</b></td><td>Ohjelman lopetus</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1226 "<tr><td><b>CTRL + Page Up</b></td><td>Suurenna ohjelman tekstejä/käyttöliittymää</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1227 "<tr><td><b>CTRL + Page Down</b></td><td>Pienennä ohjelman tekstejä/käyttöliittymää</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1228 "<tr></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1229 "<tr><td><b>Esc</b></td><td>Tyhjennä 'Etsi / suodata' kenttä ja siirry siihen</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1230 "<tr><td><b>CTRL + Enter</b></td><td>Siirry summan syöttökenttään</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1231 "<tr><td><b>Page Up</b></td><td>Siirry ylös henkilölistassa</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1232 "<tr><td><b>Page Down</b></td><td>Siirry alas henkilölistassa</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1233 "<tr></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1234 "<tr><td><b>F5</b></td><td>Lisää uusi henkilö</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1235 "<tr><td><b>F6</b></td><td>Muokkaa henkilöä</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1236 "<tr><td><b>F8</b></td><td>Poista henkilö</td></tr>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1237 "</table>"
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1238 ));
95 fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1239
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1240 // setCommonStyleSheet(this);
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1241 setModal(true);
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1242 setAttribute(Qt::WA_DeleteOnClose);
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1243 show();
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1244 activateWindow();
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1245 raise();
fb5227b415e6 Cosmetics. Matti Hamalainen <ccr@tnsp.org> parents: 90 diff changeset	1246 setFocus();
90 efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1247 }
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1248
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1249
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1250 AboutWindow::~AboutWindow()
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1251 {
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1252 delete ui;
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1253 }
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1254
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1255
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1256 void AboutWindow::on_button_Close_clicked()
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1257 {
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1258 close();
efab68769c75 Implement new separate About dialog/help window. Matti Hamalainen <ccr@tnsp.org> parents: 89 diff changeset	1259 }

Mercurial > hg > syntilista

annotate src/main.cpp @ 101:2477f46282c8