文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >Woocommerce、Multisite、global search如何开发ajax功能？

问Woocommerce、Multisite、global search如何开发ajax功能？
EN

WordPress Development用户
提问于 2020-05-08 06:29:28
回答 2查看 458关注 0票数 0

我创建了一个多站点电子商务的安装，以区分男女部门。然而，经常发生的情况是，在男性部门，他们从事与女性文章相关的研究，反之亦然。因此，我的网站说它找不到一篇文章，显然不是这样。如何实现全局搜索功能？我在粘贴的这个函数上尝试了使用switch_to_blog，不幸的是，我无法实现它。有人能帮我吗？这是我的代码-- tried...but死掉了，它是否停止工作，只在站点1...any的想法上工作？提前感谢

代码语言：javascript
复制
 switch_to_blog(1);
    $results = new WP_Query( apply_filters( 'basel_ajax_search_args', $query_args ) );

    if ( basel_get_opt( 'relevanssi_search' ) && function_exists( 'relevanssi_do_query' ) ) {
        relevanssi_do_query( $results );
    }

    $suggestions = array();

    if ( $results->have_posts() ) {

        if ( $post_type == 'product' && basel_woocommerce_installed() ) {
            $factory = new WC_Product_Factory();
        }

        while ( $results->have_posts() ) {
            $results->the_post();

            if ( $post_type == 'product' && basel_woocommerce_installed() ) {
                $product = $factory->get_product( get_the_ID() );

                $suggestions[] = array(
                    'value' => get_the_title(),
                    'permalink' => get_the_permalink(),
                    'price' => $product->get_price_html(),
                    'thumbnail' => $product->get_image(),
                    'sku' => $product->get_sku() ? esc_html__( 'SKU:', 'basel' ) . ' ' . $product->get_sku() : '',
                );
            } else {
                $suggestions[] = array(
                    'value' => get_the_title(),
                    'permalink' => get_the_permalink(),
                    'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                );
            }
        }

        wp_reset_postdata();
        restore_current_blog();
    } else {
        $suggestions[] = array(
            'value' => ( $post_type == 'product' ) ? esc_html__( 'No products found', 'basel' ) : esc_html__( 'No posts found', 'basel' ),
            'no_found' => true,
            'permalink' => ''
        );
    }

    switch_to_blog(2);
    $results = new WP_Query( apply_filters( 'basel_ajax_search_args', $query_args ) );

    if ( basel_get_opt( 'relevanssi_search' ) && function_exists( 'relevanssi_do_query' ) ) {
        relevanssi_do_query( $results );
    }

    //$suggestions = array();

    if ( $results->have_posts() ) {

        if ( $post_type == 'product' && basel_woocommerce_installed() ) {
            $factory = new WC_Product_Factory();
        }

        while ( $results->have_posts() ) {
            $results->the_post();

            if ( $post_type == 'product' && basel_woocommerce_installed() ) {
                $product = $factory->get_product( get_the_ID() );

                $suggestions[] = array(
                    'value' => get_the_title(),
                    'permalink' => get_the_permalink(),
                    'price' => $product->get_price_html(),
                    'thumbnail' => $product->get_image(),
                    'sku' => $product->get_sku() ? esc_html__( 'SKU:', 'basel' ) . ' ' . $product->get_sku() : '',
                );
            } else {
                $suggestions[] = array(
                    'value' => get_the_title(),
                    'permalink' => get_the_permalink(),
                    'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                );
            }
        }

        wp_reset_postdata();
        restore_current_blog();
    } else {
        $suggestions[] = array(
            'value' => ( $post_type == 'product' ) ? esc_html__( 'No products found', 'basel' ) : esc_html__( 'No posts found', 'basel' ),
            'no_found' => true,
            'permalink' => ''
        );
    }

     //$my_array2 = array('suggestions' => $suggestions);
     //$my_array1 = array('suggestions' => $suggestions1);
     //$res = array_merge($my_array2, $my_array1); 
    // echo json_encode($res);
    echo json_encode(array('suggestions' => $suggestions));

die(); 
}
ajax
search
globals
woocommerce-offtopic
EN

回答 2

WordPress Development用户

发布于 2020-05-15 10:36:51

新在stackexchange，我不能评论，直到我有50个声誉。

我们是同一主题开发人员。我发现这个主题可以帮你。我正在测试它- WooCommerce多站点全局搜索。但这两个网站都是新安装的产品数据(名称、价格、相同的产品类别、相同的主题)。你可以试试。

OPTION 1

在这条线之前

代码语言：javascript
复制
$results = new WP_Query( apply_filters( 'basel_ajax_search_args', $query_args ) );

添加

代码语言：javascript
复制
// in this variable you can pass all the blog IDs you would like to display posts from
$blog_ids = array( 1, 2, 3, 4, 5 );

foreach( $blog_ids as $id ) {

    switch_to_blog( $id );

和

在这行之后

代码语言：javascript
复制
wp_reset_postdata();

添加

代码语言：javascript
复制
        restore_current_blog();

和

在这2行之后

代码语言：javascript
复制
die();

}

添加

}

在尝试之前，尝试使用本地主机或暂存<>或备份您的网站。

我正在我的主题search.php中尝试它

代码语言：javascript
复制
/**
 * ------------------------------------------------------------------------------------------------
 * Ajax search
 * ------------------------------------------------------------------------------------------------
 */
if ( ! function_exists( 'woodmart_init_search_by_sku' ) ) {
    function woodmart_init_search_by_sku() {
        if ( apply_filters( 'woodmart_search_by_sku', woodmart_get_opt( 'search_by_sku' ) ) && woodmart_woocommerce_installed() ) {
            add_filter( 'posts_search', 'woodmart_product_search_sku', 9 );
        }
    }

    add_action( 'init', 'woodmart_init_search_by_sku', 10 );
}

if ( ! function_exists( 'woodmart_ajax_suggestions' ) ) {
    function woodmart_ajax_suggestions() {

        $allowed_types = array( 'post', 'product', 'portfolio' );
        $post_type = 'product';

        if ( apply_filters( 'woodmart_search_by_sku', woodmart_get_opt( 'search_by_sku' ) ) && woodmart_woocommerce_installed() ) {
            add_filter( 'posts_search', 'woodmart_product_ajax_search_sku', 10 );
        }

        $query_args = array(
            'posts_per_page' => 5,
            'post_status'    => 'publish',
            'post_type'      => $post_type,
            'no_found_rows'  => 1,
        );

        if ( ! empty( $_REQUEST['post_type'] ) && in_array( $_REQUEST['post_type'], $allowed_types ) ) {
            $post_type = strip_tags( $_REQUEST['post_type'] );
            $query_args['post_type'] = $post_type;
        }

        if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {

            $product_visibility_term_ids = wc_get_product_visibility_term_ids();
            $query_args['tax_query'][] = array(
                'taxonomy' => 'product_visibility',
                'field'    => 'term_taxonomy_id',
                'terms'    => $product_visibility_term_ids['exclude-from-search'],
                'operator' => 'NOT IN',
            );

            if ( ! empty( $_REQUEST['product_cat'] ) ) {
                $query_args['product_cat'] = strip_tags( $_REQUEST['product_cat'] );
            }
        }

        if ( 'yes' === get_option( 'woocommerce_hide_out_of_stock_items' ) && $post_type == 'product' ) {
            $query_args['meta_query'][] = array( 'key' => '_stock_status', 'value' => 'outofstock', 'compare' => 'NOT IN' );
        }

        if ( ! empty( $_REQUEST['query'] ) ) {
            $query_args['s'] = sanitize_text_field( $_REQUEST['query'] );
        }

        if ( ! empty( $_REQUEST['number'] ) ) {
            $query_args['posts_per_page'] = (int) $_REQUEST['number'];
        }

        $blog_ids = array( 1, 2, 3, 4, 5, 6, 7, 8, 9 );

        foreach( $blog_ids as $id ) {

            switch_to_blog( $id );


        $results = new WP_Query( apply_filters( 'woodmart_ajax_search_args', $query_args ) );

        if ( woodmart_get_opt( 'relevanssi_search' ) && function_exists( 'relevanssi_do_query' ) ) {
            relevanssi_do_query( $results );
        }

        $suggestions = array();

        if ( $results->have_posts() ) {

            if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {
                $factory = new WC_Product_Factory();
            }

            while ( $results->have_posts() ) {
                $results->the_post();

                if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {
                    $product = $factory->get_product( get_the_ID() );

                    $suggestions[] = array(
                        'value' => html_entity_decode( get_the_title() ),
                        'permalink' => get_the_permalink(),
                        'price' => $product->get_price_html(),
                        'thumbnail' => $product->get_image(),
                        'sku' => $product->get_sku() ? esc_html__( 'SKU:', 'woodmart' ) . ' ' . $product->get_sku() : '',
                    );
                } else {
                    $suggestions[] = array(
                        'value' => html_entity_decode( get_the_title() ),
                        'permalink' => get_the_permalink(),
                        'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                    );
                }
            }

            wp_reset_postdata();

                restore_current_blog();

        } else {
            $suggestions[] = array(
                'value' => ( $post_type == 'product' ) ? esc_html__( 'No products found', 'woodmart' ) : esc_html__( 'No posts found', 'woodmart' ),
                'no_found' => true,
                'permalink' => ''
            );
        }

        if ( woodmart_get_opt( 'enqueue_posts_results' ) && 'post' !== $post_type ) {
            $post_suggestions = woodmart_get_post_suggestions();
            $suggestions = array_merge( $suggestions, $post_suggestions );
        }

        echo json_encode( array(
            'suggestions' => $suggestions,
        ) );

        die();
    }
    }

    add_action( 'wp_ajax_woodmart_ajax_search', 'woodmart_ajax_suggestions', 10 );
    add_action( 'wp_ajax_nopriv_woodmart_ajax_search', 'woodmart_ajax_suggestions', 10 );
}

if ( ! function_exists( 'woodmart_get_post_suggestions' ) ) {
    function woodmart_get_post_suggestions() {
        $query_args = array(
            'posts_per_page' => 5,
            'post_status'    => 'publish',
            'post_type'      => 'post',
            'no_found_rows'  => 1,
        );

        if ( ! empty( $_REQUEST['query'] ) ) {
            $query_args['s'] = sanitize_text_field( $_REQUEST['query'] );
        }

        if ( ! empty( $_REQUEST['number'] ) ) {
            $query_args['posts_per_page'] = (int) $_REQUEST['number'];
        }

        $blog_ids = array( 1, 2, 3, 4, 5, 6, 7, 8, 9 );

        foreach( $blog_ids as $id ) {

            switch_to_blog( $id );


        $results = new WP_Query( $query_args );
        $suggestions = array();

        if ( $results->have_posts() ) {

            $suggestions[] = array(
                'value' => '',
                'divider' => esc_html__( 'Results from blog', 'woodmart' ),
            );

            while ( $results->have_posts() ) {
                $results->the_post();

                $suggestions[] = array(
                    'value' => html_entity_decode( get_the_title() ),
                    'permalink' => get_the_permalink(),
                    'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                );
            }

            wp_reset_postdata();

                restore_current_blog();

                }

        }

        return $suggestions;
    }
}

if ( ! function_exists( 'woodmart_product_search_sku' ) ) {
    function woodmart_product_search_sku( $where, $class = false ) {
        global $pagenow, $wpdb, $wp;

        $type = array('product', 'jam');

        if ( ( is_admin() ) //if ((is_admin() && 'edit.php' != $pagenow) 
                || !is_search()  
                || !isset( $wp->query_vars['s'] ) 
                //post_types can also be arrays..
                || (isset( $wp->query_vars['post_type'] ) && 'product' != $wp->query_vars['post_type'] )
                || (isset( $wp->query_vars['post_type'] ) && is_array( $wp->query_vars['post_type'] ) && !in_array( 'product', $wp->query_vars['post_type'] ) ) 
                ) {
            return $where;
        }

        $s = $wp->query_vars['s'];

        //WC 3.6.0
        if ( function_exists( 'WC' ) && version_compare( WC()->version, '3.6.0', '<' ) ) {
            return woodmart_sku_search_query( $where, $s );
        } else {
            return woodmart_sku_search_query_new( $where, $s );
        }
    }
}

if ( ! function_exists( 'woodmart_product_ajax_search_sku' ) ) {
    function woodmart_product_ajax_search_sku( $where ) {
        if ( ! empty( $_REQUEST['query'] ) ) {
            $s = sanitize_text_field( $_REQUEST['query'] );

            //WC 3.6.0
            if ( function_exists( 'WC' ) && version_compare( WC()->version, '3.6.0', '<' ) ) {
                return woodmart_sku_search_query( $where, $s );
            } else {
                return woodmart_sku_search_query_new( $where, $s );
            }
        }

        return $where;
    }
}

if ( ! function_exists( 'woodmart_sku_search_query' ) ) {
    function woodmart_sku_search_query( $where, $s ) {
        global $wpdb;

        $search_ids = array();
        $terms = explode( ',', $s );

        foreach ( $terms as $term ) {
            //Include the search by id if admin area.
            if ( is_admin() && is_numeric( $term ) ) {
                $search_ids[] = $term;
            }
            // search for variations with a matching sku and return the parent.

            $sku_to_parent_id = $wpdb->get_col( $wpdb->prepare( "SELECT p.post_parent as post_id FROM {$wpdb->posts} as p join {$wpdb->postmeta} pm on p.ID = pm.post_id and pm.meta_key='_sku' and pm.meta_value LIKE '%%%s%%' where p.post_parent <> 0 group by p.post_parent", wc_clean( $term ) ) );

            //Search for a regular product that matches the sku.
            $sku_to_id = $wpdb->get_col( $wpdb->prepare( "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key='_sku' AND meta_value LIKE '%%%s%%';", wc_clean( $term ) ) );

            $search_ids = array_merge( $search_ids, $sku_to_id, $sku_to_parent_id );
        }

        $search_ids = array_filter( array_map( 'absint', $search_ids ) );

        if ( sizeof( $search_ids ) > 0 ) {
            $where = str_replace( ')))', ") OR ({$wpdb->posts}.ID IN (" . implode( ',', $search_ids ) . "))))", $where );
        }

        #remove_filters_for_anonymous_class('posts_search', 'WC_Admin_Post_Types', 'product_search', 10);
        return $where;
    }
}

if ( ! function_exists( 'woodmart_sku_search_query_new' ) ) {
    function woodmart_sku_search_query_new( $where, $s ) {
        global $wpdb;

        $search_ids = array();
        $terms = explode( ',', $s );

        foreach ( $terms as $term ) {
            //Include the search by id if admin area.
            if ( is_admin() && is_numeric( $term ) ) {
                $search_ids[] = $term;
            }
            // search for variations with a matching sku and return the parent.

            $sku_to_parent_id = $wpdb->get_col( $wpdb->prepare( "SELECT p.post_parent as post_id FROM {$wpdb->posts} as p join {$wpdb->wc_product_meta_lookup} ml on p.ID = ml.product_id and ml.sku LIKE '%%%s%%' where p.post_parent <> 0 group by p.post_parent", wc_clean( $term ) ) );

            //Search for a regular product that matches the sku.
            $sku_to_id = $wpdb->get_col( $wpdb->prepare( "SELECT product_id FROM {$wpdb->wc_product_meta_lookup} WHERE sku LIKE '%%%s%%';", wc_clean( $term ) ) );

            $search_ids = array_merge( $search_ids, $sku_to_id, $sku_to_parent_id );
        }

        $search_ids = array_filter( array_map( 'absint', $search_ids ) );

        if ( sizeof( $search_ids ) > 0 ) {
            $where = str_replace( ')))', ") OR ({$wpdb->posts}.ID IN (" . implode( ',', $search_ids ) . "))))", $where );
        }

        #remove_filters_for_anonymous_class('posts_search', 'WC_Admin_Post_Types', 'product_search', 10);
        return $where;
    }
}

if ( ! function_exists( 'woodmart_rlv_index_variation_skus' ) ) {
    function woodmart_rlv_index_variation_skus( $content, $post ) {
        if ( ! woodmart_get_opt( 'search_by_sku' ) || ! woodmart_get_opt( 'relevanssi_search' ) || ! function_exists( 'relevanssi_do_query' ) ) {
            return $content;
        }

        if ( $post->post_type == 'product' ) {

            $args = array( 'post_parent' => $post->ID, 'post_type' => 'product_variation', 'posts_per_page' => -1 );
            $variations = get_posts( $args );
            if ( !empty( $variations)) {
                foreach ( $variations as $variation ) {
                    $sku = get_post_meta( $variation->ID, '_sku', true );
                    $content .= " $sku";
                }
            }
        }

        return $content;
    }

    add_filter( 'relevanssi_content_to_index', 'woodmart_rlv_index_variation_skus', 10, 2 );
}

OPTION 2

优质插件

希望能帮助^^

如果你成功了，请注意我。

票数 0
EN

WordPress Development用户

发布于 2020-05-20 10:49:18

Answer:工作过的ajax搜索建议

代码语言：javascript
复制
/**
 * ------------------------------------------------------------------------------------------------
 * Ajax search
 * ------------------------------------------------------------------------------------------------
 */
if ( ! function_exists( 'woodmart_init_search_by_sku' ) ) {
    function woodmart_init_search_by_sku() {
        if ( apply_filters( 'woodmart_search_by_sku', woodmart_get_opt( 'search_by_sku' ) ) && woodmart_woocommerce_installed() ) {
            add_filter( 'posts_search', 'woodmart_product_search_sku', 9 );
        }
    }

    add_action( 'init', 'woodmart_init_search_by_sku', 10 );
}

if ( ! function_exists( 'woodmart_ajax_suggestions' ) ) {
    function woodmart_ajax_suggestions() {

        $allowed_types = array( 'post', 'product', 'portfolio' );
        $post_type = 'product';

        if ( apply_filters( 'woodmart_search_by_sku', woodmart_get_opt( 'search_by_sku' ) ) && woodmart_woocommerce_installed() ) {
            add_filter( 'posts_search', 'woodmart_product_ajax_search_sku', 10 );
        }

        $query_args = array(
            'posts_per_page' => 5,
            'post_status'    => 'publish',
            'post_type'      => $post_type,
            'no_found_rows'  => 1,
        );

        if ( ! empty( $_REQUEST['post_type'] ) && in_array( $_REQUEST['post_type'], $allowed_types ) ) {
            $post_type = strip_tags( $_REQUEST['post_type'] );
            $query_args['post_type'] = $post_type;
        }

        if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {

            $product_visibility_term_ids = wc_get_product_visibility_term_ids();
            $query_args['tax_query'][] = array(
                'taxonomy' => 'product_visibility',
                'field'    => 'term_taxonomy_id',
                'terms'    => $product_visibility_term_ids['exclude-from-search'],
                'operator' => 'NOT IN',
            );

            if ( ! empty( $_REQUEST['product_cat'] ) ) {
                $query_args['product_cat'] = strip_tags( $_REQUEST['product_cat'] );
            }
        }

        if ( 'yes' === get_option( 'woocommerce_hide_out_of_stock_items' ) && $post_type == 'product' ) {
            $query_args['meta_query'][] = array( 'key' => '_stock_status', 'value' => 'outofstock', 'compare' => 'NOT IN' );
        }

        if ( ! empty( $_REQUEST['query'] ) ) {
            $query_args['s'] = sanitize_text_field( $_REQUEST['query'] );
        }

        if ( ! empty( $_REQUEST['number'] ) ) {
            $query_args['posts_per_page'] = (int) $_REQUEST['number'];
        }

// Blog 1
switch_to_blog(1);

        $results = new WP_Query( apply_filters( 'woodmart_ajax_search_args', $query_args ) );

        if ( woodmart_get_opt( 'relevanssi_search' ) && function_exists( 'relevanssi_do_query' ) ) {
            relevanssi_do_query( $results );
        }

        $suggestions = array();

        if ( $results->have_posts() ) {

            if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {
                $factory = new WC_Product_Factory();
            }

            while ( $results->have_posts() ) {
                $results->the_post();

                if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {
                    $product = $factory->get_product( get_the_ID() );

                    $suggestions[] = array(
                        'value' => html_entity_decode( get_the_title() ),
                        'permalink' => get_the_permalink(),
                        'price' => $product->get_price_html(),
                        'thumbnail' => $product->get_image(),
                        'sku' => $product->get_sku() ? esc_html__( 'SKU:', 'woodmart' ) . ' ' . $product->get_sku() : '',
                    );
                } else {
                    $suggestions[] = array(
                        'value' => html_entity_decode( get_the_title() ),
                        'permalink' => get_the_permalink(),
                        'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                    );
                }
            }

            wp_reset_postdata();
                restore_current_blog();
        } else {
            $suggestions[] = array(
                'value' => ( $post_type == 'product' ) ? esc_html__( 'No products found', 'woodmart' ) : esc_html__( 'No posts found', 'woodmart' ),
                'no_found' => true,
                'permalink' => ''
            );
        }

// Blog 2
switch_to_blog(2);

        $results = new WP_Query( apply_filters( 'woodmart_ajax_search_args', $query_args ) );

        if ( woodmart_get_opt( 'relevanssi_search' ) && function_exists( 'relevanssi_do_query' ) ) {
            relevanssi_do_query( $results );
        }

        $suggestions1 = array();

        if ( $results->have_posts() ) {

            if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {
                $factory = new WC_Product_Factory();
            }

            while ( $results->have_posts() ) {
                $results->the_post();

                if ( $post_type == 'product' && woodmart_woocommerce_installed() ) {
                    $product = $factory->get_product( get_the_ID() );

                    $suggestions[] = array(
                        'value' => html_entity_decode( get_the_title() ),
                        'permalink' => get_the_permalink(),
                        'price' => $product->get_price_html(),
                        'thumbnail' => $product->get_image(),
                        'sku' => $product->get_sku() ? esc_html__( 'SKU:', 'woodmart' ) . ' ' . $product->get_sku() : '',
                    );
                } else {
                    $suggestions[] = array(
                        'value' => html_entity_decode( get_the_title() ),
                        'permalink' => get_the_permalink(),
                        'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                    );
                }
            }

            wp_reset_postdata();
                restore_current_blog();
        } else {
            $suggestions[] = array(
                'value' => ( $post_type == 'product' ) ? esc_html__( 'No products found', 'woodmart' ) : esc_html__( 'No posts found', 'woodmart' ),
                'no_found' => true,
                'permalink' => ''
            );
        }

        if ( woodmart_get_opt( 'enqueue_posts_results' ) && 'post' !== $post_type ) {
            $post_suggestions = woodmart_get_post_suggestions();
            $suggestions = array_merge( $suggestions, $suggestion1, $post_suggestions );
        }

            echo json_encode(array('suggestions' => $suggestions
        ));

        die();
    }

    add_action( 'wp_ajax_woodmart_ajax_search', 'woodmart_ajax_suggestions', 10 );
    add_action( 'wp_ajax_nopriv_woodmart_ajax_search', 'woodmart_ajax_suggestions', 10 );
}

if ( ! function_exists( 'woodmart_get_post_suggestions' ) ) {
    function woodmart_get_post_suggestions() {
        $query_args = array(
            'posts_per_page' => 5,
            'post_status'    => 'publish',
            'post_type'      => 'post',
            'no_found_rows'  => 1,
        );

        if ( ! empty( $_REQUEST['query'] ) ) {
            $query_args['s'] = sanitize_text_field( $_REQUEST['query'] );
        }

        if ( ! empty( $_REQUEST['number'] ) ) {
            $query_args['posts_per_page'] = (int) $_REQUEST['number'];
        }

        $results = new WP_Query( $query_args );
        $suggestions = array();

        if ( $results->have_posts() ) {

            $suggestions[] = array(
                'value' => '',
                'divider' => esc_html__( 'Results from blog', 'woodmart' ),
            );

            while ( $results->have_posts() ) {
                $results->the_post();

                $suggestions[] = array(
                    'value' => html_entity_decode( get_the_title() ),
                    'permalink' => get_the_permalink(),
                    'thumbnail' => get_the_post_thumbnail( null, 'medium', '' ),
                );
            }

            wp_reset_postdata();
        }

        return $suggestions;
    }
}

if ( ! function_exists( 'woodmart_product_search_sku' ) ) {
    function woodmart_product_search_sku( $where, $class = false ) {
        global $pagenow, $wpdb, $wp;

        $type = array('product', 'jam');

        if ( ( is_admin() ) //if ((is_admin() && 'edit.php' != $pagenow) 
                || !is_search()  
                || !isset( $wp->query_vars['s'] ) 
                //post_types can also be arrays..
                || (isset( $wp->query_vars['post_type'] ) && 'product' != $wp->query_vars['post_type'] )
                || (isset( $wp->query_vars['post_type'] ) && is_array( $wp->query_vars['post_type'] ) && !in_array( 'product', $wp->query_vars['post_type'] ) ) 
                ) {
            return $where;
        }

        $s = $wp->query_vars['s'];

        //WC 3.6.0
        if ( function_exists( 'WC' ) && version_compare( WC()->version, '3.6.0', '<' ) ) {
            return woodmart_sku_search_query( $where, $s );
        } else {
            return woodmart_sku_search_query_new( $where, $s );
        }
    }
}

if ( ! function_exists( 'woodmart_product_ajax_search_sku' ) ) {
    function woodmart_product_ajax_search_sku( $where ) {
        if ( ! empty( $_REQUEST['query'] ) ) {
            $s = sanitize_text_field( $_REQUEST['query'] );

            //WC 3.6.0
            if ( function_exists( 'WC' ) && version_compare( WC()->version, '3.6.0', '<' ) ) {
                return woodmart_sku_search_query( $where, $s );
            } else {
                return woodmart_sku_search_query_new( $where, $s );
            }
        }

        return $where;
    }
}

if ( ! function_exists( 'woodmart_sku_search_query' ) ) {
    function woodmart_sku_search_query( $where, $s ) {
        global $wpdb;

        $search_ids = array();
        $terms = explode( ',', $s );

        foreach ( $terms as $term ) {
            //Include the search by id if admin area.
            if ( is_admin() && is_numeric( $term ) ) {
                $search_ids[] = $term;
            }
            // search for variations with a matching sku and return the parent.

            $sku_to_parent_id = $wpdb->get_col( $wpdb->prepare( "SELECT p.post_parent as post_id FROM {$wpdb->posts} as p join {$wpdb->postmeta} pm on p.ID = pm.post_id and pm.meta_key='_sku' and pm.meta_value LIKE '%%%s%%' where p.post_parent <> 0 group by p.post_parent", wc_clean( $term ) ) );

            //Search for a regular product that matches the sku.
            $sku_to_id = $wpdb->get_col( $wpdb->prepare( "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key='_sku' AND meta_value LIKE '%%%s%%';", wc_clean( $term ) ) );

            $search_ids = array_merge( $search_ids, $sku_to_id, $sku_to_parent_id );
        }

        $search_ids = array_filter( array_map( 'absint', $search_ids ) );

        if ( sizeof( $search_ids ) > 0 ) {
            $where = str_replace( ')))', ") OR ({$wpdb->posts}.ID IN (" . implode( ',', $search_ids ) . "))))", $where );
        }

        #remove_filters_for_anonymous_class('posts_search', 'WC_Admin_Post_Types', 'product_search', 10);
        return $where;
    }
}

if ( ! function_exists( 'woodmart_sku_search_query_new' ) ) {
    function woodmart_sku_search_query_new( $where, $s ) {
        global $wpdb;

        $search_ids = array();
        $terms = explode( ',', $s );

        foreach ( $terms as $term ) {
            //Include the search by id if admin area.
            if ( is_admin() && is_numeric( $term ) ) {
                $search_ids[] = $term;
            }
            // search for variations with a matching sku and return the parent.

            $sku_to_parent_id = $wpdb->get_col( $wpdb->prepare( "SELECT p.post_parent as post_id FROM {$wpdb->posts} as p join {$wpdb->wc_product_meta_lookup} ml on p.ID = ml.product_id and ml.sku LIKE '%%%s%%' where p.post_parent <> 0 group by p.post_parent", wc_clean( $term ) ) );

            //Search for a regular product that matches the sku.
            $sku_to_id = $wpdb->get_col( $wpdb->prepare( "SELECT product_id FROM {$wpdb->wc_product_meta_lookup} WHERE sku LIKE '%%%s%%';", wc_clean( $term ) ) );

            $search_ids = array_merge( $search_ids, $sku_to_id, $sku_to_parent_id );
        }

        $search_ids = array_filter( array_map( 'absint', $search_ids ) );

        if ( sizeof( $search_ids ) > 0 ) {
            $where = str_replace( ')))', ") OR ({$wpdb->posts}.ID IN (" . implode( ',', $search_ids ) . "))))", $where );
        }

        #remove_filters_for_anonymous_class('posts_search', 'WC_Admin_Post_Types', 'product_search', 10);
        return $where;
    }
}

if ( ! function_exists( 'woodmart_rlv_index_variation_skus' ) ) {
    function woodmart_rlv_index_variation_skus( $content, $post ) {
        if ( ! woodmart_get_opt( 'search_by_sku' ) || ! woodmart_get_opt( 'relevanssi_search' ) || ! function_exists( 'relevanssi_do_query' ) ) {
            return $content;
        }

        if ( $post->post_type == 'product' ) {

            $args = array( 'post_parent' => $post->ID, 'post_type' => 'product_variation', 'posts_per_page' => -1 );
            $variations = get_posts( $args );
            if ( !empty( $variations)) {
                foreach ( $variations as $variation ) {
                    $sku = get_post_meta( $variation->ID, '_sku', true );
                    $content .= " $sku";
                }
            }
        }

        return $content;
    }

    add_filter( 'relevanssi_content_to_index', 'woodmart_rlv_index_variation_skus', 10, 2 );
}
票数 0
EN
页面原文内容由WordPress Development提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://wordpress.stackexchange.com/questions/366125

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档