ilECSRemoteUserRepository Class Reference

Collaboration diagram for ilECSRemoteUserRepository:

Public Member Functions
	__construct ()
	createIfNotExisting (int $sid, int $mid, int $usr_id, string $remote_usr_id)
	Create new remote user entry. More...
	createIfRemoteUserNotExisting (int $sid, int $mid, int $usr_id, string $remote_usr_id)
	getECSRemoteUserById (int $remoteUserId)
	Read data set. More...
	getECSRemoteUserByUsrId (int $a_usr_id)
	Get instance for usr_id. More...
	getECSRemoteUserByRemoteId (string $remoteUserId)
	Get instance for remote usr_id (login|external_account) More...

Private Member Functions
	exists (int $sid, int $mid, int $usr_id)
	Check if entry exists for user. More...
	remoteUserExists (int $sid, int $mid, string $remote_usr_id)

Private Attributes
ilDBInterface	$db

Detailed Description

Author

Per Pascal Seeland pasca.nosp@m.l.se.nosp@m.eland.nosp@m.@tik.nosp@m..uni-.nosp@m.stut.nosp@m.tgart.nosp@m..de

Definition at line 23 of file class.ilECSRemoteUserRepository.php.

Constructor & Destructor Documentation

__construct()

ilECSRemoteUserRepository::__construct

(

)

Definition at line 27 of file class.ilECSRemoteUserRepository.php.

    {
        global $DIC;
 
        $this->db = $DIC['ilDB'];
    }

References $DIC.

Member Function Documentation

createIfNotExisting()

ilECSRemoteUserRepository::createIfNotExisting	(	int	$sid,
		int	$mid,
		int	$usr_id,
		string	$remote_usr_id
	)

Create new remote user entry.

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

     : void {
        if (!$this->exists($sid, $mid, $usr_id)) {
            $next_id = $this->db->nextId('ecs_remote_user');
            $query = 'INSERT INTO ecs_remote_user (eru_id, sid, mid, usr_id, remote_usr_id) ' .
                'VALUES( ' .
                $this->db->quote($next_id) . ', ' .
                $this->db->quote($sid, 'integer') . ', ' .
                $this->db->quote($mid, 'integer') . ', ' .
                $this->db->quote($usr_id, 'integer') . ', ' .
                $this->db->quote($remote_usr_id, 'text') . ' ' .
                ')';
            $this->db->manipulate($query);
        }
    }

References $query.

createIfRemoteUserNotExisting()

ilECSRemoteUserRepository::createIfRemoteUserNotExisting	(	int	$sid,
		int	$mid,
		int	$usr_id,
		string	$remote_usr_id
	)

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

     : void {
        if (!$this->remoteUserExists($sid, $mid, $remote_usr_id)) {
            $next_id = $this->db->nextId('ecs_remote_user');
            $query = 'INSERT INTO ecs_remote_user (eru_id, sid, mid, usr_id, remote_usr_id) ' .
                'VALUES( ' .
                $this->db->quote($next_id) . ', ' .
                $this->db->quote($sid, 'integer') . ', ' .
                $this->db->quote($mid, 'integer') . ', ' .
                $this->db->quote($usr_id, 'integer') . ', ' .
                $this->db->quote($remote_usr_id, 'text') . ' ' .
                ')';
            $this->db->manipulate($query);
        }
    }

References $query.

exists()

ilECSRemoteUserRepository::exists ( int  $sid, int  $mid, int  $usr_id  )

private

Check if entry exists for user.

Definition at line 37 of file class.ilECSRemoteUserRepository.php.

     : bool {
        $query = 'SELECT eru_id FROM ecs_remote_user ' .
            'WHERE sid = ' . $this->db->quote($sid, 'integer') . ' ' .
            'AND mid = ' . $this->db->quote($mid, 'integer') . ' ' .
            'AND usr_id = ' . $this->db->quote($usr_id, 'integer');
        $res = $this->db->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (bool) $row->eru_id;
        }
        return false;
    }

getECSRemoteUserById()

ilECSRemoteUserRepository::getECSRemoteUserById

(

int

$remoteUserId

)

Read data set.

Definition at line 113 of file class.ilECSRemoteUserRepository.php.

                                                           : ?ilECSRemoteUser
    {
        $query = 'SELECT * FROM ecs_remote_user ' .
            'WHERE eru_id = ' . $this->db->quote($remoteUserId, 'integer');
        $res = $this->db->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return new ilECSRemoteUser(
                $remoteUserId,
                (int) $row->sid,
                (int) $row->mid,
                (int) $row->usr_id,
                $row->remote_usr_id
            );
        }
        return null;
    }

References $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

getECSRemoteUserByRemoteId()

ilECSRemoteUserRepository::getECSRemoteUserByRemoteId

(

string

$remoteUserId

)

Get instance for remote usr_id (login|external_account)

Definition at line 147 of file class.ilECSRemoteUserRepository.php.

                                                                    : ?ilECSRemoteUser
    {
        $query = 'SELECT eru_id FROM ecs_remote_user ' .
            'WHERE remote_usr_id = ' . $this->db->quote($remoteUserId, 'text');
        $res = $this->db->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $this->getECSRemoteUserById($row->eru_id);
        }
        return null;
    }

References $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

getECSRemoteUserByUsrId()

ilECSRemoteUserRepository::getECSRemoteUserByUsrId

(

int

$a_usr_id

)

Get instance for usr_id.

Definition at line 133 of file class.ilECSRemoteUserRepository.php.

                                                          : ?ilECSRemoteUser
    {
        $query = 'SELECT eru_id FROM ecs_remote_user ' .
            'WHERE usr_id = ' . $this->db->quote($a_usr_id, 'integer');
        $res = $this->db->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $this->getECSRemoteUserById((int) $row->eru_id);
        }
        return null;
    }

References $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

remoteUserExists()

ilECSRemoteUserRepository::remoteUserExists ( int  $sid, int  $mid, string  $remote_usr_id  )

private

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

     : bool {
        $query = 'SELECT eru_id FROM ecs_remote_user ' .
            'WHERE sid = ' . $this->db->quote($sid, 'integer') . ' ' .
            'AND mid = ' . $this->db->quote($mid, 'integer') . ' ' .
            'AND remote_usr_id = ' . $this->db->quote($remote_usr_id, 'text');
        $res = $this->db->query($query);
        if ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (bool) $row->eru_id;
        }
        return false;
    }

Field Documentation

$db

ilDBInterface ilECSRemoteUserRepository::$db

private

Definition at line 25 of file class.ilECSRemoteUserRepository.php.

---

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

• Services/WebServices/ECS/classes/class.ilECSRemoteUserRepository.php