Fixed the primary key problem in the mysql.
[moodle.git] / course / user.php
CommitLineData
24f2b65a 1<?php // $Id$
f9903ed0 2
97c270e9 3// Display user activity reports for a course
4
b0e3a925 5 require_once("../config.php");
6 require_once("lib.php");
f9903ed0 7
40343df7 8 $modes = array("outline", "complete", "todaylogs", "alllogs");
9
f9903ed0 10 require_variable($id); // course id
11 require_variable($user); // user id
0ed00b3b 12 optional_variable($mode, "todaylogs");
519d369f 13 optional_variable($page, "0");
14 optional_variable($perpage, "100");
f9903ed0 15
40343df7 16 require_login();
a2ab3b05 17
f9903ed0 18 if (! $course = get_record("course", "id", $id)) {
19 error("Course id is incorrect.");
20 }
21
f9903ed0 22 if (! $user = get_record("user", "id", $user)) {
23 error("User ID is incorrect");
24 }
25
85a6e76c 26 if (! (isteacher($course->id) or ($course->showreports and $USER->id == $user->id))) {
27 error("You are not allowed to look at this page");
28 }
29
359b138b 30 add_to_log($course->id, "course", "user report", "user.php?id=$course->id&user=$user->id&mode=$mode", "$user->id");
f9903ed0 31
a2ab3b05 32 $stractivityreport = get_string("activityreport");
33 $strparticipants = get_string("participants");
34 $stroutline = get_string("outline");
35 $strcomplete = get_string("complete");
36 $stralllogs = get_string("alllogs");
37 $strtodaylogs = get_string("todaylogs");
38 $strmode = get_string($mode);
6f2e07e8 39 $fullname = fullname($user, true);
a2ab3b05 40
41 if ($course->category) {
42 print_header("$course->shortname: $stractivityreport ($mode)", "$course->fullname",
24f2b65a 43 "<a href=\"../course/view.php?id=$course->id\">$course->shortname</a> ->
44 <a href=\"../user/index.php?id=$course->id\">$strparticipants</a> ->
45 <a href=\"../user/view.php?id=$user->id&course=$course->id\">$fullname</a> ->
a2ab3b05 46 $stractivityreport -> $strmode");
47 } else {
48 print_header("$course->shortname: $stractivityreport ($mode)", "$course->fullname",
24f2b65a 49 "<a href=\"../user/view.php?id=$user->id&course=$course->id\">$fullname</a> ->
a2ab3b05 50 $stractivityreport -> $strmode");
51 }
6f2e07e8 52 print_heading($fullname);
bbfe835b 53
24f2b65a 54 echo "<table cellpadding=\"10\" align=\"center\"><tr>";
350a05c4 55 echo "<td>$stractivityreport: </td>";
40343df7 56
a2ab3b05 57 foreach ($modes as $listmode) {
58 $strmode = get_string($listmode);
59 if ($mode == $listmode) {
40343df7 60 echo "<td><u>$strmode</u></td>";
a2ab3b05 61 } else {
24f2b65a 62 echo "<td><a href=\"user.php?id=$course->id&user=$user->id&mode=$listmode>$strmode\"</a></td>";
a2ab3b05 63 }
2b8cef80 64 }
40343df7 65 echo "</tr></table>";
bbfe835b 66
9c9f7d77 67 get_all_mods($course->id, $mods, $modnames, $modnamesplural, $modnamesused);
600149be 68
7468bf01 69 switch ($mode) {
a2ab3b05 70 case "todaylogs" :
24f2b65a 71 echo "<hr /><center>";
adecd142 72 print_log_graph($course, $user->id, "userday.png");
24f2b65a 73 echo "</center>";
519d369f 74 print_log($course, $user->id, usergetmidnight(time()), "l.time DESC", $page, $perpage,
75 "user.php?id=$course->id&user=$user->id&mode=$mode");
2b8cef80 76 break;
77
78 case "alllogs" :
24f2b65a 79 echo "<hr /><center>";
2b8cef80 80 print_log_graph($course, $user->id, "usercourse.png");
24f2b65a 81 echo "</center>";
519d369f 82 print_log($course, $user->id, 0, "l.time DESC", $page, $perpage,
83 "user.php?id=$course->id&user=$user->id&mode=$mode");
7468bf01 84 break;
600149be 85
7468bf01 86 case "outline" :
87 case "complete" :
88 default:
89 $sections = get_all_sections($course->id);
600149be 90
7468bf01 91 for ($i=0; $i<=$course->numsections; $i++) {
92
93 if (isset($sections[$i])) { // should always be true
94
95 $section = $sections[$i];
96
97 if ($section->sequence) {
24f2b65a 98 echo "<hr />";
99 echo "<h2>";
7468bf01 100 switch ($course->format) {
101 case "weeks": print_string("week"); break;
102 case "topics": print_string("topic"); break;
103 default: print_string("section"); break;
104 }
24f2b65a 105 echo " $i</h2>";
7468bf01 106
24f2b65a 107 echo "<ul>";
7468bf01 108
109 if ($mode == "outline") {
24f2b65a 110 echo "<table cellpadding=\"4\" cellspacing=\"0\">";
7468bf01 111 }
112
113 $sectionmods = explode(",", $section->sequence);
114 foreach ($sectionmods as $sectionmod) {
7af6281f 115 if (empty($mods[$sectionmod])) {
116 continue;
117 }
7468bf01 118 $mod = $mods[$sectionmod];
119 $instance = get_record("$mod->modname", "id", "$mod->instance");
359b138b 120 $libfile = "$CFG->dirroot/mod/$mod->modname/lib.php";
121
122 if (file_exists($libfile)) {
123 require_once($libfile);
124
125 switch ($mode) {
126 case "outline":
127 $user_outline = $mod->modname."_user_outline";
128 if (function_exists($user_outline)) {
129 $output = $user_outline($course, $user, $mod, $instance);
130 print_outline_row($mod, $instance, $output);
131 }
132 break;
133 case "complete":
134 $user_complete = $mod->modname."_user_complete";
135 if (function_exists($user_complete)) {
24f2b65a 136 $image = "<img src=\"../mod/$mod->modname/icon.gif\" ".
137 "height=\"16\" width=\"16\" alt=\"$mod->modfullname\">";
138 echo "<h4>$image $mod->modfullname: ".
139 "<a href=\"$CFG->wwwroot/mod/$mod->modname/view.php?id=$mod->id\">".
140 "$instance->name</a></h4>";
141 echo "<ul>";
359b138b 142 $user_complete($course, $user, $mod, $instance);
24f2b65a 143 echo "</ul>";
359b138b 144 }
145 break;
7468bf01 146 }
147 }
148 }
149
150 if ($mode == "outline") {
24f2b65a 151 echo "</table>";
7468bf01 152 print_simple_box_end();
153 }
24f2b65a 154 echo "</ul>";
359b138b 155
600149be 156
7468bf01 157 }
600149be 158 }
f9903ed0 159 }
7468bf01 160 break;
f9903ed0 161 }
162
7468bf01 163
f9903ed0 164 print_footer($course);
165
7468bf01 166
359b138b 167function print_outline_row($mod, $instance, $result) {
24f2b65a 168 $image = "<img src=\"../mod/$mod->modname/icon.gif\" height=\"16\" width=\"16\" alt=\"$mod->modfullname\">";
169
170 echo "<tr>";
171 echo "<td valign=\"top\">$image</td>";
172 echo "<td valign=\"top\" width=\"300\">";
173 echo " <a title=\"$mod->modfullname\"";
174 echo " href=\"../mod/$mod->modname/view.php?id=$mod->id\">$instance->name</a></td>";
175 echo "<td>&nbsp;&nbsp;&nbsp;</td>";
176 echo "<td valign=\"top\" bgcolor=\"white\">";
359b138b 177 if (isset($result->info)) {
178 echo "$result->info";
179 } else {
24f2b65a 180 echo "<p align=\"center\">-</p>";
359b138b 181 }
24f2b65a 182 echo "</td>";
183 echo "<td>&nbsp;&nbsp;&nbsp;</td>";
359b138b 184 if (isset($result->time)) {
185 $timeago = format_time(time() - $result->time);
24f2b65a 186 echo "<td valign=\"top\" nowrap=\"nowrap\">".userdate($result->time)." ($timeago)</td>";
359b138b 187 }
24f2b65a 188 echo "</tr>";
7468bf01 189}
190
f9903ed0 191?>
192