ecshop商城首页增加一个商品浏览排行榜的实现方法

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<div class="box">
<div class="box_2">
<h3><span>浏览排行</span></h3>
<div class="top10List clearfix">
<!-- {foreach name=top_goods from=$top_goods_click item=goods}-->
<ul class="clearfix">
<img src="../images/top_{$smarty.foreach.top_goods.iteration}.gif" class="iteration" />
<!-- {if $smarty.foreach.top_goods.iteration<4}-->
<li class="topimg">
<a href="{$goods.url}"><img src="{$goods.thumb}" alt="{$goods.name|escape:html}" class="samllimg" /></a>
</li>
<!-- {/if} -->
<li {if $smarty.foreach.top_goods.iteration<4}class="iteration1"{/if}>
<a href="{$goods.url}" title="{$goods.name|escape:html}">{$goods.short_name}</a><br />
{$lang.shop_price}<font class="f1">{$goods.price}</font><br />
</li>
</ul>
<!-- {/foreach} -->
</div>
</div>
</div>
<div class="blank5"></div>

/**
* 增加调用商品浏览排行榜
*
* @ebingou.cn
*
*/
function get_top10_click()
{
$sql="SELECT goods_id, goods_name, shop_price, goods_thumb " .
'FROM ' . $GLOBALS['ecs']->table('goods')." where is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 order by click_count desc limit 10";
$arr = $GLOBALS['db']->getAll($sql);
for ($i = 0, $count = count($arr); $i < $count; $i++)
{
$arr[$i]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?
sub_str($arr[$i]['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $arr[$i]['goods_name'];
$arr[$i]['url']        = build_uri('goods', array('gid' => $arr[$i]['goods_id']), $arr[$i]['goods_name']);
$arr[$i]['thumb'] = get_image_path($arr[$i]['goods_id'], $arr[$i]['goods_thumb'],true);
$arr[$i]['price'] = price_format($arr[$i]['shop_price']);
}
return $arr;
}

$smarty->assign('top_goods', get_top10());     // 销售排行

$smarty->assign('top_goods_click', get_top10_click());     // 浏览排行

<!-- #BeginLibraryItem "/library/promotion_info.lbi" -->

<!-- #BeginLibraryItem "/library/top10_click.lbi" --><!-- #EndLibraryItem -->

$_LANG['template_libs']['top10'] = '销售排行';

$_LANG['template_libs']['top10_click'] = '浏览排行';