step = datetime.timedelta(days=1)
days = []
while dt <= end:
days.append(dt.strftime('%Y-%m-%d'))
dt += step
#print days
# 初始化sku数据
skus_all = {}
db_sku = db.sku_store.find({},
{'product_id':1, 'base_sku':1, 'app_title':1, 'special_price':1, 'is_onsale':1, 'available':1, 'ref_price':1})
for i in db_sku:
base_sku = db.dereference(i['base_sku'])
skus_all[i['product_id']]=(
base_sku['name'] if len(i['app_title'].strip())==0 else i['app_title'],
i['special_price'] if i['is_onsale']==1 else '',
i['available'],
i['ref_price'],
i['special_price']
)
# 只计算昨天和今天的销量
for day in days[-2:]:
begin_date = '%s 00:00:00' % day
end_date = '%s 23:59:59' % day
condition = {
'type' : {'$nin':['TUAN','SINGLE']},
