ecshop销量查询代码

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
版权所有 © 转载时必须以链接形式注明出处!

觉得本文对您有用,想收藏下来!方法很简单:请点击-〉
我们一直坚持白天工作、晚上熬夜更新资源,付出了巨大的精力和时间,其中的辛酸难以言述。

文章评论

暂无评论,来发表一个吧

发表 取消
充值有惊喜 ECSHOP插件网微信客服edait_cn