管理员用户列表基于Wordpress中的自定义用户元数据的自定义列显示 [英] Admin user list custom column display based on custom user metadata in Wordpress

问题描述

我为WordPress用户创建了一个自定义列，称为验证".在WooCommerce注册后，将向用户发送一封电子邮件，要求他们验证其电子邮件，并以此方式确认帐户.此信息作为meta_key存储在usermeta (wp_usermeta)下的数据库中，该密钥称为is_activated.

I have created a custom column for WordPress users called "Verification". Upon WooCommerce registration, an email is sent to the user asking them to verify their email and that way, account. This information is stored in the database under usermeta (wp_usermeta) as a meta_key and that key is called is_activated.

以下是自定义列的代码:

Here is the code for the custom column:

add_action('manage_users_columns','account_verification_status_column');
function account_verification_status_column($column_headers) {
  unset($column_headers['posts']);
  $column_headers['account_verification'] = 'Verification Status';
  return $column_headers;
}

function make_verification_status_column_sortable( $columns ) {
    $columns['account_verification'] = 'Verification Status';
    return $columns;
}
add_filter( 'manage_users_sortable_columns', 'make_verification_status_column_sortable' );

我现在试图弄清楚如何从usermeta表以及本例中的meta_key is_activated中获取数据.这是我尝试过的:

I am now trying to figure out how to fetch data from the usermeta table and in this case, the meta_key is_activated. Here is what I tried:

add_action('manage_users_custom_column', 'account_verification_information', 10, 3);
function account_verification_information($status = '1') {

    global $wpdb;
    $has_user_verified = $wpdb->get_var( $wpdb->prepare(
        "SELECT COUNT(*) FROM $wpdb->users
        LEFT JOIN $wpdb->usermeta ON $wpdb->users.ID = $wpdb->usermeta.user_id
        WHERE meta_key = 'is_activated'
        AND meta_value = '$status';"
    , $level ));

    return $has_user_verified;
    $check_verification = account_verification_information(1);

  if ( $column_name === account_verification ) {
            echo $check_verification;
            } else {
                echo '<span class="na">Not yet Verified</span>';
            }
    }

希望，通过查看它，您可以理解". 如果值是1，我需要显示已验证"，如果值是0，则需要显示未验证".

Hopefully, by looking at it, you "get the idea". I need it to show "Verified" if the value is 1 and "Not Verified" if the value is 0.

我尝试了很多不同的版本，我迷路了.

I've tried so many different versions of this I am getting lost..

我们非常感谢您的帮助.

Any help is highly appreciated.

推荐答案

请尝试以下操作:

add_action('manage_users_columns','account_verification_status_column');
function account_verification_status_column($column_headers) {
    unset($column_headers['posts']);

    $column_headers['account_verification'] = __('Verification Status');

    return $column_headers;
}

add_filter( 'manage_users_sortable_columns', 'make_verification_status_column_sortable' );
function make_verification_status_column_sortable( $vars ) {
    $columns['account_verification'] = 'account_verification';

    return $columns;
}

add_filter('manage_users_custom_column',  'add_user_column_value', 10, 3);
function add_user_column_value( $value, $column_name, $user_id ){
    if ( 'account_verification' == $column_name ){
        if( get_user_meta( $user_id, 'is_activated', true ) == 1 ){
            $value = '<span style="color:green;font-weight:bold;">Verified</span>';
        } else {
            $value = '<span class="na" style="color:grey;"><em>Not Verified</em></span>';
        }
    }

    return $value;
}

代码进入您的活动子主题(活动主题)的function.php文件中.经过测试，可以正常工作.

Code goes in function.php file of your active child theme (active theme). Tested and works.

这篇关于管理员用户列表基于Wordpress中的自定义用户元数据的自定义列显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！