Nikaia\TranslationSheet\Sheet\TranslationsSheetCoordinates

Complexity

Total Complexity

21

Size/Duplication

Total Lines	163
Duplicated Lines	18.4 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

87.5%

Importance

Changes

0

19 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	setSheetId()	0	6	1
A	setSheetTitle()	0	6	1
A	emptySheet()	0	11	1
A	sheetWithData()	0	11	1
A	headerShortRange()	0	6	1
A	metaColumnsRange()	0	10	1
A	dataShortRange()	0	9	2
A	translationsRange()	0	10	2
A	getColumnsCount()	0	4	1
A	getRowsCount()	0	4	1
A	getLocalesCount()	0	4	1
A	namespaceColumnIndex()	0	4	1
A	groupColumnIndex()	0	4	1
A	keyColumnIndex()	0	4	1
A	sourceFileColumnIndex()	0	4	1
A	headerRange()	10	10	1
A	fullKeyColumnRange()	10	10	1
A	dataRange()	10	10	1

<?php

namespace Nikaia\TranslationSheet\Sheet;

class TranslationsSheetCoordinates

Since you have declared the constructor as private, maybe you should also declare the class as final.

{
    protected $headerRowsCount = 1;

    protected $dataRowsCount = 0;

    protected $columnsCount = 0;

    protected $localesCount = 1;

    protected $sheetId;

    protected $sheetTitle;

    private function __construct()
    {
    }

    public function setSheetId($sheetId)
    {
        $this->sheetId = $sheetId;

        return $this;
    }

    public function setSheetTitle($sheetTitle)
    {
        $this->sheetTitle = $sheetTitle;

        return $this;
    }

    public static function emptySheet($columnsCount, $localesCount, $headerRowsCount)
    {
        $instance = new self;

        $instance->headerRowsCount = $headerRowsCount;
        $instance->dataRowsCount = 10;
        $instance->columnsCount = $columnsCount;
        $instance->localesCount = $localesCount;

        return $instance;
    }

    public static function sheetWithData($dataRowsCount, $columnsCount, $localesCount, $headerRowsCount)
    {
        $instance = new self;

        $instance->headerRowsCount = $headerRowsCount;
        $instance->dataRowsCount = $dataRowsCount;
        $instance->columnsCount = $columnsCount;
        $instance->localesCount = $localesCount;

        return $instance;
    }

    public function headerShortRange()
    {
        $alphabet = range('A', 'Z');

        return $this->sheetTitle.'!A1:'.$alphabet[$this->getColumnsCount() - 1].'1';
    }

    public function headerRange()

This method seems to be duplicated in your project.

    {
        return [
            'sheetId' => $this->sheetId,
            'startRowIndex' => 0,
            'endRowIndex' => 1,
            'startColumnIndex' => 0,
            'endColumnIndex' => $this->getColumnsCount(),
        ];
    }

    public function fullKeyColumnRange()

This method seems to be duplicated in your project.

    {
        return [
            'sheetId' => $this->sheetId,
            'startRowIndex' => 1,
            'endRowIndex' => $this->getRowsCount(),
            'startColumnIndex' => 0,
            'endColumnIndex' => 1,
        ];
    }

    public function metaColumnsRange()
    {
        return [
            'sheetId' => $this->sheetId,
            'startRowIndex' => 1,
            'endRowIndex' => $this->getRowsCount(),
            'startColumnIndex' => $this->getLocalesCount() + 1,
            'endColumnIndex' => $this->getColumnsCount(),
        ];
    }

    public function dataShortRange($firstRow = 2, $noLastRow = false)
    {
        $alphabet = range('A', 'Z');
        $firstColumn = 'A';
        $lastColumn = $alphabet[$this->getColumnsCount() - 1];
        $lastRow = $this->getRowsCount();

        return $this->sheetTitle.'!'.$firstColumn.$firstRow.':'.$lastColumn.($noLastRow ? '' : $lastRow);
    }

    public function dataRange($endRow, $firstRow = 2)

This method seems to be duplicated in your project.

    {
        return [
            'sheetId' => $this->sheetId,
            'startRowIndex' => $firstRow,
            'endRowIndex' => $endRow,
            'startColumnIndex' => 0,
            'endColumnIndex' => $this->getColumnsCount(),
        ];
    }

    public function translationsRange($firstColumn = 1, $rowCount = null)
    {
        return [
            'sheetId' => $this->sheetId,
            'startRowIndex' => 1,
            'endRowIndex' => $rowCount ?: $this->getRowsCount(),
            'startColumnIndex' => $firstColumn,
            'endColumnIndex' => $firstColumn + $this->getLocalesCount(),
        ];
    }

    public function getColumnsCount()
    {
        return $this->columnsCount;
    }

    public function getRowsCount()
    {
        return $this->dataRowsCount + $this->headerRowsCount;
    }

    public function getLocalesCount()
    {
        return $this->localesCount;
    }

    public function namespaceColumnIndex()
    {
        return $this->getLocalesCount() + 1;
    }

    public function groupColumnIndex()
    {
        return $this->getLocalesCount() + 2;
    }

    public function keyColumnIndex()
    {
        return $this->getLocalesCount() + 3;
    }

    public function sourceFileColumnIndex()
    {
        return $this->getLocalesCount() + 4;
    }
}