WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/logistics/service/impl/DataAccessor.py

 warehouse_allocation_cache = {}
 serviceable_location_cache = {}
 delivery_estimate_cache = {}
 warehouse_location_cache = {}
 location_state={}
+'Delhivery Bluedart, Fedex Surface, Fedex Air'
 state_locations = {}
 provider_costing_sheet = {}
 DELHIVERY = 3
 #pincode location map is ab
     print "Starting cache population at: " + str(datetime.datetime.now())
     #__cache_warehouse_allocation_table()
     __cache_warehouse_locations()
     __cache_serviceable_location_details_table()
     __cache_delivery_estimate_table()
+    __cache_pincode_provider_serviceability()
     __cache_locations()
     __cache_pincode_estimates()
     __cache_courier_costing_table()
     close_session()
     print "Done cache population at: " + str(datetime.datetime.now())
     if pincode_locations.has_key(destination_pin):
         locations = pincode_locations[destination_pin]
         for item_selling_price in selling_price_list:
             returnMap[item_selling_price] = {}
             for location_id, value in locations.iteritems():
-                returnMap[item_selling_price][location_id] = LocationInfo(locationId = location_id, sameState=value['sameState'])
                 #put weight logic here
                 otgAvailable = False
                 codAvailable = False
                 minDelay = -1
                 maxDelay = -1
                     if not serviceable_map.has_key(pp):
                         continue
                     iscod, isotg, providerCodLimit, websiteCodLimit, storeCodLimit, providerPrepaidLimit = serviceable_map[pp]
                     if item_selling_price <= providerPrepaidLimit:
                         if not serviceable:
+                            returnMap[item_selling_price][location_id] = LocationInfo(locationId = location_id, sameState=value['sameState'])
                             serviceable = True
                             minDelay = delay_days
                             maxDelay = delay_days
                         else:
                             minDelay = min(delay_days,minDelay)
                         iscod = iscod and item_selling_price <= min(providerCodLimit, websiteCodLimit)
                         isotg = (isotg and item_selling_price >= 2000)
                         otgAvailable = otgAvailable or isotg
                         codAvailable = codAvailable or iscod
                 if serviceable:
-                    returnMap[item_selling_price][location_id].otgAvailable = otgAvailable
+                    returnMap[item_selling_price][location_id].isOtg = otgAvailable
-                    returnMap[item_selling_price][location_id].codAvailable = codAvailable
+                    returnMap[item_selling_price][location_id].isCod = codAvailable
                     returnMap[item_selling_price][location_id].minDelay = minDelay
                     returnMap[item_selling_price][location_id].maxDelay = maxDelay
     return returnMap
 def get_logistics_estimation(destination_pin, item_selling_price, weight, type, billingWarehouseId):
             dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit = serviceable_location_cache.get(6).get(destination_pin)
             if item_selling_price <= providerPrepaidLimit:
                 iscod = iscod and item_selling_price <= websiteCodLimit
                 otgAvailable = otgAvailable and item_selling_price >= 2000
                 return 6, iscod, otgAvailable
     '''
-    if serviceable_location_cache.has_key(3) and serviceable_location_cache.get(3).has_key(destination_pin):
-        dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(3).get(destination_pin)
-        if item_selling_price <= providerPrepaidLimit:
+    ''' lets give opportunity to provider who is cod serviceable
-            iscod = iscod and item_selling_price <= websiteCodLimit
-            otgAvailable = otgAvailable and item_selling_price >= 2000
-            return 3, iscod, otgAvailable
+    '''
     if billingWarehouseId not in [12,13] and serviceable_location_cache.has_key(7) and serviceable_location_cache.get(7).has_key(destination_pin):
         if item_selling_price < 3000 and serviceable_location_cache.has_key(1) and serviceable_location_cache.get(1).has_key(destination_pin):
             dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(1).get(destination_pin)
             if item_selling_price <= providerPrepaidLimit:
                 iscod = iscod and item_selling_price <= websiteCodLimit
                 otgAvailable = otgAvailable and item_selling_price >= 2000
+                if iscod:
-                return 1, iscod, otgAvailable
+                    return 1, iscod, otgAvailable
         else:
             dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(7).get(destination_pin)
             if item_selling_price <= providerPrepaidLimit:
                 iscod = iscod and item_selling_price <= websiteCodLimit
                 otgAvailable = otgAvailable and item_selling_price >= 2000
+                if iscod:
-                return 7, iscod, otgAvailable
+                    return 7, iscod, otgAvailable
     if billingWarehouseId not in [12,13] and serviceable_location_cache.has_key(46) and serviceable_location_cache.get(46).has_key(destination_pin):
         if item_selling_price < 3000 and serviceable_location_cache.has_key(1) and serviceable_location_cache.get(1).has_key(destination_pin):
             dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(1).get(destination_pin)
             if item_selling_price <= providerPrepaidLimit:
                 iscod = iscod and item_selling_price <= websiteCodLimit
                 otgAvailable = otgAvailable and item_selling_price >= 2000
+                if iscod:
-                return 1, iscod, otgAvailable
+                    return 1, iscod, otgAvailable
         else:
             dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(46).get(destination_pin)
             if item_selling_price <= providerPrepaidLimit:
                 iscod = iscod and item_selling_price <= websiteCodLimit
                 otgAvailable = otgAvailable and item_selling_price >= 2000
+                if iscod:
-                return 46, iscod, otgAvailable
+                    return 46, iscod, otgAvailable
     if serviceable_location_cache.has_key(1) and serviceable_location_cache.get(1).has_key(destination_pin):
         dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(1).get(destination_pin)
         if item_selling_price <= providerPrepaidLimit:
             iscod = iscod and item_selling_price <= websiteCodLimit
             otgAvailable = otgAvailable and item_selling_price >= 2000
+            if iscod:
-            return 1, iscod, otgAvailable
+                return 1, iscod, otgAvailable
+    if serviceable_location_cache.has_key(3) and serviceable_location_cache.get(3).has_key(destination_pin):
+        dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit = serviceable_location_cache.get(3).get(destination_pin)
+        if item_selling_price <= providerPrepaidLimit:
+            iscod = iscod and item_selling_price <= websiteCodLimit
+            otgAvailable = otgAvailable and item_selling_price >= 2000
+            return 3, iscod, otgAvailable
     return None, False, False
 def get_destination_code(providerId, pinCode):
     serviceableLocationDetail = ServiceableLocationDetails.query.filter_by(provider_id = providerId, dest_pincode = pinCode).one()
     return serviceableLocationDetail.dest_code
             awb.awb_number = number
             awb.provider_id = provider_id
             awb.is_available = True
             awb.type = type
     session.commit()
-def get_pincode_item_serviceability():
-    pass
 def set_AWB_as_used(awb_number):
     query = Awb.query.filter_by(awb_number = awb_number)
     awb = query.one()
     awb.is_available=False
     sp = client.getStorePricing(itemId)
     if codAllowed:
         return sp.minAdvancePrice, True
     else:
-        dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit = serviceable_location_cache.get(providerId).get(destination_pin)
+        dest_code, exp, iscod, otgAvailable, websiteCodLimit, storeCodLimit, providerPrepaidLimit, providerCodLimit  = serviceable_location_cache.get(providerId).get(destination_pin)
         if iscod:
             if providerId == 6:
                 return max(sp.minAdvancePrice, sp.recommendedPrice - storeCodLimit), True
             if providerId == 3:
                 return max(sp.minAdvancePrice, sp.recommendedPrice - storeCodLimit), True

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/logistics/service/impl/DataAccessor.py – Rev 19663 → 20275