VerticalRangeWriterTest::setUp()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 24

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 24
rs 9.536
c 0
b 0
f 0
cc 1
nc 1
nop 0
1
<?php
2
3
class VerticalRangeWriterTest extends \PHPUnit_Framework_TestCase
4
{
5
6
    /**
7
     * @var \PHPExcelReport\Report\Writer\VerticalRangeWriter
8
     */
9
    private $sut;
10
11
    /**
12
     * @var \PHPExcel
13
     */
14
    private $output;
15
16
    protected function setUp()
17
    {
18
        $logger = new \Monolog\Logger('rendertest');
19
        $logger->pushHandler(new \Monolog\Handler\StreamHandler('php://stdout', \Monolog\Logger::DEBUG));
20
21
        $inputFileType = \PHPExcel_IOFactory::identify(__DIR__ . '/../metadata/template/singlelevel.xlsx');
22
        $objReader = \PHPExcel_IOFactory::createReader($inputFileType);
23
        $template = $objReader->load(__DIR__ . '/../metadata/template/singlelevel.xlsx');
24
25
        $this->output = new \PHPExcel();
26
        $outputSheet = $this->output->getActiveSheet();
0 ignored issues
show
Unused Code introduced by
$outputSheet is not used, you could remove the assignment.

This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently.

$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}

Both the $myVar assignment in line 1 and the $higher assignment in line 2 are dead. The first because $myVar is never used and the second because $higher is always overwritten for every possible time line.

Loading history...
27
        $templateSheet = $this->output->addExternalSheet($template->getSheetByName('TEMPLATE'));
28
29
        $namedRange = $this->output->getNamedRange('ROOT');
30
        $rangeData = $templateSheet->rangeToArray($namedRange->getRange(), null, false, true, true);
31
        print_R($rangeData);
32
        $namedRange = $this->output->getNamedRange('LEVEL1');
33
        $rangeData = $templateSheet->rangeToArray($namedRange->getRange(), null, false, true, true);
34
        print_R($rangeData);
35
die();
36
        $reportSheet = new \PHPExcelReport\Report\ReportSheet($outputSheet);
0 ignored issues
show
Unused Code introduced by
$reportSheet = new \PHPE...ortSheet($outputSheet); does not seem to be reachable.

This check looks for unreachable code. It uses sophisticated control flow analysis techniques to find statements which will never be executed.

Unreachable code is most often the result of return, die or exit statements that have been added for debug purposes.

function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}

In the above example, the last return false will never be executed, because a return statement has already been met in every possible execution path.

Loading history...
37
38
        $this->sut = new \PHPExcelReport\Report\Writer\VerticalRangeWriter($templateSheet, $reportSheet, $logger);
39
    }
40
41
    public function testSimple()
42
    {
43
        $data = [
44
            'ROOT' => [
45
                'LEVEL1' => [
46
                    ['LEVEL1_CAPTION' => '1'],
47
                    ['LEVEL1_CAPTION' => '2']
48
                ]
49
            ]
50
        ];
51
52
        $namedRange = $this->output->getNamedRange('ROOT');
53
54
        $this->sut->write($data, $namedRange);
55
56
        $this->output->setActiveSheetIndexByName('TEMPLATE');
57
        $this->output->removeSheetByIndex($this->output->getActiveSheetIndex());
58
        $excelWriter = \PHPExcel_IOFactory::createWriter($this->output, 'Excel2007');
59
        $excelWriter->save(__DIR__ . '/../metadata/output/verticalrangewritertest.xlsx');
60
    }
61
62
}
63