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

/**

 * Exports all notes from activity. Code based on CSV export from plugin Board.

 *

 * @package     mod_stickynotes

 * @copyright   2021 Olivier VALENTIN

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

 */

require(__DIR__.'/../../config.php');

use mod_stickynotes\stickynotes;

// Course module id.

$id = optional_param('id', 0, PARAM_INT);

// Retrieve all informations.

if ($id) {

    $cm = get_coursemodule_from_id('stickynotes', $id, 0, false, MUST_EXIST);

    $course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);

    $moduleinstance = $DB->get_record('stickynotes', array('id' => $cm->instance), '*', MUST_EXIST);

} else {

    throw new moodle_exception(get_string('missingidandcmid', 'mod_stickynotes'));

}

require_login($course, true, $cm);

$modulecontext = context_module::instance($cm->id);

require_capability('mod/stickynotes:export', $modulecontext);

// Start to retrieve all columns for this instance.

$cols = $DB->get_records('stickynotes_column', array('stickyid' => $moduleinstance->id), '', '*');

$allcols = array();

// For each columns, retrieve all notes.

foreach ($cols as $col) {

    $notes = $DB->get_records('stickynotes_note', array('stickyid' => $moduleinstance->id, 'stickycolid' => $col->id),

    'ordernote', '*');

    $allnotes = new StdClass;

    $allnotes = array();

    // For each note, retrieve and define all necessary information.

    foreach ($notes as $note) {

        // Count votes for note.

        $votes = $DB->count_records('stickynotes_vote', array('stickyid' => $moduleinstance->id, 'stickynoteid' => $note->id),'*');

        // Retrieve author.

        $getname = $DB->get_record('user', array('id' => $note->userid));

        $author = $getname->lastname." ".$getname->firstname;

        // Contact message, author and votes.

        $note->final = $note->message.' ('.$author.' - '.$votes.' votes)';

        $allnotes[] = (object)$note;

    }

    $notescol = new StdClass;

    $notescol->columnid = $col->id;

    $notescol->title = $col->title;

    $notescol->allnotes = $allnotes;

    $allcols[] = (object)$notescol;

}

// All informations are set.

// Header for a new CSV document.

header('Content-Type: text/csv;charset=utf-8');

header("Content-disposition: attachment; filename=\"" . strip_tags($moduleinstance->name).'_stickynotes_'.

date('YmdHis').'.csv' . "\"");

header("Pragma: no-cache");

header("Expires: 0");

$fp = fopen('php://output', 'w');

$maxnotes = 0;

$line = [];

foreach ($allcols as $col) {

    $countnotes = count($col->allnotes);

    $maxnotes = $countnotes > $maxnotes ? $countnotes : $maxnotes;

    array_push($line, $col->title);

}

fputcsv($fp, $line);

$noterow = 0;

while ($noterow < $maxnotes) {

    $line = [];

    foreach ($allcols as $col) {

        $notes = array_values($col->allnotes);

        array_push($line, isset($notes[$noterow]) ? $notes[$noterow]->final : '');

    }

    $noterow++;

    fputcsv($fp, $line);

}

fclose($fp);

exit();