chamilo-lms2/main/reports/modules/quiz.php

<?php

$reports_modules['quiz'] = array();


function reports_modules_quiz_init()
{
}

function reports_modules_quiz_init_forEachCourses($course_code, $course_id, $course_db)
{
    global $reports_modules;

    $reports_modules_quiz_toolid = reports_getToolId(TOOL_QUIZ);

    array_push($reports_modules['quiz'],
        array(
            'keys_query' =>
                'select '.$course_id.' as course_id, '.
                $reports_modules_quiz_toolid.' as tool_id, '.
                'q.id as child_id, q.title as child_name, '.
                "'".$course_code."'".' as course_code from '.Database::get_course_table(TABLE_QUIZ_TEST).' q ',
            'values_query_function' => 'reports_modules_quiz_quizVal'
        ));
}

function reports_modules_quiz_quizVal($quiz, $key_id)
{
    $courseId = api_get_course_int_id($quiz['course_code']);
    return array(
        'type' => 'sql',
        'sql' =>
            'select '.$key_id.', exe_user_id as uid, '.
            'session_id, -1 as attempt, exe_result as score, '.
            REPORTS_PROGRESS_COMPLETED.' as progress, '.
            'exe_duration as time, exe_date as ts from '.
            Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES).
            ' where c_id = '.$courseId.
            ' and exe_exo_id='.$quiz['child_id']
    );
}