MBU/utility.cpp at master · Zioba/MBU · 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
#include <utility.h>

Utility::Utility()
{

}

void Utility::initializeTableSettings(QTableWidget* table) {
    table->horizontalHeader()->setFrameShape(QFrame::StyledPanel);
    table->horizontalHeader()->setFrameShadow(QFrame::Raised);
    table->verticalHeader()->setVisible(false);
    table->setEditTriggers(QAbstractItemView::NoEditTriggers);
    table->setSelectionBehavior(QAbstractItemView::SelectRows);
    table->setShowGrid(false);
}

void Utility::closeNewEditTab(QTabWidget* tabwgt) {
    for (int i = tabwgt->count() - 1; i >= 0; i--) {
        if (tabwgt->tabText(i) == "Новый" || tabwgt->tabText(i).contains("Цель")) {
            tabwgt->removeTab(i);
            return;
        }
    }
}

void Utility::clearLayout(QLayout* layout) {
    while (QLayoutItem* item = layout->takeAt(0))
    {
        if (QWidget* widget = item->widget())
            delete widget;
        if (QLayout* childLayout = item->layout())
            clearLayout(childLayout);
        delete item;
    }
}

QList<double> Utility::convertCoordToDecimalFormat(QString coord) {
    QString latitude = coord.split("     ").first();
    QString longitude = coord.split("     ").last();

    QRegExp regex("[°'\"\\s]+");
    QStringList latitudeParts = latitude.split(regex);
    QStringList longitudeParts = longitude.split(regex);
    double latitudeParsed = latitudeParts.at(0).toDouble() +
            (latitudeParts.at(1).toDouble() + latitudeParts.at(2).toDouble() / 60) / 60;
    double longitudeParsed = longitudeParts.at(0).toDouble() +
            (longitudeParts.at(1).toDouble() + longitudeParts.at(2).toDouble() / 60) / 60;

    QList<double> list;
    list << latitudeParsed << longitudeParsed;
    return list;
}

QString Utility::convertCoordToDegreeFormat(double coord) {
    int degrees = floor(coord);
    int minutes = floor((coord - degrees) * 60);
    QString seconds = QString::number(((coord - degrees) * 60 - minutes) * 60, 'f', 2);

    if (seconds.contains("60")) {
        seconds = "0.00";
        minutes++;
        if (minutes == 60) {
            minutes = 0;
            degrees++;
        }
    }
    qDebug() << degrees << "° " << minutes << "' " << seconds.toDouble() << "\"";
    return QString::number(degrees) + " " + QString::number(minutes) + " " + seconds;
}

QString Utility::convertCodeToReferenceName(QSqlDatabase db, QString code)
{
    QSqlQuery query = QSqlQuery( db );
    QString s = "";
    QString referenceName;
    s = "SELECT reference_data.terms.termname FROM reference_data.terms WHERE reference_data.terms.termhierarchy ='"+code+"';";
    if (!query.exec(s)) {
        return "";
    }
    else {
            while ( query.next() ) {
                referenceName = query.value( 0 ).toString();
            }
    }
    return referenceName;
}

QString Utility::convertReferenceNameTOCode(QSqlDatabase db, QString referenceName)
{
    QSqlQuery query = QSqlQuery( db );
    QString s = "";
    QString code;
    s = "SELECT reference_data.terms.termhierarchy FROM reference_data.terms WHERE reference_data.terms.termname ='"+referenceName+"';";
    if (!query.exec(s)) {
        return "";
    }
    else {
            while ( query.next() ) {
                code = query.value( 0 ).toString();
            }
    }
    return code;
}