OneSheet\Workbook

Complexity

Total Complexity

13

Size/Duplication

Total Lines	88
Duplicated Lines	20.45 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

100%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	setPrintTitleRange()	0	7	4
A	getWorkbookXml()	0	7	1
A	getWorkbookRelsXml()	9	9	2
A	getSheetsXml()	9	9	2
A	getDefinedNamesXml()	0	16	4

<?php

namespace OneSheet;

use OneSheet\Xml\WorkbookXml;

class Workbook
{
    /**
     * @var int
     */
    private $printTitleStart;

    /**
     * @var int
     */
    private $printTitleEnd;

    /**
     * Set the range of rows to repeat when printing the excel file.
     * $startRow=1 and $endRow=1 will repeat the first row only.
     *
     * @param int $startRow
     * @param int $endRow
     */
    public function setPrintTitleRange($startRow, $endRow)
    {
        if ($startRow <= $endRow && is_numeric($startRow) && is_numeric($endRow)) {
            $this->printTitleStart = (int)$startRow;
            $this->printTitleEnd = (int)$endRow;
        }
    }

    /**
     * @param string[] $sheetIds
     * @return string
     */
    public function getWorkbookXml(array $sheetIds)
    {
        $sheets = $this->getSheetsXml($sheetIds);
        $definedNames = $this->getDefinedNamesXml($sheetIds);

        return sprintf(WorkbookXml::WORKBOOK_XML, $sheets, $definedNames);
    }

    /**
     * @param string[] $sheetIds
     * @return string
     */
    public function getWorkbookRelsXml($sheetIds)

This method seems to be duplicated in your project.

    {
        $sheets = '';
        foreach ($sheetIds as $key => $sheetId) {
            $sheets .= sprintf(WorkbookXml::WORKBOOK_REL_XML, $key + 1, $sheetId);
        }

        return sprintf(WorkbookXml::WORKBOOK_RELS_XML, $sheets);
    }

    /**
     * @param string[] $sheetIds
     * @return string
     */
    private function getSheetsXml($sheetIds)

This method seems to be duplicated in your project.

    {
        $sheets = '';
        foreach ($sheetIds as $key => $sheetId) {
            $sheets .= sprintf(WorkbookXml::WORKBOOK_SHEETS_XML, $sheetId, $key + 1, $key + 1);
        }

        return $sheets;
    }

    /**
     * @param string[] $sheetIds
     * @return string
     */
    private function getDefinedNamesXml(array $sheetIds)
    {
        $definedNames = '';
        if ($this->printTitleStart && $this->printTitleEnd) {
            foreach ($sheetIds as $sheetId) {
                $definedNames = sprintf(
                    WorkbookXml::DEFINED_NAMES_XML,
                    $sheetId,
                    $this->printTitleStart,
                    $this->printTitleEnd
                );
            }
        }

        return $definedNames;
    }
}