You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
980 lines
39 KiB
980 lines
39 KiB
2 years ago
|
<?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/>.
|
||
|
|
||
|
/**
|
||
|
* Course and category management helper class.
|
||
|
*
|
||
|
* @package core_course
|
||
|
* @copyright 2013 Sam Hemelryk
|
||
|
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
|
||
|
*/
|
||
|
|
||
|
namespace core_course\management;
|
||
|
|
||
|
defined('MOODLE_INTERNAL') || die;
|
||
|
|
||
|
/**
|
||
|
* Course and category management interface helper class.
|
||
|
*
|
||
|
* This class provides methods useful to the course and category management interfaces.
|
||
|
* Many of the methods on this class are static and serve one of two purposes.
|
||
|
* 1. encapsulate functionality in an effort to ensure minimal changes between the different
|
||
|
* methods of interaction. Specifically browser, AJAX and webservice.
|
||
|
* 2. abstract logic for acquiring actions away from output so that renderers may use them without
|
||
|
* having to include any logic or capability checks.
|
||
|
*
|
||
|
* @package core_course
|
||
|
* @copyright 2013 Sam Hemelryk
|
||
|
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
|
||
|
*/
|
||
|
class helper {
|
||
|
|
||
|
/**
|
||
|
* The expanded category structure if its already being loaded from the cache.
|
||
|
* @var null|array
|
||
|
*/
|
||
|
protected static $expandedcategories = null;
|
||
|
|
||
|
/**
|
||
|
* Returns course details in an array ready to be printed.
|
||
|
*
|
||
|
* @global \moodle_database $DB
|
||
|
* @param \core_course_list_element $course
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function get_course_detail_array(\core_course_list_element $course) {
|
||
|
global $DB;
|
||
|
|
||
|
$canaccess = $course->can_access();
|
||
|
|
||
|
$format = \course_get_format($course->id);
|
||
|
$modinfo = \get_fast_modinfo($course->id);
|
||
|
$modules = $modinfo->get_used_module_names();
|
||
|
$sections = array();
|
||
|
if ($format->uses_sections()) {
|
||
|
foreach ($modinfo->get_section_info_all() as $section) {
|
||
|
if ($section->uservisible) {
|
||
|
$sections[] = $format->get_section_name($section);
|
||
|
}
|
||
|
}
|
||
|
}
|
||
|
|
||
|
$category = \core_course_category::get($course->category);
|
||
|
$categoryurl = new \moodle_url('/course/management.php', array('categoryid' => $course->category));
|
||
|
$categoryname = $category->get_formatted_name();
|
||
|
|
||
|
$details = array(
|
||
|
'fullname' => array(
|
||
|
'key' => \get_string('fullname'),
|
||
|
'value' => $course->get_formatted_fullname()
|
||
|
),
|
||
|
'shortname' => array(
|
||
|
'key' => \get_string('shortname'),
|
||
|
'value' => $course->get_formatted_shortname()
|
||
|
),
|
||
|
'idnumber' => array(
|
||
|
'key' => \get_string('idnumber'),
|
||
|
'value' => s($course->idnumber)
|
||
|
),
|
||
|
'category' => array(
|
||
|
'key' => \get_string('category'),
|
||
|
'value' => \html_writer::link($categoryurl, $categoryname)
|
||
|
)
|
||
|
);
|
||
|
if (has_capability('moodle/site:accessallgroups', $course->get_context())) {
|
||
|
$groups = \groups_get_course_data($course->id);
|
||
|
$details += array(
|
||
|
'groupings' => array(
|
||
|
'key' => \get_string('groupings', 'group'),
|
||
|
'value' => count($groups->groupings)
|
||
|
),
|
||
|
'groups' => array(
|
||
|
'key' => \get_string('groups'),
|
||
|
'value' => count($groups->groups)
|
||
|
)
|
||
|
);
|
||
|
}
|
||
|
if ($canaccess) {
|
||
|
$names = \role_get_names($course->get_context());
|
||
|
$sql = 'SELECT ra.roleid, COUNT(ra.id) AS rolecount
|
||
|
FROM {role_assignments} ra
|
||
|
WHERE ra.contextid = :contextid
|
||
|
GROUP BY ra.roleid';
|
||
|
$rolecounts = $DB->get_records_sql($sql, array('contextid' => $course->get_context()->id));
|
||
|
$roledetails = array();
|
||
|
foreach ($rolecounts as $result) {
|
||
|
$a = new \stdClass;
|
||
|
$a->role = $names[$result->roleid]->localname;
|
||
|
$a->count = $result->rolecount;
|
||
|
$roledetails[] = \get_string('assignedrolecount', 'moodle', $a);
|
||
|
}
|
||
|
|
||
|
$details['roleassignments'] = array(
|
||
|
'key' => \get_string('roleassignments'),
|
||
|
'value' => join('<br />', $roledetails)
|
||
|
);
|
||
|
}
|
||
|
if ($course->can_review_enrolments()) {
|
||
|
$enrolmentlines = array();
|
||
|
$instances = \enrol_get_instances($course->id, true);
|
||
|
$plugins = \enrol_get_plugins(true);
|
||
|
foreach ($instances as $instance) {
|
||
|
if (!isset($plugins[$instance->enrol])) {
|
||
|
// Weird.
|
||
|
continue;
|
||
|
}
|
||
|
$plugin = $plugins[$instance->enrol];
|
||
|
$enrolmentlines[] = $plugin->get_instance_name($instance);
|
||
|
}
|
||
|
$details['enrolmentmethods'] = array(
|
||
|
'key' => \get_string('enrolmentmethods'),
|
||
|
'value' => join('<br />', $enrolmentlines)
|
||
|
);
|
||
|
}
|
||
|
if ($canaccess) {
|
||
|
$details['format'] = array(
|
||
|
'key' => \get_string('format'),
|
||
|
'value' => \course_get_format($course)->get_format_name()
|
||
|
);
|
||
|
$details['sections'] = array(
|
||
|
'key' => \get_string('sections'),
|
||
|
'value' => join('<br />', $sections)
|
||
|
);
|
||
|
$details['modulesused'] = array(
|
||
|
'key' => \get_string('modulesused'),
|
||
|
'value' => join('<br />', $modules)
|
||
|
);
|
||
|
}
|
||
|
return $details;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns an array of actions that can be performed upon a category being shown in a list.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function get_category_listitem_actions(\core_course_category $category) {
|
||
|
global $CFG;
|
||
|
|
||
|
$manageurl = new \moodle_url('/course/management.php', array('categoryid' => $category->id));
|
||
|
$baseurl = new \moodle_url($manageurl, array('sesskey' => \sesskey()));
|
||
|
$actions = array();
|
||
|
// Edit.
|
||
|
if ($category->can_edit()) {
|
||
|
$actions['edit'] = array(
|
||
|
'url' => new \moodle_url('/course/editcategory.php', array('id' => $category->id)),
|
||
|
'icon' => new \pix_icon('t/edit', new \lang_string('edit')),
|
||
|
'string' => new \lang_string('edit')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Show/Hide.
|
||
|
if ($category->can_change_visibility()) {
|
||
|
// We always show both icons and then just toggle the display of the invalid option with CSS.
|
||
|
$actions['hide'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'hidecategory')),
|
||
|
'icon' => new \pix_icon('t/hide', new \lang_string('hide')),
|
||
|
'string' => new \lang_string('hide')
|
||
|
);
|
||
|
$actions['show'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'showcategory')),
|
||
|
'icon' => new \pix_icon('t/show', new \lang_string('show')),
|
||
|
'string' => new \lang_string('show')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Move up/down.
|
||
|
if ($category->can_change_sortorder()) {
|
||
|
$actions['moveup'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'movecategoryup')),
|
||
|
'icon' => new \pix_icon('t/up', new \lang_string('up')),
|
||
|
'string' => new \lang_string('up')
|
||
|
);
|
||
|
$actions['movedown'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'movecategorydown')),
|
||
|
'icon' => new \pix_icon('t/down', new \lang_string('down')),
|
||
|
'string' => new \lang_string('down')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
if ($category->can_create_subcategory()) {
|
||
|
$actions['createnewsubcategory'] = array(
|
||
|
'url' => new \moodle_url('/course/editcategory.php', array('parent' => $category->id)),
|
||
|
'icon' => new \pix_icon('i/withsubcat', new \lang_string('createnewsubcategory')),
|
||
|
'string' => new \lang_string('createnewsubcategory')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Resort.
|
||
|
if ($category->can_resort_subcategories() && $category->has_children()) {
|
||
|
$actions['resortbyname'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'resortcategories', 'resort' => 'name')),
|
||
|
'icon' => new \pix_icon('t/sort', new \lang_string('sort')),
|
||
|
'string' => new \lang_string('resortsubcategoriesby', 'moodle' , get_string('categoryname'))
|
||
|
);
|
||
|
$actions['resortbynamedesc'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'resortcategories', 'resort' => 'namedesc')),
|
||
|
'icon' => new \pix_icon('t/sort', new \lang_string('sort')),
|
||
|
'string' => new \lang_string('resortsubcategoriesbyreverse', 'moodle', get_string('categoryname'))
|
||
|
);
|
||
|
$actions['resortbyidnumber'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'resortcategories', 'resort' => 'idnumber')),
|
||
|
'icon' => new \pix_icon('t/sort', new \lang_string('sort')),
|
||
|
'string' => new \lang_string('resortsubcategoriesby', 'moodle', get_string('idnumbercoursecategory'))
|
||
|
);
|
||
|
$actions['resortbyidnumberdesc'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'resortcategories', 'resort' => 'idnumberdesc')),
|
||
|
'icon' => new \pix_icon('t/sort', new \lang_string('sort')),
|
||
|
'string' => new \lang_string('resortsubcategoriesbyreverse', 'moodle', get_string('idnumbercoursecategory'))
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Delete.
|
||
|
if ($category->can_delete_full()) {
|
||
|
$actions['delete'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'deletecategory')),
|
||
|
'icon' => new \pix_icon('t/delete', new \lang_string('delete')),
|
||
|
'string' => new \lang_string('delete')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Assign roles.
|
||
|
if ($category->can_review_roles()) {
|
||
|
$actions['assignroles'] = array(
|
||
|
'url' => new \moodle_url('/admin/roles/assign.php', array('contextid' => $category->get_context()->id,
|
||
|
'returnurl' => $manageurl->out_as_local_url(false))),
|
||
|
'icon' => new \pix_icon('t/assignroles', new \lang_string('assignroles', 'role')),
|
||
|
'string' => new \lang_string('assignroles', 'role')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Permissions.
|
||
|
if ($category->can_review_permissions()) {
|
||
|
$actions['permissions'] = array(
|
||
|
'url' => new \moodle_url('/admin/roles/permissions.php', array('contextid' => $category->get_context()->id,
|
||
|
'returnurl' => $manageurl->out_as_local_url(false))),
|
||
|
'icon' => new \pix_icon('i/permissions', new \lang_string('permissions', 'role')),
|
||
|
'string' => new \lang_string('permissions', 'role')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Check permissions.
|
||
|
if ($category->can_review_permissions()) {
|
||
|
$actions['checkroles'] = array(
|
||
|
'url' => new \moodle_url('/admin/roles/check.php', array('contextid' => $category->get_context()->id,
|
||
|
'returnurl' => $manageurl->out_as_local_url(false))),
|
||
|
'icon' => new \pix_icon('i/checkpermissions', new \lang_string('checkpermissions', 'role')),
|
||
|
'string' => new \lang_string('checkpermissions', 'role')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Context locking.
|
||
|
if (!empty($CFG->contextlocking) && has_capability('moodle/site:managecontextlocks', $category->get_context())) {
|
||
|
$parentcontext = $category->get_context()->get_parent_context();
|
||
|
if (empty($parentcontext) || !$parentcontext->locked) {
|
||
|
if ($category->get_context()->locked) {
|
||
|
$lockicon = 'i/unlock';
|
||
|
$lockstring = get_string('managecontextunlock', 'admin');
|
||
|
} else {
|
||
|
$lockicon = 'i/lock';
|
||
|
$lockstring = get_string('managecontextlock', 'admin');
|
||
|
}
|
||
|
$actions['managecontextlock'] = [
|
||
|
'url' => new \moodle_url('/admin/lock.php', [
|
||
|
'id' => $category->get_context()->id,
|
||
|
'returnurl' => $manageurl->out_as_local_url(false),
|
||
|
]),
|
||
|
'icon' => new \pix_icon($lockicon, $lockstring),
|
||
|
'string' => $lockstring,
|
||
|
];
|
||
|
}
|
||
|
}
|
||
|
|
||
|
// Cohorts.
|
||
|
if ($category->can_review_cohorts()) {
|
||
|
$actions['cohorts'] = array(
|
||
|
'url' => new \moodle_url('/cohort/index.php', array('contextid' => $category->get_context()->id)),
|
||
|
'icon' => new \pix_icon('t/cohort', new \lang_string('cohorts', 'cohort')),
|
||
|
'string' => new \lang_string('cohorts', 'cohort')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
// Filters.
|
||
|
if ($category->can_review_filters()) {
|
||
|
$actions['filters'] = array(
|
||
|
'url' => new \moodle_url('/filter/manage.php', array('contextid' => $category->get_context()->id,
|
||
|
'return' => 'management')),
|
||
|
'icon' => new \pix_icon('i/filter', new \lang_string('filters', 'admin')),
|
||
|
'string' => new \lang_string('filters', 'admin')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
if ($category->can_restore_courses_into()) {
|
||
|
$actions['restore'] = array(
|
||
|
'url' => new \moodle_url('/backup/restorefile.php', array('contextid' => $category->get_context()->id)),
|
||
|
'icon' => new \pix_icon('i/restore', new \lang_string('restorecourse', 'admin')),
|
||
|
'string' => new \lang_string('restorecourse', 'admin')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
return $actions;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns an array of actions for a course listitem.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @param \core_course_list_element $course
|
||
|
* @return string
|
||
|
*/
|
||
|
public static function get_course_listitem_actions(\core_course_category $category, \core_course_list_element $course) {
|
||
|
$baseurl = new \moodle_url(
|
||
|
'/course/management.php',
|
||
|
array('courseid' => $course->id, 'categoryid' => $course->category, 'sesskey' => \sesskey())
|
||
|
);
|
||
|
$actions = array();
|
||
|
// Edit.
|
||
|
if ($course->can_edit()) {
|
||
|
$actions[] = array(
|
||
|
'url' => new \moodle_url('/course/edit.php', array('id' => $course->id, 'returnto' => 'catmanage')),
|
||
|
'icon' => new \pix_icon('t/edit', \get_string('edit')),
|
||
|
'attributes' => array('class' => 'action-edit')
|
||
|
);
|
||
|
}
|
||
|
// Delete.
|
||
|
if ($course->can_delete()) {
|
||
|
$actions[] = array(
|
||
|
'url' => new \moodle_url('/course/delete.php', array('id' => $course->id)),
|
||
|
'icon' => new \pix_icon('t/delete', \get_string('delete')),
|
||
|
'attributes' => array('class' => 'action-delete')
|
||
|
);
|
||
|
}
|
||
|
// Show/Hide.
|
||
|
if ($course->can_change_visibility()) {
|
||
|
$actions[] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'hidecourse')),
|
||
|
'icon' => new \pix_icon('t/hide', \get_string('hide')),
|
||
|
'attributes' => array('data-action' => 'hide', 'class' => 'action-hide')
|
||
|
);
|
||
|
$actions[] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'showcourse')),
|
||
|
'icon' => new \pix_icon('t/show', \get_string('show')),
|
||
|
'attributes' => array('data-action' => 'show', 'class' => 'action-show')
|
||
|
);
|
||
|
}
|
||
|
// Move up/down.
|
||
|
if ($category->can_resort_courses()) {
|
||
|
$actions[] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'movecourseup')),
|
||
|
'icon' => new \pix_icon('t/up', \get_string('up')),
|
||
|
'attributes' => array('data-action' => 'moveup', 'class' => 'action-moveup')
|
||
|
);
|
||
|
$actions[] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'movecoursedown')),
|
||
|
'icon' => new \pix_icon('t/down', \get_string('down')),
|
||
|
'attributes' => array('data-action' => 'movedown', 'class' => 'action-movedown')
|
||
|
);
|
||
|
}
|
||
|
return $actions;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns an array of actions that can be performed on the course being displayed.
|
||
|
*
|
||
|
* @param \core_course_list_element $course
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function get_course_detail_actions(\core_course_list_element $course) {
|
||
|
$params = array('courseid' => $course->id, 'categoryid' => $course->category, 'sesskey' => \sesskey());
|
||
|
$baseurl = new \moodle_url('/course/management.php', $params);
|
||
|
$actions = array();
|
||
|
// View.
|
||
|
$actions['view'] = array(
|
||
|
'url' => new \moodle_url('/course/view.php', array('id' => $course->id)),
|
||
|
'string' => \get_string('view')
|
||
|
);
|
||
|
// Edit.
|
||
|
if ($course->can_edit()) {
|
||
|
$actions['edit'] = array(
|
||
|
'url' => new \moodle_url('/course/edit.php', array('id' => $course->id)),
|
||
|
'string' => \get_string('edit')
|
||
|
);
|
||
|
}
|
||
|
// Permissions.
|
||
|
if ($course->can_review_enrolments()) {
|
||
|
$actions['enrolledusers'] = array(
|
||
|
'url' => new \moodle_url('/user/index.php', array('id' => $course->id)),
|
||
|
'string' => \get_string('enrolledusers', 'enrol')
|
||
|
);
|
||
|
}
|
||
|
// Delete.
|
||
|
if ($course->can_delete()) {
|
||
|
$actions['delete'] = array(
|
||
|
'url' => new \moodle_url('/course/delete.php', array('id' => $course->id)),
|
||
|
'string' => \get_string('delete')
|
||
|
);
|
||
|
}
|
||
|
// Show/Hide.
|
||
|
if ($course->can_change_visibility()) {
|
||
|
if ($course->visible) {
|
||
|
$actions['hide'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'hidecourse')),
|
||
|
'string' => \get_string('hide')
|
||
|
);
|
||
|
} else {
|
||
|
$actions['show'] = array(
|
||
|
'url' => new \moodle_url($baseurl, array('action' => 'showcourse')),
|
||
|
'string' => \get_string('show')
|
||
|
);
|
||
|
}
|
||
|
}
|
||
|
// Backup.
|
||
|
if ($course->can_backup()) {
|
||
|
$actions['backup'] = array(
|
||
|
'url' => new \moodle_url('/backup/backup.php', array('id' => $course->id)),
|
||
|
'string' => \get_string('backup')
|
||
|
);
|
||
|
}
|
||
|
// Restore.
|
||
|
if ($course->can_restore()) {
|
||
|
$actions['restore'] = array(
|
||
|
'url' => new \moodle_url('/backup/restorefile.php', array('contextid' => $course->get_context()->id)),
|
||
|
'string' => \get_string('restore')
|
||
|
);
|
||
|
}
|
||
|
return $actions;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resorts the courses within a category moving the given course up by one.
|
||
|
*
|
||
|
* @param \core_course_list_element $course
|
||
|
* @param \core_course_category $category
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_course_change_sortorder_up_one(\core_course_list_element $course,
|
||
|
\core_course_category $category) {
|
||
|
if (!$category->can_resort_courses()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_resort');
|
||
|
}
|
||
|
return \course_change_sortorder_by_one($course, true);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resorts the courses within a category moving the given course down by one.
|
||
|
*
|
||
|
* @param \core_course_list_element $course
|
||
|
* @param \core_course_category $category
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_course_change_sortorder_down_one(\core_course_list_element $course,
|
||
|
\core_course_category $category) {
|
||
|
if (!$category->can_resort_courses()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_resort');
|
||
|
}
|
||
|
return \course_change_sortorder_by_one($course, false);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resorts the courses within a category moving the given course up by one.
|
||
|
*
|
||
|
* @global \moodle_database $DB
|
||
|
* @param int|\stdClass $courserecordorid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_course_change_sortorder_up_one_by_record($courserecordorid) {
|
||
|
if (is_int($courserecordorid)) {
|
||
|
$courserecordorid = get_course($courserecordorid);
|
||
|
}
|
||
|
$course = new \core_course_list_element($courserecordorid);
|
||
|
$category = \core_course_category::get($course->category);
|
||
|
return self::action_course_change_sortorder_up_one($course, $category);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resorts the courses within a category moving the given course down by one.
|
||
|
*
|
||
|
* @global \moodle_database $DB
|
||
|
* @param int|\stdClass $courserecordorid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_course_change_sortorder_down_one_by_record($courserecordorid) {
|
||
|
if (is_int($courserecordorid)) {
|
||
|
$courserecordorid = get_course($courserecordorid);
|
||
|
}
|
||
|
$course = new \core_course_list_element($courserecordorid);
|
||
|
$category = \core_course_category::get($course->category);
|
||
|
return self::action_course_change_sortorder_down_one($course, $category);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Changes the sort order so that the first course appears after the second course.
|
||
|
*
|
||
|
* @param int|\stdClass $courserecordorid
|
||
|
* @param int $moveaftercourseid
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_course_change_sortorder_after_course($courserecordorid, $moveaftercourseid) {
|
||
|
$course = \get_course($courserecordorid);
|
||
|
$category = \core_course_category::get($course->category);
|
||
|
if (!$category->can_resort_courses()) {
|
||
|
$url = '/course/management.php?categoryid='.$course->category;
|
||
|
throw new \moodle_exception('nopermissions', 'error', $url, \get_string('resortcourses', 'moodle'));
|
||
|
}
|
||
|
return \course_change_sortorder_after_course($course, $moveaftercourseid);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a course visible given a \core_course_list_element object.
|
||
|
*
|
||
|
* @param \core_course_list_element $course
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_course_show(\core_course_list_element $course) {
|
||
|
if (!$course->can_change_visibility()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null,
|
||
|
'core_course_list_element::can_change_visbility');
|
||
|
}
|
||
|
return course_change_visibility($course->id, true);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a course hidden given a \core_course_list_element object.
|
||
|
*
|
||
|
* @param \core_course_list_element $course
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_course_hide(\core_course_list_element $course) {
|
||
|
if (!$course->can_change_visibility()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null,
|
||
|
'core_course_list_element::can_change_visbility');
|
||
|
}
|
||
|
return course_change_visibility($course->id, false);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a course visible given a course id or a database record.
|
||
|
*
|
||
|
* @global \moodle_database $DB
|
||
|
* @param int|\stdClass $courserecordorid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_course_show_by_record($courserecordorid) {
|
||
|
if (is_int($courserecordorid)) {
|
||
|
$courserecordorid = get_course($courserecordorid);
|
||
|
}
|
||
|
$course = new \core_course_list_element($courserecordorid);
|
||
|
return self::action_course_show($course);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a course hidden given a course id or a database record.
|
||
|
*
|
||
|
* @global \moodle_database $DB
|
||
|
* @param int|\stdClass $courserecordorid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_course_hide_by_record($courserecordorid) {
|
||
|
if (is_int($courserecordorid)) {
|
||
|
$courserecordorid = get_course($courserecordorid);
|
||
|
}
|
||
|
$course = new \core_course_list_element($courserecordorid);
|
||
|
return self::action_course_hide($course);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resort a categories subcategories shifting the given category up one.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_change_sortorder_up_one(\core_course_category $category) {
|
||
|
if (!$category->can_change_sortorder()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_change_sortorder');
|
||
|
}
|
||
|
return $category->change_sortorder_by_one(true);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resort a categories subcategories shifting the given category down one.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_change_sortorder_down_one(\core_course_category $category) {
|
||
|
if (!$category->can_change_sortorder()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_change_sortorder');
|
||
|
}
|
||
|
return $category->change_sortorder_by_one(false);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resort a categories subcategories shifting the given category up one.
|
||
|
*
|
||
|
* @param int $categoryid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_category_change_sortorder_up_one_by_id($categoryid) {
|
||
|
$category = \core_course_category::get($categoryid);
|
||
|
return self::action_category_change_sortorder_up_one($category);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resort a categories subcategories shifting the given category down one.
|
||
|
*
|
||
|
* @param int $categoryid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_category_change_sortorder_down_one_by_id($categoryid) {
|
||
|
$category = \core_course_category::get($categoryid);
|
||
|
return self::action_category_change_sortorder_down_one($category);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a category hidden given a core_course_category object.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_hide(\core_course_category $category) {
|
||
|
if (!$category->can_change_visibility()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_change_visbility');
|
||
|
}
|
||
|
$category->hide();
|
||
|
return true;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a category visible given a core_course_category object.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_show(\core_course_category $category) {
|
||
|
if (!$category->can_change_visibility()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_change_visbility');
|
||
|
}
|
||
|
$category->show();
|
||
|
return true;
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a category visible given a course category id or database record.
|
||
|
*
|
||
|
* @param int|\stdClass $categoryid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_category_show_by_id($categoryid) {
|
||
|
return self::action_category_show(\core_course_category::get($categoryid));
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Makes a category hidden given a course category id or database record.
|
||
|
*
|
||
|
* @param int|\stdClass $categoryid
|
||
|
* @return bool
|
||
|
*/
|
||
|
public static function action_category_hide_by_id($categoryid) {
|
||
|
return self::action_category_hide(\core_course_category::get($categoryid));
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resorts the sub categories of the given category.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @param string $sort One of idnumber or name.
|
||
|
* @param bool $cleanup If true cleanup will be done, if false you will need to do it manually later.
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_resort_subcategories(\core_course_category $category, $sort, $cleanup = true) {
|
||
|
if (!$category->can_resort_subcategories()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_resort');
|
||
|
}
|
||
|
return $category->resort_subcategories($sort, $cleanup);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Resorts the courses within the given category.
|
||
|
*
|
||
|
* @param \core_course_category $category
|
||
|
* @param string $sort One of fullname, shortname or idnumber
|
||
|
* @param bool $cleanup If true cleanup will be done, if false you will need to do it manually later.
|
||
|
* @return bool
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_resort_courses(\core_course_category $category, $sort, $cleanup = true) {
|
||
|
if (!$category->can_resort_courses()) {
|
||
|
throw new \moodle_exception('permissiondenied', 'error', '', null, 'core_course_category::can_resort');
|
||
|
}
|
||
|
return $category->resort_courses($sort, $cleanup);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Moves courses out of one category and into a new category.
|
||
|
*
|
||
|
* @param \core_course_category $oldcategory The category we are moving courses out of.
|
||
|
* @param \core_course_category $newcategory The category we are moving courses into.
|
||
|
* @param array $courseids The ID's of the courses we want to move.
|
||
|
* @return bool True on success.
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function action_category_move_courses_into(\core_course_category $oldcategory,
|
||
|
\core_course_category $newcategory, array $courseids) {
|
||
|
global $DB;
|
||
|
|
||
|
list($where, $params) = $DB->get_in_or_equal($courseids, SQL_PARAMS_NAMED);
|
||
|
$params['categoryid'] = $oldcategory->id;
|
||
|
$sql = "SELECT c.id FROM {course} c WHERE c.id {$where} AND c.category <> :categoryid";
|
||
|
if ($DB->record_exists_sql($sql, $params)) {
|
||
|
// Likely being tinkered with.
|
||
|
throw new \moodle_exception('coursedoesnotbelongtocategory');
|
||
|
}
|
||
|
|
||
|
// All courses are currently within the old category.
|
||
|
return self::move_courses_into_category($newcategory, $courseids);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns the view modes for the management interface.
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function get_management_viewmodes() {
|
||
|
return array(
|
||
|
'combined' => new \lang_string('categoriesandcourses'),
|
||
|
'categories' => new \lang_string('categories'),
|
||
|
'courses' => new \lang_string('courses')
|
||
|
);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Search for courses with matching params.
|
||
|
*
|
||
|
* Please note that only one of search, blocklist, or modulelist can be specified at a time.
|
||
|
* Specifying more than one will result in only the first being used.
|
||
|
*
|
||
|
* @param string $search Words to search for. We search fullname, shortname, idnumber and summary.
|
||
|
* @param int $blocklist The ID of a block, courses will only be returned if they use this block.
|
||
|
* @param string $modulelist The name of a module (relates to database table name). Only courses containing this module
|
||
|
* will be returned.
|
||
|
* @param int $page The page number to display, starting at 0.
|
||
|
* @param int $perpage The number of courses to display per page.
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function search_courses($search, $blocklist, $modulelist, $page = 0, $perpage = null) {
|
||
|
global $CFG;
|
||
|
|
||
|
if ($perpage === null) {
|
||
|
$perpage = $CFG->coursesperpage;
|
||
|
}
|
||
|
|
||
|
$searchcriteria = array();
|
||
|
if (!empty($search)) {
|
||
|
$searchcriteria = array('search' => $search);
|
||
|
} else if (!empty($blocklist)) {
|
||
|
$searchcriteria = array('blocklist' => $blocklist);
|
||
|
} else if (!empty($modulelist)) {
|
||
|
$searchcriteria = array('modulelist' => $modulelist);
|
||
|
}
|
||
|
|
||
|
$topcat = \core_course_category::top();
|
||
|
$courses = $topcat->search_courses($searchcriteria, array(
|
||
|
'recursive' => true,
|
||
|
'offset' => $page * $perpage,
|
||
|
'limit' => $perpage,
|
||
|
'sort' => array('fullname' => 1)
|
||
|
));
|
||
|
$totalcount = $topcat->search_courses_count($searchcriteria, array('recursive' => true));
|
||
|
|
||
|
return array($courses, \count($courses), $totalcount);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Moves one or more courses out of the category they are currently in and into a new category.
|
||
|
*
|
||
|
* This function works much the same way as action_category_move_courses_into however it allows courses from multiple
|
||
|
* categories to be moved into a single category.
|
||
|
*
|
||
|
* @param int|\core_course_category $categoryorid The category to move them into.
|
||
|
* @param array|int $courseids An array of course id's or optionally just a single course id.
|
||
|
* @return bool True on success or false on failure.
|
||
|
* @throws \moodle_exception
|
||
|
*/
|
||
|
public static function move_courses_into_category($categoryorid, $courseids = array()) {
|
||
|
global $DB;
|
||
|
if (!is_array($courseids)) {
|
||
|
// Just a single course ID.
|
||
|
$courseids = array($courseids);
|
||
|
}
|
||
|
// Bulk move courses from one category to another.
|
||
|
if (count($courseids) === 0) {
|
||
|
return false;
|
||
|
}
|
||
|
if ($categoryorid instanceof \core_course_category) {
|
||
|
$moveto = $categoryorid;
|
||
|
} else {
|
||
|
$moveto = \core_course_category::get($categoryorid);
|
||
|
}
|
||
|
if (!$moveto->can_move_courses_out_of() || !$moveto->can_move_courses_into()) {
|
||
|
throw new \moodle_exception('cannotmovecourses');
|
||
|
}
|
||
|
|
||
|
list($where, $params) = $DB->get_in_or_equal($courseids, SQL_PARAMS_NAMED);
|
||
|
$sql = "SELECT c.id, c.category FROM {course} c WHERE c.id {$where}";
|
||
|
$courses = $DB->get_records_sql($sql, $params);
|
||
|
$checks = array();
|
||
|
foreach ($courseids as $id) {
|
||
|
if (!isset($courses[$id])) {
|
||
|
throw new \moodle_exception('invalidcourseid');
|
||
|
}
|
||
|
$catid = $courses[$id]->category;
|
||
|
if (!isset($checks[$catid])) {
|
||
|
$coursecat = \core_course_category::get($catid);
|
||
|
$checks[$catid] = $coursecat->can_move_courses_out_of() && $coursecat->can_move_courses_into();
|
||
|
}
|
||
|
if (!$checks[$catid]) {
|
||
|
throw new \moodle_exception('cannotmovecourses');
|
||
|
}
|
||
|
}
|
||
|
return \move_courses($courseids, $moveto->id);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns an array of courseids and visiblity for all courses within the given category.
|
||
|
* @param int $categoryid
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function get_category_courses_visibility($categoryid) {
|
||
|
global $DB;
|
||
|
$sql = "SELECT c.id, c.visible
|
||
|
FROM {course} c
|
||
|
WHERE c.category = :category";
|
||
|
$params = array('category' => (int)$categoryid);
|
||
|
return $DB->get_records_sql($sql, $params);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns an array of all categoryids that have the given category as a parent and their visible value.
|
||
|
* @param int $categoryid
|
||
|
* @return array
|
||
|
*/
|
||
|
public static function get_category_children_visibility($categoryid) {
|
||
|
global $DB;
|
||
|
$category = \core_course_category::get($categoryid);
|
||
|
$select = $DB->sql_like('path', ':path');
|
||
|
$path = $category->path . '/%';
|
||
|
|
||
|
$sql = "SELECT c.id, c.visible
|
||
|
FROM {course_categories} c
|
||
|
WHERE ".$select;
|
||
|
$params = array('path' => $path);
|
||
|
return $DB->get_records_sql($sql, $params);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Records when a category is expanded or collapsed so that when the user
|
||
|
*
|
||
|
* @param \core_course_category $coursecat The category we're working with.
|
||
|
* @param bool $expanded True if the category is expanded now.
|
||
|
*/
|
||
|
public static function record_expanded_category(\core_course_category $coursecat, $expanded = true) {
|
||
|
// If this ever changes we are going to reset it and reload the categories as required.
|
||
|
self::$expandedcategories = null;
|
||
|
$categoryid = $coursecat->id;
|
||
|
$path = $coursecat->get_parents();
|
||
|
/* @var \cache_session $cache */
|
||
|
$cache = \cache::make('core', 'userselections');
|
||
|
$categories = $cache->get('categorymanagementexpanded');
|
||
|
if (!is_array($categories)) {
|
||
|
if (!$expanded) {
|
||
|
// No categories recorded, nothing to remove.
|
||
|
return;
|
||
|
}
|
||
|
$categories = array();
|
||
|
}
|
||
|
if ($expanded) {
|
||
|
$ref =& $categories;
|
||
|
foreach ($coursecat->get_parents() as $path) {
|
||
|
if (!isset($ref[$path]) || !is_array($ref[$path])) {
|
||
|
$ref[$path] = array();
|
||
|
}
|
||
|
$ref =& $ref[$path];
|
||
|
}
|
||
|
if (!isset($ref[$categoryid])) {
|
||
|
$ref[$categoryid] = true;
|
||
|
}
|
||
|
} else {
|
||
|
$found = true;
|
||
|
$ref =& $categories;
|
||
|
foreach ($coursecat->get_parents() as $path) {
|
||
|
if (!isset($ref[$path])) {
|
||
|
$found = false;
|
||
|
break;
|
||
|
}
|
||
|
$ref =& $ref[$path];
|
||
|
}
|
||
|
if ($found) {
|
||
|
$ref[$categoryid] = null;
|
||
|
unset($ref[$categoryid]);
|
||
|
}
|
||
|
}
|
||
|
$cache->set('categorymanagementexpanded', $categories);
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* Returns the categories that should be expanded when displaying the interface.
|
||
|
*
|
||
|
* @param int|null $withpath If specified a path to require as the parent.
|
||
|
* @return \core_course_category[] An array of Category ID's to expand.
|
||
|
*/
|
||
|
public static function get_expanded_categories($withpath = null) {
|
||
|
if (self::$expandedcategories === null) {
|
||
|
/* @var \cache_session $cache */
|
||
|
$cache = \cache::make('core', 'userselections');
|
||
|
self::$expandedcategories = $cache->get('categorymanagementexpanded');
|
||
|
if (self::$expandedcategories === false) {
|
||
|
self::$expandedcategories = array();
|
||
|
}
|
||
|
}
|
||
|
if (empty($withpath)) {
|
||
|
return array_keys(self::$expandedcategories);
|
||
|
}
|
||
|
$parents = explode('/', trim($withpath, '/'));
|
||
|
$ref =& self::$expandedcategories;
|
||
|
foreach ($parents as $parent) {
|
||
|
if (!isset($ref[$parent])) {
|
||
|
return array();
|
||
|
}
|
||
|
$ref =& $ref[$parent];
|
||
|
}
|
||
|
if (is_array($ref)) {
|
||
|
return array_keys($ref);
|
||
|
} else {
|
||
|
return array($parent);
|
||
|
}
|
||
|
}
|
||
|
}
|