chamilo / chamilo-lms

     *

     * @return array

     * */

    public static function get_all_group_data($visibility = GROUP_PERMISSION_OPEN, $from = 0, $number_of_items = 10)

    {

        $table = Database :: get_main_table(TABLE_MAIN_GROUP);

        $visibility = intval($visibility);

        $sql = "SELECT * FROM $table WHERE visibility = $visibility ";

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

        $data = array();

        while ($item = Database::fetch_array($res)) {

            $data[] = $item;

        }

        return $data;

    }

    /**

     * Gets a list of all group

     * @param bool $onlyActive Whether to return only active languages (default false)

     * @return Array All information about sub-language

     */

    public static function getAllLanguages($onlyActive = false)

    {

        $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = 'SELECT * FROM ' . $table;

        if ($onlyActive) {

            $sql .= ' WHERE available = 1';

        }

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

        $all_languages = [];

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $all_languages[$row['dokeos_folder']] = $row;

        }

        return $all_languages;

    }

    /**

    /**

     * @return array

     */

    public static function getOfficialCodeGrouped()

    {

        $user = Database::get_main_table(TABLE_MAIN_USER);

        $sql = "SELECT DISTINCT official_code

                FROM $user

                GROUP BY official_code";

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

        $values = Database::store_result($result, 'ASSOC');

        $result = array();

        foreach ($values as $value) {

            $result[$value['official_code']] = $value['official_code'];

        }

        return $result;

    }

    /**

     * @param string $officialCode