Pim\Bundle\ExcelConnectorBundle\Iterator\FamilyXlsxFileIterator

Complexity

Total Complexity

16

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	createValuesIterator()	0	4	1
D	getChannelData()	0	56	14
A	setDefaultOptions()	0	18	1

<?php

namespace Pim\Bundle\ExcelConnectorBundle\Iterator;

use Symfony\Component\OptionsResolver\OptionsResolver;

/**
 * Family Xls File Iterator
 *
 * @author    Antoine Guigan <antoine@akeneo.com>
 * @copyright 2013 Akeneo SAS (http://www.akeneo.com)
 * @license   http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 */
class FamilyXlsxFileIterator extends AbstractXlsxFileIterator
{
    /**
     * {@inheritdoc}
     */
    protected function createValuesIterator()
    {
        return new \ArrayIterator(array($this->getChannelData()));
    }

    /**
     * {@inheritdoc}
     */
    protected function getChannelData()
    {
        $xls = $this->getExcelObject();
        $data = [ 'attributes' => [] ];
        $attributeLabels = [];
        $channelLabels = [];
        $labelLocales = [];
        $codeColumn = null;
        $useAsLabelColumn = null;
        $channelColumn = null;
        $rowIterator = $xls->createRowIterator($this->worksheetIterator->key(), $this->options['parser_options']);

        foreach ($rowIterator as $index => $row) {
            if ($index == $this->options['code_row']) {
                $data['code'] = $row[$this->options['code_column']];
            }
            if ($index == $this->options['attribute_label_row']) {
                $attributeLabels = $row;
                $channelColumn = count($attributeLabels);
                array_splice($channelLabels, 0, $channelColumn);
                $data['requirements'] = array_fill_keys($channelLabels, []);
                $codeColumn = array_search('code', $attributeLabels);
                $useAsLabelColumn = array_search('use_as_label', $attributeLabels);
            }
            if ($index == $this->options['channel_label_row']) {
                $channelLabels = $row;
            }
            if ($index == $this->options['labels_label_row']) {
                $labelLocales = array_slice($row, $this->options['labels_column']);
            }
            if ($index == $this->options['labels_data_row']) {
                $data['labels'] = $this->getArrayHelper()->combineArrays(
                    $labelLocales,
                    array_slice($row, $this->options['labels_column'])
                );
            }
            if ($index >= (int) $this->options['attribute_data_row']) {
                $code = $row[$codeColumn];
                if ($code === '') {
                    continue;
                }
                $data['attributes'][] = $code;
                if (isset($row[$useAsLabelColumn]) && ('1' === trim($row[$useAsLabelColumn]))) {
                    $data['attribute_as_label'] = $code;
                }
                $channelValues = array_slice($row, $channelColumn);
                foreach ($channelLabels as $index => $channel) {
                    if (isset($channelValues[$index]) && '1' === trim($channelValues[$index])) {
                        $data['requirements'][$channel][] = $code;
                    }
                }
            }
        }

        return $data;
    }

    /**
     * {@inheritdoc}
     */
    protected function setDefaultOptions(OptionsResolver $resolver)
    {
        parent::setDefaultOptions($resolver);

        $resolver->setRequired(
            array(
                'channel_label_row',
                'attribute_label_row',
                'attribute_data_row',
                'code_row',
                'code_column',
                'labels_column',
                'labels_label_row',
                'labels_data_row',
                'labels_column'
            )
        );
    }
}