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, OrderStatus.COD_VERIFICATION_PENDING], 0, 0, warehouseId, 0)
            
            
            if not pending_orders:
                print "pendingOrders empty"
                return purchaseOrders, errorsMap
    
            inventory_client = InventoryClient().get_client()
            availability = {}
            virtualInventory = {}

                salesCount = 0
                numDaysInStock = 0
                rtoCount = 0
                avgSales = 0.0
                lastXdaysSale = ""
                oosStatus = None
                for oosStatus in oosStatuses:
                    if oosStatus.is_oos == False:
                        salesCount = salesCount + oosStatus.num_orders
                        numDaysInStock = numDaysInStock + 1
                        lastXdaysSale = lastXdaysSale + str(oosStatus.num_orders) + "-" 
                    else:
                        lastXdaysSale = lastXdaysSale + "X-"
                lastXdaysSale = lastXdaysSale[:-1]
                if oosStatus and oosStatus.rto_orders:
                    rtoCount = oosStatus.rto_orders
                if numDaysInStock>0:
                    avgSales = float(salesCount)/float(numDaysInStock)
                itemStockPurchaseParam = None
                try:

                    t_po_lineitem['unitPrice'] = item_pricing.transferPrice
                    t_po_lineitem['nlc'] = item_pricing.nlc
                    t_po_lineitem['mrp'] = item.mrp
                    t_purchase_order['lineitems'].append(t_po_lineitem)
                purchaseOrders.append(t_purchase_order)
            print "errorMap : ", errorsMap
            return purchaseOrders, errorsMap
        except Exception as e:
            traceback.print_exc()
        finally:
            self.close_session()

    worksheet.write(row, inc(), 'Additional Qty', boldStyle)
    worksheet.write(row, inc(), 'Errors', boldStyle)
    
    
    purchaseHandler = PurchaseHandler()
    pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7441)
    print errorsMap
    print pendingPurchaseOrders
    
    for itemId, error in errorsMap.items():
        row += 1

Rev 20172	Rev 23124
Line 83...	Line 83...
83	`try:`	83	`try:`
84	`purchaseOrders = []`	84	`purchaseOrders = []`
85		85
86	`transactionClient = TransactionClient().get_client()`	86	`transactionClient = TransactionClient().get_client()`
87	`pending_orders = transactionClient.getOrdersInBatch([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.ACCEPTED, OrderStatus.COD_VERIFICATION_PENDING], 0, 0, warehouseId, 0)`	87	`pending_orders = transactionClient.getOrdersInBatch([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.ACCEPTED, OrderStatus.COD_VERIFICATION_PENDING], 0, 0, warehouseId, 0)`
-		88
88		89
89	`if not pending_orders:`	90	`if not pending_orders:`
-		91	`print "pendingOrders empty"`
90	`return purchaseOrders, errorsMap`	92	`return purchaseOrders, errorsMap`
91		93
92	`inventory_client = InventoryClient().get_client()`	94	`inventory_client = InventoryClient().get_client()`
93	`availability = {}`	95	`availability = {}`
94	`virtualInventory = {}`	96	`virtualInventory = {}`
Line 202...	Line 204...
202	`salesCount = 0`	204	`salesCount = 0`
203	`numDaysInStock = 0`	205	`numDaysInStock = 0`
204	`rtoCount = 0`	206	`rtoCount = 0`
205	`avgSales = 0.0`	207	`avgSales = 0.0`
206	`lastXdaysSale = ""`	208	`lastXdaysSale = ""`
-		209	`oosStatus = None`
207	`for oosStatus in oosStatuses:`	210	`for oosStatus in oosStatuses:`
208	`if oosStatus.is_oos == False:`	211	`if oosStatus.is_oos == False:`
209	`salesCount = salesCount + oosStatus.num_orders`	212	`salesCount = salesCount + oosStatus.num_orders`
210	`numDaysInStock = numDaysInStock + 1`	213	`numDaysInStock = numDaysInStock + 1`
211	`lastXdaysSale = lastXdaysSale + str(oosStatus.num_orders) + "-"`	214	`lastXdaysSale = lastXdaysSale + str(oosStatus.num_orders) + "-"`
212	`else:`	215	`else:`
213	`lastXdaysSale = lastXdaysSale + "X-"`	216	`lastXdaysSale = lastXdaysSale + "X-"`
214	`lastXdaysSale = lastXdaysSale[:-1]`	217	`lastXdaysSale = lastXdaysSale[:-1]`
215	`if oosStatus.rto_orders:`	218	`if oosStatus and oosStatus.rto_orders:`
216	`rtoCount = oosStatus.rto_orders`	219	`rtoCount = oosStatus.rto_orders`
217	`if numDaysInStock>0:`	220	`if numDaysInStock>0:`
218	`avgSales = float(salesCount)/float(numDaysInStock)`	221	`avgSales = float(salesCount)/float(numDaysInStock)`
219	`itemStockPurchaseParam = None`	222	`itemStockPurchaseParam = None`
220	`try:`	223	`try:`
Line 350...	Line 353...
350	`t_po_lineitem['unitPrice'] = item_pricing.transferPrice`	353	`t_po_lineitem['unitPrice'] = item_pricing.transferPrice`
351	`t_po_lineitem['nlc'] = item_pricing.nlc`	354	`t_po_lineitem['nlc'] = item_pricing.nlc`
352	`t_po_lineitem['mrp'] = item.mrp`	355	`t_po_lineitem['mrp'] = item.mrp`
353	`t_purchase_order['lineitems'].append(t_po_lineitem)`	356	`t_purchase_order['lineitems'].append(t_po_lineitem)`
354	`purchaseOrders.append(t_purchase_order)`	357	`purchaseOrders.append(t_purchase_order)`
355	`print errorsMap`	358	`print "errorMap : ", errorsMap`
356	`return purchaseOrders, errorsMap`	359	`return purchaseOrders, errorsMap`
357	`except Exception as e:`	360	`except Exception as e:`
358	`traceback.print_exc()`	361	`traceback.print_exc()`
359	`finally:`	362	`finally:`
360	`self.close_session()`	363	`self.close_session()`
Line 430...	Line 433...
430	`worksheet.write(row, inc(), 'Additional Qty', boldStyle)`	433	`worksheet.write(row, inc(), 'Additional Qty', boldStyle)`
431	`worksheet.write(row, inc(), 'Errors', boldStyle)`	434	`worksheet.write(row, inc(), 'Errors', boldStyle)`
432		435
433		436
434	`purchaseHandler = PurchaseHandler()`	437	`purchaseHandler = PurchaseHandler()`
435	`pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7)`	438	`pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7441)`
436	`print errorsMap`	439	`print errorsMap`
437	`print pendingPurchaseOrders`	440	`print pendingPurchaseOrders`
438		441
439	`for itemId, error in errorsMap.items():`	442	`for itemId, error in errorsMap.items():`
440	`row += 1`	443	`row += 1`

Subversion Repositories SmartDukaan

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