php 商品价格区间算法,ecshop商品价格添加区间
1.在 includes/lib_goods.php 文件中找到function get_goods_info($goods_id)
在此函數中找到代碼:
/* 獲得商品的銷售價格 */
$row['market_price'] = price_format($row['market_price']);
$row['shop_price_formated'] = price_format($row['shop_price']);
然后在此代碼下面加上如下一段代碼即可實現:
/* 獲得有規格屬性的商品的銷售價格范圍 */
$sql = "SELECT SUM(max_attr_price) AS max_price FROM (SELECT MAX(attr_price+0) AS max_attr_price FROM " . $GLOBALS['ecs']->table('goods_attr') .
" WHERE goods_id = '".$goods_id."' GROUP BY attr_id) AS a";
$max_price = $GLOBALS['db']->getOne($sql);
if(intval($max_price) > 0)
{
$goods_max_price = intval($max_price) + intval($row['shop_price']);
$row['shop_price_formated'] = "¥".number_format($row['shop_price'], 2)." - ".number_format($goods_max_price, 2)."元";
}
總結
以上是生活随笔為你收集整理的php 商品价格区间算法,ecshop商品价格添加区间的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: Oracle sql如何把毫秒转为日期,
- 下一篇: linux打开u盘里的文件,Linux下