#include <QtGui>
#include <QMessageBox>
#include <QtSql>
#include "../../../../Programme/NCReport/2.6.1.mingw.eval/include/ncreport.h"
#include "../../../../Programme/NCReport/2.6.1.mingw.eval/include/ncreportoutput.h"
#include "../../../../Programme/NCReport/2.6.1.mingw.eval/include/ncreportpreviewoutput.h"
#include "../../../../Programme/NCReport/2.6.1.mingw.eval/include/ncreportpreviewwindow.h"
#include "../../../../Programme/NCReport/2.6.1.mingw.eval/include/info.h"
#include "../../../../Programme/NCReport/2.6.1.mingw.eval/include/utils.h"

#include "buchen.h"
#include "completer.h"

completer::completer(QString vergleich) {

    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
        db.setHostName("");
        db.setDatabaseName("");
        db.setUserName("");
        db.setPassword("");

    if (!db.open()) {
        QSqlError err = db.lastError();
        QMessageBox::information(0,QObject::tr("Fehler"),err.text());
        return;
    }

    QSqlQuery query;
    query.exec("select kostenart,SUBSTRING_INDEX(SUBSTRING_INDEX(kostenart, ')', 1),'(',-1) as nummer from grundkosten where kostenart like('%"
               + vergleich + "%') order by nummer");
    QSqlRecord record = query.record();
    while (query.next()) {

        element = new QListWidgetItem();
        element->setText(query.value(record.indexOf("kostenart")).toString());
        element->setData(Qt::UserRole,query.value(record.indexOf("nummer")));
        this->addItem(element);
    }

}