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

 from sqlalchemy.sql import or_
 from elixir import session
 import datetime, time
 import sys
 import logging
+import os
 from shop2020.clients.CatalogClient import CatalogClient
 logging.basicConfig(level=logging.DEBUG)
 warehouse_allocation_cache = {}
 serviceable_location_cache = {}
     serviceableLocationDetails.exp = exp
     serviceableLocationDetails.cod = cod
     serviceableLocationDetails.otgAvailable = otgAvailable
     session.commit()
-def add_new_awbs(provider_id, isCod, awbs):
+def add_new_awbs(provider_id, isCod, awbs, awbUsedFor):
     provider = get_provider(provider_id)
     if isCod:
         dtype = 'Cod'
     else:
         dtype = 'Prepaid'
     for awb in awbs:
         a = Awb()
         a.type =  dtype
         a.is_available = True
         a.awb_number = awb
+        a.awbUsedFor = awbUsedFor
         a.provider = provider
     session.commit()
     return True
 def adjust_delivery_time(start_time, delivery_days):
     delEstimate = DeliveryEstimate.query.filter(DeliveryEstimate.destination_pin == pincode).filter(DeliveryEstimate.warehouse_location == whLocation).first()
     if delEstimate is None:
         return -1
     else:
         return 1
+def get_provider_limit_details_for_pincode(provider, pincode):
+    serviceAbleDetails = ServiceableLocationDetails.get_by(provider_id = provider, dest_pincode = pincode)
+    returnDataMap = {}
+    if serviceAbleDetails:
+        returnDataMap["websiteCodLimit"] = str(serviceAbleDetails.websiteCodLimit)
+        returnDataMap["providerPrepaidLimit"] = str(serviceAbleDetails.providerPrepaidLimit)
+    return returnDataMap
+def get_new_empty_awb(providerId, type, orderQuantity):
+    query = Awb.query.with_lockmode("update").filter_by(provider_id = providerId, is_available = True)  #check the provider thing
+    if type == DeliveryType.PREPAID:
+        query = query.filter_by(type="Prepaid")
+    if type == DeliveryType.COD:
+        query = query.filter_by(type="COD")
+    additionalQuery = query
+    if orderQuantity == 1:
+        query = query.filter_by(awbUsedFor=0)
+    if orderQuantity >1:
+        query = query.filter_by(awbUsedFor=1)
+    try:
+        awb = query.first()
+        if awb is None:
+            additionalQuery = additionalQuery.filter_by(awbUsedFor=2)
+            awb = additionalQuery.first()
+        awb.is_available = False
+        session.commit()
+        return awb.awb_number
+    except:
+        raise LogisticsServiceException(103, "Unable to get an AWB for the given Provider: " + str(providerId))

Subversion Repositories SmartDukaan

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