ilUserCertificateRepository Class Reference

Collaboration diagram for ilUserCertificateRepository:

Public Member Functions
	__construct (?ilDBInterface $database=null, ?ilLogger $logger=null, ?string $defaultTitle=null, ?Factory $uuid_factory=null,)
	save (ilUserCertificate $userCertificate)
	fetchActiveCertificates (int $userId)
	fetchActiveCertificatesInIntervalForPresentation (int $userId, int $startTimestamp, int $endTimeStamp)
	fetchActiveCertificate (int $userId, int $objectId)
	fetchActiveCertificateForPresentation (int $userId, int $objectId)
	fetchActiveCertificatesByTypeForPresentation (int $userId, string $type)
	fetchCertificate (int $id)
	fetchObjectIdsWithCertificateForUser (int $userId, array $objectIds)
	fetchUserIdsWithCertificateForObject (int $objectId)
	deleteUserCertificates (int $userId)
	isResourceUsed (string $relative_image_identification)
	deleteUserCertificatesForObject (int $userId, int $obj_id)
	fetchCertificatesForOverview (string $user_language, array $filter, ?Range $range=null, string $order_field='issue_date', string $order_direction='ASC')
	fetchCertificatesForOverviewCount (array $filter, ?Range $range=null)
	requestIdentity ()

Data Fields
const	TABLE_NAME = 'il_cert_user_cert'

Private Member Functions
	fetchCertificatesOfObject (int $objId, int $userId)
	fetchLatestVersion (int $objId, int $userId)
	deactivatePreviousCertificates (int $objId, int $userId)
	createUserCertificate (array $row)
	overviewTableColumnToDbColumn (string $table_column)
	getIssueDateSqlFilter (string $column_name, array $duration)

Private Attributes
readonly ilDBInterface	$database
readonly ilLogger	$logger
readonly string	$defaultTitle
readonly Factory	$uuid_factory

Detailed Description

Author

Niels Theen nthee.nosp@m.n@da.nosp@m.tabay.nosp@m..de

Definition at line 28 of file class.ilUserCertificateRepository.php.

Constructor & Destructor Documentation

__construct()

ilUserCertificateRepository::__construct	(	?ilDBInterface	$database = null,
		?ilLogger	$logger = null,
		?string	$defaultTitle = null,
		?Factory	$uuid_factory = null
	)

Definition at line 37 of file class.ilUserCertificateRepository.php.

References $database, $defaultTitle, $DIC, $logger, $uuid_factory, ILIAS\Repository\database(), ILIAS\Repository\logger(), and null.

      {
        if (null === $database) {
            global $DIC;
            $database = $DIC->database();
        }
        $this->database = $database;

        if (null === $logger) {
            global $DIC;
            $logger = $DIC->logger()->cert();
        }
        $this->logger = $logger;

        if (null === $defaultTitle) {
            global $DIC;
            $defaultTitle = $DIC->language()->txt('certificate_no_object_title');
        }

        $this->defaultTitle = $defaultTitle;

        if (!$uuid_factory) {
            $uuid_factory = new ILIAS\Data\UUID\Factory();
        }
        $this->uuid_factory = $uuid_factory;

    }

Here is the call graph for this function:

Member Function Documentation

createUserCertificate()

ilUserCertificateRepository::createUserCertificate ( array  $row )

private

Parameters

array<string,mixed>

$row

Definition at line 595 of file class.ilUserCertificateRepository.php.

References null.

Referenced by fetchActiveCertificate(), fetchActiveCertificateForPresentation(), fetchActiveCertificates(), fetchActiveCertificatesByTypeForPresentation(), fetchActiveCertificatesInIntervalForPresentation(), fetchCertificate(), fetchCertificatesForOverview(), and fetchCertificatesOfObject().

                                                      : ilUserCertificate
    {
        return new ilUserCertificate(
            (int) $row['pattern_certificate_id'],
            (int) $row['obj_id'],
            $row['obj_type'],
            (int) $row['usr_id'],
            $row['user_name'],
            (int) $row['acquired_timestamp'],
            $row['certificate_content'],
            $row['template_values'],
            (int) $row['valid_until'],
            (int) $row['version'],
            $row['ilias_version'],
            (bool) $row['currently_active'],
            new CertificateId($row['certificate_id']),
            (string) ($row['background_image_path'] ?? ''),
            (string) ($row['tile_image_path'] ?? ''),
            (string) $row['background_image_ident'],
            (string) $row['tile_image_ident'],
            isset($row['id']) ? (int) $row['id'] : null
        );
    }

Here is the caller graph for this function:

deactivatePreviousCertificates()

ilUserCertificateRepository::deactivatePreviousCertificates ( int  $objId, int  $userId  )

private

Definition at line 536 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), and ILIAS\Repository\logger().

Referenced by save().

                                                                            : void
    {
        $this->logger->debug(
            sprintf(
                'START - deactivating previous certificates for user id: "%s" and object id: "%s"',
                $userId,
                $objId
            )
        );

        $sql = '
UPDATE ' . self::TABLE_NAME . '
SET currently_active = 0
WHERE obj_id = ' . $this->database->quote($objId, 'integer') . '
AND  usr_id = ' . $this->database->quote($userId, 'integer');

        $this->database->manipulate($sql);

        $this->logger->debug(
            sprintf(
                'END - deactivating previous certificates for user id: "%s" and object id: "%s"',
                $userId,
                $objId
            )
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

deleteUserCertificates()

ilUserCertificateRepository::deleteUserCertificates

(

int

$userId

)

Definition at line 450 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), and ILIAS\Repository\logger().

                                                       : void
    {
        $this->logger->debug(sprintf('START - Delete certificate for user("%s")"', $userId));

        $sql = 'DELETE FROM ' . self::TABLE_NAME . ' WHERE usr_id = ' . $this->database->quote($userId, 'integer');

        $this->database->manipulate($sql);

        $this->logger->debug(sprintf('END - Successfully deleted certificate for user("%s")"', $userId));
    }

Here is the call graph for this function:

deleteUserCertificatesForObject()

ilUserCertificateRepository::deleteUserCertificatesForObject	(	int	$userId,
		int	$obj_id
	)

Definition at line 619 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), and ILIAS\Repository\logger().

Referenced by removeCertificateForUser().

                                                                             : void
    {
        $this->logger->debug(
            sprintf('START - Delete certificate for user("%s") in object (obj_id: %s)"', $userId, $obj_id)
        );

        $sql = 'DELETE FROM ' . self::TABLE_NAME . ' ' . PHP_EOL
            . ' WHERE usr_id = ' . $this->database->quote($userId, 'integer') . PHP_EOL
            . ' AND obj_id = ' . $this->database->quote($obj_id, 'integer');

        $this->database->manipulate($sql);

        $this->logger->debug(
            sprintf('END - Successfully deleted certificate for user("%s") in object (obj_id: %s)"', $userId, $obj_id)
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

fetchActiveCertificate()

ilUserCertificateRepository::fetchActiveCertificate	(	int	$userId,
		int	$objectId
	)

Exceptions

ilException

Definition at line 223 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

                                                                      : ilUserCertificate
    {
        $this->logger->debug(
            sprintf(
                'START - Fetching all active certificates for user: "%s" and object: "%s"',
                $userId,
                $objectId
            )
        );

        $sql = 'SELECT *
                FROM ' . self::TABLE_NAME . '
                WHERE usr_id = ' . $this->database->quote($userId, 'integer') . '
                AND obj_id = ' . $this->database->quote($objectId, 'integer') . '
                AND currently_active = 1';

        $query = $this->database->query($sql);

        while ($row = $this->database->fetchAssoc($query)) {
            $this->logger->debug(sprintf('Active certificate values: %s', json_encode($row, JSON_THROW_ON_ERROR)));

            $this->logger->debug(
                sprintf(
                    'END -Found active user certificate for user: "%s" and object: "%s"',
                    $userId,
                    $objectId
                )
            );

            return $this->createUserCertificate($row);
        }

        throw new ilException(
            sprintf('There is no active entry for user id: "%s" and object id: "%s"', $userId, $objectId)
        );
    }

Here is the call graph for this function:

fetchActiveCertificateForPresentation()

ilUserCertificateRepository::fetchActiveCertificateForPresentation	(	int	$userId,
		int	$objectId
	)

Exceptions

ilException

Definition at line 263 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

Referenced by ilPortfolioPageGUI\createPersistentCertificateUrl().

                                                                                     : ilUserCertificatePresentation
    {
        $this->logger->debug(
            sprintf(
                'START - Fetching all active certificates for user: "%s" and object: "%s"',
                $userId,
                $objectId
            )
        );

        $sql = 'SELECT ' . self::TABLE_NAME . '.*,
                  il_cert_user_cert.certificate_id,usr_data.lastname,
                  COALESCE(object_data.title, object_data_del.title, ' . $this->database->quote($this->defaultTitle, 'text') . ') AS title
                FROM ' . self::TABLE_NAME . '
                LEFT JOIN object_data ON object_data.obj_id = ' . self::TABLE_NAME . '.obj_id
                LEFT JOIN object_data_del ON object_data_del.obj_id = ' . self::TABLE_NAME . '.obj_id
                LEFT JOIN usr_data ON usr_data.usr_id = ' . self::TABLE_NAME . '.usr_id
                WHERE ' . self::TABLE_NAME . '.usr_id = ' . $this->database->quote($userId, 'integer') . '
                AND ' . self::TABLE_NAME . '.obj_id = ' . $this->database->quote($objectId, 'integer') . '
                AND ' . self::TABLE_NAME . '.currently_active = 1';

        $query = $this->database->query($sql);

        while ($row = $this->database->fetchAssoc($query)) {
            $this->logger->debug(sprintf('Active certificate values: %s', json_encode($row, JSON_THROW_ON_ERROR)));

            $this->logger->debug(
                sprintf(
                    'END -Found active user certificate for user: "%s" and object: "%s"',
                    $userId,
                    $objectId
                )
            );

            $userCertificate = $this->createUserCertificate($row);

            return new ilUserCertificatePresentation(
                (int) $row['obj_id'],
                (string) $row['obj_type'],
                $userCertificate,
                $row['title'],
                '',
                $row['lastname']
            );
        }

        throw new ilException(
            sprintf('There is no active entry for user id: "%s" and object id: "%s"', $userId, $objectId)
        );
    }

Here is the call graph for this function:

Here is the caller graph for this function:

fetchActiveCertificates()

ilUserCertificateRepository::fetchActiveCertificates

(

int

$userId

)

Returns

ilUserCertificatePresentation[]

Definition at line 128 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

                                                        : array
    {
        $this->logger->debug(sprintf('START - Fetching all active certificates for user: "%s"', $userId));

        $sql = '
SELECT ' . self::TABLE_NAME . '.*, 
il_cert_user_cert.certificate_id,
  COALESCE(object_data.title, object_data_del.title, ' . $this->database->quote($this->defaultTitle, 'text') . ') AS title
FROM ' . self::TABLE_NAME . '
LEFT JOIN object_data ON object_data.obj_id = ' . self::TABLE_NAME . '.obj_id
LEFT JOIN object_data_del ON object_data_del.obj_id = ' . self::TABLE_NAME . '.obj_id
WHERE usr_id = ' . $this->database->quote($userId, 'integer') . '
AND currently_active = 1';

        $query = $this->database->query($sql);

        $result = [];
        while ($row = $this->database->fetchAssoc($query)) {
            $userCertificate = $this->createUserCertificate($row);

            $presentation = new ilUserCertificatePresentation(
                (int) $row['obj_id'],
                (string) $row['obj_type'],
                $userCertificate,
                $row['title'],
                ''
            );
            $result[] = $presentation;
        }

        $this->logger->debug(sprintf('Actual results: "%s"', json_encode($result, JSON_THROW_ON_ERROR)));
        $this->logger->debug(
            sprintf(
                'END - All active certificates for user: "%s" total: "%s"',
                $userId,
                count($result)
            )
        );

        return $result;
    }

Here is the call graph for this function:

fetchActiveCertificatesByTypeForPresentation()

ilUserCertificateRepository::fetchActiveCertificatesByTypeForPresentation	(	int	$userId,
		string	$type
	)

Returns

ilUserCertificatePresentation[]

Definition at line 317 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

                                                                                           : array
    {
        $this->logger->debug(
            sprintf(
                'START - Fetching all active certificates for user: "%s" and type: "%s"',
                $userId,
                $type
            )
        );

        $sql = 'SELECT ' . self::TABLE_NAME . '.*,
                  il_cert_user_cert.certificate_id,COALESCE(object_data.title, object_data_del.title, ' . $this->database->quote($this->defaultTitle, 'text') . ') AS title
                FROM ' . self::TABLE_NAME . '
                LEFT JOIN object_data ON object_data.obj_id = ' . self::TABLE_NAME . '.obj_id
                LEFT JOIN object_data_del ON object_data_del.obj_id = ' . self::TABLE_NAME . '.obj_id
                WHERE usr_id = ' . $this->database->quote($userId, 'integer') . '
                 AND obj_type = ' . $this->database->quote($type, 'text') . '
                 AND currently_active = 1';

        $query = $this->database->query($sql);

        $result = [];
        while ($row = $this->database->fetchAssoc($query)) {
            $userCertificate = $this->createUserCertificate($row);

            $presentation = new ilUserCertificatePresentation(
                (int) $row['obj_id'],
                (string) $row['obj_type'],
                $userCertificate,
                $row['title'],
                ''
            );
            $result[] = $presentation;
        }

        $this->logger->debug(
            sprintf(
                'END - Fetching all active certificates for user: "%s" and type: "%s"',
                $userId,
                $type
            )
        );

        return $result;
    }

Here is the call graph for this function:

fetchActiveCertificatesInIntervalForPresentation()

ilUserCertificateRepository::fetchActiveCertificatesInIntervalForPresentation	(	int	$userId,
		int	$startTimestamp,
		int	$endTimeStamp
	)

Returns

ilUserCertificatePresentation[]

Definition at line 173 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

     : array {
        $this->logger->debug(sprintf('START - Fetching all active certificates for user: "%s"', $userId));

        $sql = '
SELECT ' . self::TABLE_NAME . '.*, 
il_cert_user_cert.certificate_id,
  COALESCE(object_data.title, object_data_del.title, ' . $this->database->quote($this->defaultTitle, 'text') . ') AS title
FROM ' . self::TABLE_NAME . '
LEFT JOIN object_data ON object_data.obj_id = ' . self::TABLE_NAME . '.obj_id
LEFT JOIN object_data_del ON object_data_del.obj_id = ' . self::TABLE_NAME . '.obj_id
WHERE usr_id = ' . $this->database->quote($userId, 'integer') . '
AND currently_active = 1
AND acquired_timestamp >= ' . $this->database->quote($startTimestamp, 'integer') . '
AND acquired_timestamp <= ' . $this->database->quote($endTimeStamp, 'integer');

        $query = $this->database->query($sql);

        $result = [];
        while ($row = $this->database->fetchAssoc($query)) {
            $userCertificate = $this->createUserCertificate($row);

            $presentation = new ilUserCertificatePresentation(
                (int) $row['obj_id'],
                (string) $row['obj_type'],
                $userCertificate,
                $row['title'],
                ''
            );
            $result[] = $presentation;
        }

        $this->logger->debug(sprintf('Actual results: "%s"', json_encode($result, JSON_THROW_ON_ERROR)));
        $this->logger->debug(
            sprintf(
                'END - All active certificates for user: "%s" total: "%s"',
                $userId,
                count($result)
            )
        );

        return $result;
    }

Here is the call graph for this function:

fetchCertificate()

ilUserCertificateRepository::fetchCertificate

(

int

$id

)

Exceptions

ilException

Definition at line 366 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

                                             : ilUserCertificate
    {
        $this->logger->debug(sprintf('START - Fetch certificate by id: "%s"', $id));

        $sql = 'SELECT * FROM ' . self::TABLE_NAME . ' WHERE id = ' . $this->database->quote($id, 'integer');

        $query = $this->database->query($sql);

        while ($row = $this->database->fetchAssoc($query)) {
            $this->logger->debug(sprintf('Fetched certificate: "%s"', json_encode($row, JSON_THROW_ON_ERROR)));

            $this->logger->debug(sprintf('END - Fetch certificate by id: "%s"', $id));

            return $this->createUserCertificate($row);
        }

        throw new ilException('No certificate found for user certificate id: ' . $id);
    }

Here is the call graph for this function:

fetchCertificatesForOverview()

ilUserCertificateRepository::fetchCertificatesForOverview	(	string	$user_language,
		array	$filter,
		?Range	$range = null,
		string	$order_field = 'issue_date',
		string	$order_direction = 'ASC'
	)

Definition at line 658 of file class.ilUserCertificateRepository.php.

References ILIAS\UI\Implementation\Component\Table\$range, createUserCertificate(), ILIAS\Repository\database(), getIssueDateSqlFilter(), ILIAS\Data\Range\getLength(), ILIAS\Data\Range\getStart(), null, overviewTableColumnToDbColumn(), and ilDBConstants\T_TEXT.

     : array {
        $order_field = $this->overviewTableColumnToDbColumn($order_field);

        $sql_filters = [];
        foreach ($filter as $key => $value) {
            if ($value === null) {
                continue;
            }

            $column_name = $this->overviewTableColumnToDbColumn($key);

            if ($key === 'issue_date') {
                $sql_filter = $this->getIssueDateSqlFilter($column_name, is_array($value) ? $value : []);
                if ($sql_filter) {
                    $sql_filters[] = $sql_filter;
                }
            } else {
                $sql_filters[] = $this->database->like($column_name, ilDBConstants::T_TEXT, "%$value%");
            }
        }

        if ($range) {
            $this->database->setLimit($range->getLength(), $range->getStart());
        }

        $result = $this->database->query(
            'SELECT cert.*, ' .
            '(CASE
               WHEN (trans.title IS NOT NULL AND LENGTH(trans.title) > 0) THEN trans.title
               WHEN (object_data.title IS NOT NULL AND LENGTH(object_data.title) > 0) THEN object_data.title 
               WHEN (object_data_del.title IS NOT NULL AND LENGTH(object_data_del.title) > 0) THEN object_data_del.title 
               ELSE ' . $this->database->quote($this->defaultTitle, ilDBConstants::T_TEXT) . '
               END
             ) as object, '
            . 'usr_data.login AS owner FROM il_cert_user_cert AS cert '
            . 'LEFT JOIN object_data ON object_data.obj_id = cert.obj_id '
            . 'INNER JOIN usr_data ON usr_data.usr_id = cert.usr_id '
            . 'LEFT JOIN object_data_del ON object_data_del.obj_id = cert.obj_id '
            . 'LEFT JOIN object_translation trans ON trans.obj_id = object_data.obj_id AND trans.lang_code = ' . $this->database->quote($user_language, 'text')
            . ($sql_filters !== [] ? " WHERE " . implode(" AND ", $sql_filters) : "")
            . ' ORDER BY ' . $order_field . ' ' . $order_direction
        );

        $certificates = [];
        while ($row = $this->database->fetchAssoc($result)) {
            $certificates[] = $this->createUserCertificate($row);
        }
        return $certificates;
    }

Here is the call graph for this function:

fetchCertificatesForOverviewCount()

ilUserCertificateRepository::fetchCertificatesForOverviewCount	(	array	$filter,
		?Range	$range = null
	)

Definition at line 754 of file class.ilUserCertificateRepository.php.

References ILIAS\UI\Implementation\Component\Table\$range, ILIAS\Repository\database(), getIssueDateSqlFilter(), ILIAS\Data\Range\getLength(), ILIAS\Data\Range\getStart(), null, and ilDBConstants\T_TEXT.

                                                                                          : int
    {
        $sql_filters = [];
        foreach ($filter as $key => $value) {
            if ($value === null) {
                continue;
            }

            $column_name = $key;
            switch ($key) {
                case 'issue_date':
                    $column_name = 'acquired_timestamp';
                    break;
                case 'object':
                    $column_name = 'object_data.title';
                    break;
                case 'owner':
                    $column_name = 'usr_data.login';
                    break;
                case 'obj_id':
                    $column_name = 'cert.obj_id';
                    break;
            }

            if ($key === 'issue_date') {
                $sql_filter = $this->getIssueDateSqlFilter($column_name, is_array($value) ? $value : []);
                if ($sql_filter) {
                    $sql_filters[] = $sql_filter;
                }
            } else {
                $sql_filters[] = $this->database->like($column_name, ilDBConstants::T_TEXT, "%$value%");
            }
        }

        if ($range) {
            $this->database->setLimit($range->getLength(), $range->getStart());
        }

        $result = $this->database->query(
            'SELECT COUNT(id) as count FROM il_cert_user_cert AS cert '
            . 'LEFT JOIN object_data ON object_data.obj_id = cert.obj_id '
            . 'INNER JOIN usr_data ON usr_data.usr_id = cert.usr_id'
            . ($sql_filters !== [] ? ' AND ' . implode(' AND ', $sql_filters) : '')
        );

        return (int) $this->database->fetchAssoc($result)['count'];
    }

Here is the call graph for this function:

fetchCertificatesOfObject()

ilUserCertificateRepository::fetchCertificatesOfObject ( int  $objId, int  $userId  )

private

Returns

ilUserCertificate[]

Definition at line 464 of file class.ilUserCertificateRepository.php.

References createUserCertificate(), ILIAS\Repository\database(), and ILIAS\Repository\logger().

Referenced by fetchLatestVersion().

                                                                       : array
    {
        $this->logger->debug(
            sprintf(
                'START -  fetching all certificates of object(user id: "%s", object id: "%s")',
                $userId,
                $objId
            )
        );

        $sql = 'SELECT * FROM ' . self::TABLE_NAME . '
            WHERE usr_id = ' . $this->database->quote($userId, 'integer') . '
            AND obj_id = ' . $this->database->quote($objId, 'integer');

        $query = $this->database->query($sql);

        $result = [];
        while ($row = $this->database->fetchAssoc($query)) {
            $this->logger->debug(
                sprintf(
                    'Certificate found: "%s")',
                    json_encode($row, JSON_THROW_ON_ERROR | JSON_PRETTY_PRINT)
                )
            );

            $this->logger->debug(sprintf('Certificate: "%s"', json_encode($row, JSON_THROW_ON_ERROR)));

            $result[] = $this->createUserCertificate($row);
        }

        $this->logger->debug(
            sprintf(
                'END -  fetching all certificates of object(user id: "%s", object id: "%s")',
                $userId,
                $objId
            )
        );

        return $result;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

fetchLatestVersion()

ilUserCertificateRepository::fetchLatestVersion ( int  $objId, int  $userId  )

private

Definition at line 505 of file class.ilUserCertificateRepository.php.

References $version, fetchCertificatesOfObject(), and ILIAS\Repository\logger().

Referenced by save().

                                                                : string
    {
        $this->logger->debug(
            sprintf(
                'START -  fetching of latest certificates of object(user id: "%s", object id: "%s")',
                $userId,
                $objId
            )
        );

        $templates = $this->fetchCertificatesOfObject($objId, $userId);

        $version = 0;
        foreach ($templates as $template) {
            if ($template->getVersion() > $version) {
                $version = $template->getVersion();
            }
        }

        $this->logger->debug(
            sprintf(
                'END -  fetching of latest certificates of object(user id: "%s", object id: "%s") with version "%s"',
                $userId,
                $objId,
                $version
            )
        );

        return (string) $version;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

fetchObjectIdsWithCertificateForUser()

ilUserCertificateRepository::fetchObjectIdsWithCertificateForUser	(	int	$userId,
		array	$objectIds
	)

Parameters

int[]

$objectIds

Returns

int[]

Definition at line 389 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), ILIAS\Repository\int(), and ILIAS\Repository\logger().

                                                                                       : array
    {
        $this->logger->debug(
            sprintf(
                'START - Fetch certificate for user("%s") and ids: "%s"',
                $userId,
                json_encode($objectIds, JSON_THROW_ON_ERROR)
            )
        );

        if ([] === $objectIds) {
            return [];
        }

        $inStatementObjectIds = $this->database->in(
            'obj_id',
            $objectIds,
            false,
            'integer'
        );

        $sql = 'SELECT obj_id FROM ' . self::TABLE_NAME . '
 WHERE usr_id = ' . $this->database->quote($userId, 'integer') .
            ' AND ' . $inStatementObjectIds .
            ' AND currently_active = ' . $this->database->quote(1, 'integer');

        $query = $this->database->query($sql);

        $result = [];

        while ($row = $this->database->fetchAssoc($query)) {
            $this->logger->debug(sprintf('Fetched certificate: "%s"', json_encode($row, JSON_THROW_ON_ERROR)));
            $result[] = (int) $row['obj_id'];
        }

        return $result;
    }

Here is the call graph for this function:

fetchUserIdsWithCertificateForObject()

ilUserCertificateRepository::fetchUserIdsWithCertificateForObject

(

int

$objectId

)

Returns

int[]

Definition at line 430 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), ILIAS\Repository\int(), and ILIAS\Repository\logger().

                                                                       : array
    {
        $this->logger->debug(sprintf('START - Fetch certificate for object("%s")"', $objectId));

        $sql = 'SELECT usr_id FROM ' . self::TABLE_NAME . '
            WHERE obj_id = ' . $this->database->quote($objectId, 'integer') . '
             AND currently_active = ' . $this->database->quote(1, 'integer');

        $query = $this->database->query($sql);

        $result = [];

        while ($row = $this->database->fetchAssoc($query)) {
            $this->logger->debug(sprintf('Fetched certificate: "%s"', json_encode($row, JSON_THROW_ON_ERROR)));
            $result[] = (int) $row['usr_id'];
        }

        return $result;
    }

Here is the call graph for this function:

getIssueDateSqlFilter()

ilUserCertificateRepository::getIssueDateSqlFilter ( string  $column_name, array  $duration  )

private

Parameters

array{from

null|DateTimeImmutable, to: null|DateTimeImmutable} $duration

Definition at line 717 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), null, and ilDBConstants\T_INTEGER.

Referenced by fetchCertificatesForOverview(), and fetchCertificatesForOverviewCount().

                                                                                : ?string
    {
        if (array_keys($duration) === ["from", "to"] && $duration !== ["from" => null, "to" => null]) {
            $from = $duration["from"];
            $to = $duration["to"];

            $sql_filter = "";
            if ($from && $to) {
                $sql_filter = $column_name
                    . ' BETWEEN '
                    . $this->database->quote($from->getTimestamp(), ilDBConstants::T_INTEGER)
                    . ' AND '
                    . $this->database->quote($to->getTimestamp(), ilDBConstants::T_INTEGER);
            }

            if ($from && !$to) {
                $sql_filter = $column_name
                    . ' >= '
                    . $this->database->quote($from->getTimestamp(), ilDBConstants::T_INTEGER);
            }

            if (!$from && $to) {
                $sql_filter = $column_name
                    . ' <= '
                    . $this->database->quote($to->getTimestamp(), ilDBConstants::T_INTEGER);
            }

            if ($sql_filter) {
                return $sql_filter;
            }
        }
        return null;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

isResourceUsed()

ilUserCertificateRepository::isResourceUsed

(

string

$relative_image_identification

)

Definition at line 563 of file class.ilUserCertificateRepository.php.

References ILIAS\Repository\database(), and ILIAS\Repository\logger().

                                                                         : bool
    {
        $this->logger->debug(
            sprintf(
                'START - Checking if any certificate template uses background image path "%s"',
                $relative_image_identification
            )
        );

        $result = $this->database->queryF(
            'SELECT EXISTS(SELECT 1 FROM ' . self::TABLE_NAME . ' WHERE 
            (background_image_ident = %s OR tile_image_ident = %s)
             AND currently_active = 1) AS does_exist',
            ['text', 'text'],
            [$relative_image_identification, $relative_image_identification]
        );

        $exists = (bool) ($this->database->fetchAssoc($result)['does_exist'] ?? false);

        $this->logger->debug(
            sprintf(
                'END - Image path "%s" is ' . $exists ? 'in use' : 'unused',
                $relative_image_identification
            )
        );

        return $exists;
    }

Here is the call graph for this function:

overviewTableColumnToDbColumn()

ilUserCertificateRepository::overviewTableColumnToDbColumn ( string  $table_column )

private

Definition at line 636 of file class.ilUserCertificateRepository.php.

References null.

Referenced by fetchCertificatesForOverview().

                                                                        : string
    {
        $result = match ($table_column) {
            'certificate_id' => $table_column,
            'issue_date' => 'acquired_timestamp',
            'object' => 'object_data.title',
            'owner' => 'usr_data.login',
            'obj_id' => 'cert.obj_id',
            default => null,
        };

        if (!$result) {
            throw new InvalidArgumentException('Invalid table column passed');
        }

        return $result;
    }

Here is the caller graph for this function:

requestIdentity()

ilUserCertificateRepository::requestIdentity

(

)

Definition at line 802 of file class.ilUserCertificateRepository.php.

                                     : CertificateId
    {
        return new CertificateId($this->uuid_factory->uuid4AsString());
    }

save()

ilUserCertificateRepository::save

(

ilUserCertificate

$userCertificate

)

Exceptions

ilDatabaseException

Definition at line 72 of file class.ilUserCertificateRepository.php.

References $id, $objId, $version, ILIAS\Repository\database(), deactivatePreviousCertificates(), fetchLatestVersion(), ilUserCertificate\getAcquiredTimestamp(), ilUserCertificate\getBackgroundImageIdentification(), ilUserCertificate\getBackgroundImagePath(), ilUserCertificate\getCertificateContent(), ilUserCertificate\getCertificateId(), ilUserCertificate\getIliasVersion(), ilUserCertificate\getObjId(), ilUserCertificate\getObjType(), ilUserCertificate\getPatternCertificateId(), ilUserCertificate\getTemplateValues(), ilUserCertificate\getTileImageIdentification(), ilUserCertificate\getTileImagePath(), ilUserCertificate\getUserId(), ilUserCertificate\getUserName(), ilUserCertificate\getValidUntil(), ILIAS\Repository\int(), ilUserCertificate\isCurrentlyActive(), ILIAS\Repository\logger(), and ilUserCertificate\withId().

                                                            : ilUserCertificate
    {
        $this->logger->debug('START - saving of user certificate');

        $version = (int) $this->fetchLatestVersion($userCertificate->getObjId(), $userCertificate->getUserId());
        ++$version;

        $id = $this->database->nextId(self::TABLE_NAME);

        $objId = $userCertificate->getObjId();
        $userId = $userCertificate->getUserId();

        $this->deactivatePreviousCertificates($objId, $userId);

        $columns = [
            'id' => ['integer', $id],
            'pattern_certificate_id' => ['integer', $userCertificate->getPatternCertificateId()],
            'obj_id' => ['integer', $objId],
            'obj_type' => ['text', $userCertificate->getObjType()],
            'usr_id' => ['integer', $userId],
            'user_name' => ['text', $userCertificate->getUserName()],
            'acquired_timestamp' => ['integer', $userCertificate->getAcquiredTimestamp()],
            'certificate_content' => ['clob', $userCertificate->getCertificateContent()],
            'template_values' => ['clob', $userCertificate->getTemplateValues()],
            'valid_until' => ['integer', $userCertificate->getValidUntil()],
            'version' => ['integer', $version],
            'ilias_version' => ['text', $userCertificate->getIliasVersion()],
            'currently_active' => ['integer', (int) $userCertificate->isCurrentlyActive()],
            'background_image_ident' => ['text', $userCertificate->getBackgroundImageIdentification()],
            'tile_image_ident' => ['text', $userCertificate->getTileImageIdentification()],
            'certificate_id' => ['text', $userCertificate->getCertificateId()->asString()]
        ];

        if (
            $this->database->tableColumnExists('il_cert_user_cert', 'background_image_path') &&
            $this->database->tableColumnExists('il_cert_user_cert', 'tile_image_path')
        ) {
            $columns['background_image_path'] = ['text', $userCertificate->getBackgroundImagePath()];
            $columns['tile_image_path'] = ['text', $userCertificate->getTileImagePath()];
        }

        $this->logger->debug(
            sprintf(
                'END - Save certificate with following values: %s',
                json_encode($columns, JSON_THROW_ON_ERROR | JSON_PRETTY_PRINT)
            )
        );

        $this->database->insert(self::TABLE_NAME, $columns);

        return $userCertificate->withId($id)->withVersion($version);
    }

Here is the call graph for this function:

Field Documentation

$database

readonly ilDBInterface ilUserCertificateRepository::$database

private

Definition at line 32 of file class.ilUserCertificateRepository.php.

Referenced by __construct().

$defaultTitle

readonly string ilUserCertificateRepository::$defaultTitle

private

Definition at line 34 of file class.ilUserCertificateRepository.php.

Referenced by __construct().

$logger

readonly ilLogger ilUserCertificateRepository::$logger

private

Definition at line 33 of file class.ilUserCertificateRepository.php.

Referenced by __construct().

$uuid_factory

readonly Factory ilUserCertificateRepository::$uuid_factory

private

Definition at line 35 of file class.ilUserCertificateRepository.php.

Referenced by __construct().

TABLE_NAME

const ilUserCertificateRepository::TABLE_NAME = 'il_cert_user_cert'

Definition at line 30 of file class.ilUserCertificateRepository.php.

---

The documentation for this class was generated from the following file:

• components/ILIAS/Certificate/classes/User/class.ilUserCertificateRepository.php