Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle.  If not, see <http://www.gnu.org/licenses/>.


/**
 * 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');

< $params = array('category' => $this->category->id, 'contextlevel' => CONTEXT_COURSE); < $sql = 'c.category = :category';
> // 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]; foreach ($hiddencats as $category) { > $catcontext = context_coursecat::instance($category->id); > if (empty($hiddencats)) { $sql .= ' OR ' . $DB->sql_like('ctx.path', ':path' . $category->id); > return $DB->get_records_sql($sql1, $params); $params['path' . $category->id] = $catcontext->path . '/%'; > } } > > // Second statement uses only context paths. // Let's retrieve only minimum number of fields from course table - > $orcond = [];
< $sql .= ' OR ' . $DB->sql_like('ctx.path', ':path' . $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); >
< // 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'], course_modinfo::$cachedfields); < $fields = 'c.' . join(',c.', $coursefields) . ', ' . < context_helper::get_preload_record_columns_sql('ctx'); < return $DB->get_records_sql('SELECT ' . $fields . ' FROM {course} c < JOIN {context} ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = :contextlevel) < WHERE ('.$sql.') ORDER BY c.sortorder', $params);
> $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); } }