Fix for off-by-one grade error when 'Save Grades' had not been used
[moodle.git] / course / lib.php
CommitLineData
f9903ed0 1<? // $Id$
97c270e9 2 // Library of useful functions
f9903ed0 3
f9903ed0 4
9ae687af 5if (isset($COURSE_MAX_LOG_DISPLAY)) { // Being included again - should never happen!!
6 return;
7}
8
97c270e9 9$COURSE_MAX_LOG_DISPLAY = 150; // days
d9d1c35d 10
1c0200e0 11$COURSE_MAX_LOGS_PER_PAGE = 1000; // records
12
97c270e9 13$COURSE_TEACHER_COLOR = "#990000"; // To hilight certain items that are teacher-only
87ffed0d 14
97c270e9 15$COURSE_LIVELOG_REFRESH = 60; // Seconds
ef58b822 16
f9903ed0 17
9ae687af 18
f9903ed0 19function print_log_selector_form($course, $selecteduser=0, $selecteddate="today") {
20
9481285b 21 global $USER, $CFG;
22
f9903ed0 23 // Get all the possible users
24 $users = array();
720a43ce 25
26 if ($course->category) {
30d6173e 27 if ($courseusers = get_course_users($course->id, "u.lastaccess DESC")) {
28 foreach ($courseusers as $courseuser) {
29 $users[$courseuser->id] = "$courseuser->firstname $courseuser->lastname";
30 }
f9903ed0 31 }
9fa49e22 32 if ($guest = get_guest()) {
30d6173e 33 $users[$guest->id] = "$guest->firstname $guest->lastname";
122cffc9 34 }
f9903ed0 35 }
720a43ce 36
37 if (isadmin()) {
9fa49e22 38 if ($ccc = get_records("course", "", "", "fullname")) {
720a43ce 39 foreach ($ccc as $cc) {
cfa5d3f2 40 if ($cc->category) {
41 $courses["$cc->id"] = "$cc->fullname";
42 } else {
43 $courses["$cc->id"] = " $cc->fullname (Site)";
44 }
720a43ce 45 }
f9903ed0 46 }
cfa5d3f2 47 asort($courses);
f9903ed0 48 }
49
dcde9f02 50
51 $strftimedate = get_string("strftimedate");
52 $strftimedaydate = get_string("strftimedaydate");
53
f9903ed0 54 asort($users);
55
56 // Get all the possible dates
9481285b 57 // Note that we are keeping track of real (GMT) time and user time
58 // User time is only used in displays - all calcs and passing is GMT
59
60 $timenow = time(); // GMT
61
62 // What day is it now for the user, and when is midnight that day (in GMT).
9604ccb1 63 $timemidnight = $today = usergetmidnight($timenow);
9481285b 64
65 // Put today up the top of the list
dcde9f02 66 $dates = array("$timemidnight" => get_string("today").", ".userdate($timenow, $strftimedate) );
9481285b 67
68 if (! $course->startdate) {
69 $course->startdate = $course->timecreated;
70 }
f9903ed0 71
9481285b 72 $numdates = 1;
73 while ($timemidnight > $course->startdate and $numdates < 365) {
f9903ed0 74 $timemidnight = $timemidnight - 86400;
9481285b 75 $timenow = $timenow - 86400;
dcde9f02 76 $dates["$timemidnight"] = userdate($timenow, $strftimedaydate);
9481285b 77 $numdates++;
f9903ed0 78 }
79
80 if ($selecteddate == "today") {
81 $selecteddate = $today;
82 }
83
84 echo "<CENTER>";
85 echo "<FORM ACTION=log.php METHOD=get>";
720a43ce 86 if (isadmin()) {
849bc02a 87 choose_from_menu ($courses, "id", $course->id, "");
720a43ce 88 } else {
89 echo "<INPUT TYPE=hidden NAME=id VALUE=\"$course->id\">";
90 }
91 if ($course->category) {
97c270e9 92 choose_from_menu ($users, "user", $selecteduser, get_string("allparticipants") );
720a43ce 93 }
97c270e9 94 choose_from_menu ($dates, "date", $selecteddate, get_string("alldays"));
95 echo "<INPUT TYPE=submit VALUE=\"".get_string("showtheselogs")."\">";
f9903ed0 96 echo "</FORM>";
97 echo "</CENTER>";
98}
99
600149be 100function make_log_url($module, $url) {
101 switch ($module) {
102 case "course":
103 case "user":
104 case "file":
105 case "login":
106 case "lib":
107 case "admin":
108 return "/$module/$url";
109 break;
110 default:
111 return "/mod/$module/$url";
112 break;
113 }
114}
115
116
f9903ed0 117function print_log($course, $user=0, $date=0, $order="ORDER BY l.time ASC") {
9481285b 118// It is assumed that $date is the GMT time of midnight for that day,
119// and so the next 86400 seconds worth of logs are printed.
f9903ed0 120
1c0200e0 121 global $CFG, $COURSE_MAX_LOGS_PER_PAGE;
47f1da80 122
720a43ce 123 if ($course->category) {
ebc3bd2b 124 $selector = "WHERE l.course='$course->id' AND l.userid = u.id";
a2ab3b05 125
720a43ce 126 } else {
ebc3bd2b 127 $selector = "WHERE l.userid = u.id"; // Show all courses
9fa49e22 128 if ($ccc = get_courses(-1)) {
720a43ce 129 foreach ($ccc as $cc) {
130 $courses[$cc->id] = "$cc->shortname";
131 }
132 }
133 }
f9903ed0 134
135 if ($user) {
ebc3bd2b 136 $selector .= " AND l.userid = '$user'";
f9903ed0 137 }
138
139 if ($date) {
140 $enddate = $date + 86400;
141 $selector .= " AND l.time > '$date' AND l.time < '$enddate'";
142 }
143
6aeec7f8 144 if (!$logs = get_logs($selector, $order)) {
f9903ed0 145 notify("No logs found!");
146 print_footer($course);
147 exit;
148 }
149
150 $count=0;
151 $tt = getdate(time());
152 $today = mktime (0, 0, 0, $tt["mon"], $tt["mday"], $tt["year"]);
1c0200e0 153 if (($totalcountlogs = count($logs)) > $COURSE_MAX_LOGS_PER_PAGE) {
154 $totalcountlogs = "$COURSE_MAX_LOGS_PER_PAGE/$totalcountlogs";
155 }
156
dcde9f02 157 $strftimedatetime = get_string("strftimedatetime");
158
9fa49e22 159 echo "<P ALIGN=CENTER>";
1c0200e0 160 print_string("displayingrecords", "", $totalcountlogs);
9fa49e22 161 echo "</P>";
1c0200e0 162
163 $countlogs = 0;
f9903ed0 164 echo "<TABLE BORDER=0 ALIGN=center CELLPADDING=3 CELLSPACING=3>";
165 foreach ($logs as $log) {
600149be 166
1c0200e0 167 $countlogs++;
168
169 if ($countlogs > $COURSE_MAX_LOGS_PER_PAGE) {
170 break;
171 }
172
9fa49e22 173 if ($ld = get_record("log_display", "module", "$log->module", "action", "$log->action")) {
565f7a95 174 $log->info = get_field($ld->mtable, $ld->field, "id", $log->info);
600149be 175 }
176
f58d18bc 177 echo "<TR NOWRAP>";
720a43ce 178 if (! $course->category) {
f58d18bc 179 echo "<TD NOWRAP><FONT SIZE=2><A HREF=\"view.php?id=$log->course\">".$courses[$log->course]."</A></TD>";
720a43ce 180 }
f58d18bc 181 echo "<TD NOWRAP ALIGN=right><FONT SIZE=2>".userdate($log->time, "%A")."</TD>";
dcde9f02 182 echo "<TD NOWRAP><FONT SIZE=2>".userdate($log->time, $strftimedatetime)."</TD>";
ebea4e27 183 echo "<TD NOWRAP><FONT SIZE=2>";
47f1da80 184 link_to_popup_window("/lib/ipatlas/plot.php?address=$log->ip&user=$log->userid", "ipatlas","$log->ip", 400, 700);
ebea4e27 185 echo "</TD>";
ebc3bd2b 186 echo "<TD NOWRAP><FONT SIZE=2><A HREF=\"../user/view.php?id=$log->userid&course=$log->course\"><B>$log->firstname $log->lastname</B></TD>";
f58d18bc 187 echo "<TD NOWRAP><FONT SIZE=2>";
600149be 188 link_to_popup_window( make_log_url($log->module,$log->url), "fromloglive","$log->module $log->action", 400, 600);
f9903ed0 189 echo "</TD>";
f58d18bc 190 echo "<TD NOWRAP><FONT SIZE=2>$log->info</TD>";
f9903ed0 191 echo "</TR>";
192 }
193 echo "</TABLE>";
194}
195
196
776dc270 197function print_all_courses($category="all", $style="full", $maxcount=999, $width=180) {
0a263205 198 global $CFG, $USER;
d887b5a7 199
ba2e5d73 200 if ($category == "all") {
9fa49e22 201 $courses = get_courses();
0a263205 202
203 } else if ($category == "my") {
204 if (isset($USER->id)) {
9fa49e22 205 if ($courses = get_courses()) {
0a263205 206 foreach ($courses as $key => $course) {
207 if (!isteacher($course->id) and !isstudent($course->id)) {
208 unset($courses[$key]);
209 }
210 }
211 }
212 }
213
ba2e5d73 214 } else {
9fa49e22 215 $courses = get_courses($category);
ba2e5d73 216 }
217
393cc508 218 if ($style == "minimal") {
219 $count = 0;
220 $icon = "<IMG SRC=\"pix/i/course.gif\" HEIGHT=16 WIDTH=16 ALT=\"".get_string("course")."\">";
221 if ($courses) {
94361e02 222 foreach ($courses as $course) {
565f7a95 223 $moddata[]="<A TITLE=\"$course->shortname\" HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">$course->fullname</A>";
94361e02 224 $modicon[]=$icon;
225 if ($count++ >= $maxcount) {
226 break;
227 }
228 }
229 $fulllist = "<P><A HREF=\"$CFG->wwwroot/course/\">".get_string("fulllistofcourses")."</A>...";
94361e02 230 } else {
393cc508 231 $moddata = array();
232 $modicon = array();
233 $fulllist = get_string("nocoursesyet");
234 }
235 print_side_block(get_string("courses"), "", $moddata, $modicon, $fulllist, $width);
236
237 } else if ($courses) {
238 foreach ($courses as $course) {
239 print_course($course);
240 echo "<BR>\n";
d887b5a7 241 }
242
243 } else {
393cc508 244 echo "<P>".get_string("nocoursesyet")."</P>";
d887b5a7 245 }
246}
247
248
f9903ed0 249function print_course($course) {
250
d887b5a7 251 global $CFG;
252
a83fded1 253 if (! $site = get_site()) {
f9903ed0 254 error("Could not find a site!");
255 }
256
d887b5a7 257 print_simple_box_start("CENTER", "100%");
f9903ed0 258
259 echo "<TABLE WIDTH=100%>";
da5c172a 260 echo "<TR VALIGN=top>";
261 echo "<TD VALIGN=top WIDTH=50%>";
7a302afc 262 echo "<P><FONT SIZE=3><B><A TITLE=\"".get_string("entercourse")."\"
9481285b 263 HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">$course->fullname</A></B></FONT></P>";
0c71c9ae 264 if ($teachers = get_course_teachers($course->id)) {
f9903ed0 265 echo "<P><FONT SIZE=1>\n";
266 foreach ($teachers as $teacher) {
0c71c9ae 267 if ($teacher->authority > 0) {
b4d7002e 268 if (!$teacher->role) {
269 $teacher->role = $course->teacher;
270 }
271 echo "$teacher->role: <A HREF=\"$CFG->wwwroot/user/view.php?id=$teacher->id&course=$site->id\">$teacher->firstname $teacher->lastname</A><BR>";
0c71c9ae 272 }
f9903ed0 273 }
274 echo "</FONT></P>";
da5c172a 275 }
f25f1e1b 276 if ($course->guest) {
5e367a2d 277 $strallowguests = get_string("allowguests");
278 echo "<A TITLE=\"$strallowguests\" HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">";
279 echo "<IMG VSPACE=4 ALT=\"$strallowguests\" HEIGHT=16 WIDTH=16 BORDER=0 SRC=\"$CFG->wwwroot/user/user.gif\"></A>&nbsp;&nbsp;";
da5c172a 280 }
281 if ($course->password) {
5e367a2d 282 $strrequireskey = get_string("requireskey");
283 echo "<A TITLE=\"$strrequireskey\" HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">";
284 echo "<IMG VSPACE=4 ALT=\"$strrequireskey\" HEIGHT=16 WIDTH=16 BORDER=0 SRC=\"$CFG->wwwroot/pix/i/key.gif\"></A>";
da5c172a 285 }
286
287
288 echo "</TD><TD VALIGN=top WIDTH=50%>";
289 echo "<P><FONT SIZE=2>".text_to_html($course->summary)."</FONT></P>";
290 echo "</TD></TR>";
291 echo "</TABLE>";
f9903ed0 292
da5c172a 293 print_simple_box_end();
f9903ed0 294}
295
600149be 296function print_headline($text, $size=2) {
297 echo "<B><FONT SIZE=\"$size\">$text</FONT></B><BR>\n";
298}
299
300function print_recent_activity($course) {
301 // $course is an object
302 // This function trawls through the logs looking for
303 // anything new since the user's last login
304
97c270e9 305 global $CFG, $USER, $COURSE_TEACHER_COLOR;
600149be 306
307 if (! $USER->lastlogin ) {
4c654ee3 308 echo "<P ALIGN=CENTER><FONT SIZE=1>";
4b1371a7 309 print_string("welcometocourse", "", $course->shortname);
4c654ee3 310 echo "</FONT></P>";
600149be 311 return;
4c654ee3 312 } else {
313 echo "<P ALIGN=CENTER><FONT SIZE=1>";
314 echo get_string("yourlastlogin").":<BR>";
dcde9f02 315 echo userdate($USER->lastlogin, get_string("strftimerecentfull"));
4c654ee3 316 echo "</FONT></P>";
600149be 317 }
318
9fa49e22 319 if (! $logs = get_records_select("log", "time > '$USER->lastlogin' AND course = '$course->id'", "time ASC")) {
600149be 320 return;
321 }
322
323
324 // Firstly, have there been any new enrolments?
325
326 $heading = false;
327 $content = false;
328 foreach ($logs as $log) {
329 if ($log->module == "course" and $log->action == "enrol") {
330 if (! $heading) {
4c654ee3 331 print_headline(get_string("newusers").":");
600149be 332 $heading = true;
333 $content = true;
334 }
335 $user = get_record("user", "id", $log->info);
d578afc8 336 if (isstudent($course->id, $user->id)) {
337 echo "<P><FONT SIZE=1><A HREF=\"../user/view.php?id=$user->id&course=$course->id\">$user->firstname $user->lastname</A></FONT></P>";
338 }
600149be 339 }
340 }
341
342 // Next, have there been any changes to the course structure?
343
600149be 344 foreach ($logs as $log) {
345 if ($log->module == "course") {
346 if ($log->action == "add mod" or $log->action == "update mod" or $log->action == "delete mod") {
600149be 347 $info = split(" ", $log->info);
348 $modname = get_field($info[0], "name", "id", $info[1]);
349
600149be 350 switch ($log->action) {
351 case "add mod":
27038d9f 352 $stradded = get_string("added", "moodle", get_string("modulename", $info[0]));
4c654ee3 353 $changelist["$log->info"] = array ("operation" => "add", "text" => "$stradded:<BR><A HREF=\"$CFG->wwwroot/course/$log->url\">$modname</A>");
600149be 354 break;
355 case "update mod":
27038d9f 356 $strupdated = get_string("updated", "moodle", get_string("modulename", $info[0]));
47f1da80 357 if (empty($changelist["$log->info"])) {
4c654ee3 358 $changelist["$log->info"] = array ("operation" => "update", "text" => "$strupdated:<BR><A HREF=\"$CFG->wwwroot/course/$log->url\">$modname</A>");
ef25340c 359 }
600149be 360 break;
361 case "delete mod":
ef25340c 362 if ($changelist["$log->info"]["operation"] == "add") {
363 $changelist["$log->info"] = NULL;
364 } else {
27038d9f 365 $strdeleted = get_string("deletedactivity", "moodle", get_string("modulename", $info[0]));
4c654ee3 366 $changelist["$log->info"] = array ("operation" => "delete", "text" => $strdeleted);
ef25340c 367 }
600149be 368 break;
369 }
ef25340c 370 }
371 }
372 }
373
9c9f7d77 374 if (!empty($changelist)) {
ef25340c 375 foreach ($changelist as $changeinfo => $change) {
376 if ($change) {
377 $changes[$changeinfo] = $change;
378 }
379 }
380 if (count($changes) > 0) {
4c654ee3 381 print_headline(get_string("courseupdates").":");
ef25340c 382 $content = true;
383 foreach ($changes as $changeinfo => $change) {
384 echo "<P><FONT SIZE=1>".$change["text"]."</FONT></P>";
600149be 385 }
386 }
387 }
388
389
3869a2ac 390 // Now display new things from each module
600149be 391
3869a2ac 392 $mods = get_list_of_plugins("mod");
600149be 393
3869a2ac 394 foreach ($mods as $mod) {
395 include_once("$CFG->dirroot/mod/$mod/lib.php");
396 $print_recent_activity = $mod."_print_recent_activity";
397 if (function_exists($print_recent_activity)) {
398 $modcontent = $print_recent_activity($logs, isteacher($course->id));
399 if ($modcontent) {
400 $content = true;
600149be 401 }
600149be 402 }
403 }
404
3869a2ac 405
600149be 406 if (! $content) {
97c270e9 407 echo "<FONT SIZE=2>".get_string("nothingnew")."</FONT>";
600149be 408 }
600149be 409}
410
e1360728 411
d897cae4 412function get_array_of_activities($courseid) {
413// For a given course, returns an array of course activity objects
414// Each item in the array contains he following properties:
415// cm - course module id
416// mod - name of the module (eg forum)
417// section - the number of the section (eg week or topic)
418// name - the name of the instance
419
420 $mod = array();
421
9fa49e22 422 if (!$rawmods = get_course_mods($courseid)) {
d897cae4 423 return NULL;
424 }
425
426 if ($sections = get_records("course_sections", "course", $courseid, "section ASC")) {
427 foreach ($sections as $section) {
74666583 428 if (!empty($section->sequence)) {
d897cae4 429 $sequence = explode(",", $section->sequence);
430 foreach ($sequence as $seq) {
7af6281f 431 if (empty($rawmods[$seq])) {
432 continue;
433 }
d897cae4 434 $mod[$seq]->cm = $rawmods[$seq]->id;
435 $mod[$seq]->mod = $rawmods[$seq]->modname;
436 $mod[$seq]->section = $section->section;
437 $mod[$seq]->name = urlencode(get_field($rawmods[$seq]->modname, "name", "id", $rawmods[$seq]->instance));
438 }
439 }
440 }
441 }
442 return $mod;
443}
444
445
446
e1360728 447
90845098 448function get_all_mods($courseid, &$mods, &$modnames, &$modnamesplural, &$modnamesused) {
449// Returns a number of useful structures for course displays
7468bf01 450
90845098 451 $mods = NULL; // course modules indexed by id
452 $modnames = NULL; // all course module names
94361e02 453 $modnamesplural= NULL; // all course module names (plural form)
90845098 454 $modnamesused = NULL; // course module names used
7468bf01 455
9fa49e22 456 if ($allmods = get_records("modules")) {
90845098 457 foreach ($allmods as $mod) {
458 $modnames[$mod->name] = get_string("modulename", "$mod->name");
459 $modnamesplural[$mod->name] = get_string("modulenameplural", "$mod->name");
460 }
461 asort($modnames);
462 } else {
463 error("No modules are installed!");
464 }
465
9fa49e22 466 if ($rawmods = get_course_mods($courseid)) {
7468bf01 467 foreach($rawmods as $mod) { // Index the mods
468 $mods[$mod->id] = $mod;
90845098 469 $mods[$mod->id]->modfullname = $modnames[$mod->modname];
470 $modnamesused[$mod->modname] = $modnames[$mod->modname];
7468bf01 471 }
90845098 472 asort($modnamesused);
7468bf01 473 }
7468bf01 474}
475
9fa49e22 476
7468bf01 477function get_all_sections($courseid) {
478
d26d7ed0 479 return get_records("course_sections", "course", "$courseid", "section",
9fa49e22 480 "section, id, course, summary, sequence");
7468bf01 481}
482
ba2e5d73 483
5e367a2d 484function print_section_block($heading, $course, $section, $mods, $modnames, $modnamesused,
485 $absolute=true, $width="100%", $isediting=false) {
486
487 global $CFG;
488
489 $modinfo = unserialize($course->modinfo);
490 $moddata = array();
491 $modicon = array();
492 $editbuttons = "";
493
74666583 494 if (!empty($section->sequence)) {
5e367a2d 495
496 $sectionmods = explode(",", $section->sequence);
497
498 foreach ($sectionmods as $modnumber) {
499 $mod = $mods[$modnumber];
500 if ($isediting) {
501 $editbuttons = make_editing_buttons($mod->id, $absolute);
502 }
503 $instancename = urldecode($modinfo[$modnumber]->name);
504 $modicon[] = "<img src=\"$CFG->wwwroot/mod/$mod->modname/icon.gif\" height=\"16\" width=\"16\" alt=\"$mod->modfullname\">";
505 $moddata[] = "<a title=\"$mod->modfullname\" href=\"$CFG->wwwroot/mod/$mod->modname/view.php?id=$mod->id\">$instancename</a><BR>$editbuttons";
506 }
507 }
a44d18e7 508 if ($isediting) {
15ac9065 509 $editmenu = popup_form("$CFG->wwwroot/course/mod.php?id=$course->id&amp;section=$section->section&add=",
5e367a2d 510 $modnames, "section0", "", get_string("add")."...", "mods", get_string("activities"), true);
511 $editmenu = "<DIV ALIGN=right>$editmenu</DIV>";
47f1da80 512 } else {
513 $editmenu = "";
5e367a2d 514 }
515
516 print_side_block($heading, "", $moddata, $modicon, $editmenu, $width);
517}
518
519
d897cae4 520function print_section($course, $section, $mods, $modnamesused, $absolute=false, $width="100%") {
94361e02 521 global $CFG;
522
c408b0c4 523 $modinfo = unserialize($course->modinfo);
94361e02 524
19a55d67 525 echo "<TABLE WIDTH=\"$width\"><TR><TD>\n";
74666583 526 if (!empty($section->sequence)) {
94361e02 527
528 $sectionmods = explode(",", $section->sequence);
529
530 foreach ($sectionmods as $modnumber) {
9ae687af 531 if (empty($mods[$modnumber])) {
532 continue;
533 }
94361e02 534 $mod = $mods[$modnumber];
c408b0c4 535 $instancename = urldecode($modinfo[$modnumber]->name);
94361e02 536 echo "<IMG SRC=\"$CFG->wwwroot/mod/$mod->modname/icon.gif\" HEIGHT=16 WIDTH=16 ALT=\"$mod->modfullname\">";
a7ad3ea6 537 echo " <FONT SIZE=2><A TITLE=\"$mod->modfullname\"";
538 echo " HREF=\"$CFG->wwwroot/mod/$mod->modname/view.php?id=$mod->id\">$instancename</A></FONT>";
d897cae4 539 if (isediting($course->id)) {
5e367a2d 540 echo "&nbsp;&nbsp;";
94361e02 541 echo make_editing_buttons($mod->id, $absolute);
542 }
543 echo "<BR>\n";
544 }
545 }
47ef8795 546 echo "</TD></TR></TABLE><BR>\n\n";
a7ad3ea6 547}
548
7541bc3e 549function print_heading_block($heading, $width="100%", $class="headingblock") {
5e367a2d 550 global $THEME;
551
7541bc3e 552 echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
553 echo "<tr><td bgcolor=\"$THEME->cellheading\" class=\"$class\">";
5e367a2d 554 echo stripslashes($heading);
555 echo "</td></tr></table>";
5e367a2d 556}
557
558function print_side_block($heading="", $content="", $list=NULL, $icons=NULL, $footer="", $width=180) {
559// Prints a nice side block with an optional header. The content can either
560// be a block of HTML or a list of text with optional icons.
a7ad3ea6 561
5e367a2d 562 global $THEME;
563
7541bc3e 564 print_side_block_start($heading, $width);
565
5e367a2d 566 if ($content) {
7541bc3e 567 echo "$content";
5e367a2d 568 } else {
5e367a2d 569 echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">";
570 foreach ($list as $key => $string) {
7541bc3e 571 echo "<tr bgcolor=\"$THEME->cellcontent2\">";
5e367a2d 572 if ($icons) {
7541bc3e 573 echo "<td class=\"sideblocklinks\" valign=\"top\" width=\"16\">".$icons[$key]."</td>";
a7ad3ea6 574 }
7541bc3e 575 echo "<td class=\"sideblocklinks\" valign=\"top\" width=\"*\"><font size=\"-1\">$string</font></td>";
5e367a2d 576 echo "</tr>";
a7ad3ea6 577 }
5e367a2d 578 if ($footer) {
7541bc3e 579 echo "<tr bgcolor=\"$THEME->cellcontent2\">";
5e367a2d 580 if ($icons) {
7541bc3e 581 echo "<td class=\"sideblocklinks\" valign=\"top\" width=\"16\">&nbsp;</td>";
5e367a2d 582 }
7541bc3e 583 echo "<td class=\"sideblocklinks\"><font size=\"-1\">$footer</td>";
5e367a2d 584 echo "</tr>";
585 }
586 echo "</table>";
a7ad3ea6 587 }
5e367a2d 588
7541bc3e 589 print_side_block_end();
590}
591
592function print_side_block_start($heading="", $width=180, $class="sideblockmain") {
593// Starts a nice side block with an optional header.
594
595 global $THEME;
596
597 echo "<table class=\"sideblock\" width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
598 if ($heading) {
599 echo "<tr>";
600 echo "<td class=\"sideblockheading\" bgcolor=\"$THEME->cellheading\">$heading</td>";
601 echo "</tr>";
602 }
603 echo "<tr>";
604 echo "<td class=\"$class\" bgcolor=\"$THEME->cellcontent2\">";
605}
606
607function print_side_block_end() {
608 echo "</td></tr>";
5e367a2d 609 echo "</table><br \>";
94361e02 610}
611
5e367a2d 612
670fddf1 613function print_admin_links ($siteid, $width=180) {
b0e3a925 614 global $CFG;
2b25f2a0 615
2b25f2a0 616 $icon = "<IMG SRC=\"$CFG->wwwroot/pix/i/settings.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
1924074c 617 if (isadmin()) {
dae73c05 618 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/config.php\">".get_string("configvariables")."</A>";
1924074c 619 $modicon[]=$icon;
dae73c05 620 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/site.php\">".get_string("sitesettings")."</A>";
1924074c 621 $modicon[]=$icon;
622 $moddata[]="<A HREF=\"$CFG->wwwroot/course/log.php?id=$siteid\">".get_string("sitelogs")."</A>";
623 $modicon[]=$icon;
624 $moddata[]="<A HREF=\"$CFG->wwwroot/theme/index.php\">".get_string("choosetheme")."</A>";
625 $modicon[]=$icon;
dae73c05 626 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/lang.php\">".get_string("checklanguage")."</A>";
1924074c 627 $modicon[]=$icon;
be09831a 628 if (file_exists("$CFG->dirroot/$CFG->admin/$CFG->dbtype")) {
dae73c05 629 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/$CFG->dbtype/frame.php\">".get_string("managedatabase")."</A>";
1924074c 630 $modicon[]=$icon;
631 }
632 $moddata[]="<HR>";
633 $modicon[]="";
634 }
635 if (iscreator()) {
636 $moddata[]="<A HREF=\"$CFG->wwwroot/course/edit.php\">".get_string("addnewcourse")."</A>";
637 $modicon[]=$icon;
638 $moddata[]="<A HREF=\"$CFG->wwwroot/course/teacher.php\">".get_string("assignteachers")."</A>";
639 $modicon[]=$icon;
5b337cdf 640 $fulladmin = "";
1924074c 641 }
642 if (isadmin()) {
643 $moddata[]="<A HREF=\"$CFG->wwwroot/course/categories.php\">".get_string("categories")."</A>";
644 $modicon[]=$icon;
645 $moddata[]="<A HREF=\"$CFG->wwwroot/course/delete.php\">".get_string("deletecourse")."</A>";
646 $modicon[]=$icon;
647 $moddata[]="<HR>";
648 $modicon[]="";
dae73c05 649 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/user.php?newuser=true\">".get_string("addnewuser")."</A>";
1924074c 650 $modicon[]=$icon;
dae73c05 651 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/user.php\">".get_string("edituser")."</A>";
1924074c 652 $modicon[]=$icon;
dae73c05 653 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/admin.php\">".get_string("assignadmins")."</A>";
1924074c 654 $modicon[]=$icon;
dae73c05 655 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/creators.php\">".get_string("assigncreators")."</A>";
1924074c 656 $modicon[]=$icon;
dae73c05 657 $moddata[]="<A HREF=\"$CFG->wwwroot/$CFG->admin/auth.php\">".get_string("authentication")."</A>";
1924074c 658 $modicon[]=$icon;
dae73c05 659 $fulladmin = "<P><A HREF=\"$CFG->wwwroot/$CFG->admin/\">".get_string("admin")."</A>...";
1924074c 660 }
5e367a2d 661
662 print_side_block(get_string("administration"), "", $moddata, $modicon, $fulladmin, $width);
663
19a55d67 664 echo "<IMG SRC=\"$CFG->wwwroot/pix/spacer.gif\" WIDTH=\"$width\" HEIGHT=1><BR>";
2b25f2a0 665}
666
b4d7002e 667function print_course_admin_links($course, $width=180) {
b0e3a925 668 global $USER, $CFG;
44dad735 669
13469b82 670 if (isteacher($course->id)) {
671 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/edit.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
672 if (isediting($course->id)) {
673 $admindata[]="<A HREF=\"view.php?id=$course->id&edit=off\">".get_string("turneditingoff")."</A>";
674 } else {
675 $admindata[]="<A HREF=\"view.php?id=$course->id&edit=on\">".get_string("turneditingon")."</A>";
676 }
677 $admindata[]="<A HREF=\"edit.php?id=$course->id\">".get_string("settings")."...</A>";
678 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/settings.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
679 if (!$course->teachers) {
680 $course->teachers = get_string("defaultcourseteachers");
681 }
682 $admindata[]="<A HREF=\"teachers.php?id=$course->id\">$course->teachers...</A>";
683 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/settings.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
684
685 $admindata[]="<A HREF=\"grades.php?id=$course->id\">".get_string("grades")."...</A>";
686 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/grades.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
687
688 $admindata[]="<A HREF=\"log.php?id=$course->id\">".get_string("logs")."...</A>";
689 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/log.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
690 $admindata[]="<A HREF=\"$CFG->wwwroot/files/index.php?id=$course->id\">".get_string("files")."...</A>";
691 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/files/pix/files.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
692
693 $admindata[]="<A HREF=\"$CFG->wwwroot/doc/view.php?id=$course->id&file=teacher.html\">".get_string("help")."...</A>";
694 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/mod/resource/icon.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
b4d7002e 695
13469b82 696 if ($teacherforum = forum_get_course_forum($course->id, "teacher")) {
697 $admindata[]="<A HREF=\"$CFG->wwwroot/mod/forum/view.php?f=$teacherforum->id\">".get_string("nameteacher", "forum")."</A>";
698 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/mod/forum/icon.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
699 }
700 } else {
701 $admindata[]="<A HREF=\"grade.php?id=$course->id\">".get_string("grades")."...</A>";
702 $adminicon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/grades.gif\" HEIGHT=16 WIDTH=16 ALT=\"\">";
703 }
44dad735 704
5e367a2d 705 print_side_block(get_string("administration"), "", $admindata, $adminicon, "", $width);
44dad735 706}
2b25f2a0 707
ba2e5d73 708function print_course_categories($categories, $selected="none", $width=180) {
0a263205 709 global $CFG, $THEME, $USER;
85098089 710
711 $strallowguests = get_string("allowguests");
712 $strrequireskey = get_string("requireskey");
ba2e5d73 713
0c656181 714 if ($selected == "index") { // Print comprehensive index of categories with courses
9fa49e22 715 if ($courses = get_courses()) {
0c656181 716 if (isset($USER->id) and !isadmin()) {
39246b72 717 print_simple_box_start("CENTER", "100%", $THEME->cellheading);
0c656181 718 print_heading("<A HREF=\"course/index.php?category=my\">".get_string("mycourses")."</A>", "LEFT");
719 $some = false;
720 echo "<UL>";
721 foreach ($courses as $key => $course) {
722 if (isteacher($course->id) or isstudent($course->id)) {
85098089 723 echo "<A HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">$course->fullname</A>";
724 echo "<BR>";
0c656181 725 $some = true;
726 }
727 }
728 if (!$some) {
729 print_string("nocoursesyet");
730 }
731 echo "</UL>";
732 print_simple_box_end();
733 print_spacer(8,1);
734 }
735 foreach ($categories as $category) {
bd4707bf 736 print_simple_box_start("CENTER", "100%");
7ef459eb 737 print_heading("<A HREF=\"course/index.php?category=$category->id\">$category->name</A>", "LEFT");
0c656181 738 $some = false;
739 echo "<UL>";
740 foreach ($courses as $key => $course) {
741 if ($course->category == $category->id) {
85098089 742 echo "<A HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">$course->fullname</A>";
743 echo "&nbsp;&nbsp;";
0c656181 744 unset($courses[$key]);
85098089 745 if ($course->guest ) {
746 echo "<A TITLE=\"$strallowguests\" HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">";
747 echo "<IMG ALT=\"\" HEIGHT=16 WIDTH=16 BORDER=0 SRC=\"$CFG->wwwroot/user/user.gif\"></A>";
748 }
749 if ($course->password) {
750 echo "<A TITLE=\"$strrequireskey\" HREF=\"$CFG->wwwroot/course/view.php?id=$course->id\">";
751 echo "<IMG ALT=\"\" HEIGHT=16 WIDTH=16 BORDER=0 SRC=\"$CFG->wwwroot/pix/i/key.gif\"></A>";
752 }
753 echo "<BR>";
0c656181 754 $some = true;
755 }
756 }
757 if (!$some) {
758 print_string("nocoursesyet");
759 }
760 echo "</UL>";
761 print_simple_box_end();
762 print_spacer(8,1);
763 }
ba2e5d73 764 }
0c656181 765
766 } else { // Print short list of categories only
767 foreach ($categories as $cat) {
768 $caticon[]="<IMG SRC=\"$CFG->wwwroot/pix/i/course.gif\" HEIGHT=16 WIDTH=16>";
769 if ($cat->id == $selected) {
770 $catdata[]="$cat->name";
771 } else {
772 $catdata[]="<A HREF=\"$CFG->wwwroot/course/index.php?category=$cat->id\">$cat->name</A>";
773 }
774 }
775 $catdata[] = "<A HREF=\"$CFG->wwwroot/course/index.php?category=all\">".get_string("fulllistofcourses")."</A>";
13770d0c 776 $caticon[] = "";
0c656181 777 if (isset($USER->id)) {
778 $catdata[] = "<A HREF=\"$CFG->wwwroot/course/index.php?category=my\">".get_string("mycourses")."</A>";
13770d0c 779 $caticon[] = "";
0c656181 780 }
13770d0c 781 print_side_block(get_string("categories"), "", $catdata, $caticon, "", $width);
ba2e5d73 782 }
ba2e5d73 783}
94361e02 784
2b8cef80 785function print_log_graph($course, $userid=0, $type="course.png", $date=0) {
786 global $CFG;
607809b3 787 if (empty($CFG->gdversion)) {
788 echo "(".get_string("gdneed").")";
789 } else {
790 echo "<IMG BORDER=0 SRC=\"$CFG->wwwroot/course/loggraph.php?id=$course->id&user=$userid&type=$type&date=$date\">";
791 }
2b8cef80 792}
793
11b0c469 794
795
796/// MODULE FUNCTIONS /////////////////////////////////////////////////////////////////
797
798function add_course_module($mod) {
799 GLOBAL $db;
800
e5dfd0f3 801 $mod->added = time();
11b0c469 802
e5dfd0f3 803 return insert_record("course_modules", $mod);
11b0c469 804}
805
806function add_mod_to_section($mod) {
807// Returns the course_sections ID where the mod is inserted
808 GLOBAL $db;
809
9fa49e22 810 if ($section = get_record("course_sections", "course", "$mod->course", "section", "$mod->section")) {
74666583 811 if (!empty($section->sequence)) {
e5dfd0f3 812 $newsequence = "$section->sequence,$mod->coursemodule";
11b0c469 813 } else {
814 $newsequence = "$mod->coursemodule";
815 }
e5dfd0f3 816 if (set_field("course_sections", "sequence", $newsequence, "id", $section->id)) {
817 return $section->id; // Return course_sections ID that was used.
11b0c469 818 } else {
e5dfd0f3 819 return 0;
11b0c469 820 }
821
822 } else { // Insert a new record
e5dfd0f3 823 $section->course = $mod->course;
824 $section->section = $mod->section;
825 $section->summary = "";
826 $section->sequence = $mod->coursemodule;
827 return insert_record("course_sections", $section);
11b0c469 828 }
829}
830
831function delete_course_module($mod) {
832 return set_field("course_modules", "deleted", 1, "id", $mod);
833}
834
835function delete_mod_from_section($mod, $section) {
836 GLOBAL $db;
837
e5dfd0f3 838 if ($section = get_record("course_sections", "id", "$section") ) {
11b0c469 839
e5dfd0f3 840 $modarray = explode(",", $section->sequence);
11b0c469 841
842 if ($key = array_keys ($modarray, $mod)) {
843 array_splice($modarray, $key[0], 1);
844 $newsequence = implode(",", $modarray);
e5dfd0f3 845 return set_field("course_sections", "sequence", $newsequence, "id", $section->id);
11b0c469 846 } else {
847 return false;
848 }
849
850 } else {
851 return false;
852 }
853}
854
855
7c0f2984 856function move_module($cm, $move) {
11b0c469 857 GLOBAL $db;
858
859 if (!$move) {
860 return true;
861 }
862
11b0c469 863 if (! $thissection = get_record("course_sections", "id", $cm->section)) {
864 error("This course section doesn't exist");
865 }
866
867 $mods = explode(",", $thissection->sequence);
868
869 $len = count($mods);
870 $pos = array_keys($mods, $cm->id);
871 $thepos = $pos[0];
872
873 if ($len == 0 || count($pos) == 0 ) {
874 error("Very strange. Could not find the required module in this section.");
875 }
876
877 if ($len == 1) {
878 $first = true;
879 $last = true;
880 } else {
881 $first = ($thepos == 0);
882 $last = ($thepos == $len - 1);
883 }
884
885 if ($move < 0) { // Moving the module up
886
887 if ($first) {
888 if ($thissection->section == 1) { // First section, do nothing
889 return true;
890 } else { // Push onto end of previous section
891 $prevsectionnumber = $thissection->section - 1;
9fa49e22 892 if (! $prevsection = get_record("course_sections", "course", "$thissection->course",
893 "section", "$prevsectionnumber")) {
11b0c469 894 error("Previous section ($prevsection->id) doesn't exist");
895 }
896
74666583 897 if (!empty($prevsection->sequence)) {
11b0c469 898 $newsequence = "$prevsection->sequence,$cm->id";
899 } else {
900 $newsequence = "$cm->id";
901 }
902
903 if (! set_field("course_sections", "sequence", $newsequence, "id", $prevsection->id)) {
904 error("Previous section could not be updated");
905 }
906
907 if (! set_field("course_modules", "section", $prevsection->id, "id", $cm->id)) {
908 error("Module could not be updated");
909 }
910
911 array_splice($mods, 0, 1);
912 $newsequence = implode(",", $mods);
913 if (! set_field("course_sections", "sequence", $newsequence, "id", $thissection->id)) {
914 error("Module could not be updated");
915 }
916
917 return true;
918
919 }
920 } else { // move up within this section
921 $swap = $mods[$thepos-1];
922 $mods[$thepos-1] = $mods[$thepos];
923 $mods[$thepos] = $swap;
924
925 $newsequence = implode(",", $mods);
926 if (! set_field("course_sections", "sequence", $newsequence, "id", $thissection->id)) {
927 error("This section could not be updated");
928 }
929 return true;
930 }
931
932 } else { // Moving the module down
933
934 if ($last) {
935 $nextsectionnumber = $thissection->section + 1;
9fa49e22 936 if ($nextsection = get_record("course_sections", "course", "$thissection->course",
937 "section", "$nextsectionnumber")) {
11b0c469 938
74666583 939 if (!empty($nextsection->sequence)) {
11b0c469 940 $newsequence = "$cm->id,$nextsection->sequence";
941 } else {
942 $newsequence = "$cm->id";
943 }
944
945 if (! set_field("course_sections", "sequence", $newsequence, "id", $nextsection->id)) {
946 error("Next section could not be updated");
947 }
948
949 if (! set_field("course_modules", "section", $nextsection->id, "id", $cm->id)) {
950 error("Module could not be updated");
951 }
952
953 array_splice($mods, $thepos, 1);
954 $newsequence = implode(",", $mods);
955 if (! set_field("course_sections", "sequence", $newsequence, "id", $thissection->id)) {
956 error("This section could not be updated");
957 }
958 return true;
959
960 } else { // There is no next section, so just return
961 return true;
962
963 }
964 } else { // move down within this section
965 $swap = $mods[$thepos+1];
966 $mods[$thepos+1] = $mods[$thepos];
967 $mods[$thepos] = $swap;
968
969 $newsequence = implode(",", $mods);
970 if (! set_field("course_sections", "sequence", $newsequence, "id", $thissection->id)) {
971 error("This section could not be updated");
972 }
973 return true;
974 }
975 }
976}
977
94361e02 978function make_editing_buttons($moduleid, $absolute=false) {
979 global $CFG;
980
90845098 981 $delete = get_string("delete");
982 $moveup = get_string("moveup");
983 $movedown = get_string("movedown");
984 $update = get_string("update");
94361e02 985
986 if ($absolute) {
987 $path = "$CFG->wwwroot/course/";
988 } else {
989 $path = "";
990 }
5e367a2d 991 return "<A TITLE=\"$delete\" HREF=\"".$path."mod.php?delete=$moduleid\"><IMG
97c270e9 992 SRC=".$path."../pix/t/delete.gif BORDER=0></A>
993 <A TITLE=\"$moveup\" HREF=\"".$path."mod.php?id=$moduleid&move=-1\"><IMG
994 SRC=".$path."../pix/t/up.gif BORDER=0></A>
995 <A TITLE=\"$movedown\" HREF=\"".$path."mod.php?id=$moduleid&move=1\"><IMG
996 SRC=".$path."../pix/t/down.gif BORDER=0></A>
997 <A TITLE=\"$update\" HREF=\"".$path."mod.php?update=$moduleid\"><IMG
998 SRC=".$path."../pix/t/edit.gif BORDER=0></A>";
90845098 999}
1000
f9903ed0 1001?>