ECShop首页显示积分商城里商品列表的解决方法

 一、在 index.php 末尾添加一个方法

/** 
* 获得积分商城热门商品 
* 
* @param   int      $limit       列出条数 
* @param   int      $ishot       是否只显示热销 
* @return array 
*/ 
function index_get_exchange($limit=3,$ishot=0){ 
/* 获得热门积分商品列表 */ 
$sql_ishot = $ishot ? " AND eg.is_hot=1 " : ""; 
$table_exchange_goods = $GLOBALS['ecs']->table('exchange_goods'); 
$table_goods = $GLOBALS['ecs']->table('goods'); 
$sql = " 
SELECT 
g.goods_id, g.goods_name, g.goods_name_style, eg.exchange_integral, 
g.goods_type,g.goods_brief, g.goods_thumb, g.goods_img, eg.is_hot  
FROM $table_exchange_goods AS eg 
LEFT JOIN $table_goods AS g 
ON g.goods_id = eg.goods_id 
WHERE eg.is_exchange = 1 AND g.is_delete = 0 $sql_ishot

limit $limit 
";

$res = $GLOBALS['db']->getAll($sql);  
$arr = array(); 
foreach($res AS $idx => $row){ 
$arr[$idx]['name']              = $row['goods_name']; 
$arr[$idx]['goods_brief']       = $row['goods_brief']; 
$arr[$idx]['goods_style_name']  = add_style($row['goods_name'],$row['goods_name_style']); 
$arr[$idx]['exchange_integral'] = $row['exchange_integral']; 
$arr[$idx]['type']              = $row['goods_type']; 
$arr[$idx]['thumb']             = get_image_path($row['goods_id'], $row['goods_thumb'], true); 
$arr[$idx]['goods_img']         = get_image_path($row['goods_id'], $row['goods_img']); 
$arr[$idx]['url']               = build_uri('exchange_goods',array('gid'=>$row['goods_id']), $row['goods_name']); 
} 
return $arr; 
}

二、index.dwt 中的调用代码： 
{$goods.name}
{$lang.exchange_integral}{$goods.exchange_integral}

这样就OK了。希望对大家有所帮助。