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

Passed

Push — develop_3.0 ( fec27e...727422 )

by Adrien

created 2017-11-05 01:12 UTC

WorksheetManager::getCellXML() C

↳ Parent: WorksheetManager

Complexity

Conditions	7
Paths	12

Size

Total Lines	33
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	22
CRAP Score	7

Importance

Changes

Metric	Value
dl	0
loc	33
ccs	22
cts	22
cp	1
rs	6.7272
c	0
b	0
f	0
cc	7
eloc	23
nc	12
nop	3
crap	7

<?php

namespace Box\Spout\Writer\ODS\Manager;

use Box\Spout\Common\Exception\InvalidArgumentException;
use Box\Spout\Common\Exception\IOException;
use Box\Spout\Common\Helper\Escaper\ODS as ODSEscaper;
use Box\Spout\Common\Helper\StringHelper;
use Box\Spout\Writer\Common\Entity\Cell;
use Box\Spout\Writer\Common\Entity\Row;
use Box\Spout\Writer\Common\Entity\Style\Style;
use Box\Spout\Writer\Common\Entity\Worksheet;
use Box\Spout\Writer\Common\Manager\WorksheetManagerInterface;
use Box\Spout\Writer\ODS\Manager\Style\StyleManager;

/**
 * Class WorksheetManager
 * ODS worksheet manager, providing the interfaces to work with ODS worksheets.
 */
class WorksheetManager implements WorksheetManagerInterface
{
    /** @var \Box\Spout\Common\Helper\Escaper\ODS Strings escaper */
    private $stringsEscaper;

    /** @var StringHelper String helper */
    private $stringHelper;

    /** @var StyleManager Manages styles */
    private $styleManager;

    /**
     * WorksheetManager constructor.
     *
     * @param StyleManager $styleManager
     * @param ODSEscaper $stringsEscaper
     * @param StringHelper $stringHelper
     */
    public function __construct(
        StyleManager $styleManager,
        ODSEscaper $stringsEscaper,
        StringHelper $stringHelper
    ) {
        $this->styleManager = $styleManager;
        $this->stringsEscaper = $stringsEscaper;
        $this->stringHelper = $stringHelper;
    }

    /**
     * Prepares the worksheet to accept data
     *
     * @param Worksheet $worksheet The worksheet to start
     * @throws \Box\Spout\Common\Exception\IOException If the sheet data file cannot be opened for writing
     * @return void
     */
    public function startSheet(Worksheet $worksheet)
    {
        $sheetFilePointer = fopen($worksheet->getFilePath(), 'w');
        $this->throwIfSheetFilePointerIsNotAvailable($sheetFilePointer);

        $worksheet->setFilePointer($sheetFilePointer);
    }

    /**
     * Checks if the sheet has been sucessfully created. Throws an exception if not.
     *
     * @param bool|resource $sheetFilePointer Pointer to the sheet data file or FALSE if unable to open the file
     * @throws IOException If the sheet data file cannot be opened for writing
     * @return void
     */
    private function throwIfSheetFilePointerIsNotAvailable($sheetFilePointer)
    {
        if (!$sheetFilePointer) {
            throw new IOException('Unable to open sheet for writing.');
        }
    }

    /**
     * Returns the table XML root node as string.
     *
     * @param Worksheet $worksheet
     * @return string <table> node as string
     */
    public function getTableElementStartAsString(Worksheet $worksheet)
    {
        $externalSheet = $worksheet->getExternalSheet();
        $escapedSheetName = $this->stringsEscaper->escape($externalSheet->getName());
        $tableStyleName = 'ta' . ($externalSheet->getIndex() + 1);

        $tableElement  = '<table:table table:style-name="' . $tableStyleName . '" table:name="' . $escapedSheetName . '">';
        $tableElement .= '<table:table-column table:default-cell-style-name="ce1" table:style-name="co1" table:number-columns-repeated="' . $worksheet->getMaxNumColumns() . '"/>';

        return $tableElement;
    }

    /**
     * Adds a row to the given worksheet.
     *
     * @param Worksheet $worksheet The worksheet to add the row to
     * @param Row $row The row to be added
     * @throws IOException If the data cannot be written
     * @throws InvalidArgumentException If a cell value's type is not supported
     * @return void
     */
    public function addRow(Worksheet $worksheet, Row $row)
    {
        $cells = $row->getCells();
        $cellsCount = count($cells);
        $rowStyle = $row->getStyle();

        $data = '<table:table-row table:style-name="ro1">';

        $currentCellIndex = 0;
        $nextCellIndex = 1;

        for ($i = 0; $i < $cellsCount; $i++) {
            /** @var Cell $cell */
            $cell = $cells[$currentCellIndex];
            /** @var Cell|null $nextCell */
            $nextCell = isset($cells[$nextCellIndex]) ? $cells[$nextCellIndex] : null;

            if ($nextCell === null || $cell->getValue() !== $nextCell->getValue()) {
                $data .= $this->applyStyleAndGetCellXML($cell, $rowStyle, $currentCellIndex, $nextCellIndex);
                $currentCellIndex = $nextCellIndex;
            }

            $nextCellIndex++;
        }

        $data .= '</table:table-row>';

        $wasWriteSuccessful = fwrite($worksheet->getFilePointer(), $data);
        if ($wasWriteSuccessful === false) {
            throw new IOException("Unable to write data in {$worksheet->getFilePath()}");
        }

        // only update the count if the write worked
        $lastWrittenRowIndex = $worksheet->getLastWrittenRowIndex();
        $worksheet->setLastWrittenRowIndex($lastWrittenRowIndex + 1);
    }

    /**
     * Applies styles to the given style, merging the cell's style with its row's style
     * Then builds and returns xml for the cell.
     *
     * @param Cell $cell
     * @param Style $rowStyle
     * @param int $currentCellIndex
     * @param int $nextCellIndex
     * @throws InvalidArgumentException If a cell value's type is not supported
     * @return string
     */
    private function applyStyleAndGetCellXML(Cell $cell, Style $rowStyle, $currentCellIndex, $nextCellIndex)
    {
        // Apply styles - the row style is merged at this point
        $cell->applyStyle($rowStyle);
        $this->styleManager->applyExtraStylesIfNeeded($cell);
        $registeredStyle = $this->styleManager->registerStyle($cell->getStyle());
        $styleIndex = $registeredStyle->getId() + 1; // 1-based

        $numTimesValueRepeated = ($nextCellIndex - $currentCellIndex);

        return $this->getCellXML($cell, $styleIndex, $numTimesValueRepeated);
    }

    /**
     * Returns the cell XML content, given its value.
     *
     * @param Cell $cell The cell to be written
     * @param int $styleIndex Index of the used style
     * @param int $numTimesValueRepeated Number of times the value is consecutively repeated
     * @throws InvalidArgumentException If a cell value's type is not supported
     * @return string The cell XML content
     */
    private function getCellXML(Cell $cell, $styleIndex, $numTimesValueRepeated)
    {
        $data = '<table:table-cell table:style-name="ce' . $styleIndex . '"';

        if ($numTimesValueRepeated !== 1) {
            $data .= ' table:number-columns-repeated="' . $numTimesValueRepeated . '"';
        }

        if ($cell->isString()) {
            $data .= ' office:value-type="string" calcext:value-type="string">';

            $cellValueLines = explode("\n", $cell->getValue());
            foreach ($cellValueLines as $cellValueLine) {
                $data .= '<text:p>' . $this->stringsEscaper->escape($cellValueLine) . '</text:p>';
            }

            $data .= '</table:table-cell>';
        } elseif ($cell->isBoolean()) {
            $data .= ' office:value-type="boolean" calcext:value-type="boolean" office:boolean-value="' . $cell->getValue() . '">';
            $data .= '<text:p>' . $cell->getValue() . '</text:p>';
            $data .= '</table:table-cell>';
        } elseif ($cell->isNumeric()) {
            $data .= ' office:value-type="float" calcext:value-type="float" office:value="' . $cell->getValue() . '">';
            $data .= '<text:p>' . $cell->getValue() . '</text:p>';
            $data .= '</table:table-cell>';
        } elseif ($cell->isEmpty()) {
            $data .= '/>';
        } else {
            throw new InvalidArgumentException('Trying to add a value with an unsupported type: ' . gettype($cell->getValue()));
        }

        return $data;
    }

    /**
     * Closes the worksheet
     *
     * @param Worksheet $worksheet
     * @return void
     */
    public function close(Worksheet $worksheet)
    {
        $worksheetFilePointer = $worksheet->getFilePointer();

        if (!is_resource($worksheetFilePointer)) {
            return;
        }

        fclose($worksheetFilePointer);
    }
}


1		<?php
2
3		namespace Box\Spout\Writer\ODS\Manager;
4
5		use Box\Spout\Common\Exception\InvalidArgumentException;
6		use Box\Spout\Common\Exception\IOException;
7		use Box\Spout\Common\Helper\Escaper\ODS as ODSEscaper;
8		use Box\Spout\Common\Helper\StringHelper;
9		use Box\Spout\Writer\Common\Entity\Cell;
10		use Box\Spout\Writer\Common\Entity\Row;
11		use Box\Spout\Writer\Common\Entity\Style\Style;
12		use Box\Spout\Writer\Common\Entity\Worksheet;
13		use Box\Spout\Writer\Common\Manager\WorksheetManagerInterface;
14		use Box\Spout\Writer\ODS\Manager\Style\StyleManager;
15
16		/**
17		* Class WorksheetManager
18		* ODS worksheet manager, providing the interfaces to work with ODS worksheets.
19		*/
20		class WorksheetManager implements WorksheetManagerInterface
21		{
22		/** @var \Box\Spout\Common\Helper\Escaper\ODS Strings escaper */
23		private $stringsEscaper;
24
25		/** @var StringHelper String helper */
26		private $stringHelper;
27
28		/** @var StyleManager Manages styles */
29		private $styleManager;
30
31		/**
32		* WorksheetManager constructor.
33		*
34		* @param StyleManager $styleManager
35		* @param ODSEscaper $stringsEscaper
36		* @param StringHelper $stringHelper
37		*/
38	35	public function __construct(
39		StyleManager $styleManager,
40		ODSEscaper $stringsEscaper,
41		StringHelper $stringHelper
42		) {
43	35	$this->styleManager = $styleManager;
44	35	$this->stringsEscaper = $stringsEscaper;
45	35	$this->stringHelper = $stringHelper;
46	35	}
47
48		/**
49		* Prepares the worksheet to accept data
50		*
51		* @param Worksheet $worksheet The worksheet to start
52		* @throws \Box\Spout\Common\Exception\IOException If the sheet data file cannot be opened for writing
53		* @return void
54		*/
55	35	public function startSheet(Worksheet $worksheet)
56		{
57	35	$sheetFilePointer = fopen($worksheet->getFilePath(), 'w');
58	35	$this->throwIfSheetFilePointerIsNotAvailable($sheetFilePointer);
59
60	35	$worksheet->setFilePointer($sheetFilePointer);
61	35	}
62
63		/**
64		* Checks if the sheet has been sucessfully created. Throws an exception if not.
65		*
66		* @param bool\|resource $sheetFilePointer Pointer to the sheet data file or FALSE if unable to open the file
67		* @throws IOException If the sheet data file cannot be opened for writing
68		* @return void
69		*/
70	35	private function throwIfSheetFilePointerIsNotAvailable($sheetFilePointer)
71		{
72	35	if (!$sheetFilePointer) {
73		throw new IOException('Unable to open sheet for writing.');
74		}
75	35	}
76
77		/**
78		* Returns the table XML root node as string.
79		*
80		* @param Worksheet $worksheet
81		* @return string <table> node as string
82		*/
83	32	public function getTableElementStartAsString(Worksheet $worksheet)
84		{
85	32	$externalSheet = $worksheet->getExternalSheet();
86	32	$escapedSheetName = $this->stringsEscaper->escape($externalSheet->getName());
87	32	$tableStyleName = 'ta' . ($externalSheet->getIndex() + 1);
88
89	32	$tableElement = '<table:table table:style-name="' . $tableStyleName . '" table:name="' . $escapedSheetName . '">';
90	32	$tableElement .= '<table:table-column table:default-cell-style-name="ce1" table:style-name="co1" table:number-columns-repeated="' . $worksheet->getMaxNumColumns() . '"/>';
91
92	32	return $tableElement;
93		}
94
95		/**
96		* Adds a row to the given worksheet.
97		*
98		* @param Worksheet $worksheet The worksheet to add the row to
99		* @param Row $row The row to be added
100		* @throws IOException If the data cannot be written
101		* @throws InvalidArgumentException If a cell value's type is not supported
102		* @return void
103		*/
104	29	public function addRow(Worksheet $worksheet, Row $row)
105		{
106	29	$cells = $row->getCells();
107	29	$cellsCount = count($cells);
108	29	$rowStyle = $row->getStyle();
109
110	29	$data = '<table:table-row table:style-name="ro1">';
111
112	29	$currentCellIndex = 0;
113	29	$nextCellIndex = 1;
114
115	29	for ($i = 0; $i < $cellsCount; $i++) {
116		/** @var Cell $cell */
117	29	$cell = $cells[$currentCellIndex];
118		/** @var Cell\|null $nextCell */
119	29	$nextCell = isset($cells[$nextCellIndex]) ? $cells[$nextCellIndex] : null;
120
121	29	if ($nextCell === null \|\| $cell->getValue() !== $nextCell->getValue()) {
122	29	$data .= $this->applyStyleAndGetCellXML($cell, $rowStyle, $currentCellIndex, $nextCellIndex);
123	28	$currentCellIndex = $nextCellIndex;
124		}
125
126	28	$nextCellIndex++;
127		}
128
129	28	$data .= '</table:table-row>';
130
131	28	$wasWriteSuccessful = fwrite($worksheet->getFilePointer(), $data);
132	28	if ($wasWriteSuccessful === false) {
133		throw new IOException("Unable to write data in {$worksheet->getFilePath()}");
134		}
135
136		// only update the count if the write worked
137	28	$lastWrittenRowIndex = $worksheet->getLastWrittenRowIndex();
138	28	$worksheet->setLastWrittenRowIndex($lastWrittenRowIndex + 1);
139	28	}
140
141		/**
142		* Applies styles to the given style, merging the cell's style with its row's style
143		* Then builds and returns xml for the cell.
144		*
145		* @param Cell $cell
146		* @param Style $rowStyle
147		* @param int $currentCellIndex
148		* @param int $nextCellIndex
149		* @throws InvalidArgumentException If a cell value's type is not supported
150		* @return string
151		*/
152	29	private function applyStyleAndGetCellXML(Cell $cell, Style $rowStyle, $currentCellIndex, $nextCellIndex)
153		{
154		// Apply styles - the row style is merged at this point
155	29	$cell->applyStyle($rowStyle);
156	29	$this->styleManager->applyExtraStylesIfNeeded($cell);
157	29	$registeredStyle = $this->styleManager->registerStyle($cell->getStyle());
158	29	$styleIndex = $registeredStyle->getId() + 1; // 1-based
159
160	29	$numTimesValueRepeated = ($nextCellIndex - $currentCellIndex);
161
162	29	return $this->getCellXML($cell, $styleIndex, $numTimesValueRepeated);
163		}
164
165		/**
166		* Returns the cell XML content, given its value.
167		*
168		* @param Cell $cell The cell to be written
169		* @param int $styleIndex Index of the used style
170		* @param int $numTimesValueRepeated Number of times the value is consecutively repeated
171		* @throws InvalidArgumentException If a cell value's type is not supported
172		* @return string The cell XML content
173		*/
174	29	private function getCellXML(Cell $cell, $styleIndex, $numTimesValueRepeated)
175		{
176	29	$data = '<table:table-cell table:style-name="ce' . $styleIndex . '"';
177
178	29	if ($numTimesValueRepeated !== 1) {
179	4	$data .= ' table:number-columns-repeated="' . $numTimesValueRepeated . '"';
180		}
181
182	29	if ($cell->isString()) {
183	25	$data .= ' office:value-type="string" calcext:value-type="string">';
184
185	25	$cellValueLines = explode("\n", $cell->getValue());
186	25	foreach ($cellValueLines as $cellValueLine) {
187	25	$data .= '<text:p>' . $this->stringsEscaper->escape($cellValueLine) . '</text:p>';
188		}
189
190	25	$data .= '</table:table-cell>';
191	6	} elseif ($cell->isBoolean()) {
192	2	$data .= ' office:value-type="boolean" calcext:value-type="boolean" office:boolean-value="' . $cell->getValue() . '">';
193	2	$data .= '<text:p>' . $cell->getValue() . '</text:p>';
194	2	$data .= '</table:table-cell>';
195	5	} elseif ($cell->isNumeric()) {
196	2	$data .= ' office:value-type="float" calcext:value-type="float" office:value="' . $cell->getValue() . '">';
197	2	$data .= '<text:p>' . $cell->getValue() . '</text:p>';
198	2	$data .= '</table:table-cell>';
199	4	} elseif ($cell->isEmpty()) {
200	2	$data .= '/>';
201		} else {
202	2	throw new InvalidArgumentException('Trying to add a value with an unsupported type: ' . gettype($cell->getValue()));
203		}
204
205	28	return $data;
206		}
207
208		/**
209		* Closes the worksheet
210		*
211		* @param Worksheet $worksheet
212		* @return void
213		*/
214	32	public function close(Worksheet $worksheet)
215		{
216	32	$worksheetFilePointer = $worksheet->getFilePointer();
217
218	32	if (!is_resource($worksheetFilePointer)) {
219		return;
220		}
221
222	32	fclose($worksheetFilePointer);
223	32	}
224		}
225

box / spout

Push — develop_3.0 ( fec27e...727422 )

WorksheetManager::getCellXML() C

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like