class.ilExcMemberRepository.php

Go to the documentation of this file.

<?php

class ilExcMemberRepository
{
    protected ilDBInterface $db;

    public function __construct(?ilDBInterface $db = null)
    {
        global $DIC;

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

    public function getExerciseIdsOfUser(
        int $user_id
    ): 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;
    }
}