ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
Public Member Functions | Private Member Functions | Private Attributes
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.

33 {
34 if (null === $database) {
35 global $DIC;
36 $database = $DIC->database();
37 }
38 $this->database = $database;
39
40 if (null === $logger) {
41 global $DIC;
42 $logger = $DIC->logger()->cert();
43 }
44 $this->logger = $logger;
45
46 if (null === $defaultTitle) {
47 global $DIC;
48 $defaultTitle = $DIC->language()->txt('certificate_no_object_title');
49 }
50 $this->defaultTitle = $defaultTitle;
51 }
$DIC
$DIC
Definition: xapitoken.php:46

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

Member Function Documentation

◆ createUserCertificate()

ilUserCertificateRepository::createUserCertificate (   $row)
private
Parameters
$row
Returns
ilUserCertificate

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

558 : ilUserCertificate
559 {
560 return new ilUserCertificate(
561 $row['pattern_certificate_id'],
562 $row['obj_id'],
563 $row['obj_type'],
564 $row['user_id'],
565 $row['user_name'],
566 (int) $row['acquired_timestamp'],
567 $row['certificate_content'],
568 $row['template_values'],
569 $row['valid_until'],
570 $row['version'],
571 $row['ilias_version'],
572 $row['currently_active'],
573 $row['background_image_path'],
574 $row['thumbnail_image_path'],
575 $row['id']
576 );
577 }

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

+ Here is the caller graph for this function:

◆ deactivatePreviousCertificates()

ilUserCertificateRepository::deactivatePreviousCertificates ( int  $objId,
int  $userId 
)
private
Parameters
$objId
$userId
Exceptions
ilDatabaseException

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

540 {
541 $this->logger->info(sprintf('START - deactivating previous certificates for user id: "%s" and object id: "%s"', $userId, $objId));
542
543 $sql = '
544UPDATE il_cert_user_cert
545SET currently_active = 0
546WHERE obj_id = ' . $this->database->quote($objId, 'integer') . '
547AND user_id = ' . $this->database->quote($userId, 'integer');
548
549 $this->database->manipulate($sql);
550
551 $this->logger->info(sprintf('END - deactivating previous certificates for user id: "%s" and object id: "%s"', $userId, $objId));
552 }
$objId
$objId
Definition: xapitoken.php:41

References $objId.

Referenced by save().

+ Here is the caller graph for this function:

◆ deleteUserCertificates()

ilUserCertificateRepository::deleteUserCertificates ( int  $userId)

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

452 {
453 $this->logger->info(sprintf('START - Delete certificate for user("%s")"', $userId));
454
455 $sql = 'DELETE FROM il_cert_user_cert WHERE user_id = ' . $this->database->quote($userId, 'integer');
456
457 $this->database->manipulate($sql);
458
459 $this->logger->info(sprintf('END - Successfully deleted certificate for user("%s")"', $userId));
460 }

◆ fetchActiveCertificate()

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

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

225 : ilUserCertificate
226 {
227 $this->logger->info(sprintf('START - Fetching all active certificates for user: "%s" and object: "%s"', $userId, $objectId));
228
229 $sql = 'SELECT *
230FROM il_cert_user_cert
231WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
232AND obj_id = ' . $this->database->quote($objectId, 'integer') . '
233AND currently_active = 1';
234
235 $query = $this->database->query($sql);
236
237 while ($row = $this->database->fetchAssoc($query)) {
238 $this->logger->debug(sprintf('Active certificate values: %s', json_encode($row)));
239
240 $this->logger->info(sprintf('END -Found active user certificate for user: "%s" and object: "%s"', $userId, $objectId));
241
242 return $this->createUserCertificate($row);
243 }
244
245 throw new ilException(sprintf('There is no active entry for user id: "%s" and object id: "%s"', $userId, $objectId));
246 }
ilException
Base class for ILIAS Exception handling.
Definition: class.ilException.php:35
$query
$query
Definition: proxy_ylocal.php:13

References $query, and createUserCertificate().

+ 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 254 of file class.ilUserCertificateRepository.php.

254 : ilUserCertificatePresentation
255 {
256 $this->logger->info(sprintf('START - Fetching all active certificates for user: "%s" and object: "%s"', $userId, $objectId));
257
258 $sql = 'SELECT
259 il_cert_user_cert.pattern_certificate_id,
260 il_cert_user_cert.obj_id,
261 il_cert_user_cert.obj_type,
262 il_cert_user_cert.user_id,
263 il_cert_user_cert.user_name,
264 il_cert_user_cert.acquired_timestamp,
265 il_cert_user_cert.certificate_content,
266 il_cert_user_cert.template_values,
267 il_cert_user_cert.valid_until,
268 il_cert_user_cert.version,
269 il_cert_user_cert.ilias_version,
270 il_cert_user_cert.currently_active,
271 il_cert_user_cert.background_image_path,
272 il_cert_user_cert.id,
273 il_cert_user_cert.thumbnail_image_path,
274 usr_data.lastname,
275 (CASE WHEN (object_data.title IS NULL)
276 THEN
277 CASE WHEN (object_data_del.title IS NULL)
278 THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
279 ELSE object_data_del.title
280 END
281 ELSE object_data.title
282 END
283 ) as title
284FROM il_cert_user_cert
285LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
286LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
287LEFT JOIN usr_data ON usr_data.usr_id = il_cert_user_cert.user_id
288WHERE il_cert_user_cert.user_id = ' . $this->database->quote($userId, 'integer') . '
289AND il_cert_user_cert.obj_id = ' . $this->database->quote($objectId, 'integer') . '
290AND il_cert_user_cert.currently_active = 1';
291
292 $query = $this->database->query($sql);
293
294 while ($row = $this->database->fetchAssoc($query)) {
295 $this->logger->debug(sprintf('Active certificate values: %s', json_encode($row)));
296
297 $this->logger->info(sprintf('END -Found active user certificate for user: "%s" and object: "%s"', $userId, $objectId));
298
299 $userCertificate = $this->createUserCertificate($row);
300 return new ilUserCertificatePresentation(
301 (int) $row['obj_id'],
302 (string) $row['obj_type'],
303 $userCertificate,
304 $row['title'],
305 '',
306 $row['lastname']
307 );
308 }
309
310 throw new ilException(sprintf('There is no active entry for user id: "%s" and object id: "%s"', $userId, $objectId));
311 }

References $query, and createUserCertificate().

+ 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.

102 : array
103 {
104 $this->logger->info(sprintf('START - Fetching all active certificates for user: "%s"', $userId));
105
106 $sql = '
107SELECT
108 il_cert_user_cert.pattern_certificate_id,
109 il_cert_user_cert.obj_id,
110 il_cert_user_cert.obj_type,
111 il_cert_user_cert.user_id,
112 il_cert_user_cert.user_name,
113 il_cert_user_cert.acquired_timestamp,
114 il_cert_user_cert.certificate_content,
115 il_cert_user_cert.template_values,
116 il_cert_user_cert.valid_until,
117 il_cert_user_cert.version,
118 il_cert_user_cert.ilias_version,
119 il_cert_user_cert.currently_active,
120 il_cert_user_cert.background_image_path,
121 il_cert_user_cert.id,
122 il_cert_user_cert.thumbnail_image_path,
123 (CASE WHEN (object_data.title IS NULL)
124 THEN
125 CASE WHEN (object_data_del.title IS NULL)
126 THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
127 ELSE object_data_del.title
128 END
129 ELSE object_data.title
130 END
131 ) as title
132FROM il_cert_user_cert
133LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
134LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
135WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
136AND currently_active = 1';
137
138 $query = $this->database->query($sql);
139
140 $result = array();
141 while ($row = $this->database->fetchAssoc($query)) {
142 $userCertificate = $this->createUserCertificate($row);
143
144 $presentation = new ilUserCertificatePresentation(
145 (int) $row['obj_id'],
146 (string) $row['obj_type'],
147 $userCertificate,
148 $row['title'],
149 ''
150 );
151 $result[] = $presentation;
152 }
153
154 $this->logger->debug(sprintf('Actual results: "%s"', json_encode($result)));
155 $this->logger->info(sprintf('END - All active certificates for user: "%s" total: "%s"', $userId, count($result)));
156
157 return $result;
158 }
$result
$result
Definition: CleanUpTest.php:463

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

+ 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 318 of file class.ilUserCertificateRepository.php.

318 : array
319 {
320 $this->logger->info(sprintf('START - Fetching all active certificates for user: "%s" and type: "%s"', $userId, $type));
321
322 $sql = 'SELECT
323 il_cert_user_cert.pattern_certificate_id,
324 il_cert_user_cert.obj_id,
325 il_cert_user_cert.obj_type,
326 il_cert_user_cert.user_id,
327 il_cert_user_cert.user_name,
328 il_cert_user_cert.acquired_timestamp,
329 il_cert_user_cert.certificate_content,
330 il_cert_user_cert.template_values,
331 il_cert_user_cert.valid_until,
332 il_cert_user_cert.version,
333 il_cert_user_cert.ilias_version,
334 il_cert_user_cert.currently_active,
335 il_cert_user_cert.background_image_path,
336 il_cert_user_cert.id,
337 il_cert_user_cert.thumbnail_image_path,
338 (CASE WHEN (object_data.title IS NULL)
339 THEN
340 CASE WHEN (object_data_del.title IS NULL)
341 THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
342 ELSE object_data_del.title
343 END
344 ELSE object_data.title
345 END
346 ) as title
347FROM il_cert_user_cert
348LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
349LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
350WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
351 AND obj_type = ' . $this->database->quote($type, 'text') . '
352 AND currently_active = 1';
353
354 $query = $this->database->query($sql);
355
356 $result = array();
357 while ($row = $this->database->fetchAssoc($query)) {
358 $userCertificate = $this->createUserCertificate($row);
359
360 $presentation = new ilUserCertificatePresentation(
361 (int) $row['obj_id'],
362 (string) $row['obj_type'],
363 $userCertificate,
364 $row['title'],
365 ''
366 );
367 $result[] = $presentation;
368 }
369
370 $this->logger->info(sprintf('END - Fetching all active certificates for user: "%s" and type: "%s"', $userId, $type));
371
372 return $result;
373 }
$type
$type
Definition: proxy_ylocal.php:10

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

+ 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 165 of file class.ilUserCertificateRepository.php.

165 : array
166 {
167 $this->logger->info(sprintf('START - Fetching all active certificates for user: "%s"', $userId));
168
169 $sql = '
170SELECT
171 il_cert_user_cert.pattern_certificate_id,
172 il_cert_user_cert.obj_id,
173 il_cert_user_cert.obj_type,
174 il_cert_user_cert.user_id,
175 il_cert_user_cert.user_name,
176 il_cert_user_cert.acquired_timestamp,
177 il_cert_user_cert.certificate_content,
178 il_cert_user_cert.template_values,
179 il_cert_user_cert.valid_until,
180 il_cert_user_cert.version,
181 il_cert_user_cert.ilias_version,
182 il_cert_user_cert.currently_active,
183 il_cert_user_cert.background_image_path,
184 il_cert_user_cert.id,
185 il_cert_user_cert.thumbnail_image_path,
186 (CASE WHEN (object_data.title IS NULL)
187 THEN
188 CASE WHEN (object_data_del.title IS NULL)
189 THEN ' . $this->database->quote($this->defaultTitle, 'text') . '
190 ELSE object_data_del.title
191 END
192 ELSE object_data.title
193 END
194 ) as title
195FROM il_cert_user_cert
196LEFT JOIN object_data ON object_data.obj_id = il_cert_user_cert.obj_id
197LEFT JOIN object_data_del ON object_data_del.obj_id = il_cert_user_cert.obj_id
198WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
199AND currently_active = 1
200AND acquired_timestamp >= ' . $this->database->quote($startTimestamp, 'integer') . '
201AND acquired_timestamp <= ' . $this->database->quote($endTimeStamp, 'integer');
202
203 $query = $this->database->query($sql);
204
205 $result = array();
206 while ($row = $this->database->fetchAssoc($query)) {
207 $userCertificate = $this->createUserCertificate($row);
208
209 $presentation = new ilUserCertificatePresentation(
210 (int) $row['obj_id'],
211 (string) $row['obj_type'],
212 $userCertificate,
213 $row['title'],
214 ''
215 );
216 $result[] = $presentation;
217 }
218
219 $this->logger->debug(sprintf('Actual results: "%s"', json_encode($result)));
220 $this->logger->info(sprintf('END - All active certificates for user: "%s" total: "%s"', $userId, count($result)));
221
222 return $result;
223 }

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

+ Here is the call graph for this function:

◆ fetchCertificate()

ilUserCertificateRepository::fetchCertificate ( int  $id)
Parameters
int$id
Returns
ilUserCertificate
Exceptions
ilException

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

380 : ilUserCertificate
381 {
382 $this->logger->info(sprintf('START - Fetch certificate by id: "%s"', $id));
383
384 $sql = 'SELECT * FROM il_cert_user_cert WHERE id = ' . $this->database->quote($id, 'integer');
385
386 $query = $this->database->query($sql);
387
388 while ($row = $this->database->fetchAssoc($query)) {
389 $this->logger->debug(sprintf('Fetched certificate: "%s"', json_encode($row)));
390
391 $this->logger->info(sprintf('END - Fetch certificate by id: "%s"', $id));
392
393 return $this->createUserCertificate($row);
394 }
395
396 throw new ilException('No certificate found for user certificate id: ' . $id);
397 }

References $query, and createUserCertificate().

+ 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 467 of file class.ilUserCertificateRepository.php.

467 : array
468 {
469 $this->logger->info(sprintf(
470 'START - fetching all certificates of object(user id: "%s", object id: "%s")',
471 $userId,
472 $objId
473 ));
474
475 $sql = 'SELECT * FROM il_cert_user_cert
476WHERE user_id = ' . $this->database->quote($userId, 'integer') . '
477AND obj_id = ' . $this->database->quote($objId, 'integer');
478
479 $query = $this->database->query($sql);
480
481 $result = array();
482 while ($row = $this->database->fetchAssoc($query)) {
483 $this->logger->debug(sprintf(
484 'Certificate found: "%s")',
485 json_encode($row, JSON_PRETTY_PRINT)
486 ));
487
488 $this->logger->info(sprintf('Certificate: "%s"', json_encode($row)));
489
490 $result[] = $this->createUserCertificate($row);
491 }
492
493 $this->logger->info(sprintf(
494 'END - fetching all certificates of object(user id: "%s", object id: "%s")',
495 $userId,
496 $objId
497 ));
498
499 return $result;
500 }

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

Referenced by fetchLatestVersion().

+ 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 507 of file class.ilUserCertificateRepository.php.

507 : string
508 {
509 $this->logger->info(sprintf(
510 'START - fetching of latest certificates of object(user id: "%s", object id: "%s")',
511 $userId,
512 $objId
513 ));
514
515 $templates = $this->fetchCertificatesOfObject($objId, $userId);
516
517 $version = 0;
518 foreach ($templates as $template) {
519 if ($template->getVersion() > $version) {
520 $version = $template->getVersion();
521 }
522 }
523
524 $this->logger->info(sprintf(
525 'END - fetching of latest certificates of object(user id: "%s", object id: "%s") with version "%s"',
526 $userId,
527 $objId,
528 $version
529 ));
530
531 return $version;
532 }

References $objId, and fetchCertificatesOfObject().

Referenced by save().

+ 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 399 of file class.ilUserCertificateRepository.php.

400 {
401 $this->logger->info(sprintf('START - Fetch certificate for user("%s") and ids: "%s"', $userId, json_encode($objectIds)));
402
403 if (0 === count($objectIds)) {
404 return [];
405 }
406
407 $inStatementObjectIds = $this->database->in(
408 'obj_id',
409 $objectIds,
410 false,
411 'integer'
412 );
413
414 $sql = 'SELECT obj_id FROM il_cert_user_cert
415 WHERE user_id = ' . $this->database->quote($userId, 'integer') .
416' AND ' . $inStatementObjectIds .
417' AND currently_active = ' . $this->database->quote(1, 'integer');
418
419 $query = $this->database->query($sql);
420
421 $result = array();
422
423 while ($row = $this->database->fetchAssoc($query)) {
424 $this->logger->debug(sprintf('Fetched certificate: "%s"', json_encode($row)));
425 $result[] = $row['obj_id'];
426 }
427
428 return $result;
429 }

References $query, and $result.

◆ fetchUserIdsWithCertificateForObject()

ilUserCertificateRepository::fetchUserIdsWithCertificateForObject ( int  $objectId)

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

432 {
433 $this->logger->info(sprintf('START - Fetch certificate for object("%s")"', $objectId));
434
435 $sql = 'SELECT user_id FROM il_cert_user_cert
436WHERE obj_id = ' . $this->database->quote($objectId, 'integer') . '
437 AND currently_active = ' . $this->database->quote(1, 'integer');
438
439 $query = $this->database->query($sql);
440
441 $result = array();
442
443 while ($row = $this->database->fetchAssoc($query)) {
444 $this->logger->debug(sprintf('Fetched certificate: "%s"', json_encode($row)));
445 $result[] = $row['user_id'];
446 }
447
448 return $result;
449 }

References $query, and $result.

◆ save()

ilUserCertificateRepository::save ( ilUserCertificate  $userCertificate)
Parameters
ilUserCertificate$userCertificate
Returns
ilUserCertificate
Exceptions
ilDatabaseException

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

58 : ilUserCertificate
59 {
60 $this->logger->info('START - saving of user certificate');
61
62 $version = (int) $this->fetchLatestVersion($userCertificate->getObjId(), $userCertificate->getUserId());
63 $version += 1;
64
65 $id = (int) $this->database->nextId('il_cert_user_cert');
66
67 $objId = $userCertificate->getObjId();
68 $userId = $userCertificate->getUserId();
69
70 $this->deactivatePreviousCertificates($objId, $userId);
71
72 $columns = array(
73 'id' => array('integer', $id),
74 'pattern_certificate_id' => array('integer', $userCertificate->getPatternCertificateId()),
75 'obj_id' => array('integer', $objId),
76 'obj_type' => array('text', $userCertificate->getObjType()),
77 'user_id' => array('integer', $userId),
78 'user_name' => array('text', $userCertificate->getUserName()),
79 'acquired_timestamp' => array('integer', $userCertificate->getAcquiredTimestamp()),
80 'certificate_content' => array('clob', $userCertificate->getCertificateContent()),
81 'template_values' => array('clob', $userCertificate->getTemplateValues()),
82 'valid_until' => array('integer', $userCertificate->getValidUntil()),
83 'version' => array('integer', $version),
84 'ilias_version' => array('text', $userCertificate->getIliasVersion()),
85 'currently_active' => array('integer', (integer) $userCertificate->isCurrentlyActive()),
86 'background_image_path' => array('text', $userCertificate->getBackgroundImagePath()),
87 'thumbnail_image_path' => array('text', $userCertificate->getThumbnailImagePath())
88 );
89
90 $this->logger->debug(sprintf('END - Save certificate with following values: %s', json_encode($columns, JSON_PRETTY_PRINT)));
91
92 $this->database->insert('il_cert_user_cert', $columns);
93
94 return $userCertificate->withId($id)->withVersion($version);
95 }
$columns
if(! $in) $columns
Definition: Utf8Test.php:45
ilUserCertificateRepository\deactivatePreviousCertificates
deactivatePreviousCertificates(int $objId, int $userId)
Definition: class.ilUserCertificateRepository.php:539

References $columns, $objId, 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().

+ 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: