芝麻web文件管理V1.00

编辑当前文件:/home2/sdektunc/public_html/cepali/mod/assignment/tests/privacy_test.php

<?php
// This file is part of 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/>.

/**
 * Privacy test for the event monitor
 *
 * @package mod_assignment
 * @category test
 * @copyright 2018 Zig Tan <zig@moodle.com>
 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

defined('MOODLE_INTERNAL') || die();

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

use \mod_assignment\privacy\provider;
use \core_privacy\local\metadata\collection;
use \core_privacy\local\request\approved_contextlist;
use \core_privacy\local\request\transform;
use \core_privacy\local\request\writer;
use \core_privacy\tests\provider_testcase;

/**
     * @var int array   Array of test student ids associated for Course 1.
     */
    private $course1students = [];

/**
     * @var int array   Array of test student ids associated for Course 2.
     */
    private $course2students = [];

/**
     * @var int array   Array of test assignments associated for Course 1.
     */
    private $course1assignments = [];

/**
     * @var int array   Array of test assignments associated for Course 2.
     */
    private $course2assignments = [];

/**
     * Test for provider::get_contexts_for_userid().
     *
     * @throws coding_exception
     */
    public function test_get_contexts_for_userid() {
        global $DB;

$this->resetAfterTest(true);
        $this->create_courses_and_assignments();

// Get Teacher 1 to test get_contexts_for_userid().
        $teacher1 = $DB->get_record('user', ['username' => 'teacher1']);
        $contextids = provider::get_contexts_for_userid($teacher1->id);
        // Verify there should be 4 contexts, as Teacher 1 has submitted tests and marked Assignments in Course 1 and 2.
        $this->assertEquals(4, count($contextids->get_contextids()));

// Get Teacher 2 to test get_contexts_for_userid().
        $teacher2 = $DB->get_record('user', ['username' => 'teacher2']);
        $contextids = provider::get_contexts_for_userid($teacher2->id);
        // Verify there should be 0 contexts, as teacher 2 has not marked any Assignments.
        $this->assertEquals(0, count($contextids->get_contextids()));

// Get Student 1 to test get_contexts_for_userid().
        $student1 = $DB->get_record('user', ['username' => 'student1']);
        $contextids = provider::get_contexts_for_userid($student1->id);
        // Verify there should be 2 contexts, as student 1 added submissions for both Assignments in Course 1.
        $this->assertEquals(2, count($contextids->get_contextids()));

// Get Student 2 to test get_contexts_for_userid().
        $student2 = $DB->get_record('user', ['username' => 'student2']);
        $contextids = provider::get_contexts_for_userid($student2->id);
        // Verify there should be 2 context, as student 2 added submissions for both Assignments in Course 2.
        $this->assertEquals(2, count($contextids->get_contextids()));
    }

/**
     * Test that the correct userids are returned for a specific context.
     */
    public function test_get_users_in_context() {

$this->resetAfterTest(true);

$student1 = $this->getDataGenerator()->create_user(['username' => 'student1']);
        $student2 = $this->getDataGenerator()->create_user(['username' => 'student2']);
        // Student 3 should not turn up in the results of this test.
        $student3 = $this->getDataGenerator()->create_user(['username' => 'student3']);
        $teacher1 = $this->getDataGenerator()->create_user(['username' => 'teacher1']);

$course = $this->getDataGenerator()->create_course();
        $course1assignment1 = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course->id,
                'name' => 'Course 1 - Assignment 1 (onlinetext)',
                'assignmenttype' => 'onlinetext',
            ]
        );
        // Create a second assignment in the same course.
        $course1assignment2 = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course->id,
                'name' => 'Course 1 - Assignment 1 (onlinetext)',
                'assignmenttype' => 'onlinetext',
            ]
        );

$this->add_assignment_submission(
            $course1assignment1,
            $student1,
            "Course 1 - Ass 1: Student1 Test Submission"
        );

$this->add_assignment_submission(
            $course1assignment1,
            $student2,
            "Course 1 - Ass 1: Student2 Test Submission"
        );
        // Add a submission for the second assignment.
        $this->add_assignment_submission(
            $course1assignment2,
            $student3,
            "Course 1 - Ass 2: Student3 Test Submission"
        );

$submissions = $this->get_course_assignment_submissions($course->id);
        foreach ($submissions as $submission) {
            $this->mark_assignment_submission($submission->assignment, $submission->id, $teacher1, 50);
        }

$c1ass1ctx = context_module::instance($course1assignment1->cmid);
        $userlist = new \core_privacy\local\request\userlist($c1ass1ctx, 'mod_assignment');

provider::get_users_in_context($userlist);
        $userids = $userlist->get_userids();

// This is both students and the teacher who marked both assignments.
        $this->assertCount(3, $userids);
        // Make sure that student 3 is not in the returned userids.
        $this->assertFalse(in_array($student3->id, $userids));
        // Try with the course context.
        $coursecontext = context_course::instance($course->id);
        $userlist = new \core_privacy\local\request\userlist($coursecontext, 'mod_assignment');
        provider::get_users_in_context($userlist);
        $this->assertEmpty($userlist->get_userids());
    }

/**
     * Test for provider::export_user_data().
     *
     * @throws coding_exception
     */
    public function test_export_user_data_teacher() {
        global $DB;

$this->resetAfterTest(true);
        $this->create_courses_and_assignments();

// Test Teacher 1 export_data_for_user() - marking assignment submissions for both Course 1 and 2.
        $teacher1 = $DB->get_record('user', ['username' => 'teacher1']);

$contextlist = provider::get_contexts_for_userid($teacher1->id);
        $approvedcontextlist = new approved_contextlist($teacher1, 'mod_assignment', $contextlist->get_contextids());

// Verify Teacher 1 has four contexts.
        $this->assertCount(4, $contextlist->get_contextids());

// Retrieve Assignment Submissions data for Teacher 1.
        provider::export_user_data($approvedcontextlist);

$contexts = $contextlist->get_contexts();

// Context 1 - Course 1's Assignment 1 -- (onlinetext).
        $context = context_module::instance($this->course1assignments['ass1']->cmid);
        $this->assertContains($context, $contexts);

$writer = writer::with_context($context);
 $subcontexts = [
 get_string('privacy:markedsubmissionspath', 'mod_assignment'),
 transform::user($teacher1->id)
 ];
 // Verify the test assignment submission from Teacher 1 exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals('Course 1 - Ass 1: Teacher Test Submission', $submission->data1);

foreach ($this->course1students as $student) {
 $subcontexts = [
 get_string('privacy:markedsubmissionspath', 'mod_assignment'),
 transform::user($student->id)
 ];
 // Verify the student assignment submissions exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 1 - Ass 1: " . $student->id . "", $submission->data1);
 }

// Context 2 - Course 1's Assignment 2 -- (single file upload).
        $context = context_module::instance($this->course1assignments['ass2']->cmid);
        $this->assertContains($context, $contexts);

$writer = writer::with_context($context);
 foreach ($this->course1students as $student) {
 $subcontexts = [
 get_string('privacy:markedsubmissionspath', 'mod_assignment'),
 transform::user($student->id)
 ];
 // Verify the student assignment submissions exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 1 - Ass 2: " . $student->id . "", $submission->data1);

// Context 3 - Course 2's Assignment 1 -- (offline).
        $context = context_module::instance($this->course2assignments['ass1']->cmid);
        $this->assertContains($context, $contexts);

$writer = writer::with_context($context);
 foreach ($this->course2students as $student) {
 $subcontexts = [
 get_string('privacy:markedsubmissionspath', 'mod_assignment'),
 transform::user($student->id)
 ];
 // Verify the student assignment submissions exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 2 - Ass 1: " . $student->id . "", $submission->data1);
 }

// Context 4 - Course 2's Assignment 2 -- (multiple file upload).
        $context = context_module::instance($this->course2assignments['ass2']->cmid);
        $this->assertContains($context, $contexts);

// Verify the student assignment submission file upload exists.
            $submissionfiles = $writer->get_files($subcontexts);
            $this->assertTrue(array_key_exists('Student' . $student->id . '-Course2-Ass2-(File 1 of 2)', $submissionfiles));
            $this->assertTrue(array_key_exists('Student' . $student->id . '-Course2-Ass2-(File 2 of 2)', $submissionfiles));
        }
    }

/**
     * Test for provider::export_user_data().
     *
     * @throws dml_exception
     */
    public function test_export_user_data_student() {
        global $DB;

$this->resetAfterTest(true);
        $this->create_courses_and_assignments();

// Test Student 1 export_data_for_user() - added assignment submissions for both assignments in Course 1.
        $student1 = $DB->get_record('user', ['username' => 'student1']);

$contextlist = provider::get_contexts_for_userid($student1->id);
        $approvedcontextlist = new approved_contextlist($student1, 'mod_assignment', $contextlist->get_contextids());

// Retrieve Assignment Submissions data for Student 1.
        provider::export_user_data($approvedcontextlist);
        $contexts = $contextlist->get_contexts();

// Context 1 - Course 1's Assignment 1 -- (onlinetext).
        $context = context_module::instance($this->course1assignments['ass1']->cmid);
        $this->assertContains($context, $contexts);

$writer = writer::with_context($context);
        $subcontexts = [
            get_string('privacy:submissionpath', 'mod_assignment')
        ];

// Verify the student assignment submissions exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 1 - Ass 1: " . $student1->id . "", $submission->data1);

$writer = writer::with_context($context);
        $subcontexts = [
            get_string('privacy:submissionpath', 'mod_assignment')
        ];

// Verify the student assignment submission exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 1 - Ass 2: " . $student1->id . "", $submission->data1);

// Test Student 2 export_data_for_user() - added assignment submissions for both assignments in Course 2.
        $student2 = $DB->get_record('user', ['username' => 'student2']);

$contextlist = provider::get_contexts_for_userid($student2->id);
        $approvedcontextlist = new approved_contextlist($student2, 'mod_assignment', $contextlist->get_contextids());

// Retrieve Assignment Submissions data for Student 2.
        provider::export_user_data($approvedcontextlist);
        $contexts = $contextlist->get_contexts();

// Context 1 - Course 2's Assignment 1 -- (offline).
        $context = context_module::instance($this->course2assignments['ass1']->cmid);
        $this->assertContains($context, $contexts);

$writer = writer::with_context($context);
        $subcontexts = [
            get_string('privacy:submissionpath', 'mod_assignment')
        ];

// Verify the student assignment submissions exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 2 - Ass 1: " . $student2->id . "", $submission->data1);

// Context 2 - Course 2's Assignment 2 -- (multiple file upload).
        $context = context_module::instance($this->course2assignments['ass2']->cmid);
        $this->assertContains($context, $contexts);

$writer = writer::with_context($context);
        $subcontexts = [
            get_string('privacy:submissionpath', 'mod_assignment')
        ];

// Verify the student assignment submission exists.
 $submission = $writer->get_data($subcontexts);
 $this->assertEquals("Course 2 - Ass 2: " . $student2->id . "", $submission->data1);

// Verify the student assignment submission file upload exists.
        $submissionfiles = $writer->get_files($subcontexts);
        $this->assertTrue(array_key_exists('Student' . $student2->id . '-Course2-Ass2-(File 1 of 2)', $submissionfiles));
        $this->assertTrue(array_key_exists('Student' . $student2->id . '-Course2-Ass2-(File 2 of 2)', $submissionfiles));
    }

/**
     * Test for provider::delete_data_for_all_users_in_context().
     *
     * @throws dml_exception
     */
    public function test_delete_data_for_all_users_in_context() {
        global $DB;

$this->resetAfterTest(true);
        $this->create_courses_and_assignments();

// Test teacher1 delete_data_for_all_users_in_context().
        $teacher1 = $DB->get_record('user', ['username' => 'teacher1']);
        $contextlist = provider::get_contexts_for_userid($teacher1->id);

foreach ($contextlist as $context) {
            provider::delete_data_for_all_users_in_context($context);

// Verify assignment submission(s) were deleted for the context.
            $deleted = $this->get_assignment_submissions($context->id);
            $this->assertCount(0, $deleted);

// Verify all the file submissions associated with the context for all users were deleted.
            $files = $DB->get_records('files', ['component' => 'mod_assignment', 'filearea' => 'submission', 'contextid' => $context->id]);
            $this->assertEquals(0, count($files));
        }
    }

/**
     * Test for provider::delete_data_for_user().
     *
     * @throws dml_exception
     */
    public function test_delete_data_for_user() {
        global $DB;

$this->resetAfterTest(true);
        $this->create_courses_and_assignments();

// Test Teacher 1 delete_data_for_user(), should only remove the 1 test submission added by Teacher 1.
        // Should not remove any assignment submission records marked by the teacher.
        $teacher1 = $DB->get_record('user', ['username' => 'teacher1']);
        $contextlist = provider::get_contexts_for_userid($teacher1->id);
        $approvedcontextlist = new approved_contextlist($teacher1, 'mod_assignment', $contextlist->get_contextids());
        provider::delete_data_for_user($approvedcontextlist);

// Verify the submissions submitted by students still exists.
        $markedsubmissions = $DB->get_records('assignment_submissions', ['teacher' => $teacher1->id]);
        $this->assertCount(4, $markedsubmissions);

// Test student 1 delete_data_for_user().
        $student1 = $DB->get_record('user', ['username' => 'student1']);
        $contextlist = provider::get_contexts_for_userid($student1->id);
        $approvedcontextlist = new approved_contextlist($student1, 'mod_assignment', $contextlist->get_contextids());
        provider::delete_data_for_user($approvedcontextlist);

// Verify student 1's assignment submissions were deleted.
        $assignmentsubmissions = $DB->get_records('assignment_submissions', ['userid' => $student1->id]);
        $this->assertEquals(0, count($assignmentsubmissions));

// Verify student 1's file submissions were deleted.
        foreach ($contextlist->get_contextids() as $contextid) {
            $files = $DB->get_records('files', ['component' => 'mod_assignment', 'filearea' => 'submission', 'contextid' => $contextid]);
            $this->assertEquals(0, count($files));
        }
    }

/**
     * Test the deletion of a data for users.
     */
    public function test_delete_data_for_users() {
        global $DB;
        $this->resetAfterTest();

$course = $this->getDataGenerator()->create_course();
        $course1assignment = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course->id,
                'name' => 'Course 1 - Assignment 1 (single file upload)',
                'assignmenttype' => 'uploadsingle'
            ]
        );
        $context = context_module::instance($course1assignment->cmid);

// Student one submission.
        $this->add_file_assignment_submission(
            $course1assignment,
            $student1,
            "Course 1 - Ass 2: " . $student1->id,
            'Student' . $student1->id . '-Course1-Ass2'
        );
        // Student two submission.
        $this->add_file_assignment_submission(
            $course1assignment,
            $student2,
            "Course 1 - Ass 2: " . $student2->id,
            'Student' . $student2->id . '-Course1-Ass2'
        );
        // Student three submission to be retained.
        $this->add_file_assignment_submission(
            $course1assignment,
            $student3,
            "Course 1 - Ass 2: " . $student3->id,
            'Student' . $student3->id . '-Course1-Ass2'
        );

$files = $DB->get_records('files', [
            'component' => 'mod_assignment',
            'filearea' => 'submission',
            'contextid' => $context->id
        ]);
        $this->assertCount(6, $files);

$submissions = $this->get_assignment_submissions($context->id);
        $this->assertCount(3, $submissions);

$userlist = new \core_privacy\local\request\approved_userlist($context, 'mod_assignment', [$student1->id, $student2->id]);
        provider::delete_data_for_users($userlist);

$files = $DB->get_records('files', [
            'component' => 'mod_assignment',
            'filearea' => 'submission',
            'contextid' => $context->id
        ]);
        $this->assertCount(2, $files);

$submissions = $this->get_assignment_submissions($context->id);
        $this->assertCount(1, $submissions);
    }

// Start of helper functions.

/**
     * Helper function to setup Course, users, and assignments for testing.
     */
    protected function create_courses_and_assignments() {
        // Create Courses, Users, and Assignments.
        $course1 = $this->getDataGenerator()->create_course(['shortname' => 'course1']);
        $course2 = $this->getDataGenerator()->create_course(['shortname' => 'course2']);

$teacher1 = $this->getDataGenerator()->create_user(['username' => 'teacher1']);
        $teacher2 = $this->getDataGenerator()->create_user(['username' => 'teacher2']);

$student1 = $this->getDataGenerator()->create_user(['username' => 'student1']);
        $student2 = $this->getDataGenerator()->create_user(['username' => 'student2']);

$this->course1students = [
            $student1
        ];

$this->course2students = [
            $student2
        ];

$course1assignment1 = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course1->id,
                'name' => 'Course 1 - Assignment 1 (onlinetext)',
                'assignmenttype' => 'onlinetext',
            ]
        );
        $course1assignment2 = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course1->id,
                'name' => 'Course 1 - Assignment 2 (single file upload)',
                'assignmenttype' => 'uploadsingle',
            ]
        );

$this->course1assignments = [
            'ass1' => $course1assignment1,
            'ass2' => $course1assignment2
        ];

$course2assignment1 = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course2->id,
                'name' => 'Course 2 - Assignment 1 (offline)',
                'assignmenttype' => 'offline',
            ]
        );
        $course2assignment2 = $this->getDataGenerator()->create_module('assignment',
            [
                'course' => $course2->id,
                'name' => 'Course 2 - Assignment 2 (multiple file upload)',
                'assignmenttype' => 'upload',
            ]
        );

$this->course2assignments = [
            'ass1' => $course2assignment1,
            'ass2' => $course2assignment2
        ];

// Teacher 1 add test assignment submission for Course 1 - Assignment 1.
        $this->add_assignment_submission(
            $course1assignment1,
            $teacher1,
            "Course 1 - Ass 1: Teacher Test Submission"
        );

// Student 1 add assignment submissions for Course 1 - Assignment 1 and 2.
        $this->add_assignment_submission(
            $course1assignment1,
            $student1,
            "Course 1 - Ass 1: " . $student1->id
        );
        $this->add_file_assignment_submission(
            $course1assignment2,
            $student1,
            "Course 1 - Ass 2: " . $student1->id,
            'Student' . $student1->id . '-Course1-Ass2'
        );

// Student 2 add assignment submissions for Course 2 - Assignment 1 and 2.
        $this->add_assignment_submission(
            $course2assignment1,
            $student2,
            "Course 2 - Ass 1: " . $student2->id
        );
        $this->add_file_assignment_submission(
            $course2assignment2,
            $student2,
            "Course 2 - Ass 2: " . $student2->id,
            'Student' . $student2->id . '-Course2-Ass2',
            2
        );

// Teacher 1 to mark assignment submissions for Course 1's Assignment 1 and 2.
        $course1submissions = $this->get_course_assignment_submissions($course1->id);
        foreach ($course1submissions as $submission) {
            $this->mark_assignment_submission($submission->assignment, $submission->id, $teacher1, 49);
        }

// Teacher 1 to mark assignment submissions for Course 2's Assignment 1 and 2.
        $course2submissions = $this->get_course_assignment_submissions($course2->id);
        foreach ($course2submissions as $submission) {
            $this->mark_assignment_submission($submission->assignment, $submission->id, $teacher1, 50);
        }
    }

/**
     * Helper function to add an assignment submission for testing.
     *
     * @param object $assignment        Object containing assignment submission details to create for testing.
     * @param object $user              Object of the user making the assignment submission.
     * @param string $submissiondata    The onlintext string value of the assignment submission.
     * @throws dml_exception
     */
    protected function add_assignment_submission($assignment, $user, $submissiondata) {
        global $DB;

$submission = (object) [
 'assignment' => $assignment->id,
 'userid' => $user->id,
 'timecreated' => date('U'),
 'data1' => '' . $submissiondata . '',
 'submissioncomment' => 'My submission by ' . $user->username
 ];

return $DB->insert_record('assignment_submissions', $submission);
    }

/**
     * Helper function to add an assignment submission with file submissions for testing.
     *
     * @param object $assignment        Object containing assignment submission details to create for testing.
     * @param object $user              Object of the user making the assignment submission.
     * @param string $submissiondata    The onlintext string value of the assignment submission.
     * @param string $filename          The filename of the file submission included with the assignment submission.
     * @param int $numfiles             The number of files included with the assignment submission.
     * @throws dml_exception
     * @throws file_exception
     * @throws stored_file_creation_exception
     */
    protected function add_file_assignment_submission($assignment, $user, $submissiondata, $filename, $numfiles = 1) {
        global $CFG, $DB;

$submission = (object) [
 'assignment' => $assignment->id,
 'userid' => $user->id,
 'timecreated' => date('U'),
 'data1' => '' . $submissiondata . '',
 'numfiles' => $numfiles,
 'submissioncomment' => 'My submission by ' . $user->username
 ];

$submissionid = $DB->insert_record('assignment_submissions', $submission);

// Create a file submission with the test pdf.
        $this->setUser($user->id);
        $context = context_module::instance($assignment->cmid);

$fs = get_file_storage();
        $sourcefile = $CFG->dirroot . '/mod/assign/feedback/editpdf/tests/fixtures/submission.pdf';

for ($f = 1; $f <= $numfiles; $f++) {
 $pdfsubmission = (object)array(
 'contextid' => $context->id,
 'component' => 'mod_assignment',
 'filearea' => 'submission',
 'itemid' => $submissionid,
 'filepath' => '/',
 'filename' => $filename . "-(File $f of $numfiles)"
 );
 $fs->create_file_from_pathname($pdfsubmission, $sourcefile);
 }
 }

/**
     * Helper function to retrieve the assignment submission records for a given course.
     *
     * @param int $courseid     The course ID to get assignment submissions by.
     * @return array            Array of assignment submission details.
     * @throws dml_exception
     */
    protected function get_course_assignment_submissions($courseid) {
        global $DB;

$sql = "SELECT s.id,
                       s.assignment,
                       s.userid,
                       s.timecreated,
                       s.timemodified,
                       s.numfiles,
                       s.data1,
                       s.data2,
                       s.grade,
                       s.submissioncomment,
                       s.format,
                       s.teacher,
                       s.timemarked,
                       s.mailed
                  FROM {assignment} a
                  JOIN {assignment_submissions} s ON s.assignment = a.id
                 WHERE a.course = :courseid";
        $params = [
            'courseid' => $courseid
        ];

return $DB->get_records_sql($sql, $params);
    }

/**
     * Helper function to update an assignment submission with grading details for a teacher.
     *
     * @param int $assignmentid     The assignment ID to update assignment submissions with marking/graded details.
     * @param int $submissionid     The assignment submission ID to update with marking/grading details.
     * @param int $teacher          The teacher user ID to making the marking/grading details.
     * @param int $gradedata        The grade value set for the marking/grading details.
     */
    protected function mark_assignment_submission($assignmentid, $submissionid, $teacher, $gradedata) {
        global $DB;

$submission = (object) [
            'id' => $submissionid,
            'assignment' => $assignmentid,
            'grade' => $gradedata,
            'teacher' => $teacher->id,
            'timemarked' => date('U')
        ];

return $DB->update_record('assignment_submissions', $submission);
    }

/**
     * Helper function to retrieve the assignment records for a given context.
     *
     * @param int $contextid    The context module ID value to retrieve assignment IDs by.
     * @return array            Array of assignment IDs.
     * @throws dml_exception
     */
    protected function get_assignments($contextid) {
        global $DB;

$sql = "SELECT a.id
                  FROM {assignment} a
                  JOIN {course_modules} cm ON a.id = cm.instance
                  JOIN {modules} m ON m.id = cm.module AND m.name = :modulename
                  JOIN {context} ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = :contextmodule
                 WHERE ctx.id = :contextid";
        $params = [
            'modulename' => 'assignment',
            'contextmodule' => CONTEXT_MODULE,
            'contextid' => $contextid
        ];

return $DB->get_records_sql($sql, $params);
    }

/**
     * Helper function to retrieve the assignment submission records for a given context.
     *
     * @param int $contextid    The context module ID value to retrieve assignment submission IDs by.
     * @return array            Array of assignment submission IDs.
     * @throws dml_exception
     */
    protected function get_assignment_submissions($contextid) {
        global $DB;

$sql = "SELECT s.id
                  FROM {assignment_submissions} s
                  JOIN {assignment} a ON a.id = s.assignment
                  JOIN {course_modules} cm ON a.id = cm.instance
                  JOIN {modules} m ON m.id = cm.module AND m.name = :modulename
                  JOIN {context} ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = :contextmodule
                 WHERE ctx.id = :contextid";
        $params = [
            'modulename' => 'assignment',
            'contextmodule' => CONTEXT_MODULE,
            'contextid' => $contextid
        ];

return $DB->get_records_sql($sql, $params);
    }
}