php - 试图在moodle中获取特定部门的特定课程日志

Question

我正在尝试按部门明智地获取moodle课程的日志。Moodle 在日志报告中显示所有课程，这很难理解，因为我有多个部门。我想按层次结构获取日志。

这是用于获取课程列表的查询moodle

public function get_course_list() {
    global $DB, $SITE;

    $courses = array();

    $sitecontext = context_system::instance();
    // First check to see if we can override showcourses and showusers.
    $numcourses = $DB->count_records("course");
    if ($numcourses < COURSE_MAX_COURSES_PER_DROPDOWN && !$this->showcourses) {
        $this->showcourses = 1;
    }

    // Check if course filter should be shown.
    if (has_capability('report/log:view', $sitecontext) && $this->showcourses) {
        if ($courserecords = $DB->get_records("course", null, "fullname", "id,shortname,fullname,category")) {
            foreach ($courserecords as $course) {
                if ($course->id == SITEID) {
                    $courses[$course->id] = format_string($course->fullname) . ' (' . get_string('site') . ')';
                } else {
                    $courses[$course->id] = format_string(get_course_display_name_for_list($course));
                }
            }
        }
        core_collator::asort($courses);
    }
    return $courses;
}

标签： phpsql