ilBuddySystemRelationRepository Class Reference

Class ilBuddySystemRelationRepository. More...

Collaboration diagram for ilBuddySystemRelationRepository:

Public Member Functions
	getDatabaseAdapter ()
	setDatabaseAdapter (ilDB $db)
	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
	$usr_id

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 9 of file class.ilBuddySystemRelationRepository.php.

Member Function Documentation

addToApprovedBuddies()

ilBuddySystemRelationRepository::addToApprovedBuddies ( ilBuddySystemRelation  $relation )

private

Parameters

ilBuddySystemRelation

$relation

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

        {
                $this->db->replace(
                        'buddylist',
                        array(
                                'usr_id'       => array('integer', $relation->getUserId()),
                                'buddy_usr_id' => array('integer', $relation->getBuddyUserId())
                        ),
                        array(
                                'ts' => array('integer', $relation->getTimestamp())
                        )
                );
 
                $this->db->replace(
                        'buddylist',
                        array(
                                'usr_id'       => array('integer', $relation->getBuddyUserId()),
                                'buddy_usr_id' => array('integer', $relation->getUserId())
                        ),
                        array(
                                'ts' => array('integer', $relation->getTimestamp())
                        )
                );
        }

References ilBuddySystemRelation\getBuddyUserId(), ilBuddySystemRelation\getTimestamp(), and ilBuddySystemRelation\getUserId().

Referenced by save().

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 181 of file class.ilBuddySystemRelationRepository.php.

        {
                $this->db->replace(
                        'buddylist_requests',
                        array(
                                'usr_id'       => array('integer', $relation->getUserId()),
                                'buddy_usr_id' => array('integer', $relation->getBuddyUserId())
                        ),
                        array(
                                'ts'      => array('integer', $relation->getTimestamp()),
                                'ignored' => array('integer', (int)$ignored)
                        )
                );
        }

References ilBuddySystemRelation\getBuddyUserId(), ilBuddySystemRelation\getTimestamp(), and ilBuddySystemRelation\getUserId().

Referenced by save().

Here is the call graph for this function:

Here is the caller graph for this function:

destroy()

ilBuddySystemRelationRepository::destroy

(

)

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

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

getAll()

ilBuddySystemRelationRepository::getAll

(

)

Reads all items from database.

Returns

ilBuddySystemRelation[]

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

        {
                $relations = array();
 
                $res = $this->db->queryF(
                        "
                        SELECT usr_id, buddy_usr_id, ts, '" . self::TYPE_APPROVED . "' rel_type FROM buddylist WHERE usr_id = %s
                        UNION
                        SELECT usr_id, buddy_usr_id, ts, IF(ignored = 1, '" . self::TYPE_IGNORED . "', '" . self::TYPE_REQUESTED . "') rel_type FROM buddylist_requests WHERE usr_id = %s OR buddy_usr_id = %s
                        ",
                        array('integer', 'integer', 'integer'),
                        array($this->usr_id, $this->usr_id, $this->usr_id)
                );
 
                while($row = $this->db->fetchAssoc($res))
                {
                        $relation = $this->getRelationByDatabaseRecord($row);
                        $relation->setUserId($row['usr_id']);
                        $relation->setBuddyUserId($row['buddy_usr_id']);
                        $relation->setTimestamp($row['ts']);
                        $relation->setIsOwnedByRequest($relation->getUserId() == $this->usr_id);
                        $key = $this->usr_id == $relation->getUserId() ? $relation->getBuddyUserId() : $relation->getUserId();
                        $relations[$key] = $relation;
                }
 
                return $relations;
        }

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

Here is the call graph for this function:

getDatabaseAdapter()

ilBuddySystemRelationRepository::getDatabaseAdapter

(

)

Returns

ilDB

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

        {
                return $this->db;
        }

References $db.

getRelationByDatabaseRecord()

ilBuddySystemRelationRepository::getRelationByDatabaseRecord (   $row )

private

Parameters

$row

Returns

ilBuddySystemRelation

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

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

References $row.

Referenced by getAll().

Here is the caller graph for this function:

removeFromApprovedBuddies()

ilBuddySystemRelationRepository::removeFromApprovedBuddies ( ilBuddySystemRelation  $relation )

private

Parameters

ilBuddySystemRelation

$relation

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

        {
                $this->db->manipulateF(
                        "DELETE FROM buddylist WHERE usr_id = %s AND buddy_usr_id = %s",
                        array('integer', 'integer'),
                        array($relation->getUserId(), $relation->getBuddyUserId())
                );
 
                $this->db->manipulateF(
                        "DELETE FROM buddylist WHERE buddy_usr_id = %s AND usr_id = %s",
                        array('integer', 'integer'),
                        array($relation->getUserId(), $relation->getBuddyUserId())
                );
        }

References ilBuddySystemRelation\getBuddyUserId(), and ilBuddySystemRelation\getUserId().

Referenced by save().

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 199 of file class.ilBuddySystemRelationRepository.php.

        {
                $this->db->manipulateF(
                        "DELETE FROM buddylist_requests WHERE usr_id = %s AND buddy_usr_id = %s",
                        array('integer', 'integer'),
                        array($relation->getUserId(), $relation->getBuddyUserId())
                );
 
                $this->db->manipulateF(
                        "DELETE FROM buddylist_requests WHERE buddy_usr_id = %s AND usr_id = %s",
                        array('integer', 'integer'),
                        array($relation->getUserId(), $relation->getBuddyUserId())
                );
        }

References ilBuddySystemRelation\getBuddyUserId(), and ilBuddySystemRelation\getUserId().

Referenced by save().

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 217 of file class.ilBuddySystemRelationRepository.php.

        {
                $this->db->beginTransaction();
 
                if($relation->isLinked())
                {
                        $this->addToApprovedBuddies($relation);
                }
                else if($relation->wasLinked())
                {
                        $this->removeFromApprovedBuddies($relation);
                }
 
                if($relation->isRequested())
                {
                        $this->addToRequestedBuddies($relation, false);
                }
                else if($relation->isIgnored())
                {
                        $this->addToRequestedBuddies($relation, true);
                }
                else if($relation->wasRequested() || $relation->wasIgnored())
                {
                        $this->removeFromRequestedBuddies($relation);
                }
 
                $this->db->commit();
        }

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

Here is the call graph for this function:

setDatabaseAdapter()

ilBuddySystemRelationRepository::setDatabaseAdapter

(

ilDB

$db

)

Parameters

ilDB

$db

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

        {
                $this->db = $db;
        }

References $db.

Field Documentation

$db

ilBuddySystemRelationRepository::$db

protected

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

Referenced by getDatabaseAdapter(), and setDatabaseAdapter().

$usr_id

int ilBuddySystemRelationRepository::$usr_id

protected

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

TYPE_APPROVED

const ilBuddySystemRelationRepository::TYPE_APPROVED = 'app'

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

TYPE_IGNORED

const ilBuddySystemRelationRepository::TYPE_IGNORED = 'ign'

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

TYPE_REQUESTED

const ilBuddySystemRelationRepository::TYPE_REQUESTED = 'req'

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

---

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

• Services/Contact/BuddySystem/classes/class.ilBuddySystemRelationRepository.php