ilUserCertificateRepository Class Reference

Collaboration diagram for ilUserCertificateRepository:

Public Member Functions
	__construct (\ilDBInterface $database=null, ilLogger $logger=null, string $defaultTitle=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)

Private Member Functions
	fetchCertificatesOfObject (int $objId, int $userId)
	fetchLatestVersion (int $objId, int $userId)
	deactivatePreviousCertificates (int $objId, int $userId)
	createUserCertificate ($row)

Private Attributes
	$database
	$logger
	$defaultTitle

Detailed Description

Author

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

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

Constructor & Destructor Documentation

__construct()

ilUserCertificateRepository::__construct	(	\ilDBInterface	$database = null,
		ilLogger	$logger = null,
		string	$defaultTitle = null
	)

Parameters

ilDBInterface	$database
ilLogger	$logger
string | null	$defaultTitle

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

References $database, $defaultTitle, $DIC, and $logger.

      {
        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;
    }

Member Function Documentation

createUserCertificate()

ilUserCertificateRepository::createUserCertificate (   $row )

private

Parameters

$row

Returns

ilUserCertificate

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

References $row.

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

                                                 : ilUserCertificate
    {
        return new ilUserCertificate(
            $row['pattern_certificate_id'],
            $row['obj_id'],
            $row['obj_type'],
            $row['user_id'],
            $row['user_name'],
            (int) $row['acquired_timestamp'],
            $row['certificate_content'],
            $row['template_values'],
            $row['valid_until'],
            $row['version'],
            $row['ilias_version'],
            $row['currently_active'],
            $row['background_image_path'],
            $row['thumbnail_image_path'],
            $row['id']
        );
    }

Here is the caller graph for this function:

deactivatePreviousCertificates()

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

private

Parameters

$objId
$userId

Exceptions

ilDatabaseException

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

Referenced by save().

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

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

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

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

Here is the caller graph for this function:

deleteUserCertificates()

ilUserCertificateRepository::deleteUserCertificates

(

int

$userId

)

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

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

        $sql = 'DELETE FROM il_cert_user_cert WHERE user_id = ' . $this->database->quote($userId, 'integer');

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

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

fetchActiveCertificate()

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

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

References $query, $row, and createUserCertificate().

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

        $sql = 'SELECT *
FROM il_cert_user_cert
WHERE user_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)));

            $this->logger->info(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
	)

Parameters

int	$userId
int	$objectId

Returns

ilUserCertificatePresentation

Exceptions

ilException

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

References $query, $row, and createUserCertificate().

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

        $sql = 'SELECT 
  il_cert_user_cert.pattern_certificate_id,
  il_cert_user_cert.obj_id,
  il_cert_user_cert.obj_type,
  il_cert_user_cert.user_id,
  il_cert_user_cert.user_name,
  il_cert_user_cert.acquired_timestamp,
  il_cert_user_cert.certificate_content,
  il_cert_user_cert.template_values,
  il_cert_user_cert.valid_until,
  il_cert_user_cert.version,
  il_cert_user_cert.ilias_version,
  il_cert_user_cert.currently_active,
  il_cert_user_cert.background_image_path,
  il_cert_user_cert.id,
  il_cert_user_cert.thumbnail_image_path,
  usr_data.lastname,
  (CASE WHEN (object_data.title IS NULL)
    THEN
      CASE WHEN (object_data_del.title IS NULL)
        THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
        ELSE object_data_del.title
        END
    ELSE object_data.title
    END
  ) as title
FROM il_cert_user_cert
LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
LEFT JOIN usr_data ON usr_data.usr_id = il_cert_user_cert.user_id
WHERE il_cert_user_cert.user_id = ' . $this->database->quote($userId, 'integer') . '
AND il_cert_user_cert.obj_id = ' . $this->database->quote($objectId, 'integer') . '
AND il_cert_user_cert.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)));

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

            $userCertificate = $this->createUserCertificate($row);
            return new ilUserCertificatePresentation($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:

fetchActiveCertificates()

ilUserCertificateRepository::fetchActiveCertificates

(

int

$userId

)

Parameters

int	$userId
string	$orderBy

Returns

ilUserCertificatePresentation[]

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

References $query, $result, $row, and createUserCertificate().

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

        $sql = '
SELECT 
  il_cert_user_cert.pattern_certificate_id,
  il_cert_user_cert.obj_id,
  il_cert_user_cert.obj_type,
  il_cert_user_cert.user_id,
  il_cert_user_cert.user_name,
  il_cert_user_cert.acquired_timestamp,
  il_cert_user_cert.certificate_content,
  il_cert_user_cert.template_values,
  il_cert_user_cert.valid_until,
  il_cert_user_cert.version,
  il_cert_user_cert.ilias_version,
  il_cert_user_cert.currently_active,
  il_cert_user_cert.background_image_path,
  il_cert_user_cert.id,
  il_cert_user_cert.thumbnail_image_path,
  (CASE WHEN (object_data.title IS NULL)
    THEN
      CASE WHEN (object_data_del.title IS NULL)
        THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
        ELSE object_data_del.title
        END
    ELSE object_data.title 
    END
  ) as title
FROM il_cert_user_cert
LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
AND currently_active = 1';

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

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

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

        $this->logger->debug(sprintf('Actual results:', json_encode($result)));
        $this->logger->info(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
	)

Parameters

int	$userId
string	$type

Returns

ilUserCertificatePresentation[]

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

References $query, $result, $row, and createUserCertificate().

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

        $sql = 'SELECT 
  il_cert_user_cert.pattern_certificate_id,
  il_cert_user_cert.obj_id,
  il_cert_user_cert.obj_type,
  il_cert_user_cert.user_id,
  il_cert_user_cert.user_name,
  il_cert_user_cert.acquired_timestamp,
  il_cert_user_cert.certificate_content,
  il_cert_user_cert.template_values,
  il_cert_user_cert.valid_until,
  il_cert_user_cert.version,
  il_cert_user_cert.ilias_version,
  il_cert_user_cert.currently_active,
  il_cert_user_cert.background_image_path,
  il_cert_user_cert.id,
  il_cert_user_cert.thumbnail_image_path,
  (CASE WHEN (object_data.title IS NULL)
    THEN
      CASE WHEN (object_data_del.title IS NULL)
        THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
        ELSE object_data_del.title
        END
    ELSE object_data.title 
    END
  ) as title
FROM il_cert_user_cert
LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
 AND obj_type = ' . $this->database->quote($type, 'text') . '
 AND currently_active = 1';

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

        $result = array();
        while ($row = $this->database->fetchAssoc($query)) {
            $userCertificate = $this->createUserCertificate($row);
            
            $presentation = new ilUserCertificatePresentation($userCertificate, $row['title'], '');
            $result[] = $presentation;
        }

        $this->logger->info(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
	)

Parameters

int	$userId
string	$orderBy

Returns

ilUserCertificatePresentation[]

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

References $query, $result, $row, and createUserCertificate().

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

        $sql = '
SELECT 
  il_cert_user_cert.pattern_certificate_id,
  il_cert_user_cert.obj_id,
  il_cert_user_cert.obj_type,
  il_cert_user_cert.user_id,
  il_cert_user_cert.user_name,
  il_cert_user_cert.acquired_timestamp,
  il_cert_user_cert.certificate_content,
  il_cert_user_cert.template_values,
  il_cert_user_cert.valid_until,
  il_cert_user_cert.version,
  il_cert_user_cert.ilias_version,
  il_cert_user_cert.currently_active,
  il_cert_user_cert.background_image_path,
  il_cert_user_cert.id,
  il_cert_user_cert.thumbnail_image_path,
  (CASE WHEN (object_data.title IS NULL)
    THEN
      CASE WHEN (object_data_del.title IS NULL)
        THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
        ELSE object_data_del.title
        END
    ELSE object_data.title 
    END
  ) as title
FROM il_cert_user_cert
LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
WHERE user_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 = array();
        while ($row = $this->database->fetchAssoc($query)) {
            $userCertificate = $this->createUserCertificate($row);

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

        $this->logger->debug(sprintf('Actual results:', json_encode($result)));
        $this->logger->info(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

)

Parameters

int

$id

Returns

ilUserCertificate

Exceptions

ilException

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

References $query, $row, and createUserCertificate().

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

        $sql = 'SELECT * FROM il_cert_user_cert 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)));

            $this->logger->info(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:

fetchCertificatesOfObject()

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

private

Parameters

int	$objId
int	$userId

Returns

array

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

References $query, $result, $row, and createUserCertificate().

Referenced by fetchLatestVersion().

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

        $sql = 'SELECT * FROM il_cert_user_cert
WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
AND obj_id = ' . $this->database->quote($objId, 'integer');

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

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

            $this->logger->info(sprintf('Certificate: ', json_encode($row)));

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

        $this->logger->info(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

Parameters

int	$objId
int	$userId

Returns

string

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

References $template, $version, and fetchCertificatesOfObject().

Referenced by save().

                                                                 : string
    {
        $this->logger->info(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->info(sprintf(
            'END -  fetching of latest certificates of object(user id: "%s", object id: "%s") with verision',
            $userId,
            $objId,
            $version
        ));

        return $version;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

fetchObjectIdsWithCertificateForUser()

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

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

References $query, $result, and $row.

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

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

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

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

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

        $result = array();

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

        return $result;
    }

fetchUserIdsWithCertificateForObject()

ilUserCertificateRepository::fetchUserIdsWithCertificateForObject

(

int

$objectId

)

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

References $query, $result, and $row.

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

        $sql = 'SELECT user_id FROM il_cert_user_cert
WHERE obj_id = ' . $this->database->quote($objectId, 'integer') . '
 AND currently_active = ' . $this->database->quote(1, 'integer');

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

        $result = array();

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

        return $result;
    }

save()

ilUserCertificateRepository::save

(

ilUserCertificate

$userCertificate

)

Parameters

ilUserCertificate

$userCertificate

Returns

ilUserCertificate

Exceptions

ilDatabaseException

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

References $columns, $id, $version, deactivatePreviousCertificates(), fetchLatestVersion(), ilUserCertificate\getAcquiredTimestamp(), ilUserCertificate\getBackgroundImagePath(), ilUserCertificate\getCertificateContent(), ilUserCertificate\getIliasVersion(), ilUserCertificate\getObjId(), ilUserCertificate\getObjType(), ilUserCertificate\getPatternCertificateId(), ilUserCertificate\getTemplateValues(), ilUserCertificate\getThumbnailImagePath(), ilUserCertificate\getUserId(), ilUserCertificate\getUserName(), ilUserCertificate\getValidUntil(), ilUserCertificate\isCurrentlyActive(), and ilUserCertificate\withId().

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

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

        $id = (int) $this->database->nextId('il_cert_user_cert');

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

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

        $columns = array(
            'id' => array('integer', $id),
            'pattern_certificate_id' => array('integer', $userCertificate->getPatternCertificateId()),
            'obj_id' => array('integer', $objId),
            'obj_type' => array('text', $userCertificate->getObjType()),
            'user_id' => array('integer', $userId),
            'user_name' => array('text', $userCertificate->getUserName()),
            'acquired_timestamp' => array('integer', $userCertificate->getAcquiredTimestamp()),
            'certificate_content' => array('clob', $userCertificate->getCertificateContent()),
            'template_values' => array('clob', $userCertificate->getTemplateValues()),
            'valid_until' => array('integer', $userCertificate->getValidUntil()),
            'version' => array('integer', $version),
            'ilias_version' => array('text', $userCertificate->getIliasVersion()),
            'currently_active' => array('integer', (integer) $userCertificate->isCurrentlyActive()),
            'background_image_path' => array('text', $userCertificate->getBackgroundImagePath()),
            'thumbnail_image_path' => array('text', $userCertificate->getThumbnailImagePath())
        );

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

        $this->database->insert('il_cert_user_cert', $columns);

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

Here is the call graph for this function:

Field Documentation

$database

ilUserCertificateRepository::$database

private

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

Referenced by __construct().

$defaultTitle

ilUserCertificateRepository::$defaultTitle

private

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

Referenced by __construct().

$logger

ilUserCertificateRepository::$logger

private

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

Referenced by __construct().

---

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

• Services/Certificate/classes/User/class.ilUserCertificateRepository.php