| Line 2920... |
Line 2920... |
| 2920 |
amazonItem[0].fbbPromoActive = True
|
2920 |
amazonItem[0].fbbPromoActive = True
|
| 2921 |
session.commit()
|
2921 |
session.commit()
|
| 2922 |
|
2922 |
|
| 2923 |
def __get_amazon_promotion_attributes_for_item(item_id):
|
2923 |
def __get_amazon_promotion_attributes_for_item(item_id):
|
| 2924 |
timestamp = datetime.datetime.now()
|
2924 |
timestamp = datetime.datetime.now()
|
| 2925 |
fbaPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBA'+str(item_id)).filter(AmazonPromotion.promotionType==AmazonPromotionType.LONGTERM).filter(AmazonPromotion.startDate<=timestamp).filter(AmazonPromotion.endDate>=timestamp).order_by(desc(AmazonPromotion.addedOn)).limit(1).all()
|
- |
|
| 2926 |
fbbPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBB'+str(item_id)).filter(AmazonPromotion.promotionType==AmazonPromotionType.LONGTERM).filter(AmazonPromotion.startDate<=timestamp).filter(AmazonPromotion.endDate>=timestamp).order_by(desc(AmazonPromotion.addedOn)).limit(1).all()
|
- |
|
| 2927 |
return fbaPromo, fbbPromo
|
- |
|
| 2928 |
|
2925 |
fbaPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBA'+str(item_id)).filter(AmazonPromotion.startDate<=timestamp).filter(AmazonPromotion.endDate>=timestamp).filter(AmazonPromotion.updatedOnMarketplace>to_py_date(0)).order_by(desc(AmazonPromotion.updatedOnMarketplace)).limit(1).all()
|
| - |
|
2926 |
fbbPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBB'+str(item_id)).filter(AmazonPromotion.startDate<=timestamp).filter(AmazonPromotion.endDate>=timestamp).filter(AmazonPromotion.updatedOnMarketplace>to_py_date(0)).order_by(desc(AmazonPromotion.updatedOnMarketplace)).limit(1).all()
|
| - |
|
2927 |
return fbaPromo, fbbPromo
|
| - |
|
2928 |
|
| - |
|
2929 |
def get_ex_affiliate_item_info():
|
| - |
|
2930 |
query = session.query(ExclusiveAffiliateItemInfo, OutboundAffiliateMaster.name).join((OutboundAffiliateMaster, ExclusiveAffiliateItemInfo.affiliateId==OutboundAffiliateMaster.id)).filter(ExclusiveAffiliateItemInfo.isActive == True).all()
|
| - |
|
2931 |
close_session()
|
| - |
|
2932 |
map = {}
|
| - |
|
2933 |
for q in query:
|
| - |
|
2934 |
map[q[0].itemId]=to_t_exclusive_affiliate_item_info(q)
|
| - |
|
2935 |
return map
|
| - |
|
2936 |
|
| 2929 |
|
2937 |
|