summaryrefslogtreecommitdiff
path: root/transaction.cpp
blob: 3367834d21ccd96d88b9c525c66339db9888866d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
#include "transaction.h"
#include "ui_transaction.h"
#include <QtSql>
#include <QMessageBox>
#include <QDate>
#include "contraaccount.h"

Transaction::Transaction(QWidget *parent) :
    QDialog(parent),
    m_ui(new Ui::Transaction)
{
    m_ui->setupUi(this);

    m_ui->Currency->addItem("EUR");
    m_ui->Currency->addItem("GLD");

    populateContra();

    QDoubleValidator *dv = new QDoubleValidator(-1000, 1000, 2, m_ui->Amount);
    m_ui->Amount->setValidator(dv);

    m_ui->Date->setCursorPosition(0);
}

Transaction::~Transaction()
{
    delete m_ui;
}

void Transaction::populateContra() {
    QSqlQuery q;
    q.exec("SELECT id, name FROM contra_accounts ORDER BY name");
    m_ui->Contra->clear();
    m_ui->Contra->addItem(" - ", 0);
    m_ui->Contra->setCurrentIndex(0);
    while(q.next()) {
        m_ui->Contra->addItem(q.value(1).toString(), q.value(0).toInt());
    }
    m_ui->Contra->addItem("...add new contra account", -1);
}

void Transaction::on_buttonBox_accepted()
{
    // some extra input validation - because the validation performed above has its limits
    if(m_ui->Contra->currentIndex() == m_ui->Contra->count()-1) {
        QMessageBox::critical(this, "Form validation error", "Incorrect contra account selected...");
        return;
    }
    QStringList d = m_ui->Date->text().split("-");
    if(!QDate::isValid(d[0].toInt(), d[1].toInt(), d[2].toInt())) {
        QMessageBox::critical(this, "Form validation Error", "Invalid date!");
        return;
    }

    accept();
}

void Transaction::load(int id)
{
    QSqlQuery q;
    q.prepare("SELECT date, amount, currency, contra, description FROM transactions WHERE id = ?");
    q.addBindValue(id);
    q.exec();
    q.next();
    m_ui->Date->setText(q.value(0).toString());
    m_ui->Amount->setText(QString("%1").arg(q.value(1).toDouble()/100));
    m_ui->Currency->setCurrentIndex(m_ui->Currency->findText(q.value(2).toString()));
    m_ui->Contra->setCurrentIndex(m_ui->Contra->findData(q.value(3)));
    m_ui->Description->setPlainText(q.value(4).toString());
}

void Transaction::save(int id)
{
    QSqlQuery q;
    q.prepare(id
        ? "UPDATE transactions SET date = ?, amount = ?, currency = ?, contra = ?, description = ? WHERE id = ?"
        : "INSERT INTO transactions (date, amount, currency, contra, description) VALUES (?, ?, ?, ?, ?)"
    );
    q.addBindValue(m_ui->Date->text());
    q.addBindValue(m_ui->Amount->text().toDouble()*100);
    q.addBindValue(m_ui->Currency->itemText(m_ui->Currency->currentIndex()));
    q.addBindValue(m_ui->Contra->itemData(m_ui->Contra->currentIndex()).toInt());
    q.addBindValue(m_ui->Description->toPlainText());
    if(id)
        q.addBindValue(id);
    q.exec();
    // TODO: error handling?
}

void Transaction::on_Contra_currentIndexChanged(int index)
{
    if(m_ui->Contra->itemData(index).toInt() != -1)
        return;

    ContraAccount c(this);
    if(c.exec() == QDialog::Accepted) {
        int id = c.save(0);
        qDebug() << "id = " << id;
        populateContra();
        m_ui->Contra->setCurrentIndex(m_ui->Contra->findData(id));
    } else {
        m_ui->Contra->setCurrentIndex(0);
    }
}