dbhandler.cpp

#include "dbhandler.h"

DBHandler::DBHandler()
{

}

DBHandler::~DBHandler()
{
    QFile file(FILE_NAME);
    if(file.isOpen())
    {
        file.close();
    }
}

void DBHandler::loadAll(std::vector<DrawerData>& datas)
{
    QFile file(FILE_NAME);
    if(!file.open(QIODevice::ReadOnly))
    {
        qWarning("Failed to open the file for reading !");
    }

    QByteArray raw_data = file.readAll();
    QJsonDocument document = QJsonDocument::fromJson(raw_data);
    QJsonObject object = document.object();

    for(int i = 0; i < 41; i++)
    {
        DrawerData data;
        QString id = QString::number(i);

        if(object.contains(id) && object[id].isObject())
        {
            QJsonObject json = object[id].toObject();
            if(json.contains("status") && json["status"].isDouble())
            {
                data.setStatus(json["status"].toInt());
            }

            if(json.contains("name") && json["name"].isString())
            {
                data.setName(json["name"].toString());
            }

            if(json.contains("surname") && json["surname"].isString())
            {
                data.setSurname(json["surname"].toString());
            }

            if(json.contains("contact") && json["contact"].isString())
            {
                data.setContact(json["contact"].toString());
            }

            if(json.contains("deposit date") && json["deposit date"].isString())
            {
                data.setDeposit_date(json["deposit date"].toString());
            }

            if(json.contains("breakdown") && json["breakdown"].isString())
            {
                data.setBreakdown(json["breakdown"].toString());
            }

            if(json.contains("complementary info") && json["complementary info"].isString())
            {
                data.setComplementary_info(json["complementary info"].toString());
            }

            if(json.contains("repairs") && json["repairs"].isString())
            {
                data.setRepairs(json["repairs"].toString());
            }

            if(json.contains("comments") && json["comments"].isString())
            {
                data.setComments(json["comments"].toString());
            }

            if(json.contains("price") && json["price"].isString())
            {
                data.setPrice(json["price"].toString());
            }

            if(json.contains("client awarness") && json["client awarness"].isDouble())
            {
                data.setClient_awarness(json["client awarness"].toInt());
            }
        }

        datas.push_back(data);
    }

    file.close();
}

void DBHandler::saveAll(std::vector<DrawerData>& datas)
{
    QFile file(FILE_NAME);
    if(!file.open(QIODevice::WriteOnly | QIODevice::Truncate))
    {
        qWarning("Failed to open the file for reading !");
    }

    QJsonObject object;
    for(uint i = 0; i < datas.size(); i++)
    {
        QString id = QString::number(i);
        QJsonObject json;
        json["status"] = datas[i].getStatus();
        json["name"] = datas[i].getName();
        json["surname"] = datas[i].getSurname();
        json["contact"] = datas[i].getContact();
        json["deposit date"] = datas[i].getDeposit_date();
        json["breakdown"] = datas[i].getBreakdown();
        json["complementary info"] = datas[i].getComplementary_info();
        json["repairs"] = datas[i].getRepairs();
        json["comments"] = datas[i].getComments();
        json["price"] = datas[i].getPrice();
        json["client awarness"] = datas[i].getClient_awarness();

        object[id] = json;
    }

    QJsonDocument document(object);
    file.write(document.toJson());

    file.close();
}

void DBHandler::loadContactData(const QString& file_name, ContactData* data)
{
    QFile file(file_name);
    if(!file.open(QIODevice::ReadOnly))
    {
        qWarning("Failed to open contact data file !");
        //set manually the data then return
    }

    QByteArray raw_data = file.readAll();
    QJsonDocument doc = QJsonDocument::fromJson(raw_data);
    QJsonObject object = doc.object();

    if(object.contains("contacted date") && object["contacted date"].isArray())
    {
        QJsonArray date = object["contacted date"].toArray();
        data->dates().clear();
        for(int i = 0; i < date.size(); i++)
        {
            QDate save_date = QDate::fromString(date[i].toString());
            data->dates().push_back(save_date);
        }
    }

    file.close();
}

void DBHandler::saveContactData(const QString& file_name, ContactData* data)
{
    QFile file(file_name);
    if(!file.open(QIODevice::WriteOnly | QIODevice::Truncate))
    {
        qWarning("Failed to open file for writing !");
        //do a return
    }

    QJsonArray json;
    for(uint i = 0; i < data->dates().size(); i++)
    {
        json.append(data->dates()[i].toString());
    }

    QJsonObject object;
    object["contacted date"] = json;

    QJsonDocument doc(object);
    file.write(doc.toJson());

    file.close();
}

void DBHandler::deleteFileData(const QString& file_name)
{
    ContactData data;
    saveContactData(file_name, &data);//reset file with empty data
}