新聞中心

Ecshop教程：獲取某個(gè)商品的訂單信息或銷量

作者 / 無憂主機(jī) 時(shí)間 2015-12-08 13:40:45

很多人在php空間中建立了一個(gè)網(wǎng)站后，都會(huì)因?yàn)榫W(wǎng)站后期需要，想要查看單個(gè)某一商品的訂單信息或者是銷售量。類似網(wǎng)站后臺(tái)報(bào)表統(tǒng)計(jì)，有個(gè)這個(gè)的話，對(duì)于商品的銷量和訂單信息就有了一個(gè)很好的統(tǒng)計(jì)了。因此，要獲取ecshop某個(gè)商品的訂單信息或銷量，可以把以下這段代碼放到 ecshop程序文件的lib_main.php中： 1.統(tǒng)計(jì)某個(gè)下單商品的人數(shù)

function get_goods_ordernum($goods_id){
$sql = "select count(goods_number) from " . $GLOBALS['ecs']->table('order_goods') . " AS g ,".$GLOBALS['ecs']->table('order_info') . " AS o WHERE o.order_id=g.order_id and g.goods_id = " . $goods_id . " and o.order_status in(1,5) " ;//o.order_status=1 表示確認(rèn)了的訂單才算 
return $GLOBALS['db']->getAll($sql); 
}

注意：如果有3個(gè)人下單，數(shù)量是5 ，那返回結(jié)果是3 2.統(tǒng)計(jì)某個(gè)下單商品的銷量，

function get_goods_ordernum($goods_id){
$sql = "select sum(goods_number) from " . $GLOBALS['ecs']->table('order_goods') . " AS g ,".$GLOBALS['ecs']->table('order_info') . " AS o WHERE o.order_id=g.order_id and g.goods_id = " . $goods_id . " and o.order_status in(1,5) " ;//o.order_status=1 表示確認(rèn)了的訂單才算 
return $GLOBALS['db']->getAll($sql); 
}

注意：如果有3個(gè)人下單，數(shù)量是5 ，那返回結(jié)果是5 3.統(tǒng)計(jì)某個(gè)商品商品訂單的詳細(xì)信息，在制作相應(yīng)ecshop商城模板時(shí)就可以用到這個(gè)數(shù)據(jù)

function get_goods_ordernum($goods_id){
$sql = "select * from " . $GLOBALS['ecs']->table('order_goods') . " AS g ,".$GLOBALS['ecs']->table('order_info') . " AS o WHERE o.order_id=g.order_id and g.goods_id = " . $goods_id . " and o.order_status in(1,5) " ;//o.order_status=1 表示確認(rèn)了的訂單才算 
return $GLOBALS['db']->getAll($sql); 
}

order_status in(1,5) 1表示去人訂單，5表示已分單完整php代碼

/*獲取有效訂單信息*/
function sales_goods_order($goods_id){ 
$sql = "select * from " . $GLOBALS['ecs']->table('order_goods') . " AS g ,".$GLOBALS['ecs']->table('order_info') . " AS o WHERE o.order_id=g.order_id and g.goods_id = " . $goods_id . " and o.order_status in(1,5) " ;//o.order_status=1 1表示確認(rèn)訂單，5已分單
return $GLOBALS['db']->getAll($sql); 
}
/*獲取某個(gè)商品有效訂單 銷量統(tǒng)計(jì)*/
function sales_goods_number($goods_id){ 
$arr = sales_goods_order($goods_id);
//return array_sum($arr['goods_number']);
foreach($arr as $k=>$v){
$val[] = $v['goods_number']; 
}
$count = array_sum($val);
if(!empty($count)){
return $count; 
}else{
return '0'; 
}
}

本文地址：http://www.love62.cn/ecshop/21083.html

上一篇: ECshop測(cè)試數(shù)據(jù)通過SQL語句清除
下一篇: zblog網(wǎng)站標(biāo)志favicon.ico設(shè)置教程