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

 boldStyle = xlwt.XFStyle()
 f = xlwt.Font()
 f.bold = True
 boldStyle.font = f
 i = -1
+errorsMap={}
 datetime_format = xlwt.XFStyle()
 datetime_format.num_format_str = 'dd/mm/yyyy HH:MM AM/PM'
 class PurchaseHandler:
                     avgSales = float(salesCount)/float(numDaysInStock)
                 itemStockPurchaseParam = ItemStockPurchaseParams()
                 try:
                     itemStockPurchaseParam = inventory_client.getItemStockPurchaseParams(key)
                 except Exception as e:
+                    if errorsMap.has_key(key):
+                        errorsMap[key] = errorsMap.get(key) + "| Item Stock Purchase Param Missing"
+                    else:
+                        errorsMap[key] = "Item Stock Purchase Param Missing "
+                    continue
                     inventory_client.updateItemStockPurchaseParams(key, 0, 0)
                     itemStockPurchaseParam = inventory_client.getItemStockPurchaseParams(key)
                 advancedPOParameters[key] = [round(avgSales * itemStockPurchaseParam.numOfDaysStock), round(avgSales,2), numDaysInStock, itemStockPurchaseParam.minStockLevel, itemStockPurchaseParam.numOfDaysStock, lastXdaysSale, rtoCount]
             cumulativeRequirementsItemIds = list(set(requirements.keys()+SKUListForPO))
                 if  availability.has_key(itemId):
                     availabilityCount = availability.get(itemId)[0]
                     item = self.__get_item_from_master(itemId)
                     if requirementsCount > availabilityCount or itemId in SKUListForPO:
                         if item.preferredVendor is None:
+                            if errorsMap.has_key(key):
-                            raise PurchaseServiceException(101, 'Preferred Vendor missing for ' + " ".join([str(item.brand), str(item.modelName), str(item.modelNumber), str(item.color)]))
+                                errorsMap[key] = errorsMap.get(key) + "| Preferred Vendor is Missing"
+                            else:
+                                errorsMap[key] = "Preferred Vendor is Missing "
+                            continue
                         if (netRequirements.has_key(item.preferredVendor)):
                             netRequirements[item.preferredVendor].append([item, requirementsCount - availabilityCount])
                         else:
                             netRequirements[item.preferredVendor] = [[item, requirementsCount - availabilityCount]];
                 else:
                     item = self.__get_item_from_master(itemId)
                     if item.preferredVendor is None:
+                        if errorsMap.has_key(key):
-                        raise PurchaseServiceException(101, 'Preferred Vendor missing for ' + " ".join([str(item.brand), str(item.modelName), str(item.modelNumber), str(item.color)]))
+                            errorsMap[key] = errorsMap.get(key) + "| Preferred Vendor is Missing"
+                        else:
+                            errorsMap[key] = "Preferred Vendor is Missing "
+                        continue
                     if (netRequirements.has_key(item.preferredVendor)):
                         netRequirements[item.preferredVendor].append([item, requirementsCount])
                     else:
                         netRequirements[item.preferredVendor] = [[item, requirementsCount]];
                     if codRequirements.has_key(item.id):
                         t_po_lineitem['codCount'] = min(codRequirements[item.id], quantity)
                     try:
                         item_pricing = inventory_client.getItemPricing(item.id, vendorId)
                     except Exception as e:
-                        vendor = self.getSupplier(vendorId)
+                        if errorsMap.has_key(key):
+                            errorsMap[key] = errorsMap.get(key) + "| Could not find transfer price for vendor id: " + str(vendorId) +" "
+                        else:
+                            errorsMap[key] = "Could not find transfer price for vendor id: " + str(vendorId) +" "
                         print 'Could not find transfer price for Item id: ' + str(item.id) + ' and vendor id: ' + str(vendorId)
                         print e
-                        raise PurchaseServiceException(101, 'Transfer price missing for ' + vendor.name + ' and ' + " ".join([item.brand, item.modelName, item.modelNumber, item.color]))
+                        continue
                     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)
     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(), 'Errors', boldStyle)
     purchaseHandler = PurchaseHandler()
     pendingPurchaseOrders = purchaseHandler.getPendingPurchaseOrders(7)
     print pendingPurchaseOrders
                 additionalQty = additionalQty - (float(lineitem.get('rtoOrders'))/2)
             if additionalQty<0:
                 additionalQty = 0
             worksheet.write(row, inc(), additionalQty)
+            error = "NA"
+            if errorsMap.has_key(lineitem.get('itemId')):
+                error = errorsMap.get(lineitem.get('itemId'))
+            worksheet.write(row, inc(), error)
     wb.save(XLS_O_FILENAME)
     sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com", "manish.sharma@shop2020.in"], "", "All Pending Purchase Orders", XLS_O_FILENAME)
     #sendmail(["manish.sharma@shop2020.in"], "", "All Pending Purchase Orders", XLS_O_FILENAME)

Subversion Repositories SmartDukaan

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