一个wordpress cronjob来取消删除产品的wc订单?

function get_order_ids_by_product_id( $product_id, $order_status = array( 'wc-completed' ) ){
    global $wpdb;
    $results = $wpdb->get_col("
        SELECT order_items.order_id
        FROM {$wpdb->prefix}woocommerce_order_items as order_items
        LEFT JOIN {$wpdb->prefix}woocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
        LEFT JOIN {$wpdb->posts} AS posts ON order_items.order_id = posts.ID
        WHERE posts.post_type = 'shop_order'
        AND posts.post_status NOT IN ( '" . implode( "','", $order_status ) . "' )
        AND order_items.order_item_type = 'line_item'
        AND order_item_meta.meta_key = '_product_id'
        AND order_item_meta.meta_value = '$product_id'
    ");
    return $results;
}

add_action( 'before_delete_post', 'check_for_active_orders' );
function check_for_active_orders($post_id){
    $WC_Product = wc_get_product( $post_id );
    $orders_ids = get_order_ids_by_product_id( $post_id );
    if(count($orders_ids) > 0){
      foreach($orders_ids as $oid){
        $order = new WC_Order($oid);
        $order->update_status('cancelled', 'This product has been removed.');
      }
    }
}