- 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;
本文章已结束，如转载请注明：汇站网 » ecshop 获取最新购买代码函数
