Collaboration diagram for ilCalendarUserNotification:

Public Member Functions
	__construct ($a_cal_id=0)
	Init with calendar entry id. More...

	setEntryId ($a_id)
	Set calendar entry id. More...

	getEntryId ()
	Get calendar entry id. More...

	getRecipients ()

	validate ()

	save ()
	Save recipients to db. More...

	addRecipient ($a_type, $a_usr_id=0, $a_email='')
	Add recipient. More...

	setRecipients ($a_rcps)
	Set recipients. More...

	deleteRecipients ()
	Delete all recipients @global ilDB $ilDB. More...

Static Public Member Functions
static	deleteUser ($a_usr_id)
	Delete a singel user @global ilDB $ilDB. More...

static	deleteCalendarEntry ($a_cal_id)
	Delete notification for a calendar entry @global ilDB $ilDB. More...

static	createTable ()

Data Fields
const	TYPE_USER = 1

const	TYPE_EMAIL = 2

Protected Member Functions
	read ()
	Read recipients @global ilDB $ilDB. More...

Private Attributes
	$cal_id = 0

	$rcps = array()

Detailed Description

Author: Stefan Meyer smeye.nosp@m.r.il.nosp@m.ias@g.nosp@m.mx.d.nosp@m.e $Id$

Definition at line 10 of file class.ilCalendarUserNotification.php.

Constructor & Destructor Documentation

◆ __construct()

ilCalendarUserNotification::__construct ( $a_cal_id = 0 )

Init with calendar entry id.

Definition at line 22 of file class.ilCalendarUserNotification.php.

    {
        $this->cal_id = $a_cal_id;
        $this->read();
    }

References read().

Here is the call graph for this function:

Member Function Documentation

◆ addRecipient()

ilCalendarUserNotification::addRecipient	(	$a_type,
		$a_usr_id = `0`,
		$a_email = `''`
	)

Add recipient.

Parameters

int	$a_type
int	$a_usr_id
string	$a_email

Definition at line 141 of file class.ilCalendarUserNotification.php.

    {
        $this->rcps[] = array(
            'type' => $a_type,
            'usr_id' => $a_usr_id,
            'email' => $a_email
        );
    }

References $a_type.

Referenced by read().

Here is the caller graph for this function:

◆ createTable()

static ilCalendarUserNotification::createTable ( )

static

Definition at line 207 of file class.ilCalendarUserNotification.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        if ($ilDB->tableExists('cal_notification')) {
            return true;
        }
 
        // Create notification table
        $ilDB->createTable(
            'cal_notification',
            array(
                'notification_id' => array('type' => 'integer','length' => 4,'notnull' => true),
                'cal_id' => array('type' => 'integer','length' => 4, 'notnull' => true, 'default' => 0),
                'user_type' => array('type' => 'integer','length' => 1, 'notnull' => true, 'default' => 0),
                'user_id' => array('type' => 'integer','length' => 4, 'notnull' => true, 'default' => 0),
                'email' => array('type' => 'text','length' => 64, 'notnull' => false)
            )
        );
        $ilDB->addPrimaryKey(
            'cal_notification',
            array(
                'notification_id'
            )
        );
        $ilDB->createSequence('cal_notification');
        $ilDB->addIndex('cal_notification', array('cal_id'), 'i1');
    }

References $DIC, and $ilDB.

◆ deleteCalendarEntry()

static ilCalendarUserNotification::deleteCalendarEntry ( $a_cal_id )

static

Delete notification for a calendar entry @global ilDB $ilDB.

Parameters

int $a_cal_id

Returns: bool

Definition at line 52 of file class.ilCalendarUserNotification.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = 'DELETE FROM cal_notification ' .
            'WHERE cal_id = ' . $ilDB->quote($a_cal_id, 'integer');
        $res = $ilDB->manipulate($query);
        return true;
    }

References $DIC, $ilDB, $query, and $res.

Referenced by ilCalendarAppointmentGUI\delete().

Here is the caller graph for this function:

◆ deleteRecipients()

ilCalendarUserNotification::deleteRecipients ( )

Delete all recipients @global ilDB $ilDB.

Returns: bool

Definition at line 164 of file class.ilCalendarUserNotification.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = 'DELETE FROM cal_notification ' .
            'WHERE cal_id = ' . $ilDB->quote($this->getEntryId(), 'integer');
        $res = $ilDB->manipulate($query);
        return true;
    }

References $DIC, $ilDB, $query, $res, and getEntryId().

Referenced by save().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ deleteUser()

static ilCalendarUserNotification::deleteUser ( $a_usr_id )

static

Delete a singel user @global ilDB $ilDB.

Parameters

int $a_usr_id

Returns: bool

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

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = 'DELETE FROM cal_notification ' .
            'WHERE user_id = ' . $ilDB->quote($a_usr_id, 'integer');
        $res = $ilDB->manipulate($query);
        return true;
    }

References $DIC, $ilDB, $query, and $res.

◆ getEntryId()

ilCalendarUserNotification::getEntryId ( )

Get calendar entry id.

Definition at line 76 of file class.ilCalendarUserNotification.php.

    {
        return $this->cal_id;
    }

References $cal_id.

Referenced by deleteRecipients(), read(), and save().

Here is the caller graph for this function:

◆ getRecipients()

ilCalendarUserNotification::getRecipients ( )

Definition at line 81 of file class.ilCalendarUserNotification.php.

    {
        return (array) $this->rcps;
    }

References $rcps.

Referenced by save(), and validate().

Here is the caller graph for this function:

◆ read()

ilCalendarUserNotification::read ( )

protected

Read recipients @global ilDB $ilDB.

Definition at line 182 of file class.ilCalendarUserNotification.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        if (!$this->getEntryId()) {
            return true;
        }
 
        $query = 'SELECT * FROM cal_notification ' .
            'WHERE cal_id = ' . $ilDB->quote($this->getEntryId(), 'integer');
        $res = $ilDB->query($query);
 
        $this->rcps = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->addRecipient(
                $row->user_type,
                $row->user_id,
                $row->email
            );
        }
    }

References $DIC, $ilDB, $query, $res, addRecipient(), ilDBConstants\FETCHMODE_OBJECT, and getEntryId().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ save()

ilCalendarUserNotification::save ( )

Save recipients to db.

Definition at line 112 of file class.ilCalendarUserNotification.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $this->deleteRecipients();
 
        foreach ($this->getRecipients() as $rcp) {
            $query = 'INSERT INTO cal_notification ' .
                '(notification_id,cal_id, user_type, user_id, email) ' .
                'VALUES ( ' .
                $ilDB->quote($ilDB->nextId('cal_notification'), 'integer') . ', ' .
                $ilDB->quote((int) $this->getEntryId(), 'integer') . ', ' .
                $ilDB->quote((int) $rcp['type'], 'integer') . ', ' .
                $ilDB->quote((int) $rcp['usr_id'], 'integer') . ', ' .
                $ilDB->quote($rcp['email'], 'text') .
                ')';
            $ilDB->manipulate($query);
        }
        return true;
    }

References $DIC, $ilDB, $query, deleteRecipients(), getEntryId(), and getRecipients().

Here is the call graph for this function:

◆ setEntryId()

ilCalendarUserNotification::setEntryId ( $a_id )

Set calendar entry id.

Parameters

int $a_id

Definition at line 68 of file class.ilCalendarUserNotification.php.

    {
        $this->cal_id = $a_id;
    }

◆ setRecipients()

ilCalendarUserNotification::setRecipients ( $a_rcps )

Set recipients.

Parameters

array $a_rcps

Definition at line 154 of file class.ilCalendarUserNotification.php.

    {
        $this->rcps = array();
    }

◆ validate()

ilCalendarUserNotification::validate ( )

Definition at line 86 of file class.ilCalendarUserNotification.php.

    {
        global $DIC;
 
        $ilErr = $DIC['ilErr'];
        $lng = $DIC['lng'];
 
        if (!count($this->getRecipients())) {
            return true;
        }
        foreach ((array) $this->getRecipients() as $rcp_data) {
            if ($rcp_data['type'] == self::TYPE_USER) {
                continue;
            } else {
                if (!ilUtil::is_email($rcp_data['email'])) {
                    $ilErr->appendMessage($lng->txt('cal_err_invalid_notification_rcps'));
                    return false;
                }
            }
        }
        return true;
    }