clickerconvert/clickerconvert: src/converter.cpp annotate

annotate src/converter.cpp @ 97:ccd1dbea2536

Look for replacements in resources on macos

author	Andre Heinecke <andre.heinecke@intevation.de>
date	Fri, 07 Oct 2016 12:31:51 +0200
parents	80ff6591101a
children	dd322a4b90d9

rev	line source
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	1 /* Copyright (C) 2016 by ETH Zürich
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	2 * Software engineering by Intevation GmbH
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	3 *
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	4 * This file is Free Software under the GNU GPL (v>=2)
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY!
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	6 * See LICENSE.txt for details.
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	7 */
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	8
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	9 #include "converter.h"
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	10 #include <QDebug>
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	11 #include <QRegularExpression>
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	12 #include <QRegularExpressionMatch>
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	13 #include <QTextDocument>
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	14 #include <QPrinter>
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	15 #include <QImage>
5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	16 #include <QPainter>
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	17 #include <QMessageBox>
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	18 #include <QDir>
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	19 #include <QCoreApplication>
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	20 #include <QSettings>
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	21
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	22 #include "xlsxdocument.h"
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	23 #include "xlsxconditionalformatting.h"
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	24
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	25 #include "constants.h"
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	26
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	27 QTXLSX_USE_NAMESPACE
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	28
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	29 Converter::Converter(const QString &input, const QStringList &outputs,
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	30 const QString &title):
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	31 QThread(Q_NULLPTR),
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	32 mInput(input),
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	33 mOutputs(outputs),
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	34 mTitle(title)
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	35 {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	36 mTitleFmt.setFontUnderline(Format::FontUnderlineSingle);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	37 mTitleFmt.setFontSize(18);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	38 mTitleFmt.setFontName("Calibri");
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	39 mTitleFmt.setFontBold(true);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	40 mTitleFmt.setVerticalAlignment(Format::AlignTop);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	41
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	42
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	43 mQuestionFmt.setFontSize(11);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	44 mQuestionFmt.setFontName("Calibri");
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	45 mQuestionFmt.setFontBold(true);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	46 mQuestionFmt.setTopBorderStyle(Format::BorderThin);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	47 mQuestionFmt.setBottomBorderStyle(Format::BorderThin);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	48 mQuestionFmt.setTextWarp(true);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	49
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	50 mAnswerChoiceFmt.setFontSize(11);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	51 mAnswerChoiceFmt.setFontName("Calibri");
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	52 mAnswerChoiceFmt.setHorizontalAlignment(Format::AlignLeft);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	53 mAnswerChoiceFmt.setTextWarp(true);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	54
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	55 mChoiceTextFmt = mAnswerChoiceFmt;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	56 mChoiceTextFmt.setVerticalAlignment(Format::AlignVCenter);
69 dab9c19252bd Set wordwrap exiplicitly for multiple choice answers Andre Heinecke <andre.heinecke@intevation.de> parents: 65 diff changeset	57 mChoiceTextFmt.setTextWarp(true);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	58
15 03dad1cff5b9 Minor layout fixes Andre Heinecke <andre.heinecke@intevation.de> parents: 13 diff changeset	59 mChoiceVotesFmt = mChoiceTextFmt;
03dad1cff5b9 Minor layout fixes Andre Heinecke <andre.heinecke@intevation.de> parents: 13 diff changeset	60 mChoiceVotesFmt.setFontSize(10);
03dad1cff5b9 Minor layout fixes Andre Heinecke <andre.heinecke@intevation.de> parents: 13 diff changeset	61
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	62 mFreeTextFmt = mQuestionFmt;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	63 mFreeTextFmt.setFontBold(false);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	64
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	65 mAnswerTextFmt = mQuestionFmt;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	66 mAnswerTextFmt.setVerticalAlignment(Format::AlignVCenter);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	67 mAnswerTextFmt.setHorizontalAlignment(Format::AlignLeft);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	68
e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	69 mTitleStyle = QStringLiteral("<tr><td colspan='3' style='vertical-align: top;"
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	70 "font-weight: bold; text-decoration:underline; font-size: 18pt;'>"
5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	71 "%1</td></tr><tr/>");
32 ad54c98cb8d8 Minor layout fixes Andre Heinecke <andre.heinecke@intevation.de> parents: 26 diff changeset	72 mQuestionStyle = QStringLiteral("<tr><td colspan='3' style='font-size: 11pt;font-weight: bold;'"
ad54c98cb8d8 Minor layout fixes Andre Heinecke <andre.heinecke@intevation.de> parents: 26 diff changeset	73 "><hr/>%1<hr/></td></tr>");
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	74 mAnswerChoiceStyle= QStringLiteral("<tr><td colspan='3' style='text-align: left; font-size: 11pt;'>Answer</td></tr>");
5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	75 mChoiceTextStyle= QStringLiteral("<tr><td align='right' style='vertical-align: middle; font-size:11pt;'>%1</td>");
86 08cca723e37d Move pre into html style to keep it out of xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 83 diff changeset	76 mChoiceVotesStyle = QStringLiteral("<td align='left' style='vertical-align: middle; font-size:10pt;'><pre>%1</pre></td></tr>");
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	77 mAnswerTextStyle = QStringLiteral("<tr><td colspan='3' style='font-weight: bold;vertical-algin: middle;"
5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	78 "font-size:11pt;'>Answer<hr/></td></tr>");
78 f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	79 mFreeTextStyle = QStringLiteral("<tr><td colspan='3'; style='font-size:11pt;'>%1<hr/></td></tr>");
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	80 mEmptyRow = QStringLiteral("<tr style='height: %1px'/>").arg(CHOICE_ROW_HEIGHT);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	81 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	82
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	83 void Converter::run()
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	84 {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	85 QFile infile;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	86
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	87 if (mInput.isEmpty()) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	88 if (!infile.open(stdin, QIODevice::ReadOnly)) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	89 mErrors << tr("Failed to open standard input and no input file provided.");
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	90 return;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	91 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	92 } else {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	93 infile.setFileName(mInput);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	94 if (!infile.open(QIODevice::ReadOnly)) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	95 mErrors << tr("Failed to open %1 for reading.").arg(mInput);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	96 return;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	97 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	98 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	99 QTextStream instream(&infile);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	100
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	101 QList<QFile*> outfiles;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	102
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	103 if (mOutputs.isEmpty()) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	104 QFile *outfile = new QFile();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	105 if (!outfile->open(stdout, QIODevice::WriteOnly)) {
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	106 mErrors << tr("Failed to open standard output and no output file provided.");
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	107 return;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	108 }
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	109 outfiles << outfile;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	110 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	111 foreach (const QString &fileName, mOutputs) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	112 QFile *outfile = new QFile();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	113 outfile->setFileName(fileName);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	114 if (!outfile->open(QIODevice::WriteOnly)) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	115 mErrors << tr("Failed to open %1 for writing.").arg(fileName);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	116 return;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	117 }
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	118 outfiles << outfile;
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	119 }
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	120 convertToXSLX(instream, outfiles);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	121 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	122
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	123 static void makeBar(QTextStream &html, double percent, QTextDocument &doc)
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	124 {
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	125 QImage image(QSize(IMAGE_WIDTH, 25), QImage::Format_RGB32);
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	126 QPainter painter(&image);
5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	127 QRect rect = image.rect();
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	128 if (percent) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	129 rect.setRight(rect.right() / (100. / percent));
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	130 painter.fillRect(rect, QColor(BAR_COLOR));
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	131 rect.setLeft(rect.right());
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	132 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	133 rect.setRight(IMAGE_WIDTH);
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	134 painter.fillRect(rect, Qt::white);
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	135 doc.addResource(QTextDocument::ImageResource, QUrl(QStringLiteral("internal://bar%1.png").arg((int)percent)),
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	136 QVariant(image));
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	137 html << QStringLiteral("<td style='vertical-align: middle'><img src=\"internal://bar%1.png\"/></td>").arg((int)percent);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	138 return;
e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	139 }
e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	140
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	141 static const QMap<QRegularExpression*, QString> loadExpressionsFromFile(const QString &path, QStringList &errors)
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	142 {
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	143 QFile file(path);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	144 QMap<QRegularExpression*, QString> ret;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	145
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	146 if (!file.open(QIODevice::ReadOnly \| QIODevice::Text)) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	147 errors << QObject::tr("Failed to open replacement file:") + "\n\"" + path + "\"";
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	148 return ret;
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	149 }
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	150
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	151 while (!file.atEnd()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	152 const auto line = file.readLine();
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	153 auto strline = QString::fromUtf8(line).trimmed();
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	154 if (strline.startsWith(QStringLiteral(";")) \|\| strline.isEmpty()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	155 continue;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	156 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	157
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	158 auto split = strline.split("=");
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	159 if (split.count() != 2) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	160 errors << QObject::tr("Invalid replacement line:") + "\n\"" + strline + "\"";
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	161 continue;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	162 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	163
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	164 auto exp = new QRegularExpression (split[0], QRegularExpression::MultilineOption);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	165 if (!exp->isValid()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	166 errors << QObject::tr("Invalid regular expression:") + "\n\"" + split[0] + "\"" +
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	167 "\n" + QObject::tr("Error: ") + exp->errorString();
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	168 continue;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	169 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	170 const auto rep = split[1].replace("\"", "");
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	171 ret.insert(exp, rep);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	172 qDebug() << "Loaded replacement: " << *exp << " replacement:" << rep << "";
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	173 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	174 /* Special one that does not fit into the ini format well. */
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	175 ret.insert(new QRegularExpression("^="), " =");
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	176 return ret;
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	177 }
defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	178
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	179 static const QMap<QRegularExpression*, QString> loadExpressions(QStringList &errors)
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	180 {
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	181 QMap<QRegularExpression*, QString> regexs;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	182 /* Look for file next to our place */
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	183 auto ourDir = QDir(QCoreApplication::applicationDirPath());
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	184 const auto filename = QStringLiteral(CONFIG_FILE_NAME);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	185 if (ourDir.exists(filename)) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	186 regexs = loadExpressionsFromFile(ourDir.filePath(filename), errors);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	187 return regexs;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	188 }
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	189
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	190 /* Look in ../share/apps/PROJECT_NAME */
97 ccd1dbea2536 Look for replacements in resources on macos Andre Heinecke <andre.heinecke@intevation.de> parents: 89 diff changeset	191 #ifndef Q_OS_MAC
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	192 ourDir.cd(QStringLiteral("../share/apps/" APPNAME).toLower());
97 ccd1dbea2536 Look for replacements in resources on macos Andre Heinecke <andre.heinecke@intevation.de> parents: 89 diff changeset	193 #else
ccd1dbea2536 Look for replacements in resources on macos Andre Heinecke <andre.heinecke@intevation.de> parents: 89 diff changeset	194 ourDir.cd(QStringLiteral("../../Resources"));
ccd1dbea2536 Look for replacements in resources on macos Andre Heinecke <andre.heinecke@intevation.de> parents: 89 diff changeset	195 #endif
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	196 if (ourDir.exists(filename)) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	197 regexs = loadExpressionsFromFile(ourDir.filePath(filename), errors);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	198 } else {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	199 qDebug() << "Failed to find regular expressions.";
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	200 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	201 return regexs;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	202 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	203
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	204 static const QStringList sanitizeInput(QString &str)
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	205 {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	206 QStringList errors;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	207 str.replace("\r\n", "\n");
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	208 str.replace("\n\r", "\n");
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	209 const auto expressions = loadExpressions(errors);
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	210 for (const auto regex: expressions.keys()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	211 str.replace(*regex, expressions.value(regex));
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	212 delete regex;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	213 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	214 return errors;
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	215 }
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	216
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	217 static void xlsEscape(QString &str)
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	218 {
74 9a2e35a7c19c Also escape leading equal sign in questions / choices Andre Heinecke <andre.heinecke@intevation.de> parents: 73 diff changeset	219 if (str.startsWith("=")) {
9a2e35a7c19c Also escape leading equal sign in questions / choices Andre Heinecke <andre.heinecke@intevation.de> parents: 73 diff changeset	220 str = " " + str;
9a2e35a7c19c Also escape leading equal sign in questions / choices Andre Heinecke <andre.heinecke@intevation.de> parents: 73 diff changeset	221 }
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	222 }
defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	223
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	224 void Converter::convertToXSLX(QTextStream& instream, QList<QFile *>outputs)
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	225 {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	226 Document xlsx;
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	227 QTextDocument doc;
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	228 QString htmlString;
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	229 QTextStream html (&htmlString);
70 3438f5cce8cc Force text codec for html to use UTF-8 Andre Heinecke <andre.heinecke@intevation.de> parents: 69 diff changeset	230 html.setCodec("UTF-8");
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	231
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	232 ConditionalFormatting bars;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	233
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	234 bars.addDataBarRule(QColor(0xFF, 0x99, 0x33), ConditionalFormatting::VOT_Num,
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	235 "0", ConditionalFormatting::VOT_Num, "100", false);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	236
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	237 const double colWidth[] = COLUMN_WIDTHS;
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	238 double sum = 0;
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	239
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	240 for (int i = 1; i <= COLUMN_CNT; i++) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	241 xlsx.setColumnWidth(i, colWidth[i-1]);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	242 sum += colWidth[i-1];
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	243 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	244
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	245 /* For the merged cell wordwrap trick. */
15 03dad1cff5b9 Minor layout fixes Andre Heinecke <andre.heinecke@intevation.de> parents: 13 diff changeset	246 xlsx.setColumnWidth(26, sum + 1);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	247 xlsx.setColumnHidden(26, true);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	248
80 2f81925b0eee Make html valid and add title Andre Heinecke <andre.heinecke@intevation.de> parents: 79 diff changeset	249 const QString title = mTitle.isEmpty() ? DEFAULT_TITLE : mTitle;
2f81925b0eee Make html valid and add title Andre Heinecke <andre.heinecke@intevation.de> parents: 79 diff changeset	250
26 5acd601356ba Make HTML work for QTextDocument Andre Heinecke <andre.heinecke@intevation.de> parents: 25 diff changeset	251 int row = 1;
80 2f81925b0eee Make html valid and add title Andre Heinecke <andre.heinecke@intevation.de> parents: 79 diff changeset	252 html << QStringLiteral("<!DOCTYPE html><html xmlns=\"http://www.w3.org/1999/xhtml\">"
2f81925b0eee Make html valid and add title Andre Heinecke <andre.heinecke@intevation.de> parents: 79 diff changeset	253 "<head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=UTF-8\"/>"
2f81925b0eee Make html valid and add title Andre Heinecke <andre.heinecke@intevation.de> parents: 79 diff changeset	254 "<title>%1</title>"
2f81925b0eee Make html valid and add title Andre Heinecke <andre.heinecke@intevation.de> parents: 79 diff changeset	255 "</head><body><table border=\"0\" width=\"100%\">").arg(title.toHtmlEscaped());
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	256 html << QStringLiteral("<tr><th width=\"%1%\"></th>").arg(HTML_COL1_PERCENT);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	257 html << QStringLiteral("<th width=\"%1%\"></th>").arg(HTML_COL2_PERCENT);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	258 html << QStringLiteral("<th width=\"%1%\"></th>").arg(HTML_COL3_PERCENT);
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	259
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	260 // Set the title of the Questionaire
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	261 xlsx.write(row++, 1, title, mTitleFmt);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	262 html << mTitleStyle.arg(title.toHtmlEscaped());
20 df7936065450 Add default title Andre Heinecke <andre.heinecke@intevation.de> parents: 15 diff changeset	263 xlsx.mergeCells("A1:C1");
df7936065450 Add default title Andre Heinecke <andre.heinecke@intevation.de> parents: 15 diff changeset	264 xlsx.setRowHeight(1, TITLE_ROW_HEIGHT);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	265
43 f9a0b2b6832e Sanitize input and unify Lineendings Andre Heinecke <andre.heinecke@intevation.de> parents: 41 diff changeset	266 QString input = instream.readAll();
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	267
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	268 QRegularExpression questionEx(QUESTION_PATTERN);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	269 QRegularExpression choiceEx(CHOICE_PATTERN);
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	270 QRegularExpression choiceAltEx(CHOICE_UNFILLED_PATTERN);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	271 QRegularExpression freetxtEx(FREETXT_PATTERN);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	272
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	273 mErrors += sanitizeInput(input);
43 f9a0b2b6832e Sanitize input and unify Lineendings Andre Heinecke <andre.heinecke@intevation.de> parents: 41 diff changeset	274
78 f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	275 QRegularExpressionMatch match = questionEx.match(input);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	276 bool foundSomething = false;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	277 int cursor = match.capturedEnd();
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	278 while (match.hasMatch() && cursor != -1) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	279 /* We've matched a question pattern. With the answer
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	280 line */
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	281 if (!match.lastCapturedIndex() == 2) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	282 /* Should not happen without misconfiguration. */
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	283 mErrors << "Internal parser error.";
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	284 return;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	285 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	286 foundSomething = true;
78 f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	287 /* A question is everything until the last two newlines
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	288 * before an answer line.*/
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	289 QString question;
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	290
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	291 int lastBreaks = input.lastIndexOf(QStringLiteral("\n\n"), cursor);
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	292 if (lastBreaks == -1) {
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	293 /* First question */
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	294 lastBreaks = 0;
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	295 }
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	296
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	297 question = input.mid(lastBreaks, match.capturedStart() - lastBreaks);
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	298 qDebug() << "Found question: " << question;
f230ed9022e0 Rework questions to new logic for multilne questions Andre Heinecke <andre.heinecke@intevation.de> parents: 76 diff changeset	299 const QString answerLine = match.captured(1).trimmed();
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	300 xlsx.write(row, 2, QString(" "), mQuestionFmt);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	301 xlsx.write(row, 3, QString(" "), mQuestionFmt);
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	302 xlsEscape(question);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	303 xlsx.write(row++, 1, question, mQuestionFmt);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	304 html << mQuestionStyle.arg(question.toHtmlEscaped());
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	305
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	306 if (answerLine == QStringLiteral(CHOICE_IDENTIFIER)) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	307 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
21 0b66b10a287d Add german translation Andre Heinecke <andre.heinecke@intevation.de> parents: 20 diff changeset	308 xlsx.write(row++, 1, "Answer", mAnswerChoiceFmt);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	309 html << mAnswerChoiceStyle;
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	310 int firstChoiceRow = row;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	311 int lastChoiceRow = row;
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	312 repeat:
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	313 QRegularExpressionMatch choiceMatch = choiceEx.match(input, cursor);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	314 while (choiceMatch.hasMatch() && choiceMatch.capturedStart() == cursor + 1) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	315 /* We use the cursor here to keep track of the state. Only if an answer
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	316 follows immediately behind the last answer we treat it as valid as
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	317 otherwise we can't figure out when the next question begins. */
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	318 cursor = choiceMatch.capturedEnd();
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	319
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	320 /* Write the values */
12 21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	321 QString choiceName = choiceMatch.captured(1).trimmed();
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	322 xlsEscape(choiceName);
12 21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	323 xlsx.write(row, 1, choiceName, mChoiceTextFmt);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	324 html << mChoiceTextStyle.arg(choiceName.toHtmlEscaped());
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	325 qDebug() << "Captured for choice: " << choiceMatch.captured(0);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	326 bool ok;
56 5410f9f279ea Redefine question pattern to be more robust Andre Heinecke <andre.heinecke@intevation.de> parents: 55 diff changeset	327 QString percentStr = choiceMatch.captured("percent");
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	328 double percent;
63 4d65e654abf7 Converter: Handle empty percent strings again Andre Heinecke <andre.heinecke@intevation.de> parents: 56 diff changeset	329 if (percentStr.isEmpty()) {
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	330 percent = 0;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	331 ok = true;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	332 } else {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	333 percent = percentStr.toDouble(&ok);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	334 }
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	335 if (!ok) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	336 mErrors << "Unparsable number in string: " + choiceMatch.captured();
63 4d65e654abf7 Converter: Handle empty percent strings again Andre Heinecke <andre.heinecke@intevation.de> parents: 56 diff changeset	337 percent = 0;
4d65e654abf7 Converter: Handle empty percent strings again Andre Heinecke <andre.heinecke@intevation.de> parents: 56 diff changeset	338 percentStr = QString();
4d65e654abf7 Converter: Handle empty percent strings again Andre Heinecke <andre.heinecke@intevation.de> parents: 56 diff changeset	339 /* PercentStr was not a number. */
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	340 }
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	341 makeBar(html, percent, doc);
39 41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	342 xlsx.write(row, 2, percent == 0 ? QVariant() : percent);
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	343 const QString numStr = choiceMatch.captured("num");
89 80ff6591101a Fix numVotesString containing spaces in xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 86 diff changeset	344 const QString numVotesStringHtml = QString("%1% \| %2 Number of votes").
81 f3481e9e44b2 Pre align number of votes Andre Heinecke <andre.heinecke@intevation.de> parents: 80 diff changeset	345 arg(percentStr.isEmpty() ? QStringLiteral("0") : percentStr, 8).
f3481e9e44b2 Pre align number of votes Andre Heinecke <andre.heinecke@intevation.de> parents: 80 diff changeset	346 arg(numStr.isEmpty() ? QStringLiteral("0") : numStr, 3);
89 80ff6591101a Fix numVotesString containing spaces in xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 86 diff changeset	347 const QString numVotesStringXls = QString("%1% \| %2 Number of votes").
80ff6591101a Fix numVotesString containing spaces in xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 86 diff changeset	348 arg(percentStr.isEmpty() ? QStringLiteral("0") : percentStr).
80ff6591101a Fix numVotesString containing spaces in xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 86 diff changeset	349 arg(numStr.isEmpty() ? QStringLiteral("0") : numStr);
80ff6591101a Fix numVotesString containing spaces in xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 86 diff changeset	350 html << mChoiceVotesStyle.arg(numVotesStringHtml);
80ff6591101a Fix numVotesString containing spaces in xlsx Andre Heinecke <andre.heinecke@intevation.de> parents: 86 diff changeset	351 xlsx.write(row, 3, numVotesStringXls, mChoiceVotesFmt);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	352 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	353 /* As long as we can match a choice which is either before the next question
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	354 or before the end of the document */
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	355 choiceMatch = choiceEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	356 row++;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	357 lastChoiceRow++;
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	358 }
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	359 choiceMatch = choiceAltEx.match(input, cursor);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	360 bool additionalFound = false;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	361 while (choiceMatch.hasMatch() && choiceMatch.capturedStart() <= cursor + 1) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	362 additionalFound = true;
65 defd29b9f25a Converter: Unescape IMG and Latex references Andre Heinecke <andre.heinecke@intevation.de> parents: 63 diff changeset	363 QString choice = choiceMatch.captured(1);
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	364 cursor = choiceMatch.capturedEnd();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	365 /* Alternative answer that is just a list of strings */
70 3438f5cce8cc Force text codec for html to use UTF-8 Andre Heinecke <andre.heinecke@intevation.de> parents: 69 diff changeset	366 qDebug() << "Captured unfilled choice: " << choice;
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	367 html << mChoiceTextStyle.arg(choice.toHtmlEscaped());
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	368 makeBar(html, 0, doc);
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	369 xlsEscape(choice);
71 7e195eacb0da Acutally write unfilled choices in XLSX Andre Heinecke <andre.heinecke@intevation.de> parents: 70 diff changeset	370 xlsx.write(row, 1, choice);
39 41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	371 xlsx.write(row, 2, QVariant());
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	372 const QString numVotesString = QStringLiteral("Keine eingegangenen Antworten");
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	373 html << mChoiceVotesStyle.arg(numVotesString.toHtmlEscaped());
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	374 xlsx.write(row, 3, numVotesString, mChoiceVotesFmt);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	375 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	376 row++;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	377 lastChoiceRow++;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	378 choiceMatch = choiceAltEx.match(input, cursor);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	379 QRegularExpressionMatch realMatch = choiceEx.match(input, cursor);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	380 if (choiceMatch.hasMatch() && choiceMatch.capturedStart() == realMatch.capturedStart()) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	381 /* We have a real match so back to the other pattern. */
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	382 break;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	383 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	384 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	385 if (additionalFound) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	386 goto repeat;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	387 }
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	388 bars.addRange(QString("B%1:B%2").arg(firstChoiceRow).arg(lastChoiceRow));
13 101ee762f021 Add commented out Grouping Andre Heinecke <andre.heinecke@intevation.de> parents: 12 diff changeset	389 // xlsx.groupRows(firstChoiceRow - 2, lastChoiceRow - 1, false);
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	390 } else if (answerLine == QStringLiteral(TEXT_IDENTIFIER)) {
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	391 QRegularExpressionMatch textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	392 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
21 0b66b10a287d Add german translation Andre Heinecke <andre.heinecke@intevation.de> parents: 20 diff changeset	393 xlsx.write(row++, 1, "Answer", mAnswerTextFmt);
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	394 html << mAnswerTextStyle;
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	395
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	396 /* To handle the workaround for quotes in answers we store
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	397 * the number of rows and only afterwards create the html rows. */
927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	398 int firstFreeRow = row;
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	399 while (textMatch.hasMatch()) {
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	400 if (textMatch.capturedStart() != cursor + 1) {
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	401 /* The format allows unescaped quotes in the text.
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	402 This makes a workaround neccessary. If we have
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	403 an Unquoted string between the next quoted string
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	404 and that Unquoted string is before the next question
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	405 we append the unquoted string and the next quoted string
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	406 with Quotes in the Row.*/
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	407 QRegularExpressionMatch nextQuestion = questionEx.match(input, cursor);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	408 if (nextQuestion.hasMatch() &&
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	409 nextQuestion.capturedStart() < textMatch.capturedEnd()) {
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	410 /* The next question comes before the textMatch so we really have
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	411 a new question. */
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	412 break;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	413 }
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	414 const QString lastRow = xlsx.read(row - 1, 26).toString();
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	415 int unquotedLen = textMatch.capturedStart() - cursor;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	416 const QString unquoted = input.mid(cursor, unquotedLen);
82 9e3c05a03a6f Check for double newline in unquoted strings Andre Heinecke <andre.heinecke@intevation.de> parents: 81 diff changeset	417 if (unquoted.startsWith("\n\n")) {
9e3c05a03a6f Check for double newline in unquoted strings Andre Heinecke <andre.heinecke@intevation.de> parents: 81 diff changeset	418 qDebug() << "Double newline outside quote. Assuming a question follows.";
9e3c05a03a6f Check for double newline in unquoted strings Andre Heinecke <andre.heinecke@intevation.de> parents: 81 diff changeset	419 break;
9e3c05a03a6f Check for double newline in unquoted strings Andre Heinecke <andre.heinecke@intevation.de> parents: 81 diff changeset	420 }
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	421 qDebug() << "Found inner quoted string: " << unquoted;
83 f505df84380d Update l10n Andre Heinecke <andre.heinecke@intevation.de> parents: 82 diff changeset	422
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	423 /* Now combine */
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	424 QString combined = QString("%1\"%2\"%3").arg(lastRow).
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	425 arg(unquoted).
1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	426 arg(textMatch.captured(1).trimmed());
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	427 qDebug() << "Last row: " << lastRow;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	428 qDebug() << "Next Question is at: " << nextQuestion.capturedStart();
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	429 qDebug() << "Text match is: " << textMatch.captured(1).trimmed();
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	430 qDebug() << "cursor is at: " << cursor;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	431 qDebug() << "text match starts at: " << textMatch.capturedStart();
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	432 xlsEscape(combined);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	433 xlsx.write(row - 1, 26, combined, mFreeTextFmt);
12 21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	434 xlsx.write(row - 1, 1, combined, mFreeTextFmt);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	435 cursor = textMatch.capturedEnd();
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	436 textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	437 continue;
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	438 }
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	439 cursor = textMatch.capturedEnd();
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	440
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	441 QString text = textMatch.captured(1).trimmed();
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	442 qDebug() << "Found free text: " << text;
12 21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	443 if (text.startsWith("=")) {
21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	444 text = " " + text;
21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	445 }
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	446
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	447 /* Merge the cells */
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	448 xlsx.mergeCells(QString("A%1:C%1").arg(row), mFreeTextFmt);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	449
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	450 /* Merged cells ignore wordwrap the following trick is based on:
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	451 http://excel.tips.net/T003207_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap.html
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	452 */
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	453 /* Write the values */
76 1e6e7699f0b8 Add replacements.ini to configure text replacements Andre Heinecke <andre.heinecke@intevation.de> parents: 75 diff changeset	454 xlsEscape(text);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	455 xlsx.write(QString("Z%1").arg(row), text, mFreeTextFmt);
12 21f11f988115 Make sure strings don't start with = and duplicate text instead of formula Andre Heinecke <andre.heinecke@intevation.de> parents: 6 diff changeset	456 xlsx.write(row, 1, text, mFreeTextFmt);
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	457 row++;
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	458
6 a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	459 textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling Andre Heinecke <andre.heinecke@intevation.de> parents: 3 diff changeset	460 }
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	461 for (int i = firstFreeRow; i < row; i++) {
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	462 html << mFreeTextStyle.arg(xlsx.read(i, 1).toString().toHtmlEscaped());
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	463 }
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	464 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	465 /* Insert Empty row. */
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	466 xlsx.setRowHeight(row++, CHOICE_ROW_HEIGHT);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	467 match = questionEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	468 cursor = match.capturedEnd();
25 e5c5ebfa4205 Refactor to centralise html tags Andre Heinecke <andre.heinecke@intevation.de> parents: 23 diff changeset	469 html << mEmptyRow;
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	470 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	471 xlsx.addConditionalFormatting(bars);
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	472
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	473 if (!foundSomething) {
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	474 mErrors << tr("Failed to parse input document.");
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	475 }
8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	476
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	477 html << "</table></body></html>";
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	478 doc.setHtml(htmlString);
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	479
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	480 /* Fixup images for html */
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	481 QRegularExpression htmlRe = QRegularExpression("<td style='vertical-align: middle'><img src=\"internal://bar(\\d+).png\"/></td>");
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	482 htmlString.replace(htmlRe, QStringLiteral("<td style='background:linear-gradient(to right,"
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	483 BAR_COLOR ", " BAR_COLOR " \\1%, #ffffff \\1%)'></td>"));
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	484
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	485 foreach (QFile *output, outputs) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	486 const QString fName = output->fileName().toLower();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	487 if (fName.endsWith(".html")) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	488 QTextStream outstream(output);
70 3438f5cce8cc Force text codec for html to use UTF-8 Andre Heinecke <andre.heinecke@intevation.de> parents: 69 diff changeset	489 outstream.setCodec("UTF-8");
38 5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	490 outstream << htmlString;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	491 output->close();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	492 } else if (fName.endsWith(".pdf")) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	493 output->close();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	494 QPrinter printer(QPrinter::PrinterResolution);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	495 printer.setOutputFormat(QPrinter::PdfFormat);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	496 printer.setPaperSize(QPrinter::A4);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	497 printer.setOutputFileName(output->fileName());
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	498 /*
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	499 QPageLayout layout = printer.pageLayout();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	500 layout.setUnits(QPageLayout::Millimeter);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	501 layout.setMargins(QMarginsF(20, 20, 20, 20));
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	502 printer.setPageLayout(layout);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	503 doc.setPageSize(printer.pageRect().size());
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	504 */
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	505 doc.print(&printer);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	506 } else {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	507 if (!xlsx.saveAs(output)) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	508 mErrors << tr("Saving the XLSX document failed.");
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	509 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	510 output->close();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling. Andre Heinecke <andre.heinecke@intevation.de> parents: 35 diff changeset	511 }
23 927794e3cc52 Add HTML output and some pdf support Andre Heinecke <andre.heinecke@intevation.de> parents: 21 diff changeset	512 }
3 8b4c49c92451 Add initial implementation that handles choices Andre Heinecke <andre.heinecke@intevation.de> parents: diff changeset	513 }

Mercurial > clickerconvert > clickerconvert

annotate src/converter.cpp @ 97:ccd1dbea2536