Mercurial > hg > syntilista
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(); +}