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

/**
 * Prints an instance of mod_stickynotes.
 *
 * @package     mod_stickynotes
 * @copyright   2021 Olivier VALENTIN
 * @license     https://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 */

require(__DIR__.'/../../config.php');
require_once(__DIR__.'/lib.php');
require_once(__DIR__.'/../../lib/outputcomponents.php');
global $DB, $USER;


// Declare optional parameters.
$edit = optional_param('edit', 0, PARAM_INT);
$create = optional_param('create', 0, PARAM_INT);
$delete = optional_param('delete', 0, PARAM_INT);
$col = optional_param('col', 0, PARAM_INT);
$confirm = optional_param('confirm', 0, PARAM_INT);

// These params will be passed as hidden variables later in the form.
$pageparams = array('edit' => $edit, 'create' => $create);

// Course module id.
$id = optional_param('id', 0, PARAM_INT);

// Activity instance id.
$s = optional_param('s', 0, PARAM_INT);

// Get the system context instance.
$systemcontext = context_system::instance();

if ($id) {
    $cm = get_coursemodule_from_id('stickynotes', $id, 0, false, MUST_EXIST);
    $moduleinstance = $DB->get_record('stickynotes', array('id' => $cm->instance), '*', MUST_EXIST);
    $course = $DB->get_record('course', array('id' => $cm->course), '*', MUST_EXIST);
}

$PAGE->set_url('/mod/stickynnotes/column.php', array(
    'edit'           => $edit,
    'create'         => $create,
));

require_login(0, false);

if (!empty($create)) {
    // Case 1 : manager wants to create a new column.
    // Retrieve the related coursemodule.
    if (!$cm = get_coursemodule_from_instance('stickynotes', $cm->instance)) {
        throw new moodle_exception('invalidcoursemodule');
    }
    // Check if the instance is part of a course.
    if (!$course = $DB->get_record('course', array('id' => $cm->course))) {
        throw new moodle_exception('invalidcourseid');
    }

    $post = new stdClass();
    $post->title = '';
    $stickyid = $cm->instance;
} else if ($edit) {
    // Case 2 : manager wants updates column.
    // Retrieve the related coursemodule.
    if (!$cm = get_coursemodule_from_instance('stickynotes', $cm->instance)) {
        throw new moodle_exception('invalidcoursemodule');
    }

    // Check if the instance is part of a course.
    if (!$course = $DB->get_record('course', array('id' => $cm->course))) {
        throw new moodle_exception('invalidcourseid');
    }

    if (!$post = $DB->get_record('stickynotes_column', array('id' => $col))) {
        throw new moodle_exception('cannotgetcolumn', 'stickynotes');
    }

    // Require a login and retrieve the modulecontext.
    require_login($course, false, $cm);
    $modulecontext = context_module::instance($cm->id);

    // Check capability.
    if (!has_capability('mod/stickynotes:managecolumn', $modulecontext)) {
        throw new moodle_exception('cannotmanagecolumn', 'stickynotes');
    }

    $post->edit = $edit;
    $post->course = $course->id;
    $post->title = $post->title;
    $post->col = $col;
} else if ($delete) {
    // Case 3 : manager wants to delete column.

    // Retrieve the related coursemodule.
    if (!$cm = get_coursemodule_from_instance('stickynotes', $cm->instance)) {
        throw new moodle_exception('invalidcoursemodule');
    }

    // Check if the instance is part of a course.
    if (!$course = $DB->get_record('course', array('id' => $cm->course))) {
        throw new moodle_exception('invalidcourseid');
    }

    // Check if column exists.
    if (!$post = $DB->get_record('stickynotes_column', array('id' => $col))) {
        throw new moodle_exception('cannotgetcolumn', 'stickynotes');
    }
    // Require a login and retrieve the modulecontext.
    require_login($course, false, $cm);
    $modulecontext = context_module::instance($cm->id);

    // Check capability.
    if (!has_capability('mod/stickynotes:managecolumn', $modulecontext)) {
        throw new moodle_exception('cannotmanagecolumn', 'stickynotes');
    }

    // User has confirmed deletion : column is deleted.
    if (!empty($confirm) AND confirm_sesskey()) {
        // First, retrieve all notes in selected column.
        $notestodelete = $DB->get_records('stickynotes_note', array('stickyid' => $cm->instance, 'stickycolid' => $col), '', '*');

        // Then, get infos about column to be deleted.
        $coltodelete = $DB->get_record('stickynotes_column', array('id' => $col));

        // Third, retrieve all columns for which order rank is superior at selected column.
        $sql = "SELECT *
                FROM {stickynotes_column} snc
                WHERE stickyid = :instanceid AND column_order > :delcolorder";
        $params          = array('instanceid' => $cm->instance,
                                 'delcolorder' => $coltodelete->column_order);
        $colstochange = $DB->get_records_sql($sql, $params);

        // Update all superior columns : decrease rank of each superior columns by 1.
        foreach ($colstochange as $coltochange) {
            $coltochange->col = $coltochange->id;
            $oldorder = $coltochange->column_order;
            $coltochange->column_order = $oldorder - 1;
            update_column($coltochange);
        }

        // Then, every note in selected column is deleted.
        foreach ($notestodelete as $notetodelete) {
            $deletenote = delete_stickynote($notetodelete->id, $modulecontext, $moduleinstance, $course, $cm, $notetodelete->userid);
        }
        // Finally, delete column.
        $deletecolumn = delete_column($col, $modulecontext);

        $returnurl = "view.php?id=".$cm->id;
        redirect($returnurl);
    } else {
        // Shows form to confirm before delete.
        $modulecontext = context_module::instance($cm->id);
        $coursecontext = context_course::instance($course->id);
        $PAGE->navbar->add(get_string('deletecolumn', 'stickynotes'));
        $PAGE->set_title($course->shortname);
        $PAGE->set_heading($course->fullname);

        echo $OUTPUT->header();
        echo $OUTPUT->heading(format_string($cm->name), 2);
        echo $OUTPUT->confirm(get_string("deletecolumnsure", "stickynotes"),
                "column.php?delete=$delete&confirm=$delete&id=".$cm->id."&col=".$col,
                $CFG->wwwroot . '/mod/stickynotes/view.php?id=' . $cm->id);
    }

    echo $OUTPUT->footer();
    exit;
}

// Prepare the form.
// Second step: The user must be logged on properly. Must be enrolled to the course as well.
require_login($course, false, $cm);

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

// Get column infos.
$postcol = empty($post->col) ? null : $post->col;
$posttitle = empty($post->title) ? null : $post->title;

$formarray = array(
    'id'             => $cm->id,
    'course'         => $course,
    'cm'             => $cm,
    'modulecontext'  => $modulecontext,
    'edit'           => $edit,
    'create'         => $create,
    'title'          => $posttitle,
    'col'            => $postcol,
    'stickyid'       => $cm->instance,
);

$mformcol = new form_column('column.php', $formarray, 'post');

$mformcol->set_data(array(
        'stickycolid' => $postcol,
        'id' => $id,
        'col' => $postcol,
    ) + $pageparams + $formarray);

// Is it canceled?
if ($mformcol->is_cancelled()) {
    $returnurl = "view.php?id=".$cm->id;
    redirect($returnurl);
}

// Is it submitted?
if ($fromform = $mformcol->get_data()) {
    // Redirect url in case of occuring errors.
    if (empty($SESSION->fromurl)) {
        $errordestination = "$CFG->wwwroot/mod/stickynotes/view.php?id=$cm->id";
    } else {
        $errordestination = $SESSION->fromurl;
    }

    // If we are updating column.
    if ($fromform->edit) {
        $fromform->userid = $USER->id;
        $fromform->instance = $fromform->id;
        $returnurl = "view.php?id=".$fromform->instance;
        update_column($fromform);
        redirect($returnurl);

    } else if ($fromform->create) {
        // Add a new column.
        $fromform->userid = $USER->id;
        $returnurl = "view.php?id=".$fromform->id;
        insert_column($fromform);
        redirect($returnurl);
        exit();
    }
}

// Initiate the page.
$PAGE->set_title(format_string($cm->name));
$PAGE->set_heading(format_string($course->fullname));

echo $OUTPUT->header();
echo $OUTPUT->heading($cm->name);

$mformcol->display();

echo $OUTPUT->footer();