首页 文章

更改定制订单状态更改中的Woocommerce预订状态

提问于
浏览
0

我有一些自定义订单状态(使用WooCommerce订单状态管理器) . 但是,当我使用自定义付费状态时,预订状态不会更新为“已付款” . 我拼凑了一些来自各种引用的代码,但它会导致致命的错误 . 或者也许我错过了一些自定义状态应该更新预订付费状态而无需额外代码的东西?

我的代码:

add_action('woocommerce_order_status_pool-payment-rec','auto_change_booking_status_to_paid', 10, 1);
function auto_change_booking_status_to_paid($booking_id) {
    $booking = new WC_Booking( $booking_id );
    $order_id = $booking->get_order_id();
    $booking->update_status('paid', 'order_note');
    exit;
}

错误:

[20-Mar-2018 23:32:05 UTC] PHP Fatal error:  Uncaught Exception: Invalid booking. in /home/ahbc/public_html/wp-content/plugins/woocommerce-bookings/includes/data-stores/class-wc-booking-data-store.php:83
Stack trace:
#0 /home/ahbc/public_html/wp-content/plugins/woocommerce/includes/class-wc-data-store.php(149): WC_Booking_Data_Store->read(Object(WC_Booking))
#1 /home/ahbc/public_html/wp-content/plugins/woocommerce-bookings/includes/data-objects/class-wc-booking.php(149): WC_Data_Store->read(Object(WC_Booking))
#2 /home/ahbc/public_html/wp-content/plugins/ahbc-website-tweaks/ahbc-website-tweaks.php(104): WC_Booking->__construct(2223)
#3 /home/ahbc/public_html/wp-includes/class-wp-hook.php(288): auto_change_booking_status_to_paid(2223)
#4 /home/ahbc/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
#5 /home/ahbc/public_html/wp-includes/plugin.php(453): WP_Hook->do_action(Array)
#6 /home/ahbc/public_html/wp-content/plugins/woocommerce/includes/class-wc-order.php(327): do_action('woocommerce_ord...', 2223, Object(WC_Order))
# in /home/ahbc/public_html/wp-content/plugins/woocommerce-bookings/includes/data-stores/class-wc-booking-data-store.php on line 83

我也试过这个,但它似乎什么也没做:

function sv_wc_order_statuses_needs_payment( $statuses, $order ) {
    // use your custom order status slug here
    $statuses[] = 'pool-payment-rec';
    return $statuses;
}
add_filter( 'woocommerce_valid_order_statuses_for_payment_complete', 'sv_wc_order_statuses_needs_payment', 10, 2 );

我的推荐:

woocommerce booking status changes woocommerce order status

Change Woocommerce order status for Cash on delivery

https://gist.github.com/bekarice/e922e79bc40eb0729095abc561cfe621

编辑:还尝试了以下几种变化:

add_action( 'woocommerce_order_status_changed', 'auto_change_booking_status_to_paid' );

function auto_change_booking_status_to_paid( $order_id ) {
    if( ! $order_id ) return;   

    $order = wc_get_order($order_id);
    $booking = get_wc_booking($booking_id);

    if( $order->get_status() == 'test' )
//  $order_id = $booking->get_order_id();
    $booking->update_status('confirmed', 'order_note');
}

2 回答

  • 1

    好的,这里的解决方案不需要任何自定义书面查询,而是使用WooCommerce Booking插件中提供的相应方法 .

    add_action('woocommerce_order_status_pool-payment-rec', 'auto_change_booking_status_to_paid', 20, 2 );
    
    function auto_change_booking_status_to_paid( $order_id, $order ) {
    
        if( $order->get_status() === 'pool-payment-rec' ) {
            foreach( $order->get_items() as $item_id => $item ) {
                $product = wc_get_product($item['product_id']);
                if( $product->get_type() === 'booking' ) {
                    $booking_ids = WC_Booking_Data_Store::get_booking_ids_from_order_item_id( $item_id );
    
                    foreach( $booking_ids as $booking_id ) {
                        $booking = new WC_Booking($booking_id);
    
                        if( $booking->get_status() != 'paid' )
                            $booking->update_status( 'paid', 'order_note' );
                    }
    
                }
            }
        }
    }
    
  • 0

    你需要 get first the Booking ID from the order ID 在这个钩子里 . 然后,您将能够将预订状态更新为'paid'而不会出现任何错误 .

    我已经测试了另一个自定义状态而不是自定义状态,它可以工作......如果我使用你的代码,我会得到与你相同的错误 .

    在下面的代码中,我使用一个非常轻的查询来从订单ID获取预订ID,就像 WC_Order 方法一样...

    代码:

    // Utility function to get the booking ID from the Order ID
    function get_The_booking_id( $order_id ){
        global $wpdb;
        return $wpdb->get_var("SELECT ID FROM {$wpdb->prefix}posts WHERE post_parent = '$order_id'");
    }
    
    // On custom order status change, update booking status to "paid"
    add_action('woocommerce_order_status_pool-payment-rec', 'auto_change_booking_status_to_paid', 20, 2 );
    function auto_change_booking_status_to_paid( $order_id, $order ) {
    
        // Get the booking ID from the order ID
        $booking_id = get_The_booking_id( $order_id );
    
        if( empty($booking_id) )
            return; // Exit
    
        // Get an instance of the WC_Booking object
        $booking = new WC_Booking( $booking_id );
    
        // Update status
        if( $booking->get_status() != 'paid' )
            $booking->update_status( 'paid', 'order_note' );
    }
    

    代码位于活动子主题(或主题)的function.php文件中 . 经过测试和工作 .

相关问题