在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}
，每一件事与每一个美丽景色，都有可能成为一生中的难忘。
