ilExcMemberRepository Class Reference

This should hold all accesses to exc_members table in the future. More...

Collaboration diagram for ilExcMemberRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)
	Constructor. More...
	getExerciseIdsOfUser (int $user_id)
	Get all exercise IDs of a user. More...

Protected Attributes
	$db

Detailed Description

This should hold all accesses to exc_members table in the future.

Author

killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 11 of file class.ilExcMemberRepository.php.

Constructor & Destructor Documentation

__construct()

ilExcMemberRepository::__construct

(

\ilDBInterface

$db = null

)

Constructor.

Parameters

ilDBInterface

$db

Definition at line 24 of file class.ilExcMemberRepository.php.

References $db, and $DIC.

    {
        global $DIC;

        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
    }

Member Function Documentation

getExerciseIdsOfUser()

ilExcMemberRepository::getExerciseIdsOfUser

(

int

$user_id

)

Get all exercise IDs of a user.

Parameters

int

user id

Returns

int[] exercise ids

Definition at line 39 of file class.ilExcMemberRepository.php.

References $db.

                                                       : array
    {
        $db = $this->db;

        $set = $db->queryF(
            "SELECT DISTINCT obj_id FROM exc_members " .
            " WHERE usr_id = %s ",
            array("integer"),
            array($user_id)
        );
        $ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $ids[] = $rec["obj_id"];
        }

        return $ids;
    }

Field Documentation

$db

ilExcMemberRepository::$db

protected

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

Referenced by __construct(), and getExerciseIdsOfUser().

---

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

• Modules/Exercise/Members/classes/class.ilExcMemberRepository.php