chamilo / chamilo-lms

     *

     * @return array

     */

    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