Subversion Repositories SmartDukaan

Rev

Rev 18473 | Rev 18475 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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