首页 » 后端 » Discuz! etc » 正文

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

发布者:站点默认
2013/07/23 浏览数(1,738) 分类:Discuz! etc 方法:在ECShop首页显示积分商城里的商品列表已关闭评论

需要修改两个文件:index.php、index.dwt

一、在 index.php 末尾添加一个 function:

/**
* 获得积分商城热门商品
*
* @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 中的调用代码:

<!--{if $exchange_goods}-->
<ul class="imgList">
	<!--{foreach from=$exchange_goods item=goods}-->
	<li>
		<a href="{$goods.url}" class="thumb" title="{$goods.name|escape:html}"><img src="{$goods.thumb}" width="124" height="144" alt="{$goods.name|escape:html}" /></a>
		<div class="title"><a href="{$goods.url}" title="{$goods.name|escape:html}">{$goods.name}</a></div>
		<div class="price">
			<div class="promote"><strong>{$lang.exchange_integral}</strong><span href="">{$goods.exchange_integral}</span></div>
		</div>
	</li>
	<!--{/foreach}-->
</ul>
<!--{/if}-->

<完>

点击返回顶部
  1. 留言
  2. 联系方式