| Line 2871... |
Line 2871... |
| 2871 |
|
2871 |
|
| 2872 |
def get_upload_result_by_id(uploadId):
|
2872 |
def get_upload_result_by_id(uploadId):
|
| 2873 |
return session.query(CompetitorPricing,Item).join((Item,CompetitorPricing.item_id==Item.id)).filter(CompetitorPricing.competitorPricing_requestId==uploadId).all()
|
2873 |
return session.query(CompetitorPricing,Item).join((Item,CompetitorPricing.item_id==Item.id)).filter(CompetitorPricing.competitorPricing_requestId==uploadId).all()
|
| 2874 |
|
2874 |
|
| 2875 |
def add_amazon_promotion(amazonPromotions):
|
2875 |
def add_amazon_promotion(amazonPromotions):
|
| - |
|
2876 |
notAdded = []
|
| 2876 |
for sku, amazonPromotion in amazonPromotions.iteritems():
|
2877 |
for sku, amazonPromotion in amazonPromotions.iteritems():
|
| - |
|
2878 |
amazonSku = sku.strip().upper()
|
| - |
|
2879 |
if amazonSku.startswith('FBA'):
|
| - |
|
2880 |
stateId = 1
|
| - |
|
2881 |
elif amazonSku.startswith('FBB'):
|
| - |
|
2882 |
stateId = 2
|
| - |
|
2883 |
elif amazonSku.startswith('FBG'):
|
| - |
|
2884 |
stateId = 3
|
| - |
|
2885 |
else:
|
| - |
|
2886 |
notAdded.append(amazonSku)
|
| - |
|
2887 |
continue
|
| - |
|
2888 |
amazonItem = get_amazon_item_details(int(amazonSku[3:]))
|
| - |
|
2889 |
if amazonItem[0] is None:
|
| - |
|
2890 |
notAdded.append(amazonSku)
|
| - |
|
2891 |
continue
|
| 2877 |
d_amazonPromotion = AmazonPromotion()
|
2892 |
d_amazonPromotion = AmazonPromotion()
|
| 2878 |
d_amazonPromotion.sku = sku.strip().upper()
|
2893 |
d_amazonPromotion.sku = amazonSku
|
| 2879 |
d_amazonPromotion.standardPrice = amazonPromotion.standardPrice
|
2894 |
d_amazonPromotion.standardPrice = amazonPromotion.standardPrice
|
| 2880 |
d_amazonPromotion.salePrice = amazonPromotion.salePrice
|
2895 |
d_amazonPromotion.salePrice = amazonPromotion.salePrice
|
| 2881 |
d_amazonPromotion.subsidy = amazonPromotion.subsidyAmount
|
2896 |
d_amazonPromotion.subsidy = amazonPromotion.subsidyAmount
|
| 2882 |
d_amazonPromotion.startDate = to_py_date(amazonPromotion.startDate)
|
2897 |
d_amazonPromotion.startDate = to_py_date(amazonPromotion.startDate)
|
| 2883 |
d_amazonPromotion.endDate = to_py_date(amazonPromotion.endDate)
|
2898 |
d_amazonPromotion.endDate = to_py_date(amazonPromotion.endDate)
|
| 2884 |
d_amazonPromotion.addedOn = to_py_date(amazonPromotion.addedOn)
|
2899 |
d_amazonPromotion.addedOn = to_py_date(amazonPromotion.addedOn)
|
| 2885 |
d_amazonPromotion.promotionActive = False
|
2900 |
d_amazonPromotion.promotionActive = False
|
| 2886 |
if d_amazonPromotion.sku.startswith('FBA'):
|
- |
|
| 2887 |
d_amazonPromotion.stateId = 1
|
- |
|
| 2888 |
elif d_amazonPromotion.sku.startswith('FBB'):
|
- |
|
| 2889 |
d_amazonPromotion.stateId = 2
|
- |
|
| 2890 |
elif d_amazonPromotion.sku.startswith('FBG'):
|
- |
|
| 2891 |
d_amazonPromotion.stateId = 3
|
- |
|
| 2892 |
else:
|
- |
|
| 2893 |
raise CatalogServiceException(101, "Amazon Promotion Illegal sku id "+sku)
|
- |
|
| 2894 |
d_amazonPromotion.promotionType = amazonPromotion.promotionType
|
2901 |
d_amazonPromotion.promotionType = amazonPromotion.promotionType
|
| - |
|
2902 |
d_amazonPromotion.stateId = stateId
|
| 2895 |
if d_amazonPromotion.promotionType == AmazonPromotionType._NAMES_TO_VALUES.get('LONGTERM'):
|
2903 |
if d_amazonPromotion.promotionType == AmazonPromotionType._NAMES_TO_VALUES.get('LONGTERM'):
|
| 2896 |
amazonItem = get_amazon_item_details(int(d_amazonPromotion.sku[3:]))
|
- |
|
| 2897 |
if amazonItem[0] is None:
|
- |
|
| 2898 |
raise CatalogServiceException(102, "Item doesnot exist in amazonlisted sku id "+sku)
|
- |
|
| 2899 |
if d_amazonPromotion.stateId == 1:
|
2904 |
if d_amazonPromotion.stateId == 1:
|
| 2900 |
amazonItem[0].fbaPromoPrice = amazonPromotion.salePrice
|
2905 |
amazonItem[0].fbaPromoPrice = amazonPromotion.salePrice
|
| 2901 |
amazonItem[0].fbaPromoStartDate = to_py_date(amazonPromotion.startDate)
|
2906 |
amazonItem[0].fbaPromoStartDate = to_py_date(amazonPromotion.startDate)
|
| 2902 |
amazonItem[0].fbaPromoEndDate = to_py_date(amazonPromotion.endDate)
|
2907 |
amazonItem[0].fbaPromoEndDate = to_py_date(amazonPromotion.endDate)
|
| 2903 |
amazonItem[0].fbaPromoActive = False
|
2908 |
amazonItem[0].fbaPromoActive = False
|
| Line 2912... |
Line 2917... |
| 2912 |
amazonItem[0].fbgPromoEndDate = to_py_date(amazonPromotion.endDate)
|
2917 |
amazonItem[0].fbgPromoEndDate = to_py_date(amazonPromotion.endDate)
|
| 2913 |
amazonItem[0].fbgPromoActive = False
|
2918 |
amazonItem[0].fbgPromoActive = False
|
| 2914 |
else:
|
2919 |
else:
|
| 2915 |
d_amazonPromotion.promotionActive = True
|
2920 |
d_amazonPromotion.promotionActive = True
|
| 2916 |
session.commit()
|
2921 |
session.commit()
|
| 2917 |
return True
|
2922 |
return notAdded
|
| 2918 |
|
2923 |
|
| 2919 |
|
2924 |
|
| 2920 |
def get_vat_rates(itemId, categoryId):
|
2925 |
def get_vat_rates(itemId, categoryId):
|
| 2921 |
vatRates = {}
|
2926 |
vatRates = {}
|
| 2922 |
item = get_item(itemId)
|
2927 |
item = get_item(itemId)
|