syntilista: main.cpp annotate

annotate main.cpp @ 15:466417b7a1e4

Remove the mysterious XXX button.

author	Matti Hamalainen <ccr@tnsp.org>
date	Thu, 30 Mar 2017 17:10:22 +0300
parents	8a6a90ce0e0f
children	8765397e45f4

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

Mercurial > hg > syntilista

annotate main.cpp @ 15:466417b7a1e4