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']},