magento list page or search page add review count

最新推荐文章于 2024-08-08 14:28:23 发布

weixin_33919950

最新推荐文章于 2024-08-08 14:28:23 发布

阅读量150

点赞数

文章标签： python php

原文链接：https://my.oschina.net/liufeng815/blog/395867

版权

2019独角兽企业重金招聘Python工程师标准>>>

<!-- lang: php -->
//byfeng 
public function addReviewcount()
{
	$RecentviewSelect=Mage::getSingleton('core/resource')->getConnection('core_read')
	->select()
	->from($this->getTable('review/review'),array('review_count' => new Zend_Db_Expr('COUNT(*)'),'product_id'=>'entity_pk_value'))
	->where("{$this->getTable('review/review')}.status_id = 1")
	->group("{$this->getTable('review/review')}.entity_pk_value");

    $this->getSelect()->joinLeft(array('bs'=>$RecentviewSelect), 'bs.product_id = e.entity_id',
     array('review' => 'bs.review_count')); 
	 
	return $this;
}

转载于:https://my.oschina.net/liufeng815/blog/395867