syntilista: main.cpp annotate

annotate main.cpp @ 24:0e0948aec438

De-select active person when deleting.

author	Matti Hamalainen <ccr@tnsp.org>
date	Mon, 03 Apr 2017 12:46:21 +0300
parents	6e7ab784f7a4
children	a7e746642599

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 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	6 #include <QApplication>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	7 #include <QMessageBox>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	8 #include <QSettings>
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	9 #include "main.h"
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	10 #include "ui_mainwindow.h"
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	11 #include "ui_editperson.h"
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	12
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	13
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	14 int errorMsg(QString title, QString msg)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	15 {
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	16 QMessageBox dlg;
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	17
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	18 dlg.setText(title);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	19 dlg.setInformativeText(msg);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	20 dlg.setTextFormat(Qt::RichText);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	21 dlg.setIcon(QMessageBox::Critical);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	22 dlg.setStandardButtons(QMessageBox::Ok);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	23 dlg.setDefaultButton(QMessageBox::Ok);
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	24
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	25 return dlg.exec();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	26 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	27
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	28
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	29 double moneyStrToValue(const QString &str)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	30 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	31 QString str2 = str;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	32 return str2.replace(",", ".").toDouble();
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
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 moneyValueToStr(double val)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	37 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	38 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	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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	42 QString cleanupStr(const QString &str)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	43 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	44 return str.simplified().trimmed();
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	48 const QString dateTimeToStr(const QDateTime &val)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	49 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	50 QDateTime tmp = val;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	51 tmp.setOffsetFromUtc(0);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	52 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	53 }
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	56 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	57 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	58 if (err.isValid())
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 printf("SQL Error in %s: %s\n",
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	61 where.toUtf8().constData(),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	62 err.text().toUtf8().constData());
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	63 return false;
0 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 else
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	66 return true;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	67 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	68
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	69
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	70 void PersonInfo::dump()
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	71 {
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	72 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	73 id,
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	74 firstName.toUtf8().constData(),
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	75 lastName.toUtf8().constData(),
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	76 dateTimeToStr(added).toUtf8().constData(),
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	77 dateTimeToStr(updated).toUtf8().constData(),
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	78 balance,
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	79 extraInfo.toUtf8().constData());
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	80 }
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	81
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	82
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	83 //
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	84 //
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 bool getPersonInfo(qint64 id, PersonInfo &info)
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 QSqlQuery person;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	89 person.prepare(
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	90 "SELECT id,first_name,last_name,extra_info,added,updated, "
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	91 "(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	92 "FROM people WHERE id=?");
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	93
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	94 person.addBindValue(id);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	95 person.exec();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	96 if (!person.next())
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	97 return false;
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 info.id = person.value(0).toInt();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	100 info.firstName = person.value(1).toString();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	101 info.lastName = person.value(2).toString();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	102 info.extraInfo = person.value(3).toString();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	103 info.added = person.value(4).toDateTime();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	104 info.updated = person.value(5).toDateTime();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	105 info.balance = person.value(6).toDouble();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	106
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	107 person.finish();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	108
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	109 return true;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	110 }
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
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	113 int main(int argc, char *argv[])
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	114 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	115 QApplication sapp(argc, argv);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	116
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	117 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	118 // Initialize / open SQL database connection
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	119 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	120 QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	121 db.setDatabaseName(qApp->applicationDirPath() + QDir::separator() + "syntilista.sqlite3");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	122
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	123 if (!db.open())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	124 {
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	125 errorMsg(
9 1f442052d332 Oops, 10L. Matti Hamalainen <ccr@tnsp.org> parents: 8 diff changeset	126 QObject::tr("Tietokantaa ei voitu avata"),
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	127 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	128 arg(db.lastError().text())
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	129 );
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	130 return 1;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	131 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	132
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	133 QSqlQuery query;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	134 query.exec(
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	135 "CREATE TABLE people (id INTEGER PRIMARY KEY, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	136 "first_name VARCHAR(128) NOT NULL, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	137 "last_name VARCHAR(128) NOT NULL, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	138 "extra_info VARCHAR(2048), "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	139 "added DATETIME NOT NULL, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	140 "updated DATETIME NOT NULL)");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	141
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	142 checkAndReportSQLError("CREATE TABLE people", query.lastError());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	143
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	144 query.exec(
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	145 "CREATE TABLE transactions ("
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	146 "id INTEGER PRIMARY KEY, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	147 "person INT NOT NULL, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	148 "value REAL, "
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	149 "added DATETIME NOT NULL)");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	150
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	151 checkAndReportSQLError("CREATE TABLE transactions", query.lastError());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	152
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	153 SyntilistaMainWindow swin;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	154 swin.show();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	155 return sapp.exec();
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
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 // Main application window code
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	161 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	162 SyntilistaMainWindow::SyntilistaMainWindow(QWidget *parent) :
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	163 QMainWindow(parent),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	164 ui(new Ui::SyntilistaMainWindow)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	165 {
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	166 // Setup UI
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	167 ui->setupUi(this);
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	168
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	169 // Read config
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	170 readSettings();
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	171
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	172 ui->edit_Amount->setValidator(new QDoubleValidator(0, 1000, 2, this));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	173
22 c23241a3e160 UI polishing. Matti Hamalainen <ccr@tnsp.org> parents: 19 diff changeset	174 ui->button_AddDebt->setStyleSheet("background-color: #900; color: black;");
c23241a3e160 UI polishing. Matti Hamalainen <ccr@tnsp.org> parents: 19 diff changeset	175 ui->button_PayDebt->setStyleSheet("background-color: #090; color: black;");
c23241a3e160 UI polishing. Matti Hamalainen <ccr@tnsp.org> parents: 19 diff changeset	176 ui->button_PayFullDebt->setStyleSheet("background-color: #060; color: black;");
c23241a3e160 UI polishing. Matti Hamalainen <ccr@tnsp.org> parents: 19 diff changeset	177
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	178 // Setup person list filtering and sorting
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	179 peopleSortIndex = 1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	180 peopleSortOrder = Qt::AscendingOrder;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	181 peopleFilter = "";
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	182
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	183 model_People = new PersonSQLModel();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	184 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	185
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	186 ui->tableview_People->setModel(model_People);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	187 ui->tableview_People->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	188 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	189 ui->tableview_People->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	190 ui->tableview_People->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	191 ui->tableview_People->setSortingEnabled(true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	192
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	193 connect(
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	194 ui->tableview_People->selectionModel(),
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	195 SIGNAL(currentChanged(const QModelIndex &, const QModelIndex &)),
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	196 this,
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	197 SLOT(selectedPersonChanged(const QModelIndex &, const QModelIndex &)));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	198
10 0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	199 connect(
0b291bd77de5 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 9 diff changeset	200 ui->tableview_People->horizontalHeader(),
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	201 SIGNAL(sortIndicatorChanged(int, Qt::SortOrder)),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	202 this,
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	203 SLOT(updateSortOrder(int, Qt::SortOrder)));
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 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	206
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	207 model_Latest = new TransactionSQLModel();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	208 ui->tableview_Latest->setModel(model_Latest);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	209 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	210 ui->tableview_Latest->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	211 ui->tableview_Latest->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	212
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	213 setActivePerson(-1);
17 d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	214
d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	215 // Keyboard shortcuts
d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	216 sc_quit = new QShortcut(QKeySequence(Qt::CTRL + Qt::Key_Q), this, SLOT(close()));
d40345d63733 Implement some keyboard shortcuts. Matti Hamalainen <ccr@tnsp.org> parents: 16 diff changeset	217 sc_esc = new QShortcut(QKeySequence(Qt::Key_Escape), this, SLOT(on_button_ClearFilter_clicked()));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	218 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	219
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	220
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	221 SyntilistaMainWindow::~SyntilistaMainWindow()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	222 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	223 printf("QUITTAUS\n");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	224
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	225 saveSettings();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	226
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	227 delete ui;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	228 delete model_People;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	229 delete model_Latest;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	230 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	231
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	232
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	233 void SyntilistaMainWindow::statusMsg(const QString &msg)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	234 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	235 ui->statusbar->showMessage(msg);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	236 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	237
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	238
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	239 void SyntilistaMainWindow::readSettings()
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 QSettings settings(APP_VENDOR, APP_NAME);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	242 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	243 resize(settings.value("size", QSize(1000, 600)).toSize());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	244 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	245
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	246
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	247 void SyntilistaMainWindow::saveSettings()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	248 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	249 QSettings settings(APP_VENDOR, APP_NAME);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	250 settings.setValue("pos", pos());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	251 settings.setValue("size", size());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	252 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	253
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	254
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	255 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	256 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	257 (void) prev;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	258 int row = curr.row();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	259 if (row >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	260 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	261 const QAbstractItemModel *model = curr.model();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	262 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	263 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	264 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	265 setActivePerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	266 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	267
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	268
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	269 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	270 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	271 peopleSortIndex = index;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	272 peopleSortOrder = order;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	273 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	274 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	275
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	276
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	277 void SyntilistaMainWindow::setActivePerson(qint64 id)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	278 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	279 currPerson.id = id;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	280
1 db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	281 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	282
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	283 if (id >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	284 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	285 if (!getPersonInfo(id, currPerson))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	286 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	287 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	288 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	289 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	290 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	291 ui->personGB->setEnabled(true);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	292 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	293
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	294 ui->label_BalanceValue->setText(moneyValueToStr(currPerson.balance));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	295 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	296 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	297
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	298 QSqlQuery query;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	299 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	300 query.addBindValue(id);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	301 query.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	302 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	303
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	304 model_Latest->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	305
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	306 model_Latest->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	307 model_Latest->setHeaderData(1, Qt::Horizontal, tr("Summa"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	308 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	309
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	310 ui->tableview_Latest->setModel(model_Latest);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	311 ui->tableview_Latest->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	312 ui->tableview_Latest->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	313 ui->tableview_Latest->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	314
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	315 return; // Ugly
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	316 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	317 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	318
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	319 // In case of id < 0 or errors ..
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	320 ui->personGB->setEnabled(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	321 ui->edit_Amount->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	322 ui->label_BalanceValue->setText("--");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	323 ui->label_BalanceValue->setStyleSheet(NULL);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	324 ui->label_PersonName->setText("???");
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	325 ui->tableview_Latest->setModel(NULL);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	326 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	327
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	328
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	329 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	330 // Widget slot handlers
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	331 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	332 void SyntilistaMainWindow::on_button_Quit_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	333 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	334 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	335 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	336
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	337
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	338 void SyntilistaMainWindow::on_button_DeletePerson_clicked()
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	339 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	340 if (currPerson.id <= 0)
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	341 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	342 statusMsg(tr("Ei valittua henkilöä!"));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	343 return;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	344 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	345
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	346 PersonInfo info;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	347 if (!getPersonInfo(currPerson.id, info))
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	348 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	349 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	350 return;
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	351 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	352
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	353 QMessageBox dlg;
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	354 dlg.setText(tr("Varmistus"));
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	355 dlg.setInformativeText(
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	356 tr("<br>Haluatko varmasti poistaa henkilön:<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	357 "<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	358 "<b>'%1, %2'</b> <i>(ID #%3)</i>?<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	359 "<br>"
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	360 "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	361 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	362
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	363 dlg.setTextFormat(Qt::RichText);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	364 dlg.setIcon(QMessageBox::Question);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	365 dlg.setStandardButtons(QMessageBox::Yes \| QMessageBox::No);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	366 dlg.setDefaultButton(QMessageBox::No);
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	367
8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	368 if (dlg.exec() == QMessageBox::Yes)
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	369 {
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	370 int rv = model_People->deletePerson(info.id);
14 8a6a90ce0e0f Fixes. Matti Hamalainen <ccr@tnsp.org> parents: 13 diff changeset	371 updatePersonList();
24 0e0948aec438 De-select active person when deleting. Matti Hamalainen <ccr@tnsp.org> parents: 23 diff changeset	372 setActivePerson(-1);
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	373 if (rv != 0)
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	374 {
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	375 errorMsg(tr("SQL-tietokantavirhe"),
6 0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	376 tr("Henkilön tietoja poistettaessa tapahtui virhe #%1.").
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	377 arg(rv));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	378 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	379 else
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	380 {
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	381 statusMsg(tr("Henkilö '%1 %2' (ID #%3) poistettu.").
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	382 arg(info.firstName).arg(info.lastName).
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	383 arg(info.id));
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	384 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	385 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	386 }
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	387
0315a3b9f560 Implement person and transaction history deletion. Matti Hamalainen <ccr@tnsp.org> parents: 5 diff changeset	388
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	389 void SyntilistaMainWindow::on_button_AddPerson_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	390 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	391 EditPerson *person = new EditPerson(this);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	392 person->setPerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	393 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	394
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 void SyntilistaMainWindow::on_button_EditPerson_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	397 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	398 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	399 {
db8f47446713 Disable the edit person push button when no person is selected. Matti Hamalainen <ccr@tnsp.org> parents: 0 diff changeset	400 EditPerson *person = new EditPerson(this);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	401 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	402 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	403 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	404
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	405
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	406 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	407 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	408 int row = curr.row();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	409 if (row >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	410 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	411 const QAbstractItemModel *model = curr.model();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	412 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	413
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	414 EditPerson *person = new EditPerson(this);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	415 person->setPerson(currPerson.id);
0 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 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	418 setActivePerson(-1);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	419 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	420
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	421
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	422 void SyntilistaMainWindow::on_button_ClearFilter_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	423 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	424 ui->edit_PersonFilter->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	425 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	426
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	427
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	428 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	429 // Update visible person list/query based on the current
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	430 // filtering and sorting settings.
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	431 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	432 void SyntilistaMainWindow::updatePersonList()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	433 {
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	434 static QString queryBase =
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	435 "SELECT id,last_name,first_name,"
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	436 "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	437 "updated FROM people";
8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	438
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	439 QSqlQuery query;
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	440 QString queryOrderDir, queryOrderBy;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	441
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	442 // Sort order
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	443 if (peopleSortOrder == Qt::AscendingOrder)
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	444 queryOrderDir = QStringLiteral("ASC");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	445 else
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	446 queryOrderDir = QStringLiteral("DESC");
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	447
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	448 // Sort by which column
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	449 switch (peopleSortIndex)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	450 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	451 case 1:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	452 case 2:
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	453 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	454 break;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	455
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	456 case 3:
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	457 queryOrderBy = QStringLiteral(" ORDER BY balance ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	458 break;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	459
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	460 case 4:
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	461 queryOrderBy = QStringLiteral(" ORDER BY updated ") + queryOrderDir;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	462 break;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	463
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	464 default:
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	465 queryOrderBy = "";
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	466 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	467
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	468 // Are we filtering or not?
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	469 if (peopleFilter != "")
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	470 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	471 // Filter by name(s)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	472 QString tmp = "%"+ peopleFilter +"%";
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	473 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	474
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	475 query.addBindValue(tmp);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	476 query.addBindValue(tmp);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	477 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	478 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	479 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	480 // No filter
16 8765397e45f4 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 15 diff changeset	481 query.prepare(queryBase + queryOrderBy);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	482 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	483
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	484 // Execute the query and update model
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	485 checkAndReportSQLError("updatePersonList() before exec", query.lastError());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	486 query.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	487 checkAndReportSQLError("updatePersonList() after exec", query.lastError());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	488
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	489 model_People->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	490
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	491 model_People->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	492 model_People->setHeaderData(1, Qt::Horizontal, tr("Sukunimi"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	493 model_People->setHeaderData(2, Qt::Horizontal, tr("Etunimi"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	494 model_People->setHeaderData(3, Qt::Horizontal, tr("Tase"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	495 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	496 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	497
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	498
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	499 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	500 // Update the list of people when filter parameter changes
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	501 //
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	502 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	503 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	504 peopleFilter = cleanupStr(str);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	505 updatePersonList();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	506 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	507
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	508
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	509 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	510 // Add one transaction to given person id
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	511 //
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	512 int SyntilistaMainWindow::addTransaction(qint64 id, double value, PersonInfo &info)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	513 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	514 if (!getPersonInfo(id, info))
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	515 return -1;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	516
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	517 QSqlDatabase::database().transaction();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	518
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	519 QSqlQuery query;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	520 query.prepare("INSERT INTO transactions (person,value,added) VALUES (?,?,?)");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	521 query.addBindValue(id);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	522 query.addBindValue(value);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	523 query.addBindValue(QDateTime::currentDateTimeUtc());
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	524 query.exec();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	525 if (!checkAndReportSQLError("addTransaction()", query.lastError()))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	526 {
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	527 QSqlDatabase::database().rollback();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	528 return -2;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	529 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	530
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	531 query.prepare("UPDATE people SET updated=? WHERE id=?");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	532 query.addBindValue(QDateTime::currentDateTimeUtc());
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	533 query.addBindValue(id);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	534 query.exec();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	535 if (!checkAndReportSQLError("addTransaction update timestamp", query.lastError()))
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	536 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	537 QSqlDatabase::database().rollback();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	538 return -3;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	539 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	540
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	541 QSqlDatabase::database().commit();
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	542
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	543 return 0;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	544 }
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	545
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	546
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	547 int SyntilistaMainWindow::addTransactionGUI(qint64 id, bool debt, double value)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	548 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	549 PersonInfo info;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	550
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	551 // Check if person is selected
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	552 if (id <= 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	553 return -1;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	554
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	555 // Check value
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	556 if (value == 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	557 {
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	558 QString tmp = (debt ? "lisätty" : "vähennetty");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	559 statusMsg("Velkaa ei "+ tmp +" koska summaa ei määritetty.");
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	560 return 1;
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	561 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	562
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	563 // Perform transaction insert
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	564 int ret = addTransaction(id, debt ? -value : value, info);
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	565 if (ret == 0)
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	566 {
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	567 // 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	568 ui->edit_Amount->clear();
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	569 if (info.id == currPerson.id)
07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	570 setActivePerson(info.id);
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	571
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	572 model_People->updateModel();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	573
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	574 QString str;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	575 if (debt)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	576 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	577 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	578 arg(moneyValueToStr(value)).
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	579 arg(info.firstName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	580 arg(info.lastName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	581 arg(info.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	582 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	583 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	584 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	585 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	586 arg(moneyValueToStr(value)).
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	587 arg(info.firstName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	588 arg(info.lastName).
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	589 arg(info.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	590 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	591 statusMsg(str);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	592 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	593 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	594 {
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	595 errorMsg(
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	596 tr("SQL-tietokantavirhe"),
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	597 tr("Tietokantaan tapahtumaa lisättäessa tapahtui virhe #%1.").
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	598 arg(ret));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	599 }
4 f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	600
f2404a9987dc Cleaning up the code. Matti Hamalainen <ccr@tnsp.org> parents: 2 diff changeset	601 return ret;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	602 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	603
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	604
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	605 void SyntilistaMainWindow::on_button_AddDebt_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	606 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	607 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	608 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	609
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	610
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	611 void SyntilistaMainWindow::on_button_PayDebt_clicked()
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	612 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	613 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	614 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	615
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	616
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	617 void SyntilistaMainWindow::on_button_PayFullDebt_clicked()
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	618 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	619 if (currPerson.balance < 0)
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	620 addTransactionGUI(currPerson.id, false, -currPerson.balance);
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	621 else
8 466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	622 {
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	623 statusMsg(
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	624 tr("Valitulla henkilöllä '%1, %2' ei ole velkaa.").
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	625 arg(currPerson.lastName).
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	626 arg(currPerson.firstName));
466d89a2a629 More cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 6 diff changeset	627 }
2 edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	628 }
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	629
edc1e8cf6e2c Implement "pay debt in full" button. Matti Hamalainen <ccr@tnsp.org> parents: 1 diff changeset	630
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	631 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	632 // Edit person dialog
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	633 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	634 EditPerson::EditPerson(QWidget *parent) :
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	635 QDialog(parent),
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	636 ui(new Ui::EditPerson)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	637 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	638 ui->setupUi(this);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	639
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	640 setModal(true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	641 setAttribute(Qt::WA_DeleteOnClose);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	642 show();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	643 activateWindow();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	644 raise();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	645 setFocus();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	646
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	647 model_Transactions = new TransactionSQLModel();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	648 ui->tableview_Transactions->setModel(model_Transactions);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	649 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	650 ui->tableview_Transactions->verticalHeader()->setVisible(false);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	651 ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	652
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	653 validateForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	654 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	655
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	656
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	657 EditPerson::~EditPerson()
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 delete ui;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	660 delete model_Transactions;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	661 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	662
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	663
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	664 void EditPerson::statusMsg(const QString &msg)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	665 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	666 dynamic_cast<SyntilistaMainWindow *>(parent())->statusMsg(msg);
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	670 bool EditPerson::validateForm()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	671 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	672 selPerson.firstName = cleanupStr(ui->edit_FirstName->text());
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	673 selPerson.lastName = cleanupStr(ui->edit_LastName->text());
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	674 selPerson.extraInfo = ui->textedit_ExtraInfo->document()->toPlainText();
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	675
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	676 ui->edit_FirstName->setStyleSheet(selPerson.firstName == "" ? "background-color: red;" : NULL);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	677 ui->edit_LastName->setStyleSheet(selPerson.lastName == "" ? "background-color: red;" : NULL);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	678
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	679 return selPerson.firstName != "" && selPerson.lastName != "";
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	680 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	681
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	682
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	683 void EditPerson::on_button_Cancel_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	684 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	685 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	686 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	687
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	688
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	689 void EditPerson::on_button_OK_clicked()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	690 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	691 if (!validateForm())
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	692 {
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	693 errorMsg(
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	694 tr("Virhe!"),
18 8282142605e0 Cleanups. Matti Hamalainen <ccr@tnsp.org> parents: 17 diff changeset	695 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	696
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	697 return;
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	698 }
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	699
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	700 if (selPerson.id >= 0)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	701 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	702 QSqlQuery person;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	703 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	704 person.addBindValue(selPerson.id);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	705 person.addBindValue(selPerson.firstName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	706 person.addBindValue(selPerson.lastName);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	707 person.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	708
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	709 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	710
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	711 if (person.next())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	712 {
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	713 errorMsg(
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	714 tr("Virhe!"),
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	715 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	716 arg(selPerson.firstName).arg(selPerson.lastName));
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	717 return;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	718 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	719
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	720 dynamic_cast<SyntilistaMainWindow *>(parent())->model_People->updatePerson(selPerson);
12 07db1a0bbdc7 More cleanups, fixes. Matti Hamalainen <ccr@tnsp.org> parents: 11 diff changeset	721 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	722
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	723 statusMsg(tr("Päivitettiin henkilö '%1 %2' (#%3).").
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	724 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	725 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	726 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	727 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	728 QSqlQuery person;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	729 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	730 person.addBindValue(selPerson.firstName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	731 person.addBindValue(selPerson.lastName);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	732 person.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	733
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	734 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	735
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	736 if (person.next())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	737 {
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	738 errorMsg(
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	739 tr("Virhe!"),
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	740 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	741 arg(selPerson.firstName).arg(selPerson.lastName));
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	742
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	743 return;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	744 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	745
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	746 dynamic_cast<SyntilistaMainWindow *>(parent())->model_People->addPerson(selPerson);
14 8a6a90ce0e0f Fixes. Matti Hamalainen <ccr@tnsp.org> parents: 13 diff changeset	747 dynamic_cast<SyntilistaMainWindow *>(parent())->updatePersonList();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	748
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	749 statusMsg(tr("Lisättiin uusi henkilö '%1 %2'.").
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	750 arg(selPerson.firstName).arg(selPerson.lastName));
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	753 close();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	754 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	755
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	756
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	757 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	758 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	759 (void) arg1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	760 validateForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	761 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	762
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 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	765 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	766 (void) arg1;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	767 validateForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	768 }
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 void EditPerson::clearForm()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	772 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	773 ui->edit_FirstName->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	774 ui->edit_LastName->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	775 ui->textedit_ExtraInfo->document()->clear();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	776 ui->edit_FirstName->setFocus();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	777 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	778
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	779
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	780 void EditPerson::setPerson(qint64 id)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	781 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	782 selPerson.id = id;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	783
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	784 if (id >= 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	785 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	786 PersonInfo pinfo;
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	787 if (!getPersonInfo(id, pinfo))
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	788 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	789 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	790 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	791 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	792 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	793 ui->edit_FirstName->setText(pinfo.firstName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	794 ui->edit_LastName->setText(pinfo.lastName);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	795 ui->textedit_ExtraInfo->document()->setPlainText(pinfo.extraInfo);
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	796
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	797 QSqlQuery query;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	798 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	799 query.addBindValue(pinfo.id);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	800 query.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	801 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	802
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	803 model_Transactions->setQuery(query);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	804
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	805 model_Transactions->setHeaderData(0, Qt::Horizontal, tr("ID"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	806 model_Transactions->setHeaderData(1, Qt::Horizontal, tr("Summa"));
a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	807 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	808
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	809 ui->tableview_Transactions->setModel(model_Transactions);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	810 ui->tableview_Transactions->setColumnHidden(0, true);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	811
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	812 return; // Ugly
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	813 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	814 }
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 // In case of id < 0 or errors ..
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	817 clearForm();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	818 ui->tableview_Transactions->setModel(NULL);
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
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 //
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	823 // Custom SQL models
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 PersonSQLModel::PersonSQLModel(QObject *parent) : QSqlQueryModel(parent)
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 }
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	830 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	831 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	832 QVariant value = QSqlQueryModel::data(index, role);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	833
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	834 if (value.isValid() && role == Qt::DisplayRole)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	835 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	836 switch (index.column())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	837 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	838 case 3:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	839 return moneyValueToStr(value.toDouble());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	840
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	841 case 4:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	842 return dateTimeToStr(value.toDateTime());
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 if (index.column() == 3 && role == Qt::ForegroundRole)
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 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	849 if (val < 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	850 return QVariant::fromValue(QColor(Qt::red));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	851 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	852 return QVariant::fromValue(QColor(Qt::green));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	853 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	854
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	855 return value;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	856 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	857
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	858
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	859 int PersonSQLModel::updatePerson(const PersonInfo &info)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	860 {
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	861 QSqlQuery np;
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	862
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	863 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	864 np.addBindValue(info.firstName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	865 np.addBindValue(info.lastName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	866 np.addBindValue(info.extraInfo);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	867 np.addBindValue(QDateTime::currentDateTimeUtc());
11 4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	868 np.addBindValue(info.id);
5 a5a3baee3043 More cleanups and fixes. Matti Hamalainen <ccr@tnsp.org> parents: 4 diff changeset	869 np.exec();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	870
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	871 if (!checkAndReportSQLError("PersonSQLModel::updatePerson()", np.lastError()))
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	872 return -1;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	873
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	874 QSqlDatabase::database().commit();
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	875
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	876 updateModel();
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	877 return 0;
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	878 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	879
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	880
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	881 int PersonSQLModel::addPerson(const PersonInfo &info)
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	882 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	883 // beginInsertRows(QModelIndex(), rowCount(), rowCount());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	884
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	885 QSqlQuery np;
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	886 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	887 np.addBindValue(info.firstName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	888 np.addBindValue(info.lastName);
4e8a960e3975 More cleanups, better error dialogs. Matti Hamalainen <ccr@tnsp.org> parents: 10 diff changeset	889 np.addBindValue(info.extraInfo);
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	890 np.addBindValue(QDateTime::currentDateTimeUtc());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	891 np.addBindValue(QDateTime::currentDateTimeUtc());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	892 np.exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	893
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	894 if (!checkAndReportSQLError("PersonSQLModel::addPerson()", np.lastError()))
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	895 return -1;
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	896
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	897 QSqlDatabase::database().commit();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	898
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	899 // endInsertRows();
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	900 updateModel();
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	901 return 0;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	902 }
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	903
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	904
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	905 int PersonSQLModel::deletePerson(qint64 id)
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	906 {
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	907 QSqlDatabase::database().transaction();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	908 QSqlQuery del;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	909
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	910 del.prepare("DELETE FROM people WHERE id=?");
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	911 del.addBindValue(id);
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	912 del.exec();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	913
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	914 if (!checkAndReportSQLError("delete user", del.lastError()))
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	915 {
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	916 QSqlDatabase::database().rollback();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	917 return -1;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	918 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	919
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	920 del.prepare("DELETE FROM transactions WHERE person=?");
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	921 del.addBindValue(id);
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	922 del.exec();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	923
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	924 if (!checkAndReportSQLError("delete user transactions", del.lastError()))
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	925 {
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	926 QSqlDatabase::database().rollback();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	927 return -2;
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	928 }
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	929
13 ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	930 QSqlDatabase::database().commit();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	931 updateModel();
ca5ce74c0563 Refactoring. Matti Hamalainen <ccr@tnsp.org> parents: 12 diff changeset	932 return 0;
0 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
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 void PersonSQLModel::updateModel()
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	937 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	938 query().exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	939 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	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 TransactionSQLModel::TransactionSQLModel(QObject *parent) : QSqlQueryModel(parent)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	944 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	945 }
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
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	948 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	949 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	950 QVariant value = QSqlQueryModel::data(index, role);
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	951
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	952 if (value.isValid() && role == Qt::DisplayRole)
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 switch (index.column())
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	955 {
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	956 case 1:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	957 return moneyValueToStr(value.toDouble());
19 2ee61a6b78f8 Remove trailing whitespace. Matti Hamalainen <ccr@tnsp.org> parents: 18 diff changeset	958
0 fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	959 case 2:
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	960 return dateTimeToStr(value.toDateTime());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	961 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	962 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	963
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	964 if (index.column() == 1 && role == Qt::ForegroundRole)
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 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	967 if (val < 0)
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	968 return QVariant::fromValue(QColor(Qt::red));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	969 else
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	970 return QVariant::fromValue(QColor(Qt::green));
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	971 }
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	972
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	973 return value;
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
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 void TransactionSQLModel::updateModel()
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 query().exec();
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	980 emit dataChanged(QModelIndex(), QModelIndex());
fec4d0c461f2 Initial import of the post-prototyping phase code. Matti Hamalainen <ccr@tnsp.org> parents: diff changeset	981 }

Mercurial > hg > syntilista

annotate main.cpp @ 24:0e0948aec438