calendar/lib: calendar_set_filters() use pre-fetched context and course recs
[moodle-pu.git] / calendar / lib.php
blob1eac3efa43b107b7c2984a71f0e7d1c2570ae3d7
1 <?php // $Id$
3 /////////////////////////////////////////////////////////////////////////////
4 // //
5 // NOTICE OF COPYRIGHT //
6 // //
7 // Moodle - Calendar extension //
8 // //
9 // Copyright (C) 2003-2004 Greek School Network www.sch.gr //
10 // //
11 // Designed by: //
12 // Avgoustos Tsinakos (tsinakos@teikav.edu.gr) //
13 // Jon Papaioannou (pj@moodle.org) //
14 // //
15 // Programming and development: //
16 // Jon Papaioannou (pj@moodle.org) //
17 // //
18 // For bugs, suggestions, etc contact: //
19 // Jon Papaioannou (pj@moodle.org) //
20 // //
21 // The current module was developed at the University of Macedonia //
22 // (www.uom.gr) under the funding of the Greek School Network (www.sch.gr) //
23 // The aim of this project is to provide additional and improved //
24 // functionality to the Asynchronous Distance Education service that the //
25 // Greek School Network deploys. //
26 // //
27 // This program is free software; you can redistribute it and/or modify //
28 // it under the terms of the GNU General Public License as published by //
29 // the Free Software Foundation; either version 2 of the License, or //
30 // (at your option) any later version. //
31 // //
32 // This program is distributed in the hope that it will be useful, //
33 // but WITHOUT ANY WARRANTY; without even the implied warranty of //
34 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
35 // GNU General Public License for more details: //
36 // //
37 // http://www.gnu.org/copyleft/gpl.html //
38 // //
39 /////////////////////////////////////////////////////////////////////////////
41 // These are read by the administration component to provide default values
42 define('CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD', 21);
43 define('CALENDAR_DEFAULT_UPCOMING_MAXEVENTS', 10);
44 define('CALENDAR_DEFAULT_STARTING_WEEKDAY', 1);
45 // This is a packed bitfield: day X is "weekend" if $field & (1 << X) is true
46 // Default value = 65 = 64 + 1 = 2^6 + 2^0 = Saturday & Sunday
47 define('CALENDAR_DEFAULT_WEEKEND', 65);
49 // Fetch the correct values from admin settings/lang pack
50 // If no such settings found, use the above defaults
51 $firstday = isset($CFG->calendar_startwday) ? $CFG->calendar_startwday : get_string('firstdayofweek');
52 if(!is_numeric($firstday)) {
53 define ('CALENDAR_STARTING_WEEKDAY', CALENDAR_DEFAULT_STARTING_WEEKDAY);
55 else {
56 define ('CALENDAR_STARTING_WEEKDAY', intval($firstday) % 7);
58 define ('CALENDAR_UPCOMING_DAYS', isset($CFG->calendar_lookahead) ? intval($CFG->calendar_lookahead) : CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD);
59 define ('CALENDAR_UPCOMING_MAXEVENTS', isset($CFG->calendar_maxevents) ? intval($CFG->calendar_maxevents) : CALENDAR_DEFAULT_UPCOMING_MAXEVENTS);
60 define ('CALENDAR_WEEKEND', isset($CFG->calendar_weekend) ? intval($CFG->calendar_weekend) : CALENDAR_DEFAULT_WEEKEND);
61 define ('CALENDAR_URL', $CFG->wwwroot.'/calendar/');
62 define ('CALENDAR_TF_24', '%H:%M');
63 define ('CALENDAR_TF_12', '%I:%M %p');
65 define ('CALENDAR_MAXCOURSES', 3);
67 $CALENDARDAYS = array('sunday','monday','tuesday','wednesday','thursday','friday','saturday');
71 function calendar_get_mini($courses, $groups, $users, $cal_month = false, $cal_year = false) {
72 global $CFG, $USER;
74 $display = &New stdClass;
75 $display->minwday = get_user_preferences('calendar_startwday', CALENDAR_STARTING_WEEKDAY);
76 $display->maxwday = $display->minwday + 6;
78 $content = '';
80 if(!empty($cal_month) && !empty($cal_year)) {
81 $thisdate = usergetdate(time()); // Date and time the user sees at his location
82 if($cal_month == $thisdate['mon'] && $cal_year == $thisdate['year']) {
83 // Navigated to this month
84 $date = $thisdate;
85 $display->thismonth = true;
87 else {
88 // Navigated to other month, let's do a nice trick and save us a lot of work...
89 if(!checkdate($cal_month, 1, $cal_year)) {
90 $date = array('mday' => 1, 'mon' => $thisdate['mon'], 'year' => $thisdate['year']);
91 $display->thismonth = true;
93 else {
94 $date = array('mday' => 1, 'mon' => $cal_month, 'year' => $cal_year);
95 $display->thismonth = false;
99 else {
100 $date = usergetdate(time()); // Date and time the user sees at his location
101 $display->thismonth = true;
104 // Fill in the variables we 're going to use, nice and tidy
105 list($d, $m, $y) = array($date['mday'], $date['mon'], $date['year']); // This is what we want to display
106 $display->maxdays = calendar_days_in_month($m, $y);
108 if (get_user_timezone_offset() < 99) {
109 // We 'll keep these values as GMT here, and offset them when the time comes to query the db
110 $display->tstart = gmmktime(0, 0, 0, $m, 1, $y); // This is GMT
111 $display->tend = gmmktime(23, 59, 59, $m, $display->maxdays, $y); // GMT
112 } else {
113 // no timezone info specified
114 $display->tstart = mktime(0, 0, 0, $m, 1, $y);
115 $display->tend = mktime(23, 59, 59, $m, $display->maxdays, $y);
118 $startwday = dayofweek(1, $m, $y);
120 // Align the starting weekday to fall in our display range
121 // This is simple, not foolproof.
122 if($startwday < $display->minwday) {
123 $startwday += 7;
126 // TODO: THIS IS TEMPORARY CODE!
127 // [pj] I was just reading through this and realized that I when writing this code I was probably
128 // asking for trouble, as all these time manipulations seem to be unnecessary and a simple
129 // make_timestamp would accomplish the same thing. So here goes a test:
130 //$test_start = make_timestamp($y, $m, 1);
131 //$test_end = make_timestamp($y, $m, $display->maxdays, 23, 59, 59);
132 //if($test_start != usertime($display->tstart) - dst_offset_on($display->tstart)) {
133 //notify('Failed assertion in calendar/lib.php line 126; display->tstart = '.$display->tstart.', dst_offset = '.dst_offset_on($display->tstart).', usertime = '.usertime($display->tstart).', make_t = '.$test_start);
135 //if($test_end != usertime($display->tend) - dst_offset_on($display->tend)) {
136 //notify('Failed assertion in calendar/lib.php line 130; display->tend = '.$display->tend.', dst_offset = '.dst_offset_on($display->tend).', usertime = '.usertime($display->tend).', make_t = '.$test_end);
140 // Get the events matching our criteria. Don't forget to offset the timestamps for the user's TZ!
141 $whereclause = calendar_sql_where(
142 usertime($display->tstart) - dst_offset_on($display->tstart),
143 usertime($display->tend) - dst_offset_on($display->tend),
144 $users, $groups, $courses);
146 if($whereclause === false) {
147 $events = array();
149 else {
150 $events = get_records_select('event', $whereclause, 'timestart');
153 // Set event course class for course events
154 if (!empty($events)) {
155 foreach ($events as $eventid => $event) {
156 if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) {
157 $event->class = 'event_course'.array_search($event->courseid, $courses) % CALENDAR_MAXCOURSES;
159 if (!empty($event->modulename)) {
160 $cm = get_coursemodule_from_instance($event->modulename, $event->instance);
161 if (!groups_course_module_visible($cm)) {
162 unset($events[$eventid]);
168 // This is either a genius idea or an idiot idea: in order to not complicate things, we use this rule: if, after
169 // possibly removing SITEID from $courses, there is only one course left, then clicking on a day in the month
170 // will also set the $SESSION->cal_courses_shown variable to that one course. Otherwise, we 'd need to add extra
171 // arguments to this function.
173 $morehref = '';
174 if(!empty($courses)) {
175 $courses = array_diff($courses, array(SITEID));
176 if(count($courses) == 1) {
177 $morehref = '&amp;course='.reset($courses);
181 // We want to have easy access by day, since the display is on a per-day basis.
182 // Arguments passed by reference.
183 //calendar_events_by_day($events, $display->tstart, $eventsbyday, $durationbyday, $typesbyday);
184 calendar_events_by_day($events, $m, $y, $eventsbyday, $durationbyday, $typesbyday, $courses);
186 //Accessibility: added summary and <abbr> elements.
187 ///global $CALENDARDAYS; appears to be broken.
188 $days_title = array('sunday','monday','tuesday','wednesday','thursday','friday','saturday');
190 $summary = get_string('calendarheading', 'calendar', userdate(make_timestamp($y, $m), get_string('strftimemonthyear')));
191 $summary = get_string('tabledata', 'access', $summary);
192 $content .= '<table class="minicalendar" summary="'.$summary.'">'; // Begin table
193 $content .= '<tr class="weekdays">'; // Header row: day names
195 // Print out the names of the weekdays
196 $days = array('sun', 'mon', 'tue', 'wed', 'thu', 'fri', 'sat');
197 for($i = $display->minwday; $i <= $display->maxwday; ++$i) {
198 // This uses the % operator to get the correct weekday no matter what shift we have
199 // applied to the $display->minwday : $display->maxwday range from the default 0 : 6
200 $content .= '<th scope="col"><abbr title="'. get_string($days_title[$i % 7], 'calendar') .'">'.
201 get_string($days[$i % 7], 'calendar') ."</abbr></th>\n";
204 $content .= '</tr><tr>'; // End of day names; prepare for day numbers
206 // For the table display. $week is the row; $dayweek is the column.
207 $dayweek = $startwday;
209 // Paddding (the first week may have blank days in the beginning)
210 for($i = $display->minwday; $i < $startwday; ++$i) {
211 $content .= '<td class="dayblank">&nbsp;</td>'."\n";
214 // Now display all the calendar
215 for($day = 1; $day <= $display->maxdays; ++$day, ++$dayweek) {
216 if($dayweek > $display->maxwday) {
217 // We need to change week (table row)
218 $content .= '</tr><tr>';
219 $dayweek = $display->minwday;
222 // Reset vars
223 $cell = '';
224 if(CALENDAR_WEEKEND & (1 << ($dayweek % 7))) {
225 // Weekend. This is true no matter what the exact range is.
226 $class = 'weekend day';
228 else {
229 // Normal working day.
230 $class = 'day';
233 // Special visual fx if an event is defined
234 if(isset($eventsbyday[$day])) {
235 $dayhref = calendar_get_link_href(CALENDAR_URL.'view.php?view=day'.$morehref.'&amp;', $day, $m, $y);
237 // OverLib popup
238 $popupcontent = '';
239 foreach($eventsbyday[$day] as $eventid) {
240 if (!isset($events[$eventid])) {
241 continue;
243 $event = $events[$eventid];
244 if(!empty($event->modulename)) {
245 $popupicon = $CFG->modpixpath.'/'.$event->modulename.'/icon.gif';
246 $popupalt = $event->modulename;
248 } else if ($event->courseid == SITEID) { // Site event
249 $popupicon = $CFG->pixpath.'/c/site.gif';
250 $popupalt = '';
251 } else if ($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) { // Course event
252 $popupicon = $CFG->pixpath.'/c/course.gif';
253 $popupalt = '';
254 } else if ($event->groupid) { // Group event
255 $popupicon = $CFG->pixpath.'/c/group.gif';
256 $popupalt = '';
257 } else if ($event->userid) { // User event
258 $popupicon = $CFG->pixpath.'/c/user.gif';
259 $popupalt = '';
261 $popupcontent .= '<div><img class="icon" src="'.$popupicon.'" alt="'.$popupalt.'" /><a href="'.$dayhref.'#event_'.$event->id.'">'.format_string($event->name, true).'</a></div>';
264 //Accessibility: functionality moved to calendar_get_popup.
265 if($display->thismonth && $day == $d) {
266 $popup = calendar_get_popup(true, $events[$eventid]->timestart, $popupcontent);
267 } else {
268 $popup = calendar_get_popup(false, $events[$eventid]->timestart, $popupcontent);
271 // Class and cell content
272 if(isset($typesbyday[$day]['startglobal'])) {
273 $class .= ' event_global';
275 else if(isset($typesbyday[$day]['startcourse'])) {
276 $class .= ' event_course';
278 else if(isset($typesbyday[$day]['startgroup'])) {
279 $class .= ' event_group';
281 else if(isset($typesbyday[$day]['startuser'])) {
282 $class .= ' event_user';
284 $cell = '<a href="'.$dayhref.'" '.$popup.'>'.$day.'</a>';
286 else {
287 $cell = $day;
290 if(isset($typesbyday[$day]['durationglobal'])) {
291 $class .= ' duration_global';
293 else if(isset($typesbyday[$day]['durationcourse'])) {
294 $class .= ' duration_course';
296 else if(isset($typesbyday[$day]['durationgroup'])) {
297 $class .= ' duration_group';
299 else if(isset($typesbyday[$day]['durationuser'])) {
300 $class .= ' duration_user';
303 // If event has a class set then add it to the table day <td> tag
304 // Note: only one colour for minicalendar
305 if(isset($eventsbyday[$day])) {
306 foreach($eventsbyday[$day] as $eventid) {
307 if (!isset($events[$eventid])) {
308 continue;
310 $event = $events[$eventid];
311 if (!empty($event->class)) {
312 $class .= ' '.$event->class;
314 break;
318 // Special visual fx for today
319 //Accessibility: hidden text for today, and popup.
320 if($display->thismonth && $day == $d) {
321 $class .= ' today';
322 $today = get_string('today', 'calendar').' '.userdate(time(), get_string('strftimedayshort'));
324 if(! isset($eventsbyday[$day])) {
325 $class .= ' eventnone';
326 $popup = calendar_get_popup(true, false);
327 $cell = '<a href="#" '.$popup.'>'.$day.'</a>';
329 $cell = '<span class="accesshide">'.$today.' </span>'.$cell;
332 // Just display it
333 if(!empty($class)) {
334 $class = ' class="'.$class.'"';
336 $content .= '<td'.$class.'>'.$cell."</td>\n";
339 // Paddding (the last week may have blank days at the end)
340 for($i = $dayweek; $i <= $display->maxwday; ++$i) {
341 $content .= '<td class="dayblank">&nbsp;</td>';
343 $content .= '</tr>'; // Last row ends
345 $content .= '</table>'; // Tabular display of days ends
347 return $content;
351 * calendar_get_popup, called at multiple points in from calendar_get_mini.
352 * Copied and modified from calendar_get_mini.
353 * @uses OverLib popup.
354 * @param $is_today bool, false except when called on the current day.
355 * @param $event_timestart mixed, $events[$eventid]->timestart, OR false if there are no events.
356 * @param $popupcontent string.
357 * @return $popup string, contains onmousover and onmouseout events.
359 function calendar_get_popup($is_today, $event_timestart, $popupcontent='') {
360 $popupcaption = '';
361 if($is_today) {
362 $popupcaption = get_string('today', 'calendar').' ';
364 if (false === $event_timestart) {
365 $popupcaption .= userdate(time(), get_string('strftimedayshort'));
366 $popupcontent = get_string('eventnone', 'calendar');
368 } else {
369 $popupcaption .= get_string('eventsfor', 'calendar', userdate($event_timestart, get_string('strftimedayshort')));
371 $popupcontent = str_replace("'", "\'", htmlspecialchars($popupcontent));
372 $popupcaption = str_replace("'", "\'", htmlspecialchars($popupcaption));
373 $popup = 'onmouseover="return overlib(\''.$popupcontent.'\', CAPTION, \''.$popupcaption.'\');" onmouseout="return nd();"';
374 return $popup;
377 function calendar_get_upcoming($courses, $groups, $users, $daysinfuture, $maxevents, $fromtime=0) {
378 global $CFG;
380 $display = &new stdClass;
381 $display->range = $daysinfuture; // How many days in the future we 'll look
382 $display->maxevents = $maxevents;
384 $output = array();
386 // Prepare "course caching", since it may save us a lot of queries
387 $coursecache = array();
389 $processed = 0;
390 $now = time(); // We 'll need this later
391 $usermidnighttoday = usergetmidnight($now);
393 if ($fromtime) {
394 $display->tstart = $fromtime;
395 } else {
396 $display->tstart = $usermidnighttoday;
399 // This works correctly with respect to the user's DST, but it is accurate
400 // only because $fromtime is always the exact midnight of some day!
401 $display->tend = usergetmidnight($display->tstart + DAYSECS * $display->range + 3 * HOURSECS) - 1;
403 // Get the events matching our criteria
404 $whereclause = calendar_sql_where($display->tstart, $display->tend, $users, $groups, $courses);
405 if ($whereclause === false) {
406 $events = false;
407 } else {
408 $events = get_records_select('event', $whereclause, 'timestart');
411 // This is either a genius idea or an idiot idea: in order to not complicate things, we use this rule: if, after
412 // possibly removing SITEID from $courses, there is only one course left, then clicking on a day in the month
413 // will also set the $SESSION->cal_courses_shown variable to that one course. Otherwise, we 'd need to add extra
414 // arguments to this function.
416 $morehref = '';
417 if(!empty($courses)) {
418 $courses = array_diff($courses, array(SITEID));
419 if(count($courses) == 1) {
420 $morehref = '&amp;course='.reset($courses);
424 if($events !== false) {
426 foreach($events as $event) {
427 if(!empty($event->modulename)) {
428 $mod = get_coursemodule_from_instance($event->modulename, $event->instance);
429 if (!groups_course_module_visible($mod)) {
430 continue;
434 if($processed >= $display->maxevents) {
435 break;
438 $event->time = calendar_format_event_time($event, $now, $morehref);
439 $output[] = $event;
440 ++$processed;
443 return $output;
446 function calendar_add_event_metadata($event) {
447 global $CFG;
449 //Support multilang in event->name
450 $event->name = format_string($event->name,true);
452 if(!empty($event->modulename)) { // Activity event
453 // The module name is set. I will assume that it has to be displayed, and
454 // also that it is an automatically-generated event. And of course that the
455 // fields for get_coursemodule_from_instance are set correctly.
456 $module = calendar_get_module_cached($coursecache, $event->modulename, $event->instance);
458 if ($module === false) {
459 return;
462 $modulename = get_string('modulename', $event->modulename);
463 $eventtype = get_string($event->eventtype, $event->modulename);
464 $icon = $CFG->modpixpath.'/'.$event->modulename.'/icon.gif';
466 $event->icon = '<img height="16" width="16" src="'.$icon.'" alt="'.$eventtype.'" title="'.$modulename.'" style="vertical-align: middle;" />';
467 $event->referer = '<a href="'.$CFG->wwwroot.'/mod/'.$event->modulename.'/view.php?id='.$module->id.'">'.$event->name.'</a>';
468 $event->courselink = '<a href="'.$CFG->wwwroot.'/course/view.php?id='.$module->course.'">'.$coursecache[$module->course]->fullname.'</a>';
469 $event->cmid = $module->id;
472 } else if($event->courseid == SITEID) { // Site event
473 $event->icon = '<img height="16" width="16" src="'.$CFG->pixpath.'/c/site.gif" alt="'.get_string('globalevent', 'calendar').'" style="vertical-align: middle;" />';
474 $event->cssclass = 'event_global';
475 } else if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) { // Course event
476 calendar_get_course_cached($coursecache, $event->courseid);
477 $event->icon = '<img height="16" width="16" src="'.$CFG->pixpath.'/c/course.gif" alt="'.get_string('courseevent', 'calendar').'" style="vertical-align: middle;" />';
478 $event->courselink = '<a href="'.$CFG->wwwroot.'/course/view.php?id='.$event->courseid.'">'.$coursecache[$event->courseid]->fullname.'</a>';
479 $event->cssclass = 'event_course';
480 } else if ($event->groupid) { // Group event
481 $event->icon = '<img height="16" width="16" src="'.$CFG->pixpath.'/c/group.gif" alt="'.get_string('groupevent', 'calendar').'" style="vertical-align: middle;" />';
482 $event->cssclass = 'event_group';
483 } else if($event->userid) { // User event
484 $event->icon = '<img height="16" width="16" src="'.$CFG->pixpath.'/c/user.gif" alt="'.get_string('userevent', 'calendar').'" style="vertical-align: middle;" />';
485 $event->cssclass = 'event_user';
487 return $event;
490 function calendar_print_event($event) {
491 global $CFG, $USER;
493 static $strftimetime;
495 $event = calendar_add_event_metadata($event);
496 echo '<a name="event_'.$event->id.'"></a><table class="event" cellspacing="0">';
497 echo '<tr><td class="picture">';
498 if (!empty($event->icon)) {
499 echo $event->icon;
500 } else {
501 print_spacer(16,16);
503 echo '</td>';
504 echo '<td class="topic">';
506 if (!empty($event->referer)) {
507 echo '<div class="referer">'.$event->referer.'</div>';
508 } else {
509 echo '<div class="name">'.$event->name."</div>";
511 if (!empty($event->courselink)) {
512 echo '<div class="course">'.$event->courselink.' </div>';
514 if (!empty($event->time)) {
515 echo '<span class="date">'.$event->time.'</span>';
516 } else {
517 echo '<span class="date">'.calendar_time_representation($event->timestart).'</span>';
520 echo '</td></tr>';
521 echo '<tr><td class="side">&nbsp;</td>';
523 // If event has a class set then add it to the event <td> tag
524 $eventclass='';
525 if (!empty($event->class)) {
526 $eventclass = ' '.$event->class;
529 echo '<td class="description '.$event->cssclass.$eventclass.'">';
530 echo format_text($event->description, FORMAT_HTML);
531 if (calendar_edit_event_allowed($event)) {
532 echo '<div class="commands">';
533 $calendarcourseid = '';
534 if (!empty($event->calendarcourseid)) {
535 $calendarcourseid = '&amp;course='.$event->calendarcourseid;
537 if (empty($event->cmid)) {
538 $editlink = CALENDAR_URL.'event.php?action=edit&amp;id='.$event->id.$calendarcourseid;
539 $deletelink = CALENDAR_URL.'event.php?action=delete&amp;id='.$event->id.$calendarcourseid;
540 } else {
541 $editlink = $CFG->wwwroot.'/course/mod.php?update='.$event->cmid.'&amp;return=true&amp;sesskey='.$USER->sesskey;
542 $deletelink = $CFG->wwwroot.'/course/mod.php?delete='.$event->cmid.'&amp;sesskey='.$USER->sesskey;;
544 echo ' <a href="'.$editlink.'"><img
545 src="'.$CFG->pixpath.'/t/edit.gif" alt="'.get_string('tt_editevent', 'calendar').'"
546 title="'.get_string('tt_editevent', 'calendar').'" /></a>';
547 echo ' <a href="'.$deletelink.'"><img
548 src="'.$CFG->pixpath.'/t/delete.gif" alt="'.get_string('tt_deleteevent', 'calendar').'"
549 title="'.get_string('tt_deleteevent', 'calendar').'" /></a>';
550 echo '</div>';
552 echo '</td></tr></table>';
556 function calendar_sql_where($tstart, $tend, $users, $groups, $courses, $withduration=true, $ignorehidden=true) {
557 $whereclause = '';
558 // Quick test
559 if(is_bool($users) && is_bool($groups) && is_bool($courses)) {
560 return false;
563 if(is_array($users) && !empty($users)) {
564 // Events from a number of users
565 if(!empty($whereclause)) $whereclause .= ' OR';
566 $whereclause .= ' (userid IN ('.implode(',', $users).') AND courseid = 0 AND groupid = 0)';
568 else if(is_numeric($users)) {
569 // Events from one user
570 if(!empty($whereclause)) $whereclause .= ' OR';
571 $whereclause .= ' (userid = '.$users.' AND courseid = 0 AND groupid = 0)';
573 else if($users === true) {
574 // Events from ALL users
575 if(!empty($whereclause)) $whereclause .= ' OR';
576 $whereclause .= ' (userid != 0 AND courseid = 0 AND groupid = 0)';
578 else if($users === false) {
579 // No user at all, do nothing
582 if(is_array($groups) && !empty($groups)) {
583 // Events from a number of groups
584 if(!empty($whereclause)) $whereclause .= ' OR';
585 $whereclause .= ' groupid IN ('.implode(',', $groups).')';
587 else if(is_numeric($groups)) {
588 // Events from one group
589 if(!empty($whereclause)) $whereclause .= ' OR ';
590 $whereclause .= ' groupid = '.$groups;
592 else if($groups === true) {
593 // Events from ALL groups
594 if(!empty($whereclause)) $whereclause .= ' OR ';
595 $whereclause .= ' groupid != 0';
597 // boolean false (no groups at all): we don't need to do anything
599 if(is_array($courses)) {
600 // A number of courses (maybe none at all!)
601 if(!empty($courses)) {
602 if(!empty($whereclause)) {
603 $whereclause .= ' OR';
605 $whereclause .= ' (groupid = 0 AND courseid IN ('.implode(',', $courses).'))';
607 else {
608 // This means NO courses, not that we don't care!
609 // No need to do anything
612 else if(is_numeric($courses)) {
613 // One course
614 if(!empty($whereclause)) $whereclause .= ' OR';
615 $whereclause .= ' (groupid = 0 AND courseid = '.$courses.')';
617 else if($courses === true) {
618 // Events from ALL courses
619 if(!empty($whereclause)) $whereclause .= ' OR';
620 $whereclause .= ' (groupid = 0 AND courseid != 0)';
623 // Security check: if, by now, we have NOTHING in $whereclause, then it means
624 // that NO event-selecting clauses were defined. Thus, we won't be returning ANY
625 // events no matter what. Allowing the code to proceed might return a completely
626 // valid query with only time constraints, thus selecting ALL events in that time frame!
627 if(empty($whereclause)) {
628 return false;
631 if($withduration) {
632 $timeclause = '(timestart >= '.$tstart.' OR timestart + timeduration > '.$tstart.') AND timestart <= '.$tend;
634 else {
635 $timeclause = 'timestart >= '.$tstart.' AND timestart <= '.$tend;
637 if(!empty($whereclause)) {
638 // We have additional constraints
639 $whereclause = $timeclause.' AND ('.$whereclause.')';
641 else {
642 // Just basic time filtering
643 $whereclause = $timeclause;
646 if ($ignorehidden) {
647 $whereclause .= ' AND visible = 1';
650 return $whereclause;
653 function calendar_top_controls($type, $data) {
654 global $CFG, $CALENDARDAYS, $THEME;
655 $content = '';
656 if(!isset($data['d'])) {
657 $data['d'] = 1;
660 // Ensure course id passed if relevant
661 // Required due to changes in view/lib.php mainly (calendar_session_vars())
662 $courseid = '';
663 if (!empty($data['id'])) {
664 $courseid = '&amp;course='.$data['id'];
667 if(!checkdate($data['m'], $data['d'], $data['y'])) {
668 $time = time();
670 else {
671 $time = make_timestamp($data['y'], $data['m'], $data['d']);
673 $date = usergetdate($time);
675 $data['m'] = $date['mon'];
676 $data['y'] = $date['year'];
678 //Accessibility: calendar block controls, replaced <table> with <div>.
679 //$nexttext = link_arrow_right(get_string('monthnext', 'access'), $url='', $accesshide=true);
680 //$prevtext = link_arrow_left(get_string('monthprev', 'access'), $url='', $accesshide=true);
682 switch($type) {
683 case 'frontpage':
684 list($prevmonth, $prevyear) = calendar_sub_month($data['m'], $data['y']);
685 list($nextmonth, $nextyear) = calendar_add_month($data['m'], $data['y']);
686 $nextlink = calendar_get_link_next(get_string('monthnext', 'access'), 'index.php?', 0, $nextmonth, $nextyear, $accesshide=true);
687 $prevlink = calendar_get_link_previous(get_string('monthprev', 'access'), 'index.php?', 0, $prevmonth, $prevyear, true);
688 $content .= "\n".'<div class="calendar-controls">'. $prevlink;
689 $content .= '<span class="hide"> | </span><span class="current"><a href="'.calendar_get_link_href(CALENDAR_URL.'view.php?view=month'.$courseid.'&amp;', 1, $data['m'], $data['y']).'">'.userdate($time, get_string('strftimemonthyear')).'</a></span>';
690 $content .= '<span class="hide"> | </span>'. $nextlink ."\n";
691 $content .= "<span class=\"clearer\"><!-- --></span></div>\n";
692 break;
693 case 'course':
694 list($prevmonth, $prevyear) = calendar_sub_month($data['m'], $data['y']);
695 list($nextmonth, $nextyear) = calendar_add_month($data['m'], $data['y']);
696 $nextlink = calendar_get_link_next(get_string('monthnext', 'access'), 'view.php?id='.$data['id'].'&amp;', 0, $nextmonth, $nextyear, $accesshide=true);
697 $prevlink = calendar_get_link_previous(get_string('monthprev', 'access'), 'view.php?id='.$data['id'].'&amp;', 0, $prevmonth, $prevyear, true);
698 $content .= "\n".'<div class="calendar-controls">'. $prevlink;
699 $content .= '<span class="hide"> | </span><span class="current"><a href="'.calendar_get_link_href(CALENDAR_URL.'view.php?view=month'.$courseid.'&amp;', 1, $data['m'], $data['y']).'">'.userdate($time, get_string('strftimemonthyear')).'</a></span>';
700 $content .= '<span class="hide"> | </span>'. $nextlink ."\n";
701 $content .= "<span class=\"clearer\"><!-- --></span></div>\n";
702 break;
703 case 'upcoming':
704 $content .= '<div style="text-align: center;"><a href="'.CALENDAR_URL.'view.php?view=upcoming"'.$courseid.'>'.userdate($time, get_string('strftimemonthyear'))."</a></div>\n";
705 break;
706 case 'display':
707 $content .= '<div style="text-align: center;"><a href="'.calendar_get_link_href(CALENDAR_URL.'view.php?view=month'.$courseid.'&amp;', 1, $data['m'], $data['y']).'">'.userdate($time, get_string('strftimemonthyear'))."</a></div>\n";
708 break;
709 case 'month':
710 list($prevmonth, $prevyear) = calendar_sub_month($data['m'], $data['y']);
711 list($nextmonth, $nextyear) = calendar_add_month($data['m'], $data['y']);
712 $prevdate = make_timestamp($prevyear, $prevmonth, 1);
713 $nextdate = make_timestamp($nextyear, $nextmonth, 1);
714 $content .= "\n".'<div class="calendar-controls">';
715 $content .= calendar_get_link_previous(userdate($prevdate, get_string('strftimemonthyear')), 'view.php?view=month'.$courseid.'&amp;', 1, $prevmonth, $prevyear);
716 $content .= '<span class="hide"> | </span><span class="current">'.userdate($time, get_string('strftimemonthyear'))."</span>\n";
717 $content .= '<span class="hide"> | </span>'.calendar_get_link_next(userdate($nextdate, get_string('strftimemonthyear')), 'view.php?view=month'.$courseid.'&amp;', 1, $nextmonth, $nextyear);
718 $content .= "<span class=\"clearer\"><!-- --></span></div>\n";
719 break;
720 case 'day':
721 $data['d'] = $date['mday']; // Just for convenience
722 $prevdate = usergetdate(make_timestamp($data['y'], $data['m'], $data['d'] - 1));
723 $nextdate = usergetdate(make_timestamp($data['y'], $data['m'], $data['d'] + 1));
724 $prevname = calendar_wday_name($CALENDARDAYS[$prevdate['wday']]);
725 $nextname = calendar_wday_name($CALENDARDAYS[$nextdate['wday']]);
726 $content .= "\n".'<div class="calendar-controls">';
727 $content .= calendar_get_link_previous($prevname, 'view.php?view=day'.$courseid.'&amp;', $prevdate['mday'], $prevdate['mon'], $prevdate['year']);
729 // Get the format string
730 $text = get_string('strftimedaydate');
732 // Regexp hackery to make a link out of the month/year part
733 $text = ereg_replace('(%B.+%Y|%Y.+%B|%Y.+%m[^ ]+)', '<a href="'.calendar_get_link_href('view.php?view=month&amp;', 1, $data['m'], $data['y']).'">\\1</a>', $text);
734 $text = ereg_replace('(F.+Y|Y.+F|Y.+m[^ ]+)', '<a href="'.calendar_get_link_href('view.php?view=month&amp;', 1, $data['m'], $data['y']).'">\\1</a>', $text);
736 // Replace with actual values and lose any day leading zero
737 $text = userdate($time, $text);
738 // Print the actual thing
739 $content .= '<span class="hide"> | </span><span class="current">'.$text.'</span>';
741 $content .= '<span class="hide"> | </span>'. calendar_get_link_next($nextname, 'view.php?view=day'.$courseid.'&amp;', $nextdate['mday'], $nextdate['mon'], $nextdate['year']);
742 $content .= "<span class=\"clearer\"><!-- --></span></div>\n";
743 break;
745 return $content;
748 function calendar_filter_controls($type, $vars = NULL, $course = NULL, $courses = NULL) {
749 global $CFG, $SESSION, $USER;
751 $groupevents = true;
752 $getvars = '';
754 $id = optional_param( 'id',0,PARAM_INT );
756 switch($type) {
757 case 'event':
758 case 'upcoming':
759 case 'day':
760 case 'month':
761 $getvars = '&amp;from='.$type;
762 break;
763 case 'course':
764 if ($id > 0) {
765 $getvars = '&amp;from=course&amp;id='.$id;
766 } else {
767 $getvars = '&amp;from=course';
769 if (isset($course->groupmode) and $course->groupmode == NOGROUPS and $course->groupmodeforce) {
770 $groupevents = false;
772 break;
775 if (!empty($vars)) {
776 $getvars .= '&amp;'.$vars;
779 $content = '<table>';
781 $content .= '<tr>';
782 if($SESSION->cal_show_global) {
783 $content .= '<td class="eventskey event_global" style="width: 11px;"><img src="'.$CFG->pixpath.'/t/hide.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_hideglobal', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showglobal'.$getvars."'".'" /></td>';
784 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showglobal'.$getvars.'" title="'.get_string('tt_hideglobal', 'calendar').'">'.get_string('global', 'calendar').'</a></td>'."\n";
786 else {
787 $content .= '<td style="width: 11px;"><img src="'.$CFG->pixpath.'/t/show.gif" class="iconsmall" alt="'.get_string('show').'" title="'.get_string('tt_showglobal', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showglobal'.$getvars."'".'" /></td>';
788 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showglobal'.$getvars.'" title="'.get_string('tt_showglobal', 'calendar').'">'.get_string('global', 'calendar').'</a></td>'."\n";
790 $tr = '';
792 if(!empty($USER->id) && !isguest()) {
794 $content .= $tr;
795 $tr = $tr ? '' : "</tr>\n<tr>";
797 if($groupevents) {
799 // This course MIGHT have group events defined, so show the filter
800 if($SESSION->cal_show_groups) {
801 $content .= '<td class="eventskey event_group" style="width: 11px;"><img src="'.$CFG->pixpath.'/t/hide.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_hidegroups', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showgroups'.$getvars."'".'" /></td>';
802 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showgroups'.$getvars.'" title="'.get_string('tt_hidegroups', 'calendar').'">'.get_string('group', 'calendar').'</a></td>'."\n";
803 } else {
804 $content .= '<td style="width: 11px;"><img src="'.$CFG->pixpath.'/t/show.gif" class="iconsmall" alt="'.get_string('show').'" title="'.get_string('tt_showgroups', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showgroups'.$getvars."'".'" /></td>';
805 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showgroups'.$getvars.'" title="'.get_string('tt_showgroups', 'calendar').'">'.get_string('group', 'calendar').'</a></td>'."\n";
807 } else {
809 // This course CANNOT have group events, so lose the filter
810 $content .= '<td style="width: 11px;"></td><td>&nbsp;</td>'."\n";
813 $content .= $tr;
814 $tr = $tr ? '' : "</tr>\n<tr>";
816 if ($SESSION->cal_show_user) {
817 $content .= '<td class="eventskey event_user" style="width: 11px;"><img src="'.$CFG->pixpath.'/t/hide.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_hideuser', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showuser'.$getvars."'".'" /></td>';
818 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showuser'.$getvars.'" title="'.get_string('tt_hideuser', 'calendar').'">'.get_string('user', 'calendar').'</a></td>'."\n";
819 } else {
820 $content .= '<td style="width: 11px;"><img src="'.$CFG->pixpath.'/t/show.gif" class="iconsmall" alt="'.get_string('show').'" title="'.get_string('tt_showuser', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showuser'.$getvars."'".'" /></td>';
821 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showuser'.$getvars.'" title="'.get_string('tt_showuser', 'calendar').'">'.get_string('user', 'calendar').'</a></td>'."\n";
825 // Remove global SITE ID from courses array as do not want to display this
826 if (!empty($courses)) {
827 $key = array_search(SITEID, $courses);
828 if ($key !== false) {
829 unset($courses[$key]);
833 if (empty($courses) || count($courses) == 1) {
835 // If not multiple courses then just display default single course colour highlighting
836 $content .= $tr;
837 $tr = $tr ? '' : "</tr>\n<tr>";
839 if($SESSION->cal_show_course) {
840 $content .= '<td class="eventskey event_course" style="width: 11px;"><img src="'.$CFG->pixpath.'/t/hide.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_hidecourse', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showcourses'.$getvars."'".'" /></td>';
841 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showcourses'.$getvars.'" title="'.get_string('tt_hidecourse', 'calendar').'">'.get_string('course', 'calendar').'</a></td>'."\n";
843 else {
844 $content .= '<td style="width: 11px;"><img src="'.$CFG->pixpath.'/t/show.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_showcourse', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showcourses'.$getvars."'".'" /></td>';
845 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showcourses'.$getvars.'" title="'.get_string('tt_showcourse', 'calendar').'">'.get_string('course', 'calendar').'</a></td>'."\n";
847 } else {
849 // Otherwise display list of course shortnames and relevant colours
850 // Get list of course shortnames (Limit to 12 for now - who would have more than that?)
851 $select = 'id in ('.implode(',', $courses).')';
852 $sort = 'id';
853 $fields = 'id, shortname';
854 $courseshortnames = get_records_select('course', $select, $sort, $fields, 0, 12);
856 for ($i = 0; $i < CALENDAR_MAXCOURSES; $i++) {
858 // Concatenate shortnames if there are more than 3 courses
859 $strshortnames = '';
860 $n = 0;
861 for ($j = $i; $j < count($courses); $j += CALENDAR_MAXCOURSES) {
862 $strshortnames .= ', <a title="" href="'.$CFG->wwwroot.'/course/view.php?id='.$courses[$j].'">'.(!empty($courseshortnames[$courses[$j]]->shortname) ? $courseshortnames[$courses[$j]]->shortname : $courses[$j]).'</a>';
863 $n++;
866 if ($n) {
868 $content .= $tr;
869 $tr = $tr ? '' : "</tr>\n<tr>";
871 if ($n < 2) {
872 $strcourse = get_string('course', 'calendar');
873 } else {
874 $strcourse = get_string('courses', 'calendar');
877 if($SESSION->cal_show_course) {
878 $content .= '<td class="eventskey event_course'.$i.'" style="width: 11px;"><img src="'.$CFG->pixpath.'/t/hide.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_hidecourse', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showcourses'.$getvars."'".'" /></td>';
879 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showcourses'.$getvars.'" title="'.get_string('tt_hidecourse', 'calendar').'">'.$strcourse.'</a>: '.substr($strshortnames, 2).'</td>'."\n";
881 else {
882 $content .= '<td style="width: 11px;"><img src="'.$CFG->pixpath.'/t/show.gif" class="iconsmall" alt="'.get_string('hide').'" title="'.get_string('tt_showcourse', 'calendar').'" style="cursor:pointer" onclick="location.href='."'".CALENDAR_URL.'set.php?var=showcourses'.$getvars."'".'" /></td>';
883 $content .= '<td><a href="'.CALENDAR_URL.'set.php?var=showcourses'.$getvars.'" title="'.get_string('tt_showcourse', 'calendar').'">'.$strcourse.'</a>: '.substr($strshortnames, 2).'</td>'."\n";
888 $content .= "</tr>\n</table>\n";
890 return $content;
893 function calendar_day_representation($tstamp, $now = false, $usecommonwords = true) {
895 static $shortformat;
896 if(empty($shortformat)) {
897 $shortformat = get_string('strftimedayshort');
900 if($now === false) {
901 $now = time();
904 // To have it in one place, if a change is needed
905 $formal = userdate($tstamp, $shortformat);
907 $datestamp = usergetdate($tstamp);
908 $datenow = usergetdate($now);
910 if($usecommonwords == false) {
911 // We don't want words, just a date
912 return $formal;
914 else if($datestamp['year'] == $datenow['year'] && $datestamp['yday'] == $datenow['yday']) {
915 // Today
916 return get_string('today', 'calendar');
918 else if(
919 ($datestamp['year'] == $datenow['year'] && $datestamp['yday'] == $datenow['yday'] - 1 ) ||
920 ($datestamp['year'] == $datenow['year'] - 1 && $datestamp['mday'] == 31 && $datestamp['mon'] == 12 && $datenow['yday'] == 1)
922 // Yesterday
923 return get_string('yesterday', 'calendar');
925 else if(
926 ($datestamp['year'] == $datenow['year'] && $datestamp['yday'] == $datenow['yday'] + 1 ) ||
927 ($datestamp['year'] == $datenow['year'] + 1 && $datenow['mday'] == 31 && $datenow['mon'] == 12 && $datestamp['yday'] == 1)
929 // Tomorrow
930 return get_string('tomorrow', 'calendar');
932 else {
933 return $formal;
937 function calendar_time_representation($time) {
938 static $langtimeformat = NULL;
939 if($langtimeformat === NULL) {
940 $langtimeformat = get_string('strftimetime');
942 $timeformat = get_user_preferences('calendar_timeformat');
943 if(empty($timeformat)){
944 $timeformat = get_config(NULL,'calendar_site_timeformat');
946 // The ? is needed because the preference might be present, but empty
947 return userdate($time, empty($timeformat) ? $langtimeformat : $timeformat);
951 * TODO document
953 function calendar_get_link_href($linkbase, $d, $m, $y) {
954 if(empty($linkbase)) return '';
955 $paramstr = '';
956 if(!empty($d)) $paramstr .= '&amp;cal_d='.$d;
957 if(!empty($m)) $paramstr .= '&amp;cal_m='.$m;
958 if(!empty($y)) $paramstr .= '&amp;cal_y='.$y;
959 if(!empty($paramstr)) $paramstr = substr($paramstr, 5);
960 return $linkbase.$paramstr;
964 * TODO document
966 function calendar_get_link_tag($text, $linkbase, $d, $m, $y) {
967 $href = calendar_get_link_href($linkbase, $d, $m, $y);
968 if(empty($href)) return $text;
969 return '<a href="'.$href.'">'.$text.'</a>';
973 * Build and return a previous month HTML link, with an arrow.
974 * @param string $text The text label.
975 * @param string $linkbase The URL stub.
976 * @param int $d $m $y Day of month, month and year numbers.
977 * @param bool $accesshide Default visible, or hide from all except screenreaders.
978 * @return string HTML string.
980 function calendar_get_link_previous($text, $linkbase, $d, $m, $y, $accesshide=false) {
981 $href = calendar_get_link_href($linkbase, $d, $m, $y);
982 if(empty($href)) return $text;
983 return link_arrow_left($text, $href, $accesshide, 'previous');
987 * Build and return a next month HTML link, with an arrow.
988 * @param string $text The text label.
989 * @param string $linkbase The URL stub.
990 * @param int $d $m $y Day of month, month and year numbers.
991 * @param bool $accesshide Default visible, or hide from all except screenreaders.
992 * @return string HTML string.
994 function calendar_get_link_next($text, $linkbase, $d, $m, $y, $accesshide=false) {
995 $href = calendar_get_link_href($linkbase, $d, $m, $y);
996 if(empty($href)) return $text;
997 return link_arrow_right($text, $href, $accesshide, 'next');
1000 function calendar_wday_name($englishname) {
1001 return get_string(strtolower($englishname), 'calendar');
1004 function calendar_days_in_month($month, $year) {
1005 return intval(date('t', mktime(0, 0, 0, $month, 1, $year)));
1008 function calendar_get_sideblock_upcoming($events, $linkhref = NULL) {
1009 $content = '';
1010 $lines = count($events);
1011 if (!$lines) {
1012 return $content;
1015 for ($i = 0; $i < $lines; ++$i) {
1016 if (!isset($events[$i]->time)) { // Just for robustness
1017 continue;
1019 $events[$i] = calendar_add_event_metadata($events[$i]);
1020 $content .= '<div class="event"><span class="icon c0">'.$events[$i]->icon.'</span> ';
1021 if (!empty($events[$i]->referer)) {
1022 // That's an activity event, so let's provide the hyperlink
1023 $content .= $events[$i]->referer;
1024 } else {
1025 if(!empty($linkhref)) {
1026 $ed = usergetdate($events[$i]->timestart);
1027 $href = calendar_get_link_href(CALENDAR_URL.$linkhref, $ed['mday'], $ed['mon'], $ed['year']);
1028 $content .= '<a href="'.$href.'#event_'.$events[$i]->id.'">'.$events[$i]->name.'</a>';
1030 else {
1031 $content .= $events[$i]->name;
1034 $events[$i]->time = str_replace('&raquo;', '<br />&raquo;', $events[$i]->time);
1035 $content .= '<div class="date">'.$events[$i]->time.'</div></div>';
1036 if ($i < $lines - 1) $content .= '<hr />';
1039 return $content;
1042 function calendar_add_month($month, $year) {
1043 if($month == 12) {
1044 return array(1, $year + 1);
1046 else {
1047 return array($month + 1, $year);
1051 function calendar_sub_month($month, $year) {
1052 if($month == 1) {
1053 return array(12, $year - 1);
1055 else {
1056 return array($month - 1, $year);
1060 function calendar_events_by_day($events, $month, $year, &$eventsbyday, &$durationbyday, &$typesbyday, &$courses) {
1061 $eventsbyday = array();
1062 $typesbyday = array();
1063 $durationbyday = array();
1065 if($events === false) {
1066 return;
1069 foreach($events as $event) {
1071 $startdate = usergetdate($event->timestart);
1072 // Set end date = start date if no duration
1073 if ($event->timeduration) {
1074 $enddate = usergetdate($event->timestart + $event->timeduration - 1);
1075 } else {
1076 $enddate = $startdate;
1079 // Simple arithmetic: $year * 13 + $month is a distinct integer for each distinct ($year, $month) pair
1080 if(!($startdate['year'] * 13 + $startdate['mon'] <= $year * 13 + $month) && ($enddate['year'] * 13 + $enddate['mon'] >= $year * 13 + $month)) {
1081 // Out of bounds
1082 continue;
1085 $eventdaystart = intval($startdate['mday']);
1087 if($startdate['mon'] == $month && $startdate['year'] == $year) {
1088 // Give the event to its day
1089 $eventsbyday[$eventdaystart][] = $event->id;
1091 // Mark the day as having such an event
1092 if($event->courseid == SITEID && $event->groupid == 0) {
1093 $typesbyday[$eventdaystart]['startglobal'] = true;
1094 // Set event class for global event
1095 $events[$event->id]->class = 'event_global';
1097 else if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) {
1098 $typesbyday[$eventdaystart]['startcourse'] = true;
1099 // Set event class for course event
1100 $events[$event->id]->class = 'event_course'.array_search($event->courseid, $courses) % CALENDAR_MAXCOURSES;
1102 else if($event->groupid) {
1103 $typesbyday[$eventdaystart]['startgroup'] = true;
1104 // Set event class for group event
1105 $events[$event->id]->class = 'event_group';
1107 else if($event->userid) {
1108 $typesbyday[$eventdaystart]['startuser'] = true;
1109 // Set event class for user event
1110 $events[$event->id]->class = 'event_user';
1114 if($event->timeduration == 0) {
1115 // Proceed with the next
1116 continue;
1119 // The event starts on $month $year or before. So...
1120 $lowerbound = $startdate['mon'] == $month && $startdate['year'] == $year ? intval($startdate['mday']) : 0;
1122 // Also, it ends on $month $year or later...
1123 $upperbound = $enddate['mon'] == $month && $enddate['year'] == $year ? intval($enddate['mday']) : calendar_days_in_month($month, $year);
1125 // Mark all days between $lowerbound and $upperbound (inclusive) as duration
1126 for($i = $lowerbound + 1; $i <= $upperbound; ++$i) {
1127 $durationbyday[$i][] = $event->id;
1128 if($event->courseid == SITEID && $event->groupid == 0) {
1129 $typesbyday[$i]['durationglobal'] = true;
1131 else if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) {
1132 $typesbyday[$i]['durationcourse'] = true;
1134 else if($event->groupid) {
1135 $typesbyday[$i]['durationgroup'] = true;
1137 else if($event->userid) {
1138 $typesbyday[$i]['durationuser'] = true;
1143 return;
1146 function calendar_get_module_cached(&$coursecache, $modulename, $instance) {
1147 $module = get_coursemodule_from_instance($modulename, $instance);
1149 if($module === false) return false;
1150 if(!calendar_get_course_cached($coursecache, $module->course)) {
1151 return false;
1153 return $module;
1156 function calendar_get_course_cached(&$coursecache, $courseid) {
1157 global $COURSE;
1158 if (!isset($coursecache[$courseid])) {
1159 if ($courseid == $COURSE->id) {
1160 $coursecache[$courseid] = $COURSE;
1161 } else {
1162 $coursecache[$courseid] = get_record('course', 'id', $courseid);
1165 return $coursecache[$courseid];
1168 function calendar_session_vars() {
1169 global $SESSION, $USER;
1171 if(!empty($USER->id) && isset($USER->realuser) && !isset($SESSION->cal_loggedinas)) {
1172 // We just logged in as someone else, update the filtering
1173 unset($SESSION->cal_users_shown);
1174 unset($SESSION->cal_courses_shown);
1175 $SESSION->cal_loggedinas = true;
1176 if(intval(get_user_preferences('calendar_persistflt', 0))) {
1177 calendar_set_filters_status(get_user_preferences('calendar_savedflt', 0xff));
1180 else if(!empty($USER->id) && !isset($USER->realuser) && isset($SESSION->cal_loggedinas)) {
1181 // We just logged back to our real self, update again
1182 unset($SESSION->cal_users_shown);
1183 unset($SESSION->cal_courses_shown);
1184 unset($SESSION->cal_loggedinas);
1185 if(intval(get_user_preferences('calendar_persistflt', 0))) {
1186 calendar_set_filters_status(get_user_preferences('calendar_savedflt', 0xff));
1190 if(!isset($SESSION->cal_course_referer)) {
1191 $SESSION->cal_course_referer = 0;
1193 if(!isset($SESSION->cal_show_global)) {
1194 $SESSION->cal_show_global = true;
1196 if(!isset($SESSION->cal_show_groups)) {
1197 $SESSION->cal_show_groups = true;
1199 if(!isset($SESSION->cal_show_course)) {
1200 $SESSION->cal_show_course = true;
1202 if(!isset($SESSION->cal_show_user)) {
1203 $SESSION->cal_show_user = true;
1205 // if(empty($SESSION->cal_courses_shown)) {
1206 $SESSION->cal_courses_shown = calendar_get_default_courses(true);
1208 if(empty($SESSION->cal_users_shown)) {
1209 // The empty() instead of !isset() here makes a whole world of difference,
1210 // as it will automatically change to the user's id when the user first logs
1211 // in. With !isset(), it would never do that.
1212 $SESSION->cal_users_shown = !empty($USER->id) ? $USER->id : false;
1214 else if(is_numeric($SESSION->cal_users_shown) && !empty($USER->id) && $SESSION->cal_users_shown != $USER->id) {
1215 // Follow the white rabbit, for example if a teacher logs in as a student
1216 $SESSION->cal_users_shown = $USER->id;
1220 function calendar_overlib_html() {
1221 return '<div id="overDiv" style="position: absolute; visibility: hidden; z-index:1000;"></div>'
1222 .'<script type="text/javascript" src="'.CALENDAR_URL.'overlib.cfg.php"></script>';
1225 function calendar_set_referring_course($courseid) {
1226 global $SESSION;
1227 $SESSION->cal_course_referer = intval($courseid);
1230 function calendar_set_filters(&$courses, &$group, &$user, $courseeventsfrom = NULL, $groupeventsfrom = NULL, $ignorefilters = false) {
1231 global $SESSION, $USER, $CFG;
1233 // Insidious bug-wannabe: setting $SESSION->cal_courses_shown to $course->id would cause
1234 // the code to function incorrectly UNLESS we convert it to an integer. One case where
1235 // PHP's loose type system works against us.
1236 if(is_string($SESSION->cal_courses_shown)) {
1237 $SESSION->cal_courses_shown = intval($SESSION->cal_courses_shown);
1240 if($courseeventsfrom === NULL) {
1241 $courseeventsfrom = $SESSION->cal_courses_shown;
1243 if($groupeventsfrom === NULL) {
1244 $groupeventsfrom = $SESSION->cal_courses_shown;
1247 if(($SESSION->cal_show_course && $SESSION->cal_show_global) || $ignorefilters) {
1248 if(is_int($courseeventsfrom)) {
1249 $courses = array(SITEID, $courseeventsfrom);
1251 else if(is_array($courseeventsfrom)) {
1252 $courses = array_keys($courseeventsfrom);
1253 $courses[] = SITEID;
1256 else if($SESSION->cal_show_course) {
1257 if(is_int($courseeventsfrom)) {
1258 $courses = array($courseeventsfrom);
1260 else if(is_array($courseeventsfrom)) {
1261 $courses = array_keys($courseeventsfrom);
1263 $courses = array_diff($courses, array(SITEID));
1265 else if($SESSION->cal_show_global) {
1266 $courses = array(SITEID);
1268 else {
1269 $courses = false;
1271 //BUG 6130 clean $courses array as SESSION has bad entries.
1272 // [pj] TODO: See if this has to do with my new change in get_default_courses and can be taken out
1273 if (is_array($courses)) {
1274 foreach ($courses as $index => $value) {
1275 if (empty($value)) unset($courses[$index]);
1278 // Sort courses for consistent colour highlighting
1279 // Effectively ignoring SITEID as setting as last course id
1280 $key = array_search(SITEID, $courses);
1281 if ($key !== false) {
1282 unset($courses[$key]);
1283 sort($courses);
1284 $courses[] = SITEID;
1285 } else {
1286 sort($courses);
1290 if($SESSION->cal_show_user || $ignorefilters) {
1291 // This doesn't work for arrays yet (maybe someday it will)
1292 $user = $SESSION->cal_users_shown;
1294 else {
1295 $user = false;
1297 if($SESSION->cal_show_groups || $ignorefilters) {
1298 if(is_int($groupeventsfrom)) {
1299 $groupcourses = array($groupeventsfrom);
1301 else if(is_array($groupeventsfrom)) {
1302 $groupcourses = array_keys($groupeventsfrom);
1305 // XXX TODO: not sure how to replace $CFG->calendar_adminseesall
1306 if(has_capability('moodle/calendar:manageentries', get_context_instance(CONTEXT_SYSTEM, SITEID)) && !empty($CFG->calendar_adminseesall)) {
1307 $group = true;
1309 else {
1310 $grouparray = array();
1312 // We already have the courses to examine in $courses
1313 // For each course...
1315 foreach($groupcourses as $courseid) {
1317 if (!isset($courseeventsfrom[$courseid]->context)) { // SHOULD be set MDL-11221
1318 $courseeventsfrom[$courseid]->context = get_context_instance(CONTEXT_COURSE, $courseid);
1321 // If the user is an editing teacher in there,
1322 if (!empty($USER->id) && has_capability('moodle/calendar:manageentries', $courseeventsfrom[$courseid]->context)) {
1323 // If this course has groups, show events from all of them
1324 if(is_int($groupeventsfrom)) {
1325 if (is_object($courseeventsfrom[$courseid])) { // SHOULD be set MDL-11221
1326 $courserecord = $courseeventsfrom[$courseid];
1327 } else {
1328 $courserecord = get_record('course', 'id', $courseid);
1330 $courserecord = get_record('course', 'id', $courseid);
1331 if ($courserecord->groupmode != NOGROUPS || !$courserecord->groupmodeforce) {
1332 $groupids[] = $courseid;
1335 else if(isset($SESSION->cal_courses_shown[$courseid]) && ($SESSION->cal_courses_shown[$courseid]->groupmode != NOGROUPS || !$SESSION->cal_courses_shown[$courseid]->groupmodeforce)) {
1336 $groupids[] = $courseid;
1340 // Otherwise (not editing teacher) show events from the group he is a member of
1341 else if(isset($USER->groupmember[$courseid])) {
1342 //changed to 2D array
1343 foreach ($USER->groupmember[$courseid] as $groupid){
1344 $grouparray[] = $groupid;
1349 if (!empty($groupids)) {
1350 $sql = "SELECT id
1351 FROM {$CFG->prefix}groups
1352 WHERE courseid IN (".implode(',', $groupids).')';
1354 if ($grouprecords= get_records_sql($sql)) {
1355 $grouparray = array_merge($grouparray, array_keys($grouprecords));
1359 if(empty($grouparray)) {
1360 $group = false;
1362 else {
1363 $group = $grouparray;
1368 else {
1369 $group = false;
1373 function calendar_edit_event_allowed($event) {
1375 global $USER;
1377 // can not be using guest account
1378 if ($USER->username == "guest") {
1379 return false;
1382 $sitecontext = get_context_instance(CONTEXT_SYSTEM, SITEID);
1383 // if user has manageentries at site level, return true
1384 if (has_capability('moodle/calendar:manageentries', $sitecontext)) {
1385 return true;
1388 // if groupid is set, it's definitely a group event
1389 if ($event->groupid) {
1390 //TODO:check.
1391 if (! groups_group_exists($event->groupid)) {
1392 return false;
1395 // this is ok because if you have this capability at course level, you should be able
1396 // to edit group calendar too
1397 // there is no need to check membership, because if you have this capability
1398 // you will have a role in this group context
1399 return has_capability('moodle/calendar:manageentries', get_context_instance(CONTEXT_GROUP, $event->groupid));
1400 } else if ($event->courseid) {
1401 // if groupid is not set, but course is set,
1402 // it's definiely a course event
1403 return has_capability('moodle/calendar:manageentries', get_context_instance(CONTEXT_COURSE, $event->courseid));
1404 } else if ($event->userid && $event->userid == $USER->id) {
1405 // if course is not set, but userid id set, it's a user event
1406 return (has_capability('moodle/calendar:manageownentries', $sitecontext));
1408 return false;
1411 function calendar_get_default_courses($ignoreref = false) {
1412 global $USER, $CFG, $SESSION;
1414 if(!empty($SESSION->cal_course_referer) && !$ignoreref) {
1415 return array($SESSION->cal_course_referer => 1);
1418 if(empty($USER->id)) {
1419 return array();
1422 $courses = array();
1423 if (has_capability('moodle/calendar:manageentries', get_context_instance(CONTEXT_SYSTEM, SITEID))) {
1424 if (!empty($CFG->calendar_adminseesall)) {
1425 $courses = get_records_sql('SELECT id, 1 FROM '.$CFG->prefix.'course');
1426 return $courses;
1430 if (isset($CFG->adminseesall)) {
1431 $courses = get_my_courses($USER->id, null, null, $CFG->adminseesall);
1433 else {
1434 $courses = get_my_courses($USER->id, null, null, false);
1437 return $courses;
1440 function calendar_preferences_button() {
1441 global $CFG, $USER;
1443 // Guests have no preferences
1444 if (empty($USER->id) || isguest()) {
1445 return '';
1448 return "<form $CFG->frametarget method=\"get\" ".
1449 " action=\"$CFG->wwwroot/calendar/preferences.php\">".
1450 "<div><input type=\"submit\" value=\"".get_string("preferences", "calendar")." ...\" /></div></form>";
1453 function calendar_format_event_time($event, $now, $morehref, $usecommonwords = true, $showtime=0) {
1454 $startdate = usergetdate($event->timestart);
1455 $enddate = usergetdate($event->timestart + $event->timeduration);
1456 $usermidnightstart = usergetmidnight($event->timestart);
1458 if($event->timeduration) {
1459 // To avoid doing the math if one IF is enough :)
1460 $usermidnightend = usergetmidnight($event->timestart + $event->timeduration);
1462 else {
1463 $usermidnightend = $usermidnightstart;
1466 // OK, now to get a meaningful display...
1467 // First of all we have to construct a human-readable date/time representation
1469 if($event->timeduration) {
1470 // It has a duration
1471 if($usermidnightstart == $usermidnightend ||
1472 ($event->timestart == $usermidnightstart) && ($event->timeduration == 86400 || $event->timeduration == 86399) ||
1473 ($event->timestart + $event->timeduration <= $usermidnightstart + 86400)) {
1474 // But it's all on the same day
1475 $timestart = calendar_time_representation($event->timestart);
1476 $timeend = calendar_time_representation($event->timestart + $event->timeduration);
1477 $time = $timestart.' <strong>&raquo;</strong> '.$timeend;
1479 if ($event->timestart == $usermidnightstart && ($event->timeduration == 86400 || $event->timeduration == 86399)) {
1480 $time = get_string('allday', 'calendar');
1483 // Set printable representation
1484 if (!$showtime) {
1485 $day = calendar_day_representation($event->timestart, $now, $usecommonwords);
1486 $eventtime = calendar_get_link_tag($day, CALENDAR_URL.'view.php?view=day'.$morehref.'&amp;', $enddate['mday'], $enddate['mon'], $enddate['year']).', '.$time;
1487 } else {
1488 $eventtime = $time;
1490 } else {
1491 // It spans two or more days
1492 $daystart = calendar_day_representation($event->timestart, $now, $usecommonwords).', ';
1493 if ($showtime == $usermidnightstart) {
1494 $daystart = '';
1496 $timestart = calendar_time_representation($event->timestart);
1497 $dayend = calendar_day_representation($event->timestart + $event->timeduration, $now, $usecommonwords).', ';
1498 if ($showtime == $usermidnightend) {
1499 $dayend = '';
1501 $timeend = calendar_time_representation($event->timestart + $event->timeduration);
1503 // Set printable representation
1504 if ($now >= $usermidnightstart && $now < ($usermidnightstart + 86400)) {
1505 $eventtime = $timestart.' <strong>&raquo;</strong> '.calendar_get_link_tag($dayend, CALENDAR_URL.'view.php?view=day'.$morehref.'&amp;', $enddate['mday'], $enddate['mon'], $enddate['year']).
1506 $timeend;
1507 } else {
1508 $eventtime = calendar_get_link_tag($daystart, CALENDAR_URL.'view.php?view=day'.$morehref.'&amp;', $startdate['mday'], $startdate['mon'], $startdate['year']).
1509 $timestart.' <strong>&raquo;</strong> '.calendar_get_link_tag($dayend, CALENDAR_URL.'view.php?view=day'.$morehref.'&amp;', $enddate['mday'], $enddate['mon'], $enddate['year']).
1510 $timeend;
1513 } else {
1514 $time = ' ';
1516 // Set printable representation
1517 if (!$showtime) {
1518 $day = calendar_day_representation($event->timestart, $now, $usecommonwords);
1519 $eventtime = calendar_get_link_tag($day, CALENDAR_URL.'view.php?view=day'.$morehref.'&amp;', $startdate['mday'], $startdate['mon'], $startdate['year']).trim($time);
1520 } else {
1521 $eventtime = $time;
1525 if($event->timestart + $event->timeduration < $now) {
1526 // It has expired
1527 $eventtime = '<span class="dimmed_text">'.str_replace(' href=', ' class="dimmed" href=', $eventtime).'</span>';
1530 return $eventtime;
1533 function calendar_print_month_selector($name, $selected) {
1535 $months = array();
1537 for ($i=1; $i<=12; $i++) {
1538 $months[$i] = userdate(gmmktime(12, 0, 0, $i, 15, 2000), '%B');
1541 choose_from_menu($months, $name, $selected, '');
1544 function calendar_get_filters_status() {
1545 global $SESSION;
1547 $status = 0;
1548 if($SESSION->cal_show_global) {
1549 $status += 1;
1551 if($SESSION->cal_show_course) {
1552 $status += 2;
1554 if($SESSION->cal_show_groups) {
1555 $status += 4;
1557 if($SESSION->cal_show_user) {
1558 $status += 8;
1560 return $status;
1563 function calendar_set_filters_status($packed_bitfield) {
1564 global $SESSION, $USER;
1566 if(!isset($USER) || empty($USER->id)) {
1567 return false;
1570 $SESSION->cal_show_global = ($packed_bitfield & 1);
1571 $SESSION->cal_show_course = ($packed_bitfield & 2);
1572 $SESSION->cal_show_groups = ($packed_bitfield & 4);
1573 $SESSION->cal_show_user = ($packed_bitfield & 8);
1575 return true;
1578 function calendar_get_allowed_types(&$allowed) {
1579 global $USER, $CFG, $SESSION;
1580 $sitecontext = get_context_instance(CONTEXT_SYSTEM);
1581 $allowed->user = has_capability('moodle/calendar:manageownentries', $sitecontext);
1582 $allowed->groups = false; // This may change just below
1583 $allowed->courses = false; // This may change just below
1584 $allowed->site = has_capability('moodle/calendar:manageentries', get_context_instance(CONTEXT_COURSE, SITEID));
1586 if(!empty($SESSION->cal_course_referer) && $SESSION->cal_course_referer != SITEID && has_capability('moodle/calendar:manageentries', get_context_instance(CONTEXT_COURSE, $SESSION->cal_course_referer))) {
1587 $course = get_record('course', 'id', $SESSION->cal_course_referer);
1589 $allowed->courses = array($course->id => 1);
1591 if($course->groupmode != NOGROUPS || !$course->groupmodeforce) {
1592 $allowed->groups = groups_get_all_groups($SESSION->cal_course_referer);
1598 * see if user can add calendar entries at all
1599 * used to print the "New Event" button
1600 * @return bool
1602 function calendar_user_can_add_event() {
1603 calendar_get_allowed_types($allowed);
1604 return (bool)($allowed->user || $allowed->groups || $allowed->courses || $allowed->site);