Collaboration diagram for ilMailingList:

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

	insert ()

	update ()

	delete ()

	getAssignedEntries ()

	assignAddressbookEntry ($addr_id=0)

	deassignAddressbookEntry ($a_id=0)

	deassignAllEntries ()

	setId ($a_mail_id=0)

	getId ()

	setUserId ($a_user_id=0)

	getUserId ()

	setTitle ($a_title='')

	getTitle ()

	setDescription ($a_description='')

	getDescription ()

	setCreatedate ($_createdate='0000-00-00 00:00:00')

	getCreatedate ()

	setChangedate ($a_changedate='0000-00-00 00:00:00')

	getChangedate ()

	setMode ($a_mode)

	getMode ()

Static Public Member Functions
static	_isOwner ($a_ml_id, $a_usr_id)

Data Fields
const	MODE_ADDRESSBOOK = 1

const	MODE_TEMPORARY = 2

Private Member Functions
	read ()

Private Attributes
	$mail_id = 0

	$user_id = 0

	$title = ''

	$description = ''

	$createdate = '0000-00-00 00:00:00'

	$changedate = '0000-00-00 00:00:00'

	$user = null

	$db = null

Detailed Description

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

Version: $Id$

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

Constructor & Destructor Documentation

◆ __construct()

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

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

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

References $ilDB, $user, read(), and setMode().

Here is the call graph for this function:

Member Function Documentation

◆ _isOwner()

static ilMailingList::_isOwner	(	$a_ml_id,
		$a_usr_id
	)

static

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

        {
                global $ilDB;
                
                $res = $ilDB->queryf('
                        SELECT * FROM addressbook_mlist 
                        WHERE ml_id = %s
                        AND user_id =%s',
                        array('integer', 'integer'),
                        array($a_ml_id, $a_usr_id));
                        
                $row = $ilDB->fetchObject($res);
                
                return is_object($row) ? true : false;
        }

References $ilDB, $res, and $row.

Referenced by ilMailingListsGUI\mailToList(), ilMailingListsGUI\performDelete(), ilMailingListsGUI\performDeleteMembers(), ilMailingListsGUI\saveAssignmentForm(), ilMailingListsGUI\saveForm(), ilMailingListsGUI\showAssignmentForm(), and ilMailingListsGUI\showForm().

Here is the caller graph for this function:

◆ assignAddressbookEntry()

ilMailingList::assignAddressbookEntry ( $addr_id = 0 )

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

        {
                $nextId = $this->db->nextId('addressbook_mlist_ass');
                $statement = $this->db->manipulateF('
                        INSERT INTO addressbook_mlist_ass 
                        (       a_id, 
                                ml_id,
                                addr_id
                        )
                        VALUES(%s,%s,%s )',
                        array('integer', 'integer', 'integer'),
                        array($nextId, $this->getId(), $addr_id));
                
                return true;
        }

References getId().

Here is the call graph for this function:

◆ deassignAddressbookEntry()

ilMailingList::deassignAddressbookEntry ( $a_id = 0 )

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

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

◆ deassignAllEntries()

ilMailingList::deassignAllEntries ( )

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

        {
                $statement = $this->db->manipulateF('   
                DELETE FROM addressbook_mlist_ass 
                                WHERE ml_id = %s',
                                array('integer'),
                                array($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 130 of file class.ilMailingList.php.

        {
                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',
                                array('integer', 'integer'),
                                array($this->getId(), $this->getUserId()));
                        
                        return true;
                }
                else
                {
                        return false;
                }               
        }

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

Here is the call graph for this function:

◆ getAssignedEntries()

ilMailingList::getAssignedEntries ( )

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

        {
                if($this->getMode() == self::MODE_ADDRESSBOOK)
                {
                        $res = $this->db->queryf('
                                SELECT * FROM addressbook_mlist_ass 
                                INNER JOIN addressbook ON addressbook.addr_id = addressbook_mlist_ass.addr_id 
                                WHERE ml_id = %s',
                                array('integer'),
                                array($this->getId()));
                }
                else
                {
                        $res = $this->db->queryf('
                                SELECT * FROM addressbook_mlist_ass 
                                INNER JOIN usr_data ON addressbook_mlist_ass.addr_id = usr_data.usr_id 
                                WHERE ml_id = %s',
                                array('integer'),
                                array($this->getId()));
                }
                
                $entries = array();
                
                $counter = 0;
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {                       
                        $entries[$counter] = array('a_id' => $row->a_id, 
                                                                           'addr_id' => $row->addr_id,
                                                                           'login' => $row->login,
                                                                           'email' => $row->email,
                                                                           'firstname' => $row->firstname,
                                                                           'lastname' => $row->lastname                                                                    
                                                                           );
                        
                        ++$counter;
                }
                
                return $entries;
        }

References $res, $row, DB_FETCHMODE_OBJECT, getId(), and getMode().

Here is the call graph for this function:

◆ getChangedate()

ilMailingList::getChangedate ( )

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

        {
                return $this->changedate;
        }

References $changedate.

Referenced by update().

Here is the caller graph for this function:

◆ getCreatedate()

ilMailingList::getCreatedate ( )

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

        {
                return $this->createdate;
        }

References $createdate.

Referenced by insert().

Here is the caller graph for this function:

◆ getDescription()

ilMailingList::getDescription ( )

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

        {
                return $this->description;
        }

References $description.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ getId()

ilMailingList::getId ( )

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

        {
                return $this->mail_id;
        }

References $mail_id.

Referenced by assignAddressbookEntry(), deassignAllEntries(), delete(), getAssignedEntries(), read(), and update().

Here is the caller graph for this function:

◆ getMode()

ilMailingList::getMode ( )

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

        {
                return $this->mode;
        }       

Referenced by getAssignedEntries(), insert(), and update().

Here is the caller graph for this function:

◆ getTitle()

ilMailingList::getTitle ( )

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

        {
                return $this->title;
        }

References $title.

Referenced by insert(), and update().

Here is the caller graph for this function:

◆ getUserId()

ilMailingList::getUserId ( )

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

        {
                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 60 of file class.ilMailingList.php.

        {
                $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)',
                        array(  'integer',
                                        'integer',
                                        'text', 
                                        'text', 
                                        'timestamp',
                                        'timestamp',
                                        'integer'),
                        array(  $nextId,  
                                        $this->getUserId(), 
                                        $this->getTitle(), 
                                        $this->getDescription(), 
                                        $this->getCreatedate(), 
                                        NULL,
                                        $this->getMode()
                ));
                
                $this->mail_id = $nextId;
                
                return true;
        }

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

Here is the call graph for this function:

◆ read()

ilMailingList::read ( )

private

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

        {
                if ($this->getId() && $this->getUserId())
                {
                        $res = $this->db->queryf('
                                SELECT * FROM addressbook_mlist 
                                WHERE ml_id = %s
                                AND user_id =%s',
                                array('integer', 'integer'),
                                array($this->getId(), $this->getUserId())); 
        
                        $row = $res->fetchRow(DB_FETCHMODE_OBJECT);
        
                        if (is_object($row))
                        {
                                $this->setId($row->ml_id);
                                $this->setUserId($row->user_id);
                                $this->setTitle($row->title);
                                $this->setDescription($row->description);
                                $this->setCreatedate($row->createdate);
                                $this->setChangedate($row->changedae);          
                                $this->setMode($row->lmode);
                        }
                }               
                
                
                return true;
        }

References $res, $row, DB_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 ( $a_changedate = '0000-00-00 00:00:00' )

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

                                                                    :00:00')
        {
                if($a_changedate == '0000-00-00 00:00:00')
                $this->changedate = NULL;
                else
                $this->changedate = $a_changedate;
        }

Referenced by read().

Here is the caller graph for this function:

◆ setCreatedate()

ilMailingList::setCreatedate ( $_createdate = '0000-00-00 00:00:00' )

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

                                                                   :00:00')
        {
                $this->createdate = $_createdate;
        }

Referenced by read().

Here is the caller graph for this function:

◆ setDescription()

ilMailingList::setDescription ( $a_description = '' )

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

        {
                $this->description = $a_description;
        }

Referenced by read().

Here is the caller graph for this function:

◆ setId()

ilMailingList::setId ( $a_mail_id = 0 )

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

        {
                $this->mail_id = $a_mail_id;
        }

Referenced by read().

Here is the caller graph for this function:

◆ setMode()

ilMailingList::setMode ( $a_mode )

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

        {
                $a_mode = (int)$a_mode;
                if(in_array($a_mode, array(self::MODE_ADDRESSBOOK, self::MODE_TEMPORARY)))
                {
                        $this->mode = (int)$a_mode;
                }
        }

Referenced by __construct(), and read().

Here is the caller graph for this function:

◆ setTitle()

ilMailingList::setTitle ( $a_title = '' )

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

        {
                $this->title = $a_title;
        }

Referenced by read().

Here is the caller graph for this function:

◆ setUserId()

ilMailingList::setUserId ( $a_user_id = 0 )

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

        {
                $this->user_id = $a_user_id;
        }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilMailingList::update ( )

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

        {
                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',
                                array(  'text',
                                                'text',
                                                'timestamp',
                                                'integer',
                                                'integer',
                                                'integer'
                                ),
                                array(  $this->getTitle(),
                                                        $this->getDescription(),
                                                        $this->getChangedate(),
                                                        $this->getMode(),
                                                        $this->getId(),
                                                        $this->getUserId()
                        ));
                        
                        return true;
                }
                else
                {
                        return false;
                }
        }

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

Here is the call graph for this function:

Field Documentation

◆ $changedate

ilMailingList::$changedate = '0000-00-00 00:00:00'

private

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

Referenced by getChangedate().

◆ $createdate

ilMailingList::$createdate = '0000-00-00 00:00:00'

private

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

Referenced by getCreatedate().

◆ $db

ilMailingList::$db = null

private

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

◆ $description

ilMailingList::$description = ''

private

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

Referenced by getDescription().

◆ $mail_id

ilMailingList::$mail_id = 0

private

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

Referenced by getId().

◆ $title

ilMailingList::$title = ''

private

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

Referenced by getTitle().

◆ $user

ilMailingList::$user = null

private

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

Referenced by __construct().

◆ $user_id

ilMailingList::$user_id = 0

private

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

Referenced by getUserId().

◆ MODE_ADDRESSBOOK

const ilMailingList::MODE_ADDRESSBOOK = 1

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

◆ MODE_TEMPORARY

const ilMailingList::MODE_TEMPORARY = 2

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

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

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

Services/Contact/classes/class.ilMailingList.php

Public Member Functions

Static Public Member Functions

Data Fields

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ _isOwner()

◆ assignAddressbookEntry()

◆ deassignAddressbookEntry()

◆ deassignAllEntries()

◆ delete()

◆ getAssignedEntries()

◆ getChangedate()

◆ getCreatedate()

◆ getDescription()

◆ getId()

◆ getMode()

◆ getTitle()

◆ getUserId()

◆ insert()

◆ read()

◆ setChangedate()

◆ setCreatedate()

◆ setDescription()

◆ setId()

◆ setMode()

◆ setTitle()

◆ setUserId()

◆ update()

Field Documentation

◆ $changedate

◆ $createdate

◆ $db

◆ $description

◆ $mail_id

◆ $title

◆ $user

◆ $user_id

◆ MODE_ADDRESSBOOK

◆ MODE_TEMPORARY