1 |
efrain |
1 |
<?php
|
|
|
2 |
// This file is part of Moodle - http://moodle.org/
|
|
|
3 |
//
|
|
|
4 |
// Moodle is free software: you can redistribute it and/or modify
|
|
|
5 |
// it under the terms of the GNU General Public License as published by
|
|
|
6 |
// the Free Software Foundation, either version 3 of the License, or
|
|
|
7 |
// (at your option) any later version.
|
|
|
8 |
//
|
|
|
9 |
// Moodle is distributed in the hope that it will be useful,
|
|
|
10 |
// but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
|
11 |
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
|
12 |
// GNU General Public License for more details.
|
|
|
13 |
//
|
|
|
14 |
// You should have received a copy of the GNU General Public License
|
|
|
15 |
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
|
|
|
16 |
|
|
|
17 |
/**
|
|
|
18 |
* Functions used to retrieve grades objects
|
|
|
19 |
*
|
|
|
20 |
* @package core_grades
|
|
|
21 |
* @category grade
|
|
|
22 |
* @copyright 2008 Petr Skoda and Nicolas Connault
|
|
|
23 |
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
|
|
|
24 |
*/
|
|
|
25 |
|
|
|
26 |
/**
|
|
|
27 |
* Returns the aggregated or calculated course grade(s) for a single course for one or more users
|
|
|
28 |
*
|
|
|
29 |
* @param int $courseid The ID of course
|
|
|
30 |
* @param int|array $userid_or_ids Optional ID of the graded user or array of user IDs; if userid not used, returns only information about grade_item
|
|
|
31 |
* @return stdClass Returns an object containing information about course grade item. scaleid, name, grade
|
|
|
32 |
* and locked status etc and user course grades: $item->grades[$userid] => $usercoursegrade
|
|
|
33 |
*/
|
|
|
34 |
function grade_get_course_grades($courseid, $userid_or_ids=null) {
|
|
|
35 |
|
|
|
36 |
$grade_item = grade_item::fetch_course_item($courseid);
|
|
|
37 |
|
|
|
38 |
if ($grade_item->needsupdate) {
|
|
|
39 |
grade_regrade_final_grades($courseid);
|
|
|
40 |
}
|
|
|
41 |
|
|
|
42 |
$item = new stdClass();
|
|
|
43 |
$item->scaleid = $grade_item->scaleid;
|
|
|
44 |
$item->name = $grade_item->get_name();
|
|
|
45 |
$item->grademin = $grade_item->grademin;
|
|
|
46 |
$item->grademax = $grade_item->grademax;
|
|
|
47 |
$item->gradepass = $grade_item->gradepass;
|
|
|
48 |
$item->locked = $grade_item->is_locked();
|
|
|
49 |
$item->hidden = $grade_item->is_hidden();
|
|
|
50 |
$item->grades = array();
|
|
|
51 |
|
|
|
52 |
switch ($grade_item->gradetype) {
|
|
|
53 |
case GRADE_TYPE_NONE:
|
|
|
54 |
break;
|
|
|
55 |
|
|
|
56 |
case GRADE_TYPE_VALUE:
|
|
|
57 |
$item->scaleid = 0;
|
|
|
58 |
break;
|
|
|
59 |
|
|
|
60 |
case GRADE_TYPE_TEXT:
|
|
|
61 |
$item->scaleid = 0;
|
|
|
62 |
$item->grademin = 0;
|
|
|
63 |
$item->grademax = 0;
|
|
|
64 |
$item->gradepass = 0;
|
|
|
65 |
break;
|
|
|
66 |
}
|
|
|
67 |
|
|
|
68 |
if (empty($userid_or_ids)) {
|
|
|
69 |
$userids = array();
|
|
|
70 |
|
|
|
71 |
} else if (is_array($userid_or_ids)) {
|
|
|
72 |
$userids = $userid_or_ids;
|
|
|
73 |
|
|
|
74 |
} else {
|
|
|
75 |
$userids = array($userid_or_ids);
|
|
|
76 |
}
|
|
|
77 |
|
|
|
78 |
if ($userids) {
|
|
|
79 |
$grade_grades = grade_grade::fetch_users_grades($grade_item, $userids, true);
|
|
|
80 |
foreach ($userids as $userid) {
|
|
|
81 |
$grade_grades[$userid]->grade_item =& $grade_item;
|
|
|
82 |
|
|
|
83 |
$grade = new stdClass();
|
|
|
84 |
$grade->grade = $grade_grades[$userid]->finalgrade;
|
|
|
85 |
$grade->locked = $grade_grades[$userid]->is_locked();
|
|
|
86 |
$grade->hidden = $grade_grades[$userid]->is_hidden();
|
|
|
87 |
$grade->overridden = $grade_grades[$userid]->overridden;
|
|
|
88 |
$grade->feedback = $grade_grades[$userid]->feedback;
|
|
|
89 |
$grade->feedbackformat = $grade_grades[$userid]->feedbackformat;
|
|
|
90 |
$grade->usermodified = $grade_grades[$userid]->usermodified;
|
|
|
91 |
$grade->dategraded = $grade_grades[$userid]->get_dategraded();
|
|
|
92 |
$grade->datesubmitted = $grade_grades[$userid]->get_datesubmitted();
|
|
|
93 |
|
|
|
94 |
// create text representation of grade
|
|
|
95 |
if ($grade_item->needsupdate) {
|
|
|
96 |
$grade->grade = false;
|
|
|
97 |
$grade->str_grade = get_string('error');
|
|
|
98 |
$grade->str_long_grade = $grade->str_grade;
|
|
|
99 |
|
|
|
100 |
} else if (is_null($grade->grade)) {
|
|
|
101 |
$grade->str_grade = '-';
|
|
|
102 |
$grade->str_long_grade = $grade->str_grade;
|
|
|
103 |
|
|
|
104 |
} else {
|
|
|
105 |
$grade->str_grade = grade_format_gradevalue($grade->grade, $grade_item);
|
|
|
106 |
if ($grade_item->gradetype == GRADE_TYPE_SCALE or $grade_item->get_displaytype() != GRADE_DISPLAY_TYPE_REAL) {
|
|
|
107 |
$grade->str_long_grade = $grade->str_grade;
|
|
|
108 |
} else {
|
|
|
109 |
$a = new stdClass();
|
|
|
110 |
$a->grade = $grade->str_grade;
|
|
|
111 |
$a->max = grade_format_gradevalue($grade_item->grademax, $grade_item);
|
|
|
112 |
$grade->str_long_grade = get_string('gradelong', 'grades', $a);
|
|
|
113 |
}
|
|
|
114 |
}
|
|
|
115 |
|
|
|
116 |
// create html representation of feedback
|
|
|
117 |
if (is_null($grade->feedback)) {
|
|
|
118 |
$grade->str_feedback = '';
|
|
|
119 |
} else {
|
|
|
120 |
$grade->str_feedback = format_text($grade->feedback, $grade->feedbackformat);
|
|
|
121 |
}
|
|
|
122 |
|
|
|
123 |
$item->grades[$userid] = $grade;
|
|
|
124 |
}
|
|
|
125 |
}
|
|
|
126 |
|
|
|
127 |
return $item;
|
|
|
128 |
}
|
|
|
129 |
|
|
|
130 |
/**
|
|
|
131 |
* Returns the aggregated or calculated course grade for a single user for one or more courses
|
|
|
132 |
*
|
|
|
133 |
* @param int $userid The ID of the single user
|
|
|
134 |
* @param int|array $courseid_or_ids Optional ID of course or array of IDs, empty means all of the user's courses
|
|
|
135 |
* @return mixed grade info or grades array including item info, false if error
|
|
|
136 |
*/
|
|
|
137 |
function grade_get_course_grade($userid, $courseid_or_ids=null) {
|
|
|
138 |
|
|
|
139 |
if (!is_array($courseid_or_ids)) {
|
|
|
140 |
if (empty($courseid_or_ids)) {
|
|
|
141 |
if (!$courses = enrol_get_users_courses($userid)) {
|
|
|
142 |
return false;
|
|
|
143 |
}
|
|
|
144 |
$courseids = array_keys($courses);
|
|
|
145 |
return grade_get_course_grade($userid, $courseids);
|
|
|
146 |
}
|
|
|
147 |
if (!is_numeric($courseid_or_ids)) {
|
|
|
148 |
return false;
|
|
|
149 |
}
|
|
|
150 |
if (!$grades = grade_get_course_grade($userid, array($courseid_or_ids))) {
|
|
|
151 |
return false;
|
|
|
152 |
} else {
|
|
|
153 |
// only one grade - not array
|
|
|
154 |
$grade = reset($grades);
|
|
|
155 |
return $grade;
|
|
|
156 |
}
|
|
|
157 |
}
|
|
|
158 |
|
|
|
159 |
foreach ($courseid_or_ids as $courseid) {
|
|
|
160 |
$grade_item = grade_item::fetch_course_item($courseid);
|
|
|
161 |
$course_items[$grade_item->courseid] = $grade_item;
|
|
|
162 |
}
|
|
|
163 |
|
|
|
164 |
$grades = array();
|
|
|
165 |
foreach ($course_items as $grade_item) {
|
|
|
166 |
if ($grade_item->needsupdate) {
|
|
|
167 |
grade_regrade_final_grades($courseid);
|
|
|
168 |
}
|
|
|
169 |
|
|
|
170 |
$item = new stdClass();
|
|
|
171 |
$item->scaleid = $grade_item->scaleid;
|
|
|
172 |
$item->name = $grade_item->get_name();
|
|
|
173 |
$item->grademin = $grade_item->grademin;
|
|
|
174 |
$item->grademax = $grade_item->grademax;
|
|
|
175 |
$item->gradepass = $grade_item->gradepass;
|
|
|
176 |
$item->locked = $grade_item->is_locked();
|
|
|
177 |
$item->hidden = $grade_item->is_hidden();
|
|
|
178 |
|
|
|
179 |
switch ($grade_item->gradetype) {
|
|
|
180 |
case GRADE_TYPE_NONE:
|
|
|
181 |
break;
|
|
|
182 |
|
|
|
183 |
case GRADE_TYPE_VALUE:
|
|
|
184 |
$item->scaleid = 0;
|
|
|
185 |
break;
|
|
|
186 |
|
|
|
187 |
case GRADE_TYPE_TEXT:
|
|
|
188 |
$item->scaleid = 0;
|
|
|
189 |
$item->grademin = 0;
|
|
|
190 |
$item->grademax = 0;
|
|
|
191 |
$item->gradepass = 0;
|
|
|
192 |
break;
|
|
|
193 |
}
|
|
|
194 |
$grade_grade = new grade_grade(array('userid'=>$userid, 'itemid'=>$grade_item->id));
|
|
|
195 |
$grade_grade->grade_item =& $grade_item;
|
|
|
196 |
|
|
|
197 |
$grade = new stdClass();
|
|
|
198 |
$grade->grade = $grade_grade->finalgrade;
|
|
|
199 |
$grade->locked = $grade_grade->is_locked();
|
|
|
200 |
$grade->hidden = $grade_grade->is_hidden();
|
|
|
201 |
$grade->overridden = $grade_grade->overridden;
|
|
|
202 |
$grade->feedback = $grade_grade->feedback;
|
|
|
203 |
$grade->feedbackformat = $grade_grade->feedbackformat;
|
|
|
204 |
$grade->usermodified = $grade_grade->usermodified;
|
|
|
205 |
$grade->dategraded = $grade_grade->get_dategraded();
|
|
|
206 |
$grade->item = $item;
|
|
|
207 |
|
|
|
208 |
// create text representation of grade
|
|
|
209 |
if ($grade_item->needsupdate) {
|
|
|
210 |
$grade->grade = false;
|
|
|
211 |
$grade->str_grade = get_string('error');
|
|
|
212 |
$grade->str_long_grade = $grade->str_grade;
|
|
|
213 |
|
|
|
214 |
} else if (is_null($grade->grade)) {
|
|
|
215 |
$grade->str_grade = '-';
|
|
|
216 |
$grade->str_long_grade = $grade->str_grade;
|
|
|
217 |
|
|
|
218 |
} else {
|
|
|
219 |
$grade->str_grade = grade_format_gradevalue($grade->grade, $grade_item);
|
|
|
220 |
if ($grade_item->gradetype == GRADE_TYPE_SCALE or $grade_item->get_displaytype() != GRADE_DISPLAY_TYPE_REAL) {
|
|
|
221 |
$grade->str_long_grade = $grade->str_grade;
|
|
|
222 |
} else {
|
|
|
223 |
$a = new stdClass();
|
|
|
224 |
$a->grade = $grade->str_grade;
|
|
|
225 |
$a->max = grade_format_gradevalue($grade_item->grademax, $grade_item);
|
|
|
226 |
$grade->str_long_grade = get_string('gradelong', 'grades', $a);
|
|
|
227 |
}
|
|
|
228 |
}
|
|
|
229 |
|
|
|
230 |
// create html representation of feedback
|
|
|
231 |
if (is_null($grade->feedback)) {
|
|
|
232 |
$grade->str_feedback = '';
|
|
|
233 |
} else {
|
|
|
234 |
$grade->str_feedback = format_text($grade->feedback, $grade->feedbackformat);
|
|
|
235 |
}
|
|
|
236 |
|
|
|
237 |
$grades[$grade_item->courseid] = $grade;
|
|
|
238 |
}
|
|
|
239 |
|
|
|
240 |
return $grades;
|
|
|
241 |
}
|
|
|
242 |
|
|
|
243 |
/**
|
|
|
244 |
* Returns all grade items (including outcomes) or main item for a given activity identified by $cm object.
|
|
|
245 |
*
|
|
|
246 |
* @param cm_info $cm A course module object (preferably with modname property)
|
|
|
247 |
* @param bool $only_main_item Limit the search to the primary grade item for the activity, 'itemnumber'==0
|
|
|
248 |
* @return mixed An array of grade item instances, one grade item if $only_main_item == true, false if error or not found
|
|
|
249 |
*/
|
|
|
250 |
function grade_get_grade_items_for_activity($cm, $only_main_item=false) {
|
|
|
251 |
global $CFG, $DB;
|
|
|
252 |
|
|
|
253 |
if (!isset($cm->modname)) {
|
|
|
254 |
$params = array($cm->id);
|
|
|
255 |
$cm = $DB->get_record_sql("SELECT cm.*, md.name as modname
|
|
|
256 |
FROM {course_modules} cm,
|
|
|
257 |
{modules} md
|
|
|
258 |
WHERE cm.id = ? AND md.id = cm.module", $params);
|
|
|
259 |
}
|
|
|
260 |
|
|
|
261 |
|
|
|
262 |
if (empty($cm) or empty($cm->instance) or empty($cm->course)) {
|
|
|
263 |
debugging("Incorrect cm parameter in grade_get_grade_items_for_activity()!");
|
|
|
264 |
return false;
|
|
|
265 |
}
|
|
|
266 |
|
|
|
267 |
if ($only_main_item) {
|
|
|
268 |
return grade_item::fetch_all(array('itemtype'=>'mod', 'itemmodule'=>$cm->modname, 'iteminstance'=>$cm->instance, 'courseid'=>$cm->course, 'itemnumber'=>0));
|
|
|
269 |
} else {
|
|
|
270 |
return grade_item::fetch_all(array('itemtype'=>'mod', 'itemmodule'=>$cm->modname, 'iteminstance'=>$cm->instance, 'courseid'=>$cm->course));
|
|
|
271 |
}
|
|
|
272 |
}
|
|
|
273 |
|
|
|
274 |
/**
|
|
|
275 |
* Returns whether or not a user received grades in main grade item for given activity
|
|
|
276 |
*
|
|
|
277 |
* @param cm_info $cm The activity context module
|
|
|
278 |
* @param int $userid The user ID
|
|
|
279 |
* @return bool True if graded, false if user not graded yet
|
|
|
280 |
*/
|
|
|
281 |
function grade_is_user_graded_in_activity($cm, $userid) {
|
|
|
282 |
|
|
|
283 |
$grade_items = grade_get_grade_items_for_activity($cm, true);
|
|
|
284 |
if (empty($grade_items)) {
|
|
|
285 |
return false;
|
|
|
286 |
}
|
|
|
287 |
|
|
|
288 |
$grade_item = reset($grade_items);
|
|
|
289 |
|
|
|
290 |
if ($grade_item->gradetype == GRADE_TYPE_NONE) {
|
|
|
291 |
return false;
|
|
|
292 |
}
|
|
|
293 |
|
|
|
294 |
if ($grade_item->needsupdate) {
|
|
|
295 |
// activity items should never fail to regrade
|
|
|
296 |
grade_regrade_final_grades($grade_item->courseid);
|
|
|
297 |
}
|
|
|
298 |
|
|
|
299 |
if (!$grade = $grade_item->get_final($userid)) {
|
|
|
300 |
return false;
|
|
|
301 |
}
|
|
|
302 |
|
|
|
303 |
if (is_null($grade->finalgrade)) {
|
|
|
304 |
return false;
|
|
|
305 |
}
|
|
|
306 |
|
|
|
307 |
return true;
|
|
|
308 |
}
|
|
|
309 |
|
|
|
310 |
/**
|
|
|
311 |
* Returns an array of activities (defined as $cm objects) which are gradeable from gradebook, outcomes are ignored.
|
|
|
312 |
*
|
|
|
313 |
* @param int $courseid If provided then restrict to one course.
|
|
|
314 |
* @param string $modulename If defined (could be 'forum', 'assignment' etc) then only that type are returned.
|
|
|
315 |
* @return array $cm objects
|
|
|
316 |
*/
|
|
|
317 |
function grade_get_gradable_activities($courseid, $modulename='') {
|
|
|
318 |
global $CFG, $DB;
|
|
|
319 |
|
|
|
320 |
if (empty($modulename)) {
|
|
|
321 |
if (!$modules = $DB->get_records('modules', array('visible' => '1'))) {
|
|
|
322 |
return false;
|
|
|
323 |
}
|
|
|
324 |
$result = array();
|
|
|
325 |
foreach ($modules as $module) {
|
|
|
326 |
if ($cms = grade_get_gradable_activities($courseid, $module->name)) {
|
|
|
327 |
$result = $result + $cms;
|
|
|
328 |
}
|
|
|
329 |
}
|
|
|
330 |
if (empty($result)) {
|
|
|
331 |
return false;
|
|
|
332 |
} else {
|
|
|
333 |
return $result;
|
|
|
334 |
}
|
|
|
335 |
}
|
|
|
336 |
|
|
|
337 |
$params = array($courseid, $modulename, GRADE_TYPE_NONE, $modulename);
|
|
|
338 |
$sql = "SELECT cm.*, m.name, md.name as modname
|
|
|
339 |
FROM {grade_items} gi, {course_modules} cm, {modules} md, {{$modulename}} m
|
|
|
340 |
WHERE gi.courseid = ? AND
|
|
|
341 |
gi.itemtype = 'mod' AND
|
|
|
342 |
gi.itemmodule = ? AND
|
|
|
343 |
gi.itemnumber = 0 AND
|
|
|
344 |
gi.gradetype != ? AND
|
|
|
345 |
gi.iteminstance = cm.instance AND
|
|
|
346 |
cm.instance = m.id AND
|
|
|
347 |
md.name = ? AND
|
|
|
348 |
md.id = cm.module";
|
|
|
349 |
|
|
|
350 |
return $DB->get_records_sql($sql, $params);
|
|
|
351 |
}
|
|
|
352 |
|