| Line 331... |
Line 331... |
| 331 |
errorsMap[item.id] = errorsMap.get(item.id) + "| Could not find transfer price for vendor id: " + str(vendorId) +" "
|
331 |
errorsMap[item.id] = errorsMap.get(item.id) + "| Could not find transfer price for vendor id: " + str(vendorId) +" "
|
| 332 |
else:
|
332 |
else:
|
| 333 |
errorsMap[item.id] = "Could not find transfer price for vendor id: " + str(vendorId) +" "
|
333 |
errorsMap[item.id] = "Could not find transfer price for vendor id: " + str(vendorId) +" "
|
| 334 |
print 'Could not find transfer price for Item id: ' + str(item.id) + ' and vendor id: ' + str(vendorId)
|
334 |
print 'Could not find transfer price for Item id: ' + str(item.id) + ' and vendor id: ' + str(vendorId)
|
| 335 |
print e
|
335 |
print e
|
| - |
|
336 |
t_po_lineitem['unitPrice'] = item_pricing.transferPrice
|
| - |
|
337 |
t_po_lineitem['nlc'] = item_pricing.nlc
|
| - |
|
338 |
t_po_lineitem['mrp'] = item.mrp
|
| - |
|
339 |
t_purchase_order['lineitems'].append(t_po_lineitem)
|
| - |
|
340 |
purchaseOrders.append(t_purchase_order)
|
| 336 |
continue
|
341 |
continue
|
| 337 |
t_po_lineitem['unitPrice'] = item_pricing.transferPrice
|
342 |
t_po_lineitem['unitPrice'] = item_pricing.transferPrice
|
| 338 |
t_po_lineitem['nlc'] = item_pricing.nlc
|
343 |
t_po_lineitem['nlc'] = item_pricing.nlc
|
| 339 |
t_po_lineitem['mrp'] = item.mrp
|
344 |
t_po_lineitem['mrp'] = item.mrp
|
| 340 |
t_purchase_order['lineitems'].append(t_po_lineitem)
|
345 |
t_purchase_order['lineitems'].append(t_po_lineitem)
|
| Line 421... |
Line 426... |
| 421 |
|
426 |
|
| 422 |
purchaseHandler = PurchaseHandler()
|
427 |
purchaseHandler = PurchaseHandler()
|
| 423 |
pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7)
|
428 |
pendingPurchaseOrders, errorsMap = purchaseHandler.getPendingPurchaseOrders(7)
|
| 424 |
print errorsMap
|
429 |
print errorsMap
|
| 425 |
print pendingPurchaseOrders
|
430 |
print pendingPurchaseOrders
|
| - |
|
431 |
|
| - |
|
432 |
for itemId, error in errorsMap.items():
|
| - |
|
433 |
row += 1
|
| - |
|
434 |
i=-1
|
| - |
|
435 |
worksheet.write(row, inc(), "Not_defined")
|
| - |
|
436 |
worksheet.write(row, inc(), str(itemId))
|
| - |
|
437 |
item = purchaseHandler.__get_item_from_master(itemId)
|
| - |
|
438 |
worksheet.write(row, inc(), item.brand+" "+item.model_name+" "+item.model_number+" "+item.color)
|
| - |
|
439 |
worksheet.write(row, inc(), 0)
|
| - |
|
440 |
|
| - |
|
441 |
worksheet.write(row, inc(), 0)
|
| - |
|
442 |
worksheet.write(row, inc(), 0)
|
| - |
|
443 |
worksheet.write(row, inc(), 0)
|
| - |
|
444 |
worksheet.write(row, inc(), 0)
|
| - |
|
445 |
worksheet.write(row, inc(), 0)
|
| - |
|
446 |
worksheet.write(row, inc(), 0)
|
| - |
|
447 |
worksheet.write(row, inc(), 0)
|
| - |
|
448 |
worksheet.write(row, inc(), 0)
|
| - |
|
449 |
worksheet.write(row, inc(), 0)
|
| - |
|
450 |
worksheet.write(row, inc(), 0)
|
| - |
|
451 |
worksheet.write(row, inc(), 0)
|
| - |
|
452 |
worksheet.write(row, inc(), "Not_defined")
|
| - |
|
453 |
worksheet.write(row, inc(), 0)
|
| - |
|
454 |
worksheet.write(row, inc(), 0)
|
| - |
|
455 |
worksheet.write(row, inc(), 0)
|
| - |
|
456 |
worksheet.write(row, inc(), 0)
|
| - |
|
457 |
worksheet.write(row, inc(), 0)
|
| - |
|
458 |
worksheet.write(row, inc(), error)
|
| - |
|
459 |
worksheet.write(row, inc(), error)
|
| - |
|
460 |
|
| 426 |
for purchaseOrder in pendingPurchaseOrders:
|
461 |
for purchaseOrder in pendingPurchaseOrders:
|
| 427 |
for lineitem in purchaseOrder.get('lineitems'):
|
462 |
for lineitem in purchaseOrder.get('lineitems'):
|
| 428 |
row += 1
|
463 |
row += 1
|
| 429 |
i=-1
|
464 |
i=-1
|
| 430 |
worksheet.write(row, inc(), purchaseOrder.get('SupplierName'))
|
465 |
worksheet.write(row, inc(), purchaseOrder.get('SupplierName'))
|