From a1e26b5e46184c8621a079a3e3b5d983119e9ae1 Mon Sep 17 00:00:00 2001 From: Sam Hemelryk Date: Tue, 18 Jan 2011 17:17:14 +0800 Subject: [PATCH] gradebook MDL-20617 Fixed SQL formatting --- grade/report/user/lib.php | 18 ++++++++++++------ 1 file changed, 12 insertions(+), 6 deletions(-) diff --git a/grade/report/user/lib.php b/grade/report/user/lib.php index fc0b31a0edf..6d66a6e31e3 100644 --- a/grade/report/user/lib.php +++ b/grade/report/user/lib.php @@ -618,9 +618,12 @@ class grade_report_user extends grade_report { // find sums of all grade items in course $sql = "SELECT gg.itemid, SUM(gg.finalgrade) AS sum FROM {grade_items} gi - JOIN {grade_grades} gg ON gg.itemid = gi.id - JOIN ($enrolledsql) je ON je.id = gg.userid - JOIN {role_assignments} ra ON ra.userid = gg.userid + JOIN {grade_grades} gg + ON gg.itemid = gi.id + JOIN ($enrolledsql) je + ON je.id = gg.userid + JOIN {role_assignments} ra + ON ra.userid = gg.userid $groupsql WHERE gi.courseid = :courseid AND ra.roleid $gradebookrolessql @@ -647,9 +650,12 @@ class grade_report_user extends grade_report { $sql = "SELECT gi.id, COUNT(u.id) AS count FROM {grade_items} gi JOIN {user} u - JOIN ($enrolledsql) je ON je.id = u.id - JOIN {role_assignments} ra ON ra.userid = u.id - LEFT JOIN {grade_grades} gg ON (gg.itemid = gi.id AND gg.userid = u.id AND gg.finalgrade IS NOT NULL AND gg.hidden = 0) + JOIN ($enrolledsql) je + ON je.id = u.id + JOIN {role_assignments} ra + ON ra.userid = u.id + LEFT JOIN {grade_grades} gg + ON (gg.itemid = gi.id AND gg.userid = u.id AND gg.finalgrade IS NOT NULL AND gg.hidden = 0) $groupsql WHERE gi.courseid = :courseid AND ra.roleid $gradebookrolessql -- 2.43.0