Mercurial > clickerconvert

annotate src/converter.cpp @ 39:41cd27a64365

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Write empty columns for XSLX to avoid strange 0 formatting Excel shows a pretty large bar for zero values
author Andre Heinecke <andre.heinecke@intevation.de>
date Fri, 15 Apr 2016 15:24:07 +0200
parents ca66763b6524
children f6c53e896008
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>
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
17
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
18 #include "xlsxdocument.h"
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
19 #include "xlsxconditionalformatting.h"
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
20
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
21 #include "constants.h"
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
22
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
23 QTXLSX_USE_NAMESPACE
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 Converter::Converter(const QString &input, const QString &output,
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
26 ConvertFormat fmt, const QString &title):
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
27 QThread(Q_NULLPTR),
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
28 mInput(input),
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
29 mOutput(output),
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
30 mFmt(fmt),
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
31 mTitle(title)
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
32 {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
33 mTitleFmt.setFontUnderline(Format::FontUnderlineSingle);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
34 mTitleFmt.setFontSize(18);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
35 mTitleFmt.setFontName("Calibri");
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
36 mTitleFmt.setFontBold(true);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
37 mTitleFmt.setVerticalAlignment(Format::AlignTop);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
38
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
39
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
40 mQuestionFmt.setFontSize(11);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
41 mQuestionFmt.setFontName("Calibri");
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
42 mQuestionFmt.setFontBold(true);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
43 mQuestionFmt.setTopBorderStyle(Format::BorderThin);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
44 mQuestionFmt.setBottomBorderStyle(Format::BorderThin);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
45 mQuestionFmt.setTextWarp(true);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
46
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
47 mAnswerChoiceFmt.setFontSize(11);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
48 mAnswerChoiceFmt.setFontName("Calibri");
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
49 mAnswerChoiceFmt.setHorizontalAlignment(Format::AlignLeft);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
50 mAnswerChoiceFmt.setTextWarp(true);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
51
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
52 mChoiceTextFmt = mAnswerChoiceFmt;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
53 mChoiceTextFmt.setVerticalAlignment(Format::AlignVCenter);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
54
15
03dad1cff5b9 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 13
diff changeset
55 mChoiceVotesFmt = mChoiceTextFmt;
03dad1cff5b9 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 13
diff changeset
56 mChoiceVotesFmt.setFontSize(10);
03dad1cff5b9 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 13
diff changeset
57
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
58 mFreeTextFmt = mQuestionFmt;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
59 mFreeTextFmt.setFontBold(false);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
60
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
61 mAnswerTextFmt = mQuestionFmt;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
62 mAnswerTextFmt.setVerticalAlignment(Format::AlignVCenter);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
63 mAnswerTextFmt.setHorizontalAlignment(Format::AlignLeft);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
64
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
65 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
66 "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
67 "%1</td></tr><tr/>");
32
ad54c98cb8d8 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 26
diff changeset
68 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
69 "><hr/>%1<hr/></td></tr>");
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
70 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
71 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
72 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
73 "font-size:10pt;'</td>%1</td></tr>");
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
74 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
75 "font-size:11pt;'>Answer<hr/></td></tr>");
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
76 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
77 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
78 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
79
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
80 void Converter::run()
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 QFile infile;
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 if (mInput.isEmpty()) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
85 if (!infile.open(stdin, QIODevice::ReadOnly)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
86 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
87 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
88 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
89 } else {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
90 infile.setFileName(mInput);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
91 if (!infile.open(QIODevice::ReadOnly)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
92 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
93 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
94 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
95 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
96 QTextStream instream(&infile);
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 QFile outfile;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
99 if (mOutput.isEmpty()) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
100 if (!outfile.open(stdout, QIODevice::WriteOnly)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
101 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
102 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
103 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
104 } else {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
105 outfile.setFileName(mOutput);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
106 if (!outfile.open(QIODevice::WriteOnly)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
107 mErrors << tr("Failed to open %1 for writing.").arg(mOutput);
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 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
110 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
111 convertToXSLX(instream, outfile);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
112 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
113
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
114 static void makeBar(QTextStream &html, double percent, int width, QTextDocument &doc, bool forPDF)
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
115 {
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
116 static int barCnt;
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
117 if (!forPDF) {
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
118 html << QStringLiteral("<td style='background:linear-gradient(to right,"
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
119 BAR_COLOR ", " BAR_COLOR " %1%, #ffffff %1%)'></td>").arg(percent);
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
120 return;
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
121 }
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
122 QImage image(QSize(width, 25), QImage::Format_RGB32);
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
123 QPainter painter(&image);
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
124 QRect rect = image.rect();
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
125 qDebug() << "Image of " << width;
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
126 rect.setRight(rect.right() / (100 / percent));
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
127 painter.fillRect(rect, QColor(BAR_COLOR));
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
128 qDebug() << "Filled " << rect << " with color";
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
129 rect.setLeft(rect.right());
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
130 rect.setRight(width);
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
131 painter.fillRect(rect, Qt::white);
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
132 qDebug() << "Filled " << rect << " with white";
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
133 doc.addResource(QTextDocument::ImageResource, QUrl(QStringLiteral("internal://bar%1.png").arg(barCnt)),
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
134 QVariant(image));
32
ad54c98cb8d8 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 26
diff changeset
135 html << QStringLiteral("<td style='vertical-align: middle'><img src=\"internal://bar%1.png\"/></td>").arg(barCnt++);
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
136 image.save(QStringLiteral("/tmp/foo.png"));
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
137 return;
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
138 }
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
139
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
140 void Converter::convertToXSLX(QTextStream& instream, QFile &output)
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
141 {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
142 Document xlsx;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
143 QTextDocument doc;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
144 QString htmlString;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
145 QTextStream html (&htmlString);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
146
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
147 ConditionalFormatting bars;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
148
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
149 bars.addDataBarRule(QColor(0xFF, 0x99, 0x33), ConditionalFormatting::VOT_Num,
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
150 "0", ConditionalFormatting::VOT_Num, "100", false);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
151
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
152 const double colWidth[] = COLUMN_WIDTHS;
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
153 double sum = 0;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
154
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
155 for (int i = 1; i <= COLUMN_CNT; i++) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
156 xlsx.setColumnWidth(i, colWidth[i-1]);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
157 sum += colWidth[i-1];
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
158 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
159
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
160 double xlsx2htmlFactor = HTML_WIDTH / sum;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
161 int col1Width = colWidth[0] * xlsx2htmlFactor;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
162 int col2Width = colWidth[1] * xlsx2htmlFactor;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
163 int col3Width = colWidth[2] * xlsx2htmlFactor;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
164
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
165 /* For the merged cell wordwrap trick. */
15
03dad1cff5b9 Minor layout fixes
Andre Heinecke <andre.heinecke@intevation.de>
parents: 13
diff changeset
166 xlsx.setColumnWidth(26, sum + 1);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
167 xlsx.setColumnHidden(26, true);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
168
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
169 int row = 1;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
170 html << "<html><meta http-equiv=\"Content-Type\" content=\"text/html;charset=UTF-8\">"
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
171 "<body><table border=\"0\" style='width:\"" << HTML_WIDTH << "px\";border-collapse:collapse'>";
26
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
172 html << "<tr><th width=\"" << col1Width << "px\"</th>";
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
173 html << "<th width=\"" << col2Width << "px\"</th>";
5acd601356ba Make HTML work for QTextDocument
Andre Heinecke <andre.heinecke@intevation.de>
parents: 25
diff changeset
174 html << "<th width=\"" << col3Width << "px\"</th>";
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
175
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
176 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
177 // Set the title of the Questionaire
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
178 xlsx.write(row++, 1, title, mTitleFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
179 html << mTitleStyle.arg(title.toHtmlEscaped());
20
df7936065450 Add default title
Andre Heinecke <andre.heinecke@intevation.de>
parents: 15
diff changeset
180 xlsx.mergeCells("A1:C1");
df7936065450 Add default title
Andre Heinecke <andre.heinecke@intevation.de>
parents: 15
diff changeset
181 xlsx.setRowHeight(1, TITLE_ROW_HEIGHT);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
182
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
183 const QString input = instream.readAll();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
184
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
185 QRegularExpression questionEx(QUESTION_PATTERN);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
186 QRegularExpression choiceEx(CHOICE_PATTERN);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
187 QRegularExpression freetxtEx (FREETXT_PATTERN);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
188
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
189 QRegularExpressionMatch match = questionEx.match(input);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
190 bool foundSomething = false;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
191 int cursor = match.capturedEnd();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
192 while (match.hasMatch() && cursor != -1) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
193 /* 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
194 line */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
195 if (!match.lastCapturedIndex() == 2) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
196 /* Should not happen without misconfiguration. */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
197 mErrors << "Internal parser error.";
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
198 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
199 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
200 foundSomething = true;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
201 const QString question = match.captured(1).trimmed();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
202 const QString answerLine = match.captured(2).trimmed();
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
203 xlsx.write(row, 2, QString(" "), mQuestionFmt);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
204 xlsx.write(row, 3, QString(" "), mQuestionFmt);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
205 xlsx.write(row++, 1, question, mQuestionFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
206 html << mQuestionStyle.arg(question.toHtmlEscaped());
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
207
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
208 if (answerLine == QStringLiteral(CHOICE_IDENTIFIER)) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
209 QRegularExpressionMatch choiceMatch = choiceEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
210 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
21
0b66b10a287d Add german translation
Andre Heinecke <andre.heinecke@intevation.de>
parents: 20
diff changeset
211 xlsx.write(row++, 1, "Answer", mAnswerChoiceFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
212 html << mAnswerChoiceStyle;
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
213 int firstChoiceRow = row;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
214 int lastChoiceRow = row;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
215 while (choiceMatch.hasMatch() && choiceMatch.capturedStart() == cursor + 1) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
216 /* 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
217 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
218 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
219 cursor = choiceMatch.capturedEnd();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
220
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
221 /* 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
222 QString choiceName = choiceMatch.captured(1).trimmed();
21f11f988115 Make sure strings don't start with = and duplicate text instead of formula
Andre Heinecke <andre.heinecke@intevation.de>
parents: 6
diff changeset
223 if (choiceName.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
224 choiceName = " " + choiceName;
21f11f988115 Make sure strings don't start with = and duplicate text instead of formula
Andre Heinecke <andre.heinecke@intevation.de>
parents: 6
diff changeset
225 }
21f11f988115 Make sure strings don't start with = and duplicate text instead of formula
Andre Heinecke <andre.heinecke@intevation.de>
parents: 6
diff changeset
226 xlsx.write(row, 1, choiceName, mChoiceTextFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
227 html << mChoiceTextStyle.arg(choiceName.toHtmlEscaped());
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
228 bool ok;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
229 double percent = choiceMatch.captured(3).toDouble(&ok);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
230 if (!ok) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
231 mErrors << "Unparsable number in string: " + choiceMatch.captured();
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
232 }
39
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
233 makeBar(html, percent, doc);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
234 xlsx.write(row, 2, percent == 0 ? QVariant() : percent);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
235 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
236 const QString numVotesString = QString("%1% | %2 Number of votes").
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
237 arg(choiceMatch.captured(3)).arg(choiceMatch.captured(2));
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
238 html << mChoiceVotesStyle.arg(numVotesString.toHtmlEscaped());
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
239 xlsx.write(row, 3, numVotesString, mChoiceVotesFmt);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
240 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
241 /* 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
242 or before the end of the document */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
243 choiceMatch = choiceEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
244 row++;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
245 lastChoiceRow++;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
246 }
39
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
247 choiceMatch = choiceAltEx.match(input, cursor);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
248 bool additionalFound = false;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
249 while (choiceMatch.hasMatch() && choiceMatch.capturedStart() <= cursor + 1) {
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
250 additionalFound = true;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
251 const QString choice = choiceMatch.captured(1);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
252 cursor = choiceMatch.capturedEnd();
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
253 /* Alternative answer that is just a list of strings */
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
254 qDebug() << choiceAltEx.captureCount();
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
255 qDebug() << choiceMatch.captured(2);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
256 qDebug() << choiceMatch.capturedTexts();
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
257 qDebug() << "Caputured unfilled choice: " << choice;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
258 html << mChoiceTextStyle.arg(choice.toHtmlEscaped());
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
259 makeBar(html, 0, doc);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
260 xlsx.write(row, 2, QVariant());
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
261 const QString numVotesString = QStringLiteral("Keine eingegangenen Antworten");
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
262 html << mChoiceVotesStyle.arg(numVotesString.toHtmlEscaped());
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
263 xlsx.write(row, 3, numVotesString, mChoiceVotesFmt);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
264 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
265 row++;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
266 lastChoiceRow++;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
267 choiceMatch = choiceAltEx.match(input, cursor);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
268 QRegularExpressionMatch realMatch = choiceEx.match(input, cursor);
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
269 if (choiceMatch.hasMatch() && choiceMatch.capturedStart() == realMatch.capturedStart()) {
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
270 /* We have a real match so back to the other pattern. */
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
271 break;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
272 }
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
273 }
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
274 if (additionalFound) {
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
275 goto repeat;
41cd27a64365 Write empty columns for XSLX to avoid strange 0 formatting
Andre Heinecke <andre.heinecke@intevation.de>
parents: 35
diff changeset
276 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
277 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
278 // xlsx.groupRows(firstChoiceRow - 2, lastChoiceRow - 1, false);
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
279 } else if (answerLine == QStringLiteral(TEXT_IDENTIFIER)) {
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
280 QRegularExpressionMatch textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
281 xlsx.setRowHeight(row, CHOICE_ROW_HEIGHT);
21
0b66b10a287d Add german translation
Andre Heinecke <andre.heinecke@intevation.de>
parents: 20
diff changeset
282 xlsx.write(row++, 1, "Answer", mAnswerTextFmt);
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
283 html << mAnswerTextStyle;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
284
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
285 /* 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
286 * 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
287 int firstFreeRow = row;
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
288 while (textMatch.hasMatch()) {
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
289 if (textMatch.capturedStart() != cursor + 1) {
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
290 /* The format allows unescaped quotes in the text.
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
291 This makes a workaround neccessary. If we have
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
292 an Unquoted string between the next quoted string
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
293 and that Unquoted string is before the next question
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
294 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
295 with Quotes in the Row.*/
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
296 QRegularExpressionMatch nextQuestion = questionEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
297 if (nextQuestion.hasMatch() &&
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
298 nextQuestion.capturedStart() < textMatch.capturedEnd()) {
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
299 /* 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
300 a new question. */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
301 break;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
302 }
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
303 const QString lastRow = xlsx.read(row - 1, 26).toString();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
304 int unquotedLen = textMatch.capturedStart() - cursor;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
305 const QString unquoted = input.mid(cursor, unquotedLen);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
306 qDebug() << "Found inner quoted string: " << unquoted;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
307 /* Now combine */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
308 const QString combined = QString("%1\"%2\"%3").arg(lastRow).
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
309 arg(unquoted).
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
310 arg(textMatch.captured(1).trimmed());
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
311 qDebug() << "Last row: " << lastRow;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
312 qDebug() << "Next Question is at: " << nextQuestion.capturedStart();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
313 qDebug() << "Text match is: " << textMatch.captured(1).trimmed();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
314 qDebug() << "cursor is at: " << cursor;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
315 qDebug() << "text match starts at: " << textMatch.capturedStart();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
316 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
317 xlsx.write(row - 1, 1, combined, mFreeTextFmt);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
318 cursor = textMatch.capturedEnd();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
319 textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
320 continue;
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
321 }
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
322 cursor = textMatch.capturedEnd();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
323
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
324 QString text = textMatch.captured(1).trimmed();
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
325 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
326 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
327 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
328 }
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
329
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
330 /* Merge the cells */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
331 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
332
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
333 /* 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
334 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
335 */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
336 /* Write the values */
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
337 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
338 xlsx.write(row, 1, text, mFreeTextFmt);
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
339 row++;
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
340
6
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
341 textMatch = freetxtEx.match(input, cursor);
a10425e7ef98 Add free text handling
Andre Heinecke <andre.heinecke@intevation.de>
parents: 3
diff changeset
342 }
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
343 for (int i = firstFreeRow; i < row; i++) {
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
344 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
345 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
346 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
347 /* Insert Empty row. */
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
348 xlsx.setRowHeight(row++, CHOICE_ROW_HEIGHT);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
349 match = questionEx.match(input, cursor);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
350 cursor = match.capturedEnd();
25
e5c5ebfa4205 Refactor to centralise html tags
Andre Heinecke <andre.heinecke@intevation.de>
parents: 23
diff changeset
351 html << mEmptyRow;
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
352 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
353 xlsx.addConditionalFormatting(bars);
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
354
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
355 if (!foundSomething) {
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
356 mErrors << tr("Failed to parse input document.");
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
357 }
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
358
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
359 if (mFmt == Format_XLSX && !xlsx.saveAs(&output)) {
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
360 mErrors << tr("Saving the XLSX document failed.");
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
361 return;
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
362 }
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
363
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
364 html << "</table></body></html>";
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
365
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
366 if (mFmt == Format_HTML) {
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
367 QTextStream outstream(&output);
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
368 outstream << htmlString;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
369 return;
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
370 }
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
371
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
372 if (mFmt == Format_PDF) {
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
373 output.close();
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
374 QPrinter printer(QPrinter::PrinterResolution);
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
375 printer.setOutputFormat(QPrinter::PdfFormat);
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
376 printer.setPaperSize(QPrinter::A4);
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
377 printer.setOutputFileName(output.fileName());
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
378 doc.setHtml(htmlString);
35
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
379 /*
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
380 QPageLayout layout = printer.pageLayout();
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
381 layout.setUnits(QPageLayout::Millimeter);
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
382 layout.setMargins(QMarginsF(20, 20, 20, 20));
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
383 printer.setPageLayout(layout);
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
384 doc.setPageSize(printer.pageRect().size());
ca66763b6524 Add commented out layout test
Andre Heinecke <andre.heinecke@intevation.de>
parents: 32
diff changeset
385 */
23
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
386 doc.print(&printer);
927794e3cc52 Add HTML output and some pdf support
Andre Heinecke <andre.heinecke@intevation.de>
parents: 21
diff changeset
387 }
3
8b4c49c92451 Add initial implementation that handles choices
Andre Heinecke <andre.heinecke@intevation.de>
parents:
diff changeset
388 }
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)