syntilista: main.cpp annotate

annotate main.cpp @ 71:2d12c12a7b89

More UI improvements.

author	Matti Hamalainen <ccr@tnsp.org>
date	Mon, 10 Apr 2017 02:57:22 +0300
parents	597bf29c5898
children	cc8fbf9a61b2

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

Mercurial > hg > syntilista

annotate main.cpp @ 71:2d12c12a7b89