Php 添加不存在的订单元数据以扩展WooCommerce管理订单搜索

在我之前的问题之后，我有一个问题:Allow search using billing email in WooCommerce Admin Orders list

以下是我将邮箱和邮箱显示为MD5、电话号码和支付网关名称的代码:

add_filter( 'manage_edit-shop_order_columns', 'add_custom_columns_to_admin_orders', 20);
function add_custom_columns_to_admin_orders( $columns ) {
    $new_columns = array();
    foreach ( $columns as $column_name => $column_info ) {
        $new_columns[ $column_name ] = $column_info;

        if ( 'order_total' === $column_name ) {
            $new_columns['order_md5_email'] = __( 'MD5 Email Address', 'my-textdomain' );
            $new_columns['order_email'] = __( 'Email Address', 'my-textdomain' );
            $new_columns['order_customers_phone'] = __( 'Customers Phone', 'my-textdomain' );
            $new_columns['order_payment'] = __( 'Payment Method', 'my-textdomain' );
        }
    }
    return $new_columns;
}


add_action( 'manage_shop_order_posts_custom_column', 'custom_columns_content_in_admin_orders' );
function custom_columns_content_in_admin_orders( $column ) {
    global $post, $the_order;
    if ( 'order_md5_email' === $column ) {
        if ( $the_order->has_status( array('completed') ) ) {
            $email_address = $the_order->get_billing_email();
            $email_address = md5($email_address);
            echo '<span class="order_complete"> '.$email_address.' </span>';
        } else {
            echo '<span class="order_not_complete">This Order is Not Completed!</span>';
        }
    }
    
    if ( 'order_email' === $column ) {
        if ( $the_order->has_status( array('completed') ) ) {
            $email_address = $the_order->get_billing_email();
            echo '<span class="order_complete"> '.$email_address.' </span>';
        } else {
            echo '<span class="order_not_complete">This Order is Not Completed!</span>';
        }
    }
    
    if ( 'order_customers_phone' === $column ) {
        echo '<label for="billing_phone" class="label-billing-email">Customer Phone Number:  </label>';
        echo '<input type="text" name="billing_phone" value="' . $the_order->get_billing_phone() . '" readonly />';
    }
    
    if ( 'order_payment' === $column ) {
        echo $the_order->get_payment_method_title();
    }
}

此代码还用于过滤管理订单页面上的搜索:

add_filter( 'woocommerce_shop_order_search_fields', 'extending_admin_orders_search_field', 10, 1 );
function extending_admin_orders_search_field( $meta_keys ){
    $meta_keys[] = '_billing_email';
    $meta_keys[] = '_billing_phone';
    $meta_keys[] = '_payment_method_title';

    return $meta_keys;
}

现在我遇到的问题是，当我在管理订单页面中搜索值时，如果我搜索邮箱的MD5，它将显示在结果中，就像简单的电话号码和邮箱以及支付网关的名称一样，显示没有任何问题.

我认为以下两种方法都是适用的:

1. 在创建搜索筛选器之前，使用邮箱并生成MD5或我想要的更改(例如，此部分$meta_keys[] = '_billing_email';应更改为此值==&gt；$meta_keys[] = md5('_billing_email');).
2. 保存自定义元数据，然后在搜索过滤器中调用此自定义元数据，就像亲爱的杰克在回答我的问题时给出的电话号码、邮箱地址和支付网关的名称一样.

如果你能在这两种情况下给我指点，并举个例子，我将不胜感激.