SheetWrapper::configureMappings() - Code Metrics - Inspection of "Removed duplicate code" - MewesK/TwigSpreadsheetBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( f8e5a3...1b3ca1 )

by Mewes

created 2017-06-05 15:58 UTC

SheetWrapper::configureMappings() B

↳ Parent: SheetWrapper

Complexity

Conditions	3
Paths	1

Size

Total Lines	78
Code Lines	68

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	78
rs	8.9019
c	0
b	0
f	0
cc	3
eloc	68
nc	1
nop	0

How to fix Long Method

<?php

namespace MewesK\TwigSpreadsheetBundle\Wrapper;

use PhpOffice\PhpSpreadsheet\Exception;
use PhpOffice\PhpSpreadsheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Worksheet\ColumnDimension;
use PhpOffice\PhpSpreadsheet\Worksheet\RowDimension;

/**
 * Class SheetWrapper.
 */
class SheetWrapper extends BaseWrapper
{
    /**
     * @var int
     */
    const COLUMN_DEFAULT = 0;
    /**
     * @var int
     */
    const ROW_DEFAULT = 1;

    /**
     * @var DocumentWrapper
     */
    protected $documentWrapper;

    /**
     * @var Worksheet
     */
    protected $object;
    /**
     * @var null|int
     */
    protected $row;
    /**
     * @var null|int
     */
    protected $column;

    /**
     * SheetWrapper constructor.
     *
     * @param array             $context
     * @param \Twig_Environment $environment
     * @param DocumentWrapper   $documentWrapper
     */
    public function __construct(array $context, \Twig_Environment $environment, DocumentWrapper $documentWrapper)
    {
        parent::__construct($context, $environment);

        $this->documentWrapper = $documentWrapper;

        $this->object = null;
        $this->row = null;
        $this->column = null;
    }

    /**
     * @param int|string|null $index
     * @param array           $properties
     *
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \RuntimeException
     */
    public function start($index, array $properties = [])
    {
        if (is_int($index) && $index < $this->documentWrapper->getObject()->getSheetCount()) {
            $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex($index);
        } elseif (is_string($index)) {
            if (!$this->documentWrapper->getObject()->sheetNameExists($index)) {
                // create new sheet with a name
                $this->documentWrapper->getObject()->createSheet()->setTitle($index);
            }
            $this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
        } else {
            // create new sheet without a name
            $this->documentWrapper->getObject()->createSheet();
            $this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);
        }

        $this->attributes['index'] = $index;
        $this->attributes['properties'] = $properties;

        $this->setProperties($properties, $this->mappings);
    }

    /**
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    public function end()
    {
        // auto-size columns
        if (
            isset($this->attributes['properties']['columnDimension']) &&
            is_array($this->attributes['properties']['columnDimension'])
        ) {
            /**
             * @var array $columnDimension
             */
            $columnDimension = $this->attributes['properties']['columnDimension'];
            foreach ($columnDimension as $key => $value) {
                if (isset($value['autoSize'])) {
                    if ('default' === $key) {
                        try {
                            $cellIterator = $this->object->getRowIterator()->current()->getCellIterator();
                            $cellIterator->setIterateOnlyExistingCells(true);

                            foreach ($cellIterator as $cell) {
                                $this->object->getColumnDimension($cell->getColumn())->setAutoSize($value['autoSize']);
                            }
                        } catch (Exception $e) {
                            // ignore exceptions thrown when no cells are defined
                        }
                    } else {
                        $this->object->getColumnDimension($key)->setAutoSize($value['autoSize']);
                    }
                }
            }
        }

        $this->object = null;
        $this->attributes = [];
        $this->row = null;
    }

    public function increaseRow()
    {
        $this->row = $this->row === null ? self::ROW_DEFAULT : $this->row + 1;
    }

    public function increaseColumn()
    {
        $this->column = $this->column === null ? self::COLUMN_DEFAULT : $this->column + 1;
    }

    /**
     * @return Worksheet
     */
    public function getObject(): Worksheet
    {
        return $this->object;
    }

    /**
     * @param Worksheet $object
     */
    public function setObject(Worksheet $object)
    {
        $this->object = $object;
    }

    /**
     * @return int|null
     */
    public function getRow()
    {
        return $this->row;
    }

    /**
     * @param int|null $row
     */
    public function setRow($row)
    {
        $this->row = $row;
    }

    /**
     * @return int|null
     */
    public function getColumn()
    {
        return $this->column;
    }

    /**
     * @param int|null $column
     */
    public function setColumn($column)
    {
        $this->column = $column;
    }

    /**
     * @return array
     */
    protected function configureMappings(): array
    {
        return [
            'autoFilter' => function ($value) { $this->object->setAutoFilter($value); },
            'columnDimension' => [
                '__multi' => function ($column = 'default'): ColumnDimension {
                    return $column === 'default' ?
                        $this->object->getDefaultColumnDimension() :
                        $this->object->getColumnDimension($column);
                },
                'autoSize' => function ($value, ColumnDimension $object) { $object->setAutoSize($value); },
                'collapsed' => function ($value, ColumnDimension $object) { $object->setCollapsed($value); },
                'columnIndex' => function ($value, ColumnDimension $object) { $object->setColumnIndex($value); },
                'outlineLevel' => function ($value, ColumnDimension $object) { $object->setOutlineLevel($value); },
                'visible' => function ($value, ColumnDimension $object) { $object->setVisible($value); },
                'width' => function ($value, ColumnDimension $object) { $object->setWidth($value); },
                'xfIndex' => function ($value, ColumnDimension $object) { $object->setXfIndex($value); },
            ],
            'pageMargins' => [
                'top' => function ($value) { $this->object->getPageMargins()->setTop($value); },
                'bottom' => function ($value) { $this->object->getPageMargins()->setBottom($value); },
                'left' => function ($value) { $this->object->getPageMargins()->setLeft($value); },
                'right' => function ($value) { $this->object->getPageMargins()->setRight($value); },
                'header' => function ($value) { $this->object->getPageMargins()->setHeader($value); },
                'footer' => function ($value) { $this->object->getPageMargins()->setFooter($value); },
            ],
            'pageSetup' => [
                'fitToHeight' => function ($value) { $this->object->getPageSetup()->setFitToHeight($value); },
                'fitToPage' => function ($value) { $this->object->getPageSetup()->setFitToPage($value); },
                'fitToWidth' => function ($value) { $this->object->getPageSetup()->setFitToWidth($value); },
                'horizontalCentered' => function ($value) { $this->object->getPageSetup()->setHorizontalCentered($value); },
                'orientation' => function ($value) { $this->object->getPageSetup()->setOrientation($value); },
                'paperSize' => function ($value) { $this->object->getPageSetup()->setPaperSize($value); },
                'printArea' => function ($value) { $this->object->getPageSetup()->setPrintArea($value); },
                'scale' => function ($value) { $this->object->getPageSetup()->setScale($value); },
                'verticalCentered' => function ($value) { $this->object->getPageSetup()->setVerticalCentered($value); },
            ],
            'printGridlines' => function ($value) { $this->object->setPrintGridlines($value); },
            'protection' => [
                'autoFilter' => function ($value) { $this->object->getProtection()->setAutoFilter($value); },
                'deleteColumns' => function ($value) { $this->object->getProtection()->setDeleteColumns($value); },
                'deleteRows' => function ($value) { $this->object->getProtection()->setDeleteRows($value); },
                'formatCells' => function ($value) { $this->object->getProtection()->setFormatCells($value); },
                'formatColumns' => function ($value) { $this->object->getProtection()->setFormatColumns($value); },
                'formatRows' => function ($value) { $this->object->getProtection()->setFormatRows($value); },
                'insertColumns' => function ($value) { $this->object->getProtection()->setInsertColumns($value); },
                'insertHyperlinks' => function ($value) { $this->object->getProtection()->setInsertHyperlinks($value); },
                'insertRows' => function ($value) { $this->object->getProtection()->setInsertRows($value); },
                'objects' => function ($value) { $this->object->getProtection()->setObjects($value); },
                'password' => function ($value) { $this->object->getProtection()->setPassword($value); },
                'pivotTables' => function ($value) { $this->object->getProtection()->setPivotTables($value); },
                'scenarios' => function ($value) { $this->object->getProtection()->setScenarios($value); },
                'selectLockedCells' => function ($value) { $this->object->getProtection()->setSelectLockedCells($value); },
                'selectUnlockedCells' => function ($value) { $this->object->getProtection()->setSelectUnlockedCells($value); },
                'sheet' => function ($value) { $this->object->getProtection()->setSheet($value); },
                'sort' => function ($value) { $this->object->getProtection()->setSort($value); },
            ],
            'rightToLeft' => function ($value) { $this->object->setRightToLeft($value); },
            'rowDimension' => [
                '__multi' => function ($column = 'default'): RowDimension {
                    return $column === 'default' ?
                        $this->object->getDefaultRowDimension() :
                        $this->object->getRowDimension($column);
                },
                'collapsed' => function ($value, RowDimension $object) { $object->setCollapsed($value); },
                'outlineLevel' => function ($value, RowDimension $object) { $object->setOutlineLevel($value); },
                'rowHeight' => function ($value, RowDimension $object) { $object->setRowHeight($value); },
                'rowIndex' => function ($value, RowDimension $object) { $object->setRowIndex($value); },
                'visible' => function ($value, RowDimension $object) { $object->setVisible($value); },
                'xfIndex' => function ($value, RowDimension $object) { $object->setXfIndex($value); },
                'zeroHeight' => function ($value, RowDimension $object) { $object->setZeroHeight($value); },
            ],
            'sheetState' => function ($value) { $this->object->setSheetState($value); },
            'showGridlines' => function ($value) { $this->object->setShowGridlines($value); },
            'tabColor' => function ($value) { $this->object->getTabColor()->setRGB($value); },
            'zoomScale' => function ($value) { $this->object->getSheetView()->setZoomScale($value); },
        ];
    }
}


1			<?php
2
3			namespace MewesK\TwigSpreadsheetBundle\Wrapper;
4
5			use PhpOffice\PhpSpreadsheet\Exception;
6			use PhpOffice\PhpSpreadsheet\Worksheet;
7			use PhpOffice\PhpSpreadsheet\Worksheet\ColumnDimension;
8			use PhpOffice\PhpSpreadsheet\Worksheet\RowDimension;
9
10			/**
11			* Class SheetWrapper.
12			*/
13			class SheetWrapper extends BaseWrapper
14			{
15			/**
16			* @var int
17			*/
18			const COLUMN_DEFAULT = 0;
19			/**
20			* @var int
21			*/
22			const ROW_DEFAULT = 1;
23
24			/**
25			* @var DocumentWrapper
26			*/
27			protected $documentWrapper;
28
29			/**
30			* @var Worksheet
31			*/
32			protected $object;
33			/**
34			* @var null\|int
35			*/
36			protected $row;
37			/**
38			* @var null\|int
39			*/
40			protected $column;
41
42			/**
43			* SheetWrapper constructor.
44			*
45			* @param array $context
46			* @param \Twig_Environment $environment
47			* @param DocumentWrapper $documentWrapper
48			*/
49			public function __construct(array $context, \Twig_Environment $environment, DocumentWrapper $documentWrapper)
50			{
51			parent::__construct($context, $environment);
52
53			$this->documentWrapper = $documentWrapper;
54
55			$this->object = null;
56			$this->row = null;
57			$this->column = null;
58			}
59
60			/**
61			* @param int\|string\|null $index
62			* @param array $properties
63			*
64			* @throws \PhpOffice\PhpSpreadsheet\Exception
65			* @throws \RuntimeException
66			*/
67			public function start($index, array $properties = [])
68			{
69			if (is_int($index) && $index < $this->documentWrapper->getObject()->getSheetCount()) {
70			$this->object = $this->documentWrapper->getObject()->setActiveSheetIndex($index);
71			} elseif (is_string($index)) {
72			if (!$this->documentWrapper->getObject()->sheetNameExists($index)) {
73			// create new sheet with a name
74			$this->documentWrapper->getObject()->createSheet()->setTitle($index);
75			}
76			$this->object = $this->documentWrapper->getObject()->setActiveSheetIndexByName($index);
77			} else {
78			// create new sheet without a name
79			$this->documentWrapper->getObject()->createSheet();
80			$this->object = $this->documentWrapper->getObject()->setActiveSheetIndex(0);
81			}
82
83			$this->attributes['index'] = $index;
84			$this->attributes['properties'] = $properties;
85
86			$this->setProperties($properties, $this->mappings);
87			}
88
89			/**
90			* @throws \PhpOffice\PhpSpreadsheet\Exception
91			*/
92			public function end()
93			{
94			// auto-size columns
95			if (
96			isset($this->attributes['properties']['columnDimension']) &&
97			is_array($this->attributes['properties']['columnDimension'])
98			) {
99			/**
100			* @var array $columnDimension
101			*/
102			$columnDimension = $this->attributes['properties']['columnDimension'];
103			foreach ($columnDimension as $key => $value) {
104			if (isset($value['autoSize'])) {
105			if ('default' === $key) {
106			try {
107			$cellIterator = $this->object->getRowIterator()->current()->getCellIterator();
108			$cellIterator->setIterateOnlyExistingCells(true);
109
110			foreach ($cellIterator as $cell) {
111			$this->object->getColumnDimension($cell->getColumn())->setAutoSize($value['autoSize']);
112			}
113			} catch (Exception $e) {
114			// ignore exceptions thrown when no cells are defined
115			}
116			} else {
117			$this->object->getColumnDimension($key)->setAutoSize($value['autoSize']);
118			}
119			}
120			}
121			}
122
123			$this->object = null;
124			$this->attributes = [];
125			$this->row = null;
126			}
127
128			public function increaseRow()
129			{
130			$this->row = $this->row === null ? self::ROW_DEFAULT : $this->row + 1;
131			}
132
133			public function increaseColumn()
134			{
135			$this->column = $this->column === null ? self::COLUMN_DEFAULT : $this->column + 1;
136			}
137
138			/**
139			* @return Worksheet
140			*/
141			public function getObject(): Worksheet
142			{
143			return $this->object;
144			}
145
146			/**
147			* @param Worksheet $object
148			*/
149			public function setObject(Worksheet $object)
150			{
151			$this->object = $object;
152			}
153
154			/**
155			* @return int\|null
156			*/
157			public function getRow()
158			{
159			return $this->row;
160			}
161
162			/**
163			* @param int\|null $row
164			*/
165			public function setRow($row)
166			{
167			$this->row = $row;
168			}
169
170			/**
171			* @return int\|null
172			*/
173			public function getColumn()
174			{
175			return $this->column;
176			}
177
178			/**
179			* @param int\|null $column
180			*/
181			public function setColumn($column)
182			{
183			$this->column = $column;
184			}
185
186			/**
187			* @return array
188			*/
189			protected function configureMappings(): array
190			{
191			return [
192			'autoFilter' => function ($value) { $this->object->setAutoFilter($value); },
193			'columnDimension' => [
194			'__multi' => function ($column = 'default'): ColumnDimension {
195			return $column === 'default' ?
196			$this->object->getDefaultColumnDimension() :
197			$this->object->getColumnDimension($column);
198			},
199			'autoSize' => function ($value, ColumnDimension $object) { $object->setAutoSize($value); },
200			'collapsed' => function ($value, ColumnDimension $object) { $object->setCollapsed($value); },
201			'columnIndex' => function ($value, ColumnDimension $object) { $object->setColumnIndex($value); },
202			'outlineLevel' => function ($value, ColumnDimension $object) { $object->setOutlineLevel($value); },
203			'visible' => function ($value, ColumnDimension $object) { $object->setVisible($value); },
204			'width' => function ($value, ColumnDimension $object) { $object->setWidth($value); },
205			'xfIndex' => function ($value, ColumnDimension $object) { $object->setXfIndex($value); },
206			],
207			'pageMargins' => [
208			'top' => function ($value) { $this->object->getPageMargins()->setTop($value); },
209			'bottom' => function ($value) { $this->object->getPageMargins()->setBottom($value); },
210			'left' => function ($value) { $this->object->getPageMargins()->setLeft($value); },
211			'right' => function ($value) { $this->object->getPageMargins()->setRight($value); },
212			'header' => function ($value) { $this->object->getPageMargins()->setHeader($value); },
213			'footer' => function ($value) { $this->object->getPageMargins()->setFooter($value); },
214			],
215			'pageSetup' => [
216			'fitToHeight' => function ($value) { $this->object->getPageSetup()->setFitToHeight($value); },
217			'fitToPage' => function ($value) { $this->object->getPageSetup()->setFitToPage($value); },
218			'fitToWidth' => function ($value) { $this->object->getPageSetup()->setFitToWidth($value); },
219			'horizontalCentered' => function ($value) { $this->object->getPageSetup()->setHorizontalCentered($value); },
220			'orientation' => function ($value) { $this->object->getPageSetup()->setOrientation($value); },
221			'paperSize' => function ($value) { $this->object->getPageSetup()->setPaperSize($value); },
222			'printArea' => function ($value) { $this->object->getPageSetup()->setPrintArea($value); },
223			'scale' => function ($value) { $this->object->getPageSetup()->setScale($value); },
224			'verticalCentered' => function ($value) { $this->object->getPageSetup()->setVerticalCentered($value); },
225			],
226			'printGridlines' => function ($value) { $this->object->setPrintGridlines($value); },
227			'protection' => [
228			'autoFilter' => function ($value) { $this->object->getProtection()->setAutoFilter($value); },
229			'deleteColumns' => function ($value) { $this->object->getProtection()->setDeleteColumns($value); },
230			'deleteRows' => function ($value) { $this->object->getProtection()->setDeleteRows($value); },
231			'formatCells' => function ($value) { $this->object->getProtection()->setFormatCells($value); },
232			'formatColumns' => function ($value) { $this->object->getProtection()->setFormatColumns($value); },
233			'formatRows' => function ($value) { $this->object->getProtection()->setFormatRows($value); },
234			'insertColumns' => function ($value) { $this->object->getProtection()->setInsertColumns($value); },
235			'insertHyperlinks' => function ($value) { $this->object->getProtection()->setInsertHyperlinks($value); },
236			'insertRows' => function ($value) { $this->object->getProtection()->setInsertRows($value); },
237			'objects' => function ($value) { $this->object->getProtection()->setObjects($value); },
238			'password' => function ($value) { $this->object->getProtection()->setPassword($value); },
239			'pivotTables' => function ($value) { $this->object->getProtection()->setPivotTables($value); },
240			'scenarios' => function ($value) { $this->object->getProtection()->setScenarios($value); },
241			'selectLockedCells' => function ($value) { $this->object->getProtection()->setSelectLockedCells($value); },
242			'selectUnlockedCells' => function ($value) { $this->object->getProtection()->setSelectUnlockedCells($value); },
243			'sheet' => function ($value) { $this->object->getProtection()->setSheet($value); },
244			'sort' => function ($value) { $this->object->getProtection()->setSort($value); },
245			],
246			'rightToLeft' => function ($value) { $this->object->setRightToLeft($value); },
247			'rowDimension' => [
248			'__multi' => function ($column = 'default'): RowDimension {
249			return $column === 'default' ?
250			$this->object->getDefaultRowDimension() :
251			$this->object->getRowDimension($column);
252			},
253			'collapsed' => function ($value, RowDimension $object) { $object->setCollapsed($value); },
254			'outlineLevel' => function ($value, RowDimension $object) { $object->setOutlineLevel($value); },
255			'rowHeight' => function ($value, RowDimension $object) { $object->setRowHeight($value); },
256			'rowIndex' => function ($value, RowDimension $object) { $object->setRowIndex($value); },
257			'visible' => function ($value, RowDimension $object) { $object->setVisible($value); },
258			'xfIndex' => function ($value, RowDimension $object) { $object->setXfIndex($value); },
259			'zeroHeight' => function ($value, RowDimension $object) { $object->setZeroHeight($value); },
260			],
261			'sheetState' => function ($value) { $this->object->setSheetState($value); },
262			'showGridlines' => function ($value) { $this->object->setShowGridlines($value); },
263			'tabColor' => function ($value) { $this->object->getTabColor()->setRGB($value); },
264			'zoomScale' => function ($value) { $this->object->getSheetView()->setZoomScale($value); },
265			];
266			}
267			}
268

MewesK / TwigSpreadsheetBundle

GitHub Access Token became invalid

Push — master ( f8e5a3...1b3ca1 )

SheetWrapper::configureMappings() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like