//донецкая респ
select name,typename,* from gar.addr_obj where level = '1' and isactual = 1 order by name
//ясиноватое
select name,typename,* from gar.addr_obj a
join gar.adm_hierarchy h on h.objectid = a.objectid
where h.parentobjid = 155815692
and isactual = 1 order by name
//нетайлово
select name,typename,* from gar.addr_obj a
join gar.adm_hierarchy h on h.objectid = a.objectid
where h.parentobjid = 155816063
and isactual = 1 order by name
//безкаравайной
select name,typename,* from gar.addr_obj a
join gar.adm_hierarchy h on h.objectid = a.objectid
where h.parentobjid = 156148609
and isactual = 1 order by name
//пусто
select name,typename,* from gar.addr_obj a
join gar.adm_hierarchy h on h.objectid = a.objectid
where h.parentobjid = 160316367
and isactual = 1 order by name
//дом
select housenum,hs.* from gar.houses hs
join gar.adm_hierarchy h on h.objectid = hs.objectid
where h.parentobjid = 160316367
and isactual = 1 order by housenum

            QVector<QVector<QString>>vv;
            QVector<QString>v_tmp;
            for(int i=0;i<res;i++)
            {
                for(int j=0;j<field_len.size();j++)
                {
                        v_tmp.push_back(codepage_str);
                }

                vv.push_back(v_tmp);
            }
            qDebug()<<"vv.size="<<vv.size();
            for(int i=0;i<vv.size();i++)
            {
                qDebug()<<"vv["<<i<<"].size="<<vv[i].size();
                d_tmp.rid = vv[i][0];
                d_tmp.p = vv[i][1];
                d_tmp.dt = vv[i][2];
                d_tmp.ds = vv[i][3];
                d_tmp.dn = vv[i][4];
                d_tmp.dd = vv[i][5];
                d_tmp.de = vv[i][6];
                d_tmp.o = vv[i][7];
                v_.push_back(d_tmp);
            }

vv.size= 6
vv[ 0 ].size= 8
vv[ 1 ].size= 8
vv[ 2 ].size= 8
vv[ 3 ].size= 8
vv[ 4 ].size= 8
vv[ 5 ].size= 8

        QString dnp="ДНП";
        QByteArray ba = dnp.toLocal8Bit();
        const char *c_str2 = ba.data();
        QString buf = QTextCodec::codecForName("CP1251")->toUnicode(c_str2);
        delete[] c_str2;
        dnp = QTextCodec::codecForName("IBM-866")->fromUnicode(buf).data();
        if(strcmp(v[5].c_str(),dnp.toStdString().c_str())==0)
            qDebug()<<v[5].c_str();

QString sql="select W,DATE2 from "+v_filename[j].filename+" where EP ='"+ep+"' and ( STAT ='";
    sql+="ДНП";
    sql+="' or STAT ='";
    sql+="ДПП";
    sql+="');";
    QByteArray ba = sql.toLocal8Bit();
    const char *c_str2 = ba.data();
    QString buf = QTextCodec::codecForName("CP1251")->toUnicode(c_str2);
    sql = QTextCodec::codecForName("IBM-866")->fromUnicode(buf).data();
    query_base = new QSqlQuery(db_ODBC);
    bool res = query_base->exec(sql);

...
QSqlDatabase db_ODBC = QSqlDatabase::addDatabase("QODBC", "name_dbf");
    db_ODBC.setConnectOptions();
    db_ODBC.setDatabaseName("name_dbf");
    if (!db_ODBC.open()) {
        if (QMessageBox::warning(&w, "Не найден ODBC-источник данных","text"))
        {
            return -1;
        }
    }
...

select A,B,C,D, E,count(A) from T1 where (A,B,C,D) in 
(select A,B,C,D from T1 where not exists
(select * from T2 where T1.id = T2.f_id)) group by A,B,C,D,E having count(A)=1;

    QString str="Обычный текст \"Текст в кавычках\"";
    ...
    QString xml = "Проверка кодировки";
    QXmlStreamWriter stream(&xml);
    stream.setAutoFormatting(true);
    stream.writeStartDocument(); 
    stream.writeStartElement("Begin");
...
    stream.writeTextElement("Tag", str);
...
    stream.writeEndElement();//Begin
    stream.writeEndDocument();
    QString s_out_xml = "any.xml";
    QFile *f_xml = new QFile(s_out_xml);
    f_xml->open(QIODevice::WriteOnly);
    QTextCodec *codec = QTextCodec::codecForName("UTF-8");
    xml = xml.replace("<?xml version=\"1.0\"?>", "<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
    xml = xml.replace("Проверка кодировки", "");
    QByteArray encodedString = codec->fromUnicode(xml);
    f_xml->write(encodedString);
    f_xml->close();

<Tag>Обычный текст &quot;Текст в кавычках&quot;</Tag>

mimebytearrayattachment.cpp:4: ошибка: undefined reference to `_imp___ZTV23MimeByteArrayAttachment'
ошибка: collect2.exe: error: ld returned 1 exit status

QT       += core gui network
 
greaterThan(QT_MAJOR_VERSION, 4): QT += widgets
 
CONFIG += c++11
 
# The following define makes your compiler emit warnings if you use
# any Qt feature that has been marked deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS SMTP_BUILD
 
# You can also make your code fail to compile if it uses deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000    # disables all the APIs deprecated before Qt 6.0.0
 
SOURCES += \
    emailaddress.cpp \
    main.cpp \
    mainwindow.cpp \
    mimeattachment.cpp \
    mimebase64encoder.cpp \
    mimebase64formatter.cpp \
    mimebytearrayattachment.cpp \
    mimecontentencoder.cpp \
    mimecontentformatter.cpp \
    mimefile.cpp \
    mimehtml.cpp \
    mimeinlinefile.cpp \
    mimemessage.cpp \
    mimemultipart.cpp \
    mimepart.cpp \
    mimeqpencoder.cpp \
    mimeqpformatter.cpp \
    mimetext.cpp \
    quotedprintable.cpp \
    smtpclient.cpp
 
HEADERS += \
    SmtpMime \
    emailaddress.h \
    mainwindow.h \
    mimeattachment.h \
    mimebase64encoder.h \
    mimebase64formatter.h \
    mimebytearrayattachment.h \
    mimecontentencoder.h \
    mimecontentformatter.h \
    mimefile.h \
    mimehtml.h \
    mimeinlinefile.h \
    mimemessage.h \
    mimemultipart.h \
    mimepart.h \
    mimeqpencoder.h \
    mimeqpformatter.h \
    mimetext.h \
    quotedprintable.h \
    smtpclient.h \
    smtpmime_global.h
 
FORMS += \
    mainwindow.ui
 
TRANSLATIONS += \
    SMTP_QT_ru_RU.ts
 
# Default rules for deployment.
qnx: target.path = /tmp/$${TARGET}/bin
else: unix:!android: target.path = /opt/$${TARGET}/bin
!isEmpty(target.path): INSTALLS += target
 
# Location of SMTP Library
SMTP_LIBRARY_LOCATION = $$PWD/../build-SMTP_QT-desktop_mingw-Debug/
 
win32:CONFIG(release, debug|release): LIBS += -L$$SMTP_LIBRARY_LOCATION/release/ -lSmtpMime2
else:win32:CONFIG(debug, debug|release): LIBS += -L$$SMTP_LIBRARY_LOCATION/debug/ -lSmtpMime2
else:unix: LIBS += -L$$SMTP_LIBRARY_LOCATION -lSmtpMime
 
INCLUDEPATH += $$SMTP_LIBRARY_LOCATION
DEPENDPATH += $$SMTP_LIBRARY_LOCATION