ÿØÿà JFIF    ÿÛ „  ( %!1"%)+...383-7(-.+  -%%--------+------------/----------------------------ÿÀ  ¶" ÿÄ     ÿÄ @    !1AQaq‘¡"±ÁÑð2’BRráS‚ñ3b¢CT²Ò #cÿÄ    ÿÄ '   1!AQ2a"‘±#ÿÚ   ? ò(/p‘—–¢·,M|¯G»R£üešT. ôŸEoCFñ‡ 4ÔkåóxR|µÁ¨ÓDà!Ç´µ˜‡p ÍQ‹§!þž^õWsŒy  åÁ§$á«%ºq˜™JyyË0y«^Ϗ -3ÃÏËÈ£Æ\P’ä„s&•‹Üs üô'àWt¹pñCp$bÚF`·7.^)¾!)ÒÙ˜–ÅÏš^h¾ø³·ìe±ŒaeÖ—Í,e=B}Jéߦ$$½—šÙÜCC¯¶è8β–Åkèwx LÉngT±æ¹£Ócœ¿Í/©Éÿ ‰ÚCÒ­mq;Tt¶–}0"zÖPcd1š­¤tˆ„ÐÓâqú[™öUCŠ2޿د­É(¸ßúçšmW,Ò ºf‹Ån™ÄLêÁ8üÁkÁ€L¥ÍuJ1œôrÂSŒÓöt!7EUíïb)AËi¬â-ÙHk8òÁiXYwÅ)O^"ÇØriÛô{»wRUKÙÏÚlÓ¬€‚’שT ] ªb—ÊîKC^×M“xùäñz¬zJ× {4[¹M'IÆeH1LCWÕ]œûº WDæà°OÅ‚¹c²ÞuA–rL`HšpCez‡V’— Ž‚Ë„–ñ­'µR0ÕÖ=À:±G»C\nÆÉ5*¢ †3šhQ4ýÒi$Õ1"Ü]¢p-q3zcQ$ªö¨¥æf›‘»´ÝÚHá„e²JÇ–iÊ:·à¬Øc5Åk»Laª*wi [0Ówk ¦a¦0Õ²ÅÅ‚T¸’³q:Æ<¹ú Ò˜Æ}2VE•Ѐp¡Ô3Úº …h³^LJºçì¥Ánó|˜ÖˆÎˆ+« ¦dø‘Mº–d\ªDðÛ„Ì×LÝ——Ð9Ç|•FèçVm™¨€™3õS–9Äå¢<̉Ìm¢±`·º˜&Z²ž Ë®D«¶»6™‰©­HÈ Àá«h­i³04æ’hxœi3ï¨(ÓL·†‹¶ËpŒ ƒÜÒ? :õdsÀ –3æÓ·Üjâ¬9—]8n¼&]I F£¼…ì–—Œ0v°LǐÅfÛ2TÖ’aµ˜N@ÖBSÏ^à´4-±°b×nÈÈœÆD=KdŒø…ÄÈK,›ÖR§fjü$^ÔÎ!„6^ s:Üun\ôkCÞò÷<—Lúl Í›G¹ÀPá¼Nc¡šÒ…ÙWͳœ±vÊáЄ×9‹P‰cEØ‘™›µŸP<×g1 º©Ø¬wiÁ^l5× I/';Ë+´Z‡ÓÄFÕp[Èð’ HÄ ó 9¬Dl4“é±Ï”V=^Hð;žLädÉa‚°Ë,#/Ž~²BÔÛ QãñQtIeórVB,ÏÂf‹4#Μc‹É3ZIÖ Œ¢¥·üxa‡Ãçè„jŠ[5 Ä!U?,3žÎ×…ðdÓ÷háŠA‰ìÄ4÷ÃÜZÃE{‰®+W\ZÍE[‰»µk»MÝ­`¢©†˜ÃV‹-f¢¡†¢a«eŠ%«Y¨©q%jâd,Ôq`) ¤¦…šˆ ¦E>0Ùb²t–Ÿ  ÷jsςҒKÈcø(é›;k(’#ôŒQ ™C> õ³M9óºÆµ¤çâ;uÀ)5>RÔ¸fÓ~Ȧ—’-$fe«"FâUˆÊwµPÏu w+"åÉó¨6s™Û9(À¨ù©hE°½†n`m~“@©›p!Vkhµ Á1šbEqqÊ@ºèl›2 –Yã%‘‚hÛ{a¶‡ÅÞM²¬çL34®Çl]®‹ŽØŒm'RÜe35æöˆ­Á­ cP9šeÁköo´L³Ì=p8]”‡B¶,šº|ɏdzXˆØk*ÇÚ{#ñ‰pã(€¶‡9ý'šÜ³½¯kƒ†Â’ëSOƒ•Å®H6+a¢µˆ‹Y¨b˜b+XˆÖ!°u!¢"µˆˆn2ˆ Å0Ä`Å Ô®c(ÓÜGº•Ä»Œ âWî%q.áÐÄ÷î%umÍ£+ÜQ,Vn¦-GphU¸¢X­&,Gt ·K¢ÅÅ·¥RÄÊÉbKn N­R2g$VµÕó Qr#–ÓZUÏð0ÎtÙÀœz ëöo“Îk¯n„T°"SÞ+³/…€½"ižãO%Í%&Δâ‘ËØ´IˆÓ°Ë‰ÞM3.™yçÁzit›`4C`k¢¼á!álÄï sÂ[×!¤l¾æo"ƒIÔ'@ªu)3›ô®“@Z à¾] üœ'‡4¸PÞkÁ-qÄH‰ÓÍBd´ÿ —¹°ÄA&ÊUC„öz‚‚RæŠtf¬>˜ÑidšEçÑL÷áý¡V±h§­c¿¥¨ƒ@g¼…Ýö^ÞËc.ž„æ“I[ ª+·zÐÒÚ,½Ð»¶€C›7jk$๖€Ž¾ÅÙpp¶ÍþéΤ ½ØÎŒq ñpæžÅ¥#Øâ49ÃÂK^MYV“,¶Éz_òæ:…;Õ«¦I3âJ£¤û5$7Èxün\â]Êe¯(Ÿ&Ž‹¶2<6Ćf× æ¢ƱqWı[(ÙÂŽç‚T7¨@ÈÉÍß‚ïÙ"&3TYlGށ†)†#5ŠA©^T2ÆÁ†)©†©†¤yGXÁ†©"†)©¼ÅV WS†#©]R–r‹q5ÕbâWþBh¯u+ªÅÄ×ü„nÑ^êkªÁj‰jeœWˆÕÕ`µDµ2Ì+Ä µDµµ5Ô{¤Þ0RF’H÷AÛ<ÊÁ§ ƈæ0Ñ£ê4 öÚµ[¬/1²€â<-¬šö²r×0o×w ´xÐÒË„ g01¬„åEM蛇Ã\6µE›‘fÙO k÷CºnÓ1`iîÒ² áÂ!ÑLÄÿ ³¬\õ*:M=Ç»c‹2[‰ØsÕLò\ŒK L^™üÄN\¶#» Ç\……ßïIœÉ$¸ÎñÍ®ÔHÇ Ûí/´>Li”„†g^$ 7NÍÑÑ2M2ªNg=k½Ð}Ÿl6‡ —JWˆ”ÞéT·+µ¦üÂFè¢Vs6ýÆ4»2+2IÝ9ô9®ÇGÙÇ1+Ä8;*Õ§ž½D*îÑWÚçá3Ma¤·ˆ¥t}š²Ü…Q+Æüµ8HíS”üxGéÁˆ¦Ël„éÈ 5 µÄƒ6äÜ(kIš¯S†fÖ&¸®×v|Äyˆ*禌Éù@7-®Ä[]ÎÖ¿ê`º…=:…žJVnݳvðÖKE¼‚ »mà ÷f®:Ë ™–4rð¡4` ܹçž~‹C=œ…¾Ïj|VDtK.ƒ"9 Ï ­–éXá³6WÒïIL-Ї Ç . /** * Calendar extension * * @package core_calendar * @copyright 2004 Greek School Network (http://www.sch.gr), Jon Papaioannou, * Avgoustos Tsinakos * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ use core_external\external_api; if (!defined('MOODLE_INTERNAL')) { die('Direct access to this script is forbidden.'); /// It must be included from a Moodle page } require_once(__DIR__ . '/deprecatedlib.php'); /** * These are read by the administration component to provide default values */ /** * CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD - default value of upcoming event preference */ define('CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD', 21); /** * CALENDAR_DEFAULT_UPCOMING_MAXEVENTS - default value to display the maximum number of upcoming event */ define('CALENDAR_DEFAULT_UPCOMING_MAXEVENTS', 10); /** * CALENDAR_DEFAULT_STARTING_WEEKDAY - default value to display the starting weekday */ define('CALENDAR_DEFAULT_STARTING_WEEKDAY', 1); // This is a packed bitfield: day X is "weekend" if $field & (1 << X) is true // Default value = 65 = 64 + 1 = 2^6 + 2^0 = Saturday & Sunday /** * CALENDAR_DEFAULT_WEEKEND - default value for weekend (Saturday & Sunday) */ define('CALENDAR_DEFAULT_WEEKEND', 65); /** * CALENDAR_URL - path to calendar's folder */ define('CALENDAR_URL', $CFG->wwwroot.'/calendar/'); /** * CALENDAR_TF_24 - Calendar time in 24 hours format */ define('CALENDAR_TF_24', '%H:%M'); /** * CALENDAR_TF_12 - Calendar time in 12 hours format */ define('CALENDAR_TF_12', '%I:%M %p'); /** * CALENDAR_EVENT_SITE - Site calendar event types */ define('CALENDAR_EVENT_SITE', 1); /** * CALENDAR_EVENT_COURSE - Course calendar event types */ define('CALENDAR_EVENT_COURSE', 2); /** * CALENDAR_EVENT_GROUP - group calendar event types */ define('CALENDAR_EVENT_GROUP', 4); /** * CALENDAR_EVENT_USER - user calendar event types */ define('CALENDAR_EVENT_USER', 8); /** * CALENDAR_EVENT_COURSECAT - Course category calendar event types */ define('CALENDAR_EVENT_COURSECAT', 16); /** * CALENDAR_IMPORT_FROM_FILE - import the calendar from a file */ define('CALENDAR_IMPORT_FROM_FILE', 0); /** * CALENDAR_IMPORT_FROM_URL - import the calendar from a URL */ define('CALENDAR_IMPORT_FROM_URL', 1); /** * CALENDAR_IMPORT_EVENT_UPDATED_SKIPPED - imported event was skipped */ define('CALENDAR_IMPORT_EVENT_SKIPPED', -1); /** * CALENDAR_IMPORT_EVENT_UPDATED - imported event was updated */ define('CALENDAR_IMPORT_EVENT_UPDATED', 1); /** * CALENDAR_IMPORT_EVENT_INSERTED - imported event was added by insert */ define('CALENDAR_IMPORT_EVENT_INSERTED', 2); /** * CALENDAR_SUBSCRIPTION_UPDATE - Used to represent update action for subscriptions in various forms. */ define('CALENDAR_SUBSCRIPTION_UPDATE', 1); /** * CALENDAR_SUBSCRIPTION_REMOVE - Used to represent remove action for subscriptions in various forms. */ define('CALENDAR_SUBSCRIPTION_REMOVE', 2); /** * CALENDAR_EVENT_USER_OVERRIDE_PRIORITY - Constant for the user override priority. */ define('CALENDAR_EVENT_USER_OVERRIDE_PRIORITY', 0); /** * CALENDAR_EVENT_TYPE_STANDARD - Standard events. */ define('CALENDAR_EVENT_TYPE_STANDARD', 0); /** * CALENDAR_EVENT_TYPE_ACTION - Action events. */ define('CALENDAR_EVENT_TYPE_ACTION', 1); /** * Manage calendar events. * * This class provides the required functionality in order to manage calendar events. * It was introduced as part of Moodle 2.0 and was created in order to provide a * better framework for dealing with calendar events in particular regard to file * handling through the new file API. * * @package core_calendar * @category calendar * @copyright 2009 Sam Hemelryk * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later * * @property int $id The id within the event table * @property string $name The name of the event * @property string $description The description of the event * @property int $format The format of the description FORMAT_? * @property int $courseid The course the event is associated with (0 if none) * @property int $groupid The group the event is associated with (0 if none) * @property int $userid The user the event is associated with (0 if none) * @property int $repeatid If this is a repeated event this will be set to the * id of the original * @property string $component If created by a plugin/component (other than module), the full frankenstyle name of a component * @property string $modulename If added by a module this will be the module name * @property int $instance If added by a module this will be the module instance * @property string $eventtype The event type * @property int $timestart The start time as a timestamp * @property int $timeduration The duration of the event in seconds * @property int $timeusermidnight User midnight for the event * @property int $visible 1 if the event is visible * @property int $uuid ? * @property int $sequence ? * @property int $timemodified The time last modified as a timestamp */ class calendar_event { /** @var stdClass An object containing the event properties can be accessed via the magic __get/set methods */ protected $properties = null; /** @var string The converted event discription with file paths resolved. * This gets populated when someone requests description for the first time */ protected $_description = null; /** @var array The options to use with this description editor */ protected $editoroptions = array( 'subdirs' => false, 'forcehttps' => false, 'maxfiles' => -1, 'maxbytes' => null, 'trusttext' => false); /** @var object The context to use with the description editor */ protected $editorcontext = null; /** * Instantiates a new event and optionally populates its properties with the data provided. * * @param \stdClass $data Optional. An object containing the properties to for * an event */ public function __construct($data = null) { global $CFG, $USER; // First convert to object if it is not already (should either be object or assoc array). if (!is_object($data)) { $data = (object) $data; } $this->editoroptions['maxbytes'] = $CFG->maxbytes; $data->eventrepeats = 0; if (empty($data->id)) { $data->id = null; } if (!empty($data->subscriptionid)) { $data->subscription = calendar_get_subscription($data->subscriptionid); } // Default to a user event. if (empty($data->eventtype)) { $data->eventtype = 'user'; } // Default to the current user. if (empty($data->userid)) { $data->userid = $USER->id; } if (!empty($data->timeduration) && is_array($data->timeduration)) { $data->timeduration = make_timestamp( $data->timeduration['year'], $data->timeduration['month'], $data->timeduration['day'], $data->timeduration['hour'], $data->timeduration['minute']) - $data->timestart; } if (!empty($data->description) && is_array($data->description)) { $data->format = $data->description['format']; $data->description = $data->description['text']; } else if (empty($data->description)) { $data->description = ''; $data->format = editors_get_preferred_format(); } // Ensure form is defaulted correctly. if (empty($data->format)) { $data->format = editors_get_preferred_format(); } if (empty($data->component)) { $data->component = null; } $this->properties = $data; } /** * Magic set method. * * Attempts to call a set_$key method if one exists otherwise falls back * to simply set the property. * * @param string $key property name * @param mixed $value value of the property */ public function __set($key, $value) { if (method_exists($this, 'set_'.$key)) { $this->{'set_'.$key}($value); } $this->properties->{$key} = $value; } /** * Magic get method. * * Attempts to call a get_$key method to return the property and ralls over * to return the raw property. * * @param string $key property name * @return mixed property value * @throws \coding_exception */ public function __get($key) { if (method_exists($this, 'get_'.$key)) { return $this->{'get_'.$key}(); } if (!property_exists($this->properties, $key)) { throw new \coding_exception('Undefined property requested'); } return $this->properties->{$key}; } /** * Magic isset method. * * PHP needs an isset magic method if you use the get magic method and * still want empty calls to work. * * @param string $key $key property name * @return bool|mixed property value, false if property is not exist */ public function __isset($key) { return !empty($this->properties->{$key}); } /** * Calculate the context value needed for an event. * * Event's type can be determine by the available value store in $data * It is important to check for the existence of course/courseid to determine * the course event. * Default value is set to CONTEXT_USER * * @return \stdClass The context object. */ protected function calculate_context() { global $USER, $DB; $context = null; if (isset($this->properties->categoryid) && $this->properties->categoryid > 0) { $context = \context_coursecat::instance($this->properties->categoryid); } else if (isset($this->properties->courseid) && $this->properties->courseid > 0) { $context = \context_course::instance($this->properties->courseid); } else if (isset($this->properties->course) && $this->properties->course > 0) { $context = \context_course::instance($this->properties->course); } else if (isset($this->properties->groupid) && $this->properties->groupid > 0) { $group = $DB->get_record('groups', array('id' => $this->properties->groupid)); $context = \context_course::instance($group->courseid); } else if (isset($this->properties->userid) && $this->properties->userid > 0 && $this->properties->userid == $USER->id) { $context = \context_user::instance($this->properties->userid); } else if (isset($this->properties->userid) && $this->properties->userid > 0 && $this->properties->userid != $USER->id && !empty($this->properties->modulename) && isset($this->properties->instance) && $this->properties->instance > 0) { $cm = get_coursemodule_from_instance($this->properties->modulename, $this->properties->instance, 0, false, MUST_EXIST); $context = \context_course::instance($cm->course); } else { $context = \context_user::instance($this->properties->userid); } return $context; } /** * Returns the context for this event. The context is calculated * the first time is is requested and then stored in a member * variable to be returned each subsequent time. * * This is a magical getter function that will be called when * ever the context property is accessed, e.g. $event->context. * * @return context */ protected function get_context() { if (!isset($this->properties->context)) { $this->properties->context = $this->calculate_context(); } return $this->properties->context; } /** * Returns an array of editoroptions for this event. * * @return array event editor options */ protected function get_editoroptions() { return $this->editoroptions; } /** * Returns an event description: Called by __get * Please use $blah = $event->description; * * @return string event description */ protected function get_description() { global $CFG; require_once($CFG->libdir . '/filelib.php'); if ($this->_description === null) { // Check if we have already resolved the context for this event. if ($this->editorcontext === null) { // Switch on the event type to decide upon the appropriate context to use for this event. $this->editorcontext = $this->get_context(); if (!calendar_is_valid_eventtype($this->properties->eventtype)) { return clean_text($this->properties->description, $this->properties->format); } } // Work out the item id for the editor, if this is a repeated event // then the files will be associated with the original. if (!empty($this->properties->repeatid) && $this->properties->repeatid > 0) { $itemid = $this->properties->repeatid; } else { $itemid = $this->properties->id; } // Convert file paths in the description so that things display correctly. $this->_description = file_rewrite_pluginfile_urls($this->properties->description, 'pluginfile.php', $this->editorcontext->id, 'calendar', 'event_description', $itemid); // Clean the text so no nasties get through. $this->_description = clean_text($this->_description, $this->properties->format); } // Finally return the description. return $this->_description; } /** * Return the number of repeat events there are in this events series. * * @return int number of event repeated */ public function count_repeats() { global $DB; if (!empty($this->properties->repeatid)) { $this->properties->eventrepeats = $DB->count_records('event', array('repeatid' => $this->properties->repeatid)); // We don't want to count ourselves. $this->properties->eventrepeats--; } return $this->properties->eventrepeats; } /** * Update or create an event within the database * * Pass in a object containing the event properties and this function will * insert it into the database and deal with any associated files * * Capability checking should be performed if the user is directly manipulating the event * and no other capability has been tested. However if the event is not being manipulated * directly by the user and another capability has been checked for them to do this then * capabilites should not be checked. * * For example if a user is editing an event in the calendar the check should be true, * but if you are updating an event in an activities settings are changed then the calendar * capabilites should not be checked. * * @see self::create() * @see self::update() * * @param \stdClass $data object of event * @param bool $checkcapability If Moodle should check the user can manage the calendar events for this call or not. * @return bool event updated */ public function update($data, $checkcapability=true) { global $DB, $USER; foreach ($data as $key => $value) { $this->properties->$key = $value; } $this->properties->timemodified = time(); $usingeditor = (!empty($this->properties->description) && is_array($this->properties->description)); // Prepare event data. $eventargs = array( 'context' => $this->get_context(), 'objectid' => $this->properties->id, 'other' => array( 'repeatid' => empty($this->properties->repeatid) ? 0 : $this->properties->repeatid, 'timestart' => $this->properties->timestart, 'name' => $this->properties->name ) ); if (empty($this->properties->id) || $this->properties->id < 1) { if ($checkcapability) { if (!calendar_add_event_allowed($this->properties)) { throw new \moodle_exception('nopermissiontoupdatecalendar'); } } if ($usingeditor) { switch ($this->properties->eventtype) { case 'user': $this->properties->courseid = 0; $this->properties->course = 0; $this->properties->groupid = 0; $this->properties->userid = $USER->id; break; case 'site': $this->properties->courseid = SITEID; $this->properties->course = SITEID; $this->properties->groupid = 0; $this->properties->userid = $USER->id; break; case 'course': $this->properties->groupid = 0; $this->properties->userid = $USER->id; break; case 'category': $this->properties->groupid = 0; $this->properties->category = 0; $this->properties->userid = $USER->id; break; case 'group': $this->properties->userid = $USER->id; break; default: // We should NEVER get here, but just incase we do lets fail gracefully. $usingeditor = false; break; } // If we are actually using the editor, we recalculate the context because some default values // were set when calculate_context() was called from the constructor. if ($usingeditor) { $this->properties->context = $this->calculate_context(); $this->editorcontext = $this->get_context(); } $editor = $this->properties->description; $this->properties->format = $this->properties->description['format']; $this->properties->description = $this->properties->description['text']; } // Insert the event into the database. $this->properties->id = $DB->insert_record('event', $this->properties); if ($usingeditor) { $this->properties->description = file_save_draft_area_files( $editor['itemid'], $this->editorcontext->id, 'calendar', 'event_description', $this->properties->id, $this->editoroptions, $editor['text'], $this->editoroptions['forcehttps']); $DB->set_field('event', 'description', $this->properties->description, array('id' => $this->properties->id)); } // Log the event entry. $eventargs['objectid'] = $this->properties->id; $eventargs['context'] = $this->get_context(); $event = \core\event\calendar_event_created::create($eventargs); $event->trigger(); $repeatedids = array(); if (!empty($this->properties->repeat)) { $this->properties->repeatid = $this->properties->id; $DB->set_field('event', 'repeatid', $this->properties->repeatid, array('id' => $this->properties->id)); $eventcopy = clone($this->properties); unset($eventcopy->id); $timestart = new \DateTime('@' . $eventcopy->timestart); $timestart->setTimezone(\core_date::get_user_timezone_object()); for ($i = 1; $i < $eventcopy->repeats; $i++) { $timestart->add(new \DateInterval('P7D')); $eventcopy->timestart = $timestart->getTimestamp(); // Get the event id for the log record. $eventcopyid = $DB->insert_record('event', $eventcopy); // If the context has been set delete all associated files. if ($usingeditor) { $fs = get_file_storage(); $files = $fs->get_area_files($this->editorcontext->id, 'calendar', 'event_description', $this->properties->id); foreach ($files as $file) { $fs->create_file_from_storedfile(array('itemid' => $eventcopyid), $file); } } $repeatedids[] = $eventcopyid; // Trigger an event. $eventargs['objectid'] = $eventcopyid; $eventargs['other']['timestart'] = $eventcopy->timestart; $event = \core\event\calendar_event_created::create($eventargs); $event->trigger(); } } return true; } else { if ($checkcapability) { if (!calendar_edit_event_allowed($this->properties)) { throw new \moodle_exception('nopermissiontoupdatecalendar'); } } if ($usingeditor) { if ($this->editorcontext !== null) { $this->properties->description = file_save_draft_area_files( $this->properties->description['itemid'], $this->editorcontext->id, 'calendar', 'event_description', $this->properties->id, $this->editoroptions, $this->properties->description['text'], $this->editoroptions['forcehttps']); } else { $this->properties->format = $this->properties->description['format']; $this->properties->description = $this->properties->description['text']; } } $event = $DB->get_record('event', array('id' => $this->properties->id)); $updaterepeated = (!empty($this->properties->repeatid) && !empty($this->properties->repeateditall)); if ($updaterepeated) { $sqlset = 'name = ?, description = ?, timeduration = ?, timemodified = ?, groupid = ?, courseid = ?'; // Note: Group and course id may not be set. If not, keep their current values. $params = [ $this->properties->name, $this->properties->description, $this->properties->timeduration, time(), isset($this->properties->groupid) ? $this->properties->groupid : $event->groupid, isset($this->properties->courseid) ? $this->properties->courseid : $event->courseid, ]; // Note: Only update start date, if it was changed by the user. if ($this->properties->timestart != $event->timestart) { $timestartoffset = $this->properties->timestart - $event->timestart; $sqlset .= ', timestart = timestart + ?'; $params[] = $timestartoffset; } // Note: Only update location, if it was changed by the user. $updatelocation = (!empty($this->properties->location) && $this->properties->location !== $event->location); if ($updatelocation) { $sqlset .= ', location = ?'; $params[] = $this->properties->location; } // Update all. $sql = "UPDATE {event} SET $sqlset WHERE repeatid = ?"; $params[] = $event->repeatid; $DB->execute($sql, $params); // Trigger an update event for each of the calendar event. $events = $DB->get_records('event', array('repeatid' => $event->repeatid), '', '*'); foreach ($events as $calendarevent) { $eventargs['objectid'] = $calendarevent->id; $eventargs['other']['timestart'] = $calendarevent->timestart; $event = \core\event\calendar_event_updated::create($eventargs); $event->add_record_snapshot('event', $calendarevent); $event->trigger(); } } else { $DB->update_record('event', $this->properties); $event = self::load($this->properties->id); $this->properties = $event->properties(); // Trigger an update event. $event = \core\event\calendar_event_updated::create($eventargs); $event->add_record_snapshot('event', $this->properties); $event->trigger(); } return true; } } /** * Deletes an event and if selected an repeated events in the same series * * This function deletes an event, any associated events if $deleterepeated=true, * and cleans up any files associated with the events. * * @see self::delete() * * @param bool $deleterepeated delete event repeatedly * @return bool succession of deleting event */ public function delete($deleterepeated = false) { global $DB; // If $this->properties->id is not set then something is wrong. if (empty($this->properties->id)) { debugging('Attempting to delete an event before it has been loaded', DEBUG_DEVELOPER); return false; } $calevent = $DB->get_record('event', array('id' => $this->properties->id), '*', MUST_EXIST); // Delete the event. $DB->delete_records('event', array('id' => $this->properties->id)); // Trigger an event for the delete action. $eventargs = array( 'context' => $this->get_context(), 'objectid' => $this->properties->id, 'other' => array( 'repeatid' => empty($this->properties->repeatid) ? 0 : $this->properties->repeatid, 'timestart' => $this->properties->timestart, 'name' => $this->properties->name )); $event = \core\event\calendar_event_deleted::create($eventargs); $event->add_record_snapshot('event', $calevent); $event->trigger(); // If we are deleting parent of a repeated event series, promote the next event in the series as parent. if (($this->properties->id == $this->properties->repeatid) && !$deleterepeated) { $newparent = $DB->get_field_sql("SELECT id from {event} where repeatid = ? order by id ASC", array($this->properties->id), IGNORE_MULTIPLE); if (!empty($newparent)) { $DB->execute("UPDATE {event} SET repeatid = ? WHERE repeatid = ?", array($newparent, $this->properties->id)); // Get all records where the repeatid is the same as the event being removed. $events = $DB->get_records('event', array('repeatid' => $newparent)); // For each of the returned events trigger an update event. foreach ($events as $calendarevent) { // Trigger an event for the update. $eventargs['objectid'] = $calendarevent->id; $eventargs['other']['timestart'] = $calendarevent->timestart; $event = \core\event\calendar_event_updated::create($eventargs); $event->add_record_snapshot('event', $calendarevent); $event->trigger(); } } } // If the editor context hasn't already been set then set it now. if ($this->editorcontext === null) { $this->editorcontext = $this->get_context(); } // If the context has been set delete all associated files. if ($this->editorcontext !== null) { $fs = get_file_storage(); $files = $fs->get_area_files($this->editorcontext->id, 'calendar', 'event_description', $this->properties->id); foreach ($files as $file) { $file->delete(); } } // If we need to delete repeated events then we will fetch them all and delete one by one. if ($deleterepeated && !empty($this->properties->repeatid) && $this->properties->repeatid > 0) { // Get all records where the repeatid is the same as the event being removed. $events = $DB->get_records('event', array('repeatid' => $this->properties->repeatid)); // For each of the returned events populate an event object and call delete. // make sure the arg passed is false as we are already deleting all repeats. foreach ($events as $event) { $event = new calendar_event($event); $event->delete(false); } } return true; } /** * Fetch all event properties. * * This function returns all of the events properties as an object and optionally * can prepare an editor for the description field at the same time. This is * designed to work when the properties are going to be used to set the default * values of a moodle forms form. * * @param bool $prepareeditor If set to true a editor is prepared for use with * the mforms editor element. (for description) * @return \stdClass Object containing event properties */ public function properties($prepareeditor = false) { global $DB; // First take a copy of the properties. We don't want to actually change the // properties or we'd forever be converting back and forwards between an // editor formatted description and not. $properties = clone($this->properties); // Clean the description here. $properties->description = clean_text($properties->description, $properties->format); // If set to true we need to prepare the properties for use with an editor // and prepare the file area. if ($prepareeditor) { // We may or may not have a property id. If we do then we need to work // out the context so we can copy the existing files to the draft area. if (!empty($properties->id)) { if ($properties->eventtype === 'site') { // Site context. $this->editorcontext = $this->get_context(); } else if ($properties->eventtype === 'user') { // User context. $this->editorcontext = $this->get_context(); } else if ($properties->eventtype === 'group' || $properties->eventtype === 'course') { // First check the course is valid. $course = $DB->get_record('course', array('id' => $properties->courseid)); if (!$course) { throw new \moodle_exception('invalidcourse'); } // Course context. $this->editorcontext = $this->get_context(); // We have a course and are within the course context so we had // better use the courses max bytes value. $this->editoroptions['maxbytes'] = $course->maxbytes; } else if ($properties->eventtype === 'category') { // First check the course is valid. \core_course_category::get($properties->categoryid, MUST_EXIST, true); // Course context. $this->editorcontext = $this->get_context(); } else { // If we get here we have a custom event type as used by some // modules. In this case the event will have been added by // code and we won't need the editor. $this->editoroptions['maxbytes'] = 0; $this->editoroptions['maxfiles'] = 0; } if (empty($this->editorcontext) || empty($this->editorcontext->id)) { $contextid = false; } else { // Get the context id that is what we really want. $contextid = $this->editorcontext->id; } } else { // If we get here then this is a new event in which case we don't need a // context as there is no existing files to copy to the draft area. $contextid = null; } // If the contextid === false we don't support files so no preparing // a draft area. if ($contextid !== false) { // Just encase it has already been submitted. $draftiddescription = file_get_submitted_draft_itemid('description'); // Prepare the draft area, this copies existing files to the draft area as well. $properties->description = file_prepare_draft_area($draftiddescription, $contextid, 'calendar', 'event_description', $properties->id, $this->editoroptions, $properties->description); } else { $draftiddescription = 0; } // Structure the description field as the editor requires. $properties->description = array('text' => $properties->description, 'format' => $properties->format, 'itemid' => $draftiddescription); } // Finally return the properties. return $properties; } /** * Toggles the visibility of an event * * @param null|bool $force If it is left null the events visibility is flipped, * If it is false the event is made hidden, if it is true it * is made visible. * @return bool if event is successfully updated, toggle will be visible */ public function toggle_visibility($force = null) { global $DB; // Set visible to the default if it is not already set. if (empty($this->properties->visible)) { $this->properties->visible = 1; } if ($force === true || ($force !== false && $this->properties->visible == 0)) { // Make this event visible. $this->properties->visible = 1; } else { // Make this event hidden. $this->properties->visible = 0; } // Update the database to reflect this change. $success = $DB->set_field('event', 'visible', $this->properties->visible, array('id' => $this->properties->id)); $calendarevent = $DB->get_record('event', array('id' => $this->properties->id), '*', MUST_EXIST); // Prepare event data. $eventargs = array( 'context' => $this->get_context(), 'objectid' => $this->properties->id, 'other' => array( 'repeatid' => empty($this->properties->repeatid) ? 0 : $this->properties->repeatid, 'timestart' => $this->properties->timestart, 'name' => $this->properties->name ) ); $event = \core\event\calendar_event_updated::create($eventargs); $event->add_record_snapshot('event', $calendarevent); $event->trigger(); return $success; } /** * Returns an event object when provided with an event id. * * This function makes use of MUST_EXIST, if the event id passed in is invalid * it will result in an exception being thrown. * * @param int|object $param event object or event id * @return calendar_event */ public static function load($param) { global $DB; if (is_object($param)) { $event = new calendar_event($param); } else { $event = $DB->get_record('event', array('id' => (int)$param), '*', MUST_EXIST); $event = new calendar_event($event); } return $event; } /** * Creates a new event and returns an event object. * * Capability checking should be performed if the user is directly creating the event * and no other capability has been tested. However if the event is not being created * directly by the user and another capability has been checked for them to do this then * capabilites should not be checked. * * For example if a user is creating an event in the calendar the check should be true, * but if you are creating an event in an activity when it is created then the calendar * capabilites should not be checked. * * @param \stdClass|array $properties An object containing event properties * @param bool $checkcapability If Moodle should check the user can manage the calendar events for this call or not. * @throws \coding_exception * * @return calendar_event|bool The event object or false if it failed */ public static function create($properties, $checkcapability = true) { if (is_array($properties)) { $properties = (object)$properties; } if (!is_object($properties)) { throw new \coding_exception('When creating an event properties should be either an object or an assoc array'); } $event = new calendar_event($properties); if ($event->update($properties, $checkcapability)) { return $event; } else { return false; } } /** * Format the event name using the external API. * * This function should we used when text formatting is required in external functions. * * @return string Formatted name. */ public function format_external_name() { if ($this->editorcontext === null) { // Switch on the event type to decide upon the appropriate context to use for this event. $this->editorcontext = $this->get_context(); } return \core_external\util::format_string($this->properties->name, $this->editorcontext->id); } /** * Format the text using the external API. * * This function should we used when text formatting is required in external functions. * * @return array an array containing the text formatted and the text format */ public function format_external_text() { if ($this->editorcontext === null) { // Switch on the event type to decide upon the appropriate context to use for this event. $this->editorcontext = $this->get_context(); if (!calendar_is_valid_eventtype($this->properties->eventtype)) { // We don't have a context here, do a normal format_text. return \core_external\util::format_text( $this->properties->description, $this->properties->format, $this->editorcontext ); } } // Work out the item id for the editor, if this is a repeated event then the files will be associated with the original. if (!empty($this->properties->repeatid) && $this->properties->repeatid > 0) { $itemid = $this->properties->repeatid; } else { $itemid = $this->properties->id; } return \core_external\util::format_text( $this->properties->description, $this->properties->format, $this->editorcontext, 'calendar', 'event_description', $itemid ); } } /** * Calendar information class * * This class is used simply to organise the information pertaining to a calendar * and is used primarily to make information easily available. * * @package core_calendar * @category calendar * @copyright 2010 Sam Hemelryk * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class calendar_information { /** * @var int The timestamp * * Rather than setting the day, month and year we will set a timestamp which will be able * to be used by multiple calendars. */ public $time; /** @var int A course id */ public $courseid = null; /** @var array An array of categories */ public $categories = array(); /** @var int The current category */ public $categoryid = null; /** @var array An array of courses */ public $courses = array(); /** @var array An array of groups */ public $groups = array(); /** @var array An array of users */ public $users = array(); /** @var context The anticipated context that the calendar is viewed in */ public $context = null; /** @var string The calendar's view mode. */ protected $viewmode; /** @var \stdClass course data. */ public $course; /** @var int day. */ protected $day; /** @var int month. */ protected $month; /** @var int year. */ protected $year; /** * Creates a new instance * * @param int $day the number of the day * @param int $month the number of the month * @param int $year the number of the year * @param int $time the unixtimestamp representing the date we want to view, this is used instead of $calmonth * and $calyear to support multiple calendars */ public function __construct($day = 0, $month = 0, $year = 0, $time = 0) { // If a day, month and year were passed then convert it to a timestamp. If these were passed // then we can assume the day, month and year are passed as Gregorian, as no where in core // should we be passing these values rather than the time. This is done for BC. if (!empty($day) || !empty($month) || !empty($year)) { $date = usergetdate(time()); if (empty($day)) { $day = $date['mday']; } if (empty($month)) { $month = $date['mon']; } if (empty($year)) { $year = $date['year']; } if (checkdate($month, $day, $year)) { $time = make_timestamp($year, $month, $day); } else { $time = time(); } } $this->set_time($time); } /** * Creates and set up a instance. * * @param int $time the unixtimestamp representing the date we want to view. * @param int $courseid The ID of the course the user wishes to view. * @param int $categoryid The ID of the category the user wishes to view * If a courseid is specified, this value is ignored. * @return calendar_information */ public static function create($time, int $courseid, ?int $categoryid = null): calendar_information { $calendar = new static(0, 0, 0, $time); if ($courseid != SITEID && !empty($courseid)) { // Course ID must be valid and existing. $course = get_course($courseid); $calendar->context = context_course::instance($course->id); if (!$course->visible && !is_role_switched($course->id)) { require_capability('moodle/course:viewhiddencourses', $calendar->context); } $courses = [$course->id => $course]; $category = (\core_course_category::get($course->category, MUST_EXIST, true))->get_db_record(); } else if (!empty($categoryid)) { $course = get_site(); $courses = calendar_get_default_courses(null, 'id, category, groupmode, groupmodeforce'); // Filter available courses to those within this category or it's children. $ids = [$categoryid]; $category = \core_course_category::get($categoryid); $ids = array_merge($ids, array_keys($category->get_children())); $courses = array_filter($courses, function($course) use ($ids) { return array_search($course->category, $ids) !== false; }); $category = $category->get_db_record(); $calendar->context = context_coursecat::instance($categoryid); } else { $course = get_site(); $courses = calendar_get_default_courses(null, 'id, category, groupmode, groupmodeforce'); $category = null; $calendar->context = context_system::instance(); } $calendar->set_sources($course, $courses, $category); return $calendar; } /** * Set the time period of this instance. * * @param int $time the unixtimestamp representing the date we want to view. * @return $this */ public function set_time($time = null) { if (empty($time)) { $this->time = time(); } else { $this->time = $time; } return $this; } /** * @deprecated 3.4 */ #[\core\attribute\deprecated('prepare_for_view', since: '3.4', mdl: 'MDL-59890', final: true)] public function prepare_for_view() { \core\deprecation::emit_deprecation([self::class, __FUNCTION__]); } /** * Set the sources for events within the calendar. * * If no category is provided, then the category path for the current * course will be used. * * @param stdClass $course The current course being viewed. * @param stdClass[] $courses The list of all courses currently accessible. * @param stdClass $category The current category to show. */ public function set_sources(stdClass $course, array $courses, ?stdClass $category = null) { global $USER; // A cousre must always be specified. $this->course = $course; $this->courseid = $course->id; list($courseids, $group, $user) = calendar_set_filters($courses); $this->courses = $courseids; $this->groups = $group; $this->users = $user; // Do not show category events by default. $this->categoryid = null; $this->categories = null; // Determine the correct category information to show. // When called with a course, the category of that course is usually included too. // When a category was specifically requested, it should be requested with the site id. if (SITEID !== $this->courseid) { // A specific course was requested. // Fetch the category that this course is in, along with all parents. // Do not include child categories of this category, as the user many not have enrolments in those siblings or children. $category = \core_course_category::get($course->category, MUST_EXIST, true); $this->categoryid = $category->id; $this->categories = $category->get_parents(); $this->categories[] = $category->id; } else if (null !== $category && $category->id > 0) { // A specific category was requested. // Fetch all parents of this category, along with all children too. $category = \core_course_category::get($category->id); $this->categoryid = $category->id; // Build the category list. // This includes the current category. $this->categories = $category->get_parents(); $this->categories[] = $category->id; $this->categories = array_merge($this->categories, $category->get_all_children_ids()); } else if (SITEID === $this->courseid) { // The site was requested. // Fetch all categories where this user has any enrolment, and all categories that this user can manage. // Grab the list of categories that this user has courses in. $coursecategories = array_flip(array_map(function($course) { return $course->category; }, $courses)); $calcatcache = cache::make('core', 'calendar_categories'); $this->categories = $calcatcache->get('site'); if ($this->categories === false) { // Use the category id as the key in the following array. That way we do not have to remove duplicates. $categories = []; foreach (\core_course_category::get_all() as $category) { if (isset($coursecategories[$category->id]) || has_capability('moodle/category:manage', $category->get_context(), $USER, false)) { // If the user has access to a course in this category or can manage the category, // then they can see all parent categories too. $categories[$category->id] = true; foreach ($category->get_parents() as $catid) { $categories[$catid] = true; } } } $this->categories = array_keys($categories); $calcatcache->set('site', $this->categories); } } } /** * Ensures the date for the calendar is correct and either sets it to now * or throws a moodle_exception if not * * @param bool $defaultonow use current time * @throws moodle_exception * @return bool validation of checkdate */ public function checkdate($defaultonow = true) { if (!checkdate($this->month, $this->day, $this->year)) { if ($defaultonow) { $now = usergetdate(time()); $this->day = intval($now['mday']); $this->month = intval($now['mon']); $this->year = intval($now['year']); return true; } else { throw new moodle_exception('invaliddate'); } } return true; } /** * Gets todays timestamp for the calendar * * @return int today timestamp */ public function timestamp_today() { return $this->time; } /** * Gets tomorrows timestamp for the calendar * * @return int tomorrow timestamp */ public function timestamp_tomorrow() { return strtotime('+1 day', $this->time); } /** * Adds the pretend blocks for the calendar * * @param core_calendar_renderer $renderer * @param bool $showfilters display filters, false is set as default * @param string|null $view preference view options (eg: day, month, upcoming) */ public function add_sidecalendar_blocks(core_calendar_renderer $renderer, $showfilters=false, $view=null) { global $PAGE; if (!has_capability('moodle/block:view', $PAGE->context) ) { return; } if ($showfilters) { $filters = new block_contents(); $filters->content = $renderer->event_filter(); $filters->footer = ''; $filters->title = get_string('eventskey', 'calendar'); $renderer->add_pretend_calendar_block($filters, BLOCK_POS_RIGHT); } } /** * Getter method for the calendar's view mode. * * @return string */ public function get_viewmode(): string { return $this->viewmode; } /** * Setter method for the calendar's view mode. * * @param string $viewmode */ public function set_viewmode(string $viewmode): void { $this->viewmode = $viewmode; } } /** * Get calendar events. * * @param int $tstart Start time of time range for events * @param int $tend End time of time range for events * @param array|int|boolean $users array of users, user id or boolean for all/no user events * @param array|int|boolean $groups array of groups, group id or boolean for all/no group events * @param array|int|boolean $courses array of courses, course id or boolean for all/no course events * @param boolean $withduration whether only events starting within time range selected * or events in progress/already started selected as well * @param boolean $ignorehidden whether to select only visible events or all events * @param array|int|boolean $categories array of categories, category id or boolean for all/no course events * @return array $events of selected events or an empty array if there aren't any (or there was an error) */ function calendar_get_events($tstart, $tend, $users, $groups, $courses, $withduration = true, $ignorehidden = true, $categories = []) { global $DB; $whereclause = ''; $params = array(); // Quick test. if (empty($users) && empty($groups) && empty($courses) && empty($categories)) { return array(); } if ((is_array($users) && !empty($users)) or is_numeric($users)) { // Events from a number of users if(!empty($whereclause)) $whereclause .= ' OR'; list($insqlusers, $inparamsusers) = $DB->get_in_or_equal($users, SQL_PARAMS_NAMED); $whereclause .= " (e.userid $insqlusers AND e.courseid = 0 AND e.groupid = 0 AND e.categoryid = 0)"; $params = array_merge($params, $inparamsusers); } else if($users === true) { // Events from ALL users if(!empty($whereclause)) $whereclause .= ' OR'; $whereclause .= ' (e.userid != 0 AND e.courseid = 0 AND e.groupid = 0 AND e.categoryid = 0)'; } else if($users === false) { // No user at all, do nothing } if ((is_array($groups) && !empty($groups)) or is_numeric($groups)) { // Events from a number of groups if(!empty($whereclause)) $whereclause .= ' OR'; list($insqlgroups, $inparamsgroups) = $DB->get_in_or_equal($groups, SQL_PARAMS_NAMED); $whereclause .= " e.groupid $insqlgroups "; $params = array_merge($params, $inparamsgroups); } else if($groups === true) { // Events from ALL groups if(!empty($whereclause)) $whereclause .= ' OR '; $whereclause .= ' e.groupid != 0'; } // boolean false (no groups at all): we don't need to do anything if ((is_array($courses) && !empty($courses)) or is_numeric($courses)) { if(!empty($whereclause)) $whereclause .= ' OR'; list($insqlcourses, $inparamscourses) = $DB->get_in_or_equal($courses, SQL_PARAMS_NAMED); $whereclause .= " (e.groupid = 0 AND e.courseid $insqlcourses)"; $params = array_merge($params, $inparamscourses); } else if ($courses === true) { // Events from ALL courses if(!empty($whereclause)) $whereclause .= ' OR'; $whereclause .= ' (e.groupid = 0 AND e.courseid != 0)'; } if ((is_array($categories) && !empty($categories)) || is_numeric($categories)) { if (!empty($whereclause)) { $whereclause .= ' OR'; } list($insqlcategories, $inparamscategories) = $DB->get_in_or_equal($categories, SQL_PARAMS_NAMED); $whereclause .= " (e.groupid = 0 AND e.courseid = 0 AND e.categoryid $insqlcategories)"; $params = array_merge($params, $inparamscategories); } else if ($categories === true) { // Events from ALL categories. if (!empty($whereclause)) { $whereclause .= ' OR'; } $whereclause .= ' (e.groupid = 0 AND e.courseid = 0 AND e.categoryid != 0)'; } // Security check: if, by now, we have NOTHING in $whereclause, then it means // that NO event-selecting clauses were defined. Thus, we won't be returning ANY // events no matter what. Allowing the code to proceed might return a completely // valid query with only time constraints, thus selecting ALL events in that time frame! if(empty($whereclause)) { return array(); } if($withduration) { $timeclause = '(e.timestart >= '.$tstart.' OR e.timestart + e.timeduration > '.$tstart.') AND e.timestart <= '.$tend; } else { $timeclause = 'e.timestart >= '.$tstart.' AND e.timestart <= '.$tend; } if(!empty($whereclause)) { // We have additional constraints $whereclause = $timeclause.' AND ('.$whereclause.')'; } else { // Just basic time filtering $whereclause = $timeclause; } if ($ignorehidden) { $whereclause .= ' AND e.visible = 1'; } $sql = "SELECT e.* FROM {event} e LEFT JOIN {modules} m ON e.modulename = m.name -- Non visible modules will have a value of 0. WHERE (m.visible = 1 OR m.visible IS NULL) AND $whereclause ORDER BY e.timestart"; $events = $DB->get_records_sql($sql, $params); if ($events === false) { $events = array(); } return $events; } /** * Return the days of the week. * * @return array array of days */ function calendar_get_days() { $calendartype = \core_calendar\type_factory::get_calendar_instance(); return $calendartype->get_weekdays(); } /** * Get the subscription from a given id. * * @since Moodle 2.5 * @param int $id id of the subscription * @return stdClass Subscription record from DB * @throws moodle_exception for an invalid id */ function calendar_get_subscription($id) { global $DB; $cache = \cache::make('core', 'calendar_subscriptions'); $subscription = $cache->get($id); if (empty($subscription)) { $subscription = $DB->get_record('event_subscriptions', array('id' => $id), '*', MUST_EXIST); $cache->set($id, $subscription); } return $subscription; } /** * Gets the first day of the week. * * Used to be define('CALENDAR_STARTING_WEEKDAY', blah); * * @return int */ function calendar_get_starting_weekday() { $calendartype = \core_calendar\type_factory::get_calendar_instance(); return $calendartype->get_starting_weekday(); } /** * Get current module cache. * * Only use this method if you do not know courseid. Otherwise use: * get_fast_modinfo($courseid)->instances[$modulename][$instance] * * @param array $modulecache in memory module cache * @param string $modulename name of the module * @param int $instance module instance number * @return stdClass|bool $module information */ function calendar_get_module_cached(&$modulecache, $modulename, $instance) { if (!isset($modulecache[$modulename . '_' . $instance])) { $modulecache[$modulename . '_' . $instance] = get_coursemodule_from_instance($modulename, $instance); } return $modulecache[$modulename . '_' . $instance]; } /** * Get current course cache. * * @param array $coursecache list of course cache * @param int $courseid id of the course * @return stdClass $coursecache[$courseid] return the specific course cache */ function calendar_get_course_cached(&$coursecache, $courseid) { if (!isset($coursecache[$courseid])) { $coursecache[$courseid] = get_course($courseid); } return $coursecache[$courseid]; } /** * Get group from groupid for calendar display * * @param int $groupid * @return stdClass group object with fields 'id', 'name' and 'courseid' */ function calendar_get_group_cached($groupid) { static $groupscache = array(); if (!isset($groupscache[$groupid])) { $groupscache[$groupid] = groups_get_group($groupid, 'id,name,courseid'); } return $groupscache[$groupid]; } /** * Get calendar events by id. * * @since Moodle 2.5 * @param array $eventids list of event ids * @return array Array of event entries, empty array if nothing found */ function calendar_get_events_by_id($eventids) { global $DB; if (!is_array($eventids) || empty($eventids)) { return array(); } list($wheresql, $params) = $DB->get_in_or_equal($eventids); $wheresql = "id $wheresql"; return $DB->get_records_select('event', $wheresql, $params); } /** * Adds day, month, year arguments to a URL and returns a moodle_url object. * * @param string|moodle_url $linkbase * @param int $d The number of the day. * @param int $m The number of the month. * @param int $y The number of the year. * @param int $time the unixtime, used for multiple calendar support. The values $d, * $m and $y are kept for backwards compatibility. * @return moodle_url|null $linkbase */ function calendar_get_link_href($linkbase, $d, $m, $y, $time = 0) { if (empty($linkbase)) { return null; } if (!($linkbase instanceof \moodle_url)) { $linkbase = new \moodle_url($linkbase); } $linkbase->param('time', calendar_get_timestamp($d, $m, $y, $time)); return $linkbase; } /** * Return the number of days in month. * * @param int $month the number of the month. * @param int $year the number of the year * @return int */ function calendar_days_in_month($month, $year) { $calendartype = \core_calendar\type_factory::get_calendar_instance(); return $calendartype->get_num_days_in_month($year, $month); } /** * Returns the courses to load events for. * * @param array $courseeventsfrom An array of courses to load calendar events for * @param bool $ignorefilters specify the use of filters, false is set as default * @param stdClass $user The user object. This defaults to the global $USER object. * @return array An array of courses, groups, and user to load calendar events for based upon filters */ function calendar_set_filters(array $courseeventsfrom, $ignorefilters = false, ?stdClass $user = null) { global $CFG, $USER; if (is_null($user)) { $user = $USER; } $courses = array(); $userid = false; $group = false; // Get the capabilities that allow seeing group events from all groups. $allgroupscaps = array('moodle/site:accessallgroups', 'moodle/calendar:manageentries'); $isvaliduser = !empty($user->id); if ($ignorefilters || calendar_show_event_type(CALENDAR_EVENT_COURSE, $user)) { $courses = array_keys($courseeventsfrom); } if ($ignorefilters || calendar_show_event_type(CALENDAR_EVENT_SITE, $user)) { $courses[] = SITEID; } $courses = array_unique($courses); sort($courses); if (!empty($courses) && in_array(SITEID, $courses)) { // Sort courses for consistent colour highlighting. // Effectively ignoring SITEID as setting as last course id. $key = array_search(SITEID, $courses); unset($courses[$key]); $courses[] = SITEID; } if ($ignorefilters || ($isvaliduser && calendar_show_event_type(CALENDAR_EVENT_USER, $user))) { $userid = $user->id; } if (!empty($courseeventsfrom) && (calendar_show_event_type(CALENDAR_EVENT_GROUP, $user) || $ignorefilters)) { if (!empty($CFG->calendar_adminseesall) && has_any_capability($allgroupscaps, \context_system::instance())) { $group = true; } else if ($isvaliduser) { $groupids = []; foreach ($courseeventsfrom as $courseid => $course) { if ($course->groupmode != NOGROUPS || !$course->groupmodeforce) { if (has_all_capabilities($allgroupscaps, \context_course::instance($courseid))) { // User can access all groups in this course. // Get all the groups in this course. $coursegroups = groups_get_all_groups($course->id, 0, 0, 'g.id'); $groupids = array_merge($groupids, array_keys($coursegroups)); } else { // User can only access their own groups. // Get the groups the user is in. $coursegroups = groups_get_user_groups($course->id, $user->id); $groupids = array_merge($groupids, $coursegroups['0']); } } } if (!empty($groupids)) { $group = $groupids; } } } if (empty($courses)) { $courses = false; } return array($courses, $group, $userid); } /** * Can current user manage a non user event in system context. * * @param calendar_event|stdClass $event event object * @return boolean */ function calendar_can_manage_non_user_event_in_system($event) { $sitecontext = \context_system::instance(); $isuserevent = $event->eventtype == 'user'; $canmanageentries = has_capability('moodle/calendar:manageentries', $sitecontext); // If user has manageentries at site level and it's not user event, return true. if ($canmanageentries && !$isuserevent) { return true; } return false; } /** * Return the capability for viewing a calendar event. * * @param calendar_event $event event object * @return boolean */ function calendar_view_event_allowed(calendar_event $event) { global $USER; // Anyone can see site events. if ($event->courseid && $event->courseid == SITEID) { return true; } if (calendar_can_manage_non_user_event_in_system($event)) { return true; } if (!empty($event->groupid)) { // If it is a group event we need to be able to manage events in the course, or be in the group. if (has_capability('moodle/calendar:manageentries', $event->context) || has_capability('moodle/calendar:managegroupentries', $event->context)) { return true; } $mycourses = enrol_get_my_courses('id'); return isset($mycourses[$event->courseid]) && groups_is_member($event->groupid); } else if ($event->modulename) { // If this is a module event we need to be able to see the module. $coursemodules = []; $courseid = 0; // Override events do not have the courseid set. if ($event->courseid) { $courseid = $event->courseid; $coursemodules = get_fast_modinfo($event->courseid)->instances; } else { $cmraw = get_coursemodule_from_instance($event->modulename, $event->instance, 0, false, MUST_EXIST); $courseid = $cmraw->course; $coursemodules = get_fast_modinfo($cmraw->course)->instances; } $hasmodule = isset($coursemodules[$event->modulename]); $hasinstance = isset($coursemodules[$event->modulename][$event->instance]); // If modinfo doesn't know about the module, return false to be safe. if (!$hasmodule || !$hasinstance) { return false; } // Must be able to see the course and the module - MDL-59304. $cm = $coursemodules[$event->modulename][$event->instance]; if (!$cm->uservisible) { return false; } $mycourses = enrol_get_my_courses('id'); return isset($mycourses[$courseid]); } else if ($event->categoryid) { // If this is a category we need to be able to see the category. $cat = \core_course_category::get($event->categoryid, IGNORE_MISSING); if (!$cat) { return false; } return true; } else if (!empty($event->courseid)) { // If it is a course event we need to be able to manage events in the course, or be in the course. if (has_capability('moodle/calendar:manageentries', $event->context)) { return true; } return can_access_course(get_course($event->courseid)); } else if ($event->userid) { return calendar_can_manage_user_event($event); } else { throw new moodle_exception('unknown event type'); } return false; } /** * Return the capability for editing calendar event. * * @param calendar_event $event event object * @param bool $manualedit is the event being edited manually by the user * @return bool capability to edit event */ function calendar_edit_event_allowed($event, $manualedit = false) { global $USER, $DB; // Must be logged in. if (!isloggedin()) { return false; } // Can not be using guest account. if (isguestuser()) { return false; } if ($manualedit && !empty($event->modulename)) { $hascallback = component_callback_exists( 'mod_' . $event->modulename, 'core_calendar_event_timestart_updated' ); if (!$hascallback) { // If the activity hasn't implemented the correct callback // to handle changes to it's events then don't allow any // manual changes to them. return false; } $coursemodules = get_fast_modinfo($event->courseid)->instances; $hasmodule = isset($coursemodules[$event->modulename]); $hasinstance = isset($coursemodules[$event->modulename][$event->instance]); // If modinfo doesn't know about the module, return false to be safe. if (!$hasmodule || !$hasinstance) { return false; } $coursemodule = $coursemodules[$event->modulename][$event->instance]; $context = context_module::instance($coursemodule->id); // This is the capability that allows a user to modify the activity // settings. Since the activity generated this event we need to check // that the current user has the same capability before allowing them // to update the event because the changes to the event will be // reflected within the activity. return has_capability('moodle/course:manageactivities', $context); } if ($manualedit && !empty($event->component)) { // TODO possibly we can later add a callback similar to core_calendar_event_timestart_updated in the modules. return false; } // You cannot edit URL based calendar subscription events presently. if (!empty($event->subscriptionid)) { if (!empty($event->subscription->url)) { // This event can be updated externally, so it cannot be edited. return false; } } if (calendar_can_manage_non_user_event_in_system($event)) { return true; } // If groupid is set, it's definitely a group event. if (!empty($event->groupid)) { // Allow users to add/edit group events if - // 1) They have manageentries for the course OR // 2) They have managegroupentries AND are in the group. $group = $DB->get_record('groups', array('id' => $event->groupid)); return $group && ( has_capability('moodle/calendar:manageentries', $event->context) || (has_capability('moodle/calendar:managegroupentries', $event->context) && groups_is_member($event->groupid))); } else if (!empty($event->courseid)) { // If groupid is not set, but course is set, it's definitely a course event. return has_capability('moodle/calendar:manageentries', $event->context); } else if (!empty($event->categoryid)) { // If groupid is not set, but category is set, it's definitely a category event. return has_capability('moodle/calendar:manageentries', $event->context); } else if (!empty($event->userid) && $event->userid == $USER->id) { // If course is not set, but userid id set, it's a user event. return (has_capability('moodle/calendar:manageownentries', context_user::instance($event->userid))); } else if (!empty($event->userid)) { return calendar_can_manage_user_event($event); } return false; } /** * Can current user edit/delete/add an user event? * * @param calendar_event|stdClass $event event object * @return bool */ function calendar_can_manage_user_event($event): bool { global $USER; if (!($event instanceof \calendar_event)) { $event = new \calendar_event(clone($event)); } $canmanage = has_capability('moodle/calendar:manageentries', $event->context); $canmanageown = has_capability('moodle/calendar:manageownentries', $event->context); $ismyevent = $event->userid == $USER->id; $isadminevent = is_siteadmin($event->userid); if ($canmanageown && $ismyevent) { return true; } // In site context, user must have login and calendar:manageentries permissions // ... to manage other user's events except admin users. if ($canmanage && !$isadminevent) { return true; } return false; } /** * Return the capability for deleting a calendar event. * * @param calendar_event $event The event object * @return bool Whether the user has permission to delete the event or not. */ function calendar_delete_event_allowed($event) { // Only allow delete if you have capabilities and it is not an module or component event. return (calendar_edit_event_allowed($event) && empty($event->modulename) && empty($event->component)); } /** * Returns the default courses to display on the calendar when there isn't a specific * course to display. * * @param int $courseid (optional) If passed, an additional course can be returned for admins (the current course). * @param string $fields Comma separated list of course fields to return. * @param bool $canmanage If true, this will return the list of courses the user can create events in, rather * than the list of courses they see events from (an admin can always add events in a course * calendar, even if they are not enrolled in the course). * @param int $userid (optional) The user which this function returns the default courses for. * By default the current user. * @return array $courses Array of courses to display */ function calendar_get_default_courses($courseid = null, $fields = '*', $canmanage = false, ?int $userid = null) { global $CFG, $USER; if (!$userid) { if (!isloggedin()) { return array(); } $userid = $USER->id; } if ((!empty($CFG->calendar_adminseesall) || $canmanage) && has_capability('moodle/calendar:manageentries', context_system::instance(), $userid)) { // Add a c. prefix to every field as expected by get_courses function. $fieldlist = explode(',', $fields); $prefixedfields = array_map(function($value) { return 'c.' . trim(strtolower($value)); }, $fieldlist); $courses = get_courses('all', 'c.shortname', implode(',', $prefixedfields)); } else { $courses = enrol_get_users_courses($userid, true, $fields, 'c.shortname'); } if ($courseid && $courseid != SITEID) { if (empty($courses[$courseid]) && has_capability('moodle/calendar:manageentries', context_system::instance(), $userid)) { // Allow a site admin to see calendars from courses he is not enrolled in. // This will come from $COURSE. $courses[$courseid] = get_course($courseid); } } return $courses; } /** * Format event location property * * @param calendar_event $event * @return string */ function calendar_format_event_location(calendar_event $event): string { $location = format_text($event->location, FORMAT_PLAIN, ['context' => $event->context]); // If it looks like a link, convert it to one. if (preg_match('/^https?:\/\//i', $location) && clean_param($location, PARAM_URL)) { $location = \html_writer::link($location, $location, [ 'title' => get_string('eventnamelocation', 'core_calendar', ['name' => $event->name, 'location' => $location]), ]); } return $location; } /** * Checks to see if the requested type of event should be shown for the given user. * * @param int $type The type to check the display for (default is to display all) * @param stdClass|int|null $user The user to check for - by default the current user * @return bool True if the tyep should be displayed false otherwise */ function calendar_show_event_type($type, $user = null) { $default = CALENDAR_EVENT_SITE + CALENDAR_EVENT_COURSE + CALENDAR_EVENT_GROUP + CALENDAR_EVENT_USER; if ((int)get_user_preferences('calendar_persistflt', 0, $user) === 0) { global $SESSION; if (!isset($SESSION->calendarshoweventtype)) { $SESSION->calendarshoweventtype = $default; } return $SESSION->calendarshoweventtype & $type; } else { return get_user_preferences('calendar_savedflt', $default, $user) & $type; } } /** * Sets the display of the event type given $display. * * If $display = true the event type will be shown. * If $display = false the event type will NOT be shown. * If $display = null the current value will be toggled and saved. * * @param int $type object of CALENDAR_EVENT_XXX * @param bool $display option to display event type * @param stdClass|int $user moodle user object or id, null means current user */ function calendar_set_event_type_display($type, $display = null, $user = null) { $persist = (int)get_user_preferences('calendar_persistflt', 0, $user); $default = CALENDAR_EVENT_SITE + CALENDAR_EVENT_COURSE + CALENDAR_EVENT_GROUP + CALENDAR_EVENT_USER + CALENDAR_EVENT_COURSECAT; if ($persist === 0) { global $SESSION; if (!isset($SESSION->calendarshoweventtype)) { $SESSION->calendarshoweventtype = $default; } $preference = $SESSION->calendarshoweventtype; } else { $preference = get_user_preferences('calendar_savedflt', $default, $user); } $current = $preference & $type; if ($display === null) { $display = !$current; } if ($display && !$current) { $preference += $type; } else if (!$display && $current) { $preference -= $type; } if ($persist === 0) { $SESSION->calendarshoweventtype = $preference; } else { if ($preference == $default) { unset_user_preference('calendar_savedflt', $user); } else { set_user_preference('calendar_savedflt', $preference, $user); } } } /** * Get calendar's allowed types. * * @param stdClass $allowed list of allowed edit for event type * @param stdClass|int $course object of a course or course id * @param array $groups array of groups for the given course * @param stdClass|int $category object of a category */ function calendar_get_allowed_types(&$allowed, $course = null, $groups = null, $category = null) { global $USER, $DB; $allowed = new \stdClass(); $allowed->user = has_capability('moodle/calendar:manageownentries', \context_system::instance()); $allowed->groups = false; $allowed->courses = false; $allowed->categories = false; $allowed->site = has_capability('moodle/calendar:manageentries', \context_course::instance(SITEID)); $getgroupsfunc = function($course, $context, $user) use ($groups) { if ($course->groupmode != NOGROUPS || !$course->groupmodeforce) { if (has_capability('moodle/site:accessallgroups', $context)) { return is_null($groups) ? groups_get_all_groups($course->id) : $groups; } else { if (is_null($groups)) { return groups_get_all_groups($course->id, $user->id); } else { return array_filter($groups, function($group) use ($user) { return isset($group->members[$user->id]); }); } } } return false; }; if (!empty($course)) { if (!is_object($course)) { $course = $DB->get_record('course', array('id' => $course), 'id, groupmode, groupmodeforce', MUST_EXIST); } if ($course->id != SITEID) { $coursecontext = \context_course::instance($course->id); $allowed->user = has_capability('moodle/calendar:manageownentries', $coursecontext); if (has_capability('moodle/calendar:manageentries', $coursecontext)) { $allowed->courses = array($course->id => 1); $allowed->groups = $getgroupsfunc($course, $coursecontext, $USER); } else if (has_capability('moodle/calendar:managegroupentries', $coursecontext)) { $allowed->groups = $getgroupsfunc($course, $coursecontext, $USER); } } } if (!empty($category)) { $catcontext = \context_coursecat::instance($category->id); if (has_capability('moodle/category:manage', $catcontext)) { $allowed->categories = [$category->id => 1]; } } } /** * See if user can add calendar entries at all used to print the "New Event" button. * * @param stdClass $course object of a course or course id * @return bool has the capability to add at least one event type */ function calendar_user_can_add_event($course) { if (!isloggedin() || isguestuser()) { return false; } calendar_get_allowed_types($allowed, $course); return (bool)($allowed->user || $allowed->groups || $allowed->courses || $allowed->categories || $allowed->site); } /** * Check wether the current user is permitted to add events. * * @param stdClass $event object of event * @return bool has the capability to add event */ function calendar_add_event_allowed($event) { global $USER, $DB; // Can not be using guest account. if (!isloggedin() or isguestuser()) { return false; } if (calendar_can_manage_non_user_event_in_system($event)) { return true; } switch ($event->eventtype) { case 'category': return has_capability('moodle/category:manage', $event->context); case 'course': return has_capability('moodle/calendar:manageentries', $event->context); case 'group': // Allow users to add/edit group events if - // 1) They have manageentries (= entries for whole course). // 2) They have managegroupentries AND are in the group. $group = $DB->get_record('groups', array('id' => $event->groupid)); return $group && ( has_capability('moodle/calendar:manageentries', $event->context) || (has_capability('moodle/calendar:managegroupentries', $event->context) && groups_is_member($event->groupid))); case 'user': return calendar_can_manage_user_event($event); case 'site': return has_capability('moodle/calendar:manageentries', $event->context); default: return has_capability('moodle/calendar:manageentries', $event->context); } } /** * Returns option list for the poll interval setting. * * @return array An array of poll interval options. Interval => description. */ function calendar_get_pollinterval_choices() { return array( '0' => get_string('never', 'calendar'), HOURSECS => get_string('hourly', 'calendar'), DAYSECS => get_string('daily', 'calendar'), WEEKSECS => get_string('weekly', 'calendar'), '2628000' => get_string('monthly', 'calendar'), YEARSECS => get_string('annually', 'calendar') ); } /** * Returns option list of available options for the calendar event type, given the current user and course. * * @param int $courseid The id of the course * @return array An array containing the event types the user can create. */ function calendar_get_eventtype_choices($courseid) { $choices = array(); $allowed = new \stdClass; calendar_get_allowed_types($allowed, $courseid); if ($allowed->user) { $choices['user'] = get_string('userevents', 'calendar'); } if ($allowed->site) { $choices['site'] = get_string('siteevents', 'calendar'); } if (!empty($allowed->courses)) { $choices['course'] = get_string('courseevents', 'calendar'); } if (!empty($allowed->categories)) { $choices['category'] = get_string('categoryevents', 'calendar'); } if (!empty($allowed->groups) and is_array($allowed->groups)) { $choices['group'] = get_string('group'); } return array($choices, $allowed->groups); } /** * Add an iCalendar subscription to the database. * * @param stdClass $sub The subscription object (e.g. from the form) * @return int The insert ID, if any. */ function calendar_add_subscription($sub) { global $DB, $USER, $SITE; // Undo the form definition work around to allow us to have two different // course selectors present depending on which event type the user selects. if (!empty($sub->groupcourseid)) { $sub->courseid = $sub->groupcourseid; unset($sub->groupcourseid); } // Default course id if none is set. if (empty($sub->courseid)) { if ($sub->eventtype === 'site') { $sub->courseid = SITEID; } else { $sub->courseid = 0; } } if ($sub->eventtype === 'site') { $sub->courseid = $SITE->id; } else if ($sub->eventtype === 'group' || $sub->eventtype === 'course') { $sub->courseid = $sub->courseid; } else if ($sub->eventtype === 'category') { $sub->categoryid = $sub->categoryid; } else { // User events. $sub->courseid = 0; } $sub->userid = $USER->id; // File subscriptions never update. if (empty($sub->url)) { $sub->pollinterval = 0; } if (!empty($sub->name)) { if (empty($sub->id)) { $id = $DB->insert_record('event_subscriptions', $sub); // We cannot cache the data here because $sub is not complete. $sub->id = $id; // Trigger event, calendar subscription added. $eventparams = array('objectid' => $sub->id, 'context' => calendar_get_calendar_context($sub), 'other' => array( 'eventtype' => $sub->eventtype, ) ); switch ($sub->eventtype) { case 'category': $eventparams['other']['categoryid'] = $sub->categoryid; break; case 'course': $eventparams['other']['courseid'] = $sub->courseid; break; case 'group': $eventparams['other']['courseid'] = $sub->courseid; $eventparams['other']['groupid'] = $sub->groupid; break; default: $eventparams['other']['courseid'] = $sub->courseid; } $event = \core\event\calendar_subscription_created::create($eventparams); $event->trigger(); return $id; } else { // Why are we doing an update here? calendar_update_subscription($sub); return $sub->id; } } else { throw new \moodle_exception('errorbadsubscription', 'importcalendar'); } } /** * Add an iCalendar event to the Moodle calendar. * * @param stdClass $event The RFC-2445 iCalendar event * @param int $unused Deprecated * @param int $subscriptionid The iCalendar subscription ID * @param string $timezone The X-WR-TIMEZONE iCalendar property if provided * @throws dml_exception A DML specific exception is thrown for invalid subscriptionids. * @return int Code: CALENDAR_IMPORT_EVENT_UPDATED = updated, CALENDAR_IMPORT_EVENT_INSERTED = inserted, 0 = error */ function calendar_add_icalendar_event($event, $unused, $subscriptionid, $timezone='UTC') { global $DB; // Probably an unsupported X-MICROSOFT-CDO-BUSYSTATUS event. if (empty($event->properties['SUMMARY'])) { return 0; } $name = $event->properties['SUMMARY'][0]->value; $name = str_replace('\n', '
', $name); $name = str_replace('\\', '', $name); $name = preg_replace('/\s+/u', ' ', $name); $eventrecord = new \stdClass; $eventrecord->name = clean_param($name, PARAM_NOTAGS); if (empty($event->properties['DESCRIPTION'][0]->value)) { $description = ''; } else { $description = $event->properties['DESCRIPTION'][0]->value; $description = clean_param($description, PARAM_NOTAGS); $description = str_replace('\n', '
', $description); $description = str_replace('\\', '', $description); $description = preg_replace('/\s+/u', ' ', $description); } $eventrecord->description = $description; // Probably a repeating event with RRULE etc. TODO: skip for now. if (empty($event->properties['DTSTART'][0]->value)) { return 0; } if (isset($event->properties['DTSTART'][0]->parameters['TZID'])) { $tz = $event->properties['DTSTART'][0]->parameters['TZID']; } else { $tz = $timezone; } $tz = \core_date::normalise_timezone($tz); $eventrecord->timestart = strtotime($event->properties['DTSTART'][0]->value . ' ' . $tz); if (empty($event->properties['DTEND'])) { $eventrecord->timeduration = 0; // No duration if no end time specified. } else { if (isset($event->properties['DTEND'][0]->parameters['TZID'])) { $endtz = $event->properties['DTEND'][0]->parameters['TZID']; } else { $endtz = $timezone; } $endtz = \core_date::normalise_timezone($endtz); $eventrecord->timeduration = strtotime($event->properties['DTEND'][0]->value . ' ' . $endtz) - $eventrecord->timestart; } // Check to see if it should be treated as an all day event. if ($eventrecord->timeduration == DAYSECS) { // Check to see if the event started at Midnight on the imported calendar. date_default_timezone_set($timezone); if (date('H:i:s', $eventrecord->timestart) === "00:00:00") { // This event should be an all day event. This is not correct, we don't do anything differently for all day events. // See MDL-56227. $eventrecord->timeduration = 0; } \core_date::set_default_server_timezone(); } $eventrecord->location = empty($event->properties['LOCATION'][0]->value) ? '' : trim(str_replace('\\', '', $event->properties['LOCATION'][0]->value)); $eventrecord->uuid = $event->properties['UID'][0]->value; $eventrecord->timemodified = time(); // Add the iCal subscription details if required. // We should never do anything with an event without a subscription reference. $sub = calendar_get_subscription($subscriptionid); $eventrecord->subscriptionid = $subscriptionid; $eventrecord->userid = $sub->userid; $eventrecord->groupid = $sub->groupid; $eventrecord->courseid = $sub->courseid; $eventrecord->categoryid = $sub->categoryid; $eventrecord->eventtype = $sub->eventtype; if ($updaterecord = $DB->get_record('event', array('uuid' => $eventrecord->uuid, 'subscriptionid' => $eventrecord->subscriptionid))) { // Compare iCal event data against the moodle event to see if something has changed. $result = array_diff((array) $eventrecord, (array) $updaterecord); // Unset timemodified field because it's always going to be different. unset($result['timemodified']); if (count($result)) { $eventrecord->id = $updaterecord->id; $return = CALENDAR_IMPORT_EVENT_UPDATED; // Update. } else { return CALENDAR_IMPORT_EVENT_SKIPPED; } } else { $return = CALENDAR_IMPORT_EVENT_INSERTED; // Insert. } if ($createdevent = \calendar_event::create($eventrecord, false)) { if (!empty($event->properties['RRULE'])) { // Repeating events. date_default_timezone_set($tz); // Change time zone to parse all events. $rrule = new \core_calendar\rrule_manager($event->properties['RRULE'][0]->value); $rrule->parse_rrule(); $rrule->create_events($createdevent); \core_date::set_default_server_timezone(); // Change time zone back to what it was. } return $return; } else { return 0; } } /** * Delete subscription and all related events. * * @param int|stdClass $subscription subscription or it's id, which needs to be deleted. */ function calendar_delete_subscription($subscription) { global $DB; if (!is_object($subscription)) { $subscription = $DB->get_record('event_subscriptions', array('id' => $subscription), '*', MUST_EXIST); } // Delete subscription and related events. $DB->delete_records('event', array('subscriptionid' => $subscription->id)); $DB->delete_records('event_subscriptions', array('id' => $subscription->id)); \cache_helper::invalidate_by_definition('core', 'calendar_subscriptions', array(), array($subscription->id)); // Trigger event, calendar subscription deleted. $eventparams = array('objectid' => $subscription->id, 'context' => calendar_get_calendar_context($subscription), 'other' => array( 'eventtype' => $subscription->eventtype, ) ); switch ($subscription->eventtype) { case 'category': $eventparams['other']['categoryid'] = $subscription->categoryid; break; case 'course': $eventparams['other']['courseid'] = $subscription->courseid; break; case 'group': $eventparams['other']['courseid'] = $subscription->courseid; $eventparams['other']['groupid'] = $subscription->groupid; break; default: $eventparams['other']['courseid'] = $subscription->courseid; } $event = \core\event\calendar_subscription_deleted::create($eventparams); $event->trigger(); } /** * From a URL, fetch the calendar and return an iCalendar object. * * @param string $url The iCalendar URL * @return iCalendar The iCalendar object */ function calendar_get_icalendar($url) { global $CFG; require_once($CFG->libdir . '/filelib.php'); require_once($CFG->libdir . '/bennu/bennu.inc.php'); $curl = new \curl(); $curl->setopt(array('CURLOPT_FOLLOWLOCATION' => 1, 'CURLOPT_MAXREDIRS' => 5)); $calendar = $curl->get($url); // Http code validation should actually be the job of curl class. if (!$calendar || $curl->info['http_code'] != 200 || !empty($curl->errorno)) { throw new \moodle_exception('errorinvalidicalurl', 'calendar'); } $ical = new \iCalendar(); $ical->unserialize($calendar); return $ical; } /** * Import events from an iCalendar object into a course calendar. * * @param iCalendar $ical The iCalendar object. * @param int|null $subscriptionid The subscription ID. * @return array A log of the import progress, including errors. */ function calendar_import_events_from_ical(iCalendar $ical, ?int $subscriptionid = null): array { global $DB; $errors = []; $eventcount = 0; $updatecount = 0; $skippedcount = 0; $deletedcount = 0; // Large calendars take a while... if (!CLI_SCRIPT) { \core_php_time_limit::raise(300); } // Start with a safe default timezone. $timezone = 'UTC'; // Grab the timezone from the iCalendar file to be used later. if (isset($ical->properties['X-WR-TIMEZONE'][0]->value)) { $timezone = $ical->properties['X-WR-TIMEZONE'][0]->value; } else if (isset($ical->properties['PRODID'][0]->value)) { // If the timezone was not found, check to se if this is MS exchange / Office 365 which uses Windows timezones. if (strncmp($ical->properties['PRODID'][0]->value, 'Microsoft', 9) == 0) { if (isset($ical->components['VTIMEZONE'][0]->properties['TZID'][0]->value)) { $tzname = $ical->components['VTIMEZONE'][0]->properties['TZID'][0]->value; $timezone = IntlTimeZone::getIDForWindowsID($tzname); } } } $icaluuids = []; foreach ($ical->components['VEVENT'] as $event) { $icaluuids[] = $event->properties['UID'][0]->value; $res = calendar_add_icalendar_event($event, null, $subscriptionid, $timezone); switch ($res) { case CALENDAR_IMPORT_EVENT_UPDATED: $updatecount++; break; case CALENDAR_IMPORT_EVENT_INSERTED: $eventcount++; break; case CALENDAR_IMPORT_EVENT_SKIPPED: $skippedcount++; break; case 0: if (empty($event->properties['SUMMARY'])) { $errors[] = '(' . get_string('notitle', 'calendar') . ')'; } else { $errors[] = $event->properties['SUMMARY'][0]->value; } break; } } $existing = $DB->get_field('event_subscriptions', 'lastupdated', ['id' => $subscriptionid]); if (!empty($existing)) { $eventsuuids = $DB->get_records_menu('event', ['subscriptionid' => $subscriptionid], '', 'id, uuid'); $icaleventscount = count($icaluuids); $tobedeleted = []; if (count($eventsuuids) > $icaleventscount) { foreach ($eventsuuids as $eventid => $eventuuid) { if (!in_array($eventuuid, $icaluuids)) { $tobedeleted[] = $eventid; } } if (!empty($tobedeleted)) { $DB->delete_records_list('event', 'id', $tobedeleted); $deletedcount = count($tobedeleted); } } } $result = [ 'eventsimported' => $eventcount, 'eventsskipped' => $skippedcount, 'eventsupdated' => $updatecount, 'eventsdeleted' => $deletedcount, 'haserror' => !empty($errors), 'errors' => $errors, ]; return $result; } /** * Fetch a calendar subscription and update the events in the calendar. * * @param int $subscriptionid The course ID for the calendar. * @return array A log of the import progress, including errors. */ function calendar_update_subscription_events($subscriptionid) { $sub = calendar_get_subscription($subscriptionid); // Don't update a file subscription. if (empty($sub->url)) { return 'File subscription not updated.'; } $ical = calendar_get_icalendar($sub->url); $return = calendar_import_events_from_ical($ical, $subscriptionid); $sub->lastupdated = time(); calendar_update_subscription($sub); return $return; } /** * Update a calendar subscription. Also updates the associated cache. * * @param stdClass|array $subscription Subscription record. * @throws coding_exception If something goes wrong * @since Moodle 2.5 */ function calendar_update_subscription($subscription) { global $DB; if (is_array($subscription)) { $subscription = (object)$subscription; } if (empty($subscription->id) || !$DB->record_exists('event_subscriptions', array('id' => $subscription->id))) { throw new \coding_exception('Cannot update a subscription without a valid id'); } $DB->update_record('event_subscriptions', $subscription); // Update cache. $cache = \cache::make('core', 'calendar_subscriptions'); $cache->set($subscription->id, $subscription); // Trigger event, calendar subscription updated. $eventparams = array('userid' => $subscription->userid, 'objectid' => $subscription->id, 'context' => calendar_get_calendar_context($subscription), 'other' => array( 'eventtype' => $subscription->eventtype, ) ); switch ($subscription->eventtype) { case 'category': $eventparams['other']['categoryid'] = $subscription->categoryid; break; case 'course': $eventparams['other']['courseid'] = $subscription->courseid; break; case 'group': $eventparams['other']['courseid'] = $subscription->courseid; $eventparams['other']['groupid'] = $subscription->groupid; break; default: $eventparams['other']['courseid'] = $subscription->courseid; } $event = \core\event\calendar_subscription_updated::create($eventparams); $event->trigger(); } /** * Checks to see if the user can edit a given subscription feed. * * @param mixed $subscriptionorid Subscription object or id * @return bool true if current user can edit the subscription else false */ function calendar_can_edit_subscription($subscriptionorid) { global $USER; if (is_array($subscriptionorid)) { $subscription = (object)$subscriptionorid; } else if (is_object($subscriptionorid)) { $subscription = $subscriptionorid; } else { $subscription = calendar_get_subscription($subscriptionorid); } $allowed = new \stdClass; $courseid = $subscription->courseid; $categoryid = $subscription->categoryid; $groupid = $subscription->groupid; $category = null; if (!empty($categoryid)) { $category = \core_course_category::get($categoryid); } calendar_get_allowed_types($allowed, $courseid, null, $category); switch ($subscription->eventtype) { case 'user': return ($USER->id == $subscription->userid && $allowed->user); case 'course': if (isset($allowed->courses[$courseid])) { return $allowed->courses[$courseid]; } else { return false; } case 'category': if (isset($allowed->categories[$categoryid])) { return $allowed->categories[$categoryid]; } else { return false; } case 'site': return $allowed->site; case 'group': if (isset($allowed->groups[$groupid])) { return $allowed->groups[$groupid]; } else { return false; } default: return false; } } /** * Helper function to determine the context of a calendar subscription. * Subscriptions can be created in two contexts COURSE, or USER. * * @param stdClass $subscription * @return context instance */ function calendar_get_calendar_context($subscription) { // Determine context based on calendar type. if ($subscription->eventtype === 'site') { $context = \context_course::instance(SITEID); } else if ($subscription->eventtype === 'group' || $subscription->eventtype === 'course') { $context = \context_course::instance($subscription->courseid); } else { $context = \context_user::instance($subscription->userid); } return $context; } /** * Implements callback user_preferences, lists preferences that users are allowed to update directly * * Used in {@see core_user::fill_preferences_cache()}, see also {@see useredit_update_user_preference()} * * @return array */ function core_calendar_user_preferences() { $preferences = []; $preferences['calendar_timeformat'] = array('type' => PARAM_NOTAGS, 'null' => NULL_NOT_ALLOWED, 'default' => '0', 'choices' => array('0', CALENDAR_TF_12, CALENDAR_TF_24) ); $preferences['calendar_startwday'] = array('type' => PARAM_INT, 'null' => NULL_NOT_ALLOWED, 'default' => 0, 'choices' => array(0, 1, 2, 3, 4, 5, 6)); $preferences['calendar_maxevents'] = array('type' => PARAM_INT, 'choices' => range(1, 20)); $preferences['calendar_lookahead'] = array('type' => PARAM_INT, 'null' => NULL_NOT_ALLOWED, 'default' => 365, 'choices' => array(365, 270, 180, 150, 120, 90, 60, 30, 21, 14, 7, 6, 5, 4, 3, 2, 1)); $preferences['calendar_persistflt'] = array('type' => PARAM_INT, 'null' => NULL_NOT_ALLOWED, 'default' => 0, 'choices' => array(0, 1)); return $preferences; } /** * Get legacy calendar events * * @param int $tstart Start time of time range for events * @param int $tend End time of time range for events * @param array|int|boolean $users array of users, user id or boolean for all/no user events * @param array|int|boolean $groups array of groups, group id or boolean for all/no group events * @param array|int|boolean $courses array of courses, course id or boolean for all/no course events * @param boolean $withduration whether only events starting within time range selected * or events in progress/already started selected as well * @param boolean $ignorehidden whether to select only visible events or all events * @param array $categories array of category ids and/or objects. * @param int $limitnum Number of events to fetch or zero to fetch all. * * @return array $events of selected events or an empty array if there aren't any (or there was an error) */ function calendar_get_legacy_events($tstart, $tend, $users, $groups, $courses, $withduration = true, $ignorehidden = true, $categories = [], $limitnum = 0) { // Normalise the users, groups and courses parameters so that they are compliant with \core_calendar\local\api::get_events(). // Existing functions that were using the old calendar_get_events() were passing a mixture of array, int, boolean for these // parameters, but with the new API method, only null and arrays are accepted. list($userparam, $groupparam, $courseparam, $categoryparam) = array_map(function($param) { // If parameter is true, return null. if ($param === true) { return null; } // If parameter is false, return an empty array. if ($param === false) { return []; } // If the parameter is a scalar value, enclose it in an array. if (!is_array($param)) { return [$param]; } // No normalisation required. return $param; }, [$users, $groups, $courses, $categories]); // If a single user is provided, we can use that for capability checks. // Otherwise current logged in user is used - See MDL-58768. if (is_array($userparam) && count($userparam) == 1) { \core_calendar\local\event\container::set_requesting_user($userparam[0]); } $mapper = \core_calendar\local\event\container::get_event_mapper(); $events = \core_calendar\local\api::get_events( $tstart, $tend, null, null, null, null, $limitnum, null, $userparam, $groupparam, $courseparam, $categoryparam, $withduration, $ignorehidden ); return array_reduce($events, function($carry, $event) use ($mapper) { return $carry + [$event->get_id() => $mapper->from_event_to_stdclass($event)]; }, []); } /** * Get the calendar view output. * * @param \calendar_information $calendar The calendar being represented * @param string $view The type of calendar to have displayed * @param bool $includenavigation Whether to include navigation * @param bool $skipevents Whether to load the events or not * @param int $lookahead Overwrites site and users's lookahead setting. * @return array[array, string] */ function calendar_get_view(\calendar_information $calendar, $view, $includenavigation = true, bool $skipevents = false, ?int $lookahead = null) { global $PAGE, $CFG; $renderer = $PAGE->get_renderer('core_calendar'); $type = \core_calendar\type_factory::get_calendar_instance(); // Calculate the bounds of the month. $calendardate = $type->timestamp_to_date_array($calendar->time); $date = new \DateTime('now', core_date::get_user_timezone_object(99)); $eventlimit = 0; if ($view === 'day') { $tstart = $type->convert_to_timestamp($calendardate['year'], $calendardate['mon'], $calendardate['mday']); $date->setTimestamp($tstart); $date->modify('+1 day'); } else if ($view === 'upcoming' || $view === 'upcoming_mini') { // Number of days in the future that will be used to fetch events. if (!$lookahead) { if (isset($CFG->calendar_lookahead)) { $defaultlookahead = intval($CFG->calendar_lookahead); } else { $defaultlookahead = CALENDAR_DEFAULT_UPCOMING_LOOKAHEAD; } $lookahead = get_user_preferences('calendar_lookahead', $defaultlookahead); } // Maximum number of events to be displayed on upcoming view. $defaultmaxevents = CALENDAR_DEFAULT_UPCOMING_MAXEVENTS; if (isset($CFG->calendar_maxevents)) { $defaultmaxevents = intval($CFG->calendar_maxevents); } $eventlimit = get_user_preferences('calendar_maxevents', $defaultmaxevents); $tstart = $type->convert_to_timestamp($calendardate['year'], $calendardate['mon'], $calendardate['mday'], $calendardate['hours']); $date->setTimestamp($tstart); $date->modify('+' . $lookahead . ' days'); } else { $tstart = $type->convert_to_timestamp($calendardate['year'], $calendardate['mon'], 1); $monthdays = $type->get_num_days_in_month($calendardate['year'], $calendardate['mon']); $date->setTimestamp($tstart); $date->modify('+' . $monthdays . ' days'); if ($view === 'mini' || $view === 'minithree') { $template = 'core_calendar/calendar_mini'; } else { $template = 'core_calendar/calendar_month'; } } // We need to extract 1 second to ensure that we don't get into the next day. $date->modify('-1 second'); $tend = $date->getTimestamp(); list($userparam, $groupparam, $courseparam, $categoryparam) = array_map(function($param) { // If parameter is true, return null. if ($param === true) { return null; } // If parameter is false, return an empty array. if ($param === false) { return []; } // If the parameter is a scalar value, enclose it in an array. if (!is_array($param)) { return [$param]; } // No normalisation required. return $param; }, [$calendar->users, $calendar->groups, $calendar->courses, $calendar->categories]); if ($skipevents) { $events = []; } else { $events = \core_calendar\local\api::get_events( $tstart, $tend, null, null, null, null, $eventlimit, null, $userparam, $groupparam, $courseparam, $categoryparam, true, true, function ($event) { if ($proxy = $event->get_course_module()) { $cminfo = $proxy->get_proxied_instance(); return $cminfo->uservisible; } if ($proxy = $event->get_category()) { $category = $proxy->get_proxied_instance(); return $category->is_uservisible(); } return true; } ); } $related = [ 'events' => $events, 'cache' => new \core_calendar\external\events_related_objects_cache($events), 'type' => $type, ]; $data = []; $calendar->set_viewmode($view); if ($view == "month" || $view == "monthblock" || $view == "mini" || $view == "minithree" ) { $month = new \core_calendar\external\month_exporter($calendar, $type, $related); $month->set_includenavigation($includenavigation); $month->set_initialeventsloaded(!$skipevents); $month->set_showcoursefilter(($view == "month" || $view == "monthblock")); $data = $month->export($renderer); } else if ($view == "day") { $day = new \core_calendar\external\calendar_day_exporter($calendar, $related); $data = $day->export($renderer); $data->viewingday = true; $data->showviewselector = true; $template = 'core_calendar/calendar_day'; } else if ($view == "upcoming" || $view == "upcoming_mini") { $upcoming = new \core_calendar\external\calendar_upcoming_exporter($calendar, $related); $data = $upcoming->export($renderer); if ($view == "upcoming") { $template = 'core_calendar/calendar_upcoming'; $data->viewingupcoming = true; $data->showviewselector = true; } else if ($view == "upcoming_mini") { $template = 'core_calendar/calendar_upcoming_mini'; } } // Check if $data has events. if (isset($data->events)) { // Let's check and sanitize all "name" in $data->events before it's sent to front end. foreach ($data->events as $d) { $name = $d->name ?? null; // Encode special characters if our decoded name does not match the original name. if ($name && (html_entity_decode($name) !== $name)) { $d->name = htmlspecialchars(html_entity_decode($name), ENT_QUOTES, 'utf-8'); } } } return [$data, $template]; } /** * Request and render event form fragment. * * @param array $args The fragment arguments. * @return string The rendered mform fragment. */ function calendar_output_fragment_event_form($args) { global $CFG, $OUTPUT, $USER; require_once($CFG->libdir . '/grouplib.php'); $html = ''; $data = []; $eventid = isset($args['eventid']) ? clean_param($args['eventid'], PARAM_INT) : null; $starttime = isset($args['starttime']) ? clean_param($args['starttime'], PARAM_INT) : null; $courseid = (isset($args['courseid']) && $args['courseid'] != SITEID) ? clean_param($args['courseid'], PARAM_INT) : null; $categoryid = isset($args['categoryid']) ? clean_param($args['categoryid'], PARAM_INT) : null; $event = null; $hasformdata = isset($args['formdata']) && !empty($args['formdata']); $context = \context_user::instance($USER->id); $editoroptions = \core_calendar\local\event\forms\create::build_editor_options($context); $formoptions = ['editoroptions' => $editoroptions, 'courseid' => $courseid]; $draftitemid = 0; if ($hasformdata) { parse_str(clean_param($args['formdata'], PARAM_TEXT), $data); if (isset($data['description']['itemid'])) { $draftitemid = $data['description']['itemid']; } } if ($starttime) { $formoptions['starttime'] = $starttime; } // Let's check first which event types user can add. $eventtypes = calendar_get_allowed_event_types($courseid); $formoptions['eventtypes'] = $eventtypes; if (is_null($eventid)) { if (!empty($courseid)) { $groupcoursedata = groups_get_all_groups($courseid); $formoptions['groups'] = []; foreach ($groupcoursedata as $groupid => $groupdata) { $formoptions['groups'][$groupid] = format_string($groupdata->name, true, ['context' => $context]); } } $mform = new \core_calendar\local\event\forms\create( null, $formoptions, 'post', '', null, true, $data ); // If the user is on course context and is allowed to add course events set the event type default to course. if (!empty($courseid) && !empty($eventtypes['course'])) { $data['eventtype'] = 'course'; $data['courseid'] = $courseid; $data['groupcourseid'] = $courseid; } else if (!empty($categoryid) && !empty($eventtypes['category'])) { $data['eventtype'] = 'category'; $data['categoryid'] = $categoryid; } else if (!empty($groupcoursedata) && !empty($eventtypes['group'])) { $data['groupcourseid'] = $courseid; $data['groups'] = $groupcoursedata->groups; } $mform->set_data($data); } else { $event = calendar_event::load($eventid); if (!calendar_edit_event_allowed($event)) { throw new \moodle_exception('nopermissiontoupdatecalendar'); } $mapper = new \core_calendar\local\event\mappers\create_update_form_mapper(); $eventdata = $mapper->from_legacy_event_to_data($event); $data = array_merge((array) $eventdata, $data); $event->count_repeats(); $formoptions['event'] = $event; if (!empty($event->courseid)) { $groupcoursedata = groups_get_all_groups($event->courseid); $formoptions['groups'] = []; foreach ($groupcoursedata as $groupid => $groupdata) { $formoptions['groups'][$groupid] = format_string($groupdata->name, true, ['context' => $context]); } } $data['description']['text'] = file_prepare_draft_area( $draftitemid, $event->context->id, 'calendar', 'event_description', $event->id, null, $data['description']['text'] ); $data['description']['itemid'] = $draftitemid; $mform = new \core_calendar\local\event\forms\update( null, $formoptions, 'post', '', null, true, $data ); $mform->set_data($data); // Check to see if this event is part of a subscription or import. // If so display a warning on edit. if (isset($event->subscriptionid) && ($event->subscriptionid != null)) { $renderable = new \core\output\notification( get_string('eventsubscriptioneditwarning', 'calendar'), \core\output\notification::NOTIFY_INFO ); $html .= $OUTPUT->render($renderable); } } if ($hasformdata) { $mform->is_validated(); } $html .= $mform->render(); return $html; } /** * Calculate the timestamp from the supplied Gregorian Year, Month, and Day. * * @param int $d The day * @param int $m The month * @param int $y The year * @param int $time The timestamp to use instead of a separate y/m/d. * @return int The timestamp */ function calendar_get_timestamp($d, $m, $y, $time = 0) { // If a day, month and year were passed then convert it to a timestamp. If these were passed // then we can assume the day, month and year are passed as Gregorian, as no where in core // should we be passing these values rather than the time. if (!empty($d) && !empty($m) && !empty($y)) { if (checkdate($m, $d, $y)) { $time = make_timestamp($y, $m, $d); } else { $time = time(); } } else if (empty($time)) { $time = time(); } return $time; } /** * Get the calendar footer options. * * @param calendar_information $calendar The calendar information object. * @param array $options Display options for the footer. If an option is not set, a default value will be provided. * It consists of: * - showfullcalendarlink - bool - Whether to show the full calendar link or not. Defaults to false. * * @return array The data for template and template name. */ function calendar_get_footer_options($calendar, array $options = []) { global $CFG, $USER, $PAGE; // Generate hash for iCal link. $authtoken = calendar_get_export_token($USER); $renderer = $PAGE->get_renderer('core_calendar'); $footer = new \core_calendar\external\footer_options_exporter($calendar, $USER->id, $authtoken, $options); $data = $footer->export($renderer); $template = 'core_calendar/footer_options'; return [$data, $template]; } /** * Get the list of potential calendar filter types as a type => name * combination. * * @return array */ function calendar_get_filter_types() { $types = [ 'site', 'category', 'course', 'group', 'user', 'other' ]; return array_map(function($type) { return [ 'eventtype' => $type, 'name' => get_string("eventtype{$type}", "calendar"), 'icon' => true, 'key' => 'i/' . $type . 'event', 'component' => 'core' ]; }, $types); } /** * Check whether the specified event type is valid. * * @param string $type * @return bool */ function calendar_is_valid_eventtype($type) { $validtypes = [ 'user', 'group', 'course', 'category', 'site', ]; return in_array($type, $validtypes); } /** * Get event types the user can create event based on categories, courses and groups * the logged in user belongs to. * * @param int|null $courseid The course id. * @return array The array of allowed types. */ function calendar_get_allowed_event_types(?int $courseid = null) { global $DB, $CFG, $USER; $types = [ 'user' => false, 'site' => false, 'course' => false, 'group' => false, 'category' => false ]; if (!empty($courseid) && $courseid != SITEID) { $context = \context_course::instance($courseid); $types['user'] = has_capability('moodle/calendar:manageownentries', $context); calendar_internal_update_course_and_group_permission($courseid, $context, $types); } if (has_capability('moodle/calendar:manageentries', \context_course::instance(SITEID))) { $types['site'] = true; } if (has_capability('moodle/calendar:manageownentries', \context_system::instance())) { $types['user'] = true; } if (core_course_category::has_manage_capability_on_any()) { $types['category'] = true; } // We still don't know if the user can create group and course events, so iterate over the courses to find out // if the user has capabilities in one of the courses. if ($types['course'] == false || $types['group'] == false) { if ($CFG->calendar_adminseesall && has_capability('moodle/calendar:manageentries', context_system::instance())) { $sql = "SELECT c.id, " . context_helper::get_preload_record_columns_sql('ctx') . " FROM {course} c JOIN {context} ctx ON ctx.contextlevel = ? AND ctx.instanceid = c.id WHERE c.id IN ( SELECT DISTINCT courseid FROM {groups} )"; $courseswithgroups = $DB->get_recordset_sql($sql, [CONTEXT_COURSE]); foreach ($courseswithgroups as $course) { context_helper::preload_from_record($course); $context = context_course::instance($course->id); if (has_capability('moodle/calendar:manageentries', $context)) { if (has_any_capability(['moodle/site:accessallgroups', 'moodle/calendar:managegroupentries'], $context)) { // The user can manage group entries or access any group. $types['group'] = true; $types['course'] = true; break; } } } $courseswithgroups->close(); if (false === $types['course']) { // Course is still not confirmed. There may have been no courses with a group in them. $ctxfields = context_helper::get_preload_record_columns_sql('ctx'); $sql = "SELECT c.id, c.visible, {$ctxfields} FROM {course} c JOIN {context} ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel)"; $params = [ 'contextlevel' => CONTEXT_COURSE, ]; $courses = $DB->get_recordset_sql($sql, $params); foreach ($courses as $course) { context_helper::preload_from_record($course); $context = context_course::instance($course->id); if (has_capability('moodle/calendar:manageentries', $context)) { $types['course'] = true; break; } } $courses->close(); } } else { $courses = calendar_get_default_courses(null, 'id'); if (empty($courses)) { return $types; } $courseids = array_map(function($c) { return $c->id; }, $courses); // Check whether the user has access to create events within courses which have groups. list($insql, $params) = $DB->get_in_or_equal($courseids, SQL_PARAMS_NAMED); $sql = "SELECT c.id, " . context_helper::get_preload_record_columns_sql('ctx') . " FROM {course} c JOIN {context} ctx ON ctx.contextlevel = :contextlevel AND ctx.instanceid = c.id WHERE c.id $insql AND c.id IN (SELECT DISTINCT courseid FROM {groups})"; $params['contextlevel'] = CONTEXT_COURSE; $courseswithgroups = $DB->get_recordset_sql($sql, $params); foreach ($courseswithgroups as $coursewithgroup) { context_helper::preload_from_record($coursewithgroup); $context = context_course::instance($coursewithgroup->id); calendar_internal_update_course_and_group_permission($coursewithgroup->id, $context, $types); // Okay, course and group event types are allowed, no need to keep the loop iteration. if ($types['course'] == true && $types['group'] == true) { break; } } $courseswithgroups->close(); if (false === $types['course']) { list($insql, $params) = $DB->get_in_or_equal($courseids, SQL_PARAMS_NAMED); $contextsql = "SELECT c.id, " . context_helper::get_preload_record_columns_sql('ctx') . " FROM {course} c JOIN {context} ctx ON ctx.contextlevel = :contextlevel AND ctx.instanceid = c.id WHERE c.id $insql"; $params['contextlevel'] = CONTEXT_COURSE; $contextrecords = $DB->get_recordset_sql($contextsql, $params); foreach ($contextrecords as $course) { context_helper::preload_from_record($course); $coursecontext = context_course::instance($course->id); if (has_capability('moodle/calendar:manageentries', $coursecontext) && ($courseid == $course->id || empty($courseid))) { $types['course'] = true; break; } } $contextrecords->close(); } } } return $types; } /** * Given a course id, and context, updates the permission types array to add the 'course' or 'group' * permission if it is relevant for that course. * * For efficiency, if they already have 'course' or 'group' then it skips checks. * * Do not call this function directly, it is only for use by calendar_get_allowed_event_types(). * * @param int $courseid Course id * @param context $context Context for that course * @param array $types Current permissions */ function calendar_internal_update_course_and_group_permission(int $courseid, context $context, array &$types) { if (!$types['course']) { // If they have manageentries permission on the course, then they can update this course. if (has_capability('moodle/calendar:manageentries', $context)) { $types['course'] = true; } } // To update group events they must have EITHER manageentries OR managegroupentries. if (!$types['group'] && (has_capability('moodle/calendar:manageentries', $context) || has_capability('moodle/calendar:managegroupentries', $context))) { // And they also need for a group to exist on the course. $groups = groups_get_all_groups($courseid); if (!empty($groups)) { // And either accessallgroups, or belong to one of the groups. if (has_capability('moodle/site:accessallgroups', $context)) { $types['group'] = true; } else { foreach ($groups as $group) { if (groups_is_member($group->id)) { $types['group'] = true; break; } } } } } } /** * Get the auth token for exporting the given user calendar. * @param stdClass $user The user to export the calendar for * * @return string The export token. */ function calendar_get_export_token(stdClass $user): string { global $CFG, $DB; return sha1($user->id . $DB->get_field('user', 'password', ['id' => $user->id]) . $CFG->calendar_exportsalt); } /** * Get the list of URL parameters for calendar expport and import links. * * @return array */ function calendar_get_export_import_link_params(): array { global $PAGE; $params = []; if ($courseid = $PAGE->url->get_param('course')) { $params['course'] = $courseid; } if ($categoryid = $PAGE->url->get_param('category')) { $params['category'] = $categoryid; } return $params; } /** * Implements the inplace editable feature. * * @param string $itemtype Type of the inplace editable element * @param int $itemid Id of the item to edit * @param int $newvalue New value of the item * @return \core\output\inplace_editable */ function calendar_inplace_editable(string $itemtype, int $itemid, int $newvalue): \core\output\inplace_editable { global $OUTPUT; if ($itemtype === 'refreshinterval') { $subscription = calendar_get_subscription($itemid); $context = calendar_get_calendar_context($subscription); external_api::validate_context($context); $updateresult = \core_calendar\output\refreshintervalcollection::update($itemid, $newvalue); $refreshresults = calendar_update_subscription_events($itemid); \core\notification::add($OUTPUT->render_from_template( 'core_calendar/subscription_update_result', array_merge($refreshresults, [ 'subscriptionname' => s($subscription->name), ]) ), \core\notification::INFO); return $updateresult; } external_api::validate_context(context_system::instance()); }