Collaboration diagram for ilCmiXapiDelModel:

Public Member Functions
	__construct ()

	getXapiObjIdForUser (int $userId)

	setXapiUserAsDeleted (int $userId)

	setUserAsUpdated (int $usrId)

	resetUpdatedXapiUser (int $usrId, int $objId)

	getXapiObjectsByDeletedUsers ()

	getXapiObjectsByUser (int $userId)

	getNewDeletedUsers ()

	deleteUserEntry ($usrId, $objId)

	getXapiObjectData (int $objId)

	getAllXapiDelObjectData ()

	getNewDeletedXapiObjects ()

	deleteXapiObjectEntry ($objId)

	setXapiObjAsDeleted (int $objId, int $typeId, string $actId)

	setXapiObjAsDeletedForUser (int $objId, int $typeId, string $actId, int $usrId)

	setXapiObjAsUpdated (int $objId)

	resetUpdatedXapiObj (int $objId)

	removeCmixUsersForObject (int $objId)

	removeCmixUsersForObjectAndUser (int $objId, int $usrId)

Static Public Member Functions
static	init ()

Data Fields
const	DB_TABLE_NAME = 'cmix_settings'

const	DB_USERS_TABLE_NAME = 'cmix_users'

const	DB_DEL_OBJ = 'cmix_del_object'

const	DB_DEL_USERS = 'cmix_del_user'

Protected Attributes
ilLogger	$log

Private Attributes
ILIAS DI Container	$dic

ilDBInterface	$db

Static Private Attributes
static ilCmiXapiDelModel	$instance = null

Detailed Description

Class ilCmiXapiDelModel.

Author: Uwe Kohnle kohnl.nosp@m.e@in.nosp@m.terne.nosp@m.tleh.nosp@m.rer-g.nosp@m.mbh..nosp@m.de; Stefan Schneider

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

Constructor & Destructor Documentation

◆ __construct()

ilCmiXapiDelModel::__construct ( )

Definition at line 44 of file class.ilCmiXapiDelModel.php.

    {
        global $DIC;
        $this->dic = $DIC;
        $this->db = $this->dic->database();
        $this->log = ilLoggerFactory::getLogger('cmix');
        //
    }

References $DIC, and ilLoggerFactory\getLogger().

Here is the call graph for this function:

Member Function Documentation

◆ deleteUserEntry()

ilCmiXapiDelModel::deleteUserEntry	(	$usrId,
		$objId
	)

Definition at line 149 of file class.ilCmiXapiDelModel.php.

    {
        $this->db->manipulateF(
            'DELETE FROM ' . self::DB_DEL_USERS . ' WHERE usr_id = %s AND obj_id = %s',
            ['integer', 'integer'],
            [$usrId, $objId]
        );
    }

References $objId.

◆ deleteXapiObjectEntry()

ilCmiXapiDelModel::deleteXapiObjectEntry ( $objId )

Definition at line 193 of file class.ilCmiXapiDelModel.php.

    {
        $this->db->manipulateF(
            'DELETE FROM ' . self::DB_DEL_OBJ . ' WHERE obj_id = %s',
            ['integer'],
            [$objId]
        );
    }

References $objId.

◆ getAllXapiDelObjectData()

ilCmiXapiDelModel::getAllXapiDelObjectData ( )

Definition at line 171 of file class.ilCmiXapiDelModel.php.

                                             : array
    {
        $data = array();
 
        $result = $this->db->query("SELECT * FROM " . self::DB_DEL_OBJ . " WHERE 1");
        while ($row = $this->db->fetchAssoc($result)) {
            $data[] = $row;
        }
        return $data;
    }

References $data.

◆ getNewDeletedUsers()

ilCmiXapiDelModel::getNewDeletedUsers ( )

Definition at line 138 of file class.ilCmiXapiDelModel.php.

    {
        $data = array();
 
        $result = $this->db->query("SELECT * FROM " . self::DB_DEL_USERS . " WHERE updated IS NULL");
        while ($row = $this->db->fetchAssoc($result)) {
            $data[] = $row;
        }
        return $data;
    }

References $data.

◆ getNewDeletedXapiObjects()

ilCmiXapiDelModel::getNewDeletedXapiObjects ( )

Definition at line 182 of file class.ilCmiXapiDelModel.php.

    {
        $data = array();
 
        $result = $this->db->query("SELECT * FROM " . self::DB_DEL_OBJ . " WHERE updated IS NULL");
        while ($row = $this->db->fetchAssoc($result)) {
            $data[] = $row;
        }
        return $data;
    }

References $data.

◆ getXapiObjectData()

ilCmiXapiDelModel::getXapiObjectData ( int $objId )

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

    {
        $data = null;
        $where = $this->db->quote($objId, 'integer');
        $result = $this->db->query("SELECT lrs_type_id, activity_id, delete_data FROM " . self::DB_TABLE_NAME . " WHERE obj_id = " . $where);
        while ($row = $this->db->fetchAssoc($result)) {
            $data = $row;
        }
        return $data;
    }

References $data, and $objId.

◆ getXapiObjectsByDeletedUsers()

ilCmiXapiDelModel::getXapiObjectsByDeletedUsers ( )

Definition at line 103 of file class.ilCmiXapiDelModel.php.

                                                  : array
    {
        $data = [];
        $result = $this->db->query("SELECT obj.obj_id, obj.lrs_type_id, obj.activity_id, usr.usr_id, usr.usr_ident, del.added FROM " .
            self::DB_TABLE_NAME . " obj, " .
            self::DB_USERS_TABLE_NAME . " usr, " .
            self::DB_DEL_USERS . " del " .
            #" INNER JOIN " . self::DB_DEL_USERS . " del ON usr.usr_id = xdel.usr_id" .
            " WHERE usr.usr_id = del.usr_id AND obj.obj_id = usr.obj_id AND del.updated IS NULL");
        while ($row = $this->db->fetchAssoc($result)) {
            if (is_null($data)) {
                $data = [];
            }
            $data[] = $row;
        }
        return $data;
    }

References $data.

◆ getXapiObjectsByUser()

ilCmiXapiDelModel::getXapiObjectsByUser ( int $userId )

Definition at line 121 of file class.ilCmiXapiDelModel.php.

                                                     : array
    {
        $data = [];
        $result = $this->db->query("SELECT obj.obj_id, obj.lrs_type_id, obj.activity_id FROM " .
            self::DB_TABLE_NAME . " obj, " .
            self::DB_USERS_TABLE_NAME . " usr" .
            #" INNER JOIN " . self::DB_DEL_USERS . " del ON usr.usr_id = xdel.usr_id" .
            " WHERE usr.usr_id = " . $this->db->quote($userId, 'integer') . " AND obj.obj_id = usr.obj_id");
        while ($row = $this->db->fetchAssoc($result)) {
            if (is_null($data)) {
                $data = [];
            }
            $data[] = $row;
        }
        return $data;
    }

References $data.

◆ getXapiObjIdForUser()

ilCmiXapiDelModel::getXapiObjIdForUser ( int $userId )

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

                                                    : ?array
    {
        $data = null;
        $where = $this->db->quote($userId, 'integer');
        $result = $this->db->query("SELECT obj_id FROM " . self::DB_USERS_TABLE_NAME . " WHERE usr_id = " . $where);
        while ($row = $this->db->fetchAssoc($result)) {
            if (is_null($data)) {
                $data = [];
            }
            $data[] = $row['obj_id'];
        }
        return $data;
    }

References $data.

◆ init()

static ilCmiXapiDelModel::init ( )

static

Definition at line 53 of file class.ilCmiXapiDelModel.php.

                                 : ilCmiXapiDelModel
    {
        return self::$instance ?? self::$instance = new self();
    }

Referenced by ilCmiXapiDelCron\__construct(), ilCmiXapiAppEventListener\onServiceObjectDeleteOrToTrash(), ilCmiXapiAppEventListener\onServiceUserDeleteUser(), and ilCmiXapiAppEventListener\removeMembers().

Here is the caller graph for this function:

◆ removeCmixUsersForObject()

ilCmiXapiDelModel::removeCmixUsersForObject ( int $objId )

Definition at line 266 of file class.ilCmiXapiDelModel.php.

                                                        : void
    {
        $this->db->manipulateF(
            'DELETE FROM cmix_users WHERE obj_id = %s',
            ['integer'],
            [$objId]
        );
        $this->log->debug('cmix_users deleted for objId=' . (string) $objId);
    }

References $objId.

◆ removeCmixUsersForObjectAndUser()

ilCmiXapiDelModel::removeCmixUsersForObjectAndUser	(	int	$objId,
		int	$usrId
	)

Definition at line 276 of file class.ilCmiXapiDelModel.php.

                                                                           : void
    {
        $this->db->manipulateF(
            'DELETE FROM cmix_users WHERE obj_id = %s AND usr_id = %s',
            ['integer','integer'],
            [$objId,$usrId]
        );
        $this->log->debug('cmix_user with usrId ' . (string) $usrId . ' deleted for objId=' . (string) $objId);
    }

References $objId.

◆ resetUpdatedXapiObj()

ilCmiXapiDelModel::resetUpdatedXapiObj ( int $objId )

Definition at line 256 of file class.ilCmiXapiDelModel.php.

    {
 
        $this->db->update(self::DB_DEL_OBJ, [
            'updated' => ['timestamp', null]
        ], [
            'obj_id' => ['integer', $objId]
        ]);
    }

References $objId.

◆ resetUpdatedXapiUser()

ilCmiXapiDelModel::resetUpdatedXapiUser	(	int	$usrId,
		int	$objId
	)

Definition at line 91 of file class.ilCmiXapiDelModel.php.

    {
        $this->db->update(self::DB_DEL_USERS, [
            'updated' => ['timestamp', null]
        ], [
            'usr_id' => ['integer', $usrId],
            'obj_id' => ['integer', $objId]
        ]);
    }

References $objId.

◆ setUserAsUpdated()

ilCmiXapiDelModel::setUserAsUpdated ( int $usrId )

Definition at line 82 of file class.ilCmiXapiDelModel.php.

    {
        $this->db->update(self::DB_DEL_USERS, [
            'updated' => ['timestamp', date('Y-m-d H:i:s')]
        ], [
            'usr_id' => ['integer', $usrId]
        ]);
    }

◆ setXapiObjAsDeleted()

ilCmiXapiDelModel::setXapiObjAsDeleted	(	int	$objId,
		int	$typeId,
		string	$actId
	)

Definition at line 202 of file class.ilCmiXapiDelModel.php.

                                                                               : void
    {
        if (!$this->dic->cron()->manager()->isJobActive('xapi_deletion_cron')) {
            $xapiDelete = new ilCmiXapiStatementsDeleteRequest($objId, $typeId, $actId, null, ilCmiXapiStatementsDeleteRequest::DELETE_SCOPE_ALL);
            $xapiDelete->delete();
        } else {
            $values = [
                'obj_id' => ['integer', $objId],
                'type_id' => ['integer', $typeId],
                'activity_id' => ['string', $actId],
                'added' => ['timestamp', date('Y-m-d H:i:s')]
            ];
            $this->db->insert(self::DB_DEL_OBJ, $values);
        }
    }

References $objId, $typeId, and ilCmiXapiStatementsDeleteRequest\DELETE_SCOPE_ALL.

◆ setXapiObjAsDeletedForUser()

ilCmiXapiDelModel::setXapiObjAsDeletedForUser	(	int	$objId,
		int	$typeId,
		string	$actId,
		int	$usrId
	)

Definition at line 218 of file class.ilCmiXapiDelModel.php.

                                                                                                  : void
    {
        if (!$this->dic->cron()->manager()->isJobActive('xapi_deletion_cron')) {
            $xapiDelete = new ilCmiXapiStatementsDeleteRequest($objId, $typeId, $actId, $usrId, ilCmiXapiStatementsDeleteRequest::DELETE_SCOPE_ALL);
            $xapiDelete->delete();
        } else {
            $counter = 0;
            $result = $this->db->queryF(
                'SELECT count(*) as counter FROM ' . self::DB_DEL_USERS . ' WHERE usr_id = %s AND obj_id = %s',
                ['integer', 'integer'],
                [$usrId, $objId]
            );
            while ($row = $this->db->fetchAssoc($result)) {
                $counter = $row['counter'];
            }
 
            if ($counter == 0) {
                $values = [
                    'usr_id' => ['integer', $usrId],
                    'obj_id' => ['integer', $objId],
                    'added' => ['timestamp', date('Y-m-d H:i:s')]
                ];
                $this->db->insert(self::DB_DEL_USERS, $values);
            }
        }
    }

References $counter, $objId, $typeId, and ilCmiXapiStatementsDeleteRequest\DELETE_SCOPE_ALL.

◆ setXapiObjAsUpdated()

ilCmiXapiDelModel::setXapiObjAsUpdated ( int $objId )

Definition at line 246 of file class.ilCmiXapiDelModel.php.

    {
 
        $this->db->update(self::DB_DEL_OBJ, [
            'updated' => ['timestamp', date('Y-m-d H:i:s')]
        ], [
            'obj_id' => ['integer', $objId]
        ]);
    }

References $objId.

◆ setXapiUserAsDeleted()

ilCmiXapiDelModel::setXapiUserAsDeleted ( int $userId )

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

                                                     : bool
    {
        $values = [
            'usr_id' => ['integer', $userId],
            'added' => ['timestamp', date('Y-m-d H:i:s')]
        ];
        $this->db->insert(self::DB_DEL_USERS, $values);
        return true;
    }

Field Documentation

◆ $db

ilDBInterface ilCmiXapiDelModel::$db

private

Definition at line 38 of file class.ilCmiXapiDelModel.php.

◆ $dic

ILIAS DI Container ilCmiXapiDelModel::$dic

private

Definition at line 36 of file class.ilCmiXapiDelModel.php.

◆ $instance

ilCmiXapiDelModel ilCmiXapiDelModel::$instance = null

staticprivate

Definition at line 40 of file class.ilCmiXapiDelModel.php.

◆ $log

ilLogger ilCmiXapiDelModel::$log

protected

Definition at line 42 of file class.ilCmiXapiDelModel.php.

◆ DB_DEL_OBJ

const ilCmiXapiDelModel::DB_DEL_OBJ = 'cmix_del_object'

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

◆ DB_DEL_USERS

const ilCmiXapiDelModel::DB_DEL_USERS = 'cmix_del_user'

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

◆ DB_TABLE_NAME

const ilCmiXapiDelModel::DB_TABLE_NAME = 'cmix_settings'

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

◆ DB_USERS_TABLE_NAME

const ilCmiXapiDelModel::DB_USERS_TABLE_NAME = 'cmix_users'

Definition at line 31 of file class.ilCmiXapiDelModel.php.

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

components/ILIAS/CmiXapi/classes/class.ilCmiXapiDelModel.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Attributes

Private Attributes

Static Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ deleteUserEntry()

◆ deleteXapiObjectEntry()

◆ getAllXapiDelObjectData()

◆ getNewDeletedUsers()

◆ getNewDeletedXapiObjects()

◆ getXapiObjectData()

◆ getXapiObjectsByDeletedUsers()

◆ getXapiObjectsByUser()

◆ getXapiObjIdForUser()

◆ init()

◆ removeCmixUsersForObject()

◆ removeCmixUsersForObjectAndUser()

◆ resetUpdatedXapiObj()

◆ resetUpdatedXapiUser()

◆ setUserAsUpdated()

◆ setXapiObjAsDeleted()

◆ setXapiObjAsDeletedForUser()

◆ setXapiObjAsUpdated()

◆ setXapiUserAsDeleted()

Field Documentation

◆ $db

◆ $dic

◆ $instance

◆ $log

◆ DB_DEL_OBJ

◆ DB_DEL_USERS

◆ DB_TABLE_NAME

◆ DB_USERS_TABLE_NAME