ilEventParticipants Class Reference

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 ()
	setContact ($a_status)
	getContact ()
	updateUser ()
	getUser ($a_usr_id)
	getParticipants ()
	isRegistered ($a_usr_id)
	hasParticipated ($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)
	__read ()

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 = array()
	$participated = array()
	$contacts = []

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 36 of file class.ilEventParticipants.php.

References $DIC, $ilDB, $ilErr, $lng, $tree, and __read().

    {
        global $DIC;

        $ilErr = $DIC['ilErr'];
        $ilDB = $DIC['ilDB'];
        $lng = $DIC['lng'];
        $tree = $DIC['tree'];

        $this->ilErr = $ilErr;
        $this->db = $ilDB;
        $this->lng = $lng;

        $this->event_id = $a_event_id;
        $this->__read();
    }

Here is the call graph for this function:

Member Function Documentation

__read()

ilEventParticipants::__read

(

)

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

References $DIC, $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_OBJECT, and getEventId().

Referenced by __construct().

    {
        global $DIC;

        $ilDB = $DIC['ilDB'];

        $query = "SELECT * FROM event_participants " .
            "WHERE event_id = " . $ilDB->quote($this->getEventId()) . " ";
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->participants[$row->usr_id]['usr_id'] = $row->usr_id;
            $this->participants[$row->usr_id]['registered'] = $row->registered;
            $this->participants[$row->usr_id]['participated'] = $row->participated;
            $this->participants[$row->usr_id]['contact'] = $row->contact;

            $lp_mark = new ilLPMarks($this->getEventId(), $row->usr_id);
            $this->participants[$row->usr_id]['mark'] = $lp_mark->getMark();
            $this->participants[$row->usr_id]['comment'] = $lp_mark->getComment();
            
            
            if ($row->registered) {
                $this->registered[] = $row->usr_id;
            }
            if ($row->participated) {
                $this->participated[] = $row->usr_id;
            }
        }
    }

Here is the call graph for this function:

Here is the caller graph for this function:

_deleteByEvent()

static ilEventParticipants::_deleteByEvent (   $a_event_id )

static

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

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

Referenced by ilObjSession\delete().

    {
        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;
    }

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 401 of file class.ilEventParticipants.php.

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

Referenced by ilObjUser\delete().

    {
        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;
    }

Here is the caller graph for this function:

_getParticipated()

static ilEventParticipants::_getParticipated (   $a_event_id )

static

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

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

Referenced by ilLPStatusEvent\_getStatusInfo().

    {
        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();
    }

Here is the caller graph for this function:

_getRegistered()

static ilEventParticipants::_getRegistered (   $a_event_id )

static

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

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

Referenced by ilLPStatusEvent\_getStatusInfo().

    {
        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();
    }

Here is the caller graph for this function:

_hasParticipated()

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

static

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

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

Referenced by ilLPStatusEvent\determineStatus().

    {
        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;
    }

Here is the caller graph for this function:

_isRegistered()

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

static

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

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

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

    {
        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;
    }

Here is the caller graph for this function:

_lookupComment()

ilEventParticipants::_lookupComment	(		$a_event_id,
			$a_usr_id
	)

Definition at line 369 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 362 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 284 of file class.ilEventParticipants.php.

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

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

    {
        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;
    }

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 322 of file class.ilEventParticipants.php.

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

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

    {
        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;
    }

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 186 of file class.ilEventParticipants.php.

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

Referenced by updateParticipation().

    {
        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;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

getComment()

ilEventParticipants::getComment

(

)

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

References $comment.

Referenced by updateUser().

    {
        return $this->comment;
    }

Here is the caller graph for this function:

getContact()

ilEventParticipants::getContact

(

)

Returns

int

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

References $contact.

Referenced by updateUser().

    {
        return $this->contact;
    }

Here is the caller graph for this function:

getEventId()

ilEventParticipants::getEventId

(

)

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

References $event_id.

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

    {
        return $this->event_id;
    }

Here is the caller graph for this function:

getMark()

ilEventParticipants::getMark

(

)

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

Referenced by updateUser().

    {
        return $this->mark;
    }

Here is the caller graph for this function:

getParticipants()

ilEventParticipants::getParticipants

(

)

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

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

getParticipated()

ilEventParticipants::getParticipated

(

)

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

References $participated.

Referenced by updateUser().

    {
        return $this->participated;
    }

Here is the caller graph for this function:

getRegistered()

ilEventParticipants::getRegistered

(

)

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

References $registered.

Referenced by updateUser().

    {
        return $this->registered;
    }

Here is the caller graph for this function:

getUser()

ilEventParticipants::getUser

(

$a_usr_id

)

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

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

getUserId()

ilEventParticipants::getUserId

(

)

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

Referenced by updateUser().

    {
        return $this->user_id;
    }

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 449 of file class.ilEventParticipants.php.

References $sess.

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

hasParticipated()

ilEventParticipants::hasParticipated

(

$a_usr_id

)

Definition at line 164 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 175 of file class.ilEventParticipants.php.

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

isRegistered()

ilEventParticipants::isRegistered

(

$a_usr_id

)

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

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

register()

ilEventParticipants::register

(

$a_usr_id

)

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

References _register(), and getEventId().

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

Here is the call graph for this function:

setComment()

ilEventParticipants::setComment

(

$a_comment

)

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

References comment().

    {
        $this->comment = $a_comment;
    }

Here is the call graph for this function:

setContact()

ilEventParticipants::setContact

(

$a_status

)

Parameters

bool

$a_status

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

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

setEventId()

ilEventParticipants::setEventId

(

$a_event_id

)

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

    {
        $this->event_id = $a_event_id;
    }

setMark()

ilEventParticipants::setMark

(

$a_mark

)

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

    {
        $this->mark = $a_mark;
    }

setParticipated()

ilEventParticipants::setParticipated

(

$a_status

)

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

    {
        $this->participated = $a_status;
    }

setRegistered()

ilEventParticipants::setRegistered

(

$a_status

)

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

    {
        $this->registered = $a_status;
    }

setUserId()

ilEventParticipants::setUserId

(

$a_usr_id

)

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

    {
        $this->user_id = $a_usr_id;
    }

unregister()

ilEventParticipants::unregister

(

$a_usr_id

)

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

References _unregister(), and getEventId().

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

Here is the call graph for this function:

updateParticipation()

ilEventParticipants::updateParticipation	(		$a_usr_id,
			$a_status
	)

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

References _updateParticipation(), and getEventId().

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

Here is the call graph for this function:

updateUser()

ilEventParticipants::updateUser

(

)

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

References $DIC, $ilDB, $query, $res, ilLPStatusWrapper\_updateStatus(), getComment(), getContact(), getEventId(), getMark(), getParticipated(), getRegistered(), and getUserId().

    {
        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 " .
            ") 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') . ' ' .
            ")";
        $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;
    }

Here is the call graph for this function:

Field Documentation

$contact

ilEventParticipants::$contact = 0

protected

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

Referenced by getContact().

$contacts

ilEventParticipants::$contacts = []

protected

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

$event_id

ilEventParticipants::$event_id = null

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

Referenced by getEventId().

$ilDB

ilEventParticipants::$ilDB

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

Referenced by __construct(), __read(), _deleteByEvent(), _deleteByUser(), _getParticipated(), _getRegistered(), _hasParticipated(), _isRegistered(), _register(), _unregister(), _updateParticipation(), and updateUser().

$ilErr

ilEventParticipants::$ilErr

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

Referenced by __construct().

$lng

ilEventParticipants::$lng

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

Referenced by __construct().

$participated

ilEventParticipants::$participated = array()

protected

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

Referenced by getParticipated().

$registered

ilEventParticipants::$registered = array()

protected

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

Referenced by getRegistered().

$tree

ilEventParticipants::$tree

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

Referenced by __construct().

---

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

• Modules/Session/classes/class.ilEventParticipants.php