Passed
Push — master ( 2661ad...b3452a )
by
unknown
13:20 queued 15s
created

StringTable::writeRichTextForCharts()   F

Complexity

Conditions 17
Paths 1160

Size

Total Lines 85
Code Lines 50

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 50
CRAP Score 17

Importance

Changes 0
Metric Value
eloc 50
dl 0
loc 85
ccs 50
cts 50
cp 1
rs 1.0499
c 0
b 0
f 0
cc 17
nc 1160
nop 3
crap 17

How to fix   Long Method    Complexity   

Long Method

Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.

For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.

Commonly applied refactorings include:

1
<?php
2
3
namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;
4
5
use PhpOffice\PhpSpreadsheet\Cell\Cell;
6
use PhpOffice\PhpSpreadsheet\Cell\DataType;
7
use PhpOffice\PhpSpreadsheet\Chart\ChartColor;
8
use PhpOffice\PhpSpreadsheet\Reader\Xlsx\Namespaces;
9
use PhpOffice\PhpSpreadsheet\RichText\RichText;
10
use PhpOffice\PhpSpreadsheet\RichText\Run;
11
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
12
use PhpOffice\PhpSpreadsheet\Shared\XMLWriter;
13
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet as ActualWorksheet;
14
15
class StringTable extends WriterPart
16
{
17
    /**
18
     * Create worksheet stringtable.
19
     *
20
     * @param string[] $existingTable Existing table to eventually merge with
21
     *
22
     * @return string[] String table for worksheet
23
     */
24 373
    public function createStringTable(ActualWorksheet $worksheet, ?array $existingTable = null): array
25
    {
26
        // Create string lookup table
27 373
        $aStringTable = $existingTable ?? [];
28
29
        // Fill index array
30 373
        $aFlippedStringTable = $this->flipStringTable($aStringTable);
31
32
        // Loop through cells
33 373
        foreach ($worksheet->getCellCollection()->getCoordinates() as $coordinate) {
34
            /** @var Cell $cell */
35 353
            $cell = $worksheet->getCellCollection()->get($coordinate);
36 353
            $cellValue = $cell->getValue();
37
            if (
38 353
                !is_object($cellValue)
39 353
                && ($cellValue !== null)
40 353
                && $cellValue !== ''
41 353
                && ($cell->getDataType() == DataType::TYPE_STRING || $cell->getDataType() == DataType::TYPE_STRING2 || $cell->getDataType() == DataType::TYPE_NULL)
42 353
                && !isset($aFlippedStringTable[$cellValue])
43
            ) {
44 232
                $aStringTable[] = $cellValue;
45 232
                $aFlippedStringTable[$cellValue] = true;
46
            } elseif (
47 312
                $cellValue instanceof RichText
48 312
                && !isset($aFlippedStringTable[$cellValue->getHashCode()])
49
            ) {
50 19
                $aStringTable[] = $cellValue;
51 19
                $aFlippedStringTable[$cellValue->getHashCode()] = true;
52
            }
53
        }
54
55 373
        return $aStringTable;
56
    }
57
58
    /**
59
     * Write string table to XML format.
60
     *
61
     * @param (RichText|string)[] $stringTable
62
     *
63
     * @return string XML Output
64
     */
65 373
    public function writeStringTable(array $stringTable): string
66
    {
67
        // Create XML writer
68 373
        $objWriter = null;
69 373
        if ($this->getParentWriter()->getUseDiskCaching()) {
70
            $objWriter = new XMLWriter(XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
71
        } else {
72 373
            $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
73
        }
74
75
        // XML header
76 373
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
77
78
        // String table
79 373
        $objWriter->startElement('sst');
80 373
        $objWriter->writeAttribute('xmlns', Namespaces::MAIN);
81 373
        $objWriter->writeAttribute('uniqueCount', (string) count($stringTable));
82
83
        // Loop through string table
84 373
        foreach ($stringTable as $textElement) {
85 235
            $objWriter->startElement('si');
86
87 235
            if (!($textElement instanceof RichText)) {
88 232
                $textToWrite = StringHelper::controlCharacterPHP2OOXML($textElement);
89 232
                $objWriter->startElement('t');
90 232
                if ($textToWrite !== trim($textToWrite)) {
91 8
                    $objWriter->writeAttribute('xml:space', 'preserve');
92
                }
93 232
                $objWriter->writeRawData($textToWrite);
94 232
                $objWriter->endElement();
95
            } else {
96 19
                $this->writeRichText($objWriter, $textElement);
97
            }
98
99 235
            $objWriter->endElement();
100
        }
101
102 373
        $objWriter->endElement();
103
104 373
        return $objWriter->getData();
105
    }
106
107
    /**
108
     * Write Rich Text.
109
     *
110
     * @param ?string $prefix Optional Namespace prefix
111
     */
112 36
    public function writeRichText(XMLWriter $objWriter, RichText $richText, ?string $prefix = null): void
113
    {
114 36
        if ($prefix !== null) {
115
            $prefix .= ':';
116
        }
117
118
        // Loop through rich text elements
119 36
        $elements = $richText->getRichTextElements();
120 36
        foreach ($elements as $element) {
121
            // r
122 33
            $objWriter->startElement($prefix . 'r');
123
124
            // rPr
125 33
            if ($element instanceof Run && $element->getFont() !== null) {
126
                // rPr
127 21
                $objWriter->startElement($prefix . 'rPr');
128
129
                // rFont
130 21
                if ($element->getFont()->getName() !== null) {
131 21
                    $objWriter->startElement($prefix . 'rFont');
132 21
                    $objWriter->writeAttribute('val', $element->getFont()->getName());
133 21
                    $objWriter->endElement();
134
                }
135
136
                // Bold
137 21
                $objWriter->startElement($prefix . 'b');
138 21
                $objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false'));
139 21
                $objWriter->endElement();
140
141
                // Italic
142 21
                $objWriter->startElement($prefix . 'i');
143 21
                $objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false'));
144 21
                $objWriter->endElement();
145
146
                // Superscript / subscript
147 21
                if ($element->getFont()->getSuperscript() || $element->getFont()->getSubscript()) {
148 1
                    $objWriter->startElement($prefix . 'vertAlign');
149 1
                    if ($element->getFont()->getSuperscript()) {
150 1
                        $objWriter->writeAttribute('val', 'superscript');
151 1
                    } elseif ($element->getFont()->getSubscript()) {
152 1
                        $objWriter->writeAttribute('val', 'subscript');
153
                    }
154 1
                    $objWriter->endElement();
155
                }
156
157
                // Strikethrough
158 21
                $objWriter->startElement($prefix . 'strike');
159 21
                $objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false'));
160 21
                $objWriter->endElement();
161
162
                // Color
163 21
                if ($element->getFont()->getColor()->getARGB() !== null) {
164 21
                    $objWriter->startElement($prefix . 'color');
165 21
                    $objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
166 21
                    $objWriter->endElement();
167
                }
168
169
                // Size
170 21
                if ($element->getFont()->getSize() !== null) {
171 21
                    $objWriter->startElement($prefix . 'sz');
172 21
                    $objWriter->writeAttribute('val', (string) $element->getFont()->getSize());
173 21
                    $objWriter->endElement();
174
                }
175
176
                // Underline
177 21
                if ($element->getFont()->getUnderline() !== null) {
178 21
                    $objWriter->startElement($prefix . 'u');
179 21
                    $objWriter->writeAttribute('val', $element->getFont()->getUnderline());
180 21
                    $objWriter->endElement();
181
                }
182
183 21
                $objWriter->endElement();
184
            }
185
186
            // t
187 33
            $objWriter->startElement($prefix . 't');
188 33
            $objWriter->writeAttribute('xml:space', 'preserve');
189 33
            $objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($element->getText()));
190 33
            $objWriter->endElement();
191
192 33
            $objWriter->endElement();
193
        }
194
    }
195
196
    /**
197
     * Write Rich Text.
198
     *
199
     * @param RichText|string $richText text string or Rich text
200
     * @param string $prefix Optional Namespace prefix
201
     */
202 82
    public function writeRichTextForCharts(XMLWriter $objWriter, $richText = null, string $prefix = ''): void
203
    {
204 82
        if (!($richText instanceof RichText)) {
205 49
            $textRun = $richText;
206 49
            $richText = new RichText();
207 49
            $run = $richText->createTextRun($textRun ?? '');
208 49
            $run->setFont(null);
209
        }
210
211 82
        if ($prefix !== '') {
212 82
            $prefix .= ':';
213
        }
214
215
        // Loop through rich text elements
216 82
        $elements = $richText->getRichTextElements();
217 82
        foreach ($elements as $element) {
218
            // r
219 82
            $objWriter->startElement($prefix . 'r');
220 82
            if ($element->getFont() !== null) {
221
                // rPr
222 28
                $objWriter->startElement($prefix . 'rPr');
223 28
                $fontSize = $element->getFont()->getSize();
224 28
                if (is_numeric($fontSize)) {
225 22
                    $fontSize *= (($fontSize < 100) ? 100 : 1);
226 22
                    $objWriter->writeAttribute('sz', (string) $fontSize);
227
                }
228
229
                // Bold
230 28
                $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? '1' : '0'));
231
                // Italic
232 28
                $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? '1' : '0'));
233
                // Underline
234 28
                $underlineType = $element->getFont()->getUnderline();
235
                switch ($underlineType) {
236 28
                    case 'single':
237 6
                        $underlineType = 'sng';
238
239 6
                        break;
240 28
                    case 'double':
241 5
                        $underlineType = 'dbl';
242
243 5
                        break;
244
                }
245 28
                if ($underlineType !== null) {
246 28
                    $objWriter->writeAttribute('u', $underlineType);
247
                }
248
                // Strikethrough
249 28
                $objWriter->writeAttribute('strike', ($element->getFont()->getStriketype() ?: 'noStrike'));
250
                // Superscript/subscript
251 28
                if ($element->getFont()->getBaseLine()) {
252 5
                    $objWriter->writeAttribute('baseline', (string) $element->getFont()->getBaseLine());
253
                }
254
255
                // Color
256 28
                $this->writeChartTextColor($objWriter, $element->getFont()->getChartColor(), $prefix);
257
258
                // Underscore Color
259 28
                $this->writeChartTextColor($objWriter, $element->getFont()->getUnderlineColor(), $prefix, 'uFill');
260
261
                // fontName
262 28
                if ($element->getFont()->getLatin()) {
263 23
                    $objWriter->startElement($prefix . 'latin');
264 23
                    $objWriter->writeAttribute('typeface', $element->getFont()->getLatin());
265 23
                    $objWriter->endElement();
266
                }
267 28
                if ($element->getFont()->getEastAsian()) {
268 21
                    $objWriter->startElement($prefix . 'ea');
269 21
                    $objWriter->writeAttribute('typeface', $element->getFont()->getEastAsian());
270 21
                    $objWriter->endElement();
271
                }
272 28
                if ($element->getFont()->getComplexScript()) {
273 21
                    $objWriter->startElement($prefix . 'cs');
274 21
                    $objWriter->writeAttribute('typeface', $element->getFont()->getComplexScript());
275 21
                    $objWriter->endElement();
276
                }
277
278 28
                $objWriter->endElement();
279
            }
280
281
            // t
282 82
            $objWriter->startElement($prefix . 't');
283 82
            $objWriter->writeRawData(StringHelper::controlCharacterPHP2OOXML($element->getText()));
284 82
            $objWriter->endElement();
285
286 82
            $objWriter->endElement();
287
        }
288
    }
289
290 28
    private function writeChartTextColor(XMLWriter $objWriter, ?ChartColor $underlineColor, string $prefix, ?string $openTag = ''): void
291
    {
292 28
        if ($underlineColor !== null) {
293 22
            $type = $underlineColor->getType();
294 22
            $value = $underlineColor->getValue();
295 22
            if (!empty($type) && !empty($value)) {
296 17
                if ($openTag !== '') {
297 5
                    $objWriter->startElement($prefix . $openTag);
298
                }
299 17
                $objWriter->startElement($prefix . 'solidFill');
300 17
                $objWriter->startElement($prefix . $type);
301 17
                $objWriter->writeAttribute('val', $value);
302 17
                $alpha = $underlineColor->getAlpha();
303 17
                if (is_numeric($alpha)) {
304
                    $objWriter->startElement('a:alpha');
305
                    $objWriter->writeAttribute('val', ChartColor::alphaToXml((int) $alpha));
306
                    $objWriter->endElement();
307
                }
308 17
                $objWriter->endElement(); // srgbClr/schemeClr/prstClr
309 17
                $objWriter->endElement(); // solidFill
310 17
                if ($openTag !== '') {
311 5
                    $objWriter->endElement(); // uFill
312
                }
313
            }
314
        }
315
    }
316
317
    /**
318
     * Flip string table (for index searching).
319
     *
320
     * @param array $stringTable Stringtable
321
     */
322 412
    public function flipStringTable(array $stringTable): array
323
    {
324
        // Return value
325 412
        $returnValue = [];
326
327
        // Loop through stringtable and add flipped items to $returnValue
328 412
        foreach ($stringTable as $key => $value) {
329 235
            if (!$value instanceof RichText) {
330 232
                $returnValue[$value] = $key;
331 19
            } elseif ($value instanceof RichText) {
332 19
                $returnValue[$value->getHashCode()] = $key;
333
            }
334
        }
335
336 412
        return $returnValue;
337
    }
338
}
339