Public Member Functions
	ilCourseWaitingList ($a_course_id)
	getCourseId ()
	addToList ($a_usr_id)
	updateSubscriptionTime ($a_usr_id, $a_subtime)
	removeFromList ($a_usr_id)
	isOnList ($a_usr_id)
	getCountUsers ()
	getPosition ($a_usr_id)
	getAllUsers ()
	getUser ($a_usr_id)
	__read ()
	_deleteAll ($a_course_id)
	_deleteUser ($a_usr_id)
Data Fields
	$db = null
	$course_id = 0

Detailed Description

Definition at line 35 of file class.ilCourseWaitingList.php.

Member Function Documentation

ilCourseWaitingList::__read ( )

Definition at line 125 of file class.ilCourseWaitingList.php.

References $counter, $query, $res, and $row.

Referenced by addToList(), ilCourseWaitingList(), and removeFromList().

        {
                $this->users = array();

                $query = "SELECT * FROM crs_waiting_list ".
                        "WHERE obj_id = '".$this->getCourseId()."' ORDER BY sub_time";

                $res = $this->db->query($query);
                $counter = 0;
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        ++$counter;
                        $this->users[$row->usr_id]['position']  = $counter;
                        $this->users[$row->usr_id]['time']              = $row->sub_time;
                        $this->users[$row->usr_id]['usr_id']    = $row->usr_id;

                }
                return true;
        }

Here is the caller graph for this function:

ilCourseWaitingList::_deleteAll ( $ a_course_id )

Definition at line 146 of file class.ilCourseWaitingList.php.

References $query.

Referenced by ilSoapCourseAdministration::updateCourse().

        {
                global $ilDB;

                $query = "DELETE FROM crs_waiting_list WHERE obj_id = '".$a_course_id."'";
                $ilDB->query($query);

                return true;
        }

Here is the caller graph for this function:

ilCourseWaitingList::_deleteUser ( $ a_usr_id )

Definition at line 155 of file class.ilCourseWaitingList.php.

References $query.

        {
                global $ilDB;

                $query = "DELETE FROM crs_waiting_list WHERE usr_id = '".$a_usr_id."'";
                $ilDB->query($query);

                return true;
        }

ilCourseWaitingList::addToList ( $ a_usr_id )

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

References $query, __read(), and isOnList().

        {
                if($this->isOnList($a_usr_id))
                {
                        return false;
                }
                $query = "INSERT INTO crs_waiting_list ".
                        "SET obj_id = '".$this->getCourseId()."', ".
                        "usr_id = '".$a_usr_id."', ".
                        "sub_time = '".time()."'";

                $this->db->query($query);
                $this->__read();

                return false;
        }

Here is the call graph for this function:

ilCourseWaitingList::getAllUsers ( )

Definition at line 113 of file class.ilCourseWaitingList.php.

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

ilCourseWaitingList::getCountUsers ( )

Definition at line 103 of file class.ilCourseWaitingList.php.

        {
                return count($this->users);
        }

ilCourseWaitingList::getCourseId ( )

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

        {
                return $this->course_id;
        }

ilCourseWaitingList::getPosition ( $ a_usr_id )

Definition at line 108 of file class.ilCourseWaitingList.php.

        {
                return isset($this->users[$a_usr_id]) ? $this->users[$a_usr_id]['position'] : -1;
        }

ilCourseWaitingList::getUser ( $ a_usr_id )

Definition at line 118 of file class.ilCourseWaitingList.php.

        {
                return isset($this->users[$a_usr_id]) ? $this->users[$a_usr_id] : false;
        }

ilCourseWaitingList::ilCourseWaitingList ( $ a_course_id )

Definition at line 42 of file class.ilCourseWaitingList.php.

References __read().

        {
                global $ilDB;

                $this->db = $ilDB;
                $this->course_id = $a_course_id;

                $this->__read();
        }

Here is the call graph for this function:

ilCourseWaitingList::isOnList ( $ a_usr_id )

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

Referenced by addToList().

        {       
                return isset($this->users[$a_usr_id]) ? true : false;
        }

Here is the caller graph for this function:

ilCourseWaitingList::removeFromList ( $ a_usr_id )

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

References $query, and __read().

        {
                $query = "DELETE FROM crs_waiting_list ".
                        " WHERE obj_id = '".$this->getCourseId()."' ".
                        " AND usr_id = '".$a_usr_id."'";

                $this->db->query($query);
                $this->__read();

                return true;
        }

Here is the call graph for this function:

ilCourseWaitingList::updateSubscriptionTime	(	$	a_usr_id,
		$	a_subtime
	)

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

References $query.

        {
                $query = "UPDATE crs_waiting_list ".
                        "SET sub_time = '".ilUtil::prepareDBString($a_subtime)."' ".
                        "WHERE usr_id = '".ilUtil::prepareDBString($a_usr_id)."' ".
                        "AND obj_id = '".$this->getCourseId()."'";

                $this->db->query($query);

                return true;
        }

Field Documentation

ilCourseWaitingList::$course_id = 0

Definition at line 38 of file class.ilCourseWaitingList.php.

ilCourseWaitingList::$db = null

Definition at line 37 of file class.ilCourseWaitingList.php.

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

course/classes/class.ilCourseWaitingList.php

ilCourseWaitingList Class Reference

Public Member Functions

Data Fields

Detailed Description

Member Function Documentation

Field Documentation