WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py

     PageViewEvents, CartEvents, EbayItem, BannerUriMapping, Campaign, SnapdealItem, \
     SnapdealItemUpdateHistory
 from shop2020.thriftpy.model.v1.catalog.ttypes import status, ItemShippingInfo, \
     ItemType, PremiumType, FreebieItem as t_FreebieItem, \
     StorePricing as tStorePricing, CatalogServiceException, \
-    BannerType
+    BannerType, InsurerType
 from shop2020.thriftpy.model.v1.inventory.ttypes import \
     InventoryServiceException, IgnoredInventoryUpdateItems
 from shop2020.utils import EmailAttachmentSender
 from shop2020.utils.EmailAttachmentSender import mail
 from shop2020.utils.Utils import to_py_date, log_risky_flag
         ds_item.model_number = item.modelNumber
     ds_item.color = item.color
     ds_item.model_name = item.modelName
     ds_item.category = item.category
     if item.category == 10006:
+        itemInsurerMapping = ItemInsurerMapping.query.filter(ItemInsurerMapping.itemId == item.id).filter(ItemInsurerMapping.insurerType == InsurerType._NAMES_TO_VALUES.get("DEVICE")).first()
+        if itemInsurerMapping is None:
+            itemInsurerMapping = ItemInsurerMapping()
+            itemInsurerMapping.itemId = item.id
-        ds_item.preferredInsurer = 1
+            itemInsurerMapping.insurerId = 1
+            itemInsurerMapping.insurerType = 1
     ds_item.comments = item.comments
     ds_item.catalog_item_id = item.catalogItemId
             item_change_log = ItemChangeLog()
             item_change_log.old_status = item.status
             item_change_log.new_status = content_complete_status
             item_change_log.timestamp = current_timestamp
             item_change_log.item = item
+            if isAndroid:
+                itemInsurerMapping = ItemInsurerMapping.query.filter(ItemInsurerMapping.itemId == item.id).filter(ItemInsurerMapping.insurerType == InsurerType._NAMES_TO_VALUES.get("DATA")).first()
+                if itemInsurerMapping is None:
+                    itemInsurerMapping = ItemInsurerMapping()
+                    itemInsurerMapping.itemId = item.id
+                    itemInsurerMapping.insurerId = 2
+                    itemInsurerMapping.insurerType = 2
         category_object = get_category(category)
         if category_object is not None:
             item.category = category
             item.product_group = category_object.display_name
     session.query(EntityTag.tag).filter_by(tag=displayName,entityId=catalogId).delete()
     session.commit()
     return True
 def get_insurance_amount(itemId, price, insurerId, quantity):
+    if insurerId ==1:
-    itemInsurerMapping = ItemInsurerMapping.query.filter(ItemInsurerMapping.itemId == itemId).filter(ItemInsurerMapping.insurerId == insurerId).first()
+        #itemInsurerMapping = ItemInsurerMapping.query.filter(ItemInsurerMapping.itemId == itemId).filter(ItemInsurerMapping.insurerId == insurerId).first()
-    if not itemInsurerMapping:
+        #if itemInsurerMapping:
-        #Default insurance premium is 1.5%
+            #Default insurance premium is 1.5%
+        #    return round(price * (1.5/100) * quantity)
         return round(price * (1.5/100) * quantity)
-    insuranceAmount = 0.0
+        '''insuranceAmount = 0.0
-    if itemInsurerMapping.premiumType == PremiumType._NAMES_TO_VALUES.get("PERCENT"):
+        if itemInsurerMapping.premiumType == PremiumType._NAMES_TO_VALUES.get("PERCENT"):
-        insuranceAmount = price * (itemInsurerMapping.premiumAmount/100) * quantity
+            insuranceAmount = price * (itemInsurerMapping.premiumAmount/100) * quantity
-    else :
+        else :
-        insuranceAmount = itemInsurerMapping.premiumAmount * quantity
+            insuranceAmount = itemInsurerMapping.premiumAmount * quantity
+        '''
+    if insurerId ==2:
+        return 0.0 #FOR PROMOTION PURPOSE
+        #return 449.0 * quantity
+    return 0.0
+def get_preffered_insurer_for_item(itemId, insurerType):
+    itemInsurerMapping = ItemInsurerMapping.query.filter(ItemInsurerMapping.itemId == itemId).filter(ItemInsurerMapping.insurerType == insurerType).first()
+    if not itemInsurerMapping:
+        return 0
+    else:
-    return insuranceAmount
+        return itemInsurerMapping.insurerId
 def get_insurer(insurerId):
     return Insurer.get_by(id = insurerId)
 def get_all_entity_tags():
     entitiesTag = EntityTag.query.all()

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py – Rev 9253 → 9299