Collaboration diagram for ilCmiXapiAuthToken:

Public Member Functions
	getRefId ()

	setRefId (int $ref_id)

	getObjId ()

	setObjId (int $obj_id)

	getUsrId ()

	setUsrId (int $usr_id)

	getToken ()

	setToken (string $token)

	getValidUntil ()

	setValidUntil (string $valid_until)

	getLrsTypeId ()

	setLrsTypeId ($lrs_type_id)

	getCmi5Session ()

	setCmi5Session ($cmi5_session)

	getCmi5SessionData ()

	setCmi5SessionData ($cmi5_session_data)

	getReturnedForCmi5Session ()

	setReturnedForCmi5Session ($returned_for_cmi5_session)

	update ()

	delete ()

Static Public Member Functions
static	insertToken ($usrId, $refId, $objId, $lrsTypeId, $a_token, $a_time)

static	deleteTokenByObjIdAndUsrId ($objId, $usrId)

static	deleteTokenByObjIdAndRefIdAndUsrId ($objId, $refId, $usrId)

static	deleteExpiredTokens ()

static	selectCurrentTimestamp ()

static	createToken ()

static	fillToken ($usrId, $refId, $objId, $lrsTypeId=0)

static	getInstanceByToken ($token)

static	getInstanceByObjIdAndUsrId ($objId, $usrId, $checkValid=true)

static	getInstanceByObjIdAndRefIdAndUsrId ($objId, $refId, $usrId, $checkValid=true)

static	getCmi5SessionByUsrIdAndObjIdAndRefId (int $usrId, int $objId, $refId=null)

static	getWacSalt ()

Data Fields
const	DB_TABLE_NAME = 'cmix_token'

const	OPENSSL_ENCRYPTION_METHOD = 'aes128'

const	OPENSSL_IV = '1234567890123456'

Protected Attributes
	$ref_id

	$obj_id

	$usr_id

	$token

	$valid_until

	$lrs_type_id

	$cmi5_session

	$cmi5_session_data

	$returned_for_cmi5_session

Detailed Description

Definition at line 15 of file class.ilCmiXapiAuthToken.php.

Member Function Documentation

◆ createToken()

static ilCmiXapiAuthToken::createToken ( )

static

Definition at line 315 of file class.ilCmiXapiAuthToken.php.

    {
        return (new \Ramsey\Uuid\UuidFactory())->uuid4()->toString();
    }

Referenced by fillToken().

Here is the caller graph for this function:

◆ delete()

ilCmiXapiAuthToken::delete ( )

Definition at line 280 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
        $query = "
                        DELETE FROM " . self::DB_TABLE_NAME . "
                        WHERE obj_id = %s AND ref_id = %s AND usr_id = %s
                ";
        
        $ilDB->manipulateF($query, array('integer', 'integer', 'integer'), array($this->getObjId(), $this->getRefId(), $this->getUsrId()));
    }

References $DIC, $ilDB, $query, getObjId(), getRefId(), and getUsrId().

Here is the call graph for this function:

◆ deleteExpiredTokens()

static ilCmiXapiAuthToken::deleteExpiredTokens ( )

static

Definition at line 293 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
        $query = "DELETE FROM " . self::DB_TABLE_NAME . " WHERE valid_until < CURRENT_TIMESTAMP";
        $ilDB->manipulate($query);
    }

References $DIC, $ilDB, and $query.

Referenced by fillToken().

Here is the caller graph for this function:

◆ deleteTokenByObjIdAndRefIdAndUsrId()

static ilCmiXapiAuthToken::deleteTokenByObjIdAndRefIdAndUsrId	(	$objId,
		$refId,
		$usrId
	)

static

Definition at line 267 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
        $query = "
                        DELETE FROM " . self::DB_TABLE_NAME . "
                        WHERE obj_id = %s AND ref_id = %s AND usr_id = %s
                ";
        
        $ilDB->manipulateF($query, array('integer', 'integer', 'integer'), array($objId, $refId, $usrId));
    }

References $DIC, $ilDB, $objId, $query, and $refId.

◆ deleteTokenByObjIdAndUsrId()

static ilCmiXapiAuthToken::deleteTokenByObjIdAndUsrId	(	$objId,
		$usrId
	)

static

Definition at line 254 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
        $query = "
                        DELETE FROM " . self::DB_TABLE_NAME . "
                        WHERE obj_id = %s AND usr_id = %s
                ";
        
        $ilDB->manipulateF($query, array('integer', 'integer'), array($objId, $usrId));
    }

References $DIC, $ilDB, $objId, and $query.

◆ fillToken()

static ilCmiXapiAuthToken::fillToken	(	$usrId,
		$refId,
		$objId,
		$lrsTypeId = `0`
	)

static

Definition at line 320 of file class.ilCmiXapiAuthToken.php.

    {
        //$seconds = $this->getTimeToDelete();
        $seconds = 86400; // TODO: invalidation interval
        
        $nowTimeDT = self::selectCurrentTimestamp();
        
        $nowTime = new ilDateTime($nowTimeDT, IL_CAL_DATETIME);
        
        $nowTimeTS = $nowTime->get(IL_CAL_UNIX);
        $newTimeTS = $nowTimeTS + $seconds;
        
        $newTime = new ilDateTime($newTimeTS, IL_CAL_UNIX);
        
        //self::deleteTokenByObjIdAndUsrId($object->getId(), $usrId);
        
        try {
            $tokenObject = self::getInstanceByObjIdAndRefIdAndUsrId($objId, $refId, $usrId, false);
            $tokenObject->setValidUntil($newTime->get(IL_CAL_DATETIME));
            $tokenObject->update();
            
            $token = $tokenObject->getToken();
        } catch (ilCmiXapiException $e) {
            $token = self::createToken();
            self::insertToken($usrId, $refId, $objId, $lrsTypeId, $token, $newTime->get(IL_CAL_DATETIME));
        }
        
        // TODO: move to cronjob ;-)
        // TODO: check cmi5 sessions of token and if not terminated -> abandoned statement
        self::deleteExpiredTokens();
        
        return $token;
    }

References Vendor\Package\$e, $objId, $refId, $token, createToken(), deleteExpiredTokens(), getInstanceByObjIdAndRefIdAndUsrId(), IL_CAL_DATETIME, IL_CAL_UNIX, insertToken(), and selectCurrentTimestamp().

Referenced by ilLTIConsumerEmbeddedContentGUI\getLaunchParameters(), ilCmiXapiLaunchGUI\getValidToken(), and ilObjLTIConsumerGUI\initInfoScreenToolbar().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getCmi5Session()

ilCmiXapiAuthToken::getCmi5Session ( )

Returns: string

Definition at line 168 of file class.ilCmiXapiAuthToken.php.

    {
        return $this->cmi5_session;
    }

References $cmi5_session.

Referenced by update().

Here is the caller graph for this function:

◆ getCmi5SessionByUsrIdAndObjIdAndRefId()

static ilCmiXapiAuthToken::getCmi5SessionByUsrIdAndObjIdAndRefId	(	int	$usrId,
		int	$objId,
			$refId = `null`
	)

static

Parameters

int	$usrId
int	$objId
int	$refId

Returns: string

Exceptions

ilCmiXapiException

Definition at line 484 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; 
        $ilDB = $DIC->database();
        if (empty($refId)) {
            $query = "SELECT cmi5_session FROM " . self::DB_TABLE_NAME . " WHERE usr_id = %s AND obj_id = %s";
            $result = $ilDB->queryF($query, array('integer', 'integer'), array($usrId, $objId));    
        }
        else
        {
            $query = "SELECT cmi5_session FROM " . self::DB_TABLE_NAME . " WHERE usr_id = %s AND obj_id = %s AND ref_id = %s";
            $result = $ilDB->queryF($query, array('integer', 'integer', 'integer'), array($usrId, $objId, $refId));
        }
        
        $row = $ilDB->fetchAssoc($result);
        
        if ($row && $row['cmi5_session'] != '') 
        {
            return $row['cmi5_session'];
        }
        throw new ilCmiXapiException('no valid cmi5_session found for: ' . $objId . '/' . $usrId);
    }

References $DIC, $ilDB, $objId, $query, $refId, and $result.

Referenced by ilObjCmiXapi\getSessionId().

Here is the caller graph for this function:

◆ getCmi5SessionData()

ilCmiXapiAuthToken::getCmi5SessionData ( )

Returns: string

Definition at line 184 of file class.ilCmiXapiAuthToken.php.

    {
        return $this->cmi5_session_data;
    }

References $cmi5_session_data.

Referenced by update().

Here is the caller graph for this function:

◆ getInstanceByObjIdAndRefIdAndUsrId()

static ilCmiXapiAuthToken::getInstanceByObjIdAndRefIdAndUsrId	(	$objId,
		$refId,
		$usrId,
		$checkValid = `true`
	)

static

Parameters

int	$objId
int	$refId
int	$usrId

Returns: ilCmiXapiAuthToken

Exceptions

ilCmiXapiException

Definition at line 434 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
                $query = "SELECT * FROM " . self::DB_TABLE_NAME . " WHERE obj_id = %s AND ref_id = %s AND usr_id = %s";
                
        if ($checkValid) {
            $query .= " AND valid_until > CURRENT_TIMESTAMP";
        }
        
        $result = $ilDB->queryF($query, array('integer', 'integer', 'integer'), array($objId, $refId, $usrId));
        
        $row = $ilDB->fetchAssoc($result);
        
        if ($row) {
            $tokenObject = new self();
            $tokenObject->setToken($row['token']);
            $tokenObject->setValidUntil($row['valid_until']);
            $tokenObject->setUsrId($row['usr_id']);
            $tokenObject->setObjId($row['obj_id']);
            $tokenObject->setRefId($row['ref_id']);
            $tokenObject->setLrsTypeId($row['lrs_type_id']);
            $tokenObject->setCmi5Session($row['cmi5_session']);
            $tokenObject->setReturnedForCmi5Session($row['returned_for_cmi5_session']);
            $tokenObject->setCmi5SessionData($row['cmi5_session_data']);
            
            return $tokenObject;
        }
        
        throw new ilCmiXapiException('no valid token found for: ' . $objId . '/' . $usrId);
    }

References $DIC, $ilDB, $objId, $query, $refId, and $result.

Referenced by fillToken().

Here is the caller graph for this function:

◆ getInstanceByObjIdAndUsrId()

static ilCmiXapiAuthToken::getInstanceByObjIdAndUsrId	(	$objId,
		$usrId,
		$checkValid = `true`
	)

static

Parameters

int	$objId
int	$usrId

Returns: ilCmiXapiAuthToken

Exceptions

ilCmiXapiException

Definition at line 394 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
                $query = "SELECT * FROM " . self::DB_TABLE_NAME . " WHERE obj_id = %s AND usr_id = %s";
                
        if ($checkValid) {
            $query .= " AND valid_until > CURRENT_TIMESTAMP";
        }
        
        $result = $ilDB->queryF($query, array('integer', 'integer'), array($objId, $usrId));
        
        $row = $ilDB->fetchAssoc($result);
        
        if ($row) {
            $tokenObject = new self();
            $tokenObject->setToken($row['token']);
            $tokenObject->setValidUntil($row['valid_until']);
            $tokenObject->setUsrId($row['usr_id']);
            $tokenObject->setObjId($row['obj_id']);
            $tokenObject->setRefId($row['ref_id']);
            $tokenObject->setLrsTypeId($row['lrs_type_id']);
            $tokenObject->setCmi5Session($row['cmi5_session']);
            $tokenObject->setReturnedForCmi5Session($row['returned_for_cmi5_session']);
            $tokenObject->setCmi5SessionData($row['cmi5_session_data']);
            
            return $tokenObject;
        }
        
        throw new ilCmiXapiException('no valid token found for: ' . $objId . '/' . $usrId);
    }

References $DIC, $ilDB, $objId, $query, and $result.

◆ getInstanceByToken()

static ilCmiXapiAuthToken::getInstanceByToken ( $token )

static

Parameters

$token

Returns: ilCmiXapiAuthToken

Exceptions

ilCmiXapiException

Definition at line 359 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        
        $query = "
                        SELECT * FROM " . self::DB_TABLE_NAME . "
                        WHERE token = %s AND valid_until > CURRENT_TIMESTAMP
                ";
        
        $res = $DIC->database()->queryF($query, array('text'), array($token));
        
        while ($row = $DIC->database()->fetchAssoc($res)) {
            $tokenObject = new self();
            $tokenObject->setToken($token);
            $tokenObject->setValidUntil($row['valid_until']);
            $tokenObject->setUsrId($row['usr_id']);
            $tokenObject->setObjId($row['obj_id']);
            $tokenObject->setRefId($row['ref_id']);
            $tokenObject->setLrsTypeId($row['lrs_type_id']);
            $tokenObject->setCmi5Session($row['cmi5_session']);
            $tokenObject->setReturnedForCmi5Session($row['returned_for_cmi5_session']);
            $tokenObject->setCmi5SessionData($row['cmi5_session_data']);
            
            return $tokenObject;
        }
        
        throw new ilCmiXapiException('no valid token found for: ' . $token);
    }

References $DIC, $query, $res, and $token.

Referenced by ilCmiXapiLaunchGUI\CMI5preLaunch(), XapiProxy\XapiProxyRequest\handleGetStatementsRequest(), ilLTIConsumerResultService\handleRequest(), and XapiProxy\XapiProxyPolyFill\initLrs().

Here is the caller graph for this function:

◆ getLrsTypeId()

ilCmiXapiAuthToken::getLrsTypeId ( )

Returns: mixed

Definition at line 152 of file class.ilCmiXapiAuthToken.php.

    {
        return $this->lrs_type_id;
    }

References $lrs_type_id.

Referenced by update().

Here is the caller graph for this function:

◆ getObjId()

ilCmiXapiAuthToken::getObjId ( )

Returns: int

Definition at line 88 of file class.ilCmiXapiAuthToken.php.

                               : int
    {
        return $this->obj_id;
    }

References $obj_id.

Referenced by delete(), ilCmiXapiUser\getCMI5RegistrationFromAuthToken(), and update().

Here is the caller graph for this function:

◆ getRefId()

ilCmiXapiAuthToken::getRefId ( )

Returns: int

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

                               : int
    {
        return $this->ref_id;
    }

References $ref_id.

Referenced by delete(), ilCmiXapiUser\getRegistrationFromAuthToken(), and update().

Here is the caller graph for this function:

◆ getReturnedForCmi5Session()

ilCmiXapiAuthToken::getReturnedForCmi5Session ( )

Returns: string

Definition at line 200 of file class.ilCmiXapiAuthToken.php.

    {
        return $this->returned_for_cmi5_session;
    }

References $returned_for_cmi5_session.

Referenced by update().

Here is the caller graph for this function:

◆ getToken()

ilCmiXapiAuthToken::getToken ( )

Returns: string

Definition at line 120 of file class.ilCmiXapiAuthToken.php.

                               : string
    {
        return $this->token;
    }

References $token.

Referenced by update().

Here is the caller graph for this function:

◆ getUsrId()

ilCmiXapiAuthToken::getUsrId ( )

Returns: int

Definition at line 104 of file class.ilCmiXapiAuthToken.php.

                               : int
    {
        return $this->usr_id;
    }

References $usr_id.

Referenced by delete(), ilCmiXapiUser\getCMI5RegistrationFromAuthToken(), ilCmiXapiUser\getRegistrationFromAuthToken(), and update().

Here is the caller graph for this function:

◆ getValidUntil()

ilCmiXapiAuthToken::getValidUntil ( )

Returns: string

Definition at line 136 of file class.ilCmiXapiAuthToken.php.

                                    : string
    {
        return $this->valid_until;
    }

References $valid_until.

Referenced by update().

Here is the caller graph for this function:

◆ getWacSalt()

static ilCmiXapiAuthToken::getWacSalt ( )

static

Returns: string

Exceptions

ilCmiXapiException

Definition at line 511 of file class.ilCmiXapiAuthToken.php.

    {
        include 'data/wacsalt.php';
        
        if (isset($salt)) {
            return $salt;
        }
        
        throw new ilCmiXapiException('no salt for encryption provided');
    }

Referenced by ilCmiXapiLaunchGUI\buildAuthTokenFetchParam().

Here is the caller graph for this function:

◆ insertToken()

static ilCmiXapiAuthToken::insertToken	(	$usrId,
		$refId,
		$objId,
		$lrsTypeId,
		$a_token,
		$a_time
	)

static

Definition at line 234 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
        
        $ilDB->insert(
            self::DB_TABLE_NAME,
            array(
                'token' => array('text', $a_token),
                'valid_until' => array('timestamp', $a_time),
                'ref_id' => array('integer', $refId),
                'obj_id' => array('integer', $objId),
                'usr_id' => array('integer', $usrId),
                'lrs_type_id' => array('integer', $lrsTypeId)
            )
        );
        // 'cmi5_session' defaults always to '' by inserting
        // 'returned_for_cmi5_session' defaults always to '' by inserting 
    }

References $DIC, $ilDB, $objId, and $refId.

Referenced by fillToken().

Here is the caller graph for this function:

◆ selectCurrentTimestamp()

static ilCmiXapiAuthToken::selectCurrentTimestamp ( )

static

Definition at line 303 of file class.ilCmiXapiAuthToken.php.

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $ilDB = $DIC->database();
 
        $query = "SELECT CURRENT_TIMESTAMP";
        $result = $ilDB->query($query);
        $row = $ilDB->fetchAssoc($result);
        
        return $row['CURRENT_TIMESTAMP'];
    }

References $DIC, $ilDB, $query, and $result.

Referenced by fillToken(), ilCmiXapiResult\insert(), and ilCmiXapiResult\update().

Here is the caller graph for this function:

◆ setCmi5Session()

ilCmiXapiAuthToken::setCmi5Session ( $cmi5_session )

Parameters

string $cmi5_session

Definition at line 176 of file class.ilCmiXapiAuthToken.php.

    {
        $this->cmi5_session = $cmi5_session;
    }

References $cmi5_session.

◆ setCmi5SessionData()

ilCmiXapiAuthToken::setCmi5SessionData ( $cmi5_session_data )

Parameters

string $cmi5_session_data

Definition at line 192 of file class.ilCmiXapiAuthToken.php.

    {
        $this->cmi5_session_data = $cmi5_session_data;
    }

References $cmi5_session_data.

◆ setLrsTypeId()

ilCmiXapiAuthToken::setLrsTypeId ( $lrs_type_id )

Parameters

mixed $lrs_type_id

Definition at line 160 of file class.ilCmiXapiAuthToken.php.

    {
        $this->lrs_type_id = $lrs_type_id;
    }

References $lrs_type_id.

◆ setObjId()

ilCmiXapiAuthToken::setObjId ( int $obj_id )

Parameters

int $obj_id

Definition at line 96 of file class.ilCmiXapiAuthToken.php.

    {
        $this->obj_id = $obj_id;
    }

References $obj_id.

◆ setRefId()

ilCmiXapiAuthToken::setRefId ( int $ref_id )

Parameters

int $ref_id

Definition at line 80 of file class.ilCmiXapiAuthToken.php.

    {
        $this->ref_id = $ref_id;
    }

References $ref_id.

◆ setReturnedForCmi5Session()

ilCmiXapiAuthToken::setReturnedForCmi5Session ( $returned_for_cmi5_session )

Parameters

string $returned_for_cmi5_session

Definition at line 208 of file class.ilCmiXapiAuthToken.php.

    {
        $this->returned_for_cmi5_session = $returned_for_cmi5_session;
    }

References $returned_for_cmi5_session.

◆ setToken()

ilCmiXapiAuthToken::setToken ( string $token )

Parameters

string $token

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

    {
        $this->token = $token;
    }

References $token.

◆ setUsrId()

ilCmiXapiAuthToken::setUsrId ( int $usr_id )

Parameters

int $usr_id

Definition at line 112 of file class.ilCmiXapiAuthToken.php.

    {
        $this->usr_id = $usr_id;
    }

References $usr_id.

◆ setValidUntil()

ilCmiXapiAuthToken::setValidUntil ( string $valid_until )

Parameters

string $valid_until

Definition at line 144 of file class.ilCmiXapiAuthToken.php.

    {
        $this->valid_until = $valid_until;
    }

References $valid_until.

◆ update()

ilCmiXapiAuthToken::update ( )

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

    {
        global $DIC; /* @var \ILIAS\DI\Container $DIC */
        $DIC->database()->update(
            self::DB_TABLE_NAME,
            [
                'valid_until' => array('timestamp', $this->getValidUntil()),
                'ref_id' => array('integer', $this->getRefId()),
                'obj_id' => array('integer', $this->getObjId()),
                'usr_id' => array('integer', $this->getUsrId()),
                'lrs_type_id' => array('integer', $this->getLrsTypeId()),
                'cmi5_session' => array('text', $this->getCmi5Session()),
                'returned_for_cmi5_session' => array('text', $this->getReturnedForCmi5Session()),
                'cmi5_session_data' => array('clob', $this->getCmi5SessionData())
            ],
            [
                'token' => array('text', $this->getToken()),
            ]
        );
    }