//
// 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 "util.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();
}