Mercurial > clickerconvert

annotate src/converter.cpp @ 76:1e6e7699f0b8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add replacements.ini to configure text replacements
author Andre Heinecke <andre.heinecke@intevation.de>
date Wed, 05 Oct 2016 14:23:23 +0200
parents 92139cc60121
children f230ed9022e0
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>");
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
76 mChoiceVotesStyle = QStringLiteral("<td style='text-align: left;vertical-algin: center;"
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
77 "font-size:10pt;'</td>%1</td></tr>");
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
78 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
79 "font-size:11pt;'>Answer<hr/></td></tr>");
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
80 mFreeTextStyle = QStringLiteral("<tr><td colspan='3'; font-size:11pt;'>%1<hr/></td></tr>");
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
81 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
82 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
83
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
84 void Converter::run()
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
85 {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
86 QFile infile;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
87
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
88 if (mInput.isEmpty()) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
89 if (!infile.open(stdin, QIODevice::ReadOnly)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
90 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
91 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
92 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
93 } else {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
94 infile.setFileName(mInput);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
95 if (!infile.open(QIODevice::ReadOnly)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
96 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
97 return;
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 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
100 QTextStream instream(&infile);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
101
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
102 QList<QFile*> outfiles;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
103
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
104 if (mOutputs.isEmpty()) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
105 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
106 if (!outfile->open(stdout, QIODevice::WriteOnly)) {
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
107 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
108 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
109 }
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
110 outfiles << outfile;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
111 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
112 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
113 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
114 outfile->setFileName(fileName);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
115 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
116 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
117 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
118 }
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
119 outfiles << outfile;
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
120 }
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
121 convertToXSLX(instream, outfiles);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
122 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
123
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
124 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
125 {
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
126 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
127 QPainter painter(&image);
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
128 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
129 if (percent) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
130 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
131 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
132 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
133 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
134 rect.setRight(IMAGE_WIDTH);
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
135 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
136 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
137 QVariant(image));
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
138 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
139 return;
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
140 }
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
141
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
142 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
143 {
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
144 QFile file(path);
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
145 QMap<QRegularExpression*, QString> ret;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
146
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
147 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
148 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
149 return ret;
65
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
150 }
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
151
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
152 while (!file.atEnd()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
153 const auto line = file.readLine();
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
154 auto strline = QString::fromUtf8(line).trimmed();
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
155 if (strline.startsWith(QStringLiteral(";")) || strline.isEmpty()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
156 continue;
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
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
159 auto split = strline.split("=");
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
160 if (split.count() != 2) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
161 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
162 continue;
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
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
165 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
166 if (!exp->isValid()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
167 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
168 "\n" + QObject::tr("Error: ") + exp->errorString();
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
169 continue;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
170 }
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
171 const auto rep = split[1].replace("\"", "");
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
172 ret.insert(exp, rep);
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
173 qDebug() << "Loaded replacement: " << *exp << " replacement:" << rep << "";
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
174 }
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
175 /* 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
176 ret.insert(new QRegularExpression("^="), " =");
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
177 return ret;
65
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
178 }
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
179
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
180 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
181 {
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
182 QMap<QRegularExpression*, QString> regexs;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
183 /* 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
184 auto ourDir = QDir(QCoreApplication::applicationDirPath());
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
185 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
186 if (ourDir.exists(filename)) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
187 regexs = loadExpressionsFromFile(ourDir.filePath(filename), errors);
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
188 return regexs;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
189 }
65
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
190
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
191 /* Look in ../share/apps/PROJECT_NAME */
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());
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
193 if (ourDir.exists(filename)) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
194 regexs = loadExpressionsFromFile(ourDir.filePath(filename), errors);
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
195 } else {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
196 qDebug() << "Failed to find regular expressions.";
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
197 }
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
198 return regexs;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
199 }
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 static const QStringList sanitizeInput(QString &str)
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 QStringList errors;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
204 str.replace("\r\n", "\n");
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
205 str.replace("\n\r", "\n");
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
206 const auto expressions = loadExpressions(errors);
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
207 for (const auto regex: expressions.keys()) {
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
208 str.replace(*regex, expressions.value(regex));
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
209 delete regex;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
210 }
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
211 return errors;
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
212 }
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 static void xlsEscape(QString &str)
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
215 {
74
9a2e35a7c19c Also escape leading equal sign in questions / choices
Andre Heinecke <andre.heinecke@intevation.de>
parents: 73
diff changeset
216 if (str.startsWith("=")) {
9a2e35a7c19c Also escape leading equal sign in questions / choices
Andre Heinecke <andre.heinecke@intevation.de>
parents: 73
diff changeset
217 str = " " + str;
9a2e35a7c19c Also escape leading equal sign in questions / choices
Andre Heinecke <andre.heinecke@intevation.de>
parents: 73
diff changeset
218 }
65
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
219 }
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
220
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
221 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
222 {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
223 Document xlsx;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
224 QTextDocument doc;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
225 QString htmlString;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
226 QTextStream html (&htmlString);
70
3438f5cce8cc Force text codec for html to use UTF-8
Andre Heinecke <andre.heinecke@intevation.de>
parents: 69
diff changeset
227 html.setCodec("UTF-8");
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
228
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
229 ConditionalFormatting bars;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
230
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
231 bars.addDataBarRule(QColor(0xFF, 0x99, 0x33), ConditionalFormatting::VOT_Num,
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
232 "0", ConditionalFormatting::VOT_Num, "100", false);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
233
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
234 const double colWidth[] = COLUMN_WIDTHS;
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
235 double sum = 0;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
236
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
237 for (int i = 1; i <= COLUMN_CNT; i++) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
238 xlsx.setColumnWidth(i, colWidth[i-1]);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
239 sum += colWidth[i-1];
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
240 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
241
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
242 /* For the merged cell wordwrap trick. */
15
03dad1cff5b9 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 13
diff changeset
243 xlsx.setColumnWidth(26, sum + 1);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
244 xlsx.setColumnHidden(26, true);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
245
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
246 int row = 1;
70
3438f5cce8cc Force text codec for html to use UTF-8
Andre Heinecke <andre.heinecke@intevation.de>
parents: 69
diff changeset
247 html << "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html;charset=UTF-8\"/>"
3438f5cce8cc Force text codec for html to use UTF-8
Andre Heinecke <andre.heinecke@intevation.de>
parents: 69
diff changeset
248 "</head><body><table border=\"0\" width:\"100%\">";
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
249 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
250 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
251 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
252
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
253 const QString title = mTitle.isEmpty() ? DEFAULT_TITLE : mTitle;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
254 // Set the title of the Questionaire
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
255 xlsx.write(row++, 1, title, mTitleFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
256 html << mTitleStyle.arg(title.toHtmlEscaped());
20
df7936065450 Add default title
Andre Heinecke <andre.heinecke@intevation.de>
parents: 15
diff changeset
257 xlsx.mergeCells("A1:C1");
df7936065450 Add default title
Andre Heinecke <andre.heinecke@intevation.de>
parents: 15
diff changeset
258 xlsx.setRowHeight(1, TITLE_ROW_HEIGHT);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
259
43
f9a0b2b6832e Sanitize input and unify Lineendings
Andre Heinecke <andre.heinecke@intevation.de>
parents: 41
diff changeset
260 QString input = instream.readAll();
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
261
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
262 QRegularExpression questionEx(QUESTION_PATTERN);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
263 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
264 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
265 QRegularExpression freetxtEx(FREETXT_PATTERN);
56
5410f9f279ea Redefine question pattern to be more robust
Andre Heinecke <andre.heinecke@intevation.de>
parents: 55
diff changeset
266 QRegularExpression firstQuestionEx(FIRST_QUESTION_PATTERN);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
267
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
268 mErrors += sanitizeInput(input);
43
f9a0b2b6832e Sanitize input and unify Lineendings
Andre Heinecke <andre.heinecke@intevation.de>
parents: 41
diff changeset
269
56
5410f9f279ea Redefine question pattern to be more robust
Andre Heinecke <andre.heinecke@intevation.de>
parents: 55
diff changeset
270 QRegularExpressionMatch match = firstQuestionEx.match(input);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
271 bool foundSomething = false;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
272 int cursor = match.capturedEnd();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
273 while (match.hasMatch() && cursor != -1) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
274 /* 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
275 line */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
276 if (!match.lastCapturedIndex() == 2) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
277 /* Should not happen without misconfiguration. */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
278 mErrors << "Internal parser error.";
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
279 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
280 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
281 foundSomething = true;
75
92139cc60121 Treat everything from the start of the document as the first question
Andre Heinecke <andre.heinecke@intevation.de>
parents: 74
diff changeset
282 /* For some reason the regular expression used is not
92139cc60121 Treat everything from the start of the document as the first question
Andre Heinecke <andre.heinecke@intevation.de>
parents: 74
diff changeset
283 * greedy enough if there are multiple question lines
92139cc60121 Treat everything from the start of the document as the first question
Andre Heinecke <andre.heinecke@intevation.de>
parents: 74
diff changeset
284 * before the first Answer. */
92139cc60121 Treat everything from the start of the document as the first question
Andre Heinecke <andre.heinecke@intevation.de>
parents: 74
diff changeset
285 QString question = input.left(match.capturedStart() +
92139cc60121 Treat everything from the start of the document as the first question
Andre Heinecke <andre.heinecke@intevation.de>
parents: 74
diff changeset
286 match.captured(1).size());
65
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
287 unescapeString(question);
75
92139cc60121 Treat everything from the start of the document as the first question
Andre Heinecke <andre.heinecke@intevation.de>
parents: 74
diff changeset
288 qDebug() << "First question: " << question;
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
289 const QString answerLine = match.captured(2).trimmed();
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
290 xlsx.write(row, 2, QString(" "), mQuestionFmt);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
291 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
292 xlsEscape(question);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
293 xlsx.write(row++, 1, question, mQuestionFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
294 html << mQuestionStyle.arg(question.toHtmlEscaped());
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
295
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
296 if (answerLine == QStringLiteral(CHOICE_IDENTIFIER)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
297 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
21
0b66b10a287d Add german translation
Andre Heinecke <andre.heinecke@intevation.de>
parents: 20
diff changeset
298 xlsx.write(row++, 1, "Answer", mAnswerChoiceFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
299 html << mAnswerChoiceStyle;
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
300 int firstChoiceRow = row;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
301 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
302 repeat:
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
303 QRegularExpressionMatch choiceMatch = choiceEx.match(input, cursor);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
304 while (choiceMatch.hasMatch() && choiceMatch.capturedStart() == cursor + 1) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
305 /* 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
306 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
307 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
308 cursor = choiceMatch.capturedEnd();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
309
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
310 /* 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
311 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
312 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
313 xlsx.write(row, 1, choiceName, mChoiceTextFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
314 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
315 qDebug() << "Captured for choice: " << choiceMatch.captured(0);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
316 bool ok;
56
5410f9f279ea Redefine question pattern to be more robust
Andre Heinecke <andre.heinecke@intevation.de>
parents: 55
diff changeset
317 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
318 double percent;
63
4d65e654abf7 Converter: Handle empty percent strings again
Andre Heinecke <andre.heinecke@intevation.de>
parents: 56
diff changeset
319 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
320 percent = 0;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
321 ok = true;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
322 } else {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
323 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
324 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
325 if (!ok) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
326 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
327 percent = 0;
4d65e654abf7 Converter: Handle empty percent strings again
Andre Heinecke <andre.heinecke@intevation.de>
parents: 56
diff changeset
328 percentStr = QString();
4d65e654abf7 Converter: Handle empty percent strings again
Andre Heinecke <andre.heinecke@intevation.de>
parents: 56
diff changeset
329 /* PercentStr was not a number. */
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
330 }
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
331 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
332 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
333 const QString numStr = choiceMatch.captured("num");
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
334 const QString numVotesString = QString("%1% | %2 Number of votes").
55
aaaf8cdbc85c Make percent string formatting more flexible
Andre Heinecke <andre.heinecke@intevation.de>
parents: 43
diff changeset
335 arg(percentStr.isEmpty() ? QStringLiteral("0") : percentStr).
aaaf8cdbc85c Make percent string formatting more flexible
Andre Heinecke <andre.heinecke@intevation.de>
parents: 43
diff changeset
336 arg(numStr.isEmpty() ? QStringLiteral("0") : numStr);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
337 html << mChoiceVotesStyle.arg(numVotesString.toHtmlEscaped());
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
338 xlsx.write(row, 3, numVotesString, mChoiceVotesFmt);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
339 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
340 /* 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
341 or before the end of the document */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
342 choiceMatch = choiceEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
343 row++;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
344 lastChoiceRow++;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
345 }
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
346 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
347 bool additionalFound = false;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
348 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
349 additionalFound = true;
65
defd29b9f25a Converter: Unescape IMG and Latex references
Andre Heinecke <andre.heinecke@intevation.de>
parents: 63
diff changeset
350 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
351 cursor = choiceMatch.capturedEnd();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
352 /* 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
353 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
354 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
355 makeBar(html, 0, doc);
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
356 xlsEscape(choice);
71
7e195eacb0da Acutally write unfilled choices in XLSX
Andre Heinecke <andre.heinecke@intevation.de>
parents: 70
diff changeset
357 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
358 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
359 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
360 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
361 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
362 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
363 row++;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
364 lastChoiceRow++;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
365 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
366 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
367 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
368 /* 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
369 break;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
370 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
371 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
372 if (additionalFound) {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
373 goto repeat;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
374 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
375 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
376 // xlsx.groupRows(firstChoiceRow - 2, lastChoiceRow - 1, false);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
377 } else if (answerLine == QStringLiteral(TEXT_IDENTIFIER)) {
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
378 QRegularExpressionMatch textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
379 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
21
0b66b10a287d Add german translation
Andre Heinecke <andre.heinecke@intevation.de>
parents: 20
diff changeset
380 xlsx.write(row++, 1, "Answer", mAnswerTextFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
381 html << mAnswerTextStyle;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
382
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
383 /* 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
384 * 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
385 int firstFreeRow = row;
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
386 while (textMatch.hasMatch()) {
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
387 if (textMatch.capturedStart() != cursor + 1) {
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
388 /* The format allows unescaped quotes in the text.
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
389 This makes a workaround neccessary. If we have
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
390 an Unquoted string between the next quoted string
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
391 and that Unquoted string is before the next question
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
392 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
393 with Quotes in the Row.*/
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
394 QRegularExpressionMatch nextQuestion = questionEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
395 if (nextQuestion.hasMatch() &&
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
396 nextQuestion.capturedStart() < textMatch.capturedEnd()) {
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
397 /* 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
398 a new question. */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
399 break;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
400 }
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
401 const QString lastRow = xlsx.read(row - 1, 26).toString();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
402 int unquotedLen = textMatch.capturedStart() - cursor;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
403 const QString unquoted = input.mid(cursor, unquotedLen);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
404 qDebug() << "Found inner quoted string: " << unquoted;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
405 /* Now combine */
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
406 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
407 arg(unquoted).
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
408 arg(textMatch.captured(1).trimmed());
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
409 qDebug() << "Last row: " << lastRow;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
410 qDebug() << "Next Question is at: " << nextQuestion.capturedStart();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
411 qDebug() << "Text match is: " << textMatch.captured(1).trimmed();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
412 qDebug() << "cursor is at: " << cursor;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
413 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
414 xlsEscape(combined);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
415 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
416 xlsx.write(row - 1, 1, combined, mFreeTextFmt);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
417 cursor = textMatch.capturedEnd();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
418 textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
419 continue;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
420 }
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
421 cursor = textMatch.capturedEnd();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
422
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
423 QString text = textMatch.captured(1).trimmed();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
424 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
425 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
426 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
427 }
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
428
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
429 /* Merge the cells */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
430 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
431
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
432 /* 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
433 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
434 */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
435 /* Write the values */
76
1e6e7699f0b8 Add replacements.ini to configure text replacements
Andre Heinecke <andre.heinecke@intevation.de>
parents: 75
diff changeset
436 xlsEscape(text);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
437 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
438 xlsx.write(row, 1, text, mFreeTextFmt);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
439 row++;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
440
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
441 textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
442 }
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
443 for (int i = firstFreeRow; i < row; i++) {
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
444 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
445 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
446 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
447 /* Insert Empty row. */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
448 xlsx.setRowHeight(row++, CHOICE_ROW_HEIGHT);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
449 match = questionEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
450 cursor = match.capturedEnd();
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
451 html << mEmptyRow;
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
452 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
453 xlsx.addConditionalFormatting(bars);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
454
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
455 if (!foundSomething) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
456 mErrors << tr("Failed to parse input document.");
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
457 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
458
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
459 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
460 doc.setHtml(htmlString);
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
461
38
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
462 /* 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
463 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
464 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
465 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
466
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
467 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
468 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
469 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
470 QTextStream outstream(output);
70
3438f5cce8cc Force text codec for html to use UTF-8
Andre Heinecke <andre.heinecke@intevation.de>
parents: 69
diff changeset
471 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
472 outstream << htmlString;
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
473 output->close();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
474 } 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
475 output->close();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
476 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
477 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
478 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
479 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
480 /*
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
481 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
482 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
483 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
484 printer.setPageLayout(layout);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
485 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
486 */
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
487 doc.print(&printer);
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
488 } else {
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
489 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
490 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
491 }
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
492 output->close();
5354cbda7188 Fix HTML Layout. Support multiple formats at once. More handling.
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
493 }
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
494 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
495 }
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)