class.ilRegistrationCode.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilRegistrationCode
{
    protected const DB_TABLE = 'reg_registration_codes';
    public const CODE_LENGTH = 10;
 
    public static function create(
        int $role,
        int $stamp,
        array $local_roles,
        ?string $limit,
        ?string $limit_date,
        bool $reg_type,
        bool $ext_type
    ): int {
        global $DIC;
 
        $ilDB = $DIC->database();
        $id = $ilDB->nextId(self::DB_TABLE);
 
        // create unique code
        $found = true;
        $code = '';
        while ($found) {
            $code = self::generateRandomCode();
            $chk = $ilDB->queryF(
                "SELECT code_id FROM " . self::DB_TABLE . " WHERE code = %s",
                ["text"],
                [$code]
            );
            $found = (bool) $ilDB->numRows($chk);
        }
 
        $data = [
            'code_id' => ['integer', $id],
            'code' => ['text', $code],
            'generated_on' => ['integer', $stamp],
            'role' => ['integer', $role],
            'role_local' => ['text', implode(";", $local_roles)],
            'alimit' => ['text', $limit],
            'alimitdt' => ['text', $limit_date],
            'reg_enabled' => ['integer', $reg_type],
            'ext_enabled' => ['integer', $ext_type]
        ];
 
        $ilDB->insert(self::DB_TABLE, $data);
        return $id;
    }
 
    protected static function generateRandomCode(): string
    {
        // missing : 01iloO
        $map = "23456789abcdefghjkmnpqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ";
 
        $code = "";
        $max = strlen($map) - 1;
        for ($loop = 1; $loop <= self::CODE_LENGTH; $loop++) {
            $code .= $map[random_int(0, $max)];
        }
        return $code;
    }
 
    public static function isUnusedCode(string $code): bool
    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $set = $ilDB->query("SELECT used FROM " . self::DB_TABLE . " WHERE code = " . $ilDB->quote($code, "text"));
        $set = $ilDB->fetchAssoc($set);
        return $set && !$set["used"];
    }
 
    public static function isValidRegistrationCode(string $a_code): bool
    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $query = 'SELECT alimit, alimitdt FROM reg_registration_codes ' .
            'WHERE used = ' . $ilDB->quote(0, 'integer') . ' ' .
            'AND reg_enabled = ' . $ilDB->quote(1, 'integer') . ' ' .
            'AND code = ' . $ilDB->quote($a_code, 'text');
        $res = $ilDB->query($query);
        if ($ilDB->numRows($res) !== 1) {
            return false;
        }
 
        $is_valid = true;
 
        $row = $ilDB->fetchAssoc($res);
        if ($row['alimit'] === 'absolute') {
            $clock_factory = (new \ILIAS\Data\Factory())->clock();
            $right_interval = new DateTimeImmutable(
                $row['alimitdt'],
                $clock_factory->system()->now()->getTimezone()
            );
 
            $is_valid = $right_interval >= $clock_factory->system()->now();
        }
 
        return  $is_valid;
    }
 
    public static function getCodeValidUntil(string $code): string
    {
        $code_data = self::getCodeData($code);
 
        if ($code_data["alimit"]) {
            switch ($code_data["alimit"]) {
                case "absolute":
                    return $code_data['alimitdt'];
            }
        }
        return "0";
    }
 
    public static function useCode(string $code): bool
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        return (bool) $ilDB->update(
            self::DB_TABLE,
            ["used" => ["timestamp", time()]],
            ["code" => ["text", $code]]
        );
    }
 
    public static function getCodeRole(string $code): int
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $set = $ilDB->query("SELECT role FROM " . self::DB_TABLE . " WHERE code = " . $ilDB->quote($code, "text"));
        $row = $ilDB->fetchAssoc($set);
        if (isset($row["role"])) {
            return (int) $row["role"];
        }
        return 0;
    }
 
    public static function getCodeData(string $code): array
    {
        global $DIC;
 
        $ilDB = $DIC->database();
        $set = $ilDB->query("SELECT role, role_local, alimit, alimitdt, reg_enabled, ext_enabled" .
            " FROM " . self::DB_TABLE .
            " WHERE code = " . $ilDB->quote($code, "text"));
        return $ilDB->fetchAssoc($set);
    }
 
    public static function applyRoleAssignments(
        ilObjUser $user,
        string $code
    ): bool {
        $recommended_content_manager = new ilRecommendedContentManager();
 
        $grole = self::getCodeRole($code);
        if ($grole) {
            $GLOBALS['DIC']['rbacadmin']->assignUser($grole, $user->getId());
        }
        $code_data = self::getCodeData($code);
        if ($code_data["role_local"]) {
            $code_local_roles = explode(";", $code_data["role_local"]);
            foreach ($code_local_roles as $role_id) {
                $GLOBALS['DIC']['rbacadmin']->assignUser($role_id, $user->getId());
 
                // patch to remove for 45 due to mantis 21953
                $role_obj = $GLOBALS['DIC']['rbacreview']->getObjectOfRole($role_id);
                switch (ilObject::_lookupType($role_obj)) {
                    case 'crs':
                    case 'grp':
                        $role_refs = ilObject::_getAllReferences($role_obj);
                        $role_ref = end($role_refs);
                        // deactivated for now, see discussion at
                        // https://docu.ilias.de/goto_docu_wiki_wpage_5620_1357.html
                        //$recommended_content_manager->addObjectRecommendation($user->getId(), $role_ref);
                        break;
                }
            }
        }
        return true;
    }
 
    public static function applyAccessLimits(
        ilObjUser $user,
        string $code
    ): void {
        $code_data = self::getCodeData($code);
 
        if ($code_data["alimit"]) {
            switch ($code_data["alimit"]) {
                case "absolute":
                    $end = new ilDateTime($code_data['alimitdt'], IL_CAL_DATE);
                    //$user->setTimeLimitFrom(time());
                    $user->setTimeLimitUntil($end->get(IL_CAL_UNIX));
                    $user->setTimeLimitUnlimited(false);
                    break;
 
                case "relative":
 
                    $rel = unserialize($code_data["alimitdt"], ["allowed_classes" => false]);
 
                    $end = new ilDateTime(time(), IL_CAL_UNIX);
 
                    if ($rel['y'] > 0) {
                        $end->increment(IL_CAL_YEAR, (int) $rel['y']);
                    }
 
                    if ($rel['m'] > 0) {
                        $end->increment(IL_CAL_MONTH, (int) $rel['m']);
                    }
 
                    if ($rel['d'] > 0) {
                        $end->increment(IL_CAL_DAY, (int) $rel['d']);
                    }
 
                    //$user->setTimeLimitFrom(time());
                    $user->setTimeLimitUntil($end->get(IL_CAL_UNIX));
                    $user->setTimeLimitUnlimited(false);
                    break;
 
                case 'unlimited':
                    $user->setTimeLimitUnlimited(true);
                    break;
            }
        } else {
            $user->setTimeLimitUnlimited(true);
        }
    }
}