方案如下:
修改includes/lib_insert.php文件,
增加一個函數
/**
*調用某商品的累積售出
*/
functioninsert_goods_sells($arr)
{
$sql='SELECTSUM(goods_number)ASnumber'.
'FROM'.$GLOBALS['ecs']->table('order_goods')."ASog,".$GLOBALS['ecs']->table('order_info')."ASo".
"WHEREog.order_id=o.order_idandog.goods_id=".$arr['goods_id'];
$row=$GLOBALS['db']->GetRow($sql);
if($row)
{
$number=intval($row['number']);
}
else
{
$number=0;
}
return$number;
}
修改模板下goods.dwt文件
增加一行代碼
<strong>累計售出:</strong>{insertname='goods_sells'goods_id=$id}{$goods.measure_unit}
|
新聞熱點
疑難解答