2 // This file is part of Moodle - http://moodle.org/
4 // Moodle is free software: you can redistribute it and/or modify
5 // it under the terms of the GNU General Public License as published by
6 // the Free Software Foundation, either version 3 of the License, or
7 // (at your option) any later version.
9 // Moodle is distributed in the hope that it will be useful,
10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 // GNU General Public License for more details.
14 // You should have received a copy of the GNU General Public License
15 // along with Moodle. If not, see <http://www.gnu.org/licenses/>.
20 * @package core_calendar
21 * @copyright 2004 Greek School Network (http://www.sch.gr), Jon Papaioannou,
23 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
26 if (!defined('MOODLE_INTERNAL')) {
27 die('Direct access to this script is forbidden.'); /// It must be included from a Moodle page
31 * These are read by the administration component to provide default values
35 * CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD - default value of upcoming event preference
37 define('CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD', 21);
40 * CALENDAR_DEFAULT_UPCOMING_MAXEVENTS - default value to display the maximum number of upcoming event
42 define('CALENDAR_DEFAULT_UPCOMING_MAXEVENTS', 10);
45 * CALENDAR_DEFAULT_STARTING_WEEKDAY - default value to display the starting weekday
47 define('CALENDAR_DEFAULT_STARTING_WEEKDAY', 1);
49 // This is a packed bitfield: day X is "weekend" if $field & (1 << X) is true
50 // Default value = 65 = 64 + 1 = 2^6 + 2^0 = Saturday & Sunday
53 * CALENDAR_DEFAULT_WEEKEND - default value for weekend (Saturday & Sunday)
55 define('CALENDAR_DEFAULT_WEEKEND', 65);
58 * CALENDAR_URL - path to calendar's folder
60 define('CALENDAR_URL', $CFG->wwwroot.'/calendar/');
63 * CALENDAR_TF_24 - Calendar time in 24 hours format
65 define('CALENDAR_TF_24', '%H:%M');
68 * CALENDAR_TF_12 - Calendar time in 12 hours format
70 define('CALENDAR_TF_12', '%I:%M %p');
73 * CALENDAR_EVENT_GLOBAL - Global calendar event types
75 define('CALENDAR_EVENT_GLOBAL', 1);
78 * CALENDAR_EVENT_COURSE - Course calendar event types
80 define('CALENDAR_EVENT_COURSE', 2);
83 * CALENDAR_EVENT_GROUP - group calendar event types
85 define('CALENDAR_EVENT_GROUP', 4);
88 * CALENDAR_EVENT_USER - user calendar event types
90 define('CALENDAR_EVENT_USER', 8);
94 * CALENDAR_IMPORT_FROM_FILE - import the calendar from a file
96 define('CALENDAR_IMPORT_FROM_FILE', 0);
99 * CALENDAR_IMPORT_FROM_URL - import the calendar from a URL
101 define('CALENDAR_IMPORT_FROM_URL', 1);
104 * CALENDAR_IMPORT_EVENT_UPDATED - imported event was updated
106 define('CALENDAR_IMPORT_EVENT_UPDATED', 1);
109 * CALENDAR_IMPORT_EVENT_INSERTED - imported event was added by insert
111 define('CALENDAR_IMPORT_EVENT_INSERTED', 2);
114 * CALENDAR_SUBSCRIPTION_UPDATE - Used to represent update action for subscriptions in various forms.
116 define('CALENDAR_SUBSCRIPTION_UPDATE', 1);
119 * CALENDAR_SUBSCRIPTION_REMOVE - Used to represent remove action for subscriptions in various forms.
121 define('CALENDAR_SUBSCRIPTION_REMOVE', 2);
124 * Return the days of the week
126 * @return array array of days
128 function calendar_get_days() {
129 $calendartype = \core_calendar\type_factory::get_calendar_instance();
130 return $calendartype->get_weekdays();
134 * Get the subscription from a given id
137 * @param int $id id of the subscription
138 * @return stdClass Subscription record from DB
139 * @throws moodle_exception for an invalid id
141 function calendar_get_subscription($id) {
144 $cache = cache::make('core', 'calendar_subscriptions');
145 $subscription = $cache->get($id);
146 if (empty($subscription)) {
147 $subscription = $DB->get_record('event_subscriptions', array('id' => $id), '*', MUST_EXIST);
149 $cache->set($id, $subscription);
151 return $subscription;
155 * Gets the first day of the week
157 * Used to be define('CALENDAR_STARTING_WEEKDAY', blah);
161 function calendar_get_starting_weekday() {
162 $calendartype = \core_calendar\type_factory::get_calendar_instance();
163 return $calendartype->get_starting_weekday();
167 * Generates the HTML for a miniature calendar
169 * @param array $courses list of course to list events from
170 * @param array $groups list of group
171 * @param array $users user's info
172 * @param int|bool $calmonth calendar month in numeric, default is set to false
173 * @param int|bool $calyear calendar month in numeric, default is set to false
174 * @param string|bool $placement the place/page the calendar is set to appear - passed on the the controls function
175 * @param int|bool $courseid id of the course the calendar is displayed on - passed on the the controls function
176 * @param int $time the unixtimestamp representing the date we want to view, this is used instead of $calmonth
177 * and $calyear to support multiple calendars
178 * @return string $content return html table for mini calendar
180 function calendar_get_mini($courses, $groups, $users, $calmonth = false, $calyear = false, $placement = false,
181 $courseid = false, $time = 0) {
182 global $CFG, $OUTPUT;
184 // Get the calendar type we are using.
185 $calendartype = \core_calendar\type_factory::get_calendar_instance();
187 $display = new stdClass;
189 // Assume we are not displaying this month for now.
190 $display->thismonth = false;
194 // Do this check for backwards compatibility. The core should be passing a timestamp rather than month and year.
195 // If a month and year are passed they will be in Gregorian.
196 if (!empty($calmonth) && !empty($calyear)) {
197 // Ensure it is a valid date, else we will just set it to the current timestamp.
198 if (checkdate($calmonth, 1, $calyear)) {
199 $time = make_timestamp($calyear, $calmonth, 1);
203 $date = usergetdate($time);
204 if ($calmonth == $date['mon'] && $calyear == $date['year']) {
205 $display->thismonth = true;
207 // We can overwrite date now with the date used by the calendar type, if it is not Gregorian, otherwise
208 // there is no need as it is already in Gregorian.
209 if ($calendartype->get_name() != 'gregorian') {
210 $date = $calendartype->timestamp_to_date_array($time);
212 } else if (!empty($time)) {
213 // Get the specified date in the calendar type being used.
214 $date = $calendartype->timestamp_to_date_array($time);
215 $thisdate = $calendartype->timestamp_to_date_array(time());
216 if ($date['month'] == $thisdate['month'] && $date['year'] == $thisdate['year']) {
217 $display->thismonth = true;
218 // If we are the current month we want to set the date to the current date, not the start of the month.
222 // Get the current date in the calendar type being used.
224 $date = $calendartype->timestamp_to_date_array($time);
225 $display->thismonth = true;
228 list($d, $m, $y) = array($date['mday'], $date['mon'], $date['year']); // This is what we want to display.
230 // Get Gregorian date for the start of the month.
231 $gregoriandate = $calendartype->convert_to_gregorian($date['year'], $date['mon'], 1);
233 // Store the gregorian date values to be used later.
234 list($gy, $gm, $gd, $gh, $gmin) = array($gregoriandate['year'], $gregoriandate['month'], $gregoriandate['day'],
235 $gregoriandate['hour'], $gregoriandate['minute']);
237 // Get the max number of days in this month for this calendar type.
238 $display->maxdays = calendar_days_in_month($m, $y);
239 // Get the starting week day for this month.
240 $startwday = dayofweek(1, $m, $y);
241 // Get the days in a week.
242 $daynames = calendar_get_days();
243 // Store the number of days in a week.
244 $numberofdaysinweek = $calendartype->get_num_weekdays();
246 // Set the min and max weekday.
247 $display->minwday = calendar_get_starting_weekday();
248 $display->maxwday = $display->minwday + ($numberofdaysinweek - 1);
250 // These are used for DB queries, so we want unixtime, so we need to use Gregorian dates.
251 $display->tstart = make_timestamp($gy, $gm, $gd, $gh, $gmin, 0);
252 $display->tend = $display->tstart + ($display->maxdays * DAYSECS) - 1;
254 // Align the starting weekday to fall in our display range
255 // This is simple, not foolproof.
256 if ($startwday < $display->minwday) {
257 $startwday += $numberofdaysinweek;
260 // Get the events matching our criteria. Don't forget to offset the timestamps for the user's TZ!
261 $events = calendar_get_events($display->tstart, $display->tend, $users, $groups, $courses);
263 // Set event course class for course events
264 if (!empty($events)) {
265 foreach ($events as $eventid => $event) {
266 if (!empty($event->modulename)) {
267 $cm = get_coursemodule_from_instance($event->modulename, $event->instance);
268 if (!\core_availability\info_module::is_user_visible($cm, 0, false)) {
269 unset($events[$eventid]);
275 // This is either a genius idea or an idiot idea: in order to not complicate things, we use this rule: if, after
276 // possibly removing SITEID from $courses, there is only one course left, then clicking on a day in the month
277 // will also set the $SESSION->cal_courses_shown variable to that one course. Otherwise, we 'd need to add extra
278 // arguments to this function.
279 $hrefparams = array();
280 if(!empty($courses)) {
281 $courses = array_diff($courses, array(SITEID));
282 if(count($courses) == 1) {
283 $hrefparams['course'] = reset($courses);
287 // We want to have easy access by day, since the display is on a per-day basis.
288 calendar_events_by_day($events, $m, $y, $eventsbyday, $durationbyday, $typesbyday, $courses);
290 // Accessibility: added summary and <abbr> elements.
291 $summary = get_string('calendarheading', 'calendar', userdate($display->tstart, get_string('strftimemonthyear')));
292 $content .= '<table class="minicalendar calendartable" summary="'.$summary.'">'; // Begin table.
293 if (($placement !== false) && ($courseid !== false)) {
294 $content .= '<caption>'. calendar_top_controls($placement, array('id' => $courseid, 'time' => $time)) .'</caption>';
296 $content .= '<tr class="weekdays">'; // Header row: day names
298 // Print out the names of the weekdays.
299 for ($i = $display->minwday; $i <= $display->maxwday; ++$i) {
300 $pos = $i % $numberofdaysinweek;
301 $content .= '<th scope="col"><abbr title="'. $daynames[$pos]['fullname'] .'">'.
302 $daynames[$pos]['shortname'] ."</abbr></th>\n";
305 $content .= '</tr><tr>'; // End of day names; prepare for day numbers
307 // For the table display. $week is the row; $dayweek is the column.
308 $dayweek = $startwday;
310 // Paddding (the first week may have blank days in the beginning)
311 for($i = $display->minwday; $i < $startwday; ++$i) {
312 $content .= '<td class="dayblank"> </td>'."\n";
315 $weekend = CALENDAR_DEFAULT_WEEKEND;
316 if (isset($CFG->calendar_weekend)) {
317 $weekend = intval($CFG->calendar_weekend);
320 // Now display all the calendar
321 $daytime = $display->tstart - DAYSECS;
322 for($day = 1; $day <= $display->maxdays; ++$day, ++$dayweek) {
324 if($dayweek > $display->maxwday) {
325 // We need to change week (table row)
326 $content .= '</tr><tr>';
327 $dayweek = $display->minwday;
331 if ($weekend & (1 << ($dayweek % $numberofdaysinweek))) {
332 // Weekend. This is true no matter what the exact range is.
333 $class = 'weekend day';
335 // Normal working day.
339 // Special visual fx if an event is defined
340 if(isset($eventsbyday[$day])) {
342 $class .= ' hasevent';
343 $hrefparams['view'] = 'day';
344 $dayhref = calendar_get_link_href(new moodle_url(CALENDAR_URL . 'view.php', $hrefparams), 0, 0, 0, $daytime);
347 foreach($eventsbyday[$day] as $eventid) {
348 if (!isset($events[$eventid])) {
351 $event = new calendar_event($events[$eventid]);
353 $component = 'moodle';
354 if (!empty($event->modulename)) {
356 $popupalt = $event->modulename;
357 $component = $event->modulename;
358 } else if ($event->courseid == SITEID) { // Site event.
359 $popupicon = 'i/siteevent';
360 } else if ($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) { // Course event.
361 $popupicon = 'i/courseevent';
362 } else if ($event->groupid) { // Group event.
363 $popupicon = 'i/groupevent';
364 } else { // Must be a user event.
365 $popupicon = 'i/userevent';
368 $dayhref->set_anchor('event_'.$event->id);
370 $popupcontent .= html_writer::start_tag('div');
371 $popupcontent .= $OUTPUT->pix_icon($popupicon, $popupalt, $component);
372 $name = format_string($event->name, true);
373 // Show ical source if needed.
374 if (!empty($event->subscription) && $CFG->calendar_showicalsource) {
377 $a->source = $event->subscription->name;
378 $name = get_string('namewithsource', 'calendar', $a);
380 $popupcontent .= html_writer::link($dayhref, $name);
381 $popupcontent .= html_writer::end_tag('div');
384 //Accessibility: functionality moved to calendar_get_popup.
385 if($display->thismonth && $day == $d) {
386 $popupid = calendar_get_popup(true, $events[$eventid]->timestart, $popupcontent);
388 $popupid = calendar_get_popup(false, $events[$eventid]->timestart, $popupcontent);
391 // Class and cell content
392 if(isset($typesbyday[$day]['startglobal'])) {
393 $class .= ' calendar_event_global';
394 } else if(isset($typesbyday[$day]['startcourse'])) {
395 $class .= ' calendar_event_course';
396 } else if(isset($typesbyday[$day]['startgroup'])) {
397 $class .= ' calendar_event_group';
398 } else if(isset($typesbyday[$day]['startuser'])) {
399 $class .= ' calendar_event_user';
401 $cell = html_writer::link($dayhref, $day, array('id' => $popupid));
406 $durationclass = false;
407 if (isset($typesbyday[$day]['durationglobal'])) {
408 $durationclass = ' duration_global';
409 } else if(isset($typesbyday[$day]['durationcourse'])) {
410 $durationclass = ' duration_course';
411 } else if(isset($typesbyday[$day]['durationgroup'])) {
412 $durationclass = ' duration_group';
413 } else if(isset($typesbyday[$day]['durationuser'])) {
414 $durationclass = ' duration_user';
416 if ($durationclass) {
417 $class .= ' duration '.$durationclass;
420 // If event has a class set then add it to the table day <td> tag
421 // Note: only one colour for minicalendar
422 if(isset($eventsbyday[$day])) {
423 foreach($eventsbyday[$day] as $eventid) {
424 if (!isset($events[$eventid])) {
427 $event = $events[$eventid];
428 if (!empty($event->class)) {
429 $class .= ' '.$event->class;
435 // Special visual fx for today
436 //Accessibility: hidden text for today, and popup.
437 if($display->thismonth && $day == $d) {
439 $today = get_string('today', 'calendar').' '.userdate(time(), get_string('strftimedayshort'));
441 if(! isset($eventsbyday[$day])) {
442 $class .= ' eventnone';
443 $popupid = calendar_get_popup(true, false);
444 $cell = html_writer::link('#', $day, array('id' => $popupid));
446 $cell = get_accesshide($today.' ').$cell;
451 $class = ' class="'.$class.'"';
453 $content .= '<td'.$class.'>'.$cell."</td>\n";
456 // Paddding (the last week may have blank days at the end)
457 for($i = $dayweek; $i <= $display->maxwday; ++$i) {
458 $content .= '<td class="dayblank"> </td>';
460 $content .= '</tr>'; // Last row ends
462 $content .= '</table>'; // Tabular display of days ends
468 * Gets the calendar popup
470 * It called at multiple points in from calendar_get_mini.
471 * Copied and modified from calendar_get_mini.
473 * @param bool $is_today false except when called on the current day.
474 * @param mixed $event_timestart $events[$eventid]->timestart, OR false if there are no events.
475 * @param string $popupcontent content for the popup window/layout.
476 * @return string eventid for the calendar_tooltip popup window/layout.
478 function calendar_get_popup($is_today, $event_timestart, $popupcontent='') {
481 if ($popupcount === null) {
486 $popupcaption = get_string('today', 'calendar').' ';
488 if (false === $event_timestart) {
489 $popupcaption .= userdate(time(), get_string('strftimedayshort'));
490 $popupcontent = get_string('eventnone', 'calendar');
493 $popupcaption .= get_string('eventsfor', 'calendar', userdate($event_timestart, get_string('strftimedayshort')));
495 $id = 'calendar_tooltip_'.$popupcount;
496 $PAGE->requires->yui_module('moodle-calendar-eventmanager', 'M.core_calendar.add_event', array(array('eventId'=>$id,'title'=>$popupcaption, 'content'=>$popupcontent)));
503 * Gets the calendar upcoming event
505 * @param array $courses array of courses
506 * @param array|int|bool $groups array of groups, group id or boolean for all/no group events
507 * @param array|int|bool $users array of users, user id or boolean for all/no user events
508 * @param int $daysinfuture number of days in the future we 'll look
509 * @param int $maxevents maximum number of events
510 * @param int $fromtime start time
511 * @return array $output array of upcoming events
513 function calendar_get_upcoming($courses, $groups, $users, $daysinfuture, $maxevents, $fromtime=0) {
514 global $CFG, $COURSE, $DB;
516 $display = new stdClass;
517 $display->range = $daysinfuture; // How many days in the future we 'll look
518 $display->maxevents = $maxevents;
522 // Prepare "course caching", since it may save us a lot of queries
523 $coursecache = array();
526 $now = time(); // We 'll need this later
527 $usermidnighttoday = usergetmidnight($now);
530 $display->tstart = $fromtime;
532 $display->tstart = $usermidnighttoday;
535 // This works correctly with respect to the user's DST, but it is accurate
536 // only because $fromtime is always the exact midnight of some day!
537 $display->tend = usergetmidnight($display->tstart + DAYSECS * $display->range + 3 * HOURSECS) - 1;
539 // Get the events matching our criteria
540 $events = calendar_get_events($display->tstart, $display->tend, $users, $groups, $courses);
542 // This is either a genius idea or an idiot idea: in order to not complicate things, we use this rule: if, after
543 // possibly removing SITEID from $courses, there is only one course left, then clicking on a day in the month
544 // will also set the $SESSION->cal_courses_shown variable to that one course. Otherwise, we 'd need to add extra
545 // arguments to this function.
547 $hrefparams = array();
548 if(!empty($courses)) {
549 $courses = array_diff($courses, array(SITEID));
550 if(count($courses) == 1) {
551 $hrefparams['course'] = reset($courses);
555 if ($events !== false) {
557 $modinfo = get_fast_modinfo($COURSE);
559 foreach($events as $event) {
562 if (!empty($event->modulename)) {
563 if ($event->courseid == $COURSE->id) {
564 if (isset($modinfo->instances[$event->modulename][$event->instance])) {
565 $cm = $modinfo->instances[$event->modulename][$event->instance];
566 if (!$cm->uservisible) {
571 if (!$cm = get_coursemodule_from_instance($event->modulename, $event->instance)) {
574 if (!\core_availability\info_module::is_user_visible($cm, 0, false)) {
580 if ($processed >= $display->maxevents) {
584 $event->time = calendar_format_event_time($event, $now, $hrefparams);
594 * Get a HTML link to a course.
596 * @param int $courseid the course id
597 * @return string a link to the course (as HTML); empty if the course id is invalid
599 function calendar_get_courselink($courseid) {
605 calendar_get_course_cached($coursecache, $courseid);
606 $context = context_course::instance($courseid);
607 $fullname = format_string($coursecache[$courseid]->fullname, true, array('context' => $context));
608 $url = new moodle_url('/course/view.php', array('id' => $courseid));
609 $link = html_writer::link($url, $fullname);
616 * Add calendar event metadata
618 * @param stdClass $event event info
619 * @return stdClass $event metadata
621 function calendar_add_event_metadata($event) {
622 global $CFG, $OUTPUT;
624 //Support multilang in event->name
625 $event->name = format_string($event->name,true);
627 if(!empty($event->modulename)) { // Activity event
628 // The module name is set. I will assume that it has to be displayed, and
629 // also that it is an automatically-generated event. And of course that the
630 // fields for get_coursemodule_from_instance are set correctly.
631 $module = calendar_get_module_cached($coursecache, $event->modulename, $event->instance);
633 if ($module === false) {
637 $modulename = get_string('modulename', $event->modulename);
638 if (get_string_manager()->string_exists($event->eventtype, $event->modulename)) {
639 // will be used as alt text if the event icon
640 $eventtype = get_string($event->eventtype, $event->modulename);
644 $icon = $OUTPUT->pix_url('icon', $event->modulename) . '';
646 $event->icon = '<img src="'.$icon.'" alt="'.$eventtype.'" title="'.$modulename.'" class="icon" />';
647 $event->referer = '<a href="'.$CFG->wwwroot.'/mod/'.$event->modulename.'/view.php?id='.$module->id.'">'.$event->name.'</a>';
648 $event->courselink = calendar_get_courselink($module->course);
649 $event->cmid = $module->id;
651 } else if($event->courseid == SITEID) { // Site event
652 $event->icon = '<img src="'.$OUTPUT->pix_url('i/siteevent') . '" alt="'.get_string('globalevent', 'calendar').'" class="icon" />';
653 $event->cssclass = 'calendar_event_global';
654 } else if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) { // Course event
655 $event->icon = '<img src="'.$OUTPUT->pix_url('i/courseevent') . '" alt="'.get_string('courseevent', 'calendar').'" class="icon" />';
656 $event->courselink = calendar_get_courselink($event->courseid);
657 $event->cssclass = 'calendar_event_course';
658 } else if ($event->groupid) { // Group event
659 $event->icon = '<img src="'.$OUTPUT->pix_url('i/groupevent') . '" alt="'.get_string('groupevent', 'calendar').'" class="icon" />';
660 $event->courselink = calendar_get_courselink($event->courseid);
661 $event->cssclass = 'calendar_event_group';
662 } else if($event->userid) { // User event
663 $event->icon = '<img src="'.$OUTPUT->pix_url('i/userevent') . '" alt="'.get_string('userevent', 'calendar').'" class="icon" />';
664 $event->cssclass = 'calendar_event_user';
670 * Get calendar events
672 * @param int $tstart Start time of time range for events
673 * @param int $tend End time of time range for events
674 * @param array|int|boolean $users array of users, user id or boolean for all/no user events
675 * @param array|int|boolean $groups array of groups, group id or boolean for all/no group events
676 * @param array|int|boolean $courses array of courses, course id or boolean for all/no course events
677 * @param boolean $withduration whether only events starting within time range selected
678 * or events in progress/already started selected as well
679 * @param boolean $ignorehidden whether to select only visible events or all events
680 * @return array $events of selected events or an empty array if there aren't any (or there was an error)
682 function calendar_get_events($tstart, $tend, $users, $groups, $courses, $withduration=true, $ignorehidden=true) {
688 if(is_bool($users) && is_bool($groups) && is_bool($courses)) {
692 if((is_array($users) && !empty($users)) or is_numeric($users)) {
693 // Events from a number of users
694 if(!empty($whereclause)) $whereclause .= ' OR';
695 list($insqlusers, $inparamsusers) = $DB->get_in_or_equal($users, SQL_PARAMS_NAMED);
696 $whereclause .= " (userid $insqlusers AND courseid = 0 AND groupid = 0)";
697 $params = array_merge($params, $inparamsusers);
698 } else if($users === true) {
699 // Events from ALL users
700 if(!empty($whereclause)) $whereclause .= ' OR';
701 $whereclause .= ' (userid != 0 AND courseid = 0 AND groupid = 0)';
702 } else if($users === false) {
703 // No user at all, do nothing
706 if((is_array($groups) && !empty($groups)) or is_numeric($groups)) {
707 // Events from a number of groups
708 if(!empty($whereclause)) $whereclause .= ' OR';
709 list($insqlgroups, $inparamsgroups) = $DB->get_in_or_equal($groups, SQL_PARAMS_NAMED);
710 $whereclause .= " groupid $insqlgroups ";
711 $params = array_merge($params, $inparamsgroups);
712 } else if($groups === true) {
713 // Events from ALL groups
714 if(!empty($whereclause)) $whereclause .= ' OR ';
715 $whereclause .= ' groupid != 0';
717 // boolean false (no groups at all): we don't need to do anything
719 if((is_array($courses) && !empty($courses)) or is_numeric($courses)) {
720 if(!empty($whereclause)) $whereclause .= ' OR';
721 list($insqlcourses, $inparamscourses) = $DB->get_in_or_equal($courses, SQL_PARAMS_NAMED);
722 $whereclause .= " (groupid = 0 AND courseid $insqlcourses)";
723 $params = array_merge($params, $inparamscourses);
724 } else if ($courses === true) {
725 // Events from ALL courses
726 if(!empty($whereclause)) $whereclause .= ' OR';
727 $whereclause .= ' (groupid = 0 AND courseid != 0)';
730 // Security check: if, by now, we have NOTHING in $whereclause, then it means
731 // that NO event-selecting clauses were defined. Thus, we won't be returning ANY
732 // events no matter what. Allowing the code to proceed might return a completely
733 // valid query with only time constraints, thus selecting ALL events in that time frame!
734 if(empty($whereclause)) {
739 $timeclause = '(timestart >= '.$tstart.' OR timestart + timeduration > '.$tstart.') AND timestart <= '.$tend;
742 $timeclause = 'timestart >= '.$tstart.' AND timestart <= '.$tend;
744 if(!empty($whereclause)) {
745 // We have additional constraints
746 $whereclause = $timeclause.' AND ('.$whereclause.')';
749 // Just basic time filtering
750 $whereclause = $timeclause;
754 $whereclause .= ' AND visible = 1';
757 $events = $DB->get_records_select('event', $whereclause, $params, 'timestart');
758 if ($events === false) {
764 /** Get calendar events by id
767 * @param array $eventids list of event ids
768 * @return array Array of event entries, empty array if nothing found
771 function calendar_get_events_by_id($eventids) {
774 if (!is_array($eventids) || empty($eventids)) {
777 list($wheresql, $params) = $DB->get_in_or_equal($eventids);
778 $wheresql = "id $wheresql";
780 return $DB->get_records_select('event', $wheresql, $params);
784 * Get control options for Calendar
786 * @param string $type of calendar
787 * @param array $data calendar information
788 * @return string $content return available control for the calender in html
790 function calendar_top_controls($type, $data) {
791 global $PAGE, $OUTPUT;
793 // Get the calendar type we are using.
794 $calendartype = \core_calendar\type_factory::get_calendar_instance();
798 // Ensure course id passed if relevant.
800 if (!empty($data['id'])) {
801 $courseid = '&course='.$data['id'];
804 // If we are passing a month and year then we need to convert this to a timestamp to
805 // support multiple calendars. No where in core should these be passed, this logic
806 // here is for third party plugins that may use this function.
807 if (!empty($data['m']) && !empty($date['y'])) {
808 if (!isset($data['d'])) {
811 if (!checkdate($data['m'], $data['d'], $data['y'])) {
814 $time = make_timestamp($data['y'], $data['m'], $data['d']);
816 } else if (!empty($data['time'])) {
817 $time = $data['time'];
822 // Get the date for the calendar type.
823 $date = $calendartype->timestamp_to_date_array($time);
825 $urlbase = $PAGE->url;
827 // We need to get the previous and next months in certain cases.
828 if ($type == 'frontpage' || $type == 'course' || $type == 'month') {
829 $prevmonth = calendar_sub_month($date['mon'], $date['year']);
830 $prevmonthtime = $calendartype->convert_to_gregorian($prevmonth[1], $prevmonth[0], 1);
831 $prevmonthtime = make_timestamp($prevmonthtime['year'], $prevmonthtime['month'], $prevmonthtime['day'],
832 $prevmonthtime['hour'], $prevmonthtime['minute']);
834 $nextmonth = calendar_add_month($date['mon'], $date['year']);
835 $nextmonthtime = $calendartype->convert_to_gregorian($nextmonth[1], $nextmonth[0], 1);
836 $nextmonthtime = make_timestamp($nextmonthtime['year'], $nextmonthtime['month'], $nextmonthtime['day'],
837 $nextmonthtime['hour'], $nextmonthtime['minute']);
842 $prevlink = calendar_get_link_previous(get_string('monthprev', 'access'), $urlbase, false, false, false, true, $prevmonthtime);
843 $nextlink = calendar_get_link_next(get_string('monthnext', 'access'), $urlbase, false, false, false, true, $nextmonthtime);
844 $calendarlink = calendar_get_link_href(new moodle_url(CALENDAR_URL.'view.php', array('view' => 'month')), false, false, false, $time);
846 if (!empty($data['id'])) {
847 $calendarlink->param('course', $data['id']);
850 if (right_to_left()) {
858 $content .= html_writer::start_tag('div', array('class'=>'calendar-controls'));
859 $content .= $left.'<span class="hide"> | </span>';
860 $content .= html_writer::tag('span', html_writer::link($calendarlink, userdate($time, get_string('strftimemonthyear')), array('title'=>get_string('monththis','calendar'))), array('class'=>'current'));
861 $content .= '<span class="hide"> | </span>'. $right;
862 $content .= "<span class=\"clearer\"><!-- --></span>\n";
863 $content .= html_writer::end_tag('div');
867 $prevlink = calendar_get_link_previous(get_string('monthprev', 'access'), $urlbase, false, false, false, true, $prevmonthtime);
868 $nextlink = calendar_get_link_next(get_string('monthnext', 'access'), $urlbase, false, false, false, true, $nextmonthtime);
869 $calendarlink = calendar_get_link_href(new moodle_url(CALENDAR_URL.'view.php', array('view' => 'month')), false, false, false, $time);
871 if (!empty($data['id'])) {
872 $calendarlink->param('course', $data['id']);
875 if (right_to_left()) {
883 $content .= html_writer::start_tag('div', array('class'=>'calendar-controls'));
884 $content .= $left.'<span class="hide"> | </span>';
885 $content .= html_writer::tag('span', html_writer::link($calendarlink, userdate($time, get_string('strftimemonthyear')), array('title'=>get_string('monththis','calendar'))), array('class'=>'current'));
886 $content .= '<span class="hide"> | </span>'. $right;
887 $content .= "<span class=\"clearer\"><!-- --></span>";
888 $content .= html_writer::end_tag('div');
891 $calendarlink = calendar_get_link_href(new moodle_url(CALENDAR_URL.'view.php', array('view' => 'upcoming')), false, false, false, $time);
892 if (!empty($data['id'])) {
893 $calendarlink->param('course', $data['id']);
895 $calendarlink = html_writer::link($calendarlink, userdate($time, get_string('strftimemonthyear')));
896 $content .= html_writer::tag('div', $calendarlink, array('class'=>'centered'));
899 $calendarlink = calendar_get_link_href(new moodle_url(CALENDAR_URL.'view.php', array('view' => 'month')), false, false, false, $time);
900 if (!empty($data['id'])) {
901 $calendarlink->param('course', $data['id']);
903 $calendarlink = html_writer::link($calendarlink, userdate($time, get_string('strftimemonthyear')));
904 $content .= html_writer::tag('h3', $calendarlink);
907 $prevlink = calendar_get_link_previous(userdate($prevmonthtime, get_string('strftimemonthyear')), 'view.php?view=month'.$courseid.'&', false, false, false, false, $prevmonthtime);
908 $nextlink = calendar_get_link_next(userdate($nextmonthtime, get_string('strftimemonthyear')), 'view.php?view=month'.$courseid.'&', false, false, false, false, $nextmonthtime);
910 if (right_to_left()) {
918 $content .= html_writer::start_tag('div', array('class'=>'calendar-controls'));
919 $content .= $left . '<span class="hide"> | </span>';
920 $content .= $OUTPUT->heading(userdate($time, get_string('strftimemonthyear')), 2, 'current');
921 $content .= '<span class="hide"> | </span>' . $right;
922 $content .= '<span class="clearer"><!-- --></span>';
923 $content .= html_writer::end_tag('div')."\n";
926 $days = calendar_get_days();
928 $prevtimestamp = $time - DAYSECS;
929 $nexttimestamp = $time + DAYSECS;
931 $prevdate = $calendartype->timestamp_to_date_array($prevtimestamp);
932 $nextdate = $calendartype->timestamp_to_date_array($nexttimestamp);
934 $prevname = $days[$prevdate['wday']]['fullname'];
935 $nextname = $days[$nextdate['wday']]['fullname'];
936 $prevlink = calendar_get_link_previous($prevname, 'view.php?view=day'.$courseid.'&', false, false, false, false, $prevtimestamp);
937 $nextlink = calendar_get_link_next($nextname, 'view.php?view=day'.$courseid.'&', false, false, false, false, $nexttimestamp);
939 if (right_to_left()) {
947 $content .= html_writer::start_tag('div', array('class'=>'calendar-controls'));
949 $content .= '<span class="hide"> | </span><span class="current">'.userdate($time, get_string('strftimedaydate')).'</span>';
950 $content .= '<span class="hide"> | </span>'. $right;
951 $content .= "<span class=\"clearer\"><!-- --></span>";
952 $content .= html_writer::end_tag('div')."\n";
960 * Formats a filter control element.
962 * @param moodle_url $url of the filter
963 * @param int $type constant defining the type filter
964 * @return string html content of the element
966 function calendar_filter_controls_element(moodle_url $url, $type) {
969 case CALENDAR_EVENT_GLOBAL:
970 $typeforhumans = 'global';
971 $class = 'calendar_event_global';
973 case CALENDAR_EVENT_COURSE:
974 $typeforhumans = 'course';
975 $class = 'calendar_event_course';
977 case CALENDAR_EVENT_GROUP:
978 $typeforhumans = 'groups';
979 $class = 'calendar_event_group';
981 case CALENDAR_EVENT_USER:
982 $typeforhumans = 'user';
983 $class = 'calendar_event_user';
986 if (calendar_show_event_type($type)) {
987 $icon = $OUTPUT->pix_icon('t/hide', get_string('hide'));
988 $str = get_string('hide'.$typeforhumans.'events', 'calendar');
990 $icon = $OUTPUT->pix_icon('t/show', get_string('show'));
991 $str = get_string('show'.$typeforhumans.'events', 'calendar');
993 $content = html_writer::start_tag('li', array('class' => 'calendar_event'));
994 $content .= html_writer::start_tag('a', array('href' => $url));
995 $content .= html_writer::tag('span', $icon, array('class' => $class));
996 $content .= html_writer::tag('span', $str, array('class' => 'eventname'));
997 $content .= html_writer::end_tag('a');
998 $content .= html_writer::end_tag('li');
1003 * Get the controls filter for calendar.
1005 * Filter is used to hide calendar info from the display page
1007 * @param moodle_url $returnurl return-url for filter controls
1008 * @return string $content return filter controls in html
1010 function calendar_filter_controls(moodle_url $returnurl) {
1011 global $CFG, $USER, $OUTPUT;
1013 $groupevents = true;
1014 $id = optional_param( 'id',0,PARAM_INT );
1015 $seturl = new moodle_url('/calendar/set.php', array('return' => base64_encode($returnurl->out_as_local_url(false)), 'sesskey'=>sesskey()));
1016 $content = html_writer::start_tag('ul');
1018 $seturl->param('var', 'showglobal');
1019 $content .= calendar_filter_controls_element($seturl, CALENDAR_EVENT_GLOBAL);
1021 $seturl->param('var', 'showcourses');
1022 $content .= calendar_filter_controls_element($seturl, CALENDAR_EVENT_COURSE);
1024 if (isloggedin() && !isguestuser()) {
1026 // This course MIGHT have group events defined, so show the filter
1027 $seturl->param('var', 'showgroups');
1028 $content .= calendar_filter_controls_element($seturl, CALENDAR_EVENT_GROUP);
1030 // This course CANNOT have group events, so lose the filter
1032 $seturl->param('var', 'showuser');
1033 $content .= calendar_filter_controls_element($seturl, CALENDAR_EVENT_USER);
1035 $content .= html_writer::end_tag('ul');
1041 * Return the representation day
1043 * @param int $tstamp Timestamp in GMT
1044 * @param int $now current Unix timestamp
1045 * @param bool $usecommonwords
1046 * @return string the formatted date/time
1048 function calendar_day_representation($tstamp, $now = false, $usecommonwords = true) {
1050 static $shortformat;
1051 if(empty($shortformat)) {
1052 $shortformat = get_string('strftimedayshort');
1055 if($now === false) {
1059 // To have it in one place, if a change is needed
1060 $formal = userdate($tstamp, $shortformat);
1062 $datestamp = usergetdate($tstamp);
1063 $datenow = usergetdate($now);
1065 if($usecommonwords == false) {
1066 // We don't want words, just a date
1069 else if($datestamp['year'] == $datenow['year'] && $datestamp['yday'] == $datenow['yday']) {
1071 return get_string('today', 'calendar');
1074 ($datestamp['year'] == $datenow['year'] && $datestamp['yday'] == $datenow['yday'] - 1 ) ||
1075 ($datestamp['year'] == $datenow['year'] - 1 && $datestamp['mday'] == 31 && $datestamp['mon'] == 12 && $datenow['yday'] == 1)
1078 return get_string('yesterday', 'calendar');
1081 ($datestamp['year'] == $datenow['year'] && $datestamp['yday'] == $datenow['yday'] + 1 ) ||
1082 ($datestamp['year'] == $datenow['year'] + 1 && $datenow['mday'] == 31 && $datenow['mon'] == 12 && $datestamp['yday'] == 1)
1085 return get_string('tomorrow', 'calendar');
1093 * return the formatted representation time
1095 * @param int $time the timestamp in UTC, as obtained from the database
1096 * @return string the formatted date/time
1098 function calendar_time_representation($time) {
1099 static $langtimeformat = NULL;
1100 if($langtimeformat === NULL) {
1101 $langtimeformat = get_string('strftimetime');
1103 $timeformat = get_user_preferences('calendar_timeformat');
1104 if(empty($timeformat)){
1105 $timeformat = get_config(NULL,'calendar_site_timeformat');
1107 // The ? is needed because the preference might be present, but empty
1108 return userdate($time, empty($timeformat) ? $langtimeformat : $timeformat);
1112 * Adds day, month, year arguments to a URL and returns a moodle_url object.
1114 * @param string|moodle_url $linkbase
1115 * @param int $d The number of the day.
1116 * @param int $m The number of the month.
1117 * @param int $y The number of the year.
1118 * @param int $time the unixtime, used for multiple calendar support. The values $d,
1119 * $m and $y are kept for backwards compatibility.
1120 * @return moodle_url|null $linkbase
1122 function calendar_get_link_href($linkbase, $d, $m, $y, $time = 0) {
1123 if (empty($linkbase)) {
1126 if (!($linkbase instanceof moodle_url)) {
1127 $linkbase = new moodle_url($linkbase);
1130 // If a day, month and year were passed then convert it to a timestamp. If these were passed
1131 // then we can assume the day, month and year are passed as Gregorian, as no where in core
1132 // should we be passing these values rather than the time.
1133 if (!empty($d) && !empty($m) && !empty($y)) {
1134 if (checkdate($m, $d, $y)) {
1135 $time = make_timestamp($y, $m, $d);
1139 } else if (empty($time)) {
1143 $linkbase->param('time', $time);
1149 * Build and return a previous month HTML link, with an arrow.
1151 * @param string $text The text label.
1152 * @param string|moodle_url $linkbase The URL stub.
1153 * @param int $d The number of the date.
1154 * @param int $m The number of the month.
1155 * @param int $y year The number of the year.
1156 * @param bool $accesshide Default visible, or hide from all except screenreaders.
1157 * @param int $time the unixtime, used for multiple calendar support. The values $d,
1158 * $m and $y are kept for backwards compatibility.
1159 * @return string HTML string.
1161 function calendar_get_link_previous($text, $linkbase, $d, $m, $y, $accesshide = false, $time = 0) {
1162 $href = calendar_get_link_href(new moodle_url($linkbase), $d, $m, $y, $time);
1166 return link_arrow_left($text, (string)$href, $accesshide, 'previous');
1170 * Build and return a next month HTML link, with an arrow.
1172 * @param string $text The text label.
1173 * @param string|moodle_url $linkbase The URL stub.
1174 * @param int $d the number of the Day
1175 * @param int $m The number of the month.
1176 * @param int $y The number of the year.
1177 * @param bool $accesshide Default visible, or hide from all except screenreaders.
1178 * @param int $time the unixtime, used for multiple calendar support. The values $d,
1179 * $m and $y are kept for backwards compatibility.
1180 * @return string HTML string.
1182 function calendar_get_link_next($text, $linkbase, $d, $m, $y, $accesshide = false, $time = 0) {
1183 $href = calendar_get_link_href(new moodle_url($linkbase), $d, $m, $y, $time);
1187 return link_arrow_right($text, (string)$href, $accesshide, 'next');
1191 * Return the name of the weekday
1193 * @param string $englishname
1194 * @return string of the weekeday
1196 function calendar_wday_name($englishname) {
1197 return get_string(strtolower($englishname), 'calendar');
1201 * Return the number of days in month
1203 * @param int $month the number of the month.
1204 * @param int $year the number of the year
1207 function calendar_days_in_month($month, $year) {
1208 $calendartype = \core_calendar\type_factory::get_calendar_instance();
1209 return $calendartype->get_num_days_in_month($year, $month);
1213 * Get the upcoming event block
1215 * @param array $events list of events
1216 * @param moodle_url|string $linkhref link to event referer
1217 * @param boolean $showcourselink whether links to courses should be shown
1218 * @return string|null $content html block content
1220 function calendar_get_block_upcoming($events, $linkhref = NULL, $showcourselink = false) {
1222 $lines = count($events);
1227 for ($i = 0; $i < $lines; ++$i) {
1228 if (!isset($events[$i]->time)) { // Just for robustness
1231 $events[$i] = calendar_add_event_metadata($events[$i]);
1232 $content .= '<div class="event"><span class="icon c0">'.$events[$i]->icon.'</span>';
1233 if (!empty($events[$i]->referer)) {
1234 // That's an activity event, so let's provide the hyperlink
1235 $content .= $events[$i]->referer;
1237 if(!empty($linkhref)) {
1238 $href = calendar_get_link_href(new moodle_url(CALENDAR_URL . $linkhref), 0, 0, 0, $events[$i]->timestart);
1239 $href->set_anchor('event_'.$events[$i]->id);
1240 $content .= html_writer::link($href, $events[$i]->name);
1243 $content .= $events[$i]->name;
1246 $events[$i]->time = str_replace('»', '<br />»', $events[$i]->time);
1247 if ($showcourselink && !empty($events[$i]->courselink)) {
1248 $content .= html_writer::div($events[$i]->courselink, 'course');
1250 $content .= '<div class="date">'.$events[$i]->time.'</div></div>';
1251 if ($i < $lines - 1) $content .= '<hr />';
1258 * Get the next following month
1260 * @param int $month the number of the month.
1261 * @param int $year the number of the year.
1262 * @return array the following month
1264 function calendar_add_month($month, $year) {
1265 // Get the calendar type we are using.
1266 $calendartype = \core_calendar\type_factory::get_calendar_instance();
1267 return $calendartype->get_next_month($year, $month);
1271 * Get the previous month.
1273 * @param int $month the number of the month.
1274 * @param int $year the number of the year.
1275 * @return array previous month
1277 function calendar_sub_month($month, $year) {
1278 // Get the calendar type we are using.
1279 $calendartype = \core_calendar\type_factory::get_calendar_instance();
1280 return $calendartype->get_prev_month($year, $month);
1284 * Get per-day basis events
1286 * @param array $events list of events
1287 * @param int $month the number of the month
1288 * @param int $year the number of the year
1289 * @param array $eventsbyday event on specific day
1290 * @param array $durationbyday duration of the event in days
1291 * @param array $typesbyday event type (eg: global, course, user, or group)
1292 * @param array $courses list of courses
1295 function calendar_events_by_day($events, $month, $year, &$eventsbyday, &$durationbyday, &$typesbyday, &$courses) {
1296 // Get the calendar type we are using.
1297 $calendartype = \core_calendar\type_factory::get_calendar_instance();
1299 $eventsbyday = array();
1300 $typesbyday = array();
1301 $durationbyday = array();
1303 if($events === false) {
1307 foreach ($events as $event) {
1308 $startdate = $calendartype->timestamp_to_date_array($event->timestart);
1309 // Set end date = start date if no duration
1310 if ($event->timeduration) {
1311 $enddate = $calendartype->timestamp_to_date_array($event->timestart + $event->timeduration - 1);
1313 $enddate = $startdate;
1316 // Simple arithmetic: $year * 13 + $month is a distinct integer for each distinct ($year, $month) pair
1317 if(!($startdate['year'] * 13 + $startdate['mon'] <= $year * 13 + $month) && ($enddate['year'] * 13 + $enddate['mon'] >= $year * 13 + $month)) {
1322 $eventdaystart = intval($startdate['mday']);
1324 if($startdate['mon'] == $month && $startdate['year'] == $year) {
1325 // Give the event to its day
1326 $eventsbyday[$eventdaystart][] = $event->id;
1328 // Mark the day as having such an event
1329 if($event->courseid == SITEID && $event->groupid == 0) {
1330 $typesbyday[$eventdaystart]['startglobal'] = true;
1331 // Set event class for global event
1332 $events[$event->id]->class = 'calendar_event_global';
1334 else if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) {
1335 $typesbyday[$eventdaystart]['startcourse'] = true;
1336 // Set event class for course event
1337 $events[$event->id]->class = 'calendar_event_course';
1339 else if($event->groupid) {
1340 $typesbyday[$eventdaystart]['startgroup'] = true;
1341 // Set event class for group event
1342 $events[$event->id]->class = 'calendar_event_group';
1344 else if($event->userid) {
1345 $typesbyday[$eventdaystart]['startuser'] = true;
1346 // Set event class for user event
1347 $events[$event->id]->class = 'calendar_event_user';
1351 if($event->timeduration == 0) {
1352 // Proceed with the next
1356 // The event starts on $month $year or before. So...
1357 $lowerbound = $startdate['mon'] == $month && $startdate['year'] == $year ? intval($startdate['mday']) : 0;
1359 // Also, it ends on $month $year or later...
1360 $upperbound = $enddate['mon'] == $month && $enddate['year'] == $year ? intval($enddate['mday']) : calendar_days_in_month($month, $year);
1362 // Mark all days between $lowerbound and $upperbound (inclusive) as duration
1363 for($i = $lowerbound + 1; $i <= $upperbound; ++$i) {
1364 $durationbyday[$i][] = $event->id;
1365 if($event->courseid == SITEID && $event->groupid == 0) {
1366 $typesbyday[$i]['durationglobal'] = true;
1368 else if($event->courseid != 0 && $event->courseid != SITEID && $event->groupid == 0) {
1369 $typesbyday[$i]['durationcourse'] = true;
1371 else if($event->groupid) {
1372 $typesbyday[$i]['durationgroup'] = true;
1374 else if($event->userid) {
1375 $typesbyday[$i]['durationuser'] = true;
1384 * Get current module cache
1386 * @param array $coursecache list of course cache
1387 * @param string $modulename name of the module
1388 * @param int $instance module instance number
1389 * @return stdClass|bool $module information
1391 function calendar_get_module_cached(&$coursecache, $modulename, $instance) {
1392 $module = get_coursemodule_from_instance($modulename, $instance);
1394 if($module === false) return false;
1395 if(!calendar_get_course_cached($coursecache, $module->course)) {
1402 * Get current course cache
1404 * @param array $coursecache list of course cache
1405 * @param int $courseid id of the course
1406 * @return stdClass $coursecache[$courseid] return the specific course cache
1408 function calendar_get_course_cached(&$coursecache, $courseid) {
1409 if (!isset($coursecache[$courseid])) {
1410 $coursecache[$courseid] = get_course($courseid);
1412 return $coursecache[$courseid];
1416 * Returns the courses to load events for, the
1418 * @param array $courseeventsfrom An array of courses to load calendar events for
1419 * @param bool $ignorefilters specify the use of filters, false is set as default
1420 * @return array An array of courses, groups, and user to load calendar events for based upon filters
1422 function calendar_set_filters(array $courseeventsfrom, $ignorefilters = false) {
1423 global $USER, $CFG, $DB;
1425 // For backwards compatability we have to check whether the courses array contains
1426 // just id's in which case we need to load course objects.
1427 $coursestoload = array();
1428 foreach ($courseeventsfrom as $id => $something) {
1429 if (!is_object($something)) {
1430 $coursestoload[] = $id;
1431 unset($courseeventsfrom[$id]);
1434 if (!empty($coursestoload)) {
1435 // TODO remove this in 2.2
1436 debugging('calendar_set_filters now preferes an array of course objects with preloaded contexts', DEBUG_DEVELOPER);
1437 $courseeventsfrom = array_merge($courseeventsfrom, $DB->get_records_list('course', 'id', $coursestoload));
1444 // capabilities that allow seeing group events from all groups
1445 // TODO: rewrite so that moodle/calendar:manageentries is not necessary here
1446 $allgroupscaps = array('moodle/site:accessallgroups', 'moodle/calendar:manageentries');
1448 $isloggedin = isloggedin();
1450 if ($ignorefilters || calendar_show_event_type(CALENDAR_EVENT_COURSE)) {
1451 $courses = array_keys($courseeventsfrom);
1453 if ($ignorefilters || calendar_show_event_type(CALENDAR_EVENT_GLOBAL)) {
1454 $courses[] = SITEID;
1456 $courses = array_unique($courses);
1459 if (!empty($courses) && in_array(SITEID, $courses)) {
1460 // Sort courses for consistent colour highlighting
1461 // Effectively ignoring SITEID as setting as last course id
1462 $key = array_search(SITEID, $courses);
1463 unset($courses[$key]);
1464 $courses[] = SITEID;
1467 if ($ignorefilters || ($isloggedin && calendar_show_event_type(CALENDAR_EVENT_USER))) {
1471 if (!empty($courseeventsfrom) && (calendar_show_event_type(CALENDAR_EVENT_GROUP) || $ignorefilters)) {
1473 if (count($courseeventsfrom)==1) {
1474 $course = reset($courseeventsfrom);
1475 if (has_any_capability($allgroupscaps, context_course::instance($course->id))) {
1476 $coursegroups = groups_get_all_groups($course->id, 0, 0, 'g.id');
1477 $group = array_keys($coursegroups);
1480 if ($group === false) {
1481 if (!empty($CFG->calendar_adminseesall) && has_any_capability($allgroupscaps, context_system::instance())) {
1483 } else if ($isloggedin) {
1484 $groupids = array();
1486 // We already have the courses to examine in $courses
1487 // For each course...
1488 foreach ($courseeventsfrom as $courseid => $course) {
1489 // If the user is an editing teacher in there,
1490 if (!empty($USER->groupmember[$course->id])) {
1491 // We've already cached the users groups for this course so we can just use that
1492 $groupids = array_merge($groupids, $USER->groupmember[$course->id]);
1493 } else if ($course->groupmode != NOGROUPS || !$course->groupmodeforce) {
1494 // If this course has groups, show events from all of those related to the current user
1495 $coursegroups = groups_get_user_groups($course->id, $USER->id);
1496 $groupids = array_merge($groupids, $coursegroups['0']);
1499 if (!empty($groupids)) {
1505 if (empty($courses)) {
1509 return array($courses, $group, $user);
1513 * Return the capability for editing calendar event
1515 * @param calendar_event $event event object
1516 * @return bool capability to edit event
1518 function calendar_edit_event_allowed($event) {
1521 // Must be logged in
1522 if (!isloggedin()) {
1526 // can not be using guest account
1527 if (isguestuser()) {
1531 // You cannot edit calendar subscription events presently.
1532 if (!empty($event->subscriptionid)) {
1536 $sitecontext = context_system::instance();
1537 // if user has manageentries at site level, return true
1538 if (has_capability('moodle/calendar:manageentries', $sitecontext)) {
1542 // if groupid is set, it's definitely a group event
1543 if (!empty($event->groupid)) {
1544 // Allow users to add/edit group events if:
1545 // 1) They have manageentries (= entries for whole course)
1546 // 2) They have managegroupentries AND are in the group
1547 $group = $DB->get_record('groups', array('id'=>$event->groupid));
1549 has_capability('moodle/calendar:manageentries', $event->context) ||
1550 (has_capability('moodle/calendar:managegroupentries', $event->context)
1551 && groups_is_member($event->groupid)));
1552 } else if (!empty($event->courseid)) {
1553 // if groupid is not set, but course is set,
1554 // it's definiely a course event
1555 return has_capability('moodle/calendar:manageentries', $event->context);
1556 } else if (!empty($event->userid) && $event->userid == $USER->id) {
1557 // if course is not set, but userid id set, it's a user event
1558 return (has_capability('moodle/calendar:manageownentries', $event->context));
1559 } else if (!empty($event->userid)) {
1560 return (has_capability('moodle/calendar:manageentries', $event->context));
1566 * Returns the default courses to display on the calendar when there isn't a specific
1567 * course to display.
1569 * @return array $courses Array of courses to display
1571 function calendar_get_default_courses() {
1574 if (!isloggedin()) {
1579 if (!empty($CFG->calendar_adminseesall) && has_capability('moodle/calendar:manageentries', context_system::instance())) {
1580 $select = ', ' . context_helper::get_preload_record_columns_sql('ctx');
1581 $join = "LEFT JOIN {context} ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel)";
1582 $sql = "SELECT c.* $select
1585 WHERE EXISTS (SELECT 1 FROM {event} e WHERE e.courseid = c.id)
1587 $courses = $DB->get_records_sql($sql, array('contextlevel' => CONTEXT_COURSE), 0, 20);
1588 foreach ($courses as $course) {
1589 context_helper::preload_from_record($course);
1594 $courses = enrol_get_my_courses();
1600 * Display calendar preference button
1602 * @param stdClass $course course object
1603 * @return string return preference button in html
1605 function calendar_preferences_button(stdClass $course) {
1608 // Guests have no preferences
1609 if (!isloggedin() || isguestuser()) {
1613 return $OUTPUT->single_button(new moodle_url('/calendar/preferences.php', array('course' => $course->id)), get_string("preferences", "calendar"));
1617 * Get event format time
1619 * @param calendar_event $event event object
1620 * @param int $now current time in gmt
1621 * @param array $linkparams list of params for event link
1622 * @param bool $usecommonwords the words as formatted date/time.
1623 * @param int $showtime determine the show time GMT timestamp
1624 * @return string $eventtime link/string for event time
1626 function calendar_format_event_time($event, $now, $linkparams = null, $usecommonwords = true, $showtime = 0) {
1627 $starttime = $event->timestart;
1628 $endtime = $event->timestart + $event->timeduration;
1630 if (empty($linkparams) || !is_array($linkparams)) {
1631 $linkparams = array();
1634 $linkparams['view'] = 'day';
1636 // OK, now to get a meaningful display...
1637 // Check if there is a duration for this event.
1638 if ($event->timeduration) {
1639 // Get the midnight of the day the event will start.
1640 $usermidnightstart = usergetmidnight($starttime);
1641 // Get the midnight of the day the event will end.
1642 $usermidnightend = usergetmidnight($endtime);
1643 // Check if we will still be on the same day.
1644 if ($usermidnightstart == $usermidnightend) {
1645 // Check if we are running all day.
1646 if ($event->timeduration == DAYSECS) {
1647 $time = get_string('allday', 'calendar');
1648 } else { // Specify the time we will be running this from.
1649 $datestart = calendar_time_representation($starttime);
1650 $dateend = calendar_time_representation($endtime);
1651 $time = $datestart . ' <strong>»</strong> ' . $dateend;
1654 // Set printable representation.
1656 $day = calendar_day_representation($event->timestart, $now, $usecommonwords);
1657 $url = calendar_get_link_href(new moodle_url(CALENDAR_URL . 'view.php', $linkparams), 0, 0, 0, $endtime);
1658 $eventtime = html_writer::link($url, $day) . ', ' . $time;
1662 } else { // It must spans two or more days.
1663 $daystart = calendar_day_representation($event->timestart, $now, $usecommonwords) . ', ';
1664 if ($showtime == $usermidnightstart) {
1667 $timestart = calendar_time_representation($event->timestart);
1668 $dayend = calendar_day_representation($event->timestart + $event->timeduration, $now, $usecommonwords) . ', ';
1669 if ($showtime == $usermidnightend) {
1672 $timeend = calendar_time_representation($event->timestart + $event->timeduration);
1674 // Set printable representation.
1675 if ($now >= $usermidnightstart && $now < ($usermidnightstart + DAYSECS)) {
1676 $url = calendar_get_link_href(new moodle_url(CALENDAR_URL . 'view.php', $linkparams), 0, 0, 0, $endtime);
1677 $eventtime = $timestart . ' <strong>»</strong> ' . html_writer::link($url, $dayend) . $timeend;
1679 $url = calendar_get_link_href(new moodle_url(CALENDAR_URL . 'view.php', $linkparams), 0, 0, 0, $endtime);
1680 $eventtime = html_writer::link($url, $daystart) . $timestart . ' <strong>»</strong> ';
1682 $url = calendar_get_link_href(new moodle_url(CALENDAR_URL . 'view.php', $linkparams), 0, 0, 0, $starttime);
1683 $eventtime .= html_writer::link($url, $dayend) . $timeend;
1686 } else { // There is no time duration.
1687 $time = calendar_time_representation($event->timestart);
1688 // Set printable representation.
1690 $day = calendar_day_representation($event->timestart, $now, $usecommonwords);
1691 $url = calendar_get_link_href(new moodle_url(CALENDAR_URL . 'view.php', $linkparams), 0, 0, 0, $starttime);
1692 $eventtime = html_writer::link($url, $day) . ', ' . trim($time);
1698 // Check if It has expired.
1699 if ($event->timestart + $event->timeduration < $now) {
1700 $eventtime = '<span class="dimmed_text">' . str_replace(' href=', ' class="dimmed" href=', $eventtime) . '</span>';
1707 * Display month selector options
1709 * @param string $name for the select element
1710 * @param string|array $selected options for select elements
1712 function calendar_print_month_selector($name, $selected) {
1714 for ($i=1; $i<=12; $i++) {
1715 $months[$i] = userdate(gmmktime(12, 0, 0, $i, 15, 2000), '%B');
1717 echo html_writer::label(get_string('months'), 'menu'. $name, false, array('class' => 'accesshide'));
1718 echo html_writer::select($months, $name, $selected, false);
1722 * Checks to see if the requested type of event should be shown for the given user.
1724 * @param CALENDAR_EVENT_GLOBAL|CALENDAR_EVENT_COURSE|CALENDAR_EVENT_GROUP|CALENDAR_EVENT_USER $type
1725 * The type to check the display for (default is to display all)
1726 * @param stdClass|int|null $user The user to check for - by default the current user
1727 * @return bool True if the tyep should be displayed false otherwise
1729 function calendar_show_event_type($type, $user = null) {
1730 $default = CALENDAR_EVENT_GLOBAL + CALENDAR_EVENT_COURSE + CALENDAR_EVENT_GROUP + CALENDAR_EVENT_USER;
1731 if (get_user_preferences('calendar_persistflt', 0, $user) === 0) {
1733 if (!isset($SESSION->calendarshoweventtype)) {
1734 $SESSION->calendarshoweventtype = $default;
1736 return $SESSION->calendarshoweventtype & $type;
1738 return get_user_preferences('calendar_savedflt', $default, $user) & $type;
1743 * Sets the display of the event type given $display.
1745 * If $display = true the event type will be shown.
1746 * If $display = false the event type will NOT be shown.
1747 * If $display = null the current value will be toggled and saved.
1749 * @param CALENDAR_EVENT_GLOBAL|CALENDAR_EVENT_COURSE|CALENDAR_EVENT_GROUP|CALENDAR_EVENT_USER $type object of CALENDAR_EVENT_XXX
1750 * @param bool $display option to display event type
1751 * @param stdClass|int $user moodle user object or id, null means current user
1753 function calendar_set_event_type_display($type, $display = null, $user = null) {
1754 $persist = get_user_preferences('calendar_persistflt', 0, $user);
1755 $default = CALENDAR_EVENT_GLOBAL + CALENDAR_EVENT_COURSE + CALENDAR_EVENT_GROUP + CALENDAR_EVENT_USER;
1756 if ($persist === 0) {
1758 if (!isset($SESSION->calendarshoweventtype)) {
1759 $SESSION->calendarshoweventtype = $default;
1761 $preference = $SESSION->calendarshoweventtype;
1763 $preference = get_user_preferences('calendar_savedflt', $default, $user);
1765 $current = $preference & $type;
1766 if ($display === null) {
1767 $display = !$current;
1769 if ($display && !$current) {
1770 $preference += $type;
1771 } else if (!$display && $current) {
1772 $preference -= $type;
1774 if ($persist === 0) {
1775 $SESSION->calendarshoweventtype = $preference;
1777 if ($preference == $default) {
1778 unset_user_preference('calendar_savedflt', $user);
1780 set_user_preference('calendar_savedflt', $preference, $user);
1786 * Get calendar's allowed types
1788 * @param stdClass $allowed list of allowed edit for event type
1789 * @param stdClass|int $course object of a course or course id
1791 function calendar_get_allowed_types(&$allowed, $course = null) {
1792 global $USER, $CFG, $DB;
1793 $allowed = new stdClass();
1794 $allowed->user = has_capability('moodle/calendar:manageownentries', context_system::instance());
1795 $allowed->groups = false; // This may change just below
1796 $allowed->courses = false; // This may change just below
1797 $allowed->site = has_capability('moodle/calendar:manageentries', context_course::instance(SITEID));
1799 if (!empty($course)) {
1800 if (!is_object($course)) {
1801 $course = $DB->get_record('course', array('id' => $course), '*', MUST_EXIST);
1803 if ($course->id != SITEID) {
1804 $coursecontext = context_course::instance($course->id);
1805 $allowed->user = has_capability('moodle/calendar:manageownentries', $coursecontext);
1807 if (has_capability('moodle/calendar:manageentries', $coursecontext)) {
1808 $allowed->courses = array($course->id => 1);
1810 if ($course->groupmode != NOGROUPS || !$course->groupmodeforce) {
1811 if (has_capability('moodle/site:accessallgroups', $coursecontext)) {
1812 $allowed->groups = groups_get_all_groups($course->id);
1814 $allowed->groups = groups_get_all_groups($course->id, $USER->id);
1817 } else if (has_capability('moodle/calendar:managegroupentries', $coursecontext)) {
1818 if($course->groupmode != NOGROUPS || !$course->groupmodeforce) {
1819 if (has_capability('moodle/site:accessallgroups', $coursecontext)) {
1820 $allowed->groups = groups_get_all_groups($course->id);
1822 $allowed->groups = groups_get_all_groups($course->id, $USER->id);
1831 * See if user can add calendar entries at all
1832 * used to print the "New Event" button
1834 * @param stdClass $course object of a course or course id
1835 * @return bool has the capability to add at least one event type
1837 function calendar_user_can_add_event($course) {
1838 if (!isloggedin() || isguestuser()) {
1841 calendar_get_allowed_types($allowed, $course);
1842 return (bool)($allowed->user || $allowed->groups || $allowed->courses || $allowed->site);
1846 * Check wether the current user is permitted to add events
1848 * @param stdClass $event object of event
1849 * @return bool has the capability to add event
1851 function calendar_add_event_allowed($event) {
1854 // can not be using guest account
1855 if (!isloggedin() or isguestuser()) {
1859 $sitecontext = context_system::instance();
1860 // if user has manageentries at site level, always return true
1861 if (has_capability('moodle/calendar:manageentries', $sitecontext)) {
1865 switch ($event->eventtype) {
1867 return has_capability('moodle/calendar:manageentries', $event->context);
1870 // Allow users to add/edit group events if:
1871 // 1) They have manageentries (= entries for whole course)
1872 // 2) They have managegroupentries AND are in the group
1873 $group = $DB->get_record('groups', array('id'=>$event->groupid));
1875 has_capability('moodle/calendar:manageentries', $event->context) ||
1876 (has_capability('moodle/calendar:managegroupentries', $event->context)
1877 && groups_is_member($event->groupid)));
1880 if ($event->userid == $USER->id) {
1881 return (has_capability('moodle/calendar:manageownentries', $event->context));
1883 //there is no 'break;' intentionally
1886 return has_capability('moodle/calendar:manageentries', $event->context);
1889 return has_capability('moodle/calendar:manageentries', $event->context);
1894 * Manage calendar events
1896 * This class provides the required functionality in order to manage calendar events.
1897 * It was introduced as part of Moodle 2.0 and was created in order to provide a
1898 * better framework for dealing with calendar events in particular regard to file
1899 * handling through the new file API
1901 * @package core_calendar
1902 * @category calendar
1903 * @copyright 2009 Sam Hemelryk
1904 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
1906 * @property int $id The id within the event table
1907 * @property string $name The name of the event
1908 * @property string $description The description of the event
1909 * @property int $format The format of the description FORMAT_?
1910 * @property int $courseid The course the event is associated with (0 if none)
1911 * @property int $groupid The group the event is associated with (0 if none)
1912 * @property int $userid The user the event is associated with (0 if none)
1913 * @property int $repeatid If this is a repeated event this will be set to the
1914 * id of the original
1915 * @property string $modulename If added by a module this will be the module name
1916 * @property int $instance If added by a module this will be the module instance
1917 * @property string $eventtype The event type
1918 * @property int $timestart The start time as a timestamp
1919 * @property int $timeduration The duration of the event in seconds
1920 * @property int $visible 1 if the event is visible
1921 * @property int $uuid ?
1922 * @property int $sequence ?
1923 * @property int $timemodified The time last modified as a timestamp
1925 class calendar_event {
1927 /** @var array An object containing the event properties can be accessed via the magic __get/set methods */
1928 protected $properties = null;
1931 * @var string The converted event discription with file paths resolved. This gets populated when someone requests description for the first time */
1932 protected $_description = null;
1934 /** @var array The options to use with this description editor */
1935 protected $editoroptions = array(
1937 'forcehttps'=>false,
1940 'trusttext'=>false);
1942 /** @var object The context to use with the description editor */
1943 protected $editorcontext = null;
1946 * Instantiates a new event and optionally populates its properties with the
1949 * @param stdClass $data Optional. An object containing the properties to for
1952 public function __construct($data=null) {
1955 // First convert to object if it is not already (should either be object or assoc array)
1956 if (!is_object($data)) {
1957 $data = (object)$data;
1960 $this->editoroptions['maxbytes'] = $CFG->maxbytes;
1962 $data->eventrepeats = 0;
1964 if (empty($data->id)) {
1968 if (!empty($data->subscriptionid)) {
1969 $data->subscription = calendar_get_subscription($data->subscriptionid);
1972 // Default to a user event
1973 if (empty($data->eventtype)) {
1974 $data->eventtype = 'user';
1977 // Default to the current user
1978 if (empty($data->userid)) {
1979 $data->userid = $USER->id;
1982 if (!empty($data->timeduration) && is_array($data->timeduration)) {
1983 $data->timeduration = make_timestamp($data->timeduration['year'], $data->timeduration['month'], $data->timeduration['day'], $data->timeduration['hour'], $data->timeduration['minute']) - $data->timestart;
1985 if (!empty($data->description) && is_array($data->description)) {
1986 $data->format = $data->description['format'];
1987 $data->description = $data->description['text'];
1988 } else if (empty($data->description)) {
1989 $data->description = '';
1990 $data->format = editors_get_preferred_format();
1992 // Ensure form is defaulted correctly
1993 if (empty($data->format)) {
1994 $data->format = editors_get_preferred_format();
1997 if (empty($data->context)) {
1998 $data->context = $this->calculate_context($data);
2000 $this->properties = $data;
2004 * Magic property method
2006 * Attempts to call a set_$key method if one exists otherwise falls back
2007 * to simply set the property
2009 * @param string $key property name
2010 * @param mixed $value value of the property
2012 public function __set($key, $value) {
2013 if (method_exists($this, 'set_'.$key)) {
2014 $this->{'set_'.$key}($value);
2016 $this->properties->{$key} = $value;
2022 * Attempts to call a get_$key method to return the property and ralls over
2023 * to return the raw property
2025 * @param string $key property name
2026 * @return mixed property value
2028 public function __get($key) {
2029 if (method_exists($this, 'get_'.$key)) {
2030 return $this->{'get_'.$key}();
2032 if (!isset($this->properties->{$key})) {
2033 throw new coding_exception('Undefined property requested');
2035 return $this->properties->{$key};
2039 * Stupid PHP needs an isset magic method if you use the get magic method and
2040 * still want empty calls to work.... blah ~!
2042 * @param string $key $key property name
2043 * @return bool|mixed property value, false if property is not exist
2045 public function __isset($key) {
2046 return !empty($this->properties->{$key});
2050 * Calculate the context value needed for calendar_event.
2051 * Event's type can be determine by the available value store in $data
2052 * It is important to check for the existence of course/courseid to determine
2054 * Default value is set to CONTEXT_USER
2056 * @param stdClass $data information about event
2057 * @return stdClass The context object.
2059 protected function calculate_context(stdClass $data) {
2063 if (isset($data->courseid) && $data->courseid > 0) {
2064 $context = context_course::instance($data->courseid);
2065 } else if (isset($data->course) && $data->course > 0) {
2066 $context = context_course::instance($data->course);
2067 } else if (isset($data->groupid) && $data->groupid > 0) {
2068 $group = $DB->get_record('groups', array('id'=>$data->groupid));
2069 $context = context_course::instance($group->courseid);
2070 } else if (isset($data->userid) && $data->userid > 0 && $data->userid == $USER->id) {
2071 $context = context_user::instance($data->userid);
2072 } else if (isset($data->userid) && $data->userid > 0 && $data->userid != $USER->id &&
2073 isset($data->instance) && $data->instance > 0) {
2074 $cm = get_coursemodule_from_instance($data->modulename, $data->instance, 0, false, MUST_EXIST);
2075 $context = context_course::instance($cm->course);
2077 $context = context_user::instance($data->userid);
2084 * Returns an array of editoroptions for this event: Called by __get
2085 * Please use $blah = $event->editoroptions;
2087 * @return array event editor options
2089 protected function get_editoroptions() {
2090 return $this->editoroptions;
2094 * Returns an event description: Called by __get
2095 * Please use $blah = $event->description;
2097 * @return string event description
2099 protected function get_description() {
2102 require_once($CFG->libdir . '/filelib.php');
2104 if ($this->_description === null) {
2105 // Check if we have already resolved the context for this event
2106 if ($this->editorcontext === null) {
2107 // Switch on the event type to decide upon the appropriate context
2108 // to use for this event
2109 $this->editorcontext = $this->properties->context;
2110 if ($this->properties->eventtype != 'user' && $this->properties->eventtype != 'course'
2111 && $this->properties->eventtype != 'site' && $this->properties->eventtype != 'group') {
2112 return clean_text($this->properties->description, $this->properties->format);
2116 // Work out the item id for the editor, if this is a repeated event then the files will
2117 // be associated with the original
2118 if (!empty($this->properties->repeatid) && $this->properties->repeatid > 0) {
2119 $itemid = $this->properties->repeatid;
2121 $itemid = $this->properties->id;
2124 // Convert file paths in the description so that things display correctly
2125 $this->_description = file_rewrite_pluginfile_urls($this->properties->description, 'pluginfile.php', $this->editorcontext->id, 'calendar', 'event_description', $itemid);
2126 // Clean the text so no nasties get through
2127 $this->_description = clean_text($this->_description, $this->properties->format);
2129 // Finally return the description
2130 return $this->_description;
2134 * Return the number of repeat events there are in this events series
2136 * @return int number of event repeated
2138 public function count_repeats() {
2140 if (!empty($this->properties->repeatid)) {
2141 $this->properties->eventrepeats = $DB->count_records('event', array('repeatid'=>$this->properties->repeatid));
2142 // We don't want to count ourselves
2143 $this->properties->eventrepeats--;
2145 return $this->properties->eventrepeats;
2149 * Update or create an event within the database
2151 * Pass in a object containing the event properties and this function will
2152 * insert it into the database and deal with any associated files
2155 * @see update_event()
2157 * @param stdClass $data object of event
2158 * @param bool $checkcapability if moodle should check calendar managing capability or not
2159 * @return bool event updated
2161 public function update($data, $checkcapability=true) {
2164 foreach ($data as $key=>$value) {
2165 $this->properties->$key = $value;
2168 $this->properties->timemodified = time();
2169 $usingeditor = (!empty($this->properties->description) && is_array($this->properties->description));
2171 // Prepare event data.
2173 'context' => $this->properties->context,
2174 'objectid' => $this->properties->id,
2176 'repeatid' => empty($this->properties->repeatid) ? 0 : $this->properties->repeatid,
2177 'timestart' => $this->properties->timestart,
2178 'name' => $this->properties->name
2182 if (empty($this->properties->id) || $this->properties->id < 1) {
2184 if ($checkcapability) {
2185 if (!calendar_add_event_allowed($this->properties)) {
2186 print_error('nopermissiontoupdatecalendar');
2191 switch ($this->properties->eventtype) {
2193 $this->properties->courseid = 0;
2194 $this->properties->course = 0;
2195 $this->properties->groupid = 0;
2196 $this->properties->userid = $USER->id;
2199 $this->properties->courseid = SITEID;
2200 $this->properties->course = SITEID;
2201 $this->properties->groupid = 0;
2202 $this->properties->userid = $USER->id;
2205 $this->properties->groupid = 0;
2206 $this->properties->userid = $USER->id;
2209 $this->properties->userid = $USER->id;
2212 // Ewww we should NEVER get here, but just incase we do lets
2214 $usingeditor = false;
2218 // If we are actually using the editor, we recalculate the context because some default values
2219 // were set when calculate_context() was called from the constructor.
2221 $this->properties->context = $this->calculate_context($this->properties);
2222 $this->editorcontext = $this->properties->context;
2225 $editor = $this->properties->description;
2226 $this->properties->format = $this->properties->description['format'];
2227 $this->properties->description = $this->properties->description['text'];
2230 // Insert the event into the database
2231 $this->properties->id = $DB->insert_record('event', $this->properties);
2234 $this->properties->description = file_save_draft_area_files(
2236 $this->editorcontext->id,
2238 'event_description',
2239 $this->properties->id,
2240 $this->editoroptions,
2242 $this->editoroptions['forcehttps']);
2243 $DB->set_field('event', 'description', $this->properties->description, array('id'=>$this->properties->id));
2246 // Log the event entry.
2247 $eventargs['objectid'] = $this->properties->id;
2248 $eventargs['context'] = $this->properties->context;
2249 $event = \core\event\calendar_event_created::create($eventargs);
2252 $repeatedids = array();
2254 if (!empty($this->properties->repeat)) {
2255 $this->properties->repeatid = $this->properties->id;
2256 $DB->set_field('event', 'repeatid', $this->properties->repeatid, array('id'=>$this->properties->id));
2258 $eventcopy = clone($this->properties);
2259 unset($eventcopy->id);
2261 for($i = 1; $i < $eventcopy->repeats; $i++) {
2263 $eventcopy->timestart = ($eventcopy->timestart+WEEKSECS) + dst_offset_on($eventcopy->timestart) - dst_offset_on($eventcopy->timestart+WEEKSECS);
2265 // Get the event id for the log record.
2266 $eventcopyid = $DB->insert_record('event', $eventcopy);
2268 // If the context has been set delete all associated files
2270 $fs = get_file_storage();
2271 $files = $fs->get_area_files($this->editorcontext->id, 'calendar', 'event_description', $this->properties->id);
2272 foreach ($files as $file) {
2273 $fs->create_file_from_storedfile(array('itemid'=>$eventcopyid), $file);
2277 $repeatedids[] = $eventcopyid;
2279 // Trigger an event.
2280 $eventargs['objectid'] = $eventcopyid;
2281 $eventargs['other']['timestart'] = $eventcopy->timestart;
2282 $event = \core\event\calendar_event_created::create($eventargs);
2287 // Hook for tracking added events
2288 self::calendar_event_hook('add_event', array($this->properties, $repeatedids));
2292 if ($checkcapability) {
2293 if(!calendar_edit_event_allowed($this->properties)) {
2294 print_error('nopermissiontoupdatecalendar');
2299 if ($this->editorcontext !== null) {
2300 $this->properties->description = file_save_draft_area_files(
2301 $this->properties->description['itemid'],
2302 $this->editorcontext->id,
2304 'event_description',
2305 $this->properties->id,
2306 $this->editoroptions,
2307 $this->properties->description['text'],
2308 $this->editoroptions['forcehttps']);
2310 $this->properties->format = $this->properties->description['format'];
2311 $this->properties->description = $this->properties->description['text'];
2315 $event = $DB->get_record('event', array('id'=>$this->properties->id));
2317 $updaterepeated = (!empty($this->properties->repeatid) && !empty($this->properties->repeateditall));
2319 if ($updaterepeated) {
2321 if ($this->properties->timestart != $event->timestart) {
2322 $timestartoffset = $this->properties->timestart - $event->timestart;
2323 $sql = "UPDATE {event}
2326 timestart = timestart + ?,
2329 WHERE repeatid = ?";
2330 $params = array($this->properties->name, $this->properties->description, $timestartoffset, $this->properties->timeduration, time(), $event->repeatid);
2332 $sql = "UPDATE {event} SET name = ?, description = ?, timeduration = ?, timemodified = ? WHERE repeatid = ?";
2333 $params = array($this->properties->name, $this->properties->description, $this->properties->timeduration, time(), $event->repeatid);
2335 $DB->execute($sql, $params);
2337 // Trigger an update event for each of the calendar event.
2338 $events = $DB->get_records('event', array('repeatid' => $event->repeatid), '', 'id,timestart');
2339 foreach ($events as $event) {
2340 $eventargs['objectid'] = $event->id;
2341 $eventargs['other']['timestart'] = $event->timestart;
2342 $event = \core\event\calendar_event_updated::create($eventargs);
2346 $DB->update_record('event', $this->properties);
2347 $event = calendar_event::load($this->properties->id);
2348 $this->properties = $event->properties();
2350 // Trigger an update event.
2351 $event = \core\event\calendar_event_updated::create($eventargs);
2355 // Hook for tracking event updates
2356 self::calendar_event_hook('update_event', array($this->properties, $updaterepeated));
2362 * Deletes an event and if selected an repeated events in the same series
2364 * This function deletes an event, any associated events if $deleterepeated=true,
2365 * and cleans up any files associated with the events.
2367 * @see delete_event()
2369 * @param bool $deleterepeated delete event repeatedly
2370 * @return bool succession of deleting event
2372 public function delete($deleterepeated=false) {
2375 // If $this->properties->id is not set then something is wrong
2376 if (empty($this->properties->id)) {
2377 debugging('Attempting to delete an event before it has been loaded', DEBUG_DEVELOPER);
2380 $calevent = $DB->get_record('event', array('id' => $this->properties->id), '*', MUST_EXIST);
2382 $DB->delete_records('event', array('id'=>$this->properties->id));
2384 // Trigger an event for the delete action.
2386 'context' => $this->properties->context,
2387 'objectid' => $this->properties->id,
2389 'repeatid' => empty($this->properties->repeatid) ? 0 : $this->properties->repeatid,
2390 'timestart' => $this->properties->timestart,
2391 'name' => $this->properties->name
2393 $event = \core\event\calendar_event_deleted::create($eventargs);
2394 $event->add_record_snapshot('event', $calevent);
2397 // If we are deleting parent of a repeated event series, promote the next event in the series as parent
2398 if (($this->properties->id == $this->properties->repeatid) && !$deleterepeated) {
2399 $newparent = $DB->get_field_sql("SELECT id from {event} where repeatid = ? order by id ASC", array($this->properties->id), IGNORE_MULTIPLE);
2400 if (!empty($newparent)) {
2401 $DB->execute("UPDATE {event} SET repeatid = ? WHERE repeatid = ?", array($newparent, $this->properties->id));
2402 // Get all records where the repeatid is the same as the event being removed
2403 $events = $DB->get_records('event', array('repeatid' => $newparent));
2404 // For each of the returned events trigger the event_update hook and an update event.
2405 foreach ($events as $event) {
2406 // Trigger an event for the update.
2407 $eventargs['objectid'] = $event->id;
2408 $eventargs['other']['timestart'] = $event->timestart;
2409 $event = \core\event\calendar_event_updated::create($eventargs);
2412 self::calendar_event_hook('update_event', array($event, false));
2417 // If the editor context hasn't already been set then set it now
2418 if ($this->editorcontext === null) {
2419 $this->editorcontext = $this->properties->context;
2422 // If the context has been set delete all associated files
2423 if ($this->editorcontext !== null) {
2424 $fs = get_file_storage();
2425 $files = $fs->get_area_files($this->editorcontext->id, 'calendar', 'event_description', $this->properties->id);
2426 foreach ($files as $file) {
2431 // Fire the event deleted hook
2432 self::calendar_event_hook('delete_event', array($this->properties->id, $deleterepeated));
2434 // If we need to delete repeated events then we will fetch them all and delete one by one
2435 if ($deleterepeated && !empty($this->properties->repeatid) && $this->properties->repeatid > 0) {
2436 // Get all records where the repeatid is the same as the event being removed
2437 $events = $DB->get_records('event', array('repeatid'=>$this->properties->repeatid));
2438 // For each of the returned events populate a calendar_event object and call delete
2439 // make sure the arg passed is false as we are already deleting all repeats
2440 foreach ($events as $event) {
2441 $event = new calendar_event($event);
2442 $event->delete(false);
2450 * Fetch all event properties
2452 * This function returns all of the events properties as an object and optionally
2453 * can prepare an editor for the description field at the same time. This is
2454 * designed to work when the properties are going to be used to set the default
2455 * values of a moodle forms form.
2457 * @param bool $prepareeditor If set to true a editor is prepared for use with
2458 * the mforms editor element. (for description)
2459 * @return stdClass Object containing event properties
2461 public function properties($prepareeditor=false) {
2462 global $USER, $CFG, $DB;
2464 // First take a copy of the properties. We don't want to actually change the
2465 // properties or we'd forever be converting back and forwards between an
2466 // editor formatted description and not
2467 $properties = clone($this->properties);
2468 // Clean the description here
2469 $properties->description = clean_text($properties->description, $properties->format);
2471 // If set to true we need to prepare the properties for use with an editor
2472 // and prepare the file area
2473 if ($prepareeditor) {
2475 // We may or may not have a property id. If we do then we need to work
2476 // out the context so we can copy the existing files to the draft area
2477 if (!empty($properties->id)) {
2479 if ($properties->eventtype === 'site') {
2481 $this->editorcontext = $this->properties->context;
2482 } else if ($properties->eventtype === 'user') {
2484 $this->editorcontext = $this->properties->context;
2485 } else if ($properties->eventtype === 'group' || $properties->eventtype === 'course') {
2486 // First check the course is valid
2487 $course = $DB->get_record('course', array('id'=>$properties->courseid));
2489 print_error('invalidcourse');
2492 $this->editorcontext = $this->properties->context;
2493 // We have a course and are within the course context so we had
2494 // better use the courses max bytes value
2495 $this->editoroptions['maxbytes'] = $course->maxbytes;
2497 // If we get here we have a custom event type as used by some
2498 // modules. In this case the event will have been added by
2499 // code and we won't need the editor
2500 $this->editoroptions['maxbytes'] = 0;
2501 $this->editoroptions['maxfiles'] = 0;
2504 if (empty($this->editorcontext) || empty($this->editorcontext->id)) {
2507 // Get the context id that is what we really want
2508 $contextid = $this->editorcontext->id;
2512 // If we get here then this is a new event in which case we don't need a
2513 // context as there is no existing files to copy to the draft area.
2517 // If the contextid === false we don't support files so no preparing
2519 if ($contextid !== false) {
2520 // Just encase it has already been submitted
2521 $draftiddescription = file_get_submitted_draft_itemid('description');
2522 // Prepare the draft area, this copies existing files to the draft area as well
2523 $properties->description = file_prepare_draft_area($draftiddescription, $contextid, 'calendar', 'event_description', $properties->id, $this->editoroptions, $properties->description);
2525 $draftiddescription = 0;
2528 // Structure the description field as the editor requires
2529 $properties->description = array('text'=>$properties->description, 'format'=>$properties->format, 'itemid'=>$draftiddescription);
2532 // Finally return the properties
2537 * Toggles the visibility of an event
2539 * @param null|bool $force If it is left null the events visibility is flipped,
2540 * If it is false the event is made hidden, if it is true it
2542 * @return bool if event is successfully updated, toggle will be visible
2544 public function toggle_visibility($force=null) {
2547 // Set visible to the default if it is not already set
2548 if (empty($this->properties->visible)) {
2549 $this->properties->visible = 1;
2552 if ($force === true || ($force !== false && $this->properties->visible == 0)) {
2553 // Make this event visible
2554 $this->properties->visible = 1;
2556 self::calendar_event_hook('show_event', array($this->properties));
2558 // Make this event hidden
2559 $this->properties->visible = 0;
2561 self::calendar_event_hook('hide_event', array($this->properties));
2564 // Update the database to reflect this change
2565 return $DB->set_field('event', 'visible', $this->properties->visible, array('id'=>$this->properties->id));
2569 * Attempts to call the hook for the specified action should a calendar type
2570 * by set $CFG->calendar, and the appopriate function defined
2572 * @param string $action One of `update_event`, `add_event`, `delete_event`, `show_event`, `hide_event`
2573 * @param array $args The args to pass to the hook, usually the event is the first element
2574 * @return bool attempts to call event hook
2576 public static function calendar_event_hook($action, array $args) {
2578 static $extcalendarinc;
2579 if ($extcalendarinc === null) {
2580 if (!empty($CFG->calendar)) {
2581 if (is_readable($CFG->dirroot .'/calendar/'. $CFG->calendar .'/lib.php')) {
2582 include_once($CFG->dirroot .'/calendar/'. $CFG->calendar .'/lib.php');
2583 $extcalendarinc = true;
2585 debugging("Calendar lib file missing or not readable at /calendar/{$CFG->calendar}/lib.php.",
2587 $extcalendarinc = false;
2590 $extcalendarinc = false;
2593 if($extcalendarinc === false) {
2596 $hook = $CFG->calendar .'_'.$action;
2597 if (function_exists($hook)) {
2598 call_user_func_array($hook, $args);
2605 * Returns a calendar_event object when provided with an event id
2607 * This function makes use of MUST_EXIST, if the event id passed in is invalid
2608 * it will result in an exception being thrown
2610 * @param int|object $param event object or event id
2611 * @return calendar_event|false status for loading calendar_event
2613 public static function load($param) {
2615 if (is_object($param)) {
2616 $event = new calendar_event($param);
2618 $event = $DB->get_record('event', array('id'=>(int)$param), '*', MUST_EXIST);
2619 $event = new calendar_event($event);
2625 * Creates a new event and returns a calendar_event object
2627 * @param stdClass|array $properties An object containing event properties
2628 * @param bool $checkcapability Check caps or not
2629 * @throws coding_exception
2631 * @return calendar_event|bool The event object or false if it failed
2633 public static function create($properties, $checkcapability = true) {
2634 if (is_array($properties)) {
2635 $properties = (object)$properties;
2637 if (!is_object($properties)) {
2638 throw new coding_exception('When creating an event properties should be either an object or an assoc array');
2640 $event = new calendar_event($properties);
2641 if ($event->update($properties, $checkcapability)) {
2650 * Calendar information class
2652 * This class is used simply to organise the information pertaining to a calendar
2653 * and is used primarily to make information easily available.
2655 * @package core_calendar
2656 * @category calendar
2657 * @copyright 2010 Sam Hemelryk
2658 * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
2660 class calendar_information {
2663 * @var int The timestamp
2665 * Rather than setting the day, month and year we will set a timestamp which will be able
2666 * to be used by multiple calendars.
2670 /** @var int A course id */
2671 public $courseid = null;
2673 /** @var array An array of courses */
2674 public $courses = array();
2676 /** @var array An array of groups */
2677 public $groups = array();
2679 /** @var array An array of users */
2680 public $users = array();
2683 * Creates a new instance
2685 * @param int $day the number of the day
2686 * @param int $month the number of the month
2687 * @param int $year the number of the year
2688 * @param int $time the unixtimestamp representing the date we want to view, this is used instead of $calmonth
2689 * and $calyear to support multiple calendars
2691 public function __construct($day = 0, $month = 0, $year = 0, $time = 0) {
2692 // If a day, month and year were passed then convert it to a timestamp. If these were passed
2693 // then we can assume the day, month and year are passed as Gregorian, as no where in core
2694 // should we be passing these values rather than the time. This is done for BC.
2695 if (!empty($day) || !empty($month) || !empty($year)) {
2696 $date = usergetdate(time());
2698 $day = $date['mday'];
2700 if (empty($month)) {
2701 $month = $date['mon'];
2704 $year = $date['year'];
2706 if (checkdate($month, $day, $year)) {
2707 $this->time = make_timestamp($year, $month, $day);
2709 $this->time = time();
2711 } else if (!empty($time)) {
2712 $this->time = $time;
2714 $this->time = time();
2719 * Initialize calendar information
2721 * @param stdClass $course object
2722 * @param array $coursestoload An array of courses [$course->id => $course]
2723 * @param bool $ignorefilters options to use filter
2725 public function prepare_for_view(stdClass $course, array $coursestoload, $ignorefilters = false) {
2726 $this->courseid = $course->id;
2727 $this->course = $course;
2728 list($courses, $group, $user) = calendar_set_filters($coursestoload, $ignorefilters);
2729 $this->courses = $courses;
2730 $this->groups = $group;
2731 $this->users = $user;
2735 * Ensures the date for the calendar is correct and either sets it to now
2736 * or throws a moodle_exception if not
2738 * @param bool $defaultonow use current time
2739 * @throws moodle_exception
2740 * @return bool validation of checkdate
2742 public function checkdate($defaultonow = true) {
2743 if (!checkdate($this->month, $this->day, $this->year)) {
2745 $now = usergetdate(time());
2746 $this->day = intval($now['mday']);
2747 $this->month = intval($now['mon']);
2748 $this->year = intval($now['year']);
2751 throw new moodle_exception('invaliddate');
2758 * Gets todays timestamp for the calendar
2760 * @return int today timestamp
2762 public function timestamp_today() {
2766 * Gets tomorrows timestamp for the calendar
2768 * @return int tomorrow timestamp
2770 public function timestamp_tomorrow() {
2771 return $this->time + DAYSECS;
2774 * Adds the pretend blocks for the calendar
2776 * @param core_calendar_renderer $renderer
2777 * @param bool $showfilters display filters, false is set as default
2778 * @param string|null $view preference view options (eg: day, month, upcoming)
2780 public function add_sidecalendar_blocks(core_calendar_renderer $renderer, $showfilters=false, $view=null) {
2782 $filters = new block_contents();
2783 $filters->content = $renderer->fake_block_filters($this->courseid, 0, 0, 0, $view, $this->courses);
2784 $filters->footer = '';
2785 $filters->title = get_string('eventskey', 'calendar');
2786 $renderer->add_pretend_calendar_block($filters, BLOCK_POS_RIGHT);
2788 $block = new block_contents;
2789 $block->content = $renderer->fake_block_threemonths($this);
2790 $block->footer = '';
2791 $block->title = get_string('monthlyview', 'calendar');
2792 $renderer->add_pretend_calendar_block($block, BLOCK_POS_RIGHT);
2797 * Returns option list for the poll interval setting.
2799 * @return array An array of poll interval options. Interval => description.
2801 function calendar_get_pollinterval_choices() {
2803 '0' => new lang_string('never', 'calendar'),
2804 HOURSECS => new lang_string('hourly', 'calendar'),
2805 DAYSECS => new lang_string('daily', 'calendar'),
2806 WEEKSECS => new lang_string('weekly', 'calendar'),
2807 '2628000' => new lang_string('monthly', 'calendar'),
2808 YEARSECS => new lang_string('annually', 'calendar')
2813 * Returns option list of available options for the calendar event type, given the current user and course.
2815 * @param int $courseid The id of the course
2816 * @return array An array containing the event types the user can create.
2818 function calendar_get_eventtype_choices($courseid) {
2820 $allowed = new stdClass;
2821 calendar_get_allowed_types($allowed, $courseid);
2823 if ($allowed->user) {
2824 $choices['user'] = get_string('userevents', 'calendar');
2826 if ($allowed->site) {
2827 $choices['site'] = get_string('siteevents', 'calendar');
2829 if (!empty($allowed->courses)) {
2830 $choices['course'] = get_string('courseevents', 'calendar');
2832 if (!empty($allowed->groups) and is_array($allowed->groups)) {
2833 $choices['group'] = get_string('group');
2836 return array($choices, $allowed->groups);
2840 * Add an iCalendar subscription to the database.
2842 * @param stdClass $sub The subscription object (e.g. from the form)
2843 * @return int The insert ID, if any.
2845 function calendar_add_subscription($sub) {
2846 global $DB, $USER, $SITE;
2848 if ($sub->eventtype === 'site') {
2849 $sub->courseid = $SITE->id;
2850 } else if ($sub->eventtype === 'group' || $sub->eventtype === 'course') {
2851 $sub->courseid = $sub->course;
2856 $sub->userid = $USER->id;
2858 // File subscriptions never update.
2859 if (empty($sub->url)) {
2860 $sub->pollinterval = 0;
2863 if (!empty($sub->name)) {
2864 if (empty($sub->id)) {
2865 $id = $DB->insert_record('event_subscriptions', $sub);
2866 // we cannot cache the data here because $sub is not complete.
2869 // Why are we doing an update here?
2870 calendar_update_subscription($sub);
2874 print_error('errorbadsubscription', 'importcalendar');
2879 * Add an iCalendar event to the Moodle calendar.
2881 * @param stdClass $event The RFC-2445 iCalendar event
2882 * @param int $courseid The course ID
2883 * @param int $subscriptionid The iCalendar subscription ID
2884 * @throws dml_exception A DML specific exception is thrown for invalid subscriptionids.
2885 * @return int Code: CALENDAR_IMPORT_EVENT_UPDATED = updated, CALENDAR_IMPORT_EVENT_INSERTED = inserted, 0 = error
2887 function calendar_add_icalendar_event($event, $courseid, $subscriptionid) {
2890 // Probably an unsupported X-MICROSOFT-CDO-BUSYSTATUS event.
2891 if (empty($event->properties['SUMMARY'])) {
2895 $name = $event->properties['SUMMARY'][0]->value;
2896 $name = str_replace('\n', '<br />', $name);
2897 $name = str_replace('\\', '', $name);
2898 $name = preg_replace('/\s+/', ' ', $name);
2900 $eventrecord = new stdClass;
2901 $eventrecord->name = clean_param($name, PARAM_NOTAGS);
2903 if (empty($event->properties['DESCRIPTION'][0]->value)) {
2906 $description = $event->properties['DESCRIPTION'][0]->value;
2907 $description = str_replace('\n', '<br />', $description);
2908 $description = str_replace('\\', '', $description);
2909 $description = preg_replace('/\s+/', ' ', $description);
2911 $eventrecord->description = clean_param($description, PARAM_NOTAGS);
2913 // Probably a repeating event with RRULE etc. TODO: skip for now.
2914 if (empty($event->properties['DTSTART'][0]->value)) {
2918 $defaulttz = date_default_timezone_get();
2919 $tz = isset($event->properties['DTSTART'][0]->parameters['TZID']) ? $event->properties['DTSTART'][0]->parameters['TZID'] :
2921 $eventrecord->timestart = strtotime($event->properties['DTSTART'][0]->value . ' ' . $tz);
2922 if (empty($event->properties['DTEND'])) {
2923 $eventrecord->timeduration = 3600; // one hour if no end time specified
2925 $endtz = isset($event->properties['DTEND'][0]->parameters['TZID']) ? $event->properties['DTEND'][0]->parameters['TZID'] :
2927 $eventrecord->timeduration = strtotime($event->properties['DTEND'][0]->value . ' ' . $endtz) - $eventrecord->timestart;
2929 $eventrecord->uuid = $event->properties['UID'][0]->value;
2930 $eventrecord->timemodified = time();
2932 // Add the iCal subscription details if required.
2933 // We should never do anything with an event without a subscription reference.
2934 $sub = calendar_get_subscription($subscriptionid);
2935 $eventrecord->subscriptionid = $subscriptionid;
2936 $eventrecord->userid = $sub->userid;
2937 $eventrecord->groupid = $sub->groupid;
2938 $eventrecord->courseid = $sub->courseid;
2939 $eventrecord->eventtype = $sub->eventtype;
2941 if ($updaterecord = $DB->get_record('event', array('uuid' => $eventrecord->uuid))) {
2942 $eventrecord->id = $updaterecord->id;
2943 $return = CALENDAR_IMPORT_EVENT_UPDATED; // Update.
2945 $return = CALENDAR_IMPORT_EVENT_INSERTED; // Insert.
2947 if ($createdevent = calendar_event::create($eventrecord, false)) {
2948 if (!empty($event->properties['RRULE'])) {
2949 // Repeating events.
2950 date_default_timezone_set($tz); // Change time zone to parse all events.
2951 $rrule = new \core_calendar\rrule_manager($event->properties['RRULE'][0]->value);
2952 $rrule->parse_rrule();
2953 $rrule->create_events($createdevent);
2954 date_default_timezone_set($defaulttz); // Change time zone back to what it was.
2963 * Update a subscription from the form data in one of the rows in the existing subscriptions table.
2965 * @param int $subscriptionid The ID of the subscription we are acting upon.
2966 * @param int $pollinterval The poll interval to use.
2967 * @param int $action The action to be performed. One of update or remove.
2968 * @throws dml_exception if invalid subscriptionid is provided
2969 * @return string A log of the import progress, including errors
2971 function calendar_process_subscription_row($subscriptionid, $pollinterval, $action) {
2973 // Fetch the subscription from the database making sure it exists.
2974 $sub = calendar_get_subscription($subscriptionid);
2976 // Update or remove the subscription, based on action.
2978 case CALENDAR_SUBSCRIPTION_UPDATE:
2979 // Skip updating file subscriptions.
2980 if (empty($sub->url)) {
2983 $sub->pollinterval = $pollinterval;
2984 calendar_update_subscription($sub);
2986 // Update the events.
2987 return "<p>".get_string('subscriptionupdated', 'calendar', $sub->name)."</p>" . calendar_update_subscription_events($subscriptionid);
2989 case CALENDAR_SUBSCRIPTION_REMOVE:
2990 calendar_delete_subscription($subscriptionid);
2991 return get_string('subscriptionremoved', 'calendar', $sub->name);
3001 * Delete subscription and all related events.
3003 * @param int|stdClass $subscription subscription or it's id, which needs to be deleted.
3005 function calendar_delete_subscription($subscription) {
3008 if (is_object($subscription)) {
3009 $subscription = $subscription->id;
3011 // Delete subscription and related events.
3012 $DB->delete_records('event', array('subscriptionid' => $subscription));
3013 $DB->delete_records('event_subscriptions', array('id' => $subscription));
3014 cache_helper::invalidate_by_definition('core', 'calendar_subscriptions', array(), array($subscription));
3017 * From a URL, fetch the calendar and return an iCalendar object.
3019 * @param string $url The iCalendar URL
3020 * @return stdClass The iCalendar object
3022 function calendar_get_icalendar($url) {
3025 require_once($CFG->libdir.'/filelib.php');
3028 $curl->setopt(array('CURLOPT_FOLLOWLOCATION' => 1, 'CURLOPT_MAXREDIRS' => 5));
3029 $calendar = $curl->get($url);
3030 // Http code validation should actually be the job of curl class.
3031 if (!$calendar || $curl->info['http_code'] != 200 || !empty($curl->errorno)) {
3032 throw new moodle_exception('errorinvalidicalurl', 'calendar');
3035 $ical = new iCalendar();
3036 $ical->unserialize($calendar);
3041 * Import events from an iCalendar object into a course calendar.
3043 * @param stdClass $ical The iCalendar object.
3044 * @param int $courseid The course ID for the calendar.
3045 * @param int $subscriptionid The subscription ID.
3046 * @return string A log of the import progress, including errors.
3048 function calendar_import_icalendar_events($ical, $courseid, $subscriptionid = null) {
3054 // Large calendars take a while...
3055 core_php_time_limit::raise(300);
3057 // Mark all events in a subscription with a zero timestamp.
3058 if (!empty($subscriptionid)) {
3059 $sql = "UPDATE {event} SET timemodified = :time WHERE subscriptionid = :id";
3060 $DB->execute($sql, array('time' => 0, 'id' => $subscriptionid));
3062 foreach ($ical->components['VEVENT'] as $event) {
3063 $res = calendar_add_icalendar_event($event, $courseid, $subscriptionid);
3065 case CALENDAR_IMPORT_EVENT_UPDATED:
3068 case CALENDAR_IMPORT_EVENT_INSERTED:
3072 $return .= '<p>'.get_string('erroraddingevent', 'calendar').': '.(empty($event->properties['SUMMARY'])?'('.get_string('notitle', 'calendar').')':$event->properties['SUMMARY'][0]->value)." </p>\n";
3076 $return .= "<p> ".get_string('eventsimported', 'calendar', $eventcount)."</p>";
3077 $return .= "<p> ".get_string('eventsupdated', 'calendar', $updatecount)."</p>";
3079 // Delete remaining zero-marked events since they're not in remote calendar.
3080 if (!empty($subscriptionid)) {
3081 $deletecount = $DB->count_records('event', array('timemodified' => 0, 'subscriptionid' => $subscriptionid));
3082 if (!empty($deletecount)) {
3083 $sql = "DELETE FROM {event} WHERE timemodified = :time AND subscriptionid = :id";
3084 $DB->execute($sql, array('time' => 0, 'id' => $subscriptionid));
3085 $return .= "<p> ".get_string('eventsdeleted', 'calendar').": {$deletecount} </p>\n";
3093 * Fetch a calendar subscription and update the events in the calendar.
3095 * @param int $subscriptionid The course ID for the calendar.
3096 * @return string A log of the import progress, including errors.
3098 function calendar_update_subscription_events($subscriptionid) {
3101 $sub = calendar_get_subscription($subscriptionid);
3102 // Don't update a file subscription. TODO: Update from a new uploaded file.
3103 if (empty($sub->url)) {
3104 return 'File subscription not updated.';
3106 $ical = calendar_get_icalendar($sub->url);
3107 $return = calendar_import_icalendar_events($ical, $sub->courseid, $subscriptionid);
3108 $sub->lastupdated = time();
3109 calendar_update_subscription($sub);
3114 * Update a calendar subscription. Also updates the associated cache.
3116 * @param stdClass|array $subscription Subscription record.
3117 * @throws coding_exception If something goes wrong
3120 function calendar_update_subscription($subscription) {
3123 if (is_array($subscription)) {
3124 $subscription = (object)$subscription;
3126 if (empty($subscription->id) || !$DB->record_exists('event_subscriptions', array('id' => $subscription->id))) {
3127 throw new coding_exception('Cannot update a subscription without a valid id');
3130 $DB->update_record('event_subscriptions', $subscription);
3132 $cache = cache::make('core', 'calendar_subscriptions');
3133 $cache->set($subscription->id, $subscription);
3137 * Checks to see if the user can edit a given subscription feed.
3139 * @param mixed $subscriptionorid Subscription object or id
3140 * @return bool true if current user can edit the subscription else false
3142 function calendar_can_edit_subscription($subscriptionorid) {
3145 if (is_array($subscriptionorid)) {
3146 $subscription = (object)$subscriptionorid;
3147 } else if (is_object($subscriptionorid)) {
3148 $subscription = $subscriptionorid;
3150 $subscription = calendar_get_subscription($subscriptionorid);
3152 $allowed = new stdClass;
3153 $courseid = $subscription->courseid;
3154 $groupid = $subscription->groupid;
3155 calendar_get_allowed_types($allowed, $courseid);
3156 switch ($subscription->eventtype) {
3158 return $allowed->user;
3160 if (isset($allowed->courses[$courseid])) {
3161 return $allowed->courses[$courseid];
3166 return $allowed->site;
3168 if (isset($allowed->groups[$groupid])) {
3169 return $allowed->groups[$groupid];
3179 * Update calendar subscriptions.
3183 function calendar_cron() {
3186 // In order to execute this we need bennu.
3187 require_once($CFG->libdir.'/bennu/bennu.inc.php');
3189 mtrace('Updating calendar subscriptions:');
3190 cron_trace_time_and_memory();
3193 $subscriptions = $DB->get_records_sql('SELECT * FROM {event_subscriptions} WHERE pollinterval > 0 AND lastupdated + pollinterval < ?', array($time));
3194 foreach ($subscriptions as $sub) {
3195 mtrace("Updating calendar subscription {$sub->name} in course {$sub->courseid}");
3197 $log = calendar_update_subscription_events($sub->id);
3198 mtrace(trim(strip_tags($log)));
3199 } catch (moodle_exception $ex) {
3200 mtrace('Error updating calendar subscription: ' . $ex->getMessage());
3204 mtrace('Finished updating calendar subscriptions.');