From 28bcbc3868c0cecb4176519136610cd96511e91c Mon Sep 17 00:00:00 2001 From: skodak Date: Sat, 27 Oct 2007 22:05:58 +0000 Subject: [PATCH] added groups param to get_numusers() - to be used in oureport; might be handy elsewhere too --- grade/report/lib.php | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) diff --git a/grade/report/lib.php b/grade/report/lib.php index a6db267b7a..1db95fee91 100755 --- a/grade/report/lib.php +++ b/grade/report/lib.php @@ -284,18 +284,26 @@ class grade_report { /** * Fetches and returns a count of all the users that will be shown on this page. + * @param boolean $groups include groups limit * @return int Count of users */ - function get_numusers() { + function get_numusers($groups=true) { global $CFG; + $groupsql = ""; + $groupwheresql = ""; + if ($groups) { + $groupsql = $this->groupsql; + $groupwheresql = $this->groupsqlwhere; + } + $countsql = "SELECT COUNT(DISTINCT u.id) FROM {$CFG->prefix}grade_grades g RIGHT OUTER JOIN {$CFG->prefix}user u ON u.id = g.userid LEFT JOIN {$CFG->prefix}role_assignments ra ON u.id = ra.userid - $this->groupsql + $groupsql WHERE ra.roleid in ($this->gradebookroles) - $this->groupwheresql + $groupwheresql AND ra.contextid ".get_related_contexts_string($this->context); return count_records_sql($countsql); } -- 2.39.5