Proyectos de Subversion Moodle

<?php

// This file is part of Moodle - https://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 <https://www.gnu.org/licenses/>.

namespace tool_courserating\output;

use tool_courserating\helper;

use tool_courserating\permission;

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

require_once($CFG->libdir.'/tablelib.php');

/**

 * Course ratings list for Moodle 3.11 (before report builder)

 *

 * TODO remove when the minimum supported version is Moodle 4.0.

 *

 * @package     tool_courserating

 * @copyright   2022 Marina Glancy

 * @license     https://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

 */

class report311 extends \table_sql {

    /** @var \context */

    protected $context;

    /**

     * Constructor for the task_log table.

     *

     * @param \moodle_url $url

     */

    public function __construct(\moodle_url $url) {

        parent::__construct('courseratings');

        $this->define_baseurl($url);

        $courseid = $url->get_param('id');

        $this->context = \context_course::instance($courseid);

        $userfieldsapi = \core_user\fields::for_identity($this->context, false)->with_userpic();

        $userfields = $userfieldsapi->get_sql('u', false, '', 'userid', false)->selects;

        $extrauserfields = $userfieldsapi->get_required_fields([\core_user\fields::PURPOSE_IDENTITY]);

        $fields = $userfields . ',

             tool_courserating_rating.timemodified AS timemodified,

             tool_courserating_rating.rating AS rating,

             tool_courserating_rating.review AS review,

             (SELECT count(1) FROM {tool_courserating_flag} f WHERE f.ratingid = tool_courserating_rating.id) AS flags,

             tool_courserating_rating.id AS id,

             tool_courserating_rating.courseid AS courseid';

        $columns = $headers = [];

        $columns[] = 'fullname';

        $headers[] = get_string('fullname');

        foreach ($extrauserfields as $extrafield) {

            $columns[] = $extrafield;

            $headers[] = \core_user\fields::get_display_name($extrafield);

        }

        $columns = array_merge($columns, ['timemodified', 'rating', 'review', 'flags', 'actions']);

        $headers = array_merge($headers, [

            get_string('rating_timemodified', 'tool_courserating'),

            get_string('rating_rating', 'tool_courserating'),

            get_string('rating_review', 'tool_courserating'),

            get_string('rating_nofflags', 'tool_courserating'),

            get_string('rating_actions', 'tool_courserating'),

        ]);

        $from = '{tool_courserating_rating} tool_courserating_rating

            JOIN {user} u ON u.id = tool_courserating_rating.userid';

        $where = 'tool_courserating_rating.courseid = :rbparam0';

        $params = ['rbparam0' => $courseid];

        $this->set_sql($fields, $from, $where, $params);

        $this->define_columns($columns);

        $this->define_headers($headers);

        $this->no_sorting('actions');

        $this->no_sorting('review');

        $this->sortable(true, 'timemodified', SORT_DESC);

    }

    /**

     * Magic formatter for the column actions

     *

     * @param \stdClass $row

     * @return string

     */

    public function col_actions($row) {

        return helper::format_actions($row->id ?? 0, $row);

    }

    /**

     * Magic formatter for the column timemodified

     *

     * @param \stdClass $row

     * @return string

     */

    public function col_timemodified($row) {

        return helper::format_date($row->timemodified);

    }

    /**

     * Magic formatter for the column review

     *

     * @param \stdClass $row

     * @return string

     */

    public function col_review($row) {

        return helper::format_review($row->review, $row);

    }

    /**

     * Magic formatter for the column rating

     *

     * @param \stdClass $row

     * @return string

     */

    public function col_rating($row) {

        return helper::format_rating_in_course_report($row->rating, $row);

    }

    /**

     * Magic formatter for the column flags

     *

     * @param \stdClass $row

     * @return string

     */

    public function col_flags($row) {

        return helper::format_flags_in_course_report($row->flags, $row);

    }

    /**

     * Get the column fullname value.

     *

     * @param \stdClass $row

     * @return string

     */

    public function col_fullname($row) {

        global $OUTPUT;

        $row = fullclone($row);

        $row->id = $row->userid;

        if ($this->download) {

            return parent::col_fullname($row);

        }

        return $OUTPUT->user_picture($row, ['courseid' => $this->context->instanceid, 'includefullname' => true]);

    }

}