这是一个想法，但我想在前端排序一个列表，您需要更改表“{prefix}term\\u taxonomy”，创建“term\\u order”字段。请参阅函数O\\u term\\u update\\u db（）：
在您的功能中。php
<?php
function O_term_update_db(){
global $wpdb;
global $term_db_version;
$term_db_version = "1";
$charset_collate = $wpdb->get_charset_collate();
if(get_site_option( \'O_term_db_version\' ) < $term_db_version):
require_once( ABSPATH . \'wp-admin/includes/upgrade.php\' );
$wpdb->query( "ALTER TABLE $wpdb->prefix .\'term_taxonomy\' ADD `term_order` INT (11) NOT NULL DEFAULT 0;" );
update_site_option( \'O_term_db_version\', $term_db_version);
endif;
}
add_action(\'init\',\'O_term_update_db\');
?>
此函数引用函数中的数据库：
。php
<?php
function O_taxonomy_filter_by_order($taxonomy){
global $wpdb;
$terms = $wpdb->get_results("
SELECT t.*, tt.*
FROM ".$wpdb->prefix."term_taxonomy AS tt
JOIN ".$wpdb->prefix."terms AS t
ON t.term_id = tt.term_id
WHERE tt.taxonomy = \'".$taxonomy."\'
ORDER BY tt.term_order ASC
",ARRAY_A);
return $terms;
}
?>
此函数用于通过函数中的Ajax更新表。php
<?php
if(!function_exists(\'O_updating_data_term_reorder\')){
function O_updating_data_term_reorder() {
check_ajax_referer(\'o-nonce\', \'security\');
global $wpdb;
$terms_ID = $_POST[\'each_term\'];
$new_order = 0;
foreach($terms_ID as $key => $ID):
$term_ID = $ID[\'term\'];
$new_order++;
$result = $wpdb->update($wpdb->prefix.\'term_taxonomy\', array(\'term_order\' => $new_order), array(\'term_id\' => $term_ID));
if(is_wp_error($result)) {
echo json_encode(array(\'save\'=>false, \'message\'=> \'ERROR: \'.$result->get_error_message()));
exit();
}
endforeach;
echo json_encode(array(\'save\'=>true, \'count\'=>$new_order));
die();
}
add_action( \'wp_ajax_o_update_term_reorder\', \'O_updating_data_term_reorder\' );
}
?>
可拖动ajax。js公司：
(function($) {
"use strict";
//jQuery Sortable is required http://api.jqueryui.com/sortable/
//Call "wp_enqueue_script(\'jquery-ui-sortable\');" in your wp_enqueue_scripts
$(\'.js-draggable-items > .draggable-column\').sortable({
connectWith: \'.draggable-column\',
items: \'.draggable-item\',
dropOnEmpty: true,
opacity: .75,
handle: \'.draggable-handler\',
placeholder: \'draggable-placeholder\',
tolerance: \'pointer\',
start: function(e, ui){
ui.placeholder.css({
\'height\': ui.item.outerHeight(),
\'margin-bottom\': ui.item.css(\'margin-bottom\')
});
}
});
$(document).on( "click","#btn-reorder-terms", function() {
var each_term_list = [];
$(\'.draggable-item\').each(function(){
each_term_list.push({
term: $(this).attr(\'data-draggable-id\'),
});
});
var data = {
\'action\' : \'o_update_term_reorder\',
\'each_term\' : each_term_list,
\'security\' : actions_vars.nonce
};
$.ajax({
type: \'POST\',
dataType: \'json\',
cache: false,
url: actions_vars.ajaxurl,
data: data,
success: function(data) {
if(data.save === true){
//success message here
alert(\'Done\');
}else{
//error message here
alert(\'Something wrong\');
}
},
error: function(errorThrown) {
console.log(data);
}
});
});
})(jQuery);
在前端列表中，尝试以下操作：
<?php
$terms = O_taxonomy_filter_by_order(\'your_taxonomy\');
?>
<button type="button" class="btn btn-primary" id="btn-reorder-terms">Save</button>
<div class="col-md-12 js-draggable-items">
<div class="row draggable-column">
<?php
foreach($terms as $key => $term):
$ID = $term[\'term_id\'];
$name = $term[\'name\'];
$order = $term[\'term_order\'];
$description = $term[\'description\'];
$link = get_category_link($ID);
?>
<div class="draggable-item" data-draggable-id="<?php echo $ID;?>" data-term-order="<?php echo $order;?>">
<div class="col-md-2 draggable-handler"><i class="si si-cursor-move"></i></div>
<div class="col-md-10"><?php echo $name;?></div>
</div>
<?php
endforeach;
?>
<div>
<div>
