-mysql
select sum(fixed_value) as fixedtotal ,FROM_UNIXTIME(createtime, '%Y-%m-%d') as day
from ims_ewei_shop_order_goods group by day
-微擎下
$where='where uniacid=:uniacid and openid=:openid and createtime >= :starttime and createtime <=:endtime';
$params=array(
':uniacid'=>