Moodle 3.2.4+ (Build 20170714)
I have a custom php report that produces an Excel spreadsheet. It extracts data from Moodle, but the final grade shows as a raw score rather than a percentage. What changes to the code (below) do I need to make to show percentage grades?
$sql = "SELECT
ue.timestart AS enrolmentstartdate,
ue.userid AS user_id,
user.*,
ud_site.data AS user_site,
en.enrol AS enrol_method,
en.cost AS enrol_cost,
course.id AS course_id,
course.fullname AS course_fullname,
course.shortname AS course_shortname,
category.name AS course_category,
tag.name AS course_tag,
gg.finalgrade AS course_finalgrade
FROM {user_enrolments} AS ue
JOIN {user} AS user ON ue.userid = user.id
JOIN {user_info_data} AS ud_site ON ud_site.userid = user.id
JOIN {user_info_field} AS uf_site ON uf_site.id = ud_site.fieldid AND uf_site.shortname = 'site'
JOIN {enrol} AS en ON ue.enrolid = en.id
JOIN {course} AS course ON en.courseid = course.id
JOIN {course_categories} AS category ON course.category = category.id
LEFT JOIN {tag_instance} AS ti ON course.id = ti.itemid
LEFT JOIN {tag} AS tag ON ti.tagid = tag.id
JOIN {grade_items} AS gi ON en.courseid = gi.courseid AND gi.itemtype = 'course'
LEFT JOIN {grade_grades} AS gg ON gg.itemid = gi.id AND ue.userid = gg.userid
WHERE user.id != 0 ";
Output to Spreadsheet
$row[] = round($record->course_finalgrade,0); //Final Result