ExcelScan/analysisjson.cpp at master · hupochun/ExcelScan · GitHub

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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
#include "analysisjson.h"

AnalysisJson::AnalysisJson() {}

// QJsonObject AnalysisJson::errToJson(const Err &err)
// {
//     QJsonObject jsonObj;
//     jsonObj["ErrRow"] = err.ErrRow;
//     jsonObj["ErrCol"] = QString(err.ErrCol);
//     return jsonObj;
// }

QJsonObject AnalysisJson::ruleToJson(const Rule &rule)
{
    QJsonObject jsonObj;
    jsonObj["RT"] = rule.RT;
    jsonObj["RT1"] = rule.RT1;
    jsonObj["condition"] = rule.condition;
    jsonObj["column"] = rule.column;
    jsonObj["CompareData"] = rule.CompareData;
    jsonObj["Description"] = rule.Description;
    jsonObj["Name"] = rule.Name;

    // QJsonArray errArray;
    // for (const Err& err : rule.ErrMsg) {
    //     errArray.append(errToJson(err));
    // }
    // jsonObj["ErrMsg"] = errArray;

    return jsonObj;
}

QJsonObject AnalysisJson::ruleTemplateToJson(const RuleTemplate &ruleTemplate)
{
    QJsonObject jsonObj;
    jsonObj["RuleNum"] = ruleTemplate.RuleNum;
    jsonObj["Name"] = ruleTemplate.Name;
    jsonObj["Description"] = ruleTemplate.Description;

    QJsonArray ruleArray;
    for (const Rule& rule : ruleTemplate.m_Rule) {
        ruleArray.append(ruleToJson(rule));
    }
    jsonObj["Rules"] = ruleArray;

    return jsonObj;
}

void AnalysisJson::saveRuleTemplateToJson(const RuleTemplate &ruleTemplate, const QString &filePath)
{
    QJsonObject jsonObj = ruleTemplateToJson(ruleTemplate);
    QJsonDocument jsonDoc(jsonObj);
    QByteArray jsonData = jsonDoc.toJson();

    QFile file(filePath);
    if (file.open(QIODevice::WriteOnly)) {
        QTextStream stream(&file);
        stream.setCodec("UTF-8");
        stream << jsonData;
        file.close();
    } else {
        qWarning() << "Failed to open file for writing:" << filePath;
    }
}

// Err AnalysisJson::jsonToErr(const QJsonObject &jsonObj)
// {
//     Err err;
//     err.ErrRow = jsonObj["ErrRow"].toInt();
//     err.ErrCol = jsonObj["ErrCol"].toString().at(0).toLatin1();
//     return err;
// }

Rule AnalysisJson::jsonToRule(const QJsonObject &jsonObj)
{
    Rule rule;
    rule.RT = jsonObj["RT"].toInt();
    rule.RT1 = jsonObj["RT1"].toInt();
    rule.condition = jsonObj["condition"].toString().toInt();
    rule.column = jsonObj["column"].toString();
    rule.CompareData = jsonObj["CompareData"].toString();
    rule.Description = jsonObj["Description"].toString();
    rule.Name = jsonObj["Name"].toString();

    // QJsonArray errArray = jsonObj["ErrMsg"].toArray();
    // for (const QJsonValue& value : errArray) {
    //     rule.ErrMsg.append(jsonToErr(value.toObject()));
    // }

    return rule;
}

RuleTemplate AnalysisJson::jsonToRuleTemplate(const QJsonObject &jsonObj)
{
    RuleTemplate ruleTemplate;
    ruleTemplate.RuleNum = jsonObj["RuleNum"].toInt();
    ruleTemplate.Name = jsonObj["Name"].toString();
    ruleTemplate.Description = jsonObj["Description"].toString();

    QJsonArray ruleArray = jsonObj["Rules"].toArray();
    for (const QJsonValue& value : ruleArray) {
        ruleTemplate.m_Rule.append(jsonToRule(value.toObject()));
    }

    return ruleTemplate;
}

RuleTemplate AnalysisJson::loadRuleTemplateFromJson(const QString &filePath)
{
    QFile file(filePath);
    RuleTemplate ruleTemplate;

    if (file.open(QIODevice::ReadOnly| QIODevice::Text)) {

        QTextStream stream(&file);
        stream.setCodec("UTF-8");
        QByteArray jsonData = stream.readAll().toUtf8();
        file.close();

        QJsonDocument jsonDoc(QJsonDocument::fromJson(jsonData));
        QJsonObject jsonObj = jsonDoc.object();
        ruleTemplate = jsonToRuleTemplate(jsonObj);
    } else {
        qWarning() << "Failed to open file for reading:" << filePath;
    }

    return ruleTemplate;
}