| 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 | 
            * A report to display the outcome of scheduled backups
  | 
        
        
            | 
            | 
           19 | 
            *
  | 
        
        
            | 
            | 
           20 | 
            * @package    report
  | 
        
        
            | 
            | 
           21 | 
            * @subpackage backups
  | 
        
        
            | 
            | 
           22 | 
            * @copyright  2007 onwards Eloy Lafuente (stronk7) {@link http://stronk7.com}
  | 
        
        
            | 
            | 
           23 | 
            * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  | 
        
        
            | 
            | 
           24 | 
            */
  | 
        
        
            | 
            | 
           25 | 
              | 
        
        
            | 
            | 
           26 | 
           require_once('../../config.php');
  | 
        
        
            | 
            | 
           27 | 
           require_once($CFG->libdir . '/adminlib.php');
  | 
        
        
            | 
            | 
           28 | 
              | 
        
        
            | 
            | 
           29 | 
           // Required for backup::xxx constants.
  | 
        
        
            | 
            | 
           30 | 
           require_once($CFG->dirroot . '/backup/util/interfaces/checksumable.class.php');
  | 
        
        
            | 
            | 
           31 | 
           require_once($CFG->dirroot . '/backup/backup.class.php');
  | 
        
        
            | 
            | 
           32 | 
              | 
        
        
            | 
            | 
           33 | 
           $courseid = optional_param('courseid', 0, PARAM_INT);
  | 
        
        
            | 
            | 
           34 | 
           $page = optional_param('page', 0, PARAM_INT); // This represents which backup we are viewing.
  | 
        
        
            | 
            | 
           35 | 
              | 
        
        
            | 
            | 
           36 | 
           // Required for constants in backup_cron_automated_helper
  | 
        
        
            | 
            | 
           37 | 
           require_once($CFG->dirroot.'/backup/util/helper/backup_cron_helper.class.php');
  | 
        
        
            | 
            | 
           38 | 
              | 
        
        
            | 
            | 
           39 | 
           admin_externalpage_setup('reportbackups', '', null, '', array('pagelayout'=>'report'));
  | 
        
        
            | 
            | 
           40 | 
              | 
        
        
            | 
            | 
           41 | 
           $strftimedatetime = get_string('strftimerecent');
  | 
        
        
            | 
            | 
           42 | 
           $strerror = get_string('error');
  | 
        
        
            | 
            | 
           43 | 
           $strok = get_string('statusok');
  | 
        
        
            | 
            | 
           44 | 
           $strunfinished = get_string('unfinished');
  | 
        
        
            | 
            | 
           45 | 
           $strskipped = get_string('skipped');
  | 
        
        
            | 
            | 
           46 | 
           $strwarning = get_string('warning');
  | 
        
        
            | 
            | 
           47 | 
           $strnotyetrun = get_string('backupnotyetrun');
  | 
        
        
            | 
            | 
           48 | 
           $strqueued = get_string('queued');
  | 
        
        
            | 
            | 
           49 | 
              | 
        
        
            | 
            | 
           50 | 
           if ($courseid) {
  | 
        
        
            | 
            | 
           51 | 
               $course = $DB->get_record('course', array('id' => $courseid), 'id, fullname', MUST_EXIST);
  | 
        
        
            | 
            | 
           52 | 
              | 
        
        
            | 
            | 
           53 | 
               // Get the automated backups that have been performed for this course.
  | 
        
        
            | 
            | 
           54 | 
               $params = array('operation' => backup::OPERATION_BACKUP,
  | 
        
        
            | 
            | 
           55 | 
                               'type' => backup::TYPE_1COURSE,
  | 
        
        
            | 
            | 
           56 | 
                               'itemid' => $course->id,
  | 
        
        
            | 
            | 
           57 | 
                               'interactive' => backup::INTERACTIVE_NO);
  | 
        
        
            | 
            | 
           58 | 
               if ($backups = $DB->get_records('backup_controllers', $params, 'timecreated DESC',
  | 
        
        
            | 
            | 
           59 | 
                   'id, backupid, status, timecreated', $page, 1)) {
  | 
        
        
            | 
            | 
           60 | 
                   // Get the backup we want to use.
  | 
        
        
            | 
            | 
           61 | 
                   $backup = reset($backups);
  | 
        
        
            | 
            | 
           62 | 
              | 
        
        
            | 
            | 
           63 | 
                   // Get the backup status.
  | 
        
        
            | 
            | 
           64 | 
                   if ($backup->status == backup::STATUS_FINISHED_OK) {
  | 
        
        
            | 
            | 
           65 | 
                       $status = $strok;
  | 
        
        
            | 
            | 
           66 | 
                       $statusclass = 'table-success'; // Green.
  | 
        
        
            | 
            | 
           67 | 
                   } else if ($backup->status == backup::STATUS_AWAITING || $backup->status == backup::STATUS_EXECUTING) {
  | 
        
        
            | 
            | 
           68 | 
                       $status = $strunfinished;
  | 
        
        
            | 
            | 
           69 | 
                       $statusclass = 'table-danger'; // Red.
  | 
        
        
            | 
            | 
           70 | 
                   } else { // Else show error.
  | 
        
        
            | 
            | 
           71 | 
                       $status = $strerror;
  | 
        
        
            | 
            | 
           72 | 
                       $statusclass = 'table-danger'; // Red.
  | 
        
        
            | 
            | 
           73 | 
                   }
  | 
        
        
            | 
            | 
           74 | 
              | 
        
        
            | 
            | 
           75 | 
                   $table = new html_table();
  | 
        
        
            | 
            | 
           76 | 
                   $table->head = array('');
  | 
        
        
            | 
            | 
           77 | 
                   $table->data = array();
  | 
        
        
            | 
            | 
           78 | 
                   $statusrow = get_string('status') . ' - ' . html_writer::tag('span', $status, array('class' => $statusclass));
  | 
        
        
            | 
            | 
           79 | 
                   $table->data[] = array($statusrow);
  | 
        
        
            | 
            | 
           80 | 
              | 
        
        
            | 
            | 
           81 | 
                   // Get the individual logs for this backup.
  | 
        
        
            | 
            | 
           82 | 
                   if ($logs = $DB->get_records('backup_logs', array('backupid' => $backup->backupid), 'timecreated ASC',
  | 
        
        
            | 
            | 
           83 | 
                       'id, message, timecreated')) {
  | 
        
        
            | 
            | 
           84 | 
                       foreach ($logs as $log) {
  | 
        
        
            | 
            | 
           85 | 
                           $table->data[] = array(userdate($log->timecreated, get_string('strftimetime', 'report_backups')) .
  | 
        
        
            | 
            | 
           86 | 
                               ' - ' . $log->message);
  | 
        
        
            | 
            | 
           87 | 
                       }
  | 
        
        
            | 
            | 
           88 | 
                   } else {
  | 
        
        
            | 
            | 
           89 | 
                       $table->data[] = array(get_string('nologsfound', 'report_backups'));
  | 
        
        
            | 
            | 
           90 | 
                   }
  | 
        
        
            | 
            | 
           91 | 
               }
  | 
        
        
            | 
            | 
           92 | 
              | 
        
        
            | 
            | 
           93 | 
               // Set the course name to display.
  | 
        
        
            | 
            | 
           94 | 
               $coursename = format_string($course->fullname, true, array('context' => context_course::instance($course->id)));
  | 
        
        
            | 
            | 
           95 | 
              | 
        
        
            | 
            | 
           96 | 
               echo $OUTPUT->header();
  | 
        
        
            | 
            | 
           97 | 
               echo $OUTPUT->heading(get_string('backupofcourselogs', 'report_backups', $coursename));
  | 
        
        
            | 
            | 
           98 | 
               if (isset($backup)) {
  | 
        
        
            | 
            | 
           99 | 
                   // We put this logic down here as we may be viewing a backup that was performed which there were no logs
  | 
        
        
            | 
            | 
           100 | 
                   // recorded for. We still want to display the pagination so the user can still navigate to other backups,
  | 
        
        
            | 
            | 
           101 | 
                   // and we also display a message so they are aware that the backup happened but there were no logs.
  | 
        
        
            | 
            | 
           102 | 
                   $baseurl = new moodle_url('/report/backups/index.php', array('courseid' => $courseid));
  | 
        
        
            | 
            | 
           103 | 
                   $numberofbackups = $DB->count_records('backup_controllers', $params);
  | 
        
        
            | 
            | 
           104 | 
                   $pagingbar = new paging_bar($numberofbackups, $page, 1, $baseurl);
  | 
        
        
            | 
            | 
           105 | 
              | 
        
        
            | 
            | 
           106 | 
                   echo $OUTPUT->render($pagingbar);
  | 
        
        
            | 
            | 
           107 | 
                   echo $OUTPUT->heading(get_string('logsofbackupexecutedon', 'report_backups', userdate($backup->timecreated)), 3);
  | 
        
        
            | 
            | 
           108 | 
                   echo html_writer::table($table);
  | 
        
        
            | 
            | 
           109 | 
                   echo $OUTPUT->render($pagingbar);
  | 
        
        
            | 
            | 
           110 | 
               } else {
  | 
        
        
            | 
            | 
           111 | 
                   echo $OUTPUT->box(get_string('nobackupsfound', 'report_backups'), 'center');
  | 
        
        
            | 
            | 
           112 | 
               }
  | 
        
        
            | 
            | 
           113 | 
               echo $OUTPUT->footer();
  | 
        
        
            | 
            | 
           114 | 
               exit();
  | 
        
        
            | 
            | 
           115 | 
           }
  | 
        
        
            | 
            | 
           116 | 
              | 
        
        
            | 
            | 
           117 | 
           $table = new html_table;
  | 
        
        
            | 
            | 
           118 | 
           $table->head = array(
  | 
        
        
            | 
            | 
           119 | 
               get_string("course"),
  | 
        
        
            | 
            | 
           120 | 
               get_string("timetaken", "backup"),
  | 
        
        
            | 
            | 
           121 | 
               get_string("status"),
  | 
        
        
            | 
            | 
           122 | 
               get_string("backupnext")
  | 
        
        
            | 
            | 
           123 | 
           );
  | 
        
        
            | 
            | 
           124 | 
           $table->headspan = array(1, 3, 1, 1);
  | 
        
        
            | 
            | 
           125 | 
           $table->attributes = array('class' => 'generaltable backup-report');
  | 
        
        
            | 
            | 
           126 | 
           $table->data = array();
  | 
        
        
            | 
            | 
           127 | 
              | 
        
        
            | 
            | 
           128 | 
           $select = ', ' . context_helper::get_preload_record_columns_sql('ctx');
  | 
        
        
            | 
            | 
           129 | 
           $join = "LEFT JOIN {context} ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel)";
  | 
        
        
            | 
            | 
           130 | 
           $sql = "SELECT bc.*, c.id as courseid, c.fullname $select
  | 
        
        
            | 
            | 
           131 | 
                     FROM {backup_courses} bc
  | 
        
        
            | 
            | 
           132 | 
                     JOIN {course} c ON c.id = bc.courseid
  | 
        
        
            | 
            | 
           133 | 
                          $join";
  | 
        
        
            | 
            | 
           134 | 
           $rs = $DB->get_recordset_sql($sql, array('contextlevel' => CONTEXT_COURSE));
  | 
        
        
            | 
            | 
           135 | 
           foreach ($rs as $backuprow) {
  | 
        
        
            | 
            | 
           136 | 
              | 
        
        
            | 
            | 
           137 | 
               // Cache the course context
  | 
        
        
            | 
            | 
           138 | 
               context_helper::preload_from_record($backuprow);
  | 
        
        
            | 
            | 
           139 | 
              | 
        
        
            | 
            | 
           140 | 
               // Prepare a cell to display the status of the entry.
  | 
        
        
            | 
            | 
           141 | 
               if ($backuprow->laststatus == backup_cron_automated_helper::BACKUP_STATUS_OK) {
  | 
        
        
            | 
            | 
           142 | 
                   $status = $strok;
  | 
        
        
            | 
            | 
           143 | 
                   $statusclass = 'table-success'; // Green.
  | 
        
        
            | 
            | 
           144 | 
               } else if ($backuprow->laststatus == backup_cron_automated_helper::BACKUP_STATUS_UNFINISHED) {
  | 
        
        
            | 
            | 
           145 | 
                   $status = $strunfinished;
  | 
        
        
            | 
            | 
           146 | 
                   $statusclass = 'table-danger'; // Red.
  | 
        
        
            | 
            | 
           147 | 
               } else if ($backuprow->laststatus == backup_cron_automated_helper::BACKUP_STATUS_SKIPPED) {
  | 
        
        
            | 
            | 
           148 | 
                   $status = $strskipped;
  | 
        
        
            | 
            | 
           149 | 
                   $statusclass = 'table-success'; // Green.
  | 
        
        
            | 
            | 
           150 | 
               } else if ($backuprow->laststatus == backup_cron_automated_helper::BACKUP_STATUS_WARNING) {
  | 
        
        
            | 
            | 
           151 | 
                   $status = $strwarning;
  | 
        
        
            | 
            | 
           152 | 
                   $statusclass = 'table-warning'; // Orange.
  | 
        
        
            | 
            | 
           153 | 
               } else if ($backuprow->laststatus == backup_cron_automated_helper::BACKUP_STATUS_NOTYETRUN) {
  | 
        
        
            | 
            | 
           154 | 
                   $status = $strnotyetrun;
  | 
        
        
            | 
            | 
           155 | 
                   $statusclass = 'table-success';
  | 
        
        
            | 
            | 
           156 | 
               } else if ($backuprow->laststatus == backup_cron_automated_helper::BACKUP_STATUS_QUEUED) {
  | 
        
        
            | 
            | 
           157 | 
                   $status = $strqueued;
  | 
        
        
            | 
            | 
           158 | 
                   $statusclass = 'table-success';
  | 
        
        
            | 
            | 
           159 | 
               } else {
  | 
        
        
            | 
            | 
           160 | 
                   $status = $strerror;
  | 
        
        
            | 
            | 
           161 | 
                   $statusclass = 'table-danger'; // Red.
  | 
        
        
            | 
            | 
           162 | 
               }
  | 
        
        
            | 
            | 
           163 | 
               $status = new html_table_cell($status);
  | 
        
        
            | 
            | 
           164 | 
               $status->attributes = array('class' => $statusclass);
  | 
        
        
            | 
            | 
           165 | 
              | 
        
        
            | 
            | 
           166 | 
               // Create the row and add it to the table
  | 
        
        
            | 
            | 
           167 | 
               $backuprowname = format_string($backuprow->fullname, true, array('context' => context_course::instance($backuprow->courseid)));
  | 
        
        
            | 
            | 
           168 | 
               $backuplogsurl = new moodle_url('/report/backups/index.php', array('courseid' => $backuprow->courseid));
  | 
        
        
            | 
            | 
           169 | 
               $backuplogsicon = new pix_icon('t/viewdetails', get_string('viewlogs', 'report_backups'));
  | 
        
        
            | 
            | 
           170 | 
               $cells = array(
  | 
        
        
            | 
            | 
           171 | 
                   $backuprowname . ' ' . $OUTPUT->action_icon($backuplogsurl, $backuplogsicon),
  | 
        
        
            | 
            | 
           172 | 
                   userdate($backuprow->laststarttime, $strftimedatetime),
  | 
        
        
            | 
            | 
           173 | 
                   '-',
  | 
        
        
            | 
            | 
           174 | 
                   userdate($backuprow->lastendtime, $strftimedatetime),
  | 
        
        
            | 
            | 
           175 | 
                   $status,
  | 
        
        
            | 
            | 
           176 | 
                   userdate($backuprow->nextstarttime, $strftimedatetime)
  | 
        
        
            | 
            | 
           177 | 
               );
  | 
        
        
            | 
            | 
           178 | 
               $table->data[] = new html_table_row($cells);
  | 
        
        
            | 
            | 
           179 | 
           }
  | 
        
        
            | 
            | 
           180 | 
           $rs->close();
  | 
        
        
            | 
            | 
           181 | 
              | 
        
        
            | 
            | 
           182 | 
           // Check if we have any results and if not add a no records notification
  | 
        
        
            | 
            | 
           183 | 
           if (empty($table->data)) {
  | 
        
        
            | 
            | 
           184 | 
               $cell = new html_table_cell($OUTPUT->notification(get_string('nologsfound')));
  | 
        
        
            | 
            | 
           185 | 
               $cell->colspan = 6;
  | 
        
        
            | 
            | 
           186 | 
               $table->data[] = new html_table_row(array($cell));
  | 
        
        
            | 
            | 
           187 | 
           }
  | 
        
        
            | 
            | 
           188 | 
              | 
        
        
            | 
            | 
           189 | 
           $automatedbackupsenabled = get_config('backup', 'backup_auto_active');
  | 
        
        
            | 
            | 
           190 | 
              | 
        
        
            | 
            | 
           191 | 
           // Display the backup report
  | 
        
        
            | 
            | 
           192 | 
           echo $OUTPUT->header();
  | 
        
        
            | 
            | 
           193 | 
           echo $OUTPUT->heading(get_string("backuploglaststatus"));
  | 
        
        
            | 
            | 
           194 | 
           echo $OUTPUT->box_start();
  | 
        
        
            | 
            | 
           195 | 
           if (empty($automatedbackupsenabled)) {
  | 
        
        
            | 
            | 
           196 | 
               // Automated backups aren't active, display a notification.
  | 
        
        
            | 
            | 
           197 | 
               // Not we don't stop because of this as perhaps scheduled backups are being run
  | 
        
        
            | 
            | 
           198 | 
               // automatically, or were enabled in the page.
  | 
        
        
            | 
            | 
           199 | 
               echo $OUTPUT->notification(get_string('automatedbackupsinactive', 'backup'));
  | 
        
        
            | 
            | 
           200 | 
           }
  | 
        
        
            | 
            | 
           201 | 
           echo html_writer::table($table);
  | 
        
        
            | 
            | 
           202 | 
           echo $OUTPUT->box_end();
  | 
        
        
            | 
            | 
           203 | 
           echo $OUTPUT->footer();
  |