WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/purchase/main/script/PendingPurchaseOrderReport.py

         """
         try:
             purchaseOrders = []
             transactionClient = TransactionClient().get_client()
-            pending_orders = transactionClient.getOrdersInBatch([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.ACCEPTED], 0, 0, warehouseId, 0)
+            pending_orders = transactionClient.getOrdersInBatch([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.ACCEPTED, OrderStatus.COD_VERIFICATION_PENDING], 0, 0, warehouseId, 0)
             if not pending_orders:
                 return purchaseOrders
             inventory_client = InventoryClient().get_client()
             availability = {}
+            virtualInventory = {}
             ourGoodWarehouseIds = [w.id for w in inventory_client.getWarehouses(WarehouseType.OURS, InventoryType.GOOD, 0, None, warehouseId)]
+            ourVirtualWarehouseIds = [w.id for w in inventory_client.getWarehouses(WarehouseType.THIRD_PARTY, InventoryType.GOOD, 0, None, warehouseId)]
             itemInventorySnapshot = inventory_client.getInventorySnapshot(0)
             for itemId, itemInventory in itemInventorySnapshot.iteritems():
                 '''item = self.__get_item_from_master(itemId)'''
                 for warehouseId, quantity in itemInventory.availability.iteritems():
                     if warehouseId in ourGoodWarehouseIds:
                         if availability.has_key(itemId):
                             availability[itemId] = [availability[itemId][0] + quantity]
                         else:
                             availability[itemId] = [quantity]
+                    if warehouseId in ourVirtualWarehouseIds:
+                        if virtualInventory.has_key(itemId):
+                            virtualInventory[itemId] = [virtualInventory[itemId][0] + quantity]
+                        else:
+                            virtualInventory[itemId] = [quantity]
             previouslyOrderedQty = {}
             unfulfilledPurchaseOrders = PurchaseOrder.query.filter(or_(PurchaseOrder.status == POStatus.PARTIALLY_FULFILLED, PurchaseOrder.status == POStatus.READY)).filter(PurchaseOrder.type == POType.REAL).all()
             for purchaseOrder in unfulfilledPurchaseOrders:
                 for lineitem in purchaseOrder.lineitems:
                     if previouslyOrderedQty.has_key(lineitem.itemId):
                         '''item = self.__get_item_from_master(lineitem.itemId)'''
                         availability[lineitem.itemId] = [lineitem.unfulfilledQuantity]
             codRequirements = {}
             requirements = {}
+            verificationPendingOrders = {}
             for order in pending_orders:
                 if order.purchaseOrderId:
                     continue
                 for lineitem in order.lineitems:
                     if (requirements.has_key(lineitem.item_id)):
-                        requirements[lineitem.item_id] += lineitem.quantity
+                        requirements[lineitem.item_id] = requirements.get(lineitem.item_id) + lineitem.quantity
                     else:
                         requirements[lineitem.item_id] = lineitem.quantity
                     if order.cod:
                         if (codRequirements.has_key(lineitem.item_id)):
-                            codRequirements[lineitem.item_id] += lineitem.quantity
+                            codRequirements[lineitem.item_id] = codRequirements.get(lineitem.item_id) + lineitem.quantity
                         else:
                             codRequirements[lineitem.item_id] = lineitem.quantity
+                        if order.status == OrderStatus.COD_VERIFICATION_PENDING:
+                            if (verificationPendingOrders.has_key(lineitem.item_id)):
+                                verificationPendingOrders[lineitem.item_id] = verificationPendingOrders.get(lineitem.item_id) + lineitem.quantity
+                            else:
+                                verificationPendingOrders[lineitem.item_id] = lineitem.quantity
             advancedPOParameters = {}
             SKUListForPO = []
             inventory_client = InventoryClient().get_client()
             itemStockPurchaseParams = inventory_client.getNonZeroItemStockPurchaseParams()
                     t_po_lineitem['numberOfDaysInStock'] = advancedPOParameters[item.id][2]
                     t_po_lineitem['minStockLevel'] = advancedPOParameters[item.id][3]
                     t_po_lineitem['numberOfDaysStock'] = advancedPOParameters[item.id][4]
                     t_po_lineitem['lastXdaysSale'] = advancedPOParameters[item.id][5]
                     t_po_lineitem['rtoOrders'] = advancedPOParameters[item.id][6]
+                    if verificationPendingOrders.has_key(item.id):
+                        t_po_lineitem['verificationPending'] = verificationPendingOrders[item.id]
+                    else:
+                        t_po_lineitem['verificationPending'] = 0
+                    if virtualInventory.has_key(item.id):
+                        t_po_lineitem['virtualStock'] = virtualInventory[item.id]
+                    else:
+                        t_po_lineitem['virtualStock'] = 0
                     if previouslyOrderedQty.has_key(item.id):
                         t_po_lineitem['previouslyOrderedQty'] = previouslyOrderedQty[item.id]
                     else:
                         t_po_lineitem['previouslyOrderedQty'] = 0
                     if codRequirements.has_key(item.id):
     worksheet.write(row, inc(), 'Prepaid', boldStyle)
     worksheet.write(row, inc(), 'Transfer price', boldStyle)
     worksheet.write(row, inc(), 'Nlc', boldStyle)
     worksheet.write(row, inc(), 'Total amount', boldStyle)
     worksheet.write(row, inc(), 'Pack Quantity', boldStyle)
+    worksheet.write(row, inc(), 'Available Quantity', boldStyle)
+    worksheet.write(row, inc(), 'Virtual Stock', boldStyle)
     worksheet.write(row, inc(), 'NetPendingOrderQty', boldStyle)
     worksheet.write(row, inc(), 'PreviouslyOrderedQty', boldStyle)
     worksheet.write(row, inc(), 'AverageSale', boldStyle)
     worksheet.write(row, inc(), 'Pending RTOs', boldStyle)
+    worksheet.write(row, inc(), 'COD Pending Orders', boldStyle)
     worksheet.write(row, inc(), 'NumDaysStock', boldStyle)
     worksheet.write(row, inc(), 'MinStockReq', boldStyle)
     worksheet.write(row, inc(), 'Additional Qty', boldStyle)
             worksheet.write(row, inc(), float(lineitem.get('suggestedQuantity')) * float(lineitem.get('unitPrice')))
             worksheet.write(row, inc(), lineitem.get('packQuantity'))
             reservedCount = 0
             if lineitem.get('reservedQuantity') is not None:
                 reservedCount = lineitem.get('reservedQuantity')
+            worksheet.write(row, inc(), long(lineitem.get('availableQuantity')))
+            worksheet.write(row, inc(), lineitem.get('virtualStock'))
-            worksheet.write(row, inc(), long(reservedCount))-long(lineitem.get('availableQuantity'))
+            worksheet.write(row, inc(), long(reservedCount)-long(lineitem.get('availableQuantity')))
             worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
             worksheet.write(row, inc(), "("+lineitem.get('lastXdaysSale')+")"+str(lineitem.get('avgSales')))
             worksheet.write(row, inc(), lineitem.get('rtoOrders'))
+            worksheet.write(row, inc(), lineitem.get('verificationPending'))
             worksheet.write(row, inc(), lineitem.get('numberOfDaysStock'))
             worksheet.write(row, inc(), lineitem.get('minStockLevel'))
             stockThroughAvgSales = float(lineitem.get('avgSales')) * float(lineitem.get('numberOfDaysStock'))
             additionalQty = 0

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/purchase/main/script/PendingPurchaseOrderReport.py – Rev 18423 → 18425