| Line 1128... |
Line 1128... |
| 1128 |
print "OOS Status already exists for ItemID:"+str(itemId)
|
1128 |
print "OOS Status already exists for ItemID:"+str(itemId)
|
| 1129 |
"""raise InventoryServiceException(101, "OOS Status already exists for ItemID:"+str(itemId) + " & Date:"+oosDate)"""
|
1129 |
"""raise InventoryServiceException(101, "OOS Status already exists for ItemID:"+str(itemId) + " & Date:"+oosDate)"""
|
| 1130 |
|
1130 |
|
| 1131 |
def get_oos_statuses_for_x_days_for_item(itemId, days):
|
1131 |
def get_oos_statuses_for_x_days_for_item(itemId, days):
|
| 1132 |
timestamp = datetime.datetime.now()
|
1132 |
timestamp = datetime.datetime.now()
|
| 1133 |
timestamp = timestamp - datetime.timedelta(days = 6)
|
1133 |
timestamp = timestamp - datetime.timedelta(days = days)
|
| 1134 |
return OOSStatus.query.filter_by(item_id = itemId).filter(OOSStatus.date > timestamp).all()
|
1134 |
return OOSStatus.query.filter_by(item_id = itemId).filter(OOSStatus.date > timestamp).all()
|
| 1135 |
|
1135 |
|
| 1136 |
def get_non_zero_item_stock_purchase_params():
|
1136 |
def get_non_zero_item_stock_purchase_params():
|
| 1137 |
return ItemStockPurchaseParams.query.filter(or_("numOfDaysStock!=0","minStockLevel!=0"))
|
1137 |
return ItemStockPurchaseParams.query.filter(or_("numOfDaysStock!=0","minStockLevel!=0"))
|
| 1138 |
|
1138 |
|
| Line 1259... |
Line 1259... |
| 1259 |
if vendoritempricing is None:
|
1259 |
if vendoritempricing is None:
|
| 1260 |
return 0
|
1260 |
return 0
|
| 1261 |
return vendoritempricing.nlc
|
1261 |
return vendoritempricing.nlc
|
| 1262 |
|
1262 |
|
| 1263 |
def get_snapdeal_inventory_snapshot():
|
1263 |
def get_snapdeal_inventory_snapshot():
|
| 1264 |
return SnapdealInventorySnapshot.query.all()
|
- |
|
| 1265 |
|
1264 |
return SnapdealInventorySnapshot.query.all()
|
| - |
|
1265 |
def get_held_inventory_map_for_item(itemId, warehouseId):
|
| - |
|
1266 |
heldInventoryMap = {}
|
| - |
|
1267 |
holdInventories = HoldInventoryDetail.query.filter_by(item_id= itemId, warehouse_id = warehouseId).all()
|
| - |
|
1268 |
for holdInventory in holdInventories:
|
| - |
|
1269 |
heldInventoryMap[holdInventory.source] = holdInventory.held
|
| - |
|
1270 |
return heldInventoryMap
|
| - |
|
1271 |
|
| - |
|
1272 |
|
| 1266 |
|
1273 |
|