ecshop获取最新购买代码函数

muban大师

function index_get_recent_buy_query()
        {
          
            $sql="select og.goods_id,og.goods_name,sum(og.goods_number) as buy_count from (select order_id,add_time from ".$GLOBALS['ecs',->table('order_info')." order by add_time desc limit 10) as o,".$GLOBALS['ecs',->table('order_goods')." as og where o.order_id=og.order_id group by og.goods_id";
            $all = $GLOBALS['db',->getAll($sql);
            $arr = array();
            foreach ($all AS $idx =>$row)
            {
          
                $arr[$idx,['goodName',  = $row['goods_name',;
                $arr[$idx,['goodID',    = $row['goods_id',;
                $arr[$idx,['add_time',  = local_date($GLOBALS['_CFG',['date_format',, $row['add_time',);
                $arr[$idx,['buy_count',=$row['buy_count',;
            }
            return $arr;