VerticalRangeWriterTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	60
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	7

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	24	1
A	testSimple()	0	20	1

<?php

class VerticalRangeWriterTest extends \PHPUnit_Framework_TestCase
{

    /**
     * @var \PHPExcelReport\Report\Writer\VerticalRangeWriter
     */
    private $sut;

    /**
     * @var \PHPExcel
     */
    private $output;

    protected function setUp()
    {
        $logger = new \Monolog\Logger('rendertest');
        $logger->pushHandler(new \Monolog\Handler\StreamHandler('php://stdout', \Monolog\Logger::DEBUG));

        $inputFileType = \PHPExcel_IOFactory::identify(__DIR__ . '/../metadata/template/singlelevel.xlsx');
        $objReader = \PHPExcel_IOFactory::createReader($inputFileType);
        $template = $objReader->load(__DIR__ . '/../metadata/template/singlelevel.xlsx');

        $this->output = new \PHPExcel();
        $outputSheet = $this->output->getActiveSheet();

$outputSheet is not used, you could remove the assignment.

        $templateSheet = $this->output->addExternalSheet($template->getSheetByName('TEMPLATE'));

        $namedRange = $this->output->getNamedRange('ROOT');
        $rangeData = $templateSheet->rangeToArray($namedRange->getRange(), null, false, true, true);
        print_R($rangeData);
        $namedRange = $this->output->getNamedRange('LEVEL1');
        $rangeData = $templateSheet->rangeToArray($namedRange->getRange(), null, false, true, true);
        print_R($rangeData);
die();
        $reportSheet = new \PHPExcelReport\Report\ReportSheet($outputSheet);

$reportSheet = new \PHPExcelReport\Report\ReportSheet($outputSheet); does not seem to be reachable.

        $this->sut = new \PHPExcelReport\Report\Writer\VerticalRangeWriter($templateSheet, $reportSheet, $logger);
    }

    public function testSimple()
    {
        $data = [
            'ROOT' => [
                'LEVEL1' => [
                    ['LEVEL1_CAPTION' => '1'],
                    ['LEVEL1_CAPTION' => '2']
                ]
            ]
        ];

        $namedRange = $this->output->getNamedRange('ROOT');

        $this->sut->write($data, $namedRange);

        $this->output->setActiveSheetIndexByName('TEMPLATE');
        $this->output->removeSheetByIndex($this->output->getActiveSheetIndex());
        $excelWriter = \PHPExcel_IOFactory::createWriter($this->output, 'Excel2007');
        $excelWriter->save(__DIR__ . '/../metadata/output/verticalrangewritertest.xlsx');
    }

}