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

 from shop2020.model.v1.catalog.impl.CategoryManager import CategoryManager
 from shop2020.model.v1.catalog.impl.Convertors import to_t_item, to_t_source
 from shop2020.model.v1.catalog.impl.DataService import Item, ItemChangeLog, \
     Category, EntityIDGenerator, SimilarItems, ProductNotification, Source, \
     SourceItemPricing, AuthorizationLog, VoucherItemMapping, CategoryVatMaster, \
-    OOSTracker,EntityTag,ItemInsurerMapping, Insurer, Banner, BannerMap, FreebieItem
+    OOSTracker,EntityTag,ItemInsurerMapping, Insurer, Banner, BannerMap, FreebieItem,\
+    StorePricing
 from shop2020.thriftpy.model.v1.catalog.ttypes import status, ItemShippingInfo, \
-    ItemType, PremiumType, FreebieItem as t_FreebieItem
+    ItemType, PremiumType, FreebieItem as t_FreebieItem, StorePricing as tStorePricing
 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.risky = item.risky
     ds_item.type = ItemType._VALUES_TO_NAMES[item.type]
     ds_item.hasItemNo = item.hasItemNo
-    ds_item.clearance = item.clearance
+    ds_item.activeOnStore = item.activeOnStore
     if item.expectedDelay is not None:
         ds_item.expectedDelay = item.expectedDelay
     if item.preferredVendor:
     ds_item.defaultForEntity = item.defaultForEntity
     ds_item.risky = item.risky
     ds_item.type = ItemType._VALUES_TO_NAMES[item.type]
     ds_item.hasItemNo = item.hasItemNo
-    ds_item.clearance = item.clearance
+    ds_item.activeOnStore = item.activeOnStore
     if item.expectedDelay is not None:
         ds_item.expectedDelay = item.expectedDelay
     else:
         ds_item.expectedDelay = 0
     if item.mrp == None or item.sellingPrice == None or item.mrp == "" or item.sellingPrice == "":
         return
     if item.mrp < item.sellingPrice:
         print "[BAD MRP and SP:] for {0} {1} {2} {3}. MRP={4}, SP={5}".format(item.productGroup, item.brand, item.modelNumber, item.color, str(item.mrp), str(item.sellingPrice))
         raise InventoryServiceException(101, "[BAD MRP and SP:] for {0} {1} {2} {3}. MRP={4}, SP={5}".format(item.productGroup, item.brand, item.modelNumber, item.color, str(item.mrp), str(item.sellingPrice)))
+    if minp < item.sellingPrice:
+        print "alert to store"
+    if maxp > item.mrp:
+        print "reset to mrp"
+        print "alert to store"
     return
 def validate_vendor_prices(item, vendorPrices):
     if item.mrp != None and item.mrp != "" and vendorPrices.mop != "" and item.mrp <  vendorPrices.mop:
         print "[BAD MRP and MOP:] for {0} {1} {2} {3}. MRP={4}. MOP={5}, Vendor={6}".format(item.productGroup, item.brand, item.modelNumber, item.color, str(item.mrp), str(vendorPrices.mop), str(vendorPrices.vendorId))
         raise InventoryServiceException(101, "[BAD MRP and MOP:] for {0} {1} {2} {3}. MRP={4}. MOP={5}, Vendor={6}".format(item.productGroup, item.brand, item.modelNumber, item.color, str(item.mrp), str(vendorPrices.mop), str(vendorPrices.vendorId)))
     if vendorPrices.mop != "" and vendorPrices.transferPrice != "" and vendorPrices.transferPrice > vendorPrices.mop:
         print "[BAD MOP and TP:] for {0} {1} {2} {3}. TP={4}. MOP={5}, Vendor={6}".format(item.productGroup, item.brand, item.modelNumber, item.color, str(vendorPrices.transferPrice), str(vendorPrices.mop), str(vendorPrices.vendorId))
         raise InventoryServiceException(101, "[BAD MOP and TP:] for {0} {1} {2} {3}. TP={4}. MOP={5}, Vendor={6}".format(item.productGroup, item.brand, item.modelNumber, item.color, str(vendorPrices.transferPrice), str(vendorPrices.mop), str(vendorPrices.vendorId)))
+    if change in dp:
+        print "alert to store"
     return
 def check_color_valid(color):
     if color is not None:
         color = color.strip().lower()
         thread = threading.Thread(target=partial(mail, mail_user, mail_password, to_addresses, subject, message))
         thread.start()
     except Exception as ex:
         print ex
-def get_clearance_sale_catalog_ids():
-    all_status = [status.ACTIVE, status.PAUSED, status.PAUSED_BY_RISK]
-    query = Item.query.filter_by(clearance=True)
-    query = query.filter(Item.status.in_(all_status))
-    query = query.group_by(Item.catalog_item_id).order_by(desc(Item.startDate)).order_by(Item.catalog_item_id)
-    clearance_sales = query.all()
-    return [item.catalog_item_id for item in clearance_sales]
 def get_vat_amount_for_item(itemId, price):
     item = Item.query.filter_by(id=itemId).first()
     vatPercentage = item.vatPercentage
     if vatPercentage is None:
         vatMaster = CategoryVatMaster.query.filter(and_(CategoryVatMaster.categoryId==item.category, CategoryVatMaster.minVal<=price,  CategoryVatMaster.maxVal>=price)).first()
     freebie = FreebieItem.get_by(itemId = freebieItem.itemId)
     if freebie is None:
         freebie = FreebieItem()
         freebie.itemId = freebieItem.itemId
     freebie.freebieItemId = freebieItem.freebieItemId
-    session.commit()
     session.commit()
+def add_store_pricing(item, rp):
+    inventoryClient = InventoryClient().get_client()
+    pricings = inventoryClient.getAllItemPricing(item.id)
+    minp = 0
+    maxp = item.mrp
+    for pricing in pricings:
+        if not minp or minp > pricing.dealerPrice:
+            minp = pricing.dealerPrice
+    if minp < item.sellingPrice:
+        print "Alert to store"
+    if maxp < minp:
+        print "Alert to store"
+    if rp < minp or rp > maxp:
+        print "Alert to store"
+    minap = min(max(500, 10%rp),rp)
+    sp = StorePricing()
+    sp.recommendedPrice = rp
+    sp.minPrice = minp
+    sp.minAdvancePrice = minap
+    sp.maxPrice = maxp
+    sp.itemId = item.id
+    session.commit()
+def get_store_pricing(itemId):
+    store = StorePricing.get_by(itemId = itemId)
+    sp = tStorePricing()
+    sp.itemId = itemId
+    if store is None:
+        return sp
+    sp.recommendedPrice = store.recommendedPrice
+    sp.minPrice = store.minPrice
+    sp.minAdvancePrice = store.minAdvancePrice
+    sp.maxPrice = store.maxPrice
+    return sp

Subversion Repositories SmartDukaan

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