gradeimporter/libs/student_viewlib.php

<?php
// This file is part of
//
// 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/>.
function query_feedbacks($cmid, $gradeimporterid) {
    global $DB, $USER, $CFG;

    // Get moodle table prefix, usually 'mdl_'
    $tp = $CFG->prefix;

    // Build database query to fetch feedbacks for the student
    $query = " SELECT
                gst.name as typename,
                gst.id as typeid,
                gst.description as typedescription,
                gf.id as id,
                gs.name as submissionname,
                gs.id as submissionid,
                gf.grade as grade,
                gf.comment as comment,
                gf.name as filename,
                gs.description as submissiondescription,
                gs.position as position
                FROM {$tp}gradeimporter_feedback as gf
                JOIN {$tp}gradeimporter_submission as gs
                    ON gf.submissionid = gs.id
                JOIN {$tp}gradeimporter_submissiontype as gst
                    ON gs.type = gst.id
                WHERE gs.gradeimporterid = {$gradeimporterid}
                    AND gf.studentid = {$USER->id}
                    AND gs.visibility = 1
            ";
    // Query database to find students feedbacks
    $records = $DB->get_records_sql($query);

    // Return query result
    return $records;
}

function make_feedback_table ($feedbacks, $cmid) {
    $table = new html_table();
    $table->head = array(get_string('type', 'gradeimporter'),
                    get_string('submission', 'gradeimporter'),
                    get_string('grade', 'gradeimporter'),
                    get_string('comment', 'gradeimporter'),
                    get_string('file', 'gradeimporter')
                );
    $table->aling = array('center', 'center', 'center', 'center', 'center');
    $table->attributes = array('class' => 'generaltable mod_index');

    if (count($feedbacks)) {
        // If feedbacks is not an empty list
        foreach ($feedbacks as $type => $feedback) {
            $rowvalues = array('type_name',
                                $feedback->submissionname,
                                $feedback->grade,
                                $feedback->comment,
                                get_file($feedback, $cmid)
                            );

            $row = new html_table_row($rowvalues);
            $table->data[] = $row;
        }
    }
    echo html_writer::table($table);
}

function get_file ($feedback, $cmid) {

    $context = context_module::instance($cmid);

    $url = moodle_url::make_pluginfile_url($context->id,
                                            'mod_gradeimporter',
                                            'submissionfiles',
                                            0,
                                            "/",
                                            $feedback->filename,
                                            true
                                        );

    // Return pluginfile url, will use function mod_gradeimporter_pluginfile at lib.php to serve the file
    return "<a href='{$url}'>$feedback->filename</a>";

}