Proyectos de Subversion Moodle

<?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/>.

/**
 * File call to overview the votes in the table
 *
 * @package    block_point_view
 * @copyright  2020 Quentin Fombaron, 2021 Astor Bizard
 * @author     Quentin Fombaron <q.fombaron@outlook.fr>
 * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

require_once(__DIR__ . '/../../config.php');
global $CFG, $DB, $PAGE, $OUTPUT;
require_once(__DIR__ . '/locallib.php');

require_login();

$id = required_param('instanceid', PARAM_INT);
$courseid = required_param('courseid', PARAM_INT);
$contextid = required_param('contextid', PARAM_INT);
$downloadformat = optional_param('downloadformat', '', PARAM_RAW);

$context = context_course::instance($courseid);

require_capability('block/point_view:access_overview', $context);

$course = get_course($courseid);

$PAGE->set_course($course);
$PAGE->set_context($context);

$blockrecord = $DB->get_record('block_instances', [ 'id' => $id ]);

block_point_view_check_instance($blockrecord, $context, format_string($course->fullname));

$parameters = [
        'instanceid' => $id,
        'contextid'  => $contextid,
        'courseid'   => $courseid,
];

$PAGE->set_url(new moodle_url("{$CFG->wwwroot}/blocks/point_view/overview.php", $parameters));

$title = get_string('reactionsdetails', 'block_point_view');
$heading = format_string($course->fullname) . ' - ' . get_string('pluginname', 'block_point_view');
$PAGE->set_title($heading . ' - ' . $title);
$PAGE->set_heading($heading);
$PAGE->navbar->add($title);
$PAGE->set_pagelayout('report');

$block = block_instance('point_view', $blockrecord);

$PAGE->requires->js_call_amd('block_point_view/script_menu_point_view', 'init');

$sql = 'SELECT cmid,
    COALESCE(COUNT(cmid), 0) AS total,
    COALESCE(TableTypeOne.TotalTypeOne, 0) AS typeone,
    COALESCE(TableTypeTwo.TotalTypeTwo, 0) AS typetwo,
    COALESCE(TableTypeThree.TotalTypethree, 0) AS typethree
  FROM {block_point_view}
    NATURAL LEFT JOIN (SELECT cmid, COUNT(vote) AS TotalTypeOne FROM {block_point_view}
      WHERE vote = 1 GROUP BY cmid) AS TableTypeOne
    NATURAL LEFT JOIN (SELECT cmid, COUNT(vote) AS TotalTypeTwo FROM {block_point_view}
      WHERE vote = 2 GROUP BY cmid) AS TableTypeTwo
    NATURAL LEFT JOIN (SELECT cmid, COUNT(vote) AS TotalTypethree FROM {block_point_view}
      WHERE vote = 3 GROUP BY cmid) AS TableTypeThree
    WHERE courseid = :courseid
  GROUP BY cmid, TableTypeOne.TotalTypeOne, TableTypeTwo.TotalTypeTwo, TableTypeThree.TotalTypethree;';

$result = $DB->get_records_sql($sql, [ 'courseid' => $courseid ]);

$users = $DB->get_records('user', null, '', implode(',', \core_user\fields::get_picture_fields()));

$sqldata = $DB->get_records('block_point_view', ['courseid' => $courseid], '', 'id,cmid,userid,vote');

$usersdisplay = [];

$tabledata = [];
$tablerowclasses = [];

$isdownloading = ($downloadformat > '');
$downloaddata = [];

$votestypes = [ 'typeone' => 'easy', 'typetwo' => 'better', 'typethree' => 'hard' ];
$pixparam = block_point_view_get_current_pix($block, array_values($votestypes));

$cms = get_fast_modinfo($courseid, -1)->cms;
foreach ($cms as $cm) {

    if (isset($result[$cm->id])) {

        $sectionname = get_section_name($course, $cm->sectionnum);
        $modulename = $cm->get_formatted_name();

        if (!$isdownloading) {
            $icon = $OUTPUT->pix_icon('icon', $cm->get_module_type_name(), $cm->modname, [ 'class' => 'iconlarge activityicon' ]);
            $modulename = $icon . $modulename;
        }

        $votecells = [];
        foreach ($votestypes as $type => $difficulty) {
            $nvotes = intval($result[$cm->id]->$type);
            if ($isdownloading) {
                $votecells[] = $nvotes;
            } else {
                $text = block_point_view_get_reaction_text($block, $difficulty);
                $votecell = new html_table_cell(
                        html_writer::empty_tag('img', [
                                'src' => $pixparam[$difficulty],
                                'class' => 'overview_img align-bottom mr-1',
                                'alt' => $text,
                                'title' => $text,
                        ]) .
                        '<span class="votePercent">' .
                        round(100 * $nvotes / intval($result[$cm->id]->total)) . '%' .
                        '</span>' .
                        '<span class="voteInt" style="display: none;">' . $nvotes . '</span>');
                if ($nvotes === 0) {
                    $votecell->attributes['class'] .= ' novote';
                }
                $votecells[] = $votecell;
            }
        }

        $details = array_fill(0, 7, []);

        foreach ($sqldata as $row) {
            if ($row->cmid == $cm->id) {
                if (!isset($usersdisplay[$row->userid])) {
                    $user = $users[$row->userid];
                    $usersdisplay[$row->userid] = fullname($user);
                    if (!$isdownloading) {
                        $usersdisplay[$row->userid] = $OUTPUT->user_picture($user) . $usersdisplay[$row->userid];
                    }
                }
                $details[$row->vote + 1][] = $usersdisplay[$row->userid];
            }
        }

        $data = [
                $sectionname,
                $modulename,
                $votecells[0],
                $votecells[1],
                $votecells[2],
                $result[$cm->id]->total,
        ];

        if ($isdownloading) {
            // Set a slighlty different layout for table download.
            $vote = [ 'easy', 'better', 'hard' ];
            foreach (array_slice($details, 2, 3) as $uservote => $usernames) {
                foreach ($usernames as $username) {
                    $downloaddata[] = array_merge($data, [ $vote[$uservote], $username ]);
                }
            }
        } else {
            $detailsrow = new html_table_row(array_map(function($usernames) {
                return implode('<br>', $usernames);
            }, $details));
            $detailsrow->style = 'display: none;';

            array_push($tabledata,
                    array_merge($data, [ '<i class="fa fa-fw fa-lg fa-caret-right" style="display: none;"></i>' ]),
                    $detailsrow
                    );

            array_push($tablerowclasses, 'row_module', 'row_module_details');
        }

    }
}

if ($isdownloading) {
    // This is a request to download the table.
    confirm_sesskey();

    $headers = [
            get_string('section'),
            get_string('module', 'block_point_view'),
            'easy_vote_number',
            'better_vote_number',
            'hard_vote_number',
            get_string('total'),
            'user_vote',
            get_string('user'),
    ];

    $file = $CFG->dirroot . '/dataformat/' . $downloadformat . '/classes/writer.php';
    if (is_readable($file)) {
        include_once($file);
    }
    $writerclass = 'dataformat_' . $downloadformat. '\writer';
    if (!class_exists($writerclass)) {
        throw new moodle_exception('invalidparameter', 'debug');
    }

    $writer = new $writerclass();

    $writer->set_filename(clean_filename('block_point_view_export_' . $course->shortname));
    $writer->send_http_headers();
    $writer->set_sheettitle($course->shortname);
    $writer->start_output();

    $writer->start_sheet($headers);

    foreach ($downloaddata as $rownum => $row) {
        $writer->write_record($row, $rownum + 1);
    }

    $writer->close_sheet($headers);

    $writer->close_output();
    exit();
}

echo $OUTPUT->header();
echo $OUTPUT->heading($title);
echo $OUTPUT->container_start('block_point_view');

if (!empty($result)) {

    $table = new html_table();

    $table->head = [
        get_string('section'),
        get_string('module', 'block_point_view'),
        '',
        get_string('reactions', 'block_point_view'),
        '',
        get_string('total'),
        '',
    ];

    $table->size = [
            '5%',
            '25%',
            '20%',
            '20%',
            '20%',
            '5%',
            '5%',
    ];

    $table->attributes['class'] = 'generaltable';

    $table->rowclasses = $tablerowclasses;

    $table->colclasses = [
            '',
            '',
            'reactions-col clickable',
            'reactions-col clickable',
            'reactions-col clickable',
            'text-center',
            'text-center clickable font-weight-bold',
    ];

    $table->data = $tabledata;

    echo html_writer::table($table);

    echo $OUTPUT->download_dataformat_selector(
            get_string('downloadas', 'table'),
            $PAGE->url->out_omit_querystring(),
            'downloadformat',
            $PAGE->url->params()
    );
} else {
    echo html_writer::tag('h4', get_string('noreactionsyet', 'block_point_view'));
}

echo $OUTPUT->container_end();
echo $OUTPUT->footer();