chamilo / chamilo-lms

     * @param int $course_id

     * @return array

     */

    public function get_usergroup_by_course($course_id)

    {

        if ($this->useMultipleUrl) {

            $urlId = api_get_current_access_url_id();

            $options = array(

                'where' => array(

                    'c.course_id = ? AND access_url_id = ?' => array(

                        $course_id,

                        $urlId,

                    ),

                ),

            );

            $from = $this->usergroup_rel_course_table." as c INNER JOIN ".$this->access_url_rel_usergroup." a

                    ON c.usergroup_id = a.usergroup_id";

        } else {

            $options = array('where' => array('c.course_id = ?' => $course_id));

            $from = $this->usergroup_rel_course_table." c";

        }

        $results = Database::select('c.usergroup_id', $from, $options);

        $array = array();

        if (!empty($results)) {

            foreach ($results as $row) {

                $array[] = $row['usergroup_id'];

            }

        }

        return $array;

    }

    /**

     * @param int $usergroup_id

     * @param   int $userId user id

     * @return array

     */

    public function get_usergroup_by_user($userId)

    {

        if ($this->useMultipleUrl) {

            $urlId = api_get_current_access_url_id();

            $from = $this->usergroup_rel_user_table." u

                    INNER JOIN {$this->access_url_rel_usergroup} a ON (a.usergroup_id AND u.usergroup_id)";

            $where =  array('where' => array('user_id = ? AND access_url_id = ? ' => array($userId, $urlId)));

        } else {

            $from = $this->usergroup_rel_user_table." u ";

            $where =  array('where' => array('user_id = ?' => $userId));

        }

        $results = Database::select(

            'u.usergroup_id',

            $from,

            $where

        );

        $array = array();

        if (!empty($results)) {

            foreach ($results as $row) {

                $array[] = $row['usergroup_id'];

            }

        }

        return $array;

    }

    /**

     * Subscribes sessions to a group  (also adding the members of the group in the session and course)