From 7167ce41b61d2ba2cdb526777a4233eb84a3b66a Mon Sep 17 00:00:00 2001
From: Unit 193 <unit193@ubuntu.com>
Date: Sat, 6 Dec 2014 17:33:25 -0500
Subject: Imported Upstream version 2.99.6

---
 Plugins/HtmlExport/HtmlExport.pro      |  29 ++
 Plugins/HtmlExport/htmlexport.cpp      | 615 +++++++++++++++++++++++++++++++++
 Plugins/HtmlExport/htmlexport.css      |  59 ++++
 Plugins/HtmlExport/htmlexport.h        |  74 ++++
 Plugins/HtmlExport/htmlexport.json     |   7 +
 Plugins/HtmlExport/htmlexport.qrc      |   8 +
 Plugins/HtmlExport/htmlexport.ui       | 129 +++++++
 Plugins/HtmlExport/htmlexport_global.h |  12 +
 8 files changed, 933 insertions(+)
 create mode 100644 Plugins/HtmlExport/HtmlExport.pro
 create mode 100644 Plugins/HtmlExport/htmlexport.cpp
 create mode 100644 Plugins/HtmlExport/htmlexport.css
 create mode 100644 Plugins/HtmlExport/htmlexport.h
 create mode 100644 Plugins/HtmlExport/htmlexport.json
 create mode 100644 Plugins/HtmlExport/htmlexport.qrc
 create mode 100644 Plugins/HtmlExport/htmlexport.ui
 create mode 100644 Plugins/HtmlExport/htmlexport_global.h

(limited to 'Plugins/HtmlExport')

diff --git a/Plugins/HtmlExport/HtmlExport.pro b/Plugins/HtmlExport/HtmlExport.pro
new file mode 100644
index 0000000..ff0a68e
--- /dev/null
+++ b/Plugins/HtmlExport/HtmlExport.pro
@@ -0,0 +1,29 @@
+#-------------------------------------------------
+#
+# Project created by QtCreator 2014-06-20T22:57:37
+#
+#-------------------------------------------------
+
+include($$PWD/../../SQLiteStudio3/plugins.pri)
+
+QT       -= gui
+
+TARGET = HtmlExport
+TEMPLATE = lib
+
+DEFINES += HTMLEXPORT_LIBRARY
+
+SOURCES += htmlexport.cpp
+
+HEADERS += htmlexport.h\
+        htmlexport_global.h
+
+OTHER_FILES += \
+    htmlexport.json \
+    htmlexport.css
+
+RESOURCES += \
+    htmlexport.qrc
+
+FORMS += \
+    htmlexport.ui
diff --git a/Plugins/HtmlExport/htmlexport.cpp b/Plugins/HtmlExport/htmlexport.cpp
new file mode 100644
index 0000000..75b3868
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport.cpp
@@ -0,0 +1,615 @@
+#include "htmlexport.h"
+#include "services/pluginmanager.h"
+#include "common/unused.h"
+#include <QFile>
+#include <QTextCodec>
+#include <QDebug>
+#include <QRegExp>
+#include <schemaresolver.h>
+
+QString HtmlExport::getFormatName() const
+{
+    return "HTML";
+}
+
+ExportManager::StandardConfigFlags HtmlExport::standardOptionsToEnable() const
+{
+    return ExportManager::CODEC;
+}
+
+QString HtmlExport::getExportConfigFormName() const
+{
+    return "HtmlExportConfig";
+}
+
+void HtmlExport::validateOptions()
+{
+    bool header = cfg.HtmlExport.PrintHeader.get();
+    EXPORT_MANAGER->updateVisibilityAndEnabled(cfg.HtmlExport.PrintDataTypes, true, header);
+}
+
+QString HtmlExport::defaultFileExtension() const
+{
+    return "html";
+}
+
+CfgMain* HtmlExport::getConfig()
+{
+    return &cfg;
+}
+
+bool HtmlExport::beforeExportQueryResults(const QString& query, QList<QueryExecutor::ResultColumnPtr>& columns, const QHash<ExportManager::ExportProviderFlag, QVariant> providedData)
+{
+    UNUSED(query);
+    UNUSED(providedData);
+
+    if (!beginDoc(tr("SQL query results")))
+        return false;
+
+    columnTypes = QueryExecutor::resolveColumnTypes(db, columns, true);
+
+    writeln("<table>");
+    incrIndent();
+    if (printHeader)
+    {
+        writeln("<tr class=\"header\">");
+        incrIndent();
+        if (printRownum)
+        {
+            writeln("<td align=\"right\">");
+            incrIndent();
+            writeln("<b><i>#</i></b>");
+            decrIndent();
+            writeln("</td>");
+        }
+
+        QString column;
+        int i = 0;
+        for (const QueryExecutor::ResultColumnPtr& col : columns)
+        {
+            writeln("<td>");
+            incrIndent();
+            column = QString("<b>%1</b>").arg(col->displayName);
+            if (printDatatypes)
+            {
+                if (!columnTypes[i].isNull())
+                    column.append("<br/>" + columnTypes[i].toFullTypeString());
+                else
+                    column.append("<br/>" + tr("no type"));
+            }
+            writeln(column);
+            decrIndent();
+            writeln("</td>");
+            i++;
+        }
+        decrIndent();
+        writeln("</tr>");
+    }
+
+    currentDataRow = 0;
+    return true;
+}
+
+bool HtmlExport::exportQueryResultsRow(SqlResultsRowPtr row)
+{
+    return exportDataRow(row);
+}
+
+bool HtmlExport::afterExportQueryResults()
+{
+    decrIndent();
+    writeln("</table>");
+    writeln("<br/><br/>");
+    return true;
+}
+
+bool HtmlExport::exportTable(const QString& database, const QString& table, const QStringList& columnNames, const QString& ddl, SqliteCreateTablePtr createTable, const QHash<ExportManager::ExportProviderFlag, QVariant> providedData)
+{
+    UNUSED(database);
+    UNUSED(ddl);
+    UNUSED(columnNames);
+    UNUSED(providedData);
+
+    if (isTableExport())
+    {
+        if (!beginDoc(tr("Exported table: %1").arg(table)))
+            return false;
+    }
+
+    int colCount = createTable->columns.size();
+    int colSpan = printRownum ? colCount + 1 : colCount;
+
+    writeln("<table>");
+    incrIndent();
+
+    writeln("<tr class=\"title\">");
+    incrIndent();
+    writeln(QString("<td colspan=\"%1\" align=\"center\">%2</td>").arg(colSpan).arg(tr("Table: %1").arg(table)));
+    decrIndent();
+    writeln("</tr>");
+
+    if (printHeader)
+    {
+        writeln("<tr class=\"header\">");
+        incrIndent();
+        if (printRownum)
+        {
+            writeln("<td align=\"right\">");
+            incrIndent();
+            writeln("<b><i>#</i></b>");
+            decrIndent();
+            writeln("</td>");
+        }
+
+        QString column;
+        for (SqliteCreateTable::Column* col : createTable->columns)
+        {
+            writeln("<td>");
+            incrIndent();
+            column = QString("<b>%1</b>").arg(col->name);
+            if (printDatatypes)
+            {
+                if (col->type)
+                    column.append("<br/>" + col->type->toDataType().toFullTypeString());
+                else
+                    column.append("<br/>" + tr("no type"));
+            }
+            writeln(column);
+            decrIndent();
+            writeln("</td>");
+        }
+        decrIndent();
+        writeln("</tr>");
+    }
+
+    columnTypes.clear();
+    for (SqliteCreateTable::Column* col : createTable->columns)
+    {
+        if (col->type)
+            columnTypes << col->type->toDataType();
+        else
+            columnTypes << DataType();
+    }
+
+    currentDataRow = 0;
+    return true;
+}
+
+bool HtmlExport::exportDataRow(SqlResultsRowPtr data)
+{
+    currentDataRow++;
+
+    writeln("<tr>");
+    incrIndent();
+    if (printRownum)
+    {
+        writeln("<td class=\"rownum\">");
+        incrIndent();
+        writeln(QString("<i>%1</i>").arg(currentDataRow));
+        decrIndent();
+        writeln("</td>");
+    }
+
+    QString align;
+    QString cellValue;
+    QString cellStyle;
+    int i = 0;
+    for (const QVariant& value : data->valueList())
+    {
+        if (columnTypes[i].isNumeric())
+            align = "right";
+        else
+            align = "left";
+
+        if (value.isNull())
+        {
+            cellValue = "<i>NULL</i>";
+            cellStyle = " class=\"null\"";
+        }
+        else
+        {
+            cellStyle = "";
+            if (value.toString().trimmed().isEmpty())
+                cellValue = "&nbsp;";
+            else
+            {
+                cellValue = value.toString();
+                cellValue.truncate(byteLengthLimit);
+                cellValue = escape(cellValue);
+            }
+        }
+        writeln(QString("<td align=\"%1\"%2>").arg(align, cellStyle));
+        incrIndent();
+        writeln(cellValue);
+        decrIndent();
+        writeln("</td>");
+        i++;
+    }
+    decrIndent();
+    writeln("</tr>");
+    return true;
+}
+
+bool HtmlExport::exportVirtualTable(const QString& database, const QString& table, const QStringList& columnNames, const QString& ddl, SqliteCreateVirtualTablePtr createTable, const QHash<ExportManager::ExportProviderFlag, QVariant> providedData)
+{
+    UNUSED(database);
+    UNUSED(ddl);
+    UNUSED(columnNames);
+    UNUSED(createTable);
+    UNUSED(providedData);
+
+    if (isTableExport())
+    {
+        if (!beginDoc(tr("Exported table: %1").arg(table)))
+            return false;
+    }
+
+    int colCount = columnNames.size();
+    int colSpan = printRownum ? colCount + 1 : colCount;
+
+    writeln("<table>");
+    incrIndent();
+
+    writeln("<tr class=\"title\">");
+    incrIndent();
+    writeln(QString("<td colspan=\"%1\" align=\"center\">%2 <font color=\"#777777\">(%3)</font></td>").arg(colSpan).arg(tr("Table: %1").arg(table), tr("virtual")));
+    decrIndent();
+    writeln("</tr>");
+
+    if (printHeader)
+    {
+        writeln("<tr class=\"header\">");
+        incrIndent();
+        if (printRownum)
+        {
+            writeln("<td align=\"right\">");
+            incrIndent();
+            writeln("<b><i>#</i></b>");
+            decrIndent();
+            writeln("</td>");
+        }
+
+        QString column;
+        for (const QString& col : columnNames)
+        {
+            writeln("<td>");
+            incrIndent();
+            writeln(QString("<b>%1</b>").arg(col));
+            decrIndent();
+            writeln("</td>");
+        }
+        decrIndent();
+        writeln("</tr>");
+    }
+
+    columnTypes.clear();
+    for (int i = 0, total = columnNames.size(); i < total; ++i)
+        columnTypes << DataType();
+
+    currentDataRow = 0;
+    return true;
+}
+
+bool HtmlExport::exportTableRow(SqlResultsRowPtr data)
+{
+    return exportDataRow(data);
+}
+
+bool HtmlExport::afterExportTable()
+{
+    decrIndent();
+    writeln("</table>");
+    writeln("<br/><br/>");
+    return true;
+}
+
+bool HtmlExport::beforeExportDatabase(const QString& database)
+{
+    if (!beginDoc(tr("Exported database: %1").arg(database)))
+        return false;
+
+    return true;
+}
+
+bool HtmlExport::exportIndex(const QString& database, const QString& name, const QString& ddl, SqliteCreateIndexPtr createIndex)
+{
+    UNUSED(database);
+    UNUSED(ddl);
+
+    writeln("<table>");
+    incrIndent();
+
+    writeln("<tr class=\"title\">");
+    incrIndent();
+    writeln(QString("<td align=\"center\" colspan=\"3\">%1</td>").arg(tr("Index: %1").arg("<b>" + name + "</b>")));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td align=\"right\" class=\"rownum\">%1</td>").arg(tr("For table:")));
+    writeln(QString("<td colspan=\"2\">%1</td>").arg(createIndex->table));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td align=\"right\" class=\"rownum\">%1</td>").arg(tr("Unique:")));
+    writeln(QString("<td colspan=\"2\">%1</td>").arg(createIndex->uniqueKw ? tr("Yes") : tr("No")));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr class=\"header\">");
+    incrIndent();
+    writeln(QString("<td><b>%1</b></td>").arg(tr("Column")));
+    writeln(QString("<td><b>%1</b></td>").arg(tr("Collating")));
+    writeln(QString("<td><b>%1</b></td>").arg(tr("Sort order")));
+    decrIndent();
+    writeln("</tr>");
+
+    for (SqliteIndexedColumn* idxCol : createIndex->indexedColumns)
+    {
+        writeln("<tr>");
+        incrIndent();
+        writeln(QString("<td>%1</td>").arg(escape(idxCol->name)));
+        writeln(QString("<td align=\"center\">%1</td>").arg(idxCol->collate.isNull() ? "&nbsp;" : escape(idxCol->collate)));
+        writeln(QString("<td align=\"center\">%1</td>").arg(idxCol->sortOrder == SqliteSortOrder::null ? "&nbsp;" : sqliteSortOrder(idxCol->sortOrder)));
+        decrIndent();
+        writeln("</tr>");
+    }
+
+    decrIndent();
+    writeln("</table>");
+    writeln("<br/><br/>");
+    return true;
+}
+
+bool HtmlExport::exportTrigger(const QString& database, const QString& name, const QString& ddl, SqliteCreateTriggerPtr createTrigger)
+{
+    UNUSED(database);
+    UNUSED(ddl);
+
+    writeln("<table>");
+    incrIndent();
+
+    writeln("<tr class=\"title\">");
+    incrIndent();
+    writeln(QString("<td align=\"center\" colspan=\"2\">%1</td>").arg(tr("Trigger: %1").arg("<b>" + name + "</b>")));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td align=\"right\" class=\"rownum\">%1</td>").arg(tr("Activated:")));
+    writeln(QString("<td><code>%1</code></td>").arg(SqliteCreateTrigger::time(createTrigger->eventTime)));
+    decrIndent();
+    writeln("</tr>");
+
+    QString event = createTrigger->event ? SqliteCreateTrigger::Event::typeToString(createTrigger->event->type) : "";
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td align=\"right\" class=\"rownum\">%1</td>").arg(tr("Action:")));
+    writeln(QString("<td><code>%1</code></td>").arg(event));
+    decrIndent();
+    writeln("</tr>");
+
+    QString onObj;
+    if (createTrigger->eventTime == SqliteCreateTrigger::Time::INSTEAD_OF)
+        onObj = tr("On view:");
+    else
+        onObj = tr("On table:");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td align=\"right\" class=\"rownum\">%1</td>").arg(onObj));
+    writeln(QString("<td><code>%1</code></td>").arg(createTrigger->table));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td align=\"right\" class=\"rownum\">%1</td>").arg(tr("Activate condition:")));
+    writeln(QString("<td><code>%1</code></td>").arg(createTrigger->precondition ? escape(createTrigger->precondition->detokenize()) : ""));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln(QString("<td colspan=\"2\" class=\"separator\">%1</td>").arg(tr("Code executed:")));
+    decrIndent();
+    writeln("</tr>");
+
+    QStringList queryStrings;
+    for (SqliteQuery* q : createTrigger->queries)
+        queryStrings << escape(q->detokenize());
+
+    writeln("<tr>");
+    incrIndent();
+    writeln("<td colspan=\"2\">");
+    incrIndent();
+    writeln(QString("<pre>%1</pre>").arg(queryStrings.join("<br/>")));
+    decrIndent();
+    writeln("</td>");
+    decrIndent();
+    writeln("</tr>");
+
+    decrIndent();
+    writeln("</table>");
+    writeln("<br/><br/>");
+    return true;
+}
+
+bool HtmlExport::exportView(const QString& database, const QString& name, const QString& ddl, SqliteCreateViewPtr view)
+{
+    UNUSED(database);
+    UNUSED(ddl);
+
+    writeln("<table>");
+    incrIndent();
+
+    writeln("<tr class=\"title\">");
+    incrIndent();
+    writeln(QString("<td align=\"center\">%1</td>").arg(tr("View: %1").arg("<b>" + name + "</b>")));
+    decrIndent();
+    writeln("</tr>");
+
+    writeln("<tr>");
+    incrIndent();
+    writeln("<td>");
+    incrIndent();
+    writeln(QString("<pre>%1</pre>").arg(escape(view->select->detokenize())));
+    decrIndent();
+    writeln("</td>");
+    decrIndent();
+    writeln("</tr>");
+
+    decrIndent();
+    writeln("</table>");
+    writeln("<br/><br/>");
+    return true;
+}
+
+bool HtmlExport::afterExport()
+{
+    static const QString bodyEndTpl = QStringLiteral("</body>");
+    static const QString docEnd = QStringLiteral("</html>");
+
+    writeln("<i>" + tr("Document generated by SQLiteStudio v%1 on %2").arg(SQLITESTUDIO->getVersionString(), QDateTime::currentDateTime().toString()) + "</i>");
+    decrIndent();
+    writeln(bodyEndTpl);
+    decrIndent();
+    writeln(docEnd);
+    return true;
+}
+
+bool HtmlExport::beginDoc(const QString& title)
+{
+    static const QString docStart = QStringLiteral(
+                R"(<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">)"
+                "\n<html>"
+                );
+
+    static const QString metaCodecTpl = QStringLiteral(R"(<meta http-equiv="Content-Type" content="text/html; charset=%1"/>)");
+    static const QString titletpl = QStringLiteral(R"(<title>%1</title>)");
+    static const QString styleStartTpl = QStringLiteral(R"(<style type="text/css">)");
+    static const QString styleEndTpl = QStringLiteral(R"(</style>)");
+    static const QString bodyStartTpl = QStringLiteral(R"(<body>)");
+
+    setupConfig();
+
+    QFile file(":/htmlexport/htmlexport.css");
+    if (!file.open(QIODevice::ReadOnly))
+    {
+        qCritical() << "Could not open htmlexport.css resource while exporting to HTML:" << file.errorString();
+        return false;
+    }
+
+    writeln(docStart);
+    incrIndent();
+    writeln(metaCodecTpl.arg(codecName));
+    writeln(titletpl.arg(title));
+    writeln(styleStartTpl);
+    incrIndent();
+    writeln(indent ? file.readAll() : compressCss(file.readAll()));
+    decrIndent();
+    writeln(styleEndTpl);
+    writeln(bodyStartTpl);
+    incrIndent();
+
+    file.close();
+    return true;
+}
+
+void HtmlExport::setupConfig()
+{
+    codecName = codec->name();
+    indentDepth = 0;
+    newLineStr = "";
+    indentStr = "";
+    indent = (cfg.HtmlExport.Format.get() == "format");
+    if (indent)
+        newLineStr = "\n";
+
+    printRownum = cfg.HtmlExport.PrintRowNum.get();
+    printHeader = cfg.HtmlExport.PrintHeader.get();
+    printDatatypes = printHeader && cfg.HtmlExport.PrintDataTypes.get();
+    byteLengthLimit = cfg.HtmlExport.ByteLengthLimit.get();
+}
+
+void HtmlExport::incrIndent()
+{
+    if (indent)
+    {
+        indentDepth++;
+        updateIndent();
+    }
+}
+
+void HtmlExport::decrIndent()
+{
+    if (indent)
+    {
+        indentDepth--;
+        updateIndent();
+    }
+}
+
+void HtmlExport::updateIndent()
+{
+    indentStr = QString("    ").repeated(indentDepth);
+}
+
+void HtmlExport::writeln(const QString& str)
+{
+    QString newStr;
+    if (str.contains("\n"))
+    {
+        QStringList lines = str.split("\n");
+        QMutableStringListIterator it(lines);
+        while (it.hasNext())
+            it.next().prepend(indentStr);
+
+        newStr = lines.join("\n") + newLineStr;
+    }
+    else
+    {
+        newStr = indentStr + str + newLineStr;
+    }
+    GenericExportPlugin::write(newStr);
+}
+
+QString HtmlExport::escape(const QString& str)
+{
+    if (cfg.HtmlExport.DontEscapeHtml.get())
+        return str;
+
+    return str.toHtmlEscaped();
+}
+
+QString HtmlExport::compressCss(QString css)
+{
+    static const QRegExp spacesLeftRe(R"REGEXP(([^a-zA-Z0-9_\s]+)\s+(\S+))REGEXP");
+    static const QRegExp spacesRightRe(R"REGEXP((\S+)\s+([^a-zA-Z0-9_\s]+))REGEXP");
+    static const QRegExp spacesBetweenWordsRe(R"REGEXP((\S+)\s{2,}(\S+))REGEXP");
+    while (spacesLeftRe.indexIn(css) > -1)
+        css.replace(spacesLeftRe, R"(\1\2)");
+
+    while (spacesRightRe.indexIn(css) > -1)
+        css.replace(spacesRightRe, R"(\1\2)");
+
+    while (spacesBetweenWordsRe.indexIn(css) > -1)
+        css.replace(spacesBetweenWordsRe, R"(\1 \2)");
+
+    return css.trimmed();
+}
+
+bool HtmlExport::init()
+{
+    Q_INIT_RESOURCE(htmlexport);
+    return GenericExportPlugin::init();
+}
+
+void HtmlExport::deinit()
+{
+    Q_CLEANUP_RESOURCE(htmlexport);
+}
diff --git a/Plugins/HtmlExport/htmlexport.css b/Plugins/HtmlExport/htmlexport.css
new file mode 100644
index 0000000..72ebf4f
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport.css
@@ -0,0 +1,59 @@
+table
+{
+    border-style: solid;
+    border-width: 1px;
+    border-color: black;
+    border-collapse: collapse;
+}
+
+table tr
+{
+    background-color: white;
+}
+
+table tr.header
+{
+    background-color: #DDDDDD;
+}
+
+table tr.title
+{
+    background-color: #EEEEEE;
+}
+
+table tr td
+{
+    padding: 0px 3px 0px 3px;
+    border-style: solid;
+    border-width: 1px;
+    border-color: #666666;
+}
+
+table tr td.null
+{
+    color: #999999;
+    text-align: center;
+    padding: 0px 3px 0px 3px;
+    border-style: solid;
+    border-width: 1px;
+    border-color: #666666;
+}
+
+table tr td.separator
+{
+    padding: 0px 3px 0px 3px;
+    border-style: solid;
+    border-width: 1px;
+    border-color: #666666;
+    background-color: #DDDDDD;
+}
+
+table tr td.rownum
+{
+    padding: 0px 3px 0px 3px;
+    border-style: solid;
+    border-width: 1px;
+    border-color: #666666;
+    background-color: #DDDDDD;
+    text-align: right;
+}
diff --git a/Plugins/HtmlExport/htmlexport.h b/Plugins/HtmlExport/htmlexport.h
new file mode 100644
index 0000000..04a379c
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport.h
@@ -0,0 +1,74 @@
+#ifndef HTMLEXPORT_H
+#define HTMLEXPORT_H
+
+#include "htmlexport_global.h"
+#include "plugins/genericexportplugin.h"
+#include "config_builder.h"
+
+CFG_CATEGORIES(HtmlExportConfig,
+    CFG_CATEGORY(HtmlExport,
+        CFG_ENTRY(QString, Format,          "compress")
+        CFG_ENTRY(bool,    PrintRowNum,     true)
+        CFG_ENTRY(bool,    PrintHeader,     true)
+        CFG_ENTRY(bool,    PrintDataTypes,  true)
+        CFG_ENTRY(bool,    DontEscapeHtml,  false)
+        CFG_ENTRY(int,     ByteLengthLimit, 10000)
+    )
+)
+class HTMLEXPORTSHARED_EXPORT HtmlExport : public GenericExportPlugin
+{
+        Q_OBJECT
+        SQLITESTUDIO_PLUGIN("htmlexport.json")
+
+    public:
+        QString getFormatName() const;
+        ExportManager::StandardConfigFlags standardOptionsToEnable() const;
+        QString getExportConfigFormName() const;
+        CfgMain* getConfig();
+        void validateOptions();
+        QString defaultFileExtension() const;
+        bool beforeExportQueryResults(const QString& query, QList<QueryExecutor::ResultColumnPtr>& columns,
+                                      const QHash<ExportManager::ExportProviderFlag,QVariant> providedData);
+        bool exportQueryResultsRow(SqlResultsRowPtr row);
+        bool exportTable(const QString& database, const QString& table, const QStringList& columnNames, const QString& ddl, SqliteCreateTablePtr createTable,
+                         const QHash<ExportManager::ExportProviderFlag,QVariant> providedData);
+        bool exportVirtualTable(const QString& database, const QString& table, const QStringList& columnNames, const QString& ddl, SqliteCreateVirtualTablePtr createTable,
+                                const QHash<ExportManager::ExportProviderFlag,QVariant> providedData);
+        bool exportTableRow(SqlResultsRowPtr data);
+        bool beforeExportDatabase(const QString& database);
+        bool exportIndex(const QString& database, const QString& name, const QString& ddl, SqliteCreateIndexPtr createIndex);
+        bool exportTrigger(const QString& database, const QString& name, const QString& ddl, SqliteCreateTriggerPtr createTrigger);
+        bool exportView(const QString& database, const QString& name, const QString& ddl, SqliteCreateViewPtr view);
+        bool afterExportQueryResults();
+        bool afterExportTable();
+        bool afterExport();
+        bool init();
+        void deinit();
+
+    private:
+        bool beginDoc(const QString& title);
+        bool exportDataRow(SqlResultsRowPtr data);
+        void setupConfig();
+        void incrIndent();
+        void decrIndent();
+        void updateIndent();
+        void writeln(const QString& str);
+        QString escape(const QString& str);
+
+        static QString compressCss(QString css);
+
+        CFG_LOCAL(HtmlExportConfig, cfg)
+        bool indent = false;
+        int indentDepth = 0;
+        QString indentStr;
+        QString newLineStr;
+        QString codecName;
+        int currentDataRow = 0;
+        QList<DataType> columnTypes;
+        bool printRownum = false;
+        bool printHeader = false;
+        bool printDatatypes = false;
+        int byteLengthLimit = 0;
+};
+
+#endif // HTMLEXPORT_H
diff --git a/Plugins/HtmlExport/htmlexport.json b/Plugins/HtmlExport/htmlexport.json
new file mode 100644
index 0000000..530a21d
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport.json
@@ -0,0 +1,7 @@
+{
+    "type":         "ExportPlugin",
+    "title":        "HTML export",
+    "description":  "Provides HTML format for exporting.",
+    "version":      10000,
+    "author":       "SalSoft"
+}
diff --git a/Plugins/HtmlExport/htmlexport.qrc b/Plugins/HtmlExport/htmlexport.qrc
new file mode 100644
index 0000000..77f9482
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport.qrc
@@ -0,0 +1,8 @@
+<RCC>
+    <qresource prefix="/htmlexport">
+        <file>htmlexport.css</file>
+    </qresource>
+    <qresource prefix="/forms">
+        <file>htmlexport.ui</file>
+    </qresource>
+</RCC>
diff --git a/Plugins/HtmlExport/htmlexport.ui b/Plugins/HtmlExport/htmlexport.ui
new file mode 100644
index 0000000..a4727a4
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport.ui
@@ -0,0 +1,129 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<ui version="4.0">
+ <class>HtmlExportConfig</class>
+ <widget class="QWidget" name="HtmlExportConfig">
+  <property name="geometry">
+   <rect>
+    <x>0</x>
+    <y>0</y>
+    <width>400</width>
+    <height>228</height>
+   </rect>
+  </property>
+  <property name="windowTitle">
+   <string>Form</string>
+  </property>
+  <layout class="QGridLayout" name="gridLayout">
+   <item row="4" column="1">
+    <widget class="QSpinBox" name="spinBox">
+     <property name="maximumSize">
+      <size>
+       <width>100</width>
+       <height>16777215</height>
+      </size>
+     </property>
+     <property name="maximum">
+      <number>999999999</number>
+     </property>
+     <property name="cfg" stdset="0">
+      <string>HtmlExport.ByteLengthLimit</string>
+     </property>
+    </widget>
+   </item>
+   <item row="4" column="0">
+    <widget class="QLabel" name="label">
+     <property name="text">
+      <string>Maximum number of characters per cell:</string>
+     </property>
+    </widget>
+   </item>
+   <item row="2" column="0" colspan="2">
+    <widget class="QCheckBox" name="dataTypesCheck">
+     <property name="text">
+      <string>Include data types in first row</string>
+     </property>
+     <property name="cfg" stdset="0">
+      <string>HtmlExport.PrintDataTypes</string>
+     </property>
+    </widget>
+   </item>
+   <item row="1" column="0" colspan="2">
+    <widget class="QCheckBox" name="colNamesCheck">
+     <property name="text">
+      <string>Column names as first row</string>
+     </property>
+     <property name="cfg" stdset="0">
+      <string>HtmlExport.PrintHeader</string>
+     </property>
+    </widget>
+   </item>
+   <item row="0" column="0" colspan="2">
+    <widget class="QCheckBox" name="rowNumsCheck">
+     <property name="text">
+      <string>Row numbers as first column</string>
+     </property>
+     <property name="cfg" stdset="0">
+      <string>HtmlExport.PrintRowNum</string>
+     </property>
+    </widget>
+   </item>
+   <item row="5" column="0" colspan="2">
+    <widget class="QGroupBox" name="outputFormatGroup">
+     <property name="title">
+      <string>Output format</string>
+     </property>
+     <layout class="QVBoxLayout" name="verticalLayout_2">
+      <item>
+       <widget class="ConfigRadioButton" name="formatRadio">
+        <property name="text">
+         <string>Format document (new lines, indentation)</string>
+        </property>
+        <property name="cfg" stdset="0">
+         <string>HtmlExport.Format</string>
+        </property>
+        <property name="assignedValue" stdset="0">
+         <string>format</string>
+        </property>
+       </widget>
+      </item>
+      <item>
+       <widget class="ConfigRadioButton" name="compressRadio">
+        <property name="text">
+         <string>Compress (everything in one line)</string>
+        </property>
+        <property name="cfg" stdset="0">
+         <string>HtmlExport.Format</string>
+        </property>
+        <property name="assignedValue" stdset="0">
+         <string>compress</string>
+        </property>
+       </widget>
+      </item>
+     </layout>
+    </widget>
+   </item>
+   <item row="3" column="0">
+    <widget class="QCheckBox" name="dontEscapeCheck">
+     <property name="toolTip">
+      <string>&lt;p&gt;When enabled, HTML characters such as &amp;lt;, &amp;gt; and &amp;amp; are not escaped in exported values. This allows you for example to export hyper-link enabled documents, but it also may result in incorrect HTML document (unmatched pairs of &amp;lt; and &amp;gt; characters). Be warned.&lt;/p&gt;</string>
+     </property>
+     <property name="text">
+      <string>Don't escape HTML characters</string>
+     </property>
+     <property name="cfg" stdset="0">
+      <string>HtmlExport.DontEscapeHtml</string>
+     </property>
+    </widget>
+   </item>
+  </layout>
+ </widget>
+ <customwidgets>
+  <customwidget>
+   <class>ConfigRadioButton</class>
+   <extends>QRadioButton</extends>
+   <header>common/configradiobutton.h</header>
+  </customwidget>
+ </customwidgets>
+ <resources/>
+ <connections/>
+</ui>
diff --git a/Plugins/HtmlExport/htmlexport_global.h b/Plugins/HtmlExport/htmlexport_global.h
new file mode 100644
index 0000000..02671c4
--- /dev/null
+++ b/Plugins/HtmlExport/htmlexport_global.h
@@ -0,0 +1,12 @@
+#ifndef HTMLEXPORT_GLOBAL_H
+#define HTMLEXPORT_GLOBAL_H
+
+#include <QtCore/qglobal.h>
+
+#if defined(HTMLEXPORT_LIBRARY)
+#  define HTMLEXPORTSHARED_EXPORT Q_DECL_EXPORT
+#else
+#  define HTMLEXPORTSHARED_EXPORT Q_DECL_IMPORT
+#endif
+
+#endif // HTMLEXPORT_GLOBAL_H
-- 
cgit v1.2.3