ApplicationTest\Service\Exporter\TransactionLinesTest::testExportTransactionLines()

Complexity

Conditions	1
Paths	1

Size

Total Lines	22
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function testExportTransactionLines(): void
    {
        /** @var User $user */
        $user = _em()->getRepository(User::class)->getOneByLogin('responsible');
        User::setCurrent($user);

        // Query to generate the Excel file on disk
        $hostname = 'my-ichtus.lan';
        $qb = _em()->getRepository(TransactionLine::class)->createQueryBuilder('tl');
        $handler = new TransactionLines($hostname);
        $result = $qb->getQuery()->getResult();

        $url = $handler->export($result);

        $spreadsheet = $this->readExport($hostname, $url);
        $sheet = $spreadsheet->getActiveSheet();

        // Test a few arbitrary data
        self::assertSame('Date', $sheet->getCell('A1')->getCalculatedValue());
        self::assertSame('Pointé', $sheet->getCell('M1')->getCalculatedValue());
        self::assertSame('Inscription cours nautique Active Member', $sheet->getCell('C2')->getCalculatedValue());
        self::assertSame(45562.5, $sheet->getCell('L14')->getCalculatedValue());
    }