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
 
 
datetime_format = xlwt.XFStyle()
datetime_format.num_format_str = 'dd/mm/yyyy HH:MM AM/PM'
 
class PurchaseHandler:

        Creates purchase order objects from pending orders
    
        Parameters:
         - warehouseId
        """
        errorsMap={}
        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:
                return purchaseOrders, errorsMap
    
            inventory_client = InventoryClient().get_client()
            availability = {}
            virtualInventory = {}
            

                        netRequirements[item.preferredVendor].append([item, requirementsCount])
                    else:
                        netRequirements[item.preferredVendor] = [[item, requirementsCount]];
    
            if not netRequirements:
                return purchaseOrders, errorsMap
    
            
            suppliersMap = {}
            for supplier in self.getSuppliers():
                suppliersMap[supplier.id] = supplier

                    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 errorsMap
            return purchaseOrders, errorsMap
        except Exception as e:
            print e
            print sys.exc_info()[0]
        finally:
            self.close_session()

    mailServer.login(SENDER, PASSWORD)
    mailServer.sendmail(SENDER, MAILTO, msg.as_string())
      
def main():
    global i
 
 
    i = -1
    row = 0
    wb = xlwt.Workbook()
    worksheet = wb.add_sheet("All Pending Purchase Orders")
    worksheet.write(row, inc(), 'Supplier Name', boldStyle)

    worksheet.write(row, inc(), 'Additional Qty', boldStyle)
    worksheet.write(row, inc(), 'Errors', boldStyle)
    
    
    purchaseHandler = PurchaseHandler()
    pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7)
    print pendingPurchaseOrders
    for purchaseOrder in pendingPurchaseOrders:
        for lineitem in purchaseOrder.get('lineitems'):
            row += 1
            i=-1

Rev 18473	Rev 18474
Line 44...	Line 44...
44	`boldStyle = xlwt.XFStyle()`	44	`boldStyle = xlwt.XFStyle()`
45	`f = xlwt.Font()`	45	`f = xlwt.Font()`
46	`f.bold = True`	46	`f.bold = True`
47	`boldStyle.font = f`	47	`boldStyle.font = f`
48	`i = -1`	48	`i = -1`
49	`errorsMap={}`	-
50		49
51	`datetime_format = xlwt.XFStyle()`	50	`datetime_format = xlwt.XFStyle()`
52	`datetime_format.num_format_str = 'dd/mm/yyyy HH:MM AM/PM'`	51	`datetime_format.num_format_str = 'dd/mm/yyyy HH:MM AM/PM'`
53		52
54	`class PurchaseHandler:`	53	`class PurchaseHandler:`
Line 76...	Line 75...
76	`Creates purchase order objects from pending orders`	75	`Creates purchase order objects from pending orders`
77		76
78	`Parameters:`	77	`Parameters:`
79	`- warehouseId`	78	`- warehouseId`
80	`"""`	79	`"""`
81	`global errorsMap`	80	`errorsMap={}`
82	`try:`	81	`try:`
83	`purchaseOrders = []`	82	`purchaseOrders = []`
84		83
85	`transactionClient = TransactionClient().get_client()`	84	`transactionClient = TransactionClient().get_client()`
86	`pending_orders = transactionClient.getOrdersInBatch([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.ACCEPTED, OrderStatus.COD_VERIFICATION_PENDING], 0, 0, warehouseId, 0)`	85	`pending_orders = transactionClient.getOrdersInBatch([OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.ACCEPTED, OrderStatus.COD_VERIFICATION_PENDING], 0, 0, warehouseId, 0)`
87		86
88	`if not pending_orders:`	87	`if not pending_orders:`
89	`return purchaseOrders`	88	`return purchaseOrders, errorsMap`
90		89
91	`inventory_client = InventoryClient().get_client()`	90	`inventory_client = InventoryClient().get_client()`
92	`availability = {}`	91	`availability = {}`
93	`virtualInventory = {}`	92	`virtualInventory = {}`
94		93
Line 261...	Line 260...
261	`netRequirements[item.preferredVendor].append([item, requirementsCount])`	260	`netRequirements[item.preferredVendor].append([item, requirementsCount])`
262	`else:`	261	`else:`
263	`netRequirements[item.preferredVendor] = [[item, requirementsCount]];`	262	`netRequirements[item.preferredVendor] = [[item, requirementsCount]];`
264		263
265	`if not netRequirements:`	264	`if not netRequirements:`
266	`return purchaseOrders`	265	`return purchaseOrders, errorsMap`
267		266
268		267
269	`suppliersMap = {}`	268	`suppliersMap = {}`
270	`for supplier in self.getSuppliers():`	269	`for supplier in self.getSuppliers():`
271	`suppliersMap[supplier.id] = supplier`	270	`suppliersMap[supplier.id] = supplier`
Line 338...	Line 337...
338	`t_po_lineitem['unitPrice'] = item_pricing.transferPrice`	337	`t_po_lineitem['unitPrice'] = item_pricing.transferPrice`
339	`t_po_lineitem['nlc'] = item_pricing.nlc`	338	`t_po_lineitem['nlc'] = item_pricing.nlc`
340	`t_po_lineitem['mrp'] = item.mrp`	339	`t_po_lineitem['mrp'] = item.mrp`
341	`t_purchase_order['lineitems'].append(t_po_lineitem)`	340	`t_purchase_order['lineitems'].append(t_po_lineitem)`
342	`purchaseOrders.append(t_purchase_order)`	341	`purchaseOrders.append(t_purchase_order)`
-		342	`print errorsMap`
343	`return purchaseOrders`	343	`return purchaseOrders, errorsMap`
344	`except Exception as e:`	344	`except Exception as e:`
345	`print e`	345	`print e`
346	`print sys.exc_info()[0]`	346	`print sys.exc_info()[0]`
347	`finally:`	347	`finally:`
348	`self.close_session()`	348	`self.close_session()`
Line 389...	Line 389...
389	`mailServer.login(SENDER, PASSWORD)`	389	`mailServer.login(SENDER, PASSWORD)`
390	`mailServer.sendmail(SENDER, MAILTO, msg.as_string())`	390	`mailServer.sendmail(SENDER, MAILTO, msg.as_string())`
391		391
392	`def main():`	392	`def main():`
393	`global i`	393	`global i`
394	`global errorsMap`	-
395	`print "ErrorsMap .....", errorsMap`	-
396	`i = -1`	394	`i = -1`
397	`row = 0`	395	`row = 0`
398	`wb = xlwt.Workbook()`	396	`wb = xlwt.Workbook()`
399	`worksheet = wb.add_sheet("All Pending Purchase Orders")`	397	`worksheet = wb.add_sheet("All Pending Purchase Orders")`
400	`worksheet.write(row, inc(), 'Supplier Name', boldStyle)`	398	`worksheet.write(row, inc(), 'Supplier Name', boldStyle)`
Line 420...	Line 418...
420	`worksheet.write(row, inc(), 'Additional Qty', boldStyle)`	418	`worksheet.write(row, inc(), 'Additional Qty', boldStyle)`
421	`worksheet.write(row, inc(), 'Errors', boldStyle)`	419	`worksheet.write(row, inc(), 'Errors', boldStyle)`
422		420
423		421
424	`purchaseHandler = PurchaseHandler()`	422	`purchaseHandler = PurchaseHandler()`
425	`pendingPurchaseOrders = purchaseHandler.getPendingPurchaseOrders(7)`	423	`pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7)`
426	`print pendingPurchaseOrders`	424	`print pendingPurchaseOrders`
427	`for purchaseOrder in pendingPurchaseOrders:`	425	`for purchaseOrder in pendingPurchaseOrders:`
428	`for lineitem in purchaseOrder.get('lineitems'):`	426	`for lineitem in purchaseOrder.get('lineitems'):`
429	`row += 1`	427	`row += 1`
430	`i=-1`	428	`i=-1`

Subversion Repositories SmartDukaan

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