2 // This file is part of Moodle - http://moodle.org/
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.
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.
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/>.
18 * This file contains the definition for the class assignment
20 * This class provides all the functionality for the new assign module.
23 * @copyright 2012 NetSpot {@link http://www.netspot.com.au}
24 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
27 defined('MOODLE_INTERNAL') || die();
30 * Assignment submission statuses
32 define('ASSIGN_SUBMISSION_STATUS_DRAFT', 'draft'); // student thinks it is a draft
33 define('ASSIGN_SUBMISSION_STATUS_SUBMITTED', 'submitted'); // student thinks it is finished
36 * Search filters for grading page
38 define('ASSIGN_FILTER_SUBMITTED', 'submitted');
39 define('ASSIGN_FILTER_SINGLE_USER', 'singleuser');
40 define('ASSIGN_FILTER_REQUIRE_GRADING', 'require_grading');
42 /** Include accesslib.php */
43 require_once($CFG->libdir.'/accesslib.php');
44 /** Include formslib.php */
45 require_once($CFG->libdir.'/formslib.php');
46 /** Include repository/lib.php */
47 require_once($CFG->dirroot . '/repository/lib.php');
48 /** Include local mod_form.php */
49 require_once($CFG->dirroot.'/mod/assign/mod_form.php');
51 require_once($CFG->libdir.'/gradelib.php');
52 /** grading lib.php */
53 require_once($CFG->dirroot.'/grade/grading/lib.php');
54 /** Include feedbackplugin.php */
55 require_once($CFG->dirroot.'/mod/assign/feedbackplugin.php');
56 /** Include submissionplugin.php */
57 require_once($CFG->dirroot.'/mod/assign/submissionplugin.php');
58 /** Include renderable.php */
59 require_once($CFG->dirroot.'/mod/assign/renderable.php');
60 /** Include gradingtable.php */
61 require_once($CFG->dirroot.'/mod/assign/gradingtable.php');
62 /** Include eventslib.php */
63 require_once($CFG->libdir.'/eventslib.php');
67 * Standard base class for mod_assign (assignment types).
70 * @copyright 2012 NetSpot {@link http://www.netspot.com.au}
71 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
76 /** @var stdClass the assignment record that contains the global settings for this assign instance */
79 /** @var context the context of the course module for this assign instance (or just the course if we are
80 creating a new one) */
83 /** @var stdClass the course this assign instance belongs to */
86 /** @var stdClass the admin config for all assign instances */
90 /** @var assign_renderer the custom renderer for this module */
93 /** @var stdClass the course module for this assign instance */
94 private $coursemodule;
96 /** @var array cache for things like the coursemodule name or the scale menu - only lives for a single
100 /** @var array list of the installed submission plugins */
101 private $submissionplugins;
103 /** @var array list of the installed feedback plugins */
104 private $feedbackplugins;
106 /** @var string action to be used to return to this page (without repeating any form submissions etc.) */
107 private $returnaction = 'view';
109 /** @var array params to be used to return to this page */
110 private $returnparams = array();
112 /** @var string modulename prevents excessive calls to get_string */
113 private static $modulename = null;
115 /** @var string modulenameplural prevents excessive calls to get_string */
116 private static $modulenameplural = null;
119 * Constructor for the base assign class
121 * @param mixed $coursemodulecontext context|null the course module context (or the course context if the coursemodule has not been created yet)
122 * @param mixed $coursemodule the current course module if it was already loaded - otherwise this class will load one from the context as required
123 * @param mixed $course the current course if it was already loaded - otherwise this class will load one from the context as required
125 public function __construct($coursemodulecontext, $coursemodule, $course) {
128 $this->context = $coursemodulecontext;
129 $this->coursemodule = $coursemodule;
130 $this->course = $course;
131 $this->cache = array(); // temporary cache only lives for a single request - used to reduce db lookups
133 $this->submissionplugins = $this->load_plugins('assignsubmission');
134 $this->feedbackplugins = $this->load_plugins('assignfeedback');
135 $this->output = $PAGE->get_renderer('mod_assign');
139 * Set the action and parameters that can be used to return to the current page
141 * @param string $action The action for the current page
142 * @param array $params An array of name value pairs which form the parameters to return to the current page
145 public function register_return_link($action, $params) {
146 $this->returnaction = $action;
147 $this->returnparams = $params;
151 * Return an action that can be used to get back to the current page
152 * @return string action
154 public function get_return_action() {
155 return $this->returnaction;
159 * Based on the current assignment settings should we display the intro
160 * @return bool showintro
162 private function show_intro() {
163 if ($this->get_instance()->alwaysshowdescription ||
164 time() > $this->get_instance()->allowsubmissionsfromdate) {
171 * Return a list of parameters that can be used to get back to the current page
172 * @return array params
174 public function get_return_params() {
175 return $this->returnparams;
179 * Set the submitted form data
180 * @param stdClass $data The form data (instance)
182 public function set_instance(stdClass $data) {
183 $this->instance = $data;
188 * @param context $context The new context
190 public function set_context(context $context) {
191 $this->context = $context;
195 * Set the course data
196 * @param stdClass $course The course data
198 public function set_course(stdClass $course) {
199 $this->course = $course;
203 * get list of feedback plugins installed
206 public function get_feedback_plugins() {
207 return $this->feedbackplugins;
211 * get list of submission plugins installed
214 public function get_submission_plugins() {
215 return $this->submissionplugins;
220 * get a specific submission plugin by its type
221 * @param string $subtype assignsubmission | assignfeedback
222 * @param string $type
223 * @return mixed assign_plugin|null
225 private function get_plugin_by_type($subtype, $type) {
226 $shortsubtype = substr($subtype, strlen('assign'));
227 $name = $shortsubtype . 'plugins';
228 $pluginlist = $this->$name;
229 foreach ($pluginlist as $plugin) {
230 if ($plugin->get_type() == $type) {
238 * Get a feedback plugin by type
239 * @param string $type - The type of plugin e.g comments
240 * @return mixed assign_feedback_plugin|null
242 public function get_feedback_plugin_by_type($type) {
243 return $this->get_plugin_by_type('assignfeedback', $type);
247 * Get a submission plugin by type
248 * @param string $type - The type of plugin e.g comments
249 * @return mixed assign_submission_plugin|null
251 public function get_submission_plugin_by_type($type) {
252 return $this->get_plugin_by_type('assignsubmission', $type);
256 * Load the plugins from the sub folders under subtype
257 * @param string $subtype - either submission or feedback
258 * @return array - The sorted list of plugins
260 private function load_plugins($subtype) {
264 $names = get_plugin_list($subtype);
266 foreach ($names as $name => $path) {
267 if (file_exists($path . '/locallib.php')) {
268 require_once($path . '/locallib.php');
270 $shortsubtype = substr($subtype, strlen('assign'));
271 $pluginclass = 'assign_' . $shortsubtype . '_' . $name;
273 $plugin = new $pluginclass($this, $name);
275 if ($plugin instanceof assign_plugin) {
276 $idx = $plugin->get_sort_order();
277 while (array_key_exists($idx, $result)) $idx +=1;
278 $result[$idx] = $plugin;
288 * Display the assignment, used by view.php
290 * The assignment is displayed differently depending on your role,
291 * the settings for the assignment and the status of the assignment.
292 * @param string $action The current action if any.
295 public function view($action='') {
300 // handle form submissions first
301 if ($action == 'savesubmission') {
302 $action = 'editsubmission';
303 if ($this->process_save_submission($mform)) {
306 } else if ($action == 'lock') {
307 $this->process_lock();
309 } else if ($action == 'reverttodraft') {
310 $this->process_revert_to_draft();
312 } else if ($action == 'unlock') {
313 $this->process_unlock();
315 } else if ($action == 'confirmsubmit') {
316 $this->process_submit_for_grading();
317 // save and show next button
318 } else if ($action == 'batchgradingoperation') {
319 $this->process_batch_grading_operation();
321 } else if ($action == 'submitgrade') {
322 if (optional_param('saveandshownext', null, PARAM_ALPHA)) {
325 if ($this->process_save_grade($mform)) {
326 $action = 'nextgrade';
328 } else if (optional_param('nosaveandprevious', null, PARAM_ALPHA)) {
329 $action = 'previousgrade';
330 } else if (optional_param('nosaveandnext', null, PARAM_ALPHA)) {
332 $action = 'nextgrade';
333 } else if (optional_param('savegrade', null, PARAM_ALPHA)) {
334 //save changes button
336 if ($this->process_save_grade($mform)) {
343 }else if ($action == 'quickgrade') {
344 $message = $this->process_save_quick_grades();
345 $action = 'quickgradingresult';
346 }else if ($action == 'saveoptions') {
347 $this->process_save_grading_options();
351 $returnparams = array('rownum'=>optional_param('rownum', 0, PARAM_INT));
352 $this->register_return_link($action, $returnparams);
354 // now show the right view page
355 if ($action == 'previousgrade') {
357 $o .= $this->view_single_grade_page($mform, -1);
358 } else if ($action == 'quickgradingresult') {
360 $o .= $this->view_quickgrading_result($message);
361 } else if ($action == 'nextgrade') {
363 $o .= $this->view_single_grade_page($mform, 1);
364 } else if ($action == 'grade') {
365 $o .= $this->view_single_grade_page($mform);
366 } else if ($action == 'viewpluginassignfeedback') {
367 $o .= $this->view_plugin_content('assignfeedback');
368 } else if ($action == 'viewpluginassignsubmission') {
369 $o .= $this->view_plugin_content('assignsubmission');
370 } else if ($action == 'editsubmission') {
371 $o .= $this->view_edit_submission_page($mform);
372 } else if ($action == 'grading') {
373 $o .= $this->view_grading_page();
374 } else if ($action == 'downloadall') {
375 $o .= $this->download_submissions();
376 } else if ($action == 'submit') {
377 $o .= $this->check_submit_for_grading();
379 $o .= $this->view_submission_page();
387 * Add this instance to the database
389 * @param stdClass $formdata The data submitted from the form
390 * @param bool $callplugins This is used to skip the plugin code
391 * when upgrading an old assignment to a new one (the plugins get called manually)
392 * @return mixed false if an error occurs or the int id of the new instance
394 public function add_instance(stdClass $formdata, $callplugins) {
399 // add the database record
400 $update = new stdClass();
401 $update->name = $formdata->name;
402 $update->timemodified = time();
403 $update->timecreated = time();
404 $update->course = $formdata->course;
405 $update->courseid = $formdata->course;
406 $update->intro = $formdata->intro;
407 $update->introformat = $formdata->introformat;
408 $update->alwaysshowdescription = $formdata->alwaysshowdescription;
409 $update->preventlatesubmissions = $formdata->preventlatesubmissions;
410 $update->submissiondrafts = $formdata->submissiondrafts;
411 $update->sendnotifications = $formdata->sendnotifications;
412 $update->sendlatenotifications = $formdata->sendlatenotifications;
413 $update->duedate = $formdata->duedate;
414 $update->allowsubmissionsfromdate = $formdata->allowsubmissionsfromdate;
415 $update->grade = $formdata->grade;
416 $returnid = $DB->insert_record('assign', $update);
417 $this->instance = $DB->get_record('assign', array('id'=>$returnid), '*', MUST_EXIST);
418 // cache the course record
419 $this->course = $DB->get_record('course', array('id'=>$formdata->course), '*', MUST_EXIST);
422 // call save_settings hook for submission plugins
423 foreach ($this->submissionplugins as $plugin) {
424 if (!$this->update_plugin_instance($plugin, $formdata)) {
425 print_error($plugin->get_error());
429 foreach ($this->feedbackplugins as $plugin) {
430 if (!$this->update_plugin_instance($plugin, $formdata)) {
431 print_error($plugin->get_error());
436 // in the case of upgrades the coursemodule has not been set so we need to wait before calling these two
437 // TODO: add event to the calendar
438 $this->update_calendar($formdata->coursemodule);
439 // TODO: add the item in the gradebook
440 $this->update_gradebook(false, $formdata->coursemodule);
444 $update = new stdClass();
445 $update->id = $this->get_instance()->id;
446 $update->nosubmissions = (!$this->is_any_submission_plugin_enabled()) ? 1: 0;
447 $DB->update_record('assign', $update);
453 * Delete all grades from the gradebook for this assignment
457 private function delete_grades() {
460 return grade_update('mod/assign', $this->get_course()->id, 'mod', 'assign', $this->get_instance()->id, 0, NULL, array('deleted'=>1)) == GRADE_UPDATE_OK;
464 * Delete this instance from the database
466 * @return bool false if an error occurs
468 public function delete_instance() {
472 foreach ($this->submissionplugins as $plugin) {
473 if (!$plugin->delete_instance()) {
474 print_error($plugin->get_error());
478 foreach ($this->feedbackplugins as $plugin) {
479 if (!$plugin->delete_instance()) {
480 print_error($plugin->get_error());
485 // delete files associated with this assignment
486 $fs = get_file_storage();
487 if (! $fs->delete_area_files($this->context->id) ) {
491 // delete_records will throw an exception if it fails - so no need for error checking here
493 $DB->delete_records('assign_submission', array('assignment'=>$this->get_instance()->id));
494 $DB->delete_records('assign_grades', array('assignment'=>$this->get_instance()->id));
495 $DB->delete_records('assign_plugin_config', array('assignment'=>$this->get_instance()->id));
497 // delete items from the gradebook
498 if (! $this->delete_grades()) {
502 // delete the instance
503 $DB->delete_records('assign', array('id'=>$this->get_instance()->id));
509 * Update the settings for a single plugin
511 * @param assign_plugin $plugin The plugin to update
512 * @param stdClass $formdata The form data
513 * @return bool false if an error occurs
515 private function update_plugin_instance(assign_plugin $plugin, stdClass $formdata) {
516 if ($plugin->is_visible()) {
517 $enabledname = $plugin->get_subtype() . '_' . $plugin->get_type() . '_enabled';
518 if ($formdata->$enabledname) {
520 if (!$plugin->save_settings($formdata)) {
521 print_error($plugin->get_error());
532 * Update the gradebook information for this assignment
534 * @param bool $reset If true, will reset all grades in the gradbook for this assignment
535 * @param int $coursemoduleid This is required because it might not exist in the database yet
538 public function update_gradebook($reset, $coursemoduleid) {
540 /** Include lib.php */
541 require_once($CFG->dirroot.'/mod/assign/lib.php');
542 $assign = clone $this->get_instance();
543 $assign->cmidnumber = $coursemoduleid;
549 return assign_grade_item_update($assign, $param);
552 /** Load and cache the admin config for this module
554 * @return stdClass the plugin config
556 public function get_admin_config() {
557 if ($this->adminconfig) {
558 return $this->adminconfig;
560 $this->adminconfig = get_config('assign');
561 return $this->adminconfig;
566 * Update the calendar entries for this assignment
568 * @param int $coursemoduleid - Required to pass this in because it might not exist in the database yet
571 public function update_calendar($coursemoduleid) {
573 require_once($CFG->dirroot.'/calendar/lib.php');
575 // special case for add_instance as the coursemodule has not been set yet.
577 if ($this->get_instance()->duedate) {
578 $event = new stdClass();
580 if ($event->id = $DB->get_field('event', 'id', array('modulename'=>'assign', 'instance'=>$this->get_instance()->id))) {
582 $event->name = $this->get_instance()->name;
584 $event->description = format_module_intro('assign', $this->get_instance(), $coursemoduleid);
585 $event->timestart = $this->get_instance()->duedate;
587 $calendarevent = calendar_event::load($event->id);
588 $calendarevent->update($event);
590 $event = new stdClass();
591 $event->name = $this->get_instance()->name;
592 $event->description = format_module_intro('assign', $this->get_instance(), $coursemoduleid);
593 $event->courseid = $this->get_instance()->course;
596 $event->modulename = 'assign';
597 $event->instance = $this->get_instance()->id;
598 $event->eventtype = 'due';
599 $event->timestart = $this->get_instance()->duedate;
600 $event->timeduration = 0;
602 calendar_event::create($event);
605 $DB->delete_records('event', array('modulename'=>'assign', 'instance'=>$this->get_instance()->id));
611 * Update this instance in the database
613 * @param stdClass $formdata - the data submitted from the form
614 * @return bool false if an error occurs
616 public function update_instance($formdata) {
619 $update = new stdClass();
620 $update->id = $formdata->instance;
621 $update->name = $formdata->name;
622 $update->timemodified = time();
623 $update->course = $formdata->course;
624 $update->intro = $formdata->intro;
625 $update->introformat = $formdata->introformat;
626 $update->alwaysshowdescription = $formdata->alwaysshowdescription;
627 $update->preventlatesubmissions = $formdata->preventlatesubmissions;
628 $update->submissiondrafts = $formdata->submissiondrafts;
629 $update->sendnotifications = $formdata->sendnotifications;
630 $update->sendlatenotifications = $formdata->sendlatenotifications;
631 $update->duedate = $formdata->duedate;
632 $update->allowsubmissionsfromdate = $formdata->allowsubmissionsfromdate;
633 $update->grade = $formdata->grade;
635 $result = $DB->update_record('assign', $update);
636 $this->instance = $DB->get_record('assign', array('id'=>$update->id), '*', MUST_EXIST);
638 // load the assignment so the plugins have access to it
640 // call save_settings hook for submission plugins
641 foreach ($this->submissionplugins as $plugin) {
642 if (!$this->update_plugin_instance($plugin, $formdata)) {
643 print_error($plugin->get_error());
647 foreach ($this->feedbackplugins as $plugin) {
648 if (!$this->update_plugin_instance($plugin, $formdata)) {
649 print_error($plugin->get_error());
655 // update the database record
658 // update all the calendar events
659 $this->update_calendar($this->get_course_module()->id);
661 $this->update_gradebook(false, $this->get_course_module()->id);
663 $update = new stdClass();
664 $update->id = $this->get_instance()->id;
665 $update->nosubmissions = (!$this->is_any_submission_plugin_enabled()) ? 1: 0;
666 $DB->update_record('assign', $update);
676 * add elements in grading plugin form
678 * @param mixed $grade stdClass|null
679 * @param MoodleQuickForm $mform
680 * @param stdClass $data
683 private function add_plugin_grade_elements($grade, MoodleQuickForm $mform, stdClass $data) {
684 foreach ($this->feedbackplugins as $plugin) {
685 if ($plugin->is_enabled() && $plugin->is_visible()) {
686 $mform->addElement('header', 'header_' . $plugin->get_type(), $plugin->get_name());
687 if (!$plugin->get_form_elements($grade, $mform, $data)) {
688 $mform->removeElement('header_' . $plugin->get_type());
697 * Add one plugins settings to edit plugin form
699 * @param assign_plugin $plugin The plugin to add the settings from
700 * @param MoodleQuickForm $mform The form to add the configuration settings to. This form is modified directly (not returned)
703 private function add_plugin_settings(assign_plugin $plugin, MoodleQuickForm $mform) {
705 if ($plugin->is_visible()) {
707 //tied disableIf rule to this select element
708 $mform->addElement('selectyesno', $plugin->get_subtype() . '_' . $plugin->get_type() . '_enabled', $plugin->get_name());
709 $mform->addHelpButton($plugin->get_subtype() . '_' . $plugin->get_type() . '_enabled', 'enabled', $plugin->get_subtype() . '_' . $plugin->get_type());
712 $default = get_config($plugin->get_subtype() . '_' . $plugin->get_type(), 'default');
713 if ($plugin->get_config('enabled') !== false) {
714 $default = $plugin->is_enabled();
716 $mform->setDefault($plugin->get_subtype() . '_' . $plugin->get_type() . '_enabled', $default);
718 $plugin->get_settings($mform);
726 * Add settings to edit plugin form
728 * @param MoodleQuickForm $mform The form to add the configuration settings to. This form is modified directly (not returned)
731 public function add_all_plugin_settings(MoodleQuickForm $mform) {
732 $mform->addElement('header', 'general', get_string('submissionsettings', 'assign'));
734 foreach ($this->submissionplugins as $plugin) {
735 $this->add_plugin_settings($plugin, $mform);
738 $mform->addElement('header', 'general', get_string('feedbacksettings', 'assign'));
739 foreach ($this->feedbackplugins as $plugin) {
740 $this->add_plugin_settings($plugin, $mform);
745 * Allow each plugin an opportunity to update the defaultvalues
746 * passed in to the settings form (needed to set up draft areas for
747 * editor and filemanager elements)
748 * @param array $defaultvalues
750 public function plugin_data_preprocessing(&$defaultvalues) {
751 foreach ($this->submissionplugins as $plugin) {
752 if ($plugin->is_visible()) {
753 $plugin->data_preprocessing($defaultvalues);
756 foreach ($this->feedbackplugins as $plugin) {
757 if ($plugin->is_visible()) {
758 $plugin->data_preprocessing($defaultvalues);
764 * Get the name of the current module.
766 * @return string the module name (Assignment)
768 protected function get_module_name() {
769 if (isset(self::$modulename)) {
770 return self::$modulename;
772 self::$modulename = get_string('modulename', 'assign');
773 return self::$modulename;
777 * Get the plural name of the current module.
779 * @return string the module name plural (Assignments)
781 protected function get_module_name_plural() {
782 if (isset(self::$modulenameplural)) {
783 return self::$modulenameplural;
785 self::$modulenameplural = get_string('modulenameplural', 'assign');
786 return self::$modulenameplural;
790 * Has this assignment been constructed from an instance?
794 public function has_instance() {
795 return $this->instance || $this->get_course_module();
799 * Get the settings for the current instance of this assignment
801 * @return stdClass The settings
803 public function get_instance() {
805 if ($this->instance) {
806 return $this->instance;
808 if ($this->get_course_module()) {
809 $this->instance = $DB->get_record('assign', array('id' => $this->get_course_module()->instance), '*', MUST_EXIST);
811 if (!$this->instance) {
812 throw new coding_exception('Improper use of the assignment class. Cannot load the assignment record.');
814 return $this->instance;
818 * Get the context of the current course
819 * @return mixed context|null The course context
821 public function get_course_context() {
822 if (!$this->context && !$this->course) {
823 throw new coding_exception('Improper use of the assignment class. Cannot load the course context.');
825 if ($this->context) {
826 return $this->context->get_course_context();
828 return context_course::instance($this->course->id);
834 * Get the current course module
836 * @return mixed stdClass|null The course module
838 public function get_course_module() {
839 if ($this->coursemodule) {
840 return $this->coursemodule;
842 if (!$this->context) {
846 if ($this->context->contextlevel == CONTEXT_MODULE) {
847 $this->coursemodule = get_coursemodule_from_id('assign', $this->context->instanceid, 0, false, MUST_EXIST);
848 return $this->coursemodule;
858 public function get_context() {
859 return $this->context;
863 * Get the current course
864 * @return mixed stdClass|null The course
866 public function get_course() {
869 return $this->course;
872 if (!$this->context) {
875 $this->course = $DB->get_record('course', array('id' => $this->get_course_context()->instanceid), '*', MUST_EXIST);
876 return $this->course;
880 * Return a grade in user-friendly form, whether it's a scale or not
882 * @param mixed $grade int|null
883 * @param boolean $editing Are we allowing changes to this grade?
884 * @param int $userid The user id the grade belongs to
885 * @param int $modified Timestamp from when the grade was last modified
886 * @return string User-friendly representation of grade
888 public function display_grade($grade, $editing, $userid=0, $modified=0) {
891 static $scalegrades = array();
893 if ($this->get_instance()->grade >= 0) {
895 if ($editing && $this->get_instance()->grade > 0) {
899 $displaygrade = format_float($grade);
901 $o = '<input type="text" name="quickgrade_' . $userid . '" value="' . $displaygrade . '" size="6" maxlength="10" class="quickgrade"/>';
902 $o .= ' / ' . format_float($this->get_instance()->grade,2);
903 $o .= '<input type="hidden" name="grademodified_' . $userid . '" value="' . $modified . '"/>';
906 if ($grade == -1 || $grade === null) {
909 return format_float(($grade),2) .' / '. format_float($this->get_instance()->grade,2);
915 if (empty($this->cache['scale'])) {
916 if ($scale = $DB->get_record('scale', array('id'=>-($this->get_instance()->grade)))) {
917 $this->cache['scale'] = make_menu_from_list($scale->scale);
923 $o = '<select name="quickgrade_' . $userid . '" class="quickgrade">';
924 $o .= '<option value="-1">' . get_string('nograde') . '</option>';
925 foreach ($this->cache['scale'] as $optionid => $option) {
927 if ($grade == $optionid) {
928 $selected = 'selected="selected"';
930 $o .= '<option value="' . $optionid . '" ' . $selected . '>' . $option . '</option>';
933 $o .= '<input type="hidden" name="grademodified_' . $userid . '" value="' . $modified . '"/>';
936 $scaleid = (int)$grade;
937 if (isset($this->cache['scale'][$scaleid])) {
938 return $this->cache['scale'][$scaleid];
946 * Load a list of users enrolled in the current course with the specified permission and group (0 for no group)
948 * @param int $currentgroup
949 * @param bool $idsonly
950 * @return array List of user records
952 public function list_participants($currentgroup, $idsonly) {
954 return get_enrolled_users($this->context, "mod/assign:submit", $currentgroup, 'u.id');
956 return get_enrolled_users($this->context, "mod/assign:submit", $currentgroup);
961 * Load a count of users enrolled in the current course with the specified permission and group (0 for no group)
963 * @param int $currentgroup
964 * @return int number of matching users
966 public function count_participants($currentgroup) {
967 return count_enrolled_users($this->context, "mod/assign:submit", $currentgroup);
971 * Load a count of users submissions in the current module that require grading
972 * This means the submission modification time is more recent than the
973 * grading modification time.
975 * @return int number of matching submissions
977 public function count_submissions_need_grading() {
980 $params = array($this->get_course_module()->instance);
982 return $DB->count_records_sql("SELECT COUNT('x')
983 FROM {assign_submission} s
984 LEFT JOIN {assign_grades} g ON s.assignment = g.assignment AND s.userid = g.userid
985 WHERE s.assignment = ?
986 AND s.timemodified IS NOT NULL
987 AND (s.timemodified > g.timemodified OR g.timemodified IS NULL)",
992 * Load a count of users enrolled in the current course with the specified permission and group (optional)
994 * @param string $status The submission status - should match one of the constants
995 * @return int number of matching submissions
997 public function count_submissions_with_status($status) {
999 return $DB->count_records_sql("SELECT COUNT('x')
1000 FROM {assign_submission}
1001 WHERE assignment = ? AND
1002 status = ?", array($this->get_course_module()->instance, $status));
1006 * Utility function to get the userid for every row in the grading table
1007 * so the order can be frozen while we iterate it
1009 * @return array An array of userids
1011 private function get_grading_userid_list(){
1012 $filter = get_user_preferences('assign_filter', '');
1013 $table = new assign_grading_table($this, 0, $filter, 0, false);
1015 $useridlist = $table->get_column_data('userid');
1022 * Utility function get the userid based on the row number of the grading table.
1023 * This takes into account any active filters on the table.
1025 * @param int $num The row number of the user
1026 * @param bool $last This is set to true if this is the last user in the table
1027 * @return mixed The user id of the matching user or false if there was an error
1029 private function get_userid_for_row($num, $last){
1030 if (!array_key_exists('userid_for_row', $this->cache)) {
1031 $this->cache['userid_for_row'] = array();
1033 if (array_key_exists($num, $this->cache['userid_for_row'])) {
1034 list($userid, $last) = $this->cache['userid_for_row'][$num];
1038 $filter = get_user_preferences('assign_filter', '');
1039 $table = new assign_grading_table($this, 0, $filter, 0, false);
1041 $userid = $table->get_cell_data($num, 'userid', $last);
1043 $this->cache['userid_for_row'][$num] = array($userid, $last);
1048 * Return all assignment submissions by ENROLLED students (even empty)
1050 * @param string $sort optional field names for the ORDER BY in the sql query
1051 * @param string $dir optional specifying the sort direction, defaults to DESC
1052 * @return array The submission objects indexed by id
1054 private function get_all_submissions( $sort="", $dir="DESC") {
1057 if ($sort == "lastname" or $sort == "firstname") {
1058 $sort = "u.$sort $dir";
1059 } else if (empty($sort)) {
1060 $sort = "a.timemodified DESC";
1062 $sort = "a.$sort $dir";
1065 return $DB->get_records_sql("SELECT a.*
1066 FROM {assign_submission} a, {user} u
1067 WHERE u.id = a.userid
1068 AND a.assignment = ?
1069 ORDER BY $sort", array($this->get_instance()->id));
1074 * Generate zip file from array of given files
1076 * @param array $filesforzipping - array of files to pass into archive_to_pathname - this array is indexed by the final file name and each element in the array is an instance of a stored_file object
1077 * @return path of temp file - note this returned file does not have a .zip extension - it is a temp file.
1079 private function pack_files($filesforzipping) {
1081 //create path for new zip file.
1082 $tempzip = tempnam($CFG->tempdir.'/', 'assignment_');
1084 $zipper = new zip_packer();
1085 if ($zipper->archive_to_pathname($filesforzipping, $tempzip)) {
1092 * Finds all assignment notifications that have yet to be mailed out, and mails them.
1094 * Cron function to be run periodically according to the moodle cron
1098 static function cron() {
1101 // only ever send a max of one days worth of updates
1102 $yesterday = time() - (24 * 3600);
1105 // Collect all submissions from the past 24 hours that require mailing.
1106 $sql = "SELECT s.*, a.course, a.name, g.*, g.id as gradeid, g.timemodified as lastmodified
1108 JOIN {assign_grades} g ON g.assignment = a.id
1109 LEFT JOIN {assign_submission} s ON s.assignment = a.id AND s.userid = g.userid
1110 WHERE g.timemodified >= :yesterday AND
1111 g.timemodified <= :today AND
1113 $params = array('yesterday' => $yesterday, 'today' => $timenow);
1114 $submissions = $DB->get_records_sql($sql, $params);
1116 if (empty($submissions)) {
1121 mtrace('Processing ' . count($submissions) . ' assignment submissions ...');
1123 // Preload courses we are going to need those.
1124 $courseids = array();
1125 foreach ($submissions as $submission) {
1126 $courseids[] = $submission->course;
1128 // Filter out duplicates
1129 $courseids = array_unique($courseids);
1130 $ctxselect = context_helper::get_preload_record_columns_sql('ctx');
1131 list($courseidsql, $params) = $DB->get_in_or_equal($courseids, SQL_PARAMS_NAMED);
1132 $sql = "SELECT c.*, {$ctxselect}
1134 LEFT JOIN {context} ctx ON ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel
1135 WHERE c.id {$courseidsql}";
1136 $params['contextlevel'] = CONTEXT_COURSE;
1137 $courses = $DB->get_records_sql($sql, $params);
1138 // Clean up... this could go on for a while.
1141 unset($courseidsql);
1144 // Simple array we'll use for caching modules.
1145 $modcache = array();
1147 // Message students about new feedback
1148 foreach ($submissions as $submission) {
1150 mtrace("Processing assignment submission $submission->id ...");
1152 // do not cache user lookups - could be too many
1153 if (!$user = $DB->get_record("user", array("id"=>$submission->userid))) {
1154 mtrace("Could not find user $submission->userid");
1158 // use a cache to prevent the same DB queries happening over and over
1159 if (!array_key_exists($submission->course, $courses)) {
1160 mtrace("Could not find course $submission->course");
1163 $course = $courses[$submission->course];
1164 if (isset($course->ctxid)) {
1165 // Context has not yet been preloaded. Do so now.
1166 context_helper::preload_from_record($course);
1169 // Override the language and timezone of the "current" user, so that
1170 // mail is customised for the receiver.
1171 cron_setup_user($user, $course);
1173 // context lookups are already cached
1174 $coursecontext = context_course::instance($course->id);
1175 if (!is_enrolled($coursecontext, $user->id)) {
1176 $courseshortname = format_string($course->shortname, true, array('context' => $coursecontext));
1177 mtrace(fullname($user)." not an active participant in " . $courseshortname);
1181 if (!$grader = $DB->get_record("user", array("id"=>$submission->grader))) {
1182 mtrace("Could not find grader $submission->grader");
1186 if (!array_key_exists($submission->assignment, $modcache)) {
1187 if (! $mod = get_coursemodule_from_instance("assign", $submission->assignment, $course->id)) {
1188 mtrace("Could not find course module for assignment id $submission->assignment");
1191 $modcache[$submission->assignment] = $mod;
1193 $mod = $modcache[$submission->assignment];
1195 // context lookups are already cached
1196 $contextmodule = context_module::instance($mod->id);
1198 if (!$mod->visible) {
1199 // Hold mail notification for hidden assignments until later
1203 // need to send this to the student
1204 $messagetype = 'feedbackavailable';
1205 $eventtype = 'assign_notification';
1206 $updatetime = $submission->lastmodified;
1207 $modulename = get_string('modulename', 'assign');
1208 self::send_assignment_notification($grader, $user, $messagetype, $eventtype, $updatetime, $mod, $contextmodule, $course, $modulename, $submission->name);
1210 $grade = new stdClass();
1211 $grade->id = $submission->gradeid;
1213 $DB->update_record('assign_grades', $grade);
1217 mtrace('Done processing ' . count($submissions) . ' assignment submissions');
1221 // Free up memory just to be sure
1229 * Update a grade in the grade table for the assignment and in the gradebook
1231 * @param stdClass $grade a grade record keyed on id
1232 * @return bool true for success
1234 private function update_grade($grade) {
1237 $grade->timemodified = time();
1239 if ($grade->grade && $grade->grade != -1) {
1240 if ($this->get_instance()->grade > 0) {
1241 if (!is_numeric($grade->grade)) {
1243 } else if ($grade->grade > $this->get_instance()->grade) {
1245 } else if ($grade->grade < 0) {
1250 if ($scale = $DB->get_record('scale', array('id' => -($this->get_instance()->grade)))) {
1251 $scaleoptions = make_menu_from_list($scale->scale);
1252 if (!array_key_exists((int) $grade->grade, $scaleoptions)) {
1259 $result = $DB->update_record('assign_grades', $grade);
1261 $this->gradebook_item_update(null, $grade);
1267 * display the submission that is used by a plugin
1268 * Uses url parameters 'sid', 'gid' and 'plugin'
1269 * @param string $pluginsubtype
1272 private function view_plugin_content($pluginsubtype) {
1277 $submissionid = optional_param('sid', 0, PARAM_INT);
1278 $gradeid = optional_param('gid', 0, PARAM_INT);
1279 $plugintype = required_param('plugin', PARAM_TEXT);
1281 if ($pluginsubtype == 'assignsubmission') {
1282 $plugin = $this->get_submission_plugin_by_type($plugintype);
1283 if ($submissionid <= 0) {
1284 throw new coding_exception('Submission id should not be 0');
1286 $item = $this->get_submission($submissionid);
1289 if ($item->userid != $USER->id) {
1290 require_capability('mod/assign:grade', $this->context);
1292 $o .= $this->output->render(new assign_header($this->get_instance(),
1293 $this->get_context(),
1294 $this->show_intro(),
1295 $this->get_course_module()->id,
1296 $plugin->get_name()));
1297 $o .= $this->output->render(new assign_submission_plugin_submission($plugin,
1299 assign_submission_plugin_submission::FULL,
1300 $this->get_course_module()->id,
1301 $this->get_return_action(),
1302 $this->get_return_params()));
1304 $this->add_to_log('view submission', get_string('viewsubmissionforuser', 'assign', $item->userid));
1306 $plugin = $this->get_feedback_plugin_by_type($plugintype);
1307 if ($gradeid <= 0) {
1308 throw new coding_exception('Grade id should not be 0');
1310 $item = $this->get_grade($gradeid);
1312 if ($item->userid != $USER->id) {
1313 require_capability('mod/assign:grade', $this->context);
1315 $o .= $this->output->render(new assign_header($this->get_instance(),
1316 $this->get_context(),
1317 $this->show_intro(),
1318 $this->get_course_module()->id,
1319 $plugin->get_name()));
1320 $o .= $this->output->render(new assign_feedback_plugin_feedback($plugin,
1322 assign_feedback_plugin_feedback::FULL,
1323 $this->get_course_module()->id,
1324 $this->get_return_action(),
1325 $this->get_return_params()));
1326 $this->add_to_log('view feedback', get_string('viewfeedbackforuser', 'assign', $item->userid));
1330 $o .= $this->view_return_links();
1332 $o .= $this->view_footer();
1337 * render the content in editor that is often used by plugin
1339 * @param string $filearea
1340 * @param int $submissionid
1341 * @param string $plugintype
1342 * @param string $editor
1343 * @param string $component
1346 public function render_editor_content($filearea, $submissionid, $plugintype, $editor, $component) {
1351 $plugin = $this->get_submission_plugin_by_type($plugintype);
1353 $text = $plugin->get_editor_text($editor, $submissionid);
1354 $format = $plugin->get_editor_format($editor, $submissionid);
1356 $finaltext = file_rewrite_pluginfile_urls($text, 'pluginfile.php', $this->get_context()->id, $component, $filearea, $submissionid);
1357 $result .= format_text($finaltext, $format, array('overflowdiv' => true, 'context' => $this->get_context()));
1361 if ($CFG->enableportfolios) {
1362 require_once($CFG->libdir . '/portfoliolib.php');
1364 $button = new portfolio_add_button();
1365 $button->set_callback_options('assign_portfolio_caller', array('cmid' => $this->get_course_module()->id, 'sid' => $submissionid, 'plugin' => $plugintype, 'editor' => $editor, 'area'=>$filearea), '/mod/assign/portfolio_callback.php');
1366 $fs = get_file_storage();
1368 if ($files = $fs->get_area_files($this->context->id, $component,$filearea, $submissionid, "timemodified", false)) {
1369 $button->set_formats(PORTFOLIO_FORMAT_RICHHTML);
1371 $button->set_formats(PORTFOLIO_FORMAT_PLAINHTML);
1373 $result .= $button->to_html();
1379 * Display a grading error
1381 * @param string $message - The description of the result
1384 private function view_quickgrading_result($message) {
1386 $o .= $this->output->render(new assign_header($this->get_instance(),
1387 $this->get_context(),
1388 $this->show_intro(),
1389 $this->get_course_module()->id,
1390 get_string('quickgradingresult', 'assign')));
1391 $o .= $this->output->render(new assign_quickgrading_result($message, $this->get_course_module()->id));
1392 $o .= $this->view_footer();
1397 * Display the page footer
1401 private function view_footer() {
1402 return $this->output->render_footer();
1406 * Does this user have grade permission for this assignment
1410 private function can_grade() {
1411 // Permissions check
1412 if (!has_capability('mod/assign:grade', $this->context)) {
1420 * Download a zip file of all assignment submissions
1424 private function download_submissions() {
1427 // more efficient to load this here
1428 require_once($CFG->libdir.'/filelib.php');
1430 // load all submissions
1431 $submissions = $this->get_all_submissions('','');
1433 if (empty($submissions)) {
1434 print_error('errornosubmissions', 'assign');
1438 // build a list of files to zip
1439 $filesforzipping = array();
1440 $fs = get_file_storage();
1442 $groupmode = groups_get_activity_groupmode($this->get_course_module());
1443 $groupid = 0; // All users
1446 $groupid = groups_get_activity_group($this->get_course_module(), true);
1447 $groupname = groups_get_group_name($groupid).'-';
1450 // construct the zip file name
1451 $filename = str_replace(' ', '_', clean_filename($this->get_course()->shortname.'-'.$this->get_instance()->name.'-'.$groupname.$this->get_course_module()->id.".zip")); //name of new zip file.
1453 // get all the files for each submission
1454 foreach ($submissions as $submission) {
1455 $userid = $submission->userid; //get userid
1456 if ((groups_is_member($groupid,$userid) or !$groupmode or !$groupid)) {
1457 // get the plugins to add their own files to the zip
1459 $user = $DB->get_record("user", array("id"=>$userid),'id,username,firstname,lastname', MUST_EXIST);
1461 $prefix = clean_filename(fullname($user) . "_" .$userid . "_");
1463 foreach ($this->submissionplugins as $plugin) {
1464 if ($plugin->is_enabled() && $plugin->is_visible()) {
1465 $pluginfiles = $plugin->get_files($submission);
1468 foreach ($pluginfiles as $zipfilename => $file) {
1469 $filesforzipping[$prefix . $zipfilename] = $file;
1475 } // end of foreach loop
1476 if ($zipfile = $this->pack_files($filesforzipping)) {
1477 $this->add_to_log('download all submissions', get_string('downloadall', 'assign'));
1478 send_temp_file($zipfile, $filename); //send file and delete after sending.
1483 * Util function to add a message to the log
1485 * @param string $action The current action
1486 * @param string $info A detailed description of the change. But no more than 255 characters.
1487 * @param string $url The url to the assign module instance.
1490 public function add_to_log($action = '', $info = '', $url='') {
1493 $fullurl = 'view.php?id=' . $this->get_course_module()->id;
1495 $fullurl .= '&' . $url;
1498 add_to_log($this->get_course()->id, 'assign', $action, $fullurl, $info, $this->get_course_module()->id, $USER->id);
1502 * Load the submission object for a particular user, optionally creating it if required
1504 * @param int $userid The id of the user whose submission we want or 0 in which case USER->id is used
1505 * @param bool $create optional Defaults to false. If set to true a new submission object will be created in the database
1506 * @return stdClass The submission
1508 private function get_user_submission($userid, $create) {
1512 $userid = $USER->id;
1514 // if the userid is not null then use userid
1515 $submission = $DB->get_record('assign_submission', array('assignment'=>$this->get_instance()->id, 'userid'=>$userid));
1521 $submission = new stdClass();
1522 $submission->assignment = $this->get_instance()->id;
1523 $submission->userid = $userid;
1524 $submission->timecreated = time();
1525 $submission->timemodified = $submission->timecreated;
1527 if ($this->get_instance()->submissiondrafts) {
1528 $submission->status = ASSIGN_SUBMISSION_STATUS_DRAFT;
1530 $submission->status = ASSIGN_SUBMISSION_STATUS_SUBMITTED;
1532 $sid = $DB->insert_record('assign_submission', $submission);
1533 $submission->id = $sid;
1540 * Load the submission object from it's id
1542 * @param int $submissionid The id of the submission we want
1543 * @return stdClass The submission
1545 private function get_submission($submissionid) {
1548 return $DB->get_record('assign_submission', array('assignment'=>$this->get_instance()->id, 'id'=>$submissionid), '*', MUST_EXIST);
1552 * This will retrieve a grade object from the db, optionally creating it if required
1554 * @param int $userid The user we are grading
1555 * @param bool $create If true the grade will be created if it does not exist
1556 * @return stdClass The grade record
1558 private function get_user_grade($userid, $create) {
1562 $userid = $USER->id;
1565 // if the userid is not null then use userid
1566 $grade = $DB->get_record('assign_grades', array('assignment'=>$this->get_instance()->id, 'userid'=>$userid));
1572 $grade = new stdClass();
1573 $grade->assignment = $this->get_instance()->id;
1574 $grade->userid = $userid;
1575 $grade->timecreated = time();
1576 $grade->timemodified = $grade->timecreated;
1579 $grade->grader = $USER->id;
1580 $gid = $DB->insert_record('assign_grades', $grade);
1588 * This will retrieve a grade object from the db
1590 * @param int $gradeid The id of the grade
1591 * @return stdClass The grade record
1593 private function get_grade($gradeid) {
1596 return $DB->get_record('assign_grades', array('assignment'=>$this->get_instance()->id, 'id'=>$gradeid), '*', MUST_EXIST);
1600 * Print the grading page for a single user submission
1602 * @param moodleform $mform
1603 * @param int $offset
1606 private function view_single_grade_page($mform, $offset=0) {
1611 // Include grade form
1612 require_once($CFG->dirroot . '/mod/assign/gradeform.php');
1614 // Need submit permission to submit an assignment
1615 require_capability('mod/assign:grade', $this->context);
1617 $o .= $this->output->render(new assign_header($this->get_instance(),
1618 $this->get_context(), false, $this->get_course_module()->id,get_string('grading', 'assign')));
1620 $rownum = required_param('rownum', PARAM_INT) + $offset;
1621 $useridlist = optional_param('useridlist', '', PARAM_TEXT);
1623 $useridlist = explode(',', $useridlist);
1625 $useridlist = $this->get_grading_userid_list();
1628 $userid = $useridlist[$rownum];
1629 if ($rownum == count($useridlist) - 1) {
1632 // the placement of this is important so can pass the list of userids above
1637 throw new coding_exception('Row is out of bounds for the current grading table: ' . $rownum);
1639 $user = $DB->get_record('user', array('id' => $userid));
1641 $o .= $this->output->render(new assign_user_summary($user, $this->get_course()->id, has_capability('moodle/site:viewfullnames', $this->get_course_context())));
1643 $submission = $this->get_user_submission($userid, false);
1644 // get the current grade
1645 $grade = $this->get_user_grade($userid, false);
1646 if ($this->can_view_submission($userid)) {
1647 $gradelocked = ($grade && $grade->locked) || $this->grading_disabled($userid);
1648 $o .= $this->output->render(new assign_submission_status($this->get_instance()->allowsubmissionsfromdate,
1649 $this->get_instance()->alwaysshowdescription,
1651 $this->is_any_submission_plugin_enabled(),
1653 $this->is_graded($userid),
1654 $this->get_instance()->duedate,
1655 $this->get_submission_plugins(),
1656 $this->get_return_action(),
1657 $this->get_return_params(),
1658 $this->get_course_module()->id,
1659 assign_submission_status::GRADER_VIEW,
1664 $data = new stdClass();
1665 if ($grade->grade !== NULL && $grade->grade >= 0) {
1666 $data->grade = format_float($grade->grade,2);
1669 $data = new stdClass();
1673 // now show the grading form
1675 $mform = new mod_assign_grade_form(null, array($this, $data, array('rownum'=>$rownum, 'useridlist'=>$useridlist, 'last'=>$last)), 'post', '', array('class'=>'gradeform'));
1677 $o .= $this->output->render(new assign_form('gradingform',$mform));
1679 $this->add_to_log('view grading form', get_string('viewgradingformforstudent', 'assign', array('id'=>$user->id, 'fullname'=>fullname($user))));
1681 $o .= $this->view_footer();
1688 * View a link to go back to the previous page. Uses url parameters returnaction and returnparams.
1692 private function view_return_links() {
1694 $returnaction = optional_param('returnaction','', PARAM_ALPHA);
1695 $returnparams = optional_param('returnparams','', PARAM_TEXT);
1698 parse_str($returnparams, $params);
1699 $params = array_merge( array('id' => $this->get_course_module()->id, 'action' => $returnaction), $params);
1701 return $this->output->single_button(new moodle_url('/mod/assign/view.php', $params), get_string('back'), 'get');
1706 * View the grading table of all submissions for this assignment
1710 private function view_grading_table() {
1712 // Include grading options form
1713 require_once($CFG->dirroot . '/mod/assign/gradingoptionsform.php');
1714 require_once($CFG->dirroot . '/mod/assign/quickgradingform.php');
1715 require_once($CFG->dirroot . '/mod/assign/gradingbatchoperationsform.php');
1719 if (has_capability('gradereport/grader:view', $this->get_course_context()) &&
1720 has_capability('moodle/grade:viewall', $this->get_course_context())) {
1721 $gradebookurl = '/grade/report/grader/index.php?id=' . $this->get_course()->id;
1722 $links[$gradebookurl] = get_string('viewgradebook', 'assign');
1724 if ($this->is_any_submission_plugin_enabled()) {
1725 $downloadurl = '/mod/assign/view.php?id=' . $this->get_course_module()->id . '&action=downloadall';
1726 $links[$downloadurl] = get_string('downloadall', 'assign');
1729 $gradingactions = new url_select($links);
1731 $gradingmanager = get_grading_manager($this->get_context(), 'mod_assign', 'submissions');
1733 $perpage = get_user_preferences('assign_perpage', 10);
1734 $filter = get_user_preferences('assign_filter', '');
1735 $controller = $gradingmanager->get_active_controller();
1736 $showquickgrading = empty($controller);
1737 if (optional_param('action', '', PARAM_ALPHA) == 'saveoptions') {
1738 $quickgrading = optional_param('quickgrading', false, PARAM_BOOL);
1739 set_user_preference('assign_quickgrading', $quickgrading);
1741 $quickgrading = get_user_preferences('assign_quickgrading', false);
1743 // print options for changing the filter and changing the number of results per page
1744 $gradingoptionsform = new mod_assign_grading_options_form(null,
1745 array('cm'=>$this->get_course_module()->id,
1746 'contextid'=>$this->context->id,
1747 'userid'=>$USER->id,
1748 'submissionsenabled'=>$this->is_any_submission_plugin_enabled(),
1749 'showquickgrading'=>$showquickgrading,
1750 'quickgrading'=>$quickgrading),
1752 array('class'=>'gradingoptionsform'));
1754 $gradingbatchoperationsform = new mod_assign_grading_batch_operations_form(null,
1755 array('cm'=>$this->get_course_module()->id,
1756 'submissiondrafts'=>$this->get_instance()->submissiondrafts),
1758 array('class'=>'gradingbatchoperationsform'));
1760 $gradingoptionsdata = new stdClass();
1761 $gradingoptionsdata->perpage = $perpage;
1762 $gradingoptionsdata->filter = $filter;
1763 $gradingoptionsform->set_data($gradingoptionsdata);
1765 // plagiarism update status apearring in the grading book
1766 if (!empty($CFG->enableplagiarism)) {
1767 /** Include plagiarismlib.php */
1768 require_once($CFG->libdir . '/plagiarismlib.php');
1769 $o .= plagiarism_update_status($this->get_course(), $this->get_course_module());
1772 $actionformtext = $this->output->render($gradingactions);
1773 $o .= $this->output->render(new assign_header($this->get_instance(),
1774 $this->get_context(), false, $this->get_course_module()->id, get_string('grading', 'assign'), $actionformtext));
1775 $o .= groups_print_activity_menu($this->get_course_module(), $CFG->wwwroot . '/mod/assign/view.php?id=' . $this->get_course_module()->id.'&action=grading', true);
1778 // load and print the table of submissions
1779 if ($showquickgrading && $quickgrading) {
1780 $table = $this->output->render(new assign_grading_table($this, $perpage, $filter, 0, true));
1781 $quickgradingform = new mod_assign_quick_grading_form(null,
1782 array('cm'=>$this->get_course_module()->id,
1783 'gradingtable'=>$table));
1784 $o .= $this->output->render(new assign_form('quickgradingform', $quickgradingform));
1786 $o .= $this->output->render(new assign_grading_table($this, $perpage, $filter, 0, false));
1789 $currentgroup = groups_get_activity_group($this->get_course_module(), true);
1790 $users = array_keys($this->list_participants($currentgroup, true));
1791 if (count($users) != 0) {
1792 // if no enrolled user in a course then don't display the batch operations feature
1793 $o .= $this->output->render(new assign_form('gradingbatchoperationsform', $gradingbatchoperationsform));
1795 $o .= $this->output->render(new assign_form('gradingoptionsform', $gradingoptionsform, 'M.mod_assign.init_grading_options'));
1800 * View entire grading page.
1804 private function view_grading_page() {
1808 // Need submit permission to submit an assignment
1809 require_capability('mod/assign:grade', $this->context);
1810 require_once($CFG->dirroot . '/mod/assign/gradeform.php');
1812 // only load this if it is
1814 $o .= $this->view_grading_table();
1816 $o .= $this->view_footer();
1817 $this->add_to_log('view submission grading table', get_string('viewsubmissiongradingtable', 'assign'));
1822 * Capture the output of the plagiarism plugins disclosures and return it as a string
1826 private function plagiarism_print_disclosure() {
1830 if (!empty($CFG->enableplagiarism)) {
1831 /** Include plagiarismlib.php */
1832 require_once($CFG->libdir . '/plagiarismlib.php');
1834 $o .= plagiarism_print_disclosure($this->get_course_module()->id);
1841 * message for students when assignment submissions have been closed
1845 private function view_student_error_message() {
1849 // Need submit permission to submit an assignment
1850 require_capability('mod/assign:submit', $this->context);
1852 $o .= $this->output->render(new assign_header($this->get_instance(),
1853 $this->get_context(),
1854 $this->show_intro(),
1855 $this->get_course_module()->id,
1856 get_string('editsubmission', 'assign')));
1858 $o .= $this->output->notification(get_string('submissionsclosed', 'assign'));
1860 $o .= $this->view_footer();
1867 * View edit submissions page.
1869 * @param moodleform $mform
1872 private function view_edit_submission_page($mform) {
1876 // Include submission form
1877 require_once($CFG->dirroot . '/mod/assign/submission_form.php');
1878 // Need submit permission to submit an assignment
1879 require_capability('mod/assign:submit', $this->context);
1881 if (!$this->submissions_open()) {
1882 return $this->view_student_error_message();
1884 $o .= $this->output->render(new assign_header($this->get_instance(),
1885 $this->get_context(),
1886 $this->show_intro(),
1887 $this->get_course_module()->id,
1888 get_string('editsubmission', 'assign')));
1889 $o .= $this->plagiarism_print_disclosure();
1890 $data = new stdClass();
1893 $mform = new mod_assign_submission_form(null, array($this, $data));
1896 $o .= $this->output->render(new assign_form('editsubmissionform',$mform));
1898 $o .= $this->view_footer();
1899 $this->add_to_log('view submit assignment form', get_string('viewownsubmissionform', 'assign'));
1905 * See if this assignment has a grade yet
1907 * @param int $userid
1910 private function is_graded($userid) {
1911 $grade = $this->get_user_grade($userid, false);
1913 return ($grade->grade !== NULL && $grade->grade >= 0);
1920 * Perform an access check to see if the current $USER can view this users submission
1922 * @param int $userid
1925 public function can_view_submission($userid) {
1928 if (!is_enrolled($this->get_course_context(), $userid)) {
1931 if ($userid == $USER->id && !has_capability('mod/assign:submit', $this->context)) {
1934 if ($userid != $USER->id && !has_capability('mod/assign:grade', $this->context)) {
1941 * Ask the user to confirm they want to perform this batch operation
1944 private function process_batch_grading_operation() {
1946 require_once($CFG->dirroot . '/mod/assign/gradingbatchoperationsform.php');
1949 $gradingbatchoperationsform = new mod_assign_grading_batch_operations_form(null,
1950 array('cm'=>$this->get_course_module()->id,
1951 'submissiondrafts'=>$this->get_instance()->submissiondrafts),
1953 array('class'=>'gradingbatchoperationsform'));
1955 if ($data = $gradingbatchoperationsform->get_data()) {
1956 // get the list of users
1957 $users = $data->selectedusers;
1958 $userlist = explode(',', $users);
1960 foreach ($userlist as $userid) {
1961 if ($data->operation == 'lock') {
1962 $this->process_lock($userid);
1963 } else if ($data->operation == 'unlock') {
1964 $this->process_unlock($userid);
1965 } else if ($data->operation == 'reverttodraft') {
1966 $this->process_revert_to_draft($userid);
1975 * Ask the user to confirm they want to submit their work for grading
1978 private function check_submit_for_grading() {
1980 // Check that all of the submission plugins are ready for this submission
1981 $notifications = array();
1982 $submission = $this->get_user_submission($USER->id, false);
1983 $plugins = $this->get_submission_plugins();
1984 foreach ($plugins as $plugin) {
1985 if ($plugin->is_enabled() && $plugin->is_visible()) {
1986 $check = $plugin->precheck_submission($submission);
1987 if ($check !== true) {
1988 $notifications[] = $check;
1994 $o .= $this->output->header();
1995 $o .= $this->output->render(new assign_submit_for_grading_page($notifications, $this->get_course_module()->id));
1996 $o .= $this->view_footer();
2001 * Print 2 tables of information with no action links -
2002 * the submission summary and the grading summary
2004 * @param stdClass $user the user to print the report for
2005 * @param bool $showlinks - Return plain text or links to the profile
2006 * @return string - the html summary
2008 public function view_student_summary($user, $showlinks) {
2009 global $CFG, $DB, $PAGE;
2011 $grade = $this->get_user_grade($user->id, false);
2012 $submission = $this->get_user_submission($user->id, false);
2015 if ($this->can_view_submission($user->id)) {
2016 $showedit = has_capability('mod/assign:submit', $this->context) &&
2017 $this->submissions_open() && ($this->is_any_submission_plugin_enabled()) && $showlinks;
2018 $showsubmit = $submission && ($submission->status == ASSIGN_SUBMISSION_STATUS_DRAFT) && $showlinks;
2019 $gradelocked = ($grade && $grade->locked) || $this->grading_disabled($user->id);
2021 $o .= $this->output->render(new assign_submission_status($this->get_instance()->allowsubmissionsfromdate,
2022 $this->get_instance()->alwaysshowdescription,
2024 $this->is_any_submission_plugin_enabled(),
2026 $this->is_graded($user->id),
2027 $this->get_instance()->duedate,
2028 $this->get_submission_plugins(),
2029 $this->get_return_action(),
2030 $this->get_return_params(),
2031 $this->get_course_module()->id,
2032 assign_submission_status::STUDENT_VIEW,
2035 require_once($CFG->libdir.'/gradelib.php');
2036 require_once($CFG->dirroot.'/grade/grading/lib.php');
2038 $gradinginfo = grade_get_grades($this->get_course()->id,
2041 $this->get_instance()->id,
2044 $gradingitem = $gradinginfo->items[0];
2045 $gradebookgrade = $gradingitem->grades[$user->id];
2047 // check to see if all feedback plugins are empty
2048 $emptyplugins = true;
2050 foreach ($this->get_feedback_plugins() as $plugin) {
2051 if ($plugin->is_visible() && $plugin->is_enabled()) {
2052 if (!$plugin->is_empty($grade)) {
2053 $emptyplugins = false;
2060 if (!($gradebookgrade->hidden) && ($gradebookgrade->grade !== null || !$emptyplugins)) {
2062 $gradefordisplay = '';
2063 $gradingmanager = get_grading_manager($this->get_context(), 'mod_assign', 'submissions');
2065 if ($controller = $gradingmanager->get_active_controller()) {
2066 $controller->set_grade_range(make_grades_menu($this->get_instance()->grade));
2067 $gradefordisplay = $controller->render_grade($PAGE,
2070 $gradebookgrade->str_long_grade,
2071 has_capability('mod/assign:grade', $this->get_context()));
2073 $gradefordisplay = $this->display_grade($gradebookgrade->grade, false);
2076 $gradeddate = $gradebookgrade->dategraded;
2077 $grader = $DB->get_record('user', array('id'=>$gradebookgrade->usermodified));
2079 $feedbackstatus = new assign_feedback_status($gradefordisplay,
2082 $this->get_feedback_plugins(),
2084 $this->get_course_module()->id,
2085 $this->get_return_action(),
2086 $this->get_return_params());
2088 $o .= $this->output->render($feedbackstatus);
2096 * View submissions page (contains details of current submission).
2100 private function view_submission_page() {
2101 global $CFG, $DB, $USER, $PAGE;
2104 $o .= $this->output->render(new assign_header($this->get_instance(),
2105 $this->get_context(),
2106 $this->show_intro(),
2107 $this->get_course_module()->id));
2109 if ($this->can_grade()) {
2110 $o .= $this->output->render(new assign_grading_summary($this->count_participants(0),
2111 $this->get_instance()->submissiondrafts,
2112 $this->count_submissions_with_status(ASSIGN_SUBMISSION_STATUS_DRAFT),
2113 $this->is_any_submission_plugin_enabled(),
2114 $this->count_submissions_with_status(ASSIGN_SUBMISSION_STATUS_SUBMITTED),
2115 $this->get_instance()->duedate,
2116 $this->get_course_module()->id,
2117 $this->count_submissions_need_grading()
2120 $grade = $this->get_user_grade($USER->id, false);
2121 $submission = $this->get_user_submission($USER->id, false);
2123 if ($this->can_view_submission($USER->id)) {
2124 $o .= $this->view_student_summary($USER, true);
2128 $o .= $this->view_footer();
2129 $this->add_to_log('view', get_string('viewownsubmissionstatus', 'assign'));
2134 * convert the final raw grade(s) in the grading table for the gradebook
2136 * @param stdClass $grade
2139 private function convert_grade_for_gradebook(stdClass $grade) {
2140 $gradebookgrade = array();
2141 // trying to match those array keys in grade update function in gradelib.php
2142 // with keys in th database table assign_grades
2143 // starting around line 262
2144 if ($grade->grade >= 0) {
2145 $gradebookgrade['rawgrade'] = $grade->grade;
2147 $gradebookgrade['userid'] = $grade->userid;
2148 $gradebookgrade['usermodified'] = $grade->grader;
2149 $gradebookgrade['datesubmitted'] = NULL;
2150 $gradebookgrade['dategraded'] = $grade->timemodified;
2151 if (isset($grade->feedbackformat)) {
2152 $gradebookgrade['feedbackformat'] = $grade->feedbackformat;
2154 if (isset($grade->feedbacktext)) {
2155 $gradebookgrade['feedback'] = $grade->feedbacktext;
2158 return $gradebookgrade;
2162 * convert submission details for the gradebook
2164 * @param stdClass $submission
2167 private function convert_submission_for_gradebook(stdClass $submission) {
2168 $gradebookgrade = array();
2171 $gradebookgrade['userid'] = $submission->userid;
2172 $gradebookgrade['usermodified'] = $submission->userid;
2173 $gradebookgrade['datesubmitted'] = $submission->timemodified;
2175 return $gradebookgrade;
2179 * update grades in the gradebook
2181 * @param mixed $submission stdClass|null
2182 * @param mixed $grade stdClass|null
2185 private function gradebook_item_update($submission=NULL, $grade=NULL) {
2187 if($submission != NULL){
2188 $gradebookgrade = $this->convert_submission_for_gradebook($submission);
2190 $gradebookgrade = $this->convert_grade_for_gradebook($grade);
2192 // Grading is disabled, return.
2193 if ($this->grading_disabled($gradebookgrade['userid'])) {
2196 $assign = clone $this->get_instance();
2197 $assign->cmidnumber = $this->get_course_module()->id;
2199 return assign_grade_item_update($assign, $gradebookgrade);
2203 * update grades in the gradebook based on submission time
2205 * @param stdClass $submission
2206 * @param bool $updatetime
2209 private function update_submission(stdClass $submission, $updatetime=true) {
2213 $submission->timemodified = time();
2215 $result= $DB->update_record('assign_submission', $submission);
2217 $this->gradebook_item_update($submission);
2223 * Is this assignment open for submissions?
2225 * Check the due date,
2226 * prevent late submissions,
2227 * has this person already submitted,
2228 * is the assignment locked?
2232 private function submissions_open() {
2237 if ($this->get_instance()->preventlatesubmissions && $this->get_instance()->duedate) {
2238 $dateopen = ($this->get_instance()->allowsubmissionsfromdate <= $time && $time <= $this->get_instance()->duedate);
2240 $dateopen = ($this->get_instance()->allowsubmissionsfromdate <= $time);
2247 // now check if this user has already submitted etc.
2248 if (!is_enrolled($this->get_course_context(), $USER)) {
2251 if ($submission = $this->get_user_submission($USER->id, false)) {
2252 if ($this->get_instance()->submissiondrafts && $submission->status == ASSIGN_SUBMISSION_STATUS_SUBMITTED) {
2253 // drafts are tracked and the student has submitted the assignment
2257 if ($grade = $this->get_user_grade($USER->id, false)) {
2258 if ($grade->locked) {
2263 if ($this->grading_disabled($USER->id)) {
2271 * render the files in file area
2272 * @param string $component
2273 * @param string $area
2274 * @param int $submissionid
2277 public function render_area_files($component, $area, $submissionid) {
2280 if (!$submissionid) {
2281 $submission = $this->get_user_submission($USER->id,false);
2282 $submissionid = $submission->id;
2285 $fs = get_file_storage();
2286 $browser = get_file_browser();
2287 $files = $fs->get_area_files($this->get_context()->id, $component, $area , $submissionid , "timemodified", false);
2288 return $this->output->assign_files($this->context, $submissionid, $area, $component);
2293 * Returns a list of teachers that should be grading given submission
2295 * @param int $userid
2298 private function get_graders($userid) {
2300 $potentialgraders = get_enrolled_users($this->context, "mod/assign:grade");
2303 if (groups_get_activity_groupmode($this->get_course_module()) == SEPARATEGROUPS) { // Separate groups are being used
2304 if ($groups = groups_get_all_groups($this->get_course()->id, $userid)) { // Try to find all groups
2305 foreach ($groups as $group) {
2306 foreach ($potentialgraders as $grader) {
2307 if ($grader->id == $userid) {
2308 continue; // do not send self
2310 if (groups_is_member($group->id, $grader->id)) {
2311 $graders[$grader->id] = $grader;
2316 // user not in group, try to find graders without group
2317 foreach ($potentialgraders as $grader) {
2318 if ($grader->id == $userid) {
2319 continue; // do not send self
2321 if (!groups_has_membership($this->get_course_module(), $grader->id)) {
2322 $graders[$grader->id] = $grader;
2327 foreach ($potentialgraders as $grader) {
2328 if ($grader->id == $userid) {
2329 continue; // do not send self
2332 if (is_enrolled($this->get_course_context(), $grader->id)) {
2333 $graders[$grader->id] = $grader;
2341 * Format a notification for plain text
2343 * @param string $messagetype
2344 * @param stdClass $info
2345 * @param stdClass $course
2346 * @param stdClass $context
2347 * @param string $modulename
2348 * @param string $assignmentname
2350 private static function format_notification_message_text($messagetype, $info, $course, $context, $modulename, $assignmentname) {
2351 $posttext = format_string($course->shortname, true, array('context' => $context->get_course_context())).' -> '.
2353 format_string($assignmentname, true, array('context' => $context))."\n";
2354 $posttext .= '---------------------------------------------------------------------'."\n";
2355 $posttext .= get_string($messagetype . 'text', "assign", $info)."\n";
2356 $posttext .= "\n---------------------------------------------------------------------\n";
2361 * Format a notification for HTML
2363 * @param string $messagetype
2364 * @param stdClass $info
2365 * @param stdClass $course
2366 * @param stdClass $context
2367 * @param string $modulename
2368 * @param stdClass $coursemodule
2369 * @param string $assignmentname
2370 * @param stdClass $info
2372 private static function format_notification_message_html($messagetype, $info, $course, $context, $modulename, $coursemodule, $assignmentname) {
2374 $posthtml = '<p><font face="sans-serif">'.
2375 '<a href="'.$CFG->wwwroot.'/course/view.php?id='.$course->id.'">'.format_string($course->shortname, true, array('context' => $context->get_course_context())).'</a> ->'.
2376 '<a href="'.$CFG->wwwroot.'/mod/assign/index.php?id='.$course->id.'">'.$modulename.'</a> ->'.
2377 '<a href="'.$CFG->wwwroot.'/mod/assign/view.php?id='.$coursemodule->id.'">'.format_string($assignmentname, true, array('context' => $context)).'</a></font></p>';
2378 $posthtml .= '<hr /><font face="sans-serif">';
2379 $posthtml .= '<p>'.get_string($messagetype . 'html', 'assign', $info).'</p>';
2380 $posthtml .= '</font><hr />';
2385 * Message someone about something (static so it can be called from cron)
2387 * @param stdClass $userfrom
2388 * @param stdClass $userto
2389 * @param string $messagetype
2390 * @param string $eventtype
2391 * @param int $updatetime
2392 * @param stdClass $coursemodule
2393 * @param stdClass $context
2394 * @param stdClass $course
2395 * @param string $modulename
2396 * @param string $assignmentname
2399 public static function send_assignment_notification($userfrom, $userto, $messagetype, $eventtype,
2400 $updatetime, $coursemodule, $context, $course,
2401 $modulename, $assignmentname) {
2404 $info = new stdClass();
2405 $info->username = fullname($userfrom, true);
2406 $info->assignment = format_string($assignmentname,true, array('context'=>$context));
2407 $info->url = $CFG->wwwroot.'/mod/assign/view.php?id='.$coursemodule->id;
2408 $info->timeupdated = strftime('%c',$updatetime);
2410 $postsubject = get_string($messagetype . 'small', 'assign', $info);
2411 $posttext = self::format_notification_message_text($messagetype, $info, $course, $context, $modulename, $assignmentname);
2412 $posthtml = ($userto->mailformat == 1) ? self::format_notification_message_html($messagetype, $info, $course, $context, $modulename, $coursemodule, $assignmentname) : '';
2414 $eventdata = new stdClass();
2415 $eventdata->modulename = 'assign';
2416 $eventdata->userfrom = $userfrom;
2417 $eventdata->userto = $userto;
2418 $eventdata->subject = $postsubject;
2419 $eventdata->fullmessage = $posttext;
2420 $eventdata->fullmessageformat = FORMAT_PLAIN;
2421 $eventdata->fullmessagehtml = $posthtml;
2422 $eventdata->smallmessage = $postsubject;
2424 $eventdata->name = $eventtype;
2425 $eventdata->component = 'mod_assign';
2426 $eventdata->notification = 1;
2427 $eventdata->contexturl = $info->url;
2428 $eventdata->contexturlname = $info->assignment;
2430 message_send($eventdata);
2434 * Message someone about something
2436 * @param stdClass $userfrom
2437 * @param stdClass $userto
2438 * @param string $messagetype
2439 * @param string $eventtype
2440 * @param int $updatetime
2443 public function send_notification($userfrom, $userto, $messagetype, $eventtype, $updatetime) {
2444 self::send_assignment_notification($userfrom, $userto, $messagetype, $eventtype, $updatetime, $this->get_course_module(), $this->get_context(), $this->get_course(), $this->get_module_name(), $this->get_instance()->name);
2448 * Notify student upon successful submission
2450 * @global moodle_database $DB
2451 * @param stdClass $submission
2454 private function notify_student_submission_receipt(stdClass $submission) {
2457 $adminconfig = $this->get_admin_config();
2458 if (!$adminconfig->submissionreceipts) {
2459 // No need to do anything
2462 $user = $DB->get_record('user', array('id'=>$submission->userid), '*', MUST_EXIST);
2463 $this->send_notification($user, $user, 'submissionreceipt', 'assign_notification', $submission->timemodified);
2467 * Send notifications to graders upon student submissions
2469 * @global moodle_database $DB
2470 * @param stdClass $submission
2473 private function notify_graders(stdClass $submission) {
2476 $late = $this->get_instance()->duedate && ($this->get_instance()->duedate < time());
2478 if (!$this->get_instance()->sendnotifications && !($late && $this->get_instance()->sendlatenotifications)) { // No need to do anything
2482 $user = $DB->get_record('user', array('id'=>$submission->userid), '*', MUST_EXIST);
2483 if ($teachers = $this->get_graders($user->id)) {
2484 foreach ($teachers as $teacher) {
2485 $this->send_notification($user, $teacher, 'gradersubmissionupdated', 'assign_notification', $submission->timemodified);
2491 * assignment submission is processed before grading
2495 private function process_submit_for_grading() {
2498 // Need submit permission to submit an assignment
2499 require_capability('mod/assign:submit', $this->context);
2502 $submission = $this->get_user_submission($USER->id,true);
2503 if ($submission->status != ASSIGN_SUBMISSION_STATUS_SUBMITTED) {
2504 // Give each submission plugin a chance to process the submission
2505 $plugins = $this->get_submission_plugins();
2506 foreach ($plugins as $plugin) {
2507 $plugin->submit_for_grading();
2510 $submission->status = ASSIGN_SUBMISSION_STATUS_SUBMITTED;
2511 $this->update_submission($submission);
2512 $this->add_to_log('submit for grading', $this->format_submission_for_log($submission));
2513 $this->notify_graders($submission);
2514 $this->notify_student_submission_receipt($submission);
2521 * @global moodle_database $DB
2522 * @return string The result of the save operation
2524 private function process_save_quick_grades() {
2525 global $USER, $DB, $CFG;
2527 // Need grade permission
2528 require_capability('mod/assign:grade', $this->context);
2530 // make sure advanced grading is disabled
2531 $gradingmanager = get_grading_manager($this->get_context(), 'mod_assign', 'submissions');
2532 $controller = $gradingmanager->get_active_controller();
2533 if (!empty($controller)) {
2534 return get_string('errorquickgradingvsadvancedgrading', 'assign');
2538 // first check all the last modified values
2539 $currentgroup = groups_get_activity_group($this->get_course_module(), true);
2540 $participants = $this->list_participants($currentgroup, true);
2542 // gets a list of possible users and look for values based upon that.
2543 foreach ($participants as $userid => $unused) {
2544 $modified = optional_param('grademodified_' . $userid, -1, PARAM_INT);
2545 if ($modified >= 0) {
2546 // gather the userid, updated grade and last modified value
2547 $record = new stdClass();
2548 $record->userid = $userid;
2549 $record->grade = unformat_float(required_param('quickgrade_' . $record->userid, PARAM_TEXT));
2550 $record->lastmodified = $modified;
2551 $record->gradinginfo = grade_get_grades($this->get_course()->id, 'mod', 'assign', $this->get_instance()->id, array($userid));
2552 $users[$userid] = $record;
2555 if (empty($users)) {
2556 // Quick check to see whether we have any users to update and we don't
2557 return get_string('quickgradingchangessaved', 'assign'); // Technical lie
2560 list($userids, $params) = $DB->get_in_or_equal(array_keys($users), SQL_PARAMS_NAMED);
2561 $params['assignment'] = $this->get_instance()->id;
2562 // check them all for currency
2563 $sql = 'SELECT u.id as userid, g.grade as grade, g.timemodified as lastmodified
2565 LEFT JOIN {assign_grades} g ON u.id = g.userid AND g.assignment = :assignment
2566 WHERE u.id ' . $userids;
2567 $currentgrades = $DB->get_recordset_sql($sql, $params);
2569 $modifiedusers = array();
2570 foreach ($currentgrades as $current) {
2571 $modified = $users[(int)$current->userid];
2572 $grade = $this->get_user_grade($userid, false);
2574 // check to see if the outcomes were modified
2575 if ($CFG->enableoutcomes) {
2576 foreach ($modified->gradinginfo->outcomes as $outcomeid => $outcome) {
2577 $oldoutcome = $outcome->grades[$modified->userid]->grade;
2578 $newoutcome = optional_param('outcome_' . $outcomeid . '_' . $modified->userid, -1, PARAM_FLOAT);
2579 if ($oldoutcome != $newoutcome) {
2580 // can't check modified time for outcomes because it is not reported
2581 $modifiedusers[$modified->userid] = $modified;
2587 // let plugins participate
2588 foreach ($this->feedbackplugins as $plugin) {
2589 if ($plugin->is_visible() && $plugin->is_enabled() && $plugin->supports_quickgrading()) {
2590 if ($plugin->is_quickgrading_modified($modified->userid, $grade)) {
2591 if ((int)$current->lastmodified > (int)$modified->lastmodified) {
2592 return get_string('errorrecordmodified', 'assign');
2594 $modifiedusers[$modified->userid] = $modified;
2602 if (($current->grade < 0 || $current->grade === NULL) &&
2603 ($modified->grade < 0 || $modified->grade === NULL)) {
2604 // different ways to indicate no grade
2607 // Treat 0 and null as different values
2608 if ($current->grade !== null) {
2609 $current->grade = floatval($current->grade);
2611 if ($current->grade !== $modified->grade) {
2613 if ($this->grading_disabled($modified->userid)) {
2616 if ((int)$current->lastmodified > (int)$modified->lastmodified) {
2617 // error - record has been modified since viewing the page
2618 return get_string('errorrecordmodified', 'assign');
2620 $modifiedusers[$modified->userid] = $modified;
2625 $currentgrades->close();
2627 // ok - ready to process the updates
2628 foreach ($modifiedusers as $userid => $modified) {
2629 $grade = $this->get_user_grade($userid, true);
2630 $grade->grade= grade_floatval(unformat_float($modified->grade));
2631 $grade->grader= $USER->id;
2633 $this->update_grade($grade);
2635 // save plugins data
2636 foreach ($this->feedbackplugins as $plugin) {
2637 if ($plugin->is_visible() && $plugin->is_enabled() && $plugin->supports_quickgrading()) {
2638 $plugin->save_quickgrading_changes($userid, $grade);
2643 if ($CFG->enableoutcomes) {
2645 foreach ($modified->gradinginfo->outcomes as $outcomeid => $outcome) {
2646 $oldoutcome = $outcome->grades[$modified->userid]->grade;
2647 $newoutcome = optional_param('outcome_' . $outcomeid . '_' . $modified->userid, -1, PARAM_INT);
2648 if ($oldoutcome != $newoutcome) {
2649 $data[$outcomeid] = $newoutcome;
2652 if (count($data) > 0) {
2653 grade_update_outcomes('mod/assign', $this->course->id, 'mod', 'assign', $this->get_instance()->id, $userid, $data);
2657 $this->add_to_log('grade submission', $this->format_grade_for_log($grade));
2660 return get_string('quickgradingchangessaved', 'assign');
2664 * save grading options
2668 private function process_save_grading_options() {
2671 // Include grading options form
2672 require_once($CFG->dirroot . '/mod/assign/gradingoptionsform.php');
2674 // Need submit permission to submit an assignment
2675 require_capability('mod/assign:grade', $this->context);
2677 $mform = new mod_assign_grading_options_form(null, array('cm'=>$this->get_course_module()->id,
2678 'contextid'=>$this->context->id,
2679 'userid'=>$USER->id,
2680 'submissionsenabled'=>$this->is_any_submission_plugin_enabled(),
2681 'showquickgrading'=>false));
2682 if ($formdata = $mform->get_data()) {
2683 set_user_preference('assign_perpage', $formdata->perpage);
2684 set_user_preference('assign_filter', $formdata->filter);
2689 * Take a grade object and print a short summary for the log file.
2690 * The size limit for the log file is 255 characters, so be careful not
2691 * to include too much information.
2693 * @param stdClass $grade
2696 private function format_grade_for_log(stdClass $grade) {
2699 $user = $DB->get_record('user', array('id' => $grade->userid), '*', MUST_EXIST);
2701 $info = get_string('gradestudent', 'assign', array('id'=>$user->id, 'fullname'=>fullname($user)));
2702 if ($grade->grade != '') {
2703 $info .= get_string('grade') . ': ' . $this->display_grade($grade->grade, false) . '. ';
2705 $info .= get_string('nograde', 'assign');
2707 if ($grade->locked) {
2708 $info .= get_string('submissionslocked', 'assign') . '. ';
2714 * Take a submission object and print a short summary for the log file.
2715 * The size limit for the log file is 255 characters, so be careful not
2716 * to include too much information.
2718 * @param stdClass $submission
2721 private function format_submission_for_log(stdClass $submission) {
2723 $info .= get_string('submissionstatus', 'assign') . ': ' . get_string('submissionstatus_' . $submission->status, 'assign') . '. <br>';
2724 // format_for_log here iterating every single log INFO from either submission or grade in every assignment plugin
2726 foreach ($this->submissionplugins as $plugin) {
2727 if ($plugin->is_enabled() && $plugin->is_visible()) {
2730 $info .= "<br>" . $plugin->format_for_log($submission);
2739 * save assignment submission
2741 * @param moodleform $mform
2744 private function process_save_submission(&$mform) {
2747 // Include submission form
2748 require_once($CFG->dirroot . '/mod/assign/submission_form.php');
2750 // Need submit permission to submit an assignment
2751 require_capability('mod/assign:submit', $this->context);
2754 $data = new stdClass();
2755 $mform = new mod_assign_submission_form(null, array($this, $data));
2756 if ($mform->is_cancelled()) {
2759 if ($data = $mform->get_data()) {
2760 $submission = $this->get_user_submission($USER->id, true); //create the submission if needed & its id
2761 $grade = $this->get_user_grade($USER->id, false); // get the grade to check if it is locked
2762 if ($grade && $grade->locked) {
2763 print_error('submissionslocked', 'assign');
2768 foreach ($this->submissionplugins as $plugin) {
2769 if ($plugin->is_enabled()) {
2770 if (!$plugin->save($submission, $data)) {
2771 print_error($plugin->get_error());
2776 $this->update_submission($submission);
2779 $this->add_to_log('submit', $this->format_submission_for_log($submission));
2781 if (!$this->get_instance()->submissiondrafts) {
2782 $this->notify_student_submission_receipt($submission);
2783 $this->notify_graders($submission);
2792 * Determine if this users grade is locked or overridden
2794 * @param int $userid - The student userid
2795 * @return bool $gradingdisabled
2797 public function grading_disabled($userid) {
2800 $gradinginfo = grade_get_grades($this->get_course()->id, 'mod', 'assign', $this->get_instance()->id, array($userid));
2801 if (!$gradinginfo) {
2805 if (!isset($gradinginfo->items[0]->grades[$userid])) {
2808 $gradingdisabled = $gradinginfo->items[0]->grades[$userid]->locked || $gradinginfo->items[0]->grades[$userid]->overridden;
2809 return $gradingdisabled;
2814 * Get an instance of a grading form if advanced grading is enabled
2815 * This is specific to the assignment, marker and student
2817 * @param int $userid - The student userid
2818 * @param bool $gradingdisabled
2819 * @return mixed gradingform_instance|null $gradinginstance
2821 private function get_grading_instance($userid, $gradingdisabled) {
2824 $grade = $this->get_user_grade($userid, false);
2825 $grademenu = make_grades_menu($this->get_instance()->grade);
2827 $advancedgradingwarning = false;
2828 $gradingmanager = get_grading_manager($this->context, 'mod_assign', 'submissions');
2829 $gradinginstance = null;
2830 if ($gradingmethod = $gradingmanager->get_active_method()) {
2831 $controller = $gradingmanager->get_controller($gradingmethod);
2832 if ($controller->is_form_available()) {
2835 $itemid = $grade->id;
2837 if ($gradingdisabled && $itemid) {
2838 $gradinginstance = ($controller->get_current_instance($USER->id, $itemid));
2839 } else if (!$gradingdisabled) {
2840 $instanceid = optional_param('advancedgradinginstanceid', 0, PARAM_INT);
2841 $gradinginstance = ($controller->get_or_create_instance($instanceid, $USER->id, $itemid));
2844 $advancedgradingwarning = $controller->form_unavailable_notification();
2847 if ($gradinginstance) {
2848 $gradinginstance->get_controller()->set_grade_range($grademenu);
2850 return $gradinginstance;
2854 * add elements to grade form
2856 * @param MoodleQuickForm $mform
2857 * @param stdClass $data
2858 * @param array $params
2861 public function add_grade_form_elements(MoodleQuickForm $mform, stdClass $data, $params) {
2863 $settings = $this->get_instance();
2865 $rownum = $params['rownum'];
2866 $last = $params['last'];
2867 $useridlist = $params['useridlist'];
2868 $userid = $useridlist[$rownum];
2869 $grade = $this->get_user_grade($userid, false);
2871 // add advanced grading
2872 $gradingdisabled = $this->grading_disabled($userid);
2873 $gradinginstance = $this->get_grading_instance($userid, $gradingdisabled);
2875 if ($gradinginstance) {
2876 $gradingelement = $mform->addElement('grading', 'advancedgrading', get_string('grade').':', array('gradinginstance' => $gradinginstance));
2877 if ($gradingdisabled) {
2878 $gradingelement->freeze();
2880 $mform->addElement('hidden', 'advancedgradinginstanceid', $gradinginstance->get_id());
2883 // use simple direct grading
2884 if ($this->get_instance()->grade > 0) {
2885 $gradingelement = $mform->addElement('text', 'grade', get_string('gradeoutof', 'assign',$this->get_instance()->grade));
2886 $mform->addHelpButton('grade', 'gradeoutofhelp', 'assign');
2887 $mform->setType('grade', PARAM_TEXT);
2888 if ($gradingdisabled) {
2889 $gradingelement->freeze();
2892 $grademenu = make_grades_menu($this->get_instance()->grade);
2893 if (count($grademenu) > 0) {
2894 $gradingelement = $mform->addElement('select', 'grade', get_string('grade').':', $grademenu);
2895 $mform->setType('grade', PARAM_INT);
2896 if ($gradingdisabled) {
2897 $gradingelement->freeze();
2903 $gradinginfo = grade_get_grades($this->get_course()->id,
2906 $this->get_instance()->id,
2908 if (!empty($CFG->enableoutcomes)) {
2909 foreach($gradinginfo->outcomes as $index=>$outcome) {
2910 $options = make_grades_menu(-$outcome->scaleid);
2911 if ($outcome->grades[$userid]->locked) {
2912 $options[0] = get_string('nooutcome', 'grades');
2913 $mform->addElement('static', 'outcome_'.$index.'['.$userid.']', $outcome->name.':',
2914 $options[$outcome->grades[$userid]->grade]);
2916 $options[''] = get_string('nooutcome', 'grades');
2917 $attributes = array('id' => 'menuoutcome_'.$index );
2918 $mform->addElement('select', 'outcome_'.$index.'['.$userid.']', $outcome->name.':', $options, $attributes );
2919 $mform->setType('outcome_'.$index.'['.$userid.']', PARAM_INT);
2920 $mform->setDefault('outcome_'.$index.'['.$userid.']', $outcome->grades[$userid]->grade );
2925 if (has_all_capabilities(array('gradereport/grader:view', 'moodle/grade:viewall'), $this->get_course_context())) {
2926 $gradestring = $this->output->action_link(new moodle_url('/grade/report/grader/index.php',
2927 array('id'=>$this->get_course()->id)),
2928 $gradinginfo->items[0]->grades[$userid]->str_grade);
2930 $gradestring = $gradinginfo->items[0]->grades[$userid]->str_grade;
2932 $mform->addElement('static', 'finalgrade', get_string('currentgrade', 'assign').':', $gradestring);
2935 $mform->addElement('static', 'progress', '', get_string('gradingstudentprogress', 'assign', array('index'=>$rownum+1, 'count'=>count($useridlist))));
2938 $this->add_plugin_grade_elements($grade, $mform, $data);
2941 $mform->addElement('hidden', 'id', $this->get_course_module()->id);
2942 $mform->setType('id', PARAM_INT);
2943 $mform->addElement('hidden', 'rownum', $rownum);
2944 $mform->setType('rownum', PARAM_INT);
2945 $mform->addElement('hidden', 'useridlist', implode(',', $useridlist));
2946 $mform->setType('useridlist', PARAM_TEXT);
2947 $mform->addElement('hidden', 'ajax', optional_param('ajax', 0, PARAM_INT));
2948 $mform->setType('ajax', PARAM_INT);
2950 $mform->addElement('hidden', 'action', 'submitgrade');
2951 $mform->setType('action', PARAM_ALPHA);
2954 $buttonarray=array();
2955 $buttonarray[] = $mform->createElement('submit', 'savegrade', get_string('savechanges', 'assign'));
2957 $buttonarray[] = $mform->createElement('submit', 'saveandshownext', get_string('savenext','assign'));
2959 $buttonarray[] = $mform->createElement('cancel', 'cancelbutton', get_string('cancel'));
2960 $mform->addGroup($buttonarray, 'buttonar', '', array(' '), false);
2961 $mform->closeHeaderBefore('buttonar');
2962 $buttonarray=array();
2965 $buttonarray[] = $mform->createElement('submit', 'nosaveandprevious', get_string('previous','assign'));
2969 $buttonarray[] = $mform->createElement('submit', 'nosaveandnext', get_string('nosavebutnext', 'assign'));
2971 $mform->addGroup($buttonarray, 'navar', '', array(' '), false);
2976 * add elements in submission plugin form
2978 * @param mixed $submission stdClass|null
2979 * @param MoodleQuickForm $mform
2980 * @param stdClass $data
2983 private function add_plugin_submission_elements($submission, MoodleQuickForm $mform, stdClass $data) {
2984 foreach ($this->submissionplugins as $plugin) {
2985 if ($plugin->is_enabled() && $plugin->is_visible() && $plugin->allow_submissions()) {
2986 $mform->addElement('header', 'header_' . $plugin->get_type(), $plugin->get_name());
2987 if (!$plugin->get_form_elements($submission, $mform, $data)) {
2988 $mform->removeElement('header_' . $plugin->get_type());
2995 * check if feedback plugins installed are enabled
2999 public function is_any_feedback_plugin_enabled() {
3000 if (!isset($this->cache['any_feedback_plugin_enabled'])) {
3001 $this->cache['any_feedback_plugin_enabled'] = false;
3002 foreach ($this->feedbackplugins as $plugin) {
3003 if ($plugin->is_enabled() && $plugin->is_visible()) {
3004 $this->cache['any_feedback_plugin_enabled'] = true;
3010 return $this->cache['any_feedback_plugin_enabled'];
3015 * check if submission plugins installed are enabled
3019 public function is_any_submission_plugin_enabled() {
3020 if (!isset($this->cache['any_submission_plugin_enabled'])) {
3021 $this->cache['any_submission_plugin_enabled'] = false;
3022 foreach ($this->submissionplugins as $plugin) {
3023 if ($plugin->is_enabled() && $plugin->is_visible() && $plugin->allow_submissions()) {
3024 $this->cache['any_submission_plugin_enabled'] = true;
3030 return $this->cache['any_submission_plugin_enabled'];
3035 * add elements to submission form
3036 * @param MoodleQuickForm $mform
3037 * @param stdClass $data
3040 public function add_submission_form_elements(MoodleQuickForm $mform, stdClass $data) {
3043 // online text submissions
3045 $submission = $this->get_user_submission($USER->id, false);
3047 $this->add_plugin_submission_elements($submission, $mform, $data);
3050 $mform->addElement('hidden', 'id', $this->get_course_module()->id);
3051 $mform->setType('id', PARAM_INT);
3053 $mform->addElement('hidden', 'action', 'savesubmission');
3054 $mform->setType('action', PARAM_TEXT);
3061 * Uses url parameter userid
3063 * @param int $userid
3066 private function process_revert_to_draft($userid = 0) {
3069 // Need grade permission
3070 require_capability('mod/assign:grade', $this->context);
3074 $userid = required_param('userid', PARAM_INT);
3077 $submission = $this->get_user_submission($userid, false);
3081 $submission->status = ASSIGN_SUBMISSION_STATUS_DRAFT;
3082 $this->update_submission($submission, false);
3084 // update the modified time on the grade (grader modified)
3085 $grade = $this->get_user_grade($userid, true);
3086 $this->update_grade($grade);
3088 $user = $DB->get_record('user', array('id' => $userid), '*', MUST_EXIST);
3090 $this->add_to_log('revert submission to draft', get_string('reverttodraftforstudent', 'assign', array('id'=>$user->id, 'fullname'=>fullname($user))));
3096 * Uses url parameter userid
3097 * @param int $userid
3100 private function process_lock($userid = 0) {
3103 // Need grade permission
3104 require_capability('mod/assign:grade', $this->context);
3108 $userid = required_param('userid', PARAM_INT);
3111 $grade = $this->get_user_grade($userid, true);
3113 $grade->grader = $USER->id;
3114 $this->update_grade($grade);
3116 $user = $DB->get_record('user', array('id' => $userid), '*', MUST_EXIST);
3118 $this->add_to_log('lock submission', get_string('locksubmissionforstudent', 'assign', array('id'=>$user->id, 'fullname'=>fullname($user))));
3122 * unlock the process
3124 * @param int $userid
3127 private function process_unlock($userid = 0) {
3130 // Need grade permission
3131 require_capability('mod/assign:grade', $this->context);
3135 $userid = required_param('userid', PARAM_INT);
3138 $grade = $this->get_user_grade($userid, true);
3140 $grade->grader = $USER->id;
3141 $this->update_grade($grade);
3143 $user = $DB->get_record('user', array('id' => $userid), '*', MUST_EXIST);
3145 $this->add_to_log('unlock submission', get_string('unlocksubmissionforstudent', 'assign', array('id'=>$user->id, 'fullname'=>fullname($user))));
3149 * save outcomes submitted from grading form
3151 * @param int $userid
3152 * @param stdClass $formdata
3154 private function process_outcomes($userid, $formdata) {
3157 if (empty($CFG->enableoutcomes)) {
3160 if ($this->grading_disabled($userid)) {
3164 require_once($CFG->libdir.'/gradelib.php');
3167 $gradinginfo = grade_get_grades($this->get_course()->id,
3170 $this->get_instance()->id,
3173 if (!empty($gradinginfo->outcomes)) {
3174 foreach($gradinginfo->outcomes as $index=>$oldoutcome) {
3175 $name = 'outcome_'.$index;
3176 if (isset($formdata->{$name}[$userid]) and $oldoutcome->grades[$userid]->grade != $formdata->{$name}[$userid]) {
3177 $data[$index] = $formdata->{$name}[$userid];
3181 if (count($data) > 0) {
3182 grade_update_outcomes('mod/assign', $this->course->id, 'mod', 'assign', $this->get_instance()->id, $userid, $data);
3191 * @param moodleform $mform
3192 * @return bool - was the grade saved
3194 private function process_save_grade(&$mform) {
3195 global $USER, $DB, $CFG;
3196 // Include grade form
3197 require_once($CFG->dirroot . '/mod/assign/gradeform.php');
3199 // Need submit permission to submit an assignment
3200 require_capability('mod/assign:grade', $this->context);
3203 $rownum = required_param('rownum', PARAM_INT);
3204 $useridlist = optional_param('useridlist', '', PARAM_TEXT);
3206 $useridlist = explode(',', $useridlist);
3208 $useridlist = $this->get_grading_userid_list();
3211 $userid = $useridlist[$rownum];
3212 if ($rownum == count($useridlist) - 1) {
3216 $data = new stdClass();
3217 $mform = new mod_assign_grade_form(null, array($this, $data, array('rownum'=>$rownum, 'useridlist'=>$useridlist, 'last'=>false)), 'post', '', array('class'=>'gradeform'));
3219 if ($formdata = $mform->get_data()) {
3220 $grade = $this->get_user_grade($userid, true);
3221 $gradingdisabled = $this->grading_disabled($userid);
3222 $gradinginstance = $this->get_grading_instance($userid, $gradingdisabled);
3223 if (!$gradingdisabled) {
3224 if ($gradinginstance) {
3225 $grade->grade = $gradinginstance->submit_and_get_grade($formdata->advancedgrading, $grade->id);
3227 // handle the case when grade is set to No Grade
3228 if (isset($formdata->grade)) {
3229 $grade->grade = grade_floatval(unformat_float($formdata->grade));
3233 $grade->grader= $USER->id;
3235 $adminconfig = $this->get_admin_config();
3236 $gradebookplugin = $adminconfig->feedback_plugin_for_gradebook;
3238 // call save in plugins
3239 foreach ($this->feedbackplugins as $plugin) {
3240 if ($plugin->is_enabled() && $plugin->is_visible()) {
3241 if (!$plugin->save($grade, $formdata)) {
3243 print_error($plugin->get_error());
3245 if (('assignfeedback_' . $plugin->get_type()) == $gradebookplugin) {
3246 // this is the feedback plugin chose to push comments to the gradebook
3247 $grade->feedbacktext = $plugin->text_for_gradebook($grade);
3248 $grade->feedbackformat = $plugin->format_for_gradebook($grade);
3252 $this->process_outcomes($userid, $formdata);
3256 $this->update_grade($grade);
3258 $user = $DB->get_record('user', array('id' => $userid), '*', MUST_EXIST);
3260 $this->add_to_log('grade submission', $this->format_grade_for_log($grade));
3270 * This function is a static wrapper around can_upgrade
3272 * @param string $type The plugin type
3273 * @param int $version The plugin version
3276 public static function can_upgrade_assignment($type, $version) {
3277 $assignment = new assign(null, null, null);
3278 return $assignment->can_upgrade($type, $version);
3282 * This function returns true if it can upgrade an assignment from the 2.2
3284 * @param string $type The plugin type
3285 * @param int $version The plugin version
3288 public function can_upgrade($type, $version) {
3289 if ($type == 'offline' && $version >= 2011112900) {
3292 foreach ($this->submissionplugins as $plugin) {
3293 if ($plugin->can_upgrade($type, $version)) {
3297 foreach ($this->feedbackplugins as $plugin) {
3298 if ($plugin->can_upgrade($type, $version)) {
3306 * Copy all the files from the old assignment files area to the new one.
3307 * This is used by the plugin upgrade code.
3309 * @param int $oldcontextid The old assignment context id
3310 * @param int $oldcomponent The old assignment component ('assignment')
3311 * @param int $oldfilearea The old assignment filearea ('submissions')
3312 * @param int $olditemid The old submissionid (can be null e.g. intro)
3313 * @param int $newcontextid The new assignment context id
3314 * @param int $newcomponent The new assignment component ('assignment')
3315 * @param int $newfilearea The new assignment filearea ('submissions')
3316 * @param int $newitemid The new submissionid (can be null e.g. intro)
3317 * @return int The number of files copied
3319 public function copy_area_files_for_upgrade($oldcontextid, $oldcomponent, $oldfilearea, $olditemid, $newcontextid, $newcomponent, $newfilearea, $newitemid) {
3320 // Note, this code is based on some code in filestorage - but that code
3321 // deleted the old files (which we don't want)
3324 $fs = get_file_storage();
3326 $oldfiles = $fs->get_area_files($oldcontextid, $oldcomponent, $oldfilearea, $olditemid, 'id', false);
3327 foreach ($oldfiles as $oldfile) {
3328 $filerecord = new stdClass();
3329 $filerecord->contextid = $newcontextid;
3330 $filerecord->component = $newcomponent;
3331 $filerecord->filearea = $newfilearea;
3332 $filerecord->itemid = $newitemid;
3333 $fs->create_file_from_storedfile($filerecord, $oldfile);
3341 * Get an upto date list of user grades and feedback for the gradebook
3343 * @param int $userid int or 0 for all users
3344 * @return array of grade data formated for the gradebook api
3345 * The data required by the gradebook api is userid,
3353 public function get_user_grades_for_gradebook($userid) {
3356 $assignmentid = $this->get_instance()->id;
3358 $adminconfig = $this->get_admin_config();
3359 $gradebookpluginname = $adminconfig->feedback_plugin_for_gradebook;
3360 $gradebookplugin = null;
3362 // find the gradebook plugin
3363 foreach ($this->feedbackplugins as $plugin) {
3364 if ($plugin->is_enabled() && $plugin->is_visible()) {
3365 if (('assignfeedback_' . $plugin->get_type()) == $gradebookpluginname) {
3366 $gradebookplugin = $plugin;
3371 $where = ' WHERE u.id = ? ';
3373 $where = ' WHERE u.id != ? ';
3376 $graderesults = $DB->get_recordset_sql('SELECT u.id as userid, s.timemodified as datesubmitted, g.grade as rawgrade, g.timemodified as dategraded, g.grader as usermodified
3378 LEFT JOIN {assign_submission} s ON u.id = s.userid and s.assignment = ?
3379 LEFT JOIN {assign_grades} g ON u.id = g.userid and g.assignment = ?
3380 ' . $where, array($assignmentid, $assignmentid, $userid));
3383 foreach ($graderesults as $result) {
3384 $gradebookgrade = clone $result;
3385 // now get the feedback
3386 if ($gradebookplugin) {
3387 $grade = $this->get_user_grade($result->userid, false);
3389 $gradebookgrade->feedbacktext = $gradebookplugin->text_for_gradebook($grade);
3390 $gradebookgrade->feedbackformat = $gradebookplugin->format_for_gradebook($grade);
3393 $grades[$gradebookgrade->userid] = $gradebookgrade;
3396 $graderesults->close();