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

     heldInventoryMap = {}
     holdInventories = HoldInventoryDetail.query.filter_by(item_id= itemId, warehouse_id = warehouseId).all()
     for holdInventory in holdInventories:
         heldInventoryMap[holdInventory.source] = holdInventory.held
     return heldInventoryMap
+def get_hold_inventory_details(itemId, warehouseId, source):
+    heldInventoryQuery = HoldInventoryDetail.query
+    if itemId:
+        heldInventoryQuery = heldInventoryQuery.filter_by(item_id = itemId)
+    if warehouseId:
+        heldInventoryQuery = heldInventoryQuery.filter_by(warehouse_id = warehouseId)
+    if source:
+        heldInventoryQuery = heldInventoryQuery.filter_by(source = source)
+    holdInventoryDetails = heldInventoryQuery.all()
+    return holdInventoryDetails

Subversion Repositories SmartDukaan