ECShop显示某商品销售累计效果的实现代码
<p><span>方案如下： </span><br><span>修改 includes/lib_insert.php 文件， </span><br><span>增加一个函数 </span></p>
<div>
<p>
<span><u>复制代码</u></span></p>
<p>
代码如下:</p>
</div>
<p>
<br>
/** <br>
* 调用某商品的累积售出 <br>
*/ <br>
function insert_goods_sells($arr) <br>
{ <br>
$sql = 'SELECT SUM(goods_number) AS number ' . <br>
' FROM ' . $GLOBALS['ecs']->table('order_goods') ." AS og , " . $GLOBALS['ecs']->table('order_info') ." AS o ". <br>
" WHERE og.order_id = o.order_id and og.goods_id=".$arr['goods_id']; <br>
$row = $GLOBALS['db']->GetRow($sql); <br>
if ($row) <br>
{ <br>
$number = intval($row['number']); <br>
} <br>
else <br>
{ <br>
$number = 0; <br>
} <br>
return $number; <br>
} </p>
<p>
<br><span>修改模板下goods.dwt文件 </span><br><span>增加一行代码 </span><br><span><strong>累计售出：</strong>{insert name='goods_sells' goods_id=$id}{$goods.measure_unit} </span></p>
頁:
[1]