ecshop实现获取商品30天出售量

在lib_goods.php下修改

//jimphei's code //获取30天出售多少件
function sales30($goods_id)
{
	 $top30_time = " AND o.order_sn >= '" . date('Ymd', gmtime() - 30 * 86400) . "'";
	$sql="select count(*) from ".$GLOBALS['ecs']->table('order_goods')." as og left join ".$GLOBALS['ecs']->table('order_info')." as o
	 on og.order_id = o.order_id where og.goods_id=".$goods_id;
	 $sql.=$top30_time;
    $sql .= " AND (o.order_status = '" . OS_CONFIRMED .  "' OR o.order_status = '" . OS_SPLITED . "') " .
           "AND (o.pay_status = '" . PS_PAYED . "' OR o.pay_status = '" . PS_PAYING . "') " .
           "AND (o.shipping_status = '" . SS_SHIPPED . "' OR o.shipping_status = '" . SS_RECEIVED . "') " ;
		   
	return $GLOBALS['db']->getOne($sql);		   
          
}