Collaboration diagram for ilMailingList:

Public Member Functions
	__construct (ilObjUser $user, int $id=0)

	insert ()

	update ()

	delete ()

	getAssignedEntries ()

	assignUser (int $usr_id=0)

	deleteEntry (int $a_id=0)

	deassignAllEntries ()

	setId (int $a_mail_id=0)

	getId ()

	setUserId (int $a_user_id=0)

	getUserId ()

	setTitle (string $a_title='')

	getTitle ()

	setDescription (?string $a_description='')

	getDescription ()

	setCreatedate (string $_createdate)

	getCreatedate ()

	setChangedate (?string $a_changedate)

	getChangedate ()

	setMode (int $a_mode)

	getMode ()

	doesExist ()

Data Fields
const	MODE_ADDRESSBOOK = 1

const	MODE_TEMPORARY = 2

Private Member Functions
	read ()

Private Attributes
int	$mail_id

int	$user_id

string	$title = ''

string	$description = ''

string	$createdate

string	$changedate

ilDBInterface	$db

int	$mode

bool	$exists = false

Detailed Description

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

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

Constructor & Destructor Documentation

◆ __construct()

ilMailingList::__construct	(	ilObjUser	$user,
		int	$id = `0`
	)

Definition at line 41 of file class.ilMailingList.php.

    {
        global $DIC;
 
        $this->db = $DIC['ilDB'];
 
        $this->mail_id = $id;
        $this->user_id = $user->getId();
 
        $this->setMode(self::MODE_ADDRESSBOOK);
 
        $this->read();
    }

References $DIC, $id, ilObject\getId(), read(), and setMode().

Here is the call graph for this function:

Member Function Documentation

◆ assignUser()

ilMailingList::assignUser ( int $usr_id = 0 )

Definition at line 199 of file class.ilMailingList.php.

                                               : bool
    {
        $nextId = $this->db->nextId('addressbook_mlist_ass');
        $this->db->manipulateF(
            'INSERT INTO addressbook_mlist_ass (a_id, ml_id, usr_id) VALUES(%s, %s, %s)',
            ['integer', 'integer', 'integer'],
            [$nextId, $this->getId(), $usr_id]
        );
        return true;
    }

References getId().

Here is the call graph for this function:

◆ deassignAllEntries()

ilMailingList::deassignAllEntries ( )

Definition at line 222 of file class.ilMailingList.php.

                                        : bool
    {
        $this->db->manipulateF(
            'DELETE FROM addressbook_mlist_ass WHERE ml_id = %s',
            ['integer'],
            [$this->getId()]
        );
        return true;
    }

References getId().

Referenced by delete().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ delete()

ilMailingList::delete ( )

Definition at line 132 of file class.ilMailingList.php.

                            : bool
    {
        if ($this->mail_id && $this->user_id) {
            $this->deassignAllEntries();
 
            $statement = $this->db->manipulateF(
                'DELETE FROM addressbook_mlist WHERE ml_id = %s AND user_id = %s',
                ['integer', 'integer'],
                [$this->getId(), $this->getUserId()]
            );
            $this->exists = false;
 
            return true;
        }
 
        return false;
    }

References deassignAllEntries(), getId(), and getUserId().

Here is the call graph for this function:

◆ deleteEntry()

ilMailingList::deleteEntry ( int $a_id = 0 )

Definition at line 211 of file class.ilMailingList.php.

                                              : bool
    {
        $this->db->manipulateF(
            'DELETE FROM addressbook_mlist_ass WHERE a_id = %s',
            ['integer'],
            [$a_id]
        );
        return true;
    }

◆ doesExist()

ilMailingList::doesExist ( )

Definition at line 303 of file class.ilMailingList.php.

                               : bool
    {
        return $this->exists;
    }

References $exists.

◆ getAssignedEntries()

ilMailingList::getAssignedEntries ( )

Returns: array<int, array{a_id: int, usr_id: int}>

Definition at line 177 of file class.ilMailingList.php.

                                        : array
    {
        $res = $this->db->queryF(
            'SELECT a_id, usr_data.usr_id FROM addressbook_mlist_ass ' .
            'INNER JOIN usr_data ON usr_data.usr_id = addressbook_mlist_ass.usr_id WHERE ml_id = %s',
            ['integer'],
            [$this->getId()]
        );
 
        $entries = [];
        $counter = 0;
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $entries[(int) $row->a_id] = [
                'a_id' => (int) $row->a_id,
                'usr_id' => (int) $row->usr_id
            ];
        }
 
        return $entries;
    }

References $res, ilDBConstants\FETCHMODE_OBJECT, getId(), and ILIAS\Repository\int().

Here is the call graph for this function:

◆ getChangedate()

ilMailingList::getChangedate ( )

Definition at line 287 of file class.ilMailingList.php.

                                   : ?string
    {
        return $this->changedate;
    }

References $changedate.

Referenced by update().

Here is the caller graph for this function:

◆ getCreatedate()

ilMailingList::getCreatedate ( )

Definition at line 277 of file class.ilMailingList.php.

                                   : string
    {
        return $this->createdate;
    }

References $createdate.

Referenced by insert().

Here is the caller graph for this function:

◆ getDescription()

ilMailingList::getDescription ( )

Definition at line 267 of file class.ilMailingList.php.

                                    : ?string
    {
        return $this->description;
    }

References $description.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ getId()

ilMailingList::getId ( )

Definition at line 237 of file class.ilMailingList.php.

                           : int
    {
        return $this->mail_id;
    }

References $mail_id.

Referenced by ilMailingListsMembersTableGUI\__construct(), assignUser(), deassignAllEntries(), delete(), getAssignedEntries(), read(), and update().

Here is the caller graph for this function:

◆ getMode()

ilMailingList::getMode ( )

Definition at line 299 of file class.ilMailingList.php.

                             : int
    {
        return $this->mode;
    }

References $mode.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ getTitle()

ilMailingList::getTitle ( )

Definition at line 257 of file class.ilMailingList.php.

                              : string
    {
        return $this->title;
    }

References $title.

Referenced by ilMailingListsMembersTableGUI\__construct(), insert(), and update().

Here is the caller graph for this function:

◆ getUserId()

ilMailingList::getUserId ( )

Definition at line 247 of file class.ilMailingList.php.

                               : int
    {
        return $this->user_id;
    }

References $user_id.

Referenced by delete(), insert(), read(), and update().

Here is the caller graph for this function:

◆ insert()

ilMailingList::insert ( )

Definition at line 55 of file class.ilMailingList.php.

                            : bool
    {
        $nextId = $this->db->nextId('addressbook_mlist');
        $statement = $this->db->manipulateF(
            '
                        INSERT INTO addressbook_mlist 
                        (   ml_id,
                                user_id,
                                title,
                                description,
                                createdate,
                                changedate,
                                lmode
                        )
                        VALUES(%s, %s, %s, %s, %s, %s, %s)',
            [
                'integer',
                'integer',
                'text',
                'text',
                'timestamp',
                'timestamp',
                'integer'
            ],
            [
                $nextId,
                $this->getUserId(),
                $this->getTitle(),
                $this->getDescription(),
                $this->getCreatedate(),
                null,
                $this->getMode()
            ]
        );
 
        $this->mail_id = $nextId;
        $this->exists = true;
 
        return true;
    }

References getCreatedate(), getDescription(), getMode(), getTitle(), and getUserId().

Here is the call graph for this function:

◆ read()

ilMailingList::read ( )

private

Definition at line 150 of file class.ilMailingList.php.

                           : void
    {
        if ($this->getId() && $this->getUserId()) {
            $res = $this->db->queryF(
                'SELECT * FROM addressbook_mlist WHERE ml_id = %s AND user_id =%s',
                ['integer', 'integer'],
                [$this->getId(), $this->getUserId()]
            );
 
            $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
 
            if (is_object($row)) {
                $this->setId((int) $row->ml_id);
                $this->setUserId((int) $row->user_id);
                $this->setTitle($row->title);
                $this->setDescription($row->description);
                $this->setCreatedate($row->createdate);
                $this->setChangedate($row->changedate);
                $this->setMode((int) $row->lmode);
                $this->exists = true;
            }
        }
    }

References $res, ilDBConstants\FETCHMODE_OBJECT, getId(), getUserId(), setChangedate(), setCreatedate(), setDescription(), setId(), setMode(), setTitle(), and setUserId().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setChangedate()

ilMailingList::setChangedate ( ?string $a_changedate )

Definition at line 282 of file class.ilMailingList.php.

                                                        : void
    {
        $this->changedate = $a_changedate;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setCreatedate()

ilMailingList::setCreatedate ( string $_createdate )

Definition at line 272 of file class.ilMailingList.php.

                                                      : void
    {
        $this->createdate = $_createdate;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setDescription()

ilMailingList::setDescription ( ?string $a_description = '' )

Definition at line 262 of file class.ilMailingList.php.

                                                               : void
    {
        $this->description = $a_description;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setId()

ilMailingList::setId ( int $a_mail_id = 0 )

Definition at line 232 of file class.ilMailingList.php.

                                             : void
    {
        $this->mail_id = $a_mail_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setMode()

ilMailingList::setMode ( int $a_mode )

Definition at line 292 of file class.ilMailingList.php.

                                        : void
    {
        if (in_array($a_mode, [self::MODE_ADDRESSBOOK, self::MODE_TEMPORARY], true)) {
            $this->mode = $a_mode;
        }
    }

Referenced by __construct(), and read().

Here is the caller graph for this function:

◆ setTitle()

ilMailingList::setTitle ( string $a_title = '' )

Definition at line 252 of file class.ilMailingList.php.

                                                  : void
    {
        $this->title = $a_title;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setUserId()

ilMailingList::setUserId ( int $a_user_id = 0 )

Definition at line 242 of file class.ilMailingList.php.

                                                 : void
    {
        $this->user_id = $a_user_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilMailingList::update ( )

Definition at line 96 of file class.ilMailingList.php.

                            : bool
    {
        if ($this->mail_id && $this->user_id) {
            $statement = $this->db->manipulateF(
                '
                                UPDATE addressbook_mlist
                                SET title = %s,
                                        description = %s,
                                        changedate =  %s,
                                        lmode = %s
                                WHERE ml_id =  %s
                                AND user_id =  %s',
                [
                    'text',
                    'text',
                    'timestamp',
                    'integer',
                    'integer',
                    'integer'
                ],
                [
                    $this->getTitle(),
                    $this->getDescription(),
                    $this->getChangedate(),
                    $this->getMode(),
                    $this->getId(),
                    $this->getUserId()
                ]
            );
 
            return true;
        }
 
        return false;
    }

References getChangedate(), getDescription(), getId(), getMode(), getTitle(), and getUserId().

Here is the call graph for this function:

Field Documentation

◆ $changedate

string ilMailingList::$changedate

private

Definition at line 32 of file class.ilMailingList.php.

Referenced by getChangedate().

◆ $createdate

string ilMailingList::$createdate

private

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

Referenced by getCreatedate().

◆ $db

ilDBInterface ilMailingList::$db

private

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

◆ $description

string ilMailingList::$description = ''

private

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

Referenced by getDescription().

◆ $exists

bool ilMailingList::$exists = false

private

Definition at line 39 of file class.ilMailingList.php.

Referenced by doesExist().

◆ $mail_id

int ilMailingList::$mail_id

private

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

Referenced by getId().

◆ $mode

int ilMailingList::$mode

private

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

Referenced by getMode().

◆ $title

string ilMailingList::$title = ''

private

Definition at line 29 of file class.ilMailingList.php.

Referenced by getTitle().

◆ $user_id

int ilMailingList::$user_id

private

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

Referenced by getUserId().

◆ MODE_ADDRESSBOOK

const ilMailingList::MODE_ADDRESSBOOK = 1

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

◆ MODE_TEMPORARY

const ilMailingList::MODE_TEMPORARY = 2

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

Referenced by ilMailingLists\deleteTemporaryLists(), ilObjUserFolderGUI\mailObject(), and ilMailingListsGUI\showMailingLists().

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

Services/Contact/classes/class.ilMailingList.php

Public Member Functions

Data Fields

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ assignUser()

◆ deassignAllEntries()

◆ delete()

◆ deleteEntry()

◆ doesExist()

◆ getAssignedEntries()

◆ getChangedate()

◆ getCreatedate()

◆ getDescription()

◆ getId()

◆ getMode()

◆ getTitle()

◆ getUserId()

◆ insert()

◆ read()

◆ setChangedate()

◆ setCreatedate()

◆ setDescription()

◆ setId()

◆ setMode()

◆ setTitle()

◆ setUserId()

◆ update()

Field Documentation

◆ $changedate

◆ $createdate

◆ $db

◆ $description

◆ $exists

◆ $mail_id

◆ $mode

◆ $title

◆ $user_id

◆ MODE_ADDRESSBOOK

◆ MODE_TEMPORARY