国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 網站 > 建站經驗 > 正文

獲取ecshop某個商品的訂單信息或銷量

2024-04-25 20:43:33
字體:
來源:轉載
供稿:網友

獲取ecshop某個商品的訂單信息或銷量,把以下代碼放到 lib_main.php

1.統計某個下單商品的人數

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 表示確認了的訂單才算

return $GLOBALS['db']->getAll($sql);

}

注意:如果有3個人下單,數量是5 ,那返回結果是3

2.統計某個下單商品的銷量,

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 表示確認了的訂單才算

return $GLOBALS['db']->getAll($sql);

}

注意:如果有3個人下單,數量是5 ,那返回結果是5

3.統計某個商品商品訂單的詳細信息,在制作相應ecshop商城模板時就可以用到這個數據

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 表示確認了的訂單才算

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表示確認訂單,5已分單

return $GLOBALS['db']->getAll($sql);

}

/*獲取某個商品有效訂單 銷量統計*/

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';

}

}

以上就是本文章的內容,希望對大家有所幫助

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 高青县| 清苑县| 内江市| 客服| 聂荣县| 安陆市| 中方县| 嵊州市| 玉树县| 佛山市| 会东县| 宁陕县| 顺义区| 西华县| 土默特右旗| 麻栗坡县| 突泉县| 台湾省| 石台县| 沙湾县| 巫山县| 红桥区| 阜宁县| 会泽县| 天气| 永吉县| 平南县| 曲靖市| 陆川县| 淮安市| 凌海市| 葫芦岛市| 柏乡县| 荆门市| 大名县| 砀山县| 东台市| 乳山市| 平武县| 班玛县| 保靖县|