chamilo / chamilo-lms

     * @param array $groupInfo

     * @return bool TRUE if successful

     */

    public static function unsubscribe_all_users($groupInfo)

    {

        $course_id = api_get_course_int_id();

        $groupId = (int) $groupInfo['id'];

        if (empty($course_id) || empty($groupId)) {

            return false;

        }

        $table_group_user = Database::get_course_table(TABLE_GROUP_USER);

        $sql = "DELETE FROM $table_group_user

                WHERE 

                    group_id = $groupId AND 

                    c_id = $course_id";

        $result = Database::query($sql);

        return $result;

    }

    /**

     * Unsubscribe all tutors from one or more groups

     * @return bool TRUE if successful

     * @author Patrick Cool <[email protected]>, Ghent University

     */

    public static function unsubscribe_all_tutors($groupId)

    {

        $courseId = api_get_course_int_id();

        $groupId = (int) $groupId;

        if (empty($courseId) || empty($groupId)) {

            return false;

        }

        if (!empty($groupId) > 0) {

            $table_group_tutor = Database::get_course_table(TABLE_GROUP_TUTOR);

            $sql = "DELETE FROM $table_group_tutor

                    WHERE group_id = $groupId AND c_id = $courseId";

            $result = Database::query($sql);

            return $result;

        }

        return true;

    }

    /**

     * Is the user a tutor of this group?

     *

     * @return array

     */

    public static function searchCourseInSessionsFromUser($userId, $courseId)

    {

        $table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $userId = (int) $userId;

        $courseId = (int) $courseId;

        if (empty($userId) || empty($courseId)) {

            return [];

        }

        $sql = "SELECT * FROM $table 

                WHERE c_id = $courseId AND user_id = $userId";

        $result = Database::query($sql);

        return Database::store_result($result, 'ASSOC');

    }

    /**

     * Subscribe and redirect to session after inscription