#ifndef THREADGESTIONBDD_H
#define THREADGESTIONBDD_H

#include <QThread>
#include <QtSql/QSqlDatabase>
#include <QtSql/qsql.h>
#include <QtSql/QSqlQuery>
#include <QtSql/QSqlError>
#include <QVariant>
#include <QDate>


class ThreadGestionBDD : public QThread
{
    Q_OBJECT
public:
    explicit ThreadGestionBDD(QObject *parent = 0);
    ~ThreadGestionBDD();

signals:
    void ConnectOk();
    void EnvoieBaseErreur(QString);
    void EnvoieFinDepot();


public slots:
    void ReceptionSelect_id_Client(QString requete, QString matricule);
    void ReceptionSelect_id_ClientNom_Prenom(QString requete, QString nom, QString prenom);
    void ReceptionInfosDepot(QString poids, QString codeBarre , QString snGrv, QString dateEnvoie);

private:
    QSqlDatabase * db;
    QSqlQuery * query;
    QString erreur;
    QString sql;
    QString matriculeClient;
    QString nomClient;
    QString prenomClient;
    QString Sn_GRV;
    int id_Client;
    int id_Depot;
    QString poidsDepot;
    QString CodeBarre;
    int id_GRV;
    QString date;
    int index;
    bool flagNewClientBase;

protected:
    void run();

};

#endif // THREADGESTIONBDD_H