OneSheet\Sheet

Complexity

Total Complexity

9

Size/Duplication

Total Lines	99
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

92.59%

Importance

Changes	3
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	13	2
A	fromDefaults()	0	4	1
A	addRow()	0	8	2
A	addRows()	0	6	2
A	addStyle()	0	4	1
A	sheetFilePath()	0	5	1

<?php
/**
 * @author neun
 * @since  2016-07-03
 */

namespace OneSheet;

/**
 * Class Sheet to write the sheet1.xml contents to file.
 * @package OneSheet
 */
class Sheet
{
    /**
     * Contains the <sheetData> section.
     *
     * @var \SplFileObject
     */
    private $sheetData;

    /**
     * @var RowBuilderInterface
     */
    private $rowBuilder;

    /**
     * Sheet constructor to init SplFileObject and write xml header.
     * Optionally supply a cell id like e.g. A2 to add freeze pane.
     * It has to be done right away, since everything is immediately
     * written to the SplFileObject.
     *
     * @param RowBuilderInterface $rowBuilder
     * @param string|null         $freezePaneCellId
     */
    public function __construct(RowBuilderInterface $rowBuilder, $freezePaneCellId = null)
    {
        $this->rowBuilder = $rowBuilder;

        $this->sheetData = new \SplFileObject(sys_get_temp_dir() . DIRECTORY_SEPARATOR . 'sheet1.xml', 'wb+');
        $this->sheetData->fwrite('<?xml version="1.0" encoding="UTF-8" standalone="yes"?><worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">');

        if (1 == preg_match('~[A-Z]+([1-9]?[0-9]+)$~', $freezePaneCellId, $match)) {
            $this->sheetData->fwrite('<sheetViews><sheetView tabSelected="1" workbookViewId="0" showGridLines="true" showRowColHeaders="1"><pane ySplit="' . (array_pop($match) - 1) . '" topLeftCell="' . $freezePaneCellId . '" activePane="bottomLeft" state="frozen"/></sheetView></sheetViews>');
        }

        $this->sheetData->fwrite('<sheetData>');
    }

    /**
     * Instantiate new sheet with default RowBuilder implementation.
     *
     * @param string|null $freezePaneCellId
     * @return Sheet
     */
    public static function fromDefaults($freezePaneCellId = null)
    {
        return new self(new DefaultRowBuilder(new DefaultCellBuilder()), $freezePaneCellId);
    }

    /**
     * Add single data row to sheet and add new style,
     * if its not an integer.
     *
     * @param array     $dataRow
     * @param int|Style $style
     */
    public function addRow(array $dataRow, $style = 0)
    {
        if (!is_int($style)) {
            $style = $this->addStyle($style);

Consider using a different name than the parameter $style. This often makes code more readable.

        }

        $this->sheetData->fwrite($this->rowBuilder->build($dataRow, $style));
    }

    /**
     * Add multiple data rows to sheet.
     *
     * @param array     $dataRows
     * @param int|Style $style
     */
    public function addRows(array $dataRows, $style = 0)
    {
        foreach ($dataRows as $dataRow) {
            $this->addRow($dataRow, $style);
        }
    }

    /**
     * Add new style and return its id.
     *
     * @param Style $style
     * @return int
     */
    public function addStyle(Style $style)
    {
        return StyleHelper::buildStyle($style);
    }

    /**
     * Write closing xml tag and return path to sheet file.
     *
     * @return string
     */
    public function sheetFilePath()
    {
        $this->sheetData->fwrite('</sheetData></worksheet>');
        return (string)$this->sheetData->getFileInfo();
    }
}