chamilo / chamilo-lms

 * @param int $ref_id representative id inside one tool item

 * @return array

 */

function get_specific_field_values_list_by_prefix(

    $prefix,

    $course_code,

    $tool_id,

    $ref_id

) {

    $table_sf = Database::get_main_table(TABLE_MAIN_SPECIFIC_FIELD);

    $table_sfv = Database::get_main_table(TABLE_MAIN_SPECIFIC_FIELD_VALUES);

    $sql = 'SELECT sfv.value FROM %s sf LEFT JOIN %s sfv ON sf.id = sfv.field_id'.

        ' WHERE sf.code = \'%s\' AND sfv.c_id = \'%s\' AND tool_id = \'%s\' AND sfv.ref_id = %s';

    $sql = sprintf(

        $sql,

        $table_sf,

        $table_sfv,

        $prefix,

        $course_code,

        $tool_id,

        $ref_id

    );

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

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

        $return_array[] = $result;

    }

    return $return_array;

}

/**

 * Add a specific field value

     *

     * @return array

     */

    public static function getLatestHotPotatoResult(

        $exercisePath,

        $userId,

        $courseId,

        $sessionId

    ) {

        $table = Database::get_main_table(

            TABLE_STATISTIC_TRACK_E_HOTPOTATOES

        );

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

        $userId = intval($userId);

        $sql = "SELECT * FROM $table

            WHERE

                c_id = $courseId AND

                exe_name LIKE '$exercisePath%' AND

                exe_user_id = $userId

            ORDER BY id

            LIMIT 1";

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

        $attempt = array();

        if (Database::num_rows($result)) {

            $attempt = Database::fetch_array($result, 'ASSOC');

        }

        return $attempt;

    }

    /**

     * Gets the exam'data results

     * @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