ilUserCertificateRepositoryTest.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

use ILIAS\Certificate\ValueObject\CertificateId;

class ilUserCertificateRepositoryTest extends ilCertificateBaseTestCase
{
    public function testSaveOfUserCertificateToDatabase(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('insert')->with(
            'il_cert_user_cert',
            [
                'id' => ['integer', 141],
                'pattern_certificate_id' => ['integer', 1],
                'obj_id' => ['integer', 20],
                'obj_type' => ['text',  'crs'],
                'usr_id' => ['integer', 400],
                'user_name' => ['text', 'Niels Theen'],
                'acquired_timestamp' => ['integer', 123_456_789],
                'certificate_content' => ['clob', '<xml>Some Content</xml>'],
                'template_values' => ['clob', '[]'],
                'valid_until' => ['integer', null],
                'version' => ['integer', 1],
                'ilias_version' => ['text', 'v5.4.0'],
                'currently_active' => ['integer', true],
                'background_image_path' => ['text', '/some/where/background.jpg'],
                'thumbnail_image_path' => ['text', '/some/where/thumbnail.svg'],
                'background_image_ident' => ['text', '-'],
                'thumbnail_image_ident' => ['text', '-'],
                'certificate_id' => ['text', '11111111-2222-3333-4444-555555555555'],
            ]
        );

        $database->method('tableColumnExists')->willReturnMap(
            [
                ['il_cert_user_cert', 'background_image_path', true],
                ['il_cert_user_cert', 'thumbnail_image_path', true],
            ]
        );

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository(
            $database,
            $logger,
            'someDefaultTitle'
        );

        $userCertificate = new ilUserCertificate(
            1,
            20,
            'crs',
            400,
            'Niels Theen',
            123_456_789,
            '<xml>Some Content</xml>',
            '[]',
            null,
            1,
            'v5.4.0',
            true,
            new CertificateId('11111111-2222-3333-4444-555555555555'),
            '/some/where/background.jpg',
            '/some/where/thumbnail.svg',
            '-',
            '-',
            null
        );

        $repository->save($userCertificate);
    }

    public function testFetchAllActiveCertificateForUser(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('fetchAssoc')->willReturnOnConsecutiveCalls(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/background.jpg',
                'thumbnail_image_path' => '/some/where/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'title' => 'Some Title',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            [
                'id' => 142,
                'pattern_certificate_id' => 5,
                'obj_id' => 3123,
                'obj_type' => 'tst',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 987_654_321,
                'certificate_content' => '<xml>Some Other Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.3.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/else/background.jpg',
                'thumbnail_image_path' => '/some/where/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'title' => 'Someother Title',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            null
        );

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository(
            $database,
            $logger,
            'someDefaultTitle'
        );

        $results = $repository->fetchActiveCertificates(400);

        $this->assertSame(141, $results[0]->getUserCertificate()->getId());
        $this->assertSame(142, $results[1]->getUserCertificate()->getId());
    }

    public function testFetchActiveCertificateForUserObjectCombination(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('fetchAssoc')->willReturnOnConsecutiveCalls(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/background.jpg',
                'thumbnail_image_path' => '/some/where/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            [
                'id' => 142,
                'pattern_certificate_id' => 5,
                'obj_id' => 20,
                'obj_type' => 'tst',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 987_654_321,
                'certificate_content' => '<xml>Some Other Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.3.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/else/background.jpg',
                'thumbnail_image_path' => '/some/where/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ]
        );

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository(
            $database,
            $logger,
            'someDefaultTitle'
        );

        $result = $repository->fetchActiveCertificate(400, 20);

        $this->assertSame(141, $result->getId());
    }

    public function testFetchNoActiveCertificateLeadsToException(): never
    {
        $this->expectException(ilException::class);

        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('fetchAssoc')->willReturn([]);

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository($database, $logger, 'someDefaultTitle');

        $repository->fetchActiveCertificate(400, 20);

        $this->fail('Should never happen. Certificate Found?');
    }

    public function testFetchActiveCertificatesByType(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('fetchAssoc')->willReturnOnConsecutiveCalls(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/background.jpg',
                'thumbnail_image_path' => '/some/where/else/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'title' => 'SomeTitle',
                'someDescription' => 'SomeDescription',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            [
                'id' => 142,
                'pattern_certificate_id' => 5,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 987_654_321,
                'certificate_content' => '<xml>Some Other Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.3.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/else/background.jpg',
                'thumbnail_image_path' => '/some/where/else/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'title' => 'SomeTitle',
                'someDescription' => 'SomeDescription',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            null
        );

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository($database, $logger, 'someDefaultTitle');

        $results = $repository->fetchActiveCertificatesByTypeForPresentation(400, 'crs');

        $this->assertSame(141, $results[0]->getUserCertificate()->getId());
        $this->assertSame(142, $results[1]->getUserCertificate()->getId());
    }

    public function testFetchCertificate(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('fetchAssoc')->willReturn(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_path' => '/some/where/background.jpg',
                'thumbnail_image_path' => '/some/where/else/thumbnail.svg',
                'background_image_ident' => '-',
                'thumbnail_image_ident' => '-',
                'title' => 'SomeTitle',
                'someDescription' => 'SomeDescription',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ]
        );

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');

        $result = $repository->fetchCertificate(141);

        $this->assertSame(141, $result->getId());
    }

    public function testNoCertificateInFetchtCertificateLeadsToException(): never
    {
        $this->expectException(ilException::class);

        $database = $this->createMock(ilDBInterface::class);

        $database->method('nextId')
            ->willReturn(141);

        $database->method('fetchAssoc')
            ->willReturn([]);

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');

        $repository->fetchCertificate(141);

        $this->fail('Should never happen. Certificate Found?');
    }

    public function testFetchObjectWithCertificateForUser(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database
            ->expects($this->once())
            ->method('query');

        $database
            ->expects($this->once())
            ->method('in');

        $database
            ->expects($this->exactly(3))
            ->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                ['obj_id' => 100],
                ['obj_id' => 300],
                []
            );

        $database->method('fetchAssoc')
            ->willReturn([]);

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');

        $userId = 10;
        $objectIds = [200, 300, 400];

        $results = $repository->fetchObjectIdsWithCertificateForUser($userId, $objectIds);

        $this->assertSame([100, 300], $results);
    }

    public function testFetchUserIdsWithCertificateForObject(): void
    {
        $database = $this->createMock(ilDBInterface::class);

        $database
            ->expects($this->once())
            ->method('query');

        $database
            ->expects($this->exactly(3))
            ->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                ['usr_id' => 100],
                ['usr_id' => 300],
                []
            );

        $database->method('fetchAssoc')
            ->willReturn([]);

        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();

        $logger->expects($this->atLeastOnce())
            ->method('debug');

        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');

        $objectId = 10;

        $results = $repository->fetchUserIdsWithCertificateForObject($objectId);

        $this->assertSame([100, 300], $results);
    }
}