#pragma once

#include <QtSql>
#include <QtCore>

namespace Incart::CablesDatabase
{

class DBHelper
{
public:
    DBHelper();
    ~DBHelper();
    QJsonObject getCableByType(qint8 type);
    QJsonArray getCablesByMode(qint8 mode, QString serie);
    qint32 getLastNumberByType(qint8 type);
    qint32 getTypeBySerial(QString serial);
    QJsonArray getAllCableTypes();
    bool isExistNumber(qint8 type, qint32 number);
    bool addCable(qint8 type);
    bool addCable(qint8 type, qint32 number, int numName, int prodName, QString prodDate, QString numDate);

    QJsonObject getPeopleList();
    bool addPerson(QString name, QString info);

    void getReport(QString date);

    bool hasValidDatabase();
    QString getDatabasePath();

protected:
    bool m_hasValidDatabase;
    QString m_databasePath;
    QSqlDatabase m_cablesDatabase;
    qint32 getPersonId(QString name);
    QJsonObject cableToJson(qint8 mode, qint8 type, QString name, QString serie)
    {
        return QJsonObject({
                           {"Mode", mode},
                           {"Type", type},
                           {"Name", name},
                           {"Serie", serie}
                           });
    }
    qint32 getPeopleNumber(qint32 id, qint32 role, QString dateAfter, QString dateBefore);
};

} // namespace Incart::CablesDatabase