ecshop销量查询代码
日期:2019-12-05
ecshop查询月销量代码
function ecs_buysum($goods_id) { $LMonth = strtotime("last month"); //前一个月 $nowTime = time(); //当前时间 $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.pay_status = 2 AND o.add_time >= ".$LMonth." AND o.add_time <= ".$nowTime." GROUP BY g.goods_id"; if (($GLOBALS['db']->getOne($sql)) == "") { return "0"; } else { return $GLOBALS['db']->getOne($sql); } }ecshop查询总销量代码
function ecs_buysum($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 = 5 " ; if (($GLOBALS['db']->getOne($sql)) == "") { return "0"; } else { return $GLOBALS['db']->getOne($sql); } }
本文原创地址:https://www.ecshopok.com/article-591.html
版权所有 © 转载时必须以链接形式注明出处!
觉得本文对您有用,想收藏下来!方法很简单:请点击-〉
我们一直坚持白天工作、晚上熬夜更新资源,付出了巨大的精力和时间,其中的辛酸难以言述。
暂无评论,来发表一个吧