長沙做網站在做項目時，客戶要求能讓銷售量前10的排在首頁，這樣吸引更多的用戶。Ecshop是一個強大的開源系統，很多功能需要二次開發就可以實現的。當然這個需求一樣可以實現，方法如下：

    代碼如下：

function get_latest_top10(){
    $sql="SELECT DISTINCT a.goods_id,b.goods_name,b.goods_number,b.`goods_thumb`,ROUND(b.`shop_price`,0) AS price FROM (SELECT goods_id,COUNT(DISTINCT rec_id) AS total FROM ecs_order_goods GROUP BY goods_id) a,ecs_goods b WHERE a.`goods_id`=b.`goods_id` ORDER BY a.total DESC LIMIT 10";
    return $GLOBALS['db']->getAll($sql);
}

這個方法，就能獲取到排行榜的商品信息；加在 includes/lib_goods.php 的尾部

 如果是首頁要調用，就類似這樣

$smarty->assign('top_goods',       get_latest_top10());

寫在 index.php 里

模板里這么調用：

 <!-- {foreach name=top_goods from=$top_goods 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} -->