ÿØÿà JFIF    ÿÛ „  ( %"1!%)+...383,7(-.+  -+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â" ÿÄ     ÿÄ H    !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ   ÿÄ %  !1AQa"23‘ÿÚ   ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ ú®ði~TÁbqÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6  öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ "Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãS炟[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt ‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%ºÍãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»& î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ ÷Û #°xŸëí(l »ý3—¥5m! rt`†0~'j2(]S¦¦kv,ÚÇ l¦øJA£Šƒ J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨ÖÚ5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg A2Z"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø ð\á)} ¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±N¢aF¨…8¯!U  Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD é©¤&‡ïDbàÁôMÁ.. /** * Utility class for browsing of curse category files. * * @package core_files * @copyright 2008 Petr Skoda (http://skodak.org) * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ defined('MOODLE_INTERNAL') || die(); /** * Represents a course category context in the tree navigated by {@link file_browser}. * * @package core_files * @copyright 2008 Petr Skoda (http://skodak.org) * @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later */ class file_info_context_coursecat extends file_info { /** @var stdClass Category object */ protected $category; /** * Constructor * * @param file_browser $browser file browser instance * @param stdClass $context context object * @param stdClass $category category object */ public function __construct($browser, $context, $category) { parent::__construct($browser, $context); $this->category = $category; } /** * Return information about this specific context level * * @param string $component component * @param string $filearea file area * @param int $itemid item ID * @param string $filepath file path * @param string $filename file name * @return fileinfo|null */ public function get_file_info($component, $filearea, $itemid, $filepath, $filename) { global $DB; if (!core_course_category::can_view_category($this->category)) { if (empty($component)) { // we can not list the category contents, so try parent, or top system if ($this->category->parent and $pc = $DB->get_record('course_categories', array('id'=>$this->category->parent))) { $parent = context_coursecat::instance($pc->id, IGNORE_MISSING); return $this->browser->get_file_info($parent); } else { return $this->browser->get_file_info(); } } return null; } if (empty($component)) { return $this; } $methodname = "get_area_{$component}_{$filearea}"; if (method_exists($this, $methodname)) { return $this->$methodname($itemid, $filepath, $filename); } return null; } /** * Return a file from course category description area * * @param int $itemid item ID * @param string $filepath file path * @param string $filename file name * @return fileinfo|null */ protected function get_area_coursecat_description($itemid, $filepath, $filename) { global $CFG; if (!$this->category->id) { // No coursecat description area for "system". return null; } if (!core_course_category::can_view_category($this->category)) { return null; } if (!has_capability('moodle/category:manage', $this->context)) { return null; } if (is_null($itemid)) { return $this; } $fs = get_file_storage(); $filepath = is_null($filepath) ? '/' : $filepath; $filename = is_null($filename) ? '.' : $filename; $urlbase = $CFG->wwwroot.'/pluginfile.php'; if (!$storedfile = $fs->get_file($this->context->id, 'coursecat', 'description', 0, $filepath, $filename)) { if ($filepath === '/' and $filename === '.') { $storedfile = new virtual_root_file($this->context->id, 'coursecat', 'description', 0); } else { // not found return null; } } return new file_info_stored($this->browser, $this->context, $storedfile, $urlbase, get_string('areacategoryintro', 'repository'), false, true, true, false); } /** * Returns localised visible name. * * @return string */ public function get_visible_name() { return format_string($this->category->name, true, array('context'=>$this->context)); } /** * Whether or not new files or directories can be added * * @return bool */ public function is_writable() { return false; } /** * Whether or not this is a directory * * @return bool */ public function is_directory() { return true; } /** * Returns list of children. * * @return array of file_info instances */ public function get_children() { $children = array(); if ($child = $this->get_area_coursecat_description(0, '/', '.')) { $children[] = $child; } list($coursecats, $hiddencats) = $this->get_categories(); foreach ($coursecats as $category) { $context = context_coursecat::instance($category->id); $children[] = new self($this->browser, $context, $category); } $courses = $this->get_courses($hiddencats); foreach ($courses as $course) { $children[] = $this->get_child_course($course); } return array_filter($children); } /** * List of courses in this category and in hidden subcategories * * @param array $hiddencats list of categories that are hidden from current user and returned by {@link get_categories()} * @return array list of courses */ protected function get_courses($hiddencats) { global $DB, $CFG; require_once($CFG->libdir.'/modinfolib.php'); // Let's retrieve only minimum number of fields from course table - // what is needed to check access or call get_fast_modinfo(). $coursefields = array_merge(['id', 'visible', 'sortorder'], \course_modinfo::$cachedfields); $fields = 'c.' . join(',c.', $coursefields) . ', ' . \context_helper::get_preload_record_columns_sql('ctx'); // First statement uses only category. $sql1 = "SELECT $fields FROM {course} c JOIN {context} ctx ON (ctx.instanceid = c.id) AND (ctx.contextlevel = :contextlevel1) WHERE c.category = :categoryid"; $params = ['categoryid' => $this->category->id, 'contextlevel1' => CONTEXT_COURSE]; if (empty($hiddencats)) { return $DB->get_records_sql($sql1, $params); } // Second statement uses only context paths. $orcond = []; foreach ($hiddencats as $category) { $catcontext = context_coursecat::instance($category->id); // Case- and accent-sensitive search is not necessary for paths. // If we do without it, this will lead to an enormous performance boost on large scale tables. $orcond[] = $DB->sql_like('path', ':path' . $category->id, false, false); $params['path' . $category->id] = $catcontext->path . '/%'; } $sql2 = "SELECT $fields FROM {course} c JOIN {context} ctx ON (ctx.instanceid = c.id) AND (ctx.contextlevel = :contextlevel2) WHERE (" . implode(' OR ', $orcond) . ")"; $params['contextlevel2'] = CONTEXT_COURSE; // Combine with UNION. $sql = "SELECT * FROM (($sql1) UNION ($sql2)) d ORDER BY d.sortorder"; return $DB->get_records_sql($sql, $params); } /** * Finds accessible and non-accessible direct subcategories * * @return array [$coursecats, $hiddencats] - child categories that are visible to the current user and not visible */ protected function get_categories() { global $DB; $fields = 'c.*, ' . context_helper::get_preload_record_columns_sql('ctx'); $coursecats = $DB->get_records_sql('SELECT ' . $fields . ' FROM {course_categories} c LEFT JOIN {context} ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel) WHERE c.parent = :parent ORDER BY c.sortorder', array('parent' => $this->category->id, 'contextlevel' => CONTEXT_COURSECAT)); $hiddencats = []; foreach ($coursecats as $id => &$category) { context_helper::preload_from_record($category); if (!core_course_category::can_view_category($category)) { $hiddencats[$id] = $coursecats[$id]; unset($coursecats[$id]); } } return [$coursecats, $hiddencats]; } /** * Returns the file info element for a given course or null if course is not accessible * * @param stdClass $course may contain context fields for preloading * @return file_info_context_course|null */ protected function get_child_course($course) { context_helper::preload_from_record($course); $context = context_course::instance($course->id); $child = new file_info_context_course($this->browser, $context, $course); return $child->get_file_info(null, null, null, null, null); } /** * Returns the number of children which are either files matching the specified extensions * or folders containing at least one such file. * * @param string|array $extensions, for example '*' or array('.gif','.jpg') * @param int $limit stop counting after at least $limit non-empty children are found * @return int */ public function count_non_empty_children($extensions = '*', $limit = 1) { $cnt = 0; if ($child = $this->get_area_coursecat_description(0, '/', '.')) { $cnt += $child->count_non_empty_children($extensions) ? 1 : 0; if ($cnt >= $limit) { return $cnt; } } list($coursecats, $hiddencats) = $this->get_categories(); foreach ($coursecats as $category) { $context = context_coursecat::instance($category->id); $child = new file_info_context_coursecat($this->browser, $context, $category); $cnt += $child->count_non_empty_children($extensions) ? 1 : 0; if ($cnt >= $limit) { return $cnt; } } $courses = $this->get_courses($hiddencats); foreach ($courses as $course) { if ($child = $this->get_child_course($course)) { $cnt += $child->count_non_empty_children($extensions) ? 1 : 0; if ($cnt >= $limit) { return $cnt; } } } return $cnt; } /** * Returns parent file_info instance * * @return file_info|null fileinfo instance or null for root directory */ public function get_parent() { $parent = $this->context->get_parent_context(); return $this->browser->get_file_info($parent); } }