ilCmiXapiDelModel Class Reference

Class ilCmiXapiDelModel. More...

Collaboration diagram for ilCmiXapiDelModel:

Public Member Functions
	__construct ()
	getXapiObjIdForUser (int $userId)
	setXapiUserAsDeleted (int $userId)
	setUserAsUpdated (int $usrId)
	resetUpdatedXapiUser (int $usrId)
	getXapiObjectsByDeletedUsers ()
	getXapiObjectsByUser (int $userId)
	getNewDeletedUsers ()
	deleteUserEntry ($usrId)
	getXapiObjectData (int $objId)
	getAllXapiDelObjectData ()
	getNewDeletedXapiObjects ()
	deleteXapiObjectEntry ($objId)
	setXapiObjAsDeleted (int $objId, int $typeId, string $actId)
	setXapiObjAsUpdated (int $objId)
	resetUpdatedXapiObj (int $objId)
	removeCmixUsersForObject (int $objId)

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.

References $DIC, and ilLoggerFactory\getLogger().

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

Here is the call graph for this function:

Member Function Documentation

deleteUserEntry()

ilCmiXapiDelModel::deleteUserEntry

(

$usrId

)

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

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

deleteXapiObjectEntry()

ilCmiXapiDelModel::deleteXapiObjectEntry

(

$objId

)

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

References $objId.

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

getAllXapiDelObjectData()

ilCmiXapiDelModel::getAllXapiDelObjectData

(

)

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

References $data.

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

getNewDeletedUsers()

ilCmiXapiDelModel::getNewDeletedUsers

(

)

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

References $data.

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

getNewDeletedXapiObjects()

ilCmiXapiDelModel::getNewDeletedXapiObjects

(

)

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

References $data.

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

getXapiObjectData()

ilCmiXapiDelModel::getXapiObjectData

(

int

$objId

)

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

References $data, and null.

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

getXapiObjectsByDeletedUsers()

ilCmiXapiDelModel::getXapiObjectsByDeletedUsers

(

)

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

References $data.

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

getXapiObjectsByUser()

ilCmiXapiDelModel::getXapiObjectsByUser

(

int

$userId

)

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

References $data.

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

getXapiObjIdForUser()

ilCmiXapiDelModel::getXapiObjIdForUser

(

int

$userId

)

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

References $data, and null.

                                                    : ?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;
    }

init()

static ilCmiXapiDelModel::init ( )

static

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

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

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

Here is the caller graph for this function:

removeCmixUsersForObject()

ilCmiXapiDelModel::removeCmixUsersForObject

(

int

$objId

)

Definition at line 237 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);

    }

resetUpdatedXapiObj()

ilCmiXapiDelModel::resetUpdatedXapiObj

(

int

$objId

)

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

References null.

    {

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

resetUpdatedXapiUser()

ilCmiXapiDelModel::resetUpdatedXapiUser

(

int

$usrId

)

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

References null.

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

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 201 of file class.ilCmiXapiDelModel.php.

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

                                                                               : void
    {
        $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);

        if(!$this->dic->cron()->manager()->isJobActive('xapi_deletion_cron')) {
            $xapiDelete = new ilCmiXapiStatementsDeleteRequest($objId, $typeId, $actId, null, ilCmiXapiStatementsDeleteRequest::DELETE_SCOPE_ALL);
            $xapiDelete->delete();
        }
    }

setXapiObjAsUpdated()

ilCmiXapiDelModel::setXapiObjAsUpdated

(

int

$objId

)

Definition at line 217 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]
        ]);
    }

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