ilExcMemberRepository Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilExcMemberRepository:

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

Protected Attributes
ilDBInterface	$db

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning This should hold all accesses to exc_members table in the future

Author

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

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

Constructor & Destructor Documentation

__construct()

ilExcMemberRepository::__construct

(

ilDBInterface

$db = null

)

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

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

References $db, and $DIC.

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 42 of file class.ilExcMemberRepository.php.

     : 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

ilDBInterface ilExcMemberRepository::$db

protected

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

Referenced by __construct().

---

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

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