StyleManager::getCellXfsSectionContent() - Code Metrics - Inspection of "Row objects and Cell styling" - box/spout - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Pull Request — develop_3.0 (#434)

by Hura

created 2017-08-01 11:01 UTC

StyleManager::getCellXfsSectionContent() B

↳ Parent: StyleManager

Complexity

Conditions	5
Paths	5

Size

Total Lines	32
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	15
CRAP Score	5.1158

Importance

Changes

Metric	Value
dl	0
loc	32
ccs	15
cts	18
cp	0.8333
rs	8.439
c	0
b	0
f	0
cc	5
eloc	19
nc	5
nop	0
crap	5.1158

<?php

namespace Box\Spout\Writer\XLSX\Manager\Style;

use Box\Spout\Writer\Common\Entity\Style\Color;
use Box\Spout\Writer\Common\Entity\Style\Style;
use Box\Spout\Writer\XLSX\Helper\BorderHelper;

/**
 * Class StyleManager
 * Manages styles to be applied to a cell
 *
 * @package Box\Spout\Writer\XLSX\Manager\Style
 */
class StyleManager extends \Box\Spout\Writer\Common\Manager\Style\StyleManager
{
    /** @var StyleRegistry */
    protected $styleRegistry;

    /**
     * For empty cells, we can specify a style or not. If no style are specified,
     * then the software default will be applied. But sometimes, it may be useful
     * to override this default style, for instance if the cell should have a
     * background color different than the default one or some borders
     * (fonts property don't really matter here).
     *
     * @param int $styleId
     * @return bool Whether the cell should define a custom style
     */
    public function shouldApplyStyleOnEmptyCell($styleId)
    {
        $associatedFillId = $this->styleRegistry->getFillIdForStyleId($styleId);
        $hasStyleCustomFill = ($associatedFillId !== null && $associatedFillId !== 0);

        $associatedBorderId = $this->styleRegistry->getBorderIdForStyleId($styleId);
        $hasStyleCustomBorders = ($associatedBorderId !== null && $associatedBorderId !== 0);

        return ($hasStyleCustomFill || $hasStyleCustomBorders);
    }


    /**
     * Returns the content of the "styles.xml" file, given a list of styles.
     *
     * @return string
     */
    public function getStylesXMLFileContent()
    {
        $content = <<<EOD
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
EOD;

        $content .= $this->getFontsSectionContent();
        $content .= $this->getFillsSectionContent();
        $content .= $this->getBordersSectionContent();
        $content .= $this->getCellStyleXfsSectionContent();
        $content .= $this->getCellXfsSectionContent();
        $content .= $this->getCellStylesSectionContent();

        $content .= <<<EOD
</styleSheet>
EOD;

        return $content;
    }

    /**
     * Returns the content of the "<fonts>" section.
     *
     * @return string
     */
    protected function getFontsSectionContent()
    {
        $registeredStyles = $this->styleRegistry->getRegisteredStyles();

        $content = '<fonts count="' . count($registeredStyles) . '">';

        /** @var Style $style */
        foreach ($registeredStyles as $style) {
            $content .= '<font>';

            $content .= '<sz val="' . $style->getFontSize() . '"/>';
            $content .= '<color rgb="' . Color::toARGB($style->getFontColor()) . '"/>';
            $content .= '<name val="' . $style->getFontName() . '"/>';

            if ($style->isFontBold()) {
                $content .= '<b/>';
            }
            if ($style->isFontItalic()) {
                $content .= '<i/>';
            }
            if ($style->isFontUnderline()) {
                $content .= '<u/>';
            }
            if ($style->isFontStrikethrough()) {
                $content .= '<strike/>';
            }

            $content .= '</font>';
        }

        $content .= '</fonts>';

        return $content;
    }

    /**
     * Returns the content of the "<fills>" section.
     *
     * @return string
     */
    protected function getFillsSectionContent()
    {
        $registeredFills = $this->styleRegistry->getRegisteredFills();

        // Excel reserves two default fills
        $fillsCount = count($registeredFills) + 2;
        $content = sprintf('<fills count="%d">', $fillsCount);

        $content .= '<fill><patternFill patternType="none"/></fill>';
        $content .= '<fill><patternFill patternType="gray125"/></fill>';

        // The other fills are actually registered by setting a background color
        foreach ($registeredFills as $styleId) {
            /** @var Style $style */
            $style = $this->styleRegistry->getStyleFromStyleId($styleId);

            $backgroundColor = $style->getBackgroundColor();
            $content .= sprintf(
                '<fill><patternFill patternType="solid"><fgColor rgb="%s"/></patternFill></fill>',
                $backgroundColor
            );
        }

        $content .= '</fills>';

        return $content;
    }

    /**
     * Returns the content of the "<borders>" section.
     *
     * @return string
     */
    protected function getBordersSectionContent()
    {
        $registeredBorders = $this->styleRegistry->getRegisteredBorders();

        // There is one default border with index 0
        $borderCount = count($registeredBorders) + 1;

        $content = '<borders count="' . $borderCount . '">';

        // Default border starting at index 0
        $content .= '<border><left/><right/><top/><bottom/></border>';

        foreach ($registeredBorders as $styleId) {
            /** @var \Box\Spout\Writer\Common\Entity\Style\Style $style */
            $style = $this->styleRegistry->getStyleFromStyleId($styleId);
            $border = $style->getBorder();
            $content .= '<border>';

            // @link https://github.com/box/spout/issues/271
            $sortOrder = ['left', 'right', 'top', 'bottom'];

            foreach ($sortOrder as $partName) {
                if ($border->hasPart($partName)) {
                    /** @var $part \Box\Spout\Writer\Common\Entity\Style\BorderPart */
                    $part = $border->getPart($partName);
                    $content .= BorderHelper::serializeBorderPart($part);
                }
            }

            $content .= '</border>';
        }

        $content .= '</borders>';

        return $content;
    }

    /**
     * Returns the content of the "<cellStyleXfs>" section.
     *
     * @return string
     */
    protected function getCellStyleXfsSectionContent()
    {
        return <<<EOD
<cellStyleXfs count="1">
    <xf borderId="0" fillId="0" fontId="0" numFmtId="0"/>
</cellStyleXfs>
EOD;
    }

    /**
     * Returns the content of the "<cellXfs>" section.
     *
     * @return string
     */
    protected function getCellXfsSectionContent()
    {
        $registeredStyles = $this->styleRegistry->getRegisteredStyles();

        $content = '<cellXfs count="' . count($registeredStyles) . '">';

        foreach ($registeredStyles as $style) {
            $styleId = $style->getId();
            $fillId = $this->styleRegistry->getFillIdForStyleId($styleId);
            $borderId = $this->styleRegistry->getBorderIdForStyleId($styleId);

            $content .= '<xf numFmtId="0" fontId="' . $styleId . '" fillId="' . $fillId . '" borderId="' . $borderId . '" xfId="0"';

            if ($style->shouldApplyFont()) {
                $content .= ' applyFont="1"';
            }

            $content .= sprintf(' applyBorder="%d"', $style->shouldApplyBorder() ? 1 : 0);

            if ($style->shouldWrapText()) {
                $content .= ' applyAlignment="1">';
                $content .= '<alignment wrapText="1"/>';
                $content .= '</xf>';
            } else {
                $content .= '/>';
            }
        }

        $content .= '</cellXfs>';

        return $content;
    }

    /**
     * Returns the content of the "<cellStyles>" section.
     *
     * @return string
     */
    protected function getCellStylesSectionContent()
    {
        return <<<EOD
<cellStyles count="1">
    <cellStyle builtinId="0" name="Normal" xfId="0"/>
</cellStyles>
EOD;
    }
}


1		<?php
2
3		namespace Box\Spout\Writer\XLSX\Manager\Style;
4
5		use Box\Spout\Writer\Common\Entity\Style\Color;
6		use Box\Spout\Writer\Common\Entity\Style\Style;
7		use Box\Spout\Writer\XLSX\Helper\BorderHelper;
8
9		/**
10		* Class StyleManager
11		* Manages styles to be applied to a cell
12		*
13		* @package Box\Spout\Writer\XLSX\Manager\Style
14		*/
15		class StyleManager extends \Box\Spout\Writer\Common\Manager\Style\StyleManager
16		{
17		/** @var StyleRegistry */
18		protected $styleRegistry;
19
20		/**
21		* For empty cells, we can specify a style or not. If no style are specified,
22		* then the software default will be applied. But sometimes, it may be useful
23		* to override this default style, for instance if the cell should have a
24		* background color different than the default one or some borders
25		* (fonts property don't really matter here).
26		*
27		* @param int $styleId
28		* @return bool Whether the cell should define a custom style
29		*/
30	9	public function shouldApplyStyleOnEmptyCell($styleId)
31		{
32	9	$associatedFillId = $this->styleRegistry->getFillIdForStyleId($styleId);
33	9	$hasStyleCustomFill = ($associatedFillId !== null && $associatedFillId !== 0);
34
35	9	$associatedBorderId = $this->styleRegistry->getBorderIdForStyleId($styleId);
36	9	$hasStyleCustomBorders = ($associatedBorderId !== null && $associatedBorderId !== 0);
37
38	9	return ($hasStyleCustomFill \|\| $hasStyleCustomBorders);
39		}
40
41
42		/**
43		* Returns the content of the "styles.xml" file, given a list of styles.
44		*
45		* @return string
46		*/
47	4	public function getStylesXMLFileContent()
48		{
49		$content = <<<EOD
50	4	<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
51		<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
52		EOD;
53
54	4	$content .= $this->getFontsSectionContent();
55	4	$content .= $this->getFillsSectionContent();
56	4	$content .= $this->getBordersSectionContent();
57	4	$content .= $this->getCellStyleXfsSectionContent();
58	4	$content .= $this->getCellXfsSectionContent();
59	4	$content .= $this->getCellStylesSectionContent();
60
61		$content .= <<<EOD
62	4	</styleSheet>
63		EOD;
64
65	4	return $content;
66		}
67
68		/**
69		* Returns the content of the "<fonts>" section.
70		*
71		* @return string
72		*/
73	4	protected function getFontsSectionContent()
74		{
75	4	$registeredStyles = $this->styleRegistry->getRegisteredStyles();
76
77	4	$content = '<fonts count="' . count($registeredStyles) . '">';
78
79		/** @var Style $style */
80	4	foreach ($registeredStyles as $style) {
81	4	$content .= '<font>';
82
83	4	$content .= '<sz val="' . $style->getFontSize() . '"/>';
84	4	$content .= '<color rgb="' . Color::toARGB($style->getFontColor()) . '"/>';
85	4	$content .= '<name val="' . $style->getFontName() . '"/>';
86
87	4	if ($style->isFontBold()) {
88		$content .= '<b/>';
89		}
90	4	if ($style->isFontItalic()) {
91		$content .= '<i/>';
92		}
93	4	if ($style->isFontUnderline()) {
94		$content .= '<u/>';
95		}
96	4	if ($style->isFontStrikethrough()) {
97		$content .= '<strike/>';
98		}
99
100	4	$content .= '</font>';
101		}
102
103	4	$content .= '</fonts>';
104
105	4	return $content;
106		}
107
108		/**
109		* Returns the content of the "<fills>" section.
110		*
111		* @return string
112		*/
113	4	protected function getFillsSectionContent()
114		{
115	4	$registeredFills = $this->styleRegistry->getRegisteredFills();
116
117		// Excel reserves two default fills
118	4	$fillsCount = count($registeredFills) + 2;
119	4	$content = sprintf('<fills count="%d">', $fillsCount);
120
121	4	$content .= '<fill><patternFill patternType="none"/></fill>';
122	4	$content .= '<fill><patternFill patternType="gray125"/></fill>';
123
124		// The other fills are actually registered by setting a background color
125	4	foreach ($registeredFills as $styleId) {
126		/** @var Style $style */
127		$style = $this->styleRegistry->getStyleFromStyleId($styleId);
128
129		$backgroundColor = $style->getBackgroundColor();
130		$content .= sprintf(
131		'<fill><patternFill patternType="solid"><fgColor rgb="%s"/></patternFill></fill>',
132		$backgroundColor
133		);
134		}
135
136	4	$content .= '</fills>';
137
138	4	return $content;
139		}
140
141		/**
142		* Returns the content of the "<borders>" section.
143		*
144		* @return string
145		*/
146	4	protected function getBordersSectionContent()
147		{
148	4	$registeredBorders = $this->styleRegistry->getRegisteredBorders();
149
150		// There is one default border with index 0
151	4	$borderCount = count($registeredBorders) + 1;
152
153	4	$content = '<borders count="' . $borderCount . '">';
154
155		// Default border starting at index 0
156	4	$content .= '<border><left/><right/><top/><bottom/></border>';
157
158	4	foreach ($registeredBorders as $styleId) {
159		/** @var \Box\Spout\Writer\Common\Entity\Style\Style $style */
160		$style = $this->styleRegistry->getStyleFromStyleId($styleId);
161		$border = $style->getBorder();
162		$content .= '<border>';
163
164		// @link https://github.com/box/spout/issues/271
165		$sortOrder = ['left', 'right', 'top', 'bottom'];
166
167		foreach ($sortOrder as $partName) {
168		if ($border->hasPart($partName)) {
169		/** @var $part \Box\Spout\Writer\Common\Entity\Style\BorderPart */
170		$part = $border->getPart($partName);
171		$content .= BorderHelper::serializeBorderPart($part);
172		}
173		}
174
175		$content .= '</border>';
176		}
177
178	4	$content .= '</borders>';
179
180	4	return $content;
181		}
182
183		/**
184		* Returns the content of the "<cellStyleXfs>" section.
185		*
186		* @return string
187		*/
188	4	protected function getCellStyleXfsSectionContent()
189		{
190		return <<<EOD
191	4	<cellStyleXfs count="1">
192		<xf borderId="0" fillId="0" fontId="0" numFmtId="0"/>
193		</cellStyleXfs>
194		EOD;
195		}
196
197		/**
198		* Returns the content of the "<cellXfs>" section.
199		*
200		* @return string
201		*/
202	4	protected function getCellXfsSectionContent()
203		{
204	4	$registeredStyles = $this->styleRegistry->getRegisteredStyles();
205
206	4	$content = '<cellXfs count="' . count($registeredStyles) . '">';
207
208	4	foreach ($registeredStyles as $style) {
209	4	$styleId = $style->getId();
210	4	$fillId = $this->styleRegistry->getFillIdForStyleId($styleId);
211	4	$borderId = $this->styleRegistry->getBorderIdForStyleId($styleId);
212
213	4	$content .= '<xf numFmtId="0" fontId="' . $styleId . '" fillId="' . $fillId . '" borderId="' . $borderId . '" xfId="0"';
214
215	4	if ($style->shouldApplyFont()) {
216	4	$content .= ' applyFont="1"';
217		}
218
219	4	$content .= sprintf(' applyBorder="%d"', $style->shouldApplyBorder() ? 1 : 0);
220
221	4	if ($style->shouldWrapText()) {
222		$content .= ' applyAlignment="1">';
223		$content .= '<alignment wrapText="1"/>';
224		$content .= '</xf>';
225		} else {
226	4	$content .= '/>';
227		}
228		}
229
230	4	$content .= '</cellXfs>';
231
232	4	return $content;
233		}
234
235		/**
236		* Returns the content of the "<cellStyles>" section.
237		*
238		* @return string
239		*/
240	4	protected function getCellStylesSectionContent()
241		{
242		return <<<EOD
243	4	<cellStyles count="1">
244		<cellStyle builtinId="0" name="Normal" xfId="0"/>
245		</cellStyles>
246		EOD;
247		}
248		}
249

box / spout

Pull Request — develop_3.0 (#434)

StyleManager::getCellXfsSectionContent() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like