ecshop 获取购买人数 获取商品几折

$goods[$idx]['zhekou_price']         = round(($row['promote_price']/$row['shop_price'])*100)/10+"";//获取商品是几折

因为ecshop提供的方法，比较严格，必须是用户付款后才算一笔合格的订单，所以我稍稍改动，自己写了个函数，需要传递一个商品ID，通过ID查找订单里对应商品的销售数量，另外这是goods_info表里的一些字段的状态

表order_info
  字段order_status，刚拍完是0，后台确后认是1 生成配货单后是5 
  字段shipping_status,刚拍完是0 配货后是3 生成配货单后是5，发货后是1 确认收货后是2
  字段pay_status,刚拍完是0

function getGoodsTotalById($id)
{
   $sql = "SELECT COUNT(*) AS total_order, SUM(g.goods_number) AS total_goods " .
            "FROM " . $GLOBALS['ecs']->table('order_info') . " AS o, " .
                $GLOBALS['ecs']->table('order_goods') . " AS g " .
            " WHERE o.order_id = g.order_id " .
            " AND g.goods_id = $id" .
            " AND (order_status = '" . OS_CONFIRMED . "' OR order_status = '" . OS_UNCONFIRMED . "' OR order_status = '5')";
    $res = $GLOBALS['db']->getRow($sql);
    return $res;
}

获取

$totals=getGoodsTotalById($row['goods_id']);

$goods[$idx]['total_order']          = $totals['total_order'];//某个商品的订单总数，或者是用多少个人购买的这个商品
$goods[$idx]['total_goods']          = $totals['total_goods'];//某个商品的销售总数