Class ilBuddySystemRelationRepository. More...

Collaboration diagram for ilBuddySystemRelationRepository:

Public Member Functions
	__construct (int $usrId)
	ilBuddySystemRelationRepository constructor. More...

	getAll ()
	Reads all items from database. More...

	destroy ()

	save (ilBuddySystemRelation $relation)

Data Fields
const	TYPE_APPROVED = 'app'

const	TYPE_REQUESTED = 'req'

const	TYPE_IGNORED = 'ign'

Protected Attributes
	$db

	$usrId

Private Member Functions
	getRelationByDatabaseRecord ($row)

	addToApprovedBuddies (ilBuddySystemRelation $relation)

	removeFromApprovedBuddies (ilBuddySystemRelation $relation)

	addToRequestedBuddies (ilBuddySystemRelation $relation, $ignored)

	removeFromRequestedBuddies (ilBuddySystemRelation $relation)

Detailed Description

Class ilBuddySystemRelationRepository.

Author: Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Definition at line 8 of file class.ilBuddySystemRelationRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ilBuddySystemRelationRepository::__construct ( int $usrId )

ilBuddySystemRelationRepository constructor.

Parameters

int $usrId

Definition at line 24 of file class.ilBuddySystemRelationRepository.php.

References $DIC, and $usrId.

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

Member Function Documentation

◆ addToApprovedBuddies()

ilBuddySystemRelationRepository::addToApprovedBuddies ( ilBuddySystemRelation $relation )

private

Parameters

ilBuddySystemRelation $relation

Definition at line 123 of file class.ilBuddySystemRelationRepository.php.

References ilBuddySystemRelation\getBuddyUsrId(), ilBuddySystemRelation\getTimestamp(), and ilBuddySystemRelation\getUsrId().

Referenced by save().

     {
         $this->db->replace(
             'buddylist',
             [
                 'usr_id' => ['integer', $relation->getUsrId()],
                 'buddy_usr_id' => ['integer', $relation->getBuddyUsrId()]
             ],
             [
                 'ts' => ['integer', $relation->getTimestamp()]
             ]
         );
 
         $this->db->replace(
             'buddylist',
             [
                 'usr_id' => ['integer', $relation->getBuddyUsrId()],
                 'buddy_usr_id' => ['integer', $relation->getUsrId()]
             ],
             [
                 'ts' => ['integer', $relation->getTimestamp()]
             ]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ addToRequestedBuddies()

ilBuddySystemRelationRepository::addToRequestedBuddies	(	ilBuddySystemRelation	$relation,
			$ignored
	)

private

Parameters

ilBuddySystemRelation	$relation
boolean	$ignored

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

References ilBuddySystemRelation\getBuddyUsrId(), ilBuddySystemRelation\getTimestamp(), and ilBuddySystemRelation\getUsrId().

Referenced by save().

     {
         $this->db->replace(
             'buddylist_requests',
             [
                 'usr_id' => ['integer', $relation->getUsrId()],
                 'buddy_usr_id' => ['integer', $relation->getBuddyUsrId()]
             ],
             [
                 'ts' => ['integer', $relation->getTimestamp()],
                 'ignored' => ['integer', (int) $ignored]
             ]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ destroy()

ilBuddySystemRelationRepository::destroy ( )

Definition at line 105 of file class.ilBuddySystemRelationRepository.php.

     {
         $this->db->queryF(
             "DELETE FROM buddylist WHERE usr_id = %s OR buddy_usr_id = %s",
             ['integer', 'integer'],
             [$this->usrId, $this->usrId]
         );
 
         $this->db->queryF(
             "DELETE FROM buddylist_requests WHERE usr_id = %s OR buddy_usr_id = %s",
             ['integer', 'integer'],
             [$this->usrId, $this->usrId]
         );
     }

◆ getAll()

ilBuddySystemRelationRepository::getAll ( )

Reads all items from database.

Returns: ilBuddySystemRelation[]

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

References $res, $usrId, and getRelationByDatabaseRecord().

                              : array
     {
         $relations = [];
 
         $res = $this->db->queryF(
             "
                         SELECT
                                buddylist.usr_id, buddylist.buddy_usr_id, buddylist.ts, %s rel_type
             FROM buddylist
                         INNER JOIN usr_data ud
                 ON ud.usr_id = buddylist.usr_id
                         WHERE buddylist.usr_id = %s
                         UNION
                         SELECT
                                buddylist_requests.usr_id, buddylist_requests.buddy_usr_id, buddylist_requests.ts, (CASE WHEN ignored = 1 THEN %s ELSE %s END) rel_type
                         FROM buddylist_requests
                         INNER JOIN usr_data ud ON ud.usr_id = buddylist_requests.usr_id
                         INNER JOIN usr_data udbuddy ON udbuddy.usr_id = buddylist_requests.buddy_usr_id
                         WHERE buddylist_requests.usr_id = %s OR buddylist_requests.buddy_usr_id = %s
                         ",
             [
                 'text',
                 'integer',
                 'text',
                 'text',
                 'integer',
                 'integer'
             ],
             [
                 self::TYPE_APPROVED,
                 $this->usrId,
                 self::TYPE_IGNORED,
                 self::TYPE_REQUESTED,
                 $this->usrId,
                 $this->usrId
             ]
         );
 
         while ($row = $this->db->fetchAssoc($res)) {
             $relation = $this->getRelationByDatabaseRecord($row);
             $relation->setUsrId((int) $row['usr_id']);
             $relation->setBuddyUsrId((int) $row['buddy_usr_id']);
             $relation->setTimestamp((int) $row['ts']);
             $relation->setIsOwnedByActor($relation->getUsrId() === $this->usrId);
             $key = $this->usrId === $relation->getUsrId() ? $relation->getBuddyUsrId() : $relation->getUsrId();
             $relations[$key] = $relation;
         }
 
         return $relations;
     }

Here is the call graph for this function:

◆ getRelationByDatabaseRecord()

ilBuddySystemRelationRepository::getRelationByDatabaseRecord ( $row )

private

Parameters

$row

Returns: ilBuddySystemRelation

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

Referenced by getAll().

     {
         if (self::TYPE_APPROVED === $row['rel_type']) {
             return new ilBuddySystemRelation(new ilBuddySystemLinkedRelationState());
         } elseif (self::TYPE_IGNORED === $row['rel_type']) {
             return new ilBuddySystemRelation(new ilBuddySystemIgnoredRequestRelationState());
         }
 
         return new ilBuddySystemRelation(new ilBuddySystemRequestedRelationState());
     }

Here is the caller graph for this function:

◆ removeFromApprovedBuddies()

ilBuddySystemRelationRepository::removeFromApprovedBuddies ( ilBuddySystemRelation $relation )

private

Parameters

ilBuddySystemRelation $relation

Definition at line 151 of file class.ilBuddySystemRelationRepository.php.

References ilBuddySystemRelation\getBuddyUsrId(), and ilBuddySystemRelation\getUsrId().

Referenced by save().

     {
         $this->db->manipulateF(
             "DELETE FROM buddylist WHERE usr_id = %s AND buddy_usr_id = %s",
             ['integer', 'integer'],
             [$relation->getUsrId(), $relation->getBuddyUsrId()]
         );
 
         $this->db->manipulateF(
             "DELETE FROM buddylist WHERE buddy_usr_id = %s AND usr_id = %s",
             ['integer', 'integer'],
             [$relation->getUsrId(), $relation->getBuddyUsrId()]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ removeFromRequestedBuddies()

ilBuddySystemRelationRepository::removeFromRequestedBuddies ( ilBuddySystemRelation $relation )

private

Parameters

ilBuddySystemRelation $relation

Definition at line 188 of file class.ilBuddySystemRelationRepository.php.

References ilBuddySystemRelation\getBuddyUsrId(), and ilBuddySystemRelation\getUsrId().

Referenced by save().

     {
         $this->db->manipulateF(
             "DELETE FROM buddylist_requests WHERE usr_id = %s AND buddy_usr_id = %s",
             ['integer', 'integer'],
             [$relation->getUsrId(), $relation->getBuddyUsrId()]
         );
 
         $this->db->manipulateF(
             "DELETE FROM buddylist_requests WHERE buddy_usr_id = %s AND usr_id = %s",
             ['integer', 'integer'],
             [$relation->getUsrId(), $relation->getBuddyUsrId()]
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ save()

ilBuddySystemRelationRepository::save ( ilBuddySystemRelation $relation )

Parameters

ilBuddySystemRelation $relation

Definition at line 206 of file class.ilBuddySystemRelationRepository.php.

References $ilDB, addToApprovedBuddies(), addToRequestedBuddies(), ilBuddySystemRelation\isIgnored(), ilBuddySystemRelation\isLinked(), ilBuddySystemRelation\isRequested(), removeFromApprovedBuddies(), removeFromRequestedBuddies(), ilBuddySystemRelation\wasIgnored(), ilBuddySystemRelation\wasLinked(), and ilBuddySystemRelation\wasRequested().

                                                           : void
     {
         $ilAtomQuery = $this->db->buildAtomQuery();
         $ilAtomQuery->addTableLock('buddylist_requests');
         $ilAtomQuery->addTableLock('buddylist');
 
         $ilAtomQuery->addQueryCallable(function (ilDBInterface $ilDB) use ($relation) {
             if ($relation->isLinked()) {
                 $this->addToApprovedBuddies($relation);
             } elseif ($relation->wasLinked()) {
                 $this->removeFromApprovedBuddies($relation);
             }
 
             if ($relation->isRequested()) {
                 $this->addToRequestedBuddies($relation, false);
             } elseif ($relation->isIgnored()) {
                 $this->addToRequestedBuddies($relation, true);
             } elseif ($relation->wasRequested() || $relation->wasIgnored()) {
                 $this->removeFromRequestedBuddies($relation);
             }
         });
 
         $ilAtomQuery->run();
     }