Aimeos\MW\Container\Content\PHPExcel

Complexity

Total Complexity

11

Size/Duplication

Total Lines	111
Duplicated Lines	0 %

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	current()	0	16	3
A	__construct()	0	6	1
A	key()	0	3	1
A	rewind()	0	3	1
A	valid()	0	3	1
A	next()	0	3	1
A	add()	0	10	2
A	close()	0	2	1

<?php

/**
 * @license LGPLv3, http://www.gnu.org/licenses/lgpl.html
 * @copyright Metaways Infosystems GmbH, 2013
 * @copyright Aimeos (aimeos.org), 2015-2018
 * @package MW
 * @subpackage Container
 */


namespace Aimeos\MW\Container\Content;


/**
 * Implementation of the PHPExcel content object.
 *
 * @package MW
 * @subpackage Container
 */
class PHPExcel
	extends \Aimeos\MW\Container\Content\Base
	implements \Aimeos\MW\Container\Content\Iface
{
	private $sheet;
	private $iterator;


	/**
	 * Initializes the PHPExcel content object.
	 *
	 * @param \PHPExcel_Worksheet $sheet PHPExcel sheet
	 * @param array $options Associative list of key/value pairs for configuration
	 */
	public function __construct( \PHPExcel_Worksheet $sheet, $name, array $options = [] )
	{
		parent::__construct( $sheet, $name, $options );

		$this->sheet = $sheet;
		$this->iterator = $sheet->getRowIterator();
	}


	/**
	 * Cleans up and saves the content.
	 * Does nothing for PHPExcel sheets.
	 */
	public function close()
	{
	}


	/**
	 * Adds a row to the content object.
	 *
	 * @param mixed $data Data to add
	 */
	public function add( $data )
	{
		$columnNum = 0;
		$rowNum = $this->iterator->current()->getRowIndex();

		foreach( (array) $data as $value ) {
			$this->sheet->setCellValueByColumnAndRow( $columnNum++, $rowNum, $value );
		}

		$this->iterator->next();
	}


	/**
	 * Return the current row.
	 *
	 * @return array List of values
	 */
	public function current()
	{
		if( $this->iterator->valid() === false ) {
			return null;
		}

		$iterator = $this->iterator->current()->getCellIterator();
		$iterator->setIterateOnlyExistingCells( false );

		$result = [];

		foreach( $iterator as $cell ) {
			$result[] = $cell->getValue();
		}

		return $result;
	}


	/**
	 * Returns the key of the current row.
	 *
	 * @return integer Position within the PHPExcel sheet
	 */
	public function key()
	{
		return $this->iterator->key();
	}


	/**
	 * Moves forward to next row.
	 */
	public function next()
	{
		$this->iterator->next();
	}


	/**
	 * Resets the current row to the beginning of the sheet.
	 */
	public function rewind()
	{
		$this->iterator->rewind();
	}


	/**
	 * Checks if the current position is valid.
	 *
	 * @return boolean True on success or false on failure
	 */
	public function valid()
	{
		return $this->iterator->valid();
	}
}