Subversion Repositories SmartDukaan

Rev

Rev 13076 | Rev 13168 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13076 Rev 13136
Line 25... Line 25...
25 
    PrivateDeals, AmazonOutOfSync, PrivateDealsPriceComparison, \
 25 
    PrivateDeals, AmazonOutOfSync, PrivateDealsPriceComparison, \
26 
    SourceReturnPercentage, CompetitorPricing, CompetitorPricingRequest, \
 26 
    SourceReturnPercentage, CompetitorPricing, CompetitorPricingRequest, \
27 
    AmazonPromotion, ExclusiveAffiliateItemInfo, OutboundAffiliateMaster
 27 
    AmazonPromotion, ExclusiveAffiliateItemInfo, OutboundAffiliateMaster
28 
from shop2020.thriftpy.model.v1.catalog.ttypes import status, ItemShippingInfo, \
 28 
from shop2020.thriftpy.model.v1.catalog.ttypes import status, ItemShippingInfo, \
29 
    ItemType, PremiumType, FreebieItem as t_FreebieItem, \
 29 
    ItemType, PremiumType, FreebieItem as t_FreebieItem, \
30 
    StorePricing as tStorePricing, CatalogServiceException, \
 30 
    StorePricing as tStorePricing, CatalogServiceException, BannerType, InsurerType, \
31 
    BannerType, InsurerType, Banner as t_banner, CompetitorPricing as TCompetitorPricing, \
 31 
    Banner as t_banner, CompetitorPricing as TCompetitorPricing, AmazonPromotionType
32 
    AmazonPromotionType
 - 
 
33 
from shop2020.thriftpy.model.v1.inventory.ttypes import VatType, \
 32 
from shop2020.thriftpy.model.v1.inventory.ttypes import VatType, \
34 
    InventoryServiceException, IgnoredInventoryUpdateItems,SnapdealInventoryItem
 33 
    InventoryServiceException, IgnoredInventoryUpdateItems, SnapdealInventoryItem
35 
from shop2020.thriftpy.model.v1.order.ttypes import OrderSource
 34 
from shop2020.thriftpy.model.v1.order.ttypes import OrderSource
36 
from shop2020.utils import EmailAttachmentSender
 35 
from shop2020.utils import EmailAttachmentSender
37 
from shop2020.utils.EmailAttachmentSender import mail
 36 
from shop2020.utils.EmailAttachmentSender import mail
38 
from shop2020.utils.Utils import to_py_date, log_risky_flag
 37 
from shop2020.utils.Utils import to_py_date, log_risky_flag
39 
from sqlalchemy import desc, asc
 38 
from sqlalchemy import desc, asc
40 
from sqlalchemy.sql.expression import or_, distinct, func, and_
39 
from sqlalchemy.sql.expression import or_, distinct, func, and_
41 
from sqlalchemy.sql.functions import now
 40 
from sqlalchemy.sql.functions import now
42 
from string import Template
 41 
from string import Template
43 
import datetime
 42 
import datetime
44 
import math
 43 
import math
45 
import sys
 44 
import sys
Line 2976... Line 2975...
2976 
            else:
 2975 
            else:
2977 
                amazonItem[0].fbgPromotionActive = True
 2976 
                amazonItem[0].fbgPromotionActive = True
2978 
    session.commit()
 2977 
    session.commit()
2979 
    return True
 2978 
    return True
2980 
 
 2979 
 
- 
 
 2980 
def check_services(map_lines):
- 
 
 2981 
    for key in map_lines.keys():
- 
 
 2982 
        line = map_lines[key]
- 
 
 2983 
        if line['insurer'] > 0 :
- 
 
 2984 
                insurerId = get_preffered_insurer_for_item(key,InsurerType.DEVICE)
- 
 
 2985 
                line['insurer'] = insurerId
- 
 
 2986 
                line['insureramount'] = get_insurance_amount(key, line['amount'], insurerId, line['quantity'])
- 
 
 2987 
        if line['dpinsurer'] > 0:
- 
 
 2988 
                insurerId = get_preffered_insurer_for_item(key,InsurerType.DATA)
- 
 
 2989 
                line['dpinsurer'] = insurerId
- 
 
 2990 
                line['dpinsureramount'] = get_insurance_amount(key, line['amount'], insurerId, line['quantity'])
- 
 
 2991 
    return map_lines
- 
 
 2992 
 
2981 
def __get_amazon_promotion_attributes_for_item(item_id):
 2993 
def __get_amazon_promotion_attributes_for_item(item_id):
2982 
    timestamp = datetime.datetime.now()
 2994 
    timestamp = datetime.datetime.now()
2983 
    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()
 2995 
    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()
2984 
    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()
 2996 
    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()
2985 
    fbgPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBG'+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()
 2997 
    fbgPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBG'+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()