问覆盖WooCommerce筛选器中最低和最高价格的标准请求处理，以便从自定义字段中按价格获取产品

EN

add_action('woocommerce_product_query', 'min_max_price_handler');

function min_max_price_handler($q) {
    global $wpdb, $wp_query;

    if (! $wp_query->is_main_query() || ( ! isset($_GET['max_price']) && ! isset($_GET['min_price']))) {
        return;
    }

    // Remove default Woocommerce min/max price request handler
    remove_filter('posts_clauses', [WC()->query, 'price_filter_post_clauses'], 10);

    $current_min_price = isset($_GET['min_price']) ? floatval(wp_unslash($_GET['min_price'])) : 0;
    $current_max_price = isset($_GET['max_price']) ? floatval(wp_unslash($_GET['max_price'])) : PHP_INT_MAX;

    $sql = "SELECT DISTINCT product_id FROM wp_product_prices WHERE country=%s AND price >= %f AND price <= %f";

    $results = $wpdb->get_results(
        $wpdb->prepare(
            $sql,
            $customer_country,
            $current_min_price,
            $current_max_price
        ),
        ARRAY_A
    );

    $results = array_column($results, 'product_id');

    if (is_array($results)) {
        $q->set('post__in', $results);
    }
}