WooCommerce：完成一定数量的订单或一个订单中的最低金额后自动更改用户角色

Question

我想在之后自动将用户角色更改为高级用户角色3已完成订单一笔订单消费满500现金我在互联网上找到了这两个代码片段：function change_privategroup_on_purchase( $order_id ) {$order = new WC_Order( $order_id );$items = $order->get_items();foreach ( $items as $item ) {    $product_name = $item['name'];    $product_id = $item['product_id'];    $product_variation_id = $item['variation_id'];    if ( $order->user_id > 0 ) {              // Insert the Product IDs Here. If Multiple Products seperate by ||      if ( $product_id == '7026' || $product_id == '7027' || $product_id == '7028' || $product_id == '7029') {                  // Mention the group number below. Here it is group1.                  update_user_meta( $order->user_id, 'private_group', 'group1');      }    }}}add_action( 'woocommerce_order_status_processing', 'change_privategroup_on_purchase' );这是访问订单历史记录的一个：function has_bought() {    // Get all customer orders    $customer_orders = get_posts( array(        'numberposts' => 3, // one order is enough        'meta_key'    => '_customer_user',        'meta_value'  => get_current_user_id(),        'post_type'   => 'shop_order', // WC orders post type        'post_status' => 'wc-completed', // Only orders with "completed" status        'fields'      => 'ids', // Return Ids "completed"    ) );    // return "true" when customer has already at least one order (false if not)   return count($customer_orders) > 3 ?  true : false; }我如何调整它们以使其发挥作用？

Answer 1

• 获取by数量的自定义函数completed orders是user id基于get_order_count( &$customer );

• 
  

/**

 * Return the number of orders this customer has.

 *

 * @since 3.0.0

 * @param WC_Customer $customer Customer object.

 * @return integer

 */

public function get_order_count( &$customer ) {

    $count = get_user_meta( $customer->get_id(), '_order_count', true );

    if ( '' === $count ) {

        global $wpdb;

        $count = $wpdb->get_var(

            // phpcs:disable WordPress.DB.PreparedSQL.NotPrepared

            "SELECT COUNT(*)

            FROM $wpdb->posts as posts

            LEFT JOIN {$wpdb->postmeta} AS meta ON posts.ID = meta.post_id

            WHERE   meta.meta_key = '_customer_user'

            AND     posts.post_type = 'shop_order'

            AND     posts.post_status IN ( '" . implode( "','", array_map( 'esc_sql', array_keys( wc_get_order_statuses() ) ) ) . "' )

            AND     meta_value = '" . esc_sql( $customer->get_id() ) . "'"

            // phpcs:enable

        );

        update_user_meta( $customer->get_id(), '_order_count', $count );

    }

    return absint( $count );

}

所以我们得到

• 条件可以通过设置进行调整

• usermeta 表中使用了一个标志，因此如果一个人已经是高级会员，则整个代码不会不必要地重新运行

• woocommerce_order_status_completed使用钩子 - 此钩子在 Woocommerce 订单完成后更改字段值

• 通过代码中添加的注释进行解释

// Based on https://github.com/woocommerce/woocommerce/blob/85a077b939b44500fc01b68d34e711117545f586/includes/data-stores/class-wc-customer-data-store.php#L349-L377

function total_completed_orders( $the_user_id ) {

    global $wpdb;

    

    $count = $wpdb->get_var(

        // phpcs:disable WordPress.DB.PreparedSQL.NotPrepared

        "SELECT COUNT(*)

        FROM $wpdb->posts as posts

        LEFT JOIN {$wpdb->postmeta} AS meta ON posts.ID = meta.post_id

        WHERE   meta.meta_key = '_customer_user'

        AND     posts.post_type = 'shop_order'

        AND     posts.post_status = 'wc-completed'

        AND     meta_value = '" . esc_sql( $the_user_id ) . "'"

        // phpcs:enable

    );

    // Return a boolean value based on orders count

    return $count;

}

function action_woocommerce_order_status_completed( $order_id ) {

    /*** Settings ***/

    

    // User role in which the customer role must be changed

    $premium_user_role = 'premium';

    

    // Spending min cash in one order

    $min_in_one_order = 500;

    

    // Change role after x completed orders

    $change_role_after_x_completed_orders = 3;

    

    /*** End settings ***/

    

    $flag = false;

    

    // Get an instance of the WC_Order object

    $order = wc_get_order( $order_id );

    

    // Is a order

    if( is_a( $order, 'WC_Order' ) ) {

        // Get user ID or $order->get_customer_id();

        $user_id = $order->get_user_id();

        

        // Retrieve user meta field for a user. 

        $is_premium = get_user_meta( $user_id, '_customer_is_premium_member', true );

        

        // Is NOT a premium member

        if ( $is_premium != 1 ) {

            // Count total completed orders

            $total_completed_orders = total_completed_orders( $user_id );

            

            // Total completed orders greater than or equal to change role after x completed orders

            if ( $total_completed_orders >= $change_role_after_x_completed_orders ) {

                $flag = true;

            } else {

                // Get current order total

                $order_total = $order->get_total();

                

                // Order total greater than or equal to minimum in one order

                if ( $order_total >= $min_in_one_order ) {

                    $flag = true;

                }

            }

            

            // True, at least 1 condition has been met

            if ( $flag ) {

                // Get the user object

                $user = get_userdata( $user_id );

                // Get all the user roles as an array.

                $user_roles = $user->roles;

                

                // User role contains 'customer'

                if ( in_array( 'customer', $user_roles ) ) {

                    // Remove customer role

                    $user->remove_role( 'customer' );

                    

                    // Add premium role

                    $user->add_role( $premium_user_role );

                    

                    // Update user meta field based on user ID, set true

                    update_user_meta( $user_id, '_customer_is_premium_member', 1 );

                }

            }

        }

    }

}

add_action( 'woocommerce_order_status_completed', 'action_woocommerce_order_status_completed', 10, 1 );