我想按自定義 ID 對用戶概覽列表中的管理列進行排序。為此，我添加了一個函數來對列進行排序，但它沒有按預期工作。它以一種奇怪的方式對字段進行排序。我想還有其他排序或函數有錯誤？！這是為用戶添加 ID 的代碼：add_action( 'edit_user_profile', 'wcv_store_custom_vendor_id', 0 );//add_action( 'wcv_admin_after_store_address', 'wcv_store_custom_vendor_id' );function wcv_store_custom_vendor_id( $user ) {?> <table class="form-table"> <tbody> <tr> <th><label for="_wcv_custom_vendor_id"><?php _e( 'Vendor ID', 'wcvendors-pro' ); ?></label></th> <td><input type="text" name="_wcv_custom_vendor_id" id="_wcv_custom_vendor_id" value="<?php echo get_user_meta( $user->ID, '_wcv_custom_vendor_id', true ); ?>" class="regular-text"></td> </tr> </tbody> </table><?php}// Save the details on the back end when updating the useradd_action( 'wcvendors_update_admin_user', 'save_wcv_custom_vendor_id' );function save_wcv_custom_vendor_id( $user_id ){ if ( isset( $_POST['_wcv_custom_vendor_id'] ) ) { update_user_meta( $user_id, '_wcv_custom_vendor_id', $_POST['_wcv_custom_vendor_id'] ); }這是我到目前為止所擁有的：// Add column to adminadd_action('manage_users_columns', 'add_custom_vendor_id_column', 10, 1 );function add_custom_vendor_id_column( $columns ) { $columns['wcv_custom_vendor_id'] = __('Vendor-ID'); return $columns;}// fetching the status, thanks to LoicTheAztecadd_filter('manage_users_custom_column', 'add_data_to_vendor_id_column', 10, 3);function add_data_to_vendor_id_column( $value, $column_name, $user_id ) { if ( 'wcv_custom_vendor_id' == $column_name ) { if( get_user_meta( $user_id, '_wcv_custom_vendor_id', true ) != '' ) { $value = '<span style="color:green;font-weight:bold;">'.get_user_meta( $user_id, '_wcv_custom_vendor_id', true ).'</span>'; } else { $value = '<span class="" style="color:red;font-weight:bold;">No ID!</span>'; } } return $value;}我檢查了很多片段，最后一個函數應該按數字排序。但我認為它根本沒有影響。有什么我想念的嗎？
1 回答
qq_花開花謝_0
TA貢獻1835條經驗 獲得超7個贊
pre_get_users反面使用request對于
meta_key我們使用以下的空值：update_user_meta( $user_id, '_wcv_custom_vendor_id', 0 );
所以你得到：
// Add column to admin
function add_custom_vendor_id_column( $columns ) {
$columns['wcv_custom_vendor_id'] = __( 'Vendor-ID', 'woocommerce');
return $columns;
}
add_action( 'manage_users_columns', 'add_custom_vendor_id_column', 10, 1 );
// fetching the status, thanks to LoicTheAztec
function add_data_to_vendor_id_column( $value, $column_name, $user_id ) {
if ( $column_name == 'wcv_custom_vendor_id' ) {
$vendor_id = (int) get_user_meta( $user_id, '_wcv_custom_vendor_id', true );
// If empty
if ( empty ($vendor_id ) ) {
update_user_meta( $user_id, '_wcv_custom_vendor_id', 0 );
}
if ( $vendor_id && $vendor_id != 0 ) {
$value .= '<span style="color:green;font-weight:bold;">' . $vendor_id . '</span>';
} else {
$value = '<span class="" style="color:red;font-weight:bold;">No ID!</span>';
}
}
return $value;
}
add_filter( 'manage_users_custom_column', 'add_data_to_vendor_id_column', 10, 3);
// make admin colum sortable
function fc_my_sortable_cake_column( $columns ) {
$columns['wcv_custom_vendor_id'] = __( 'Vendor-ID', 'woocommerce');
return $columns;
}
add_filter( 'manage_users_sortable_columns', 'fc_my_sortable_cake_column', 10, 1 );
// orderby
function action_pre_get_users( $query ) {
if ( !is_admin() )
return;
$orderby = $query->get('orderby');
if ( $orderby == 'Vendor-ID' ) {
$query->set( 'orderby' , 'meta_value_num' );
$query->set( 'meta_key', '_wcv_custom_vendor_id' );
}
}
add_action( 'pre_get_users', 'action_pre_get_users', 10, 1 );
- 1 回答
- 0 關注
- 138 瀏覽
添加回答
舉報
0/150
提交
取消