class ilEventMembers More...

Collaboration diagram for ilEventParticipants:

Public Member Functions
	__construct ($a_event_id)
	Constructor. More...

	setUserId ($a_usr_id)

	getUserId ()

	setMark ($a_mark)

	getMark ()

	setComment ($a_comment)

	getComment ()

	setParticipated ($a_status)

	getParticipated ()

	setRegistered ($a_status)

	getRegistered ()

	setExcused (bool $a_stat)

	getExcused ()

	updateExcusedForUser (int $a_usr_id, bool $a_status)
	Update excused status. More...

	setContact ($a_status)

	getContact ()

	isNotificationEnabled ()

	setNotificationEnabled ($value)

	updateUser ()

	getUser ($a_usr_id)

	getParticipants ()

	isRegistered ($a_usr_id)

	hasParticipated ($a_usr_id)

	isExcused (int $a_usr_id)

	isContact ($a_usr_id)
	Check if user is contact. More...

	updateParticipation ($a_usr_id, $a_status)

	register ($a_usr_id)

	unregister ($a_usr_id)

	_lookupComment ($a_event_id, $a_usr_id)

	getEventId ()

	setEventId ($a_event_id)

Static Public Member Functions
static	_updateParticipation ($a_usr_id, $a_event_id, $a_status)

static	_getRegistered ($a_event_id)

static	_getParticipated ($a_event_id)

static	_hasParticipated ($a_usr_id, $a_event_id)

static	_isRegistered ($a_usr_id, $a_event_id)

static	_register ($a_usr_id, $a_event_id)

static	_unregister ($a_usr_id, $a_event_id)

static	_lookupMark ($a_event_id, $a_usr_id)

static	_deleteByEvent ($a_event_id)

static	_deleteByUser ($a_usr_id)

Data Fields
	$ilErr

	$ilDB

	$tree

	$lng

	$event_id = null

Static Protected Member Functions
static	handleAutoFill ($a_obj_id)
	Trigger auto-fill from waiting list. More...

Protected Attributes
	$contact = 0

	$registered = []

	$participated = []

	$excused = []

	$contacts = []

Private Attributes
	$notificationEnabled

Detailed Description

class ilEventMembers

Author: Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Version

Id: class.ilEventParticipants.php 15697 2008-01-08 20:04:33Z hschottm

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

Constructor & Destructor Documentation

◆ __construct()

ilEventParticipants::__construct ( $a_event_id )

Constructor.

Parameters

int $a_event_id

Definition at line 53 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilErr = $DIC['ilErr'];
        $ilDB = $DIC->database();
        $lng = $DIC->language();
        $tree = $DIC->repositoryTree();
 
        $this->ilErr = $ilErr;
        $this->db = $ilDB;
        $this->lng = $lng;
 
        $this->event_id = $a_event_id;
        $this->__read();
    }

References $DIC, $ilDB, $ilErr, $lng, and $tree.

Member Function Documentation

◆ _deleteByEvent()

static ilEventParticipants::_deleteByEvent ( $a_event_id )

static

Definition at line 474 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "DELETE FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " ";
        $res = $ilDB->manipulate($query);
 
        include_once "Services/Tracking/classes/class.ilLPMarks.php";
        ilLPMarks::deleteObject($a_event_id);
 
        return true;
    }

References $DIC, $ilDB, $query, $res, and ilLPMarks\deleteObject().

Referenced by ilObjSession\delete().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _deleteByUser()

static ilEventParticipants::_deleteByUser ( $a_usr_id )

static

Definition at line 489 of file class.ilEventParticipants.php.

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

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

Referenced by ilObjUser\delete().

Here is the caller graph for this function:

◆ _getParticipated()

static ilEventParticipants::_getParticipated ( $a_event_id )

static

Definition at line 324 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND participated = 1";
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $user_ids[] = $row->usr_id;
        }
        return $user_ids ? $user_ids : array();
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilLPStatusEvent\_getStatusInfo().

Here is the caller graph for this function:

◆ _getRegistered()

static ilEventParticipants::_getRegistered ( $a_event_id )

static

Definition at line 308 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND registered = " . $ilDB->quote(1, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $user_ids[] = $row->usr_id;
        }
        return $user_ids ? $user_ids : array();
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilLPStatusEvent\_getStatusInfo().

Here is the caller graph for this function:

◆ _hasParticipated()

static ilEventParticipants::_hasParticipated	(	$a_usr_id,
		$a_event_id
	)

static

Definition at line 340 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT participated FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->query($query);
        if ($rec = $ilDB->fetchAssoc($res)) {
            return (bool) $rec["participated"];
        }
        return false;
    }

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

Referenced by ilLPStatusEvent\determineStatus().

Here is the caller graph for this function:

◆ _isRegistered()

static ilEventParticipants::_isRegistered	(	$a_usr_id,
		$a_event_id
	)

static

Definition at line 356 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return (bool) $row->registered;
        }
        return false;
    }

References $DIC, $ilDB, $query, $res, and ilDBConstants\FETCHMODE_OBJECT.

Referenced by ilSessionParticipants\_isParticipant(), ilLPStatusEvent\determineStatus(), ilObjSessionGUI\joinObject(), and ilObjSessionGUI\showJoinRequestButton().

Here is the caller graph for this function:

◆ _lookupComment()

ilEventParticipants::_lookupComment	(	$a_event_id,
		$a_usr_id
	)

Definition at line 457 of file class.ilEventParticipants.php.

    {
        include_once "Services/Tracking/classes/class.ilLPMarks.php";
        $lp_mark = new ilLPMarks($a_event_id, $a_usr_id);
        return $lp_mark->getComment();
    }

◆ _lookupMark()

static ilEventParticipants::_lookupMark	(	$a_event_id,
		$a_usr_id
	)

static

Definition at line 450 of file class.ilEventParticipants.php.

    {
        include_once "Services/Tracking/classes/class.ilLPMarks.php";
        $lp_mark = new ilLPMarks($a_event_id, $a_usr_id);
        return $lp_mark->getMark();
    }

◆ _register()

static ilEventParticipants::_register	(	$a_usr_id,
		$a_event_id
	)

static

Definition at line 372 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->query($query);
        if ($res->numRows()) {
            $query = "UPDATE event_participants " .
                "SET registered = '1' " .
                "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
                "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
            $res = $ilDB->manipulate($query);
        } else {
            $query = "INSERT INTO event_participants (registered,participated,event_id,usr_id) " .
                "VALUES( " .
                "1, " .
                "0, " .
                $ilDB->quote($a_event_id, 'integer') . ", " .
                $ilDB->quote($a_usr_id, 'integer') . " " .
                ")";
            $res = $ilDB->manipulate($query);
        }
        
        // refresh learning progress status after updating participant
        include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
        ilLPStatusWrapper::_updateStatus($a_event_id, $a_usr_id);
        
        return true;
    }

References $DIC, $ilDB, $query, $res, and ilLPStatusWrapper\_updateStatus().

Referenced by ilObjSessionGUI\joinObject(), and register().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _unregister()

static ilEventParticipants::_unregister	(	$a_usr_id,
		$a_event_id
	)

static

Definition at line 410 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->query($query);
        if ($res->numRows()) {
            $query = "UPDATE event_participants " .
                "SET registered = 0 " .
                "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
                "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
            $res = $ilDB->manipulate($query);
        } else {
            $query = "INSERT INTO event_participants (registered,participated,event_id,usr_id) " .
                "VALUES( " .
                "0, " .
                "0, " .
                $ilDB->quote($a_event_id, 'integer') . ", " .
                $ilDB->quote($a_usr_id, 'integer') . " " .
                ")";
            $res = $ilDB->manipulate($query);
        }
        
        // refresh learning progress status after updating participant
        include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
        ilLPStatusWrapper::_updateStatus($a_event_id, $a_usr_id);
        
        self::handleAutoFill($a_event_id);
        
        return true;
    }

References $DIC, $ilDB, $query, $res, ilLPStatusWrapper\_updateStatus(), and handleAutoFill().

Referenced by ilObjSessionGUI\joinObject(), and unregister().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ _updateParticipation()

static ilEventParticipants::_updateParticipation	(	$a_usr_id,
		$a_event_id,
		$a_status
	)

static

Definition at line 274 of file class.ilEventParticipants.php.

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
 
        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
        $res = $ilDB->query($query);
        if ($res->numRows()) {
            $query = "UPDATE event_participants " .
                "SET participated = " . $ilDB->quote($a_status, 'integer') . " " .
                "WHERE event_id = " . $ilDB->quote($a_event_id, 'integer') . " " .
                "AND usr_id = " . $ilDB->quote($a_usr_id, 'integer') . " ";
            $res = $ilDB->manipulate($query);
        } else {
            $query = "INSERT INTO event_participants (registered,participated,event_id,usr_id) " .
                "VALUES( " .
                $ilDB->quote(0, 'integer') . ", " .
                $ilDB->quote($a_status, 'integer') . ", " .
                $ilDB->quote($a_event_id, 'integer') . ", " .
                $ilDB->quote($a_usr_id, 'integer') . " " .
                ")";
            $res = $ilDB->manipulate($query);
        }
        
        // refresh learning progress status after updating participant
        include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
        ilLPStatusWrapper::_updateStatus($a_event_id, $a_usr_id);
 
        return true;
    }

References $DIC, $ilDB, $query, $res, and ilLPStatusWrapper\_updateStatus().

Referenced by updateParticipation().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getComment()

ilEventParticipants::getComment ( )

Definition at line 90 of file class.ilEventParticipants.php.

    {
        return $this->comment;
    }

References $comment.

Referenced by updateUser().

Here is the caller graph for this function:

◆ getContact()

ilEventParticipants::getContact ( )

Returns: int

Definition at line 167 of file class.ilEventParticipants.php.

    {
        return $this->contact;
    }

References $contact.

Referenced by updateUser().

Here is the caller graph for this function:

◆ getEventId()

ilEventParticipants::getEventId ( )

Definition at line 465 of file class.ilEventParticipants.php.

    {
        return $this->event_id;
    }

References $event_id.

Referenced by register(), unregister(), updateParticipation(), and updateUser().

Here is the caller graph for this function:

◆ getExcused()

ilEventParticipants::getExcused ( )

Returns: bool

Definition at line 122 of file class.ilEventParticipants.php.

                                 : bool
    {
        return $this->excused;
    }

References $excused.

Referenced by updateUser().

Here is the caller graph for this function:

◆ getMark()

ilEventParticipants::getMark ( )

Definition at line 82 of file class.ilEventParticipants.php.

    {
        return $this->mark;
    }

Referenced by updateUser().

Here is the caller graph for this function:

◆ getParticipants()

ilEventParticipants::getParticipants ( )

Definition at line 233 of file class.ilEventParticipants.php.

    {
        return $this->participants ? $this->participants : array();
    }

◆ getParticipated()

ilEventParticipants::getParticipated ( )

Definition at line 98 of file class.ilEventParticipants.php.

    {
        return $this->participated;
    }

References $participated.

Referenced by updateUser().

Here is the caller graph for this function:

◆ getRegistered()

ilEventParticipants::getRegistered ( )

Definition at line 106 of file class.ilEventParticipants.php.

    {
        return $this->registered;
    }

References $registered.

Referenced by updateUser().

Here is the caller graph for this function:

◆ getUser()

ilEventParticipants::getUser ( $a_usr_id )

Definition at line 228 of file class.ilEventParticipants.php.

    {
        return $this->participants[$a_usr_id] ? $this->participants[$a_usr_id] : array();
    }

◆ getUserId()

ilEventParticipants::getUserId ( )

Definition at line 74 of file class.ilEventParticipants.php.

    {
        return $this->user_id;
    }

Referenced by updateUser().

Here is the caller graph for this function:

◆ handleAutoFill()

static ilEventParticipants::handleAutoFill ( $a_obj_id )

staticprotected

Trigger auto-fill from waiting list.

Parameters

int $a_obj_id

Definition at line 573 of file class.ilEventParticipants.php.

    {
        $sess = new ilObjSession($a_obj_id, false);
        $sess->handleAutoFill();
    }

References $sess.

Referenced by _unregister(), and updateUser().

Here is the caller graph for this function:

◆ hasParticipated()

ilEventParticipants::hasParticipated ( $a_usr_id )

Definition at line 243 of file class.ilEventParticipants.php.

    {
        return $this->participants[$a_usr_id]['participated'] ? true : false;
    }

◆ isContact()

ilEventParticipants::isContact ( $a_usr_id )

Check if user is contact.

Parameters

$a_usr_id

Returns: bool

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

    {
        return $this->participants[$a_usr_id]['contact'] ? true : false;
    }

◆ isExcused()

ilEventParticipants::isExcused ( int $a_usr_id )

Parameters

int $a_usr_id

Returns: bool

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

                                             : bool
    {
        return $this->participants[$a_usr_id]['excused'] ? true : false;
    }

◆ isNotificationEnabled()

ilEventParticipants::isNotificationEnabled ( )

Returns: boolean

Definition at line 175 of file class.ilEventParticipants.php.

    {
        return (bool) $this->notificationEnabled;
    }

References $notificationEnabled.

Referenced by updateUser().

Here is the caller graph for this function:

◆ isRegistered()

ilEventParticipants::isRegistered ( $a_usr_id )

Definition at line 238 of file class.ilEventParticipants.php.

    {
        return $this->participants[$a_usr_id]['registered'] ? true : false;
    }

◆ register()

ilEventParticipants::register ( $a_usr_id )

Definition at line 405 of file class.ilEventParticipants.php.

    {
        return ilEventParticipants::_register($a_usr_id, $this->getEventId());
    }

References _register(), and getEventId().

Here is the call graph for this function:

◆ setComment()

ilEventParticipants::setComment ( $a_comment )

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

    {
        $this->comment = $a_comment;
    }

References comment().

Here is the call graph for this function:

◆ setContact()

ilEventParticipants::setContact ( $a_status )

Parameters

bool $a_status

Definition at line 159 of file class.ilEventParticipants.php.

    {
        $this->contact = (int) $a_status;
    }

◆ setEventId()

ilEventParticipants::setEventId ( $a_event_id )

Definition at line 469 of file class.ilEventParticipants.php.

    {
        $this->event_id = $a_event_id;
    }

◆ setExcused()

ilEventParticipants::setExcused ( bool $a_stat )

Parameters

bool $a_stat

Definition at line 114 of file class.ilEventParticipants.php.

    {
        $this->excused = $a_stat;
    }

◆ setMark()

ilEventParticipants::setMark ( $a_mark )

Definition at line 78 of file class.ilEventParticipants.php.

    {
        $this->mark = $a_mark;
    }

◆ setNotificationEnabled()

ilEventParticipants::setNotificationEnabled ( $value )

Parameters

boolean $value

Definition at line 183 of file class.ilEventParticipants.php.

    {
        $this->notificationEnabled = (bool) $value;
    }

◆ setParticipated()

ilEventParticipants::setParticipated ( $a_status )

Definition at line 94 of file class.ilEventParticipants.php.

    {
        $this->participated = $a_status;
    }

◆ setRegistered()

ilEventParticipants::setRegistered ( $a_status )

Definition at line 102 of file class.ilEventParticipants.php.

    {
        $this->registered = $a_status;
    }

◆ setUserId()

ilEventParticipants::setUserId ( $a_usr_id )

Definition at line 70 of file class.ilEventParticipants.php.

    {
        $this->user_id = $a_usr_id;
    }

◆ unregister()

ilEventParticipants::unregister ( $a_usr_id )

Definition at line 445 of file class.ilEventParticipants.php.

    {
        return ilEventParticipants::_unregister($a_usr_id, $this->getEventId());
    }

References _unregister(), and getEventId().

Here is the call graph for this function:

◆ updateExcusedForUser()

ilEventParticipants::updateExcusedForUser	(	int	$a_usr_id,
		bool	$a_status
	)

Update excused status.

Parameters

int	$a_usr_id
bool	$a_status

Definition at line 133 of file class.ilEventParticipants.php.

    {
        if (!is_array($this->participants) || !array_key_exists($a_usr_id, $this->participants)) {
            $event_part = new \ilEventParticipants($this->event_id);
            $event_part->setUserId($a_usr_id);
            $event_part->setMark('');
            $event_part->setComment('');
            $event_part->setNotificationEnabled(false);
            $event_part->setParticipated(false);
            $event_part->setRegistered(false);
            $event_part->setContact(false);
            $event_part->setExcused($a_status);
            $event_part->updateUser();
            return;
        }
 
        $query = 'update event_participants set excused = ' . $this->db->quote($a_status, \ilDBConstants::T_INTEGER) . ' ' .
            'where event_id = ' . $this->db->quote($this->event_id, \ilDBConstants::T_INTEGER) . ' and ' .
            'usr_id = ' . $this->db->quote($a_usr_id, \ilDBConstants::T_INTEGER);
        $this->db->manipulate($query);
        return;
    }

References $query, and ilDBConstants\T_INTEGER.

◆ updateParticipation()

ilEventParticipants::updateParticipation	(	$a_usr_id,
		$a_status
	)

Definition at line 269 of file class.ilEventParticipants.php.

    {
        ilEventParticipants::_updateParticipation($a_usr_id, $this->getEventId(), $a_status);
    }

References _updateParticipation(), and getEventId().

Here is the call graph for this function:

◆ updateUser()

ilEventParticipants::updateUser ( )

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

    {
        global $DIC;
 
        $ilDB = $DIC['ilDB'];
        
        $query = "DELETE FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($this->getEventId(), 'integer') . " " .
            "AND usr_id = " . $ilDB->quote($this->getUserId(), 'integer') . " ";
        $res = $ilDB->manipulate($query);
 
        $query = "INSERT INTO event_participants (event_id,usr_id,registered,participated,contact,notification_enabled, excused " .
            ") VALUES( " .
            $ilDB->quote($this->getEventId(), 'integer') . ", " .
            $ilDB->quote($this->getUserId(), 'integer') . ", " .
            $ilDB->quote($this->getRegistered(), 'integer') . ", " .
            $ilDB->quote($this->getParticipated(), 'integer') . ', ' .
            $ilDB->quote($this->getContact(), 'integer') . ', ' .
            $ilDB->quote($this->isNotificationEnabled(), 'integer') . ', ' .
            $ilDB->quote((int) $this->getExcused(), 'integer') .
            ")";
        $res = $ilDB->manipulate($query);
 
        include_once "Services/Tracking/classes/class.ilLPMarks.php";
        $lp_mark = new ilLPMarks($this->getEventId(), $this->getUserId());
        $lp_mark->setComment($this->getComment());
        $lp_mark->setMark($this->getMark());
        $lp_mark->update();
        
        // refresh learning progress status after updating participant
        include_once("./Services/Tracking/classes/class.ilLPStatusWrapper.php");
        ilLPStatusWrapper::_updateStatus($this->getEventId(), $this->getUserId());
        
        if (!$this->getRegistered()) {
            self::handleAutoFill($this->getEventId());
        }
 
        return true;
    }