WooCommerce从类别ID获取产品图像


WooCommerce get product Image from Category ID

我整个周末都在为这个问题而挣扎,我已经读了100多篇文章/教程,但我似乎没有做好这件事。基本上,我有一个类别ID,我想在类别页面上获得该类别的随机图像。E.g我有一个类别Jumper(猫id 1),我想从猫id 1的帖子中获得一个随机图像。目前,我收到了数百张相同的图片。

这是我创建的代码:

$args = array(
    'posts_per_page' => 1,
    'post_type' => 'product',
    'tax_query'     => array(
        array(
            'taxonomy'  => 'product_cat',
            'field'     => 'id', 
            'terms'     => $category->term_id
        )
    )
);
$myposts = new WP_Query( $args );
foreach ( $myposts as $post ) : setup_postdata( $post );
         $image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' ); 
         //$image = wp_get_attachment_image_src($mypost->ID, 'woo-size-category');
         the_title();
         echo '<img src="' .esc_url($image[0]). '" alt="' . esc_attr($category->name).'"  />';
endforeach;

下面是整个内容-product_cat.php:

<?php
/**
 * The template for displaying product category thumbnails within loops.
 *
 * Override this template by copying it to yourtheme/woocommerce/content-product_cat.php
 *
 * @author      WooThemes
 * @package     WooCommerce/Templates
 * @version     1.6.4
 */
if (!defined('ABSPATH'))
    exit; // Exit if accessed directly
global $woocommerce_loop;
// Store loop count we're currently on
if (empty($woocommerce_loop['loop']))
    $woocommerce_loop['loop'] = 0;
// Increase loop count
$woocommerce_loop['loop'] ++;
$thumbnail_id = get_woocommerce_term_meta($category->term_id, 'thumbnail_id', true);
$cat = 'no_image';
if ($thumbnail_id) {
    $cat = 'has_image';
}
?>
<div class="product-category product col-lg-3 element <?php echo $cat; ?>">

    <a href="<?php echo get_term_link($category->slug, 'product_cat'); ?>">
        <?php
        /**
         * woocommerce_before_subcategory_title hook
         *
         * @hooked woocommerce_subcategory_thumbnail - 10
         */
        if ($thumbnail_id) {
            $image = wp_get_attachment_image_src($thumbnail_id, 'woo-size-category');
            echo '<img src="' . esc_url($image[0]) . '" alt="' . esc_attr($category->name) . '"  />';
        } else {

$args = array(
    'posts_per_page' => 1,
    'post_type' => 'product',
    'tax_query'     => array(
        array(
            'taxonomy'  => 'product_cat',
            'field'     => 'id', 
            'terms'     => $category->term_id
        )
    )
);
$myposts = new WP_Query( $args );
foreach ( $myposts as $post ) : setup_postdata( $post );
         $image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' ); 
         //$image = wp_get_attachment_image_src($mypost->ID, 'woo-size-category');
         the_title();
         echo '<img src="' .esc_url($image[0]). '" alt="' . esc_attr($category->name).'"  />';
endforeach;
        }
        ?>
        <div class="category-info">
            <h2><?php echo jwUtils::crop_length($category->name, jwOpt::get_option('letter_excerpt_cat_title', -1)); ?></h2>
            <?php if (jwOpt::get_option('woo_number_of_items', '1') == '1') { ?>
                <span class="count_items"><?php echo $category->count . ' ' . __('Items', 'jawtemplates'); ?></span>
            <?php } ?>
        </div>

    </a>

</div>

如果能知道这不起作用的原因就好了。如有任何帮助,我们将不胜感激!

谢谢Chris

*****更新-这是Var Dump*****

24array(1) { [0]=> object(WP_Post)#9805 (24) { ["ID"]=> int(12738) ["post_author"]=> string(1) "1" ["post_date"]=> string(19) "2015-02-16 15:27:06" ["post_date_gmt"]=> string(19) "2015-02-16 15:27:06" ["post_content"]=> string(80) "The Jungle Race is a serious event for Tiger. When the other animals don't train" ["post_title"]=> string(23) "The Tiger Who Was Angry" ["post_excerpt"]=> string(80) "The Jungle Race is a serious event for Tiger. When the other animals don't train" ["post_status"]=> string(7) "publish" ["comment_status"]=> string(4) "open" ["ping_status"]=> string(4) "open" ["post_password"]=> string(0) "" ["post_name"]=> string(23) "the-tiger-who-was-angry" ["to_ping"]=> string(0) "" ["pinged"]=> string(0) "" ["post_modified"]=> string(19) "2015-02-23 21:02:42" ["post_modified_gmt"]=> string(19) "2015-02-23 21:02:42" ["post_content_filtered"]=> string(0) "" ["post_parent"]=> int(0) ["guid"]=> string(0) "" ["menu_order"]=> int(0) ["post_type"]=> string(7) "product" ["post_mime_type"]=> string(0) "" ["comment_count"]=> string(1) "0" ["filter"]=> string(3) "raw" } }

图像是生成的,但不是来自正确的类别

********解决方案********

以下是我最终得到的(工作!)

if ($thumbnail_id) {
    $image = wp_get_attachment_image_src($thumbnail_id, 'woo-size-category');
    echo '<img src="' . esc_url($image[0]) . '" alt="' . esc_attr($category->name) . '"  />';
} else {
global $wpdb;
// Get a random product from this category
$args = 'SELECT object_id
FROM `wp_term_relationships`
where term_taxonomy_id = '.$category->term_id.' order by rand() limit 1';
$random_product_in_cat = $wpdb->get_var( $args );

// Get the returned post thumbnail
$image = wp_get_attachment_url( get_post_thumbnail_id($random_product_in_cat) );
echo '<img src="' . esc_url($image) . '" alt="' . esc_attr($category->name) . '"  />';
}

我会通过get_posts()创建一个posts数组,然后随机选择一个。我还没有测试过,但这里有一个概念:

// Get a random product from this category
$args = array(
    'post_type' => 'product',
    'posts_per_page' => 1,
    'category'  => $category->cat_ID,
    'orderby' => 'rand',
);
$random_product_in_cat = get_posts( $args );
// Get the returned post thumbnail
echo get_the_post_thumbnail( $random_product_in_cat[0]->ID, 'thumbnail' );