StringTable::flipStringTable() - Code Metrics - Inspection of "Enforce writer parts parent to be concrete writer" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 3ee9cc...870d86 )

by Adrien

created 2017-04-21 05:49 UTC

StringTable::flipStringTable() A

↳ Parent: StringTable

Complexity

Conditions	4
Paths	4

Size

Total Lines	16
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	7
CRAP Score	4.0312

Importance

Changes

Metric	Value
cc	4
eloc	8
nc	4
nop	1
dl	0
loc	16
ccs	7
cts	8
cp	0.875
crap	4.0312
rs	9.2
c	0
b	0
f	0

<?php

namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;

/**
 * Copyright (c) 2006 - 2016 PhpSpreadsheet.
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
 *
 * @category   PhpSpreadsheet
 *
 * @copyright  Copyright (c) 2006 - 2016 PhpSpreadsheet (https://github.com/PHPOffice/PhpSpreadsheet)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 */
class StringTable extends WriterPart
{
    /**
     * Create worksheet stringtable.
     *
     * @param \PhpOffice\PhpSpreadsheet\Worksheet $pSheet Worksheet
     * @param string[] $pExistingTable Existing table to eventually merge with
     *
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     *
     * @return string[] String table for worksheet
     */
    public function createStringTable($pSheet = null, $pExistingTable = null)
    {
        if ($pSheet !== null) {
            // Create string lookup table
            $aStringTable = [];
            $cellCollection = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
            $aFlippedStringTable = null; // For faster lookup
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

            // Is an existing table given?
            if (($pExistingTable !== null) && is_array($pExistingTable)) {
                $aStringTable = $pExistingTable;
            }

            // Fill index array
            $aFlippedStringTable = $this->flipStringTable($aStringTable);

            // Loop through cells
            foreach ($pSheet->getCoordinates() as $coordinate) {
                $cell = $pSheet->getCell($coordinate);
                $cellValue = $cell->getValue();
                if (!is_object($cellValue) &&
                    ($cellValue !== null) &&
                    $cellValue !== '' &&
                    !isset($aFlippedStringTable[$cellValue]) &&
                    ($cell->getDataType() == \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING || $cell->getDataType() == \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING2 || $cell->getDataType() == \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NULL)) {
                    $aStringTable[] = $cellValue;
                    $aFlippedStringTable[$cellValue] = true;
                } elseif ($cellValue instanceof \PhpOffice\PhpSpreadsheet\RichText &&
                          ($cellValue !== null) &&
                          !isset($aFlippedStringTable[$cellValue->getHashCode()])) {
                    $aStringTable[] = $cellValue;
                    $aFlippedStringTable[$cellValue->getHashCode()] = true;
                }
            }

            return $aStringTable;
        }
        throw new \PhpOffice\PhpSpreadsheet\Writer\Exception("Invalid \PhpOffice\PhpSpreadsheet\Worksheet object passed.");
    }

    /**
     * Write string table to XML format.
     *
     * @param string[] $pStringTable
     *
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     *
     * @return string XML Output
     */
    public function writeStringTable(array $pStringTable)
    {
        // Create XML writer
        $objWriter = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        if ($this->getParentWriter()->getUseDiskCaching()) {

            $objWriter = new \PhpOffice\PhpSpreadsheet\Shared\XMLWriter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
        } else {
            $objWriter = new \PhpOffice\PhpSpreadsheet\Shared\XMLWriter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter::STORAGE_MEMORY);
        }

        // XML header
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');

        // String table
        $objWriter->startElement('sst');
        $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
        $objWriter->writeAttribute('uniqueCount', count($pStringTable));

        // Loop through string table
        foreach ($pStringTable as $textElement) {
            $objWriter->startElement('si');

            if (!$textElement instanceof \PhpOffice\PhpSpreadsheet\RichText) {
                $textToWrite = \PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($textElement);
                $objWriter->startElement('t');
                if ($textToWrite !== trim($textToWrite)) {
                    $objWriter->writeAttribute('xml:space', 'preserve');
                }
                $objWriter->writeRawData($textToWrite);
                $objWriter->endElement();
            } elseif ($textElement instanceof \PhpOffice\PhpSpreadsheet\RichText) {
                $this->writeRichText($objWriter, $textElement);
            }

            $objWriter->endElement();
        }

        $objWriter->endElement();

        return $objWriter->getData();
    }

    /**
     * Write Rich Text.
     *
     * @param \PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter XML Writer
     * @param \PhpOffice\PhpSpreadsheet\RichText $pRichText Rich text
     * @param string $prefix Optional Namespace prefix
     *
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public function writeRichText(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\RichText $pRichText, $prefix = null)
    {
        if ($prefix !== null) {
            $prefix .= ':';
        }

        // Loop through rich text elements
        $elements = $pRichText->getRichTextElements();
        foreach ($elements as $element) {
            // r
            $objWriter->startElement($prefix . 'r');

            // rPr
            if ($element instanceof \PhpOffice\PhpSpreadsheet\RichText\Run) {
                // rPr
                $objWriter->startElement($prefix . 'rPr');

                // rFont
                $objWriter->startElement($prefix . 'rFont');
                $objWriter->writeAttribute('val', $element->getFont()->getName());
                $objWriter->endElement();

                // Bold
                $objWriter->startElement($prefix . 'b');
                $objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false'));
                $objWriter->endElement();

                // Italic
                $objWriter->startElement($prefix . 'i');
                $objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false'));
                $objWriter->endElement();

                // Superscript / subscript
                if ($element->getFont()->getSuperScript() || $element->getFont()->getSubScript()) {
                    $objWriter->startElement($prefix . 'vertAlign');
                    if ($element->getFont()->getSuperScript()) {
                        $objWriter->writeAttribute('val', 'superscript');
                    } elseif ($element->getFont()->getSubScript()) {
                        $objWriter->writeAttribute('val', 'subscript');
                    }
                    $objWriter->endElement();
                }

                // Strikethrough
                $objWriter->startElement($prefix . 'strike');
                $objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false'));
                $objWriter->endElement();

                // Color
                $objWriter->startElement($prefix . 'color');
                $objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
                $objWriter->endElement();

                // Size
                $objWriter->startElement($prefix . 'sz');
                $objWriter->writeAttribute('val', $element->getFont()->getSize());
                $objWriter->endElement();

                // Underline
                $objWriter->startElement($prefix . 'u');
                $objWriter->writeAttribute('val', $element->getFont()->getUnderline());
                $objWriter->endElement();

                $objWriter->endElement();
            }

            // t
            $objWriter->startElement($prefix . 't');
            $objWriter->writeAttribute('xml:space', 'preserve');
            $objWriter->writeRawData(\PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
            $objWriter->endElement();

            $objWriter->endElement();
        }
    }

    /**
     * Write Rich Text.
     *
     * @param \PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter XML Writer
     * @param string|\PhpOffice\PhpSpreadsheet\RichText $pRichText text string or Rich text
     * @param string $prefix Optional Namespace prefix
     *
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public function writeRichTextForCharts(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter, $pRichText = null, $prefix = null)
    {
        if (!$pRichText instanceof \PhpOffice\PhpSpreadsheet\RichText) {
            $textRun = $pRichText;
            $pRichText = new \PhpOffice\PhpSpreadsheet\RichText();
            $pRichText->createTextRun($textRun);
        }

        if ($prefix !== null) {
            $prefix .= ':';
        }

        // Loop through rich text elements
        $elements = $pRichText->getRichTextElements();
        foreach ($elements as $element) {
            // r
            $objWriter->startElement($prefix . 'r');

            // rPr
            $objWriter->startElement($prefix . 'rPr');

            // Bold
            $objWriter->writeAttribute('b', ($element->getFont()->getBold() ? 1 : 0));
            // Italic
            $objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? 1 : 0));
            // Underline
            $underlineType = $element->getFont()->getUnderline();
            switch ($underlineType) {
                case 'single':
                    $underlineType = 'sng';
                    break;
                case 'double':
                    $underlineType = 'dbl';
                    break;
            }
            $objWriter->writeAttribute('u', $underlineType);
            // Strikethrough
            $objWriter->writeAttribute('strike', ($element->getFont()->getStrikethrough() ? 'sngStrike' : 'noStrike'));

            // rFont
            $objWriter->startElement($prefix . 'latin');
            $objWriter->writeAttribute('typeface', $element->getFont()->getName());
            $objWriter->endElement();

            $objWriter->endElement();

            // t
            $objWriter->startElement($prefix . 't');
            $objWriter->writeRawData(\PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
            $objWriter->endElement();

            $objWriter->endElement();
        }
    }

    /**
     * Flip string table (for index searching).
     *
     * @param array $stringTable Stringtable
     *
     * @return array
     */
    public function flipStringTable(array $stringTable)
    {
        // Return value
        $returnValue = [];

        // Loop through stringtable and add flipped items to $returnValue
        foreach ($stringTable as $key => $value) {
            if (!$value instanceof \PhpOffice\PhpSpreadsheet\RichText) {
                $returnValue[$value] = $key;
            } elseif ($value instanceof \PhpOffice\PhpSpreadsheet\RichText) {
                $returnValue[$value->getHashCode()] = $key;
            }
        }

        return $returnValue;
    }
}


1			<?php
2
3			namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx;
4
5			/**
6			* Copyright (c) 2006 - 2016 PhpSpreadsheet.
7			*
8			* This library is free software; you can redistribute it and/or
9			* modify it under the terms of the GNU Lesser General Public
10			* License as published by the Free Software Foundation; either
11			* version 2.1 of the License, or (at your option) any later version.
12			*
13			* This library is distributed in the hope that it will be useful,
14			* but WITHOUT ANY WARRANTY; without even the implied warranty of
15			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16			* Lesser General Public License for more details.
17			*
18			* You should have received a copy of the GNU Lesser General Public
19			* License along with this library; if not, write to the Free Software
20			* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
21			*
22			* @category PhpSpreadsheet
23			*
24			* @copyright Copyright (c) 2006 - 2016 PhpSpreadsheet (https://github.com/PHPOffice/PhpSpreadsheet)
25			* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
26			*/
27			class StringTable extends WriterPart
28			{
29			/**
30			* Create worksheet stringtable.
31			*
32			* @param \PhpOffice\PhpSpreadsheet\Worksheet $pSheet Worksheet
33			* @param string[] $pExistingTable Existing table to eventually merge with
34			*
35			* @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
36			*
37			* @return string[] String table for worksheet
38			*/
39	52		public function createStringTable($pSheet = null, $pExistingTable = null)
40			{
41	52		if ($pSheet !== null) {
42			// Create string lookup table
43	52		$aStringTable = [];
44	52		$cellCollection = null;
			0 ignored issues – show Unused Code introduced 2016-08-14 05:24 UTC by Report Bug Copy Issue Report `$cellCollection` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
45	52		$aFlippedStringTable = null; // For faster lookup
			0 ignored issues – show Unused Code introduced 2016-08-14 05:24 UTC by Report Bug Copy Issue Report `$aFlippedStringTable` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
46
47			// Is an existing table given?
48	52		if (($pExistingTable !== null) && is_array($pExistingTable)) {
49	52		$aStringTable = $pExistingTable;
50			}
51
52			// Fill index array
53	52		$aFlippedStringTable = $this->flipStringTable($aStringTable);
54
55			// Loop through cells
56	52		foreach ($pSheet->getCoordinates() as $coordinate) {
57	52		$cell = $pSheet->getCell($coordinate);
58	52		$cellValue = $cell->getValue();
59	52		if (!is_object($cellValue) &&
60	51		($cellValue !== null) &&
61	48		$cellValue !== '' &&
62	48		!isset($aFlippedStringTable[$cellValue]) &&
63	48		($cell->getDataType() == \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING \|\| $cell->getDataType() == \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING2 \|\| $cell->getDataType() == \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NULL)) {
64	46		$aStringTable[] = $cellValue;
65	46		$aFlippedStringTable[$cellValue] = true;
66			} elseif ($cellValue instanceof \PhpOffice\PhpSpreadsheet\RichText &&
67	10		($cellValue !== null) &&
68	10		!isset($aFlippedStringTable[$cellValue->getHashCode()])) {
69	10		$aStringTable[] = $cellValue;
70	10		$aFlippedStringTable[$cellValue->getHashCode()] = true;
71			}
72			}
73
74	52		return $aStringTable;
75			}
76			throw new \PhpOffice\PhpSpreadsheet\Writer\Exception("Invalid \PhpOffice\PhpSpreadsheet\Worksheet object passed.");
77			}
78
79			/**
80			* Write string table to XML format.
81			*
82			* @param string[] $pStringTable
83			*
84			* @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
85			*
86			* @return string XML Output
87			*/
88	52		public function writeStringTable(array $pStringTable)
89			{
90			// Create XML writer
91	52		$objWriter = null;
			0 ignored issues – show Unused Code introduced 2017-04-16 05:45 UTC by Report Bug Copy Issue Report `$objWriter` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
92	52	View Code Duplication	if ($this->getParentWriter()->getUseDiskCaching()) {
			0 ignored issues – show Duplication introduced 2016-08-14 05:24 UTC by Report Bug Copy Issue Report This code seems to be duplicated across your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
93			$objWriter = new \PhpOffice\PhpSpreadsheet\Shared\XMLWriter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
94			} else {
95	52		$objWriter = new \PhpOffice\PhpSpreadsheet\Shared\XMLWriter(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter::STORAGE_MEMORY);
96			}
97
98			// XML header
99	52		$objWriter->startDocument('1.0', 'UTF-8', 'yes');
100
101			// String table
102	52		$objWriter->startElement('sst');
103	52		$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
104	52		$objWriter->writeAttribute('uniqueCount', count($pStringTable));
105
106			// Loop through string table
107	52		foreach ($pStringTable as $textElement) {
108	47		$objWriter->startElement('si');
109
110	47		if (!$textElement instanceof \PhpOffice\PhpSpreadsheet\RichText) {
111	46		$textToWrite = \PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($textElement);
112	46		$objWriter->startElement('t');
113	46		if ($textToWrite !== trim($textToWrite)) {
114			$objWriter->writeAttribute('xml:space', 'preserve');
115			}
116	46		$objWriter->writeRawData($textToWrite);
117	46		$objWriter->endElement();
118			} elseif ($textElement instanceof \PhpOffice\PhpSpreadsheet\RichText) {
119	10		$this->writeRichText($objWriter, $textElement);
120			}
121
122	47		$objWriter->endElement();
123			}
124
125	52		$objWriter->endElement();
126
127	52		return $objWriter->getData();
128			}
129
130			/**
131			* Write Rich Text.
132			*
133			* @param \PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter XML Writer
134			* @param \PhpOffice\PhpSpreadsheet\RichText $pRichText Rich text
135			* @param string $prefix Optional Namespace prefix
136			*
137			* @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
138			*/
139	13		public function writeRichText(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter, \PhpOffice\PhpSpreadsheet\RichText $pRichText, $prefix = null)
140			{
141	13		if ($prefix !== null) {
142			$prefix .= ':';
143			}
144
145			// Loop through rich text elements
146	13		$elements = $pRichText->getRichTextElements();
147	13		foreach ($elements as $element) {
148			// r
149	13		$objWriter->startElement($prefix . 'r');
150
151			// rPr
152	13		if ($element instanceof \PhpOffice\PhpSpreadsheet\RichText\Run) {
153			// rPr
154	10		$objWriter->startElement($prefix . 'rPr');
155
156			// rFont
157	10		$objWriter->startElement($prefix . 'rFont');
158	10		$objWriter->writeAttribute('val', $element->getFont()->getName());
159	10		$objWriter->endElement();
160
161			// Bold
162	10		$objWriter->startElement($prefix . 'b');
163	10		$objWriter->writeAttribute('val', ($element->getFont()->getBold() ? 'true' : 'false'));
164	10		$objWriter->endElement();
165
166			// Italic
167	10		$objWriter->startElement($prefix . 'i');
168	10		$objWriter->writeAttribute('val', ($element->getFont()->getItalic() ? 'true' : 'false'));
169	10		$objWriter->endElement();
170
171			// Superscript / subscript
172	10		if ($element->getFont()->getSuperScript() \|\| $element->getFont()->getSubScript()) {
173	1		$objWriter->startElement($prefix . 'vertAlign');
174	1		if ($element->getFont()->getSuperScript()) {
175	1		$objWriter->writeAttribute('val', 'superscript');
176	1		} elseif ($element->getFont()->getSubScript()) {
177	1		$objWriter->writeAttribute('val', 'subscript');
178			}
179	1		$objWriter->endElement();
180			}
181
182			// Strikethrough
183	10		$objWriter->startElement($prefix . 'strike');
184	10		$objWriter->writeAttribute('val', ($element->getFont()->getStrikethrough() ? 'true' : 'false'));
185	10		$objWriter->endElement();
186
187			// Color
188	10		$objWriter->startElement($prefix . 'color');
189	10		$objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
190	10		$objWriter->endElement();
191
192			// Size
193	10		$objWriter->startElement($prefix . 'sz');
194	10		$objWriter->writeAttribute('val', $element->getFont()->getSize());
195	10		$objWriter->endElement();
196
197			// Underline
198	10		$objWriter->startElement($prefix . 'u');
199	10		$objWriter->writeAttribute('val', $element->getFont()->getUnderline());
200	10		$objWriter->endElement();
201
202	10		$objWriter->endElement();
203			}
204
205			// t
206	13		$objWriter->startElement($prefix . 't');
207	13		$objWriter->writeAttribute('xml:space', 'preserve');
208	13		$objWriter->writeRawData(\PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
209	13		$objWriter->endElement();
210
211	13		$objWriter->endElement();
212			}
213	13		}
214
215			/**
216			* Write Rich Text.
217			*
218			* @param \PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter XML Writer
219			* @param string\|\PhpOffice\PhpSpreadsheet\RichText $pRichText text string or Rich text
220			* @param string $prefix Optional Namespace prefix
221			*
222			* @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
223			*/
224	13		public function writeRichTextForCharts(\PhpOffice\PhpSpreadsheet\Shared\XMLWriter $objWriter, $pRichText = null, $prefix = null)
225			{
226	13		if (!$pRichText instanceof \PhpOffice\PhpSpreadsheet\RichText) {
227	12		$textRun = $pRichText;
228	12		$pRichText = new \PhpOffice\PhpSpreadsheet\RichText();
229	12		$pRichText->createTextRun($textRun);
230			}
231
232	13		if ($prefix !== null) {
233	13		$prefix .= ':';
234			}
235
236			// Loop through rich text elements
237	13		$elements = $pRichText->getRichTextElements();
238	13		foreach ($elements as $element) {
239			// r
240	13		$objWriter->startElement($prefix . 'r');
241
242			// rPr
243	13		$objWriter->startElement($prefix . 'rPr');
244
245			// Bold
246	13		$objWriter->writeAttribute('b', ($element->getFont()->getBold() ? 1 : 0));
247			// Italic
248	13		$objWriter->writeAttribute('i', ($element->getFont()->getItalic() ? 1 : 0));
249			// Underline
250	13		$underlineType = $element->getFont()->getUnderline();
251			switch ($underlineType) {
252	13		case 'single':
253	1		$underlineType = 'sng';
254	1		break;
255	13		case 'double':
256	1		$underlineType = 'dbl';
257	1		break;
258			}
259	13		$objWriter->writeAttribute('u', $underlineType);
260			// Strikethrough
261	13		$objWriter->writeAttribute('strike', ($element->getFont()->getStrikethrough() ? 'sngStrike' : 'noStrike'));
262
263			// rFont
264	13		$objWriter->startElement($prefix . 'latin');
265	13		$objWriter->writeAttribute('typeface', $element->getFont()->getName());
266	13		$objWriter->endElement();
267
268	13		$objWriter->endElement();
269
270			// t
271	13		$objWriter->startElement($prefix . 't');
272	13		$objWriter->writeRawData(\PhpOffice\PhpSpreadsheet\Shared\StringHelper::controlCharacterPHP2OOXML($element->getText()));
273	13		$objWriter->endElement();
274
275	13		$objWriter->endElement();
276			}
277	13		}
278
279			/**
280			* Flip string table (for index searching).
281			*
282			* @param array $stringTable Stringtable
283			*
284			* @return array
285			*/
286	52		public function flipStringTable(array $stringTable)
287			{
288			// Return value
289	52		$returnValue = [];
290
291			// Loop through stringtable and add flipped items to $returnValue
292	52		foreach ($stringTable as $key => $value) {
293	47		if (!$value instanceof \PhpOffice\PhpSpreadsheet\RichText) {
294	46		$returnValue[$value] = $key;
295			} elseif ($value instanceof \PhpOffice\PhpSpreadsheet\RichText) {
296	10		$returnValue[$value->getHashCode()] = $key;
297			}
298			}
299
300	52		return $returnValue;
301			}
302			}
303

PHPOffice / PhpSpreadsheet

Push — develop ( 3ee9cc...870d86 )

StringTable::flipStringTable() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like