diff src/viewtransactions.cpp @ 237:54ab3f3e28c0

Split EditPerson and ViewTransactions to separate source files.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 07 May 2018 19:19:13 +0300
parents
children 43a5e09bb832
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/viewtransactions.cpp	Mon May 07 19:19:13 2018 +0300
@@ -0,0 +1,67 @@
+//
+// Syntilista - debt list/management database program
+// Programmed and designed by Matti Hämäläinen <ccr@tnsp.org>
+// (C) Copyright 2017-2018 Tecnic Software productions (TNSP)
+//
+// Distributed under 3-clause BSD style license, refer to
+// included file "COPYING" for exact terms.
+//
+#include "main.h"
+#include "ui_viewtransactions.h"
+
+
+ViewTransactions::ViewTransactions(QWidget *parent) :
+    QDialog(parent),
+    ui(new Ui::ViewTransactions)
+{
+    ui->setupUi(this);
+
+    slSetCommonStyleSheet(this);
+
+    setModal(true);
+    setAttribute(Qt::WA_DeleteOnClose);
+    show();
+    activateWindow();
+    raise();
+    setFocus();
+
+    model_Transactions = new SLTransactionSQLModel();
+    ui->tableview_Transactions->setModel(model_Transactions);
+    ui->tableview_Transactions->setItemDelegate(new QSqlRelationalDelegate(ui->tableview_Transactions));
+    ui->tableview_Transactions->verticalHeader()->setVisible(false);
+    ui->tableview_Transactions->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
+
+    QSqlQuery query;
+    query.prepare(QStringLiteral(
+        "SELECT transactions.id,transactions.value,transactions.added,"
+        "people.last_name,people.first_name FROM transactions "
+        "LEFT JOIN people ON transactions.person=people.id ORDER BY transactions.added DESC"
+        ));
+
+    query.exec();
+    slCheckAndReportSQLError("SELECT transactions for tableview_Transactions", query.lastError());
+
+    model_Transactions->setQuery(query);
+
+    model_Transactions->setHeaderData(0, Qt::Horizontal, tr("ID"));
+    model_Transactions->setHeaderData(1, Qt::Horizontal, tr("Summa"));
+    model_Transactions->setHeaderData(2, Qt::Horizontal, tr("Aika"));
+    model_Transactions->setHeaderData(3, Qt::Horizontal, tr("Sukunimi"));
+    model_Transactions->setHeaderData(4, Qt::Horizontal, tr("Etunimi"));
+
+    ui->tableview_Transactions->setModel(model_Transactions);
+    ui->tableview_Transactions->setColumnHidden(0, true);
+}
+
+
+ViewTransactions::~ViewTransactions()
+{
+    delete ui;
+    delete model_Transactions;
+}
+
+
+void ViewTransactions::on_button_Close_clicked()
+{
+    close();
+}