class.ilExcMemberRepository.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2019 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilExcMemberRepository
{
 
    protected $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;
    }
}