Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 1
<?php
2
// This file is part of Moodle - http://moodle.org/
3
//
4
// Moodle is free software: you can redistribute it and/or modify
5
// it under the terms of the GNU General Public License as published by
6
// the Free Software Foundation, either version 3 of the License, or
7
// (at your option) any later version.
8
//
9
// Moodle is distributed in the hope that it will be useful,
10
// but WITHOUT ANY WARRANTY; without even the implied warranty of
11
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12
// GNU General Public License for more details.
13
//
14
// You should have received a copy of the GNU General Public License
15
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
16
 
17
/**
18
 * Fix orphaned calendar events that were broken by MDL-67494.
19
 *
20
 * This script will look for all the calendar events which userids
21
 * where broken by a wrong upgrade step, affecting to Moodle 3.9.5
22
 * and up.
23
 *
24
 * It performs checks to both:
25
 *    a) Detect if the site was affected (ran the wrong upgrade step).
26
 *    b) Look for orphaned calendar events, categorising them as:
27
 *       - standard: site / category / course / group / user events
28
 *       - subscription: events created via subscriptions.
29
 *       - action: normal action events, created to show common important dates.
30
 *       - override: user and group override events, particular, that some activities support.
31
 *       - custom: other events, not being any of the above, common or particular.
32
 * By specifying it (--fix) try to recover as many broken events (missing userid) as
33
 * possible. Standard, subscription, action, override events in core are fully supported but
34
 * override or custom events should be fixed by each plugin as far as there isn't any standard
35
 * API (plugin-wise) to launch a rebuild of the calendar events.
36
 *
37
 * @package core
38
 * @copyright 2021 onwards Simey Lameze <simey@moodle.com>
39
 * @license    https://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
40
 */
41
 
42
define('CLI_SCRIPT', true);
43
 
44
require_once(__DIR__ . '/../../config.php');
45
require_once($CFG->libdir . "/clilib.php");
46
require_once($CFG->libdir . '/db/upgradelib.php');
47
 
48
// Supported options.
49
$long = ['fix'  => false, 'help' => false];
50
$short = ['f' => 'fix', 'h' => 'help'];
51
 
52
// CLI options.
53
[$options, $unrecognized] = cli_get_params($long, $short);
54
 
55
if ($unrecognized) {
56
    $unrecognized = implode("\n  ", $unrecognized);
57
    cli_error(get_string('cliunknowoption', 'admin', $unrecognized));
58
}
59
 
60
if ($options['help']) {
61
    $help = <<<EOT
62
Fix orphaned calendar events.
63
 
64
  This script detects calendar events that have had their
65
  userid lost. By default it will perform various checks
66
  and report them, showing the site status in an easy way.
67
 
68
  Also, optionally (--fix), it wil try to recover as many
69
  lost userids as possible from different sources. Note that
70
  this script aims to process well-know events in core,
71
  leaving custom events in 3rd part plugins mostly unmodified
72
  because there isn't any consistent way to regenerate them.
73
 
74
  For more details:  https://tracker.moodle.org/browse/MDL-71156
75
 
76
Options:
77
  -h, --help    Print out this help.
78
  -f, --fix     Fix the orphaned calendar events in the DB.
79
                If not specified only check and report problems to STDERR.
80
 
81
Usage:
82
  - Only report:    \$ sudo -u www-data /usr/bin/php admin/cli/fix_orphaned_calendar_events.php
83
  - Report and fix: \$ sudo -u www-data /usr/bin/php admin/cli/fix_orphaned_calendar_events.php -f
84
EOT;
85
 
86
    cli_writeln($help);
87
    die;
88
}
89
 
90
// Check various usual pre-requisites.
91
if (empty($CFG->version)) {
92
    cli_error('Database is not yet installed.');
93
}
94
 
95
$admin = get_admin();
96
if (!$admin) {
97
    cli_error('Error: No admin account was found.');
98
}
99
 
100
if (moodle_needs_upgrading()) {
101
    cli_error('Moodle upgrade pending, script execution suspended.');
102
}
103
 
104
// Do everything as admin by default.
105
\core\session\manager::set_user($admin);
106
 
107
// Report current site status.
108
cli_heading('Checking the site status');
109
$needsfix = upgrade_calendar_site_status();
110
 
111
// Report current calendar events status.
112
cli_heading('Checking the calendar events status');
113
$info = upgrade_calendar_events_status();
114
$hasbadevents = $info['total']->bad > 0 || $info['total']->bad != $info['other']->bad;
115
$needsfix = $needsfix || $hasbadevents;
116
 
117
// If, selected, fix as many calendar events as possible.
118
if ($options['fix']) {
119
 
120
    // If the report has told us that the fix was not needed... ask for confirmation!
121
    if (!$needsfix) {
122
        cli_writeln("This site DOES NOT NEED to run the calendar events fix.");
123
        $input = cli_input('Are you completely sure that you want to run the fix? (y/N)', 'N', ['y', 'Y', 'n', 'N']);
124
        if (strtolower($input) != 'y') {
125
            exit(0);
126
        }
127
        cli_writeln("");
128
    }
129
    cli_heading('Fixing as many as possible calendar events');
130
    upgrade_calendar_events_fix_remaining($info);
131
    // Report current (after fix) calendar events status.
132
    cli_heading('Checking the calendar events status (after fix)');
133
    upgrade_calendar_events_status();
134
} else if ($needsfix) {
135
    // Fix option was not provided but problem events have been found. Notify the user and provide info how to fix these events.
136
    cli_writeln("This site NEEDS to run the calendar events fix!");
137
    cli_writeln("To fix the calendar events, re-run this script with the --fix option.");
138
}