release.php

<?php
// This file is part of a 3rd party created module for Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.

/**
 * Release grades.
 *
 * @package    mod_peerwork
 * @copyright  2019 Coventry University
 * @author     Frédéric Massart <fred@branchup.tech>
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

use mod_peerwork\event\grades_released;

require_once(__DIR__ . '/../../config.php');
require_once(__DIR__ . '/locallib.php');
require_once(__DIR__ . '/lib.php');

$id = required_param('id', PARAM_INT);
$groupid = required_param('groupid', PARAM_INT);

[$course, $cm] = get_course_and_cm_from_cmid($id, 'peerwork');
$context = context_module::instance($cm->id);

require_login($course, false, $cm);
require_sesskey();
require_capability('mod/peerwork:grade', $context);

$PAGE->set_url('/mod/peerwork/release.php', ['id' => $cm->id, 'groupid' => $groupid]);

$peerwork = $DB->get_record('peerwork', ['id' => $cm->instance], '*', MUST_EXIST);

if ($groupid > 0) {
    $sql = 'peerworkid = :peerworkid AND groupid = :groupid AND COALESCE(timegraded) > 0 AND released = 0';
    $submissions = $DB->get_records_select('peerwork_submission', $sql, [
        'peerworkid' => $peerwork->id,
        'groupid' => $groupid,
    ]);
} else {
    $sql = 'peerworkid = :peerworkid AND COALESCE(timegraded) > 0 AND released = 0';
    $submissions = $DB->get_records_select('peerwork_submission', $sql, ['peerworkid' => $peerwork->id]);
}

foreach ($submissions as $submission) {

    // Release the submission.
    $submission->released = time();
    $submission->releasedby = $USER->id;
    $DB->update_record('peerwork_submission', $submission);

    // Trigger the event.
    $params = [
        'objectid' => $submission->id,
        'context' => $context,
        'other' => [
            'groupid' => $submission->groupid,
        ],
    ];
    $event = grades_released::create($params);
    $event->add_record_snapshot('peerwork_submission', $submission);
    $event->trigger();
}

// Trigger the gradebook update.
peerwork_update_grades($peerwork);

redirect(new moodle_url('/mod/peerwork/view.php', ['id' => $cm->id]));