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 ()

	updateUser ()

	getUser ($a_usr_id)

	getParticipants ()

	isRegistered ($a_usr_id)

	hasParticipated ($a_usr_id)

	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
	$registered = array()

	$participated = array()

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

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

     {
         global $ilErr,$ilDB,$lng,$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 382 of file class.ilEventParticipants.php.

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

Referenced by __construct().

     {
         global $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]['mark'] = $row->mark;
             $this->participants[$row->usr_id]['comment'] = $row->e_comment;
             */
 
             $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 357 of file class.ilEventParticipants.php.

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

Referenced by ilObjSession\delete().

     {
         global $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 370 of file class.ilEventParticipants.php.

References $ilDB, $query, and $res.

Referenced by ilObjUser\delete().

     {
         global $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 189 of file class.ilEventParticipants.php.

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

Referenced by ilLPStatusEvent\_getStatusInfo().

     {
         global $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 175 of file class.ilEventParticipants.php.

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

Referenced by ilLPStatusEvent\_getStatusInfo().

     {
         global $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 203 of file class.ilEventParticipants.php.

References $ilDB, $query, and $res.

Referenced by ilLPStatusEvent\determineStatus().

     {
         global $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 217 of file class.ilEventParticipants.php.

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

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

     {
         global $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 326 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();
 
         /*
         global $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 $row->e_comment;
         }
         return '';
         */
     }

◆ _lookupMark()

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

static

Definition at line 305 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();
 
         /*
         global $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 $row->mark;
         }
         return '';
         */
     }

◆ _register()

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

static

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

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

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

     {
         global $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 267 of file class.ilEventParticipants.php.

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

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

     {
         global $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 143 of file class.ilEventParticipants.php.

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

Referenced by updateParticipation().

     {
         global $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 61 of file class.ilEventParticipants.php.

References $comment.

Referenced by updateUser().

     {
         return $this->comment;
     }

Here is the caller graph for this function:

◆ getEventId()

ilEventParticipants::getEventId ( )

Definition at line 348 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 53 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 123 of file class.ilEventParticipants.php.

References array.

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

◆ getParticipated()

ilEventParticipants::getParticipated ( )

Definition at line 69 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 77 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 118 of file class.ilEventParticipants.php.

References array.

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

◆ getUserId()

ilEventParticipants::getUserId ( )

Definition at line 45 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 417 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 133 of file class.ilEventParticipants.php.

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

◆ isRegistered()

ilEventParticipants::isRegistered ( $a_usr_id )

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

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

◆ register()

ilEventParticipants::register ( $a_usr_id )

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

References comment().

     {
         $this->comment = $a_comment;
     }

Here is the call graph for this function:

◆ setEventId()

ilEventParticipants::setEventId ( $a_event_id )

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

     {
         $this->event_id = $a_event_id;
     }

◆ setMark()

ilEventParticipants::setMark ( $a_mark )

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

     {
         $this->mark = $a_mark;
     }

◆ setParticipated()

ilEventParticipants::setParticipated ( $a_status )

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

     {
         $this->participated = $a_status;
     }

◆ setRegistered()

ilEventParticipants::setRegistered ( $a_status )

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

     {
         $this->registered = $a_status;
     }

◆ setUserId()

ilEventParticipants::setUserId ( $a_usr_id )

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

     {
         $this->user_id = $a_usr_id;
     }

◆ unregister()

ilEventParticipants::unregister ( $a_usr_id )

Definition at line 300 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 138 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 81 of file class.ilEventParticipants.php.

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

     {
         global $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" . // ,mark,e_comment
             ") VALUES( " .
             $ilDB->quote($this->getEventId(), 'integer') . ", " .
             $ilDB->quote($this->getUserId(), 'integer') . ", " .
             $ilDB->quote($this->getRegistered(), 'integer') . ", " .
             $ilDB->quote($this->getParticipated(), 'integer') . /* .", ".
             $ilDB->quote($this->getMark() ,'text').", ".
             $ilDB->quote($this->getComment() ,'text')." ". */
             ")";
         $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

◆ $event_id

ilEventParticipants::$event_id = null

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

Referenced by getParticipated().

◆ $registered

ilEventParticipants::$registered = array()

protected

Definition at line 20 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

Public Member Functions

Static Public Member Functions

Data Fields

Static Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __read()

◆ _deleteByEvent()

◆ _deleteByUser()

◆ _getParticipated()

◆ _getRegistered()

◆ _hasParticipated()

◆ _isRegistered()

◆ _lookupComment()

◆ _lookupMark()

◆ _register()

◆ _unregister()

◆ _updateParticipation()

◆ getComment()

◆ getEventId()

◆ getMark()

◆ getParticipants()

◆ getParticipated()

◆ getRegistered()

◆ getUser()

◆ getUserId()

◆ handleAutoFill()

◆ hasParticipated()

◆ isRegistered()

◆ register()

◆ setComment()

◆ setEventId()

◆ setMark()

◆ setParticipated()

◆ setRegistered()

◆ setUserId()

◆ unregister()

◆ updateParticipation()

◆ updateUser()

Field Documentation

◆ $event_id

◆ $ilDB

◆ $ilErr

◆ $lng

◆ $participated

◆ $registered

◆ $tree