33 $this->event_id = $a_event_id;
39 $this->user_id = $a_usr_id;
43 return $this->user_id;
47 $this->mark = $a_mark;
55 $this->comment = $a_comment;
63 $this->participated = $a_status;
71 $this->registered = $a_status;
81 $query =
"DELETE FROM event_participants ".
82 "WHERE event_id = ".$ilDB->quote($this->
getEventId() ,
'integer').
" ".
83 "AND usr_id = ".$ilDB->quote($this->
getUserId() ,
'integer').
" ";
86 $query =
"INSERT INTO event_participants (event_id,usr_id,registered,participated".
88 $ilDB->quote($this->
getEventId() ,
'integer').
", ".
89 $ilDB->quote($this->
getUserId() ,
'integer').
", ".
97 include_once
"Services/Tracking/classes/class.ilLPMarks.php";
100 $lp_mark->setMark($this->
getMark());
104 include_once(
"./Services/Tracking/classes/class.ilLPStatusWrapper.php");
117 return $this->participants[$a_usr_id] ? $this->participants[$a_usr_id] : array();
122 return $this->participants ? $this->participants : array();
127 return $this->participants[$a_usr_id][
'registered'] ? true :
false;
132 return $this->participants[$a_usr_id][
'participated'] ? true :
false;
144 $query =
"SELECT * FROM event_participants ".
145 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
146 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
150 $query =
"UPDATE event_participants ".
151 "SET participated = ".$ilDB->quote($a_status ,
'integer').
" ".
152 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
153 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
158 $query =
"INSERT INTO event_participants (registered,participated,event_id,usr_id) ".
160 $ilDB->quote(0 ,
'integer').
", ".
161 $ilDB->quote($a_status ,
'integer').
", ".
162 $ilDB->quote($a_event_id ,
'integer').
", ".
163 $ilDB->quote($a_usr_id ,
'integer').
" ".
169 include_once(
"./Services/Tracking/classes/class.ilLPStatusWrapper.php");
179 $query =
"SELECT * FROM event_participants ".
180 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
181 "AND registered = ".$ilDB->quote(1 ,
'integer');
185 $user_ids[] =
$row->usr_id;
187 return $user_ids ? $user_ids : array();
194 $query =
"SELECT * FROM event_participants ".
195 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
196 "AND participated = 1";
200 $user_ids[] =
$row->usr_id;
202 return $user_ids ? $user_ids : array();
209 $query =
"SELECT participated FROM event_participants ".
210 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
211 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
213 if ($rec = $ilDB->fetchAssoc(
$res))
215 return (
bool) $rec[
"participated"];
224 $query =
"SELECT * FROM event_participants ".
225 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
226 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
230 return (
bool)
$row->registered;
239 $query =
"SELECT * FROM event_participants ".
240 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
241 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
245 $query =
"UPDATE event_participants ".
246 "SET registered = '1' ".
247 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
248 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
253 $query =
"INSERT INTO event_participants (registered,participated,event_id,usr_id) ".
257 $ilDB->quote($a_event_id ,
'integer').
", ".
258 $ilDB->quote($a_usr_id ,
'integer').
" ".
264 include_once(
"./Services/Tracking/classes/class.ilLPStatusWrapper.php");
269 function register($a_usr_id)
278 $query =
"SELECT * FROM event_participants ".
279 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
280 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
284 $query =
"UPDATE event_participants ".
285 "SET registered = 0 ".
286 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ".
287 "AND usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
292 $query =
"INSERT INTO event_participants (registered,participated,event_id,usr_id) ".
296 $ilDB->quote($a_event_id ,
'integer').
", ".
297 $ilDB->quote($a_usr_id ,
'integer').
" ".
303 include_once(
"./Services/Tracking/classes/class.ilLPStatusWrapper.php");
306 self::handleAutoFill($a_event_id);
317 include_once
"Services/Tracking/classes/class.ilLPMarks.php";
318 $lp_mark =
new ilLPMarks($a_event_id, $a_usr_id);
319 return $lp_mark->getMark();
338 include_once
"Services/Tracking/classes/class.ilLPMarks.php";
339 $lp_mark =
new ilLPMarks($a_event_id, $a_usr_id);
340 return $lp_mark->getComment();
364 $this->event_id = $a_event_id;
371 $query =
"DELETE FROM event_participants ".
372 "WHERE event_id = ".$ilDB->quote($a_event_id ,
'integer').
" ";
375 include_once
"Services/Tracking/classes/class.ilLPMarks.php";
384 $query =
"DELETE FROM event_participants ".
385 "WHERE usr_id = ".$ilDB->quote($a_usr_id ,
'integer').
" ";
396 include_once
"Services/Tracking/classes/class.ilLPMarks.php";
400 $query =
"SELECT * FROM event_participants ".
401 "WHERE event_id = ".$ilDB->quote($this->
getEventId()).
" ";
405 $this->participants[
$row->usr_id][
'usr_id'] =
$row->usr_id;
406 $this->participants[
$row->usr_id][
'registered'] =
$row->registered;
407 $this->participants[
$row->usr_id][
'participated'] =
$row->participated;
414 $this->participants[
$row->usr_id][
'mark'] = $lp_mark->getMark();
415 $this->participants[
$row->usr_id][
'comment'] = $lp_mark->getComment();
420 $this->registered[] =
$row->usr_id;
422 if(
$row->participated)
424 $this->participated[] =
$row->usr_id;
437 $sess->handleAutoFill();
_lookupMark($a_event_id, $a_usr_id)
updateParticipation($a_usr_id, $a_status)
static _updateStatus($a_obj_id, $a_usr_id, $a_obj=null, $a_percentage=false, $a_force_raise=false)
Update status.
_unregister($a_usr_id, $a_event_id)
_register($a_usr_id, $a_event_id)
static _isRegistered($a_usr_id, $a_event_id)
const DB_FETCHMODE_OBJECT
static _hasParticipated($a_usr_id, $a_event_id)
_getRegistered($a_event_id)
_updateParticipation($a_usr_id, $a_event_id, $a_status)
_lookupComment($a_event_id, $a_usr_id)
hasParticipated($a_usr_id)
setParticipated($a_status)
static handleAutoFill($a_obj_id)
Trigger auto-fill from waiting list.
_deleteByEvent($a_event_id)
static deleteObject($a_obj_id)
Delete object.
ilEventParticipants($a_event_id)
_getParticipated($a_event_id)