Adding new report to display scheduled backup logs. MDL-7850
[moodle.git] / admin / report / backups / index.php
CommitLineData
834479c2 1<?php // $Id$
2 // index.php - scheduled backup logs
3
4 require_once('../../../config.php');
5 require_once($CFG->libdir.'/adminlib.php');
6 require_once($CFG->dirroot.'/backup/lib.php');
7
8 $adminroot = admin_get_root();
9
10 admin_externalpage_setup('reportbackups', $adminroot);
11
12 admin_externalpage_print_header($adminroot);
13
14 $courseid = optional_param('courseid', 0, PARAM_INT);
15
16 require_capability('moodle/site:backup', get_context_instance(CONTEXT_SYSTEM, SITEID));
17
18/// Scheduled backups are disabled by the server admin
19 if (!empty($CFG->disablescheduledbackups)) {
20 print_error('scheduledbackupsdisabled', '', '', NULL, true);
21 }
22
23/// Scheduled backups aren't active by the site admin
24 $backup_config = backup_get_config();
25 if (empty($backup_config->backup_sche_active)) {
26 notify(get_string('scheduledbackupsinactive'));
27 }
28
29/// Get needed strings
30 $backuploglaststatus = get_string("backuploglaststatus");
31 $backuplogdetailed = get_string("backuplogdetailed");
32 $stradmin = get_string("administration");
33 $strconfiguration = get_string("configuration");
34 $strbackup = get_string("backup");
35 $strbackupdetails = get_string("backupdetails");
36 $strlogs = get_string("logs");
37 $strftimedatetime = get_string("strftimerecent");
38 $strftimetime = get_string("strftimetime").":%S";
39 $strerror = get_string("error");
40 $strok = get_string("ok");
41 $strunfinished = get_string("unfinished");
42 $strskipped = get_string("skipped");
43 $strcourse = get_string("course");
44 $strtimetaken = get_string("timetaken","quiz");
45 $strstatus = get_string("status");
46 $strnext = get_string("next");
47
48/// Decide when to show last execution logs or detailed logs
49/// Lastlog view
50 if (!$courseid) {
51 print_heading($backuploglaststatus);
52 print_simple_box_start('center');
53 /// Now, get every record from backup_courses
54 $courses = get_records("backup_courses");
55
56 if (!$courses) {
57 notify(get_string('nologsfound'));
58 } else {
59 echo "<table border=\"0\" align=\"center\" cellpadding=\"3\" cellspacing=\"3\">";
60 //Print table header
61 echo "<tr>";
62 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"3\">$strcourse</font></td>";
63 echo "<td nowrap=\"nowrap\" align=\"center\" colspan=\"3\"><font size=\"3\">$strtimetaken</font></td>";
64 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"3\">$strstatus</font></td>";
65 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"3\">$strnext</font></td></tr>";
66 foreach ($courses as $course) {
67 /// Get the course shortname
68 $coursename = get_field ("course","fullname","id",$course->courseid);
69 if ($coursename) {
70 echo "<tr>";
71 echo "<td nowrap=\"nowrap\"><font size=\"2\"><a href=\"index.php?courseid=$course->courseid\">".$coursename."</a></font></td>";
72 echo "<td nowrap=\"nowrap\"><font size=\"2\">".userdate($course->laststarttime,$strftimedatetime)."</font></td>";
73 echo "<td nowrap=\"nowrap\"><font size=\"2\"> - </font></td>";
74 echo "<td nowrap=\"nowrap\"><font size=\"2\">".userdate($course->lastendtime,$strftimedatetime)."</font></td>";
75 if ($course->laststatus == 1) {
76 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"2\" color=\"green\">".$strok."</font></td>";
77 } else if ($course->laststatus == 2) {
78 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"2\" color=\"red\">".$strunfinished."</font></td>";
79 } else if ($course->laststatus == 3) {
80 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"2\" color=\"green\">".$strskipped."</font></td>";
81 } else {
82 echo "<td nowrap=\"nowrap\" align=\"center\"><font size=\"2\" color=\"red\">".$strerror."</font></td>";
83 }
84 echo "<td nowrap=\"nowrap\"><font size=\"2\">".userdate($course->nextstarttime,$strftimedatetime)."</font></td>";
85 echo "</tr>";
86 }
87 }
88 echo "</table>";
89 }
90 print_simple_box_end();
91/// Detailed View !!
92 } else {
93 print_heading($backuplogdetailed);
94
95 $coursename = get_field("course","fullname","id","$courseid");
96 print_heading("$strcourse: $coursename");
97
98 print_simple_box_start('center');
99
100 /// First, me get all the distinct backups for that course in backup_log
101 $executions = get_records_sql("SELECT DISTINCT laststarttime,laststarttime
102 FROM {$CFG->prefix}backup_log
103 WHERE courseid = '$courseid'
104 ORDER BY laststarttime DESC");
105
106 /// Iterate over backup executions
107 if (!$executions) {
108 notify(get_string('nologsfound'));
109 } else {
110 echo "<table border=\"0\" align=\"center\" cellpadding=\"3\" cellspacing=\"3\">";
111 foreach($executions as $execution) {
112 echo "<tr>";
113 echo "<td nowrap=\"nowrap\" align=\"center\" colspan=\"3\">";
114 print_simple_box("<center>".userdate($execution->laststarttime)."</center>", "center");
115 echo "</td>";
116 echo "</tr>";
117 $logs = get_records_sql("SELECT *
118 FROM {$CFG->prefix}backup_log
119 WHERE courseid = '$courseid' AND
120 laststarttime = '$execution->laststarttime'
121 ORDER BY id");
122 if ($logs) {
123 foreach ($logs as $log) {
124 echo "<tr>";
125 echo "<td nowrap=\"nowrap\"><font size=\"2\">".userdate($log->time,$strftimetime)."</font></td>";
126 $log->info = str_replace("- ERROR!!","- <font color=\"red\">ERROR!!</font>",$log->info);
127 $log->info = str_replace("- OK","- <font color=\"green\">OK</font>",$log->info);
128 echo "<td nowrap=\"nowrap\"><font size=\"2\">".str_replace(" ","&nbsp;&nbsp;&nbsp;&nbsp;",$log->info)."</font></td>";
129 echo "</tr>";
130 }
131 }
132 }
133 echo "</table>";
134 }
135 print_simple_box_end();
136 }
137
138 admin_externalpage_print_footer($adminroot);
139
140?>