PHP move_category函数代码示例

 /**
  * Update categories
  *
  * @param array $categories The list of categories to update
  * @return null
  * @since Moodle 2.3
  */
 public static function update_categories($categories)
 {
     global $CFG, $DB;
     require_once $CFG->dirroot . "/course/lib.php";
     // Validate parameters.
     $params = self::validate_parameters(self::update_categories_parameters(), array('categories' => $categories));
     $transaction = $DB->start_delegated_transaction();
     foreach ($params['categories'] as $cat) {
         if (!($category = $DB->get_record('course_categories', array('id' => $cat['id'])))) {
             throw new moodle_exception('unknowcategory');
         }
         $categorycontext = context_coursecat::instance($cat['id']);
         self::validate_context($categorycontext);
         require_capability('moodle/category:manage', $categorycontext);
         if (!empty($cat['name'])) {
             if (textlib::strlen($cat['name']) > 255) {
                 throw new moodle_exception('categorytoolong');
             }
             $category->name = $cat['name'];
         }
         if (!empty($cat['idnumber'])) {
             if (textlib::strlen($cat['idnumber']) > 100) {
                 throw new moodle_exception('idnumbertoolong');
             }
             $category->idnumber = $cat['idnumber'];
         }
         if (!empty($cat['description'])) {
             $category->description = $cat['description'];
             $category->descriptionformat = external_validate_format($cat['descriptionformat']);
         }
         if (!empty($cat['theme'])) {
             $category->theme = $cat['theme'];
         }
         if (!empty($cat['parent']) && $category->parent != $cat['parent']) {
             // First check if parent exists.
             if (!($parent_cat = $DB->get_record('course_categories', array('id' => $cat['parent'])))) {
                 throw new moodle_exception('unknowcategory');
             }
             // Then check if we have capability.
             self::validate_context(get_category_or_system_context((int) $cat['parent']));
             require_capability('moodle/category:manage', get_category_or_system_context((int) $cat['parent']));
             // Finally move the category.
             move_category($category, $parent_cat);
             $category->parent = $cat['parent'];
             // Get updated path by move_category().
             $category->path = $DB->get_field('course_categories', 'path', array('id' => $category->id));
         }
         $DB->update_record('course_categories', $category);
     }
     $transaction->allow_commit();
 }

    $tempcat = new stdClass();
    $tempcat->name = get_string('miscellaneous');
    $tempcat->id = $DB->insert_record('course_categories', $tempcat);
    $tempcat->context = get_context_instance(CONTEXT_COURSECAT, $tempcat->id);
    mark_context_dirty('/' . SYSCONTEXTID);
    fix_course_sortorder();
    // Required to build course_categories.depth and .path.
}
/// Move a category to a new parent if required
if (!empty($move) and $moveto >= 0 and confirm_sesskey()) {
    if ($cattomove = $DB->get_record('course_categories', array('id' => $move))) {
        require_capability('moodle/category:manage', get_category_or_system_context($cattomove->parent));
        if ($cattomove->parent != $moveto) {
            $newparent = $DB->get_record('course_categories', array('id' => $moveto));
            require_capability('moodle/category:manage', get_category_or_system_context($moveto));
            move_category($cattomove, $newparent);
        }
    }
}
/// Hide or show a category
if ($hide and confirm_sesskey()) {
    if ($tempcat = $DB->get_record('course_categories', array('id' => $hide))) {
        require_capability('moodle/category:manage', get_category_or_system_context($tempcat->parent));
        if ($tempcat->visible == 1) {
            course_category_hide($tempcat);
        }
    }
} else {
    if ($show and confirm_sesskey()) {
        if ($tempcat = $DB->get_record('course_categories', array('id' => $show))) {
            require_capability('moodle/category:manage', get_category_or_system_context($tempcat->parent));

/**
 * Delete category, but move contents to another category.
 * @param object $ccategory
 * @param int $newparentid category id
 * @return bool status
 */
function category_delete_move($category, $newparentid, $showfeedback = true)
{
    global $CFG, $DB, $OUTPUT;
    require_once $CFG->libdir . '/gradelib.php';
    require_once $CFG->libdir . '/questionlib.php';
    require_once $CFG->dirroot . '/cohort/lib.php';
    if (!($newparentcat = $DB->get_record('course_categories', array('id' => $newparentid)))) {
        return false;
    }
    if ($children = $DB->get_records('course_categories', array('parent' => $category->id), 'sortorder ASC')) {
        foreach ($children as $childcat) {
            move_category($childcat, $newparentcat);
        }
    }
    if ($courses = $DB->get_records('course', array('category' => $category->id), 'sortorder ASC', 'id')) {
        if (!move_courses(array_keys($courses), $newparentid)) {
            echo $OUTPUT->notification("Error moving courses");
            return false;
        }
        echo $OUTPUT->notification(get_string('coursesmovedout', '', format_string($category->name)), 'notifysuccess');
    }
    // move or delete cohorts in this context
    cohort_delete_category($category);
    // now delete anything that may depend on course category context
    grade_course_category_delete($category->id, $newparentid, $showfeedback);
    if (!question_delete_course_category($category, $newparentcat, $showfeedback)) {
        echo $OUTPUT->notification(get_string('errordeletingquestionsfromcategory', 'question', $category), 'notifysuccess');
        return false;
    }
    // finally delete the category and it's context
    $DB->delete_records('course_categories', array('id' => $category->id));
    delete_context(CONTEXT_COURSECAT, $category->id);
    events_trigger('course_category_deleted', $category);
    echo $OUTPUT->notification(get_string('coursecategorydeleted', '', format_string($category->name)), 'notifysuccess');
    return true;
}

  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

************************************************************************/
define('OPENLD_ROOT', './');
require OPENLD_ROOT . 'admin_header.php';
$req_page = isset($_REQUEST['page']) ? is_numeric($_REQUEST['page']) ? $_REQUEST['page'] : '1' : '1';
$req_id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '0';
$req_cat = isset($_REQUEST['category']) ? $_REQUEST['category'] : '';
($hook = get_hook('admin_browse_before_sql_input_check')) ? eval($hook) : null;
//SQL Operations
if (isset($_REQUEST['delete'])) {
    delete_category($_REQUEST['delete']);
} elseif (isset($_REQUEST['delete_link'])) {
    delete_link($_REQUEST['delete_link']);
} elseif (isset($_REQUEST['move_cat_sql'])) {
    move_category($req_id, $req_page, $_REQUEST['move_cat_sql'], $_REQUEST['to_new_parent']);
} elseif (isset($_REQUEST['move_link_sql'])) {
    move_link($req_id, $req_page, $_REQUEST['move_link_sql'], $_REQUEST['to_new_parent']);
} elseif (isset($_REQUEST['edit_cat_sql'])) {
    edit_a_category($req_id, $req_page, $_REQUEST['cat_id']);
} elseif (isset($_REQUEST['edit_link_sql'])) {
    edit_a_link($req_id, $req_page, $_REQUEST['edit_link_sql']);
} elseif (isset($_REQUEST['add_a_link'])) {
    add_a_link($req_id);
} elseif (isset($_REQUEST['add_a_category'])) {
    add_a_category($req_id);
} elseif (isset($_REQUEST['unaccept'])) {
    unaccept_category($_REQUEST['unaccept']);
} elseif (isset($_REQUEST['unaccept_link'])) {
    unaccept_link($_REQUEST['unaccept_link']);
}

            theme_setup();
        }
        if (empty($category) && has_capability('moodle/category:create', $context)) {
            // Create a new category
            if (!($newcategory->id = insert_record('course_categories', $newcategory))) {
                notify("Could not insert the new category '{$newcategory->name}' ");
            } else {
                $newcategory->context = get_context_instance(CONTEXT_COURSECAT, $newcategory->id);
                mark_context_dirty($newcategory->context->path);
                redirect('index.php?categoryedit=on');
            }
        } elseif (has_capability('moodle/category:update', $context)) {
            $newcategory->id = $category->id;
            if ($newcategory->parent != $category->parent) {
                $parent_cat = get_record('course_categories', 'id', $newcategory->parent);
                move_category($newcategory, $parent_cat);
            }
            if (!update_record('course_categories', $newcategory)) {
                error("Could not update the category '{$newcategory->name}' ");
            } else {
                if ($newcategory->parent == 0) {
                    $redirect_link = 'index.php?categoryedit=on';
                } else {
                    $redirect_link = 'category.php?id=' . $newcategory->id . '&categoryedit=on';
                }
                fix_course_sortorder();
                redirect($redirect_link);
            }
        }
    }
}

/**
 * Delete category, but move contents to another category.
 * @param object $ccategory
 * @param int $newparentid category id
 * @return bool status
 */
function category_delete_move($category, $newparentid, $showfeedback = true)
{
    global $CFG;
    require_once $CFG->libdir . '/gradelib.php';
    require_once $CFG->libdir . '/questionlib.php';
    if (!($newparentcat = get_record('course_categories', 'id', $newparentid))) {
        return false;
    }
    if ($children = get_records('course_categories', 'parent', $category->id, 'sortorder ASC')) {
        foreach ($children as $childcat) {
            if (!move_category($childcat, $newparentcat)) {
                notify("Error moving category {$childcat->name}");
                return false;
            }
        }
    }
    if ($courses = get_records('course', 'category', $category->id, 'sortorder ASC', 'id')) {
        if (!move_courses(array_keys($courses), $newparentid)) {
            notify("Error moving courses");
            return false;
        }
        notify(get_string('coursesmovedout', '', format_string($category->name)), 'notifysuccess');
    }
    // now delete anything that may depend on course category context
    grade_course_category_delete($category->id, $newparentid, $showfeedback);
    if (!question_delete_course_category($category, $newparentcat, $showfeedback)) {
        notify(get_string('errordeletingquestionsfromcategory', 'question', $category), 'notifysuccess');
        return false;
    }
    // finally delete the category and it's context
    delete_records('course_categories', 'id', $category->id);
    delete_context(CONTEXT_COURSECAT, $category->id);
    events_trigger('course_category_deleted', $category);
    notify(get_string('coursecategorydeleted', '', format_string($category->name)), 'notifysuccess');
    return true;
}

 protected function move_category($category, $destcategory)
 {
     global $CFG;
     require_once $CFG->dirroot . '/course/lib.php';
     move_category($category, $destcategory);
 }

    /// No category yet!
    // Try and make one
    unset($tempcat);
    $tempcat->name = get_string('miscellaneous');
    if (!($tempcat->id = insert_record('course_categories', $tempcat))) {
        error('Serious error: Could not create a default category!');
    }
    $tempcat->context = get_context_instance(CONTEXT_COURSECAT, $tempcat->id);
    mark_context_dirty('/' . SYSCONTEXTID);
}
/// Move a category to a new parent if required
if (!empty($move) and $moveto >= 0 and confirm_sesskey()) {
    if ($tempcat = get_record('course_categories', 'id', $move)) {
        if ($tempcat->parent != $moveto) {
            $newp = get_record('course_categories', 'id', $moveto);
            if (!move_category($tempcat, $newp)) {
                notify('Could not update that category!');
            }
        }
    }
}
/// Hide or show a category
if ((!empty($hide) or !empty($show)) and confirm_sesskey()) {
    if (!empty($hide)) {
        $tempcat = get_record('course_categories', 'id', $hide);
        $visible = 0;
    } else {
        $tempcat = get_record('course_categories', 'id', $show);
        $visible = 1;
    }
    if ($tempcat) {

 if ($standardnames) {
     $oldname = clean_param($coursecategory->oldname, PARAM_MULTILANG);
 } else {
     $oldname = $coursecategory->oldname;
 }
 // no guessing when looking for old name, it must be exact match
 if ($oldcoursecategory = $DB->get_record('course_categories', array('name' => trim($coursecategory->oldname), 'parent' => $coursecategory->oldparent))) {
     $upt->track('id', $oldcoursecategory->id, 'normal', false);
     require_capability('moodle/category:manage', get_category_or_system_context((int) $oldcoursecategory->parent));
     $DB->set_field('course_categories', 'name', $coursecategory->name, array('id' => $oldcoursecategory->id));
     // update hierarchy pointer if necessary
     if ($coursecategory->parent != $coursecategory->oldparent) {
         require_capability('moodle/category:manage', get_category_or_system_context((int) $coursecategory->parent));
         $parent_cat = $DB->get_record('course_categories', array('id' => $coursecategory->parent));
         $coursecategory->id = $oldcoursecategory->id;
         move_category($coursecategory, $parent_cat);
         $existingcategory->context = context_coursecat::instance($oldcoursecategory->id);
         $existingcategory->context->mark_dirty();
     }
     $upt->track('name', '', 'normal', false);
     // clear previous
     $upt->track('name', s($oldname) . '-->' . s($coursecategory->name), 'info');
     $upt->track('status', $strcoursecategoryrenamed);
     $renames++;
 } else {
     $upt->track('status', $strcoursecategorynotrenamedmissing, 'error');
     $renameerrors++;
     continue;
 }
 $existingcategory = $oldcoursecategory;
 $existingcategory->name = $coursecategory->name;