nikaia / translation-sheet

src/Sheet/TranslationsSheetCoordinates.php

<?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()
    {
        return $this->sheetTitle.'!A1:'.self::stringFromColumnIndex($this->getColumnsCount()).'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)
    {
        $firstColumn = 'A';
        $lastColumn = self::stringFromColumnIndex($this->getColumnsCount());
        $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;
    }

    /**
     * String from column index.
     *
     * @see https://github.com/PHPOffice/PhpSpreadsheet/blob/master/src/PhpSpreadsheet/Cell/Coordinate.php Source of implementation.
     *
     * @license https://raw.githubusercontent.com/PHPOffice/PhpSpreadsheet/master/LICENSE LGPL (GNU LESSER GENERAL PUBLIC LICENSE)
     *
     * @param int $columnIndex Column index (A = 1)
     *
     * @return string
     */
    public static function stringFromColumnIndex($columnIndex)
    {
        static $indexCache = [];
        if (! isset($indexCache[$columnIndex])) {
            $indexValue = $columnIndex;
            $base26 = null;
            do {
                $characterValue = ($indexValue % 26) ?: 26;
                $indexValue = ($indexValue - $characterValue) / 26;
                $base26 = chr($characterValue + 64).($base26 ?: '');
            } while ($indexValue > 0);
            $indexCache[$columnIndex] = $base26;
        }

        return $indexCache[$columnIndex];
    }
}