diff options
Diffstat (limited to 'Plugins/HtmlExport')
| -rw-r--r-- | Plugins/HtmlExport/HtmlExport.pro | 29 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport.cpp | 615 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport.css | 59 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport.h | 74 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport.json | 7 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport.qrc | 8 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport.ui | 129 | ||||
| -rw-r--r-- | Plugins/HtmlExport/htmlexport_global.h | 12 |
8 files changed, 933 insertions, 0 deletions
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 = " "; + 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() ? " " : escape(idxCol->collate))); + writeln(QString("<td align=\"center\">%1</td>").arg(idxCol->sortOrder == SqliteSortOrder::null ? " " : 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><p>When enabled, HTML characters such as &lt;, &gt; and &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 &lt; and &gt; characters). Be warned.</p></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 |