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

/**

 * Multiblock uninstallation.

 *

 * @package   block_multiblock

 * @copyright 2020 Peter Spicer <peter.spicer@catalyst-eu.net>

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

 */

use block_multiblock\helper;

/**

 * Clean up multiblocks when uninstalling.

 *

 * Finds every multiblock instance and decomposes any blocks in them back to parent context.

 */

function xmldb_block_multiblock_uninstall() : bool {

    global $DB;

    // Set up the queries we're going to be using.

    $sql = "SELECT c.id AS contextid, bi.*

              FROM {context} c

              JOIN {block_instances} bi ON bi.id = c.instanceid AND c.contextlevel = :contextlevel

             WHERE bi.blockname = :blockname";

    $params = [

        'blockname' => 'multiblock',

        'contextlevel' => CONTEXT_BLOCK,

    ];

    $childsql = "SELECT c.id AS contextid, bi.id AS blockid

                   FROM {context} c

                   JOIN {block_instances} bi ON bi.id = c.instanceid AND c.contextlevel = :contextlevel

                  WHERE bi.parentcontextid = :parentcontext";

    $multiblocks = $DB->get_records_sql($sql, $params);

    foreach ($multiblocks as $multiblock) {

        // Now we have the blocks, find each block's children.

        $childparams = [

            'contextlevel' => CONTEXT_BLOCK,

            'parentcontext' => $multiblock->contextid,

        ];

        $children = $DB->get_records_sql($childsql, $childparams);

        // And split each child out of the parent.

        foreach ($children as $childblock) {

            helper::split_block($multiblock, $childblock->blockid);

        }

    }

    return true;

}