chamilo / chamilo-lms

     *

     * @return array

     */

    public static function getChildren($categoryCode)

    {

        $tbl_category = Database::get_main_table(TABLE_MAIN_CATEGORY);

        $categoryCode = Database::escape_string($categoryCode);

        $result = Database::query("SELECT code, id FROM $tbl_category WHERE parent_id = '$categoryCode'");

        $children = array();

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

            $children[] = $row;

            $subChildren = self::getChildren($row['code']);

            $children = array_merge($children, $subChildren);

        }

        return $children;

    }

    /**

     * @param string $categoryCode

     * @param    int        Session id

     * @return    array    Courses list

     */

    public static function get_courses_list_from_session($session_id)

    {

        $session_id = intval($session_id);

        // table definition

        $tbl_session_course = Database :: get_main_table(TABLE_MAIN_SESSION_COURSE);

        $courseTable = Database :: get_main_table(TABLE_MAIN_COURSE);

        $sql = "SELECT DISTINCT code, c_id

                FROM $tbl_session_course sc

                INNER JOIN $courseTable c

                ON sc.c_id = c.id

                WHERE session_id= $session_id";

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

        $courses = array();

        while ($row = Database::fetch_array($result)) {

            $courses[$row['code']] = $row;

        }

        return $courses;

    }

    /**

     * Count the number of documents that an user has uploaded to a course

     * @param string $lastname Lastname to search

     * @return array The user list

     */

    public static function getUserByName($firstname, $lastname)

    {

        $firstname = Database::escape_string($firstname);

        $lastname = Database::escape_string($lastname);

        $userTable = Database::get_main_table(TABLE_MAIN_USER);

        $sql = <<<SQL

            SELECT id, username, lastname, firstname

            FROM $userTable

            WHERE firstname LIKE '$firstname%' AND

                lastname LIKE '$lastname%'

SQL;

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

        $users = [];

        while ($resultData = Database::fetch_object($result)) {

            $users[] = $resultData;

        }

        return $users;

    }

    /**

     * @param int $optionSelected

 * @author Julio Montoya <[email protected]>

 * @return int user id

 */

function api_get_access_url_from_user($user_id) {

    $user_id = intval($user_id);

    $table_url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

    $table_url          = Database :: get_main_table(TABLE_MAIN_ACCESS_URL);

    $sql = "SELECT access_url_id

            FROM $table_url_rel_user url_rel_user

            INNER JOIN $table_url u

            ON (url_rel_user.access_url_id = u.id)

            WHERE user_id = ".intval($user_id);

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

    $url_list = array();

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

        $url_list[] = $row['access_url_id'];

    }

    return $url_list;

}

/**

 * Gets the status of a user in a course