Php WooCommerce HPOS管理订单列表中带有订单元数据的定制列

Important note: WooCommerce HPOS要求所有WC订单元数据都已使用CRUD方法(而不是WordPress POST元函数)设置.只有与WooCommerce相关的setter方法才会填充HPOS使用的WooCommerce定制数据库表.

由于您使用的是WC Order自定义域和外部类/方法，因此我无法真正测试第二个函数中的代码.

现在，对于manage_woocommerce_page_wc-orders_custom_column钩子，两个可用的参数是$column和$order(但不是$order_id)，所以我修改了下面的代码:

public function source_medium_column( $columns ) {
    $columns['analytify_source'] = __('Source/Medium', 'wp-analytify-woocommerce');
    return $columns;
}

public function source_medium_value( $column, $order )
{
    if ($column === 'analytify_source') {

        // Check for the new meta key first
        $source = $order->get_meta('analytify_woo_order_source');

        if ( $source ) {
            echo $source; return;
        }

        // If the new meta key is not found, try the deprecated one
        $source_medium_deprecated = $order->get_meta('analytify_woo_single_source');

        if ( $source_medium_deprecated ) {
            echo $source_medium_deprecated; return;
        }

        // Fetch source/medium on request.
        if ( ! $source && isset($_GET['analytify_woo_fetch_sale_source']) ) {
            error_log('Fetching source/medium for order ' . $order->get_id());

            $date_created = $order->get_date_created()->format('Y-m-d');
            $start_date   = date('Y-m-d', strtotime($date_created . ' - 5 days'));
            $end_date     = date('Y-m-d', strtotime($date_created . ' + 5 days'));

            // Get sources from ga4.
            if (method_exists('WPANALYTIFY_Utils', 'get_ga_mode') && 'ga4' === WPANALYTIFY_Utils::get_ga_mode()) {
                $stats = $GLOBALS['WP_ANALYTIFY']->get_reports(
                    'analytify_woo_order_source',
                    array(),
                    array(
                        'start' => $start_date,
                        'end'   => $end_date
                    ),
                    array(
                        'sourceMedium',
                        'transactionId',
                    ),
                    array(),
                    array(
                        'logic' => 'AND',
                        'filters' => array(
                            array(
                                'type' => 'dimension',
                                'name' => 'transactionId',
                                'match_type' => 1,
                                'value'      => $order->get_id()
                            )
                        )
                    ),
                    0,
                    false
                );
                error_log('Stats: ' . print_r($stats, true));
                
                if (!empty($stats['rows'][0]['sourceMedium'])) {
                    $source = $stats['rows'][0]['sourceMedium'];
                    $order->update_meta_data('analytify_woo_order_source', $source);
                    $order->save();
                }
            } else {
                $stats = $GLOBALS['WP_ANALYTIFY']->pa_get_analytics_dashboard('ga:totalEvents', $start_date, $end_date, 'ga:sourceMedium,ga:eventCategory,ga:eventLabel', false, 'ga:eventCategory==analytify_orders;ga:eventAction==order_created;ga:eventLabel==' . $order->get_id());

                if (isset($stats['rows'][0][0])) {
                    $source = $stats['rows'][0][0];
                    $order->update_meta_data('analytify_woo_order_source', $source);
                    $order->save();
                }
            }
        }
        error_log('Final source: ' . $source);
        echo $source;
    }
}

并保持以下内容不变:

add_filter('manage_woocommerce_page_wc-orders_columns', array($this, 'source_medium_column'));
add_action('manage_woocommerce_page_wc-orders_custom_column', array($this, 'source_medium_value'), 10, 2);

它应该工作(untested).

相关:Add columns to admin orders list in WooCommerce (+ HPOS)