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

/**

 * Version details

 *

 * Configurable Reports - A Moodle block for creating customizable reports

 *

 * @package     block_configurable_reports

 * @author:     Juan leyva <http://www.twitter.com/jleyvadelgado>

 * @date:       2013-09-07

 *

 * @copyright  Juan leyva <http://www.twitter.com/jleyvadelgado>

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

 */

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

function xmldb_block_configurable_reports_upgrade($oldversion) {

    global $DB, $CFG;

    $dbman = $DB->get_manager();

    if ($oldversion < 2011040103) {

        $table = new xmldb_table('block_configurable_reports_report');

        $dbman->rename_table($table, 'block_configurable_reports');

        upgrade_plugin_savepoint(true, 2011040103, 'block', 'configurable_reports');

    }

    if ($oldversion < 2011040106) {

        $table = new xmldb_table('block_configurable_reports');

        $field = new xmldb_field('global', XMLDB_TYPE_INTEGER, '4', XMLDB_UNSIGNED, null, null, '0', null);

        if (!$dbman->field_exists($table, $field)) {

            $dbman->add_field($table, $field);

        }

        $field = new xmldb_field('lastexecutiontime', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, '0', null);

        if (!$dbman->field_exists($table, $field)) {

            $dbman->add_field($table, $field);

        }

        $field = new xmldb_field('cron', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, null, null, '0', null);

        if (!$dbman->field_exists($table, $field)) {

            $dbman->add_field($table, $field);

        }

        upgrade_plugin_savepoint(true, 2011040106, 'block', 'configurable_reports');

    }

    if ($oldversion < 2011040115) {

        $table = new xmldb_table('block_configurable_reports');

        $field = new xmldb_field('remote', XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, null, null, '0', null);

        if (!$dbman->field_exists($table, $field)) {

            $dbman->add_field($table, $field);

        }

        upgrade_plugin_savepoint(true, 2011040115, 'block', 'configurable_reports');

    }

    if ($oldversion < 2019020600) {

        $table = new xmldb_table('block_configurable_reports');

        $field = new xmldb_field('summaryformat');

        $field->set_attributes(XMLDB_TYPE_INTEGER, '4', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', 'summary');

        if (!$dbman->field_exists($table, $field)) {

            $dbman->add_field($table, $field);

        }

        // Conditionally migrate to html format in summary.

        if ($CFG->texteditors !== 'textarea') {

            $rs = $DB->get_recordset('block_configurable_reports', array('summaryformat'=>FORMAT_MOODLE), '', 'id, summary, summaryformat');

            foreach ($rs as $f) {

                $f->summary = text_to_html($f->summary, false, false, true);

                $f->summaryformat = FORMAT_HTML;

                $DB->update_record('block_configurable_reports', $f);

                upgrade_set_timeout();

            }

            $rs->close();

        }

        upgrade_plugin_savepoint(true, 2019020600, 'block', 'configurable_reports');

    }

    if ($oldversion < 2019062001) {

        // Change NULL to 0.

        $rs = $DB->get_recordset('block_configurable_reports', null, '', 'id, global, lastexecutiontime, cron');

        foreach ($rs as $f) {

            $update = false;

            if (is_null($f->global)) {

                $update = true;

                $f->global = 0;

            }

            if (is_null($f->lastexecutiontime)) {

                $update = true;

                $f->lastexecutiontime = 0;

            }

            if (is_null($f->cron)) {

                $update = true;

                $f->cron = 0;

            }

            if ($update) {

                $DB->update_record('block_configurable_reports', $f);

            }

        }

        $rs->close();

        $table = new xmldb_table('block_configurable_reports');

        // Make sure these fields match install.xml.

        $field = new xmldb_field('global', XMLDB_TYPE_INTEGER, '4', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', null);

        if ($dbman->field_exists($table, $field)) {

            $dbman->change_field_default($table, $field);

            $dbman->change_field_notnull($table, $field);

        }

        $field = new xmldb_field('lastexecutiontime', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', null);

        if ($dbman->field_exists($table, $field)) {

            $dbman->change_field_default($table, $field);

            $dbman->change_field_notnull($table, $field);

        }

        $field = new xmldb_field('cron', XMLDB_TYPE_INTEGER, '4', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, '0', null);

        if ($dbman->field_exists($table, $field)) {

            $dbman->change_field_precision($table, $field);

            $dbman->change_field_notnull($table, $field);

        }

        upgrade_plugin_savepoint(true, 2019062001, 'block', 'configurable_reports');

    }

    return true;

}