| Line 56... |
Line 56... |
| 56 |
availability = int(Amazon_Fba_Inventory_Map.get(itemId))
|
56 |
availability = int(Amazon_Fba_Inventory_Map.get(itemId))
|
| 57 |
stockQuantity = availability
|
57 |
stockQuantity = availability
|
| 58 |
grnDetail = "{"
|
58 |
grnDetail = "{"
|
| 59 |
weightedNlc = 0.0
|
59 |
weightedNlc = 0.0
|
| 60 |
|
60 |
|
| - |
|
61 |
multipliedQty = 0.0
|
| - |
|
62 |
|
| 61 |
if result_data:
|
63 |
if result_data:
|
| 62 |
for record_data in result_data:
|
64 |
for record_data in result_data:
|
| 63 |
print record_data[6]
|
65 |
print record_data[6]
|
| 64 |
if record_data[6] is not None:
|
66 |
if record_data[6] is not None:
|
| 65 |
if availability == int(record_data[3]):
|
67 |
if availability == int(record_data[3]):
|
| 66 |
grnDetail = grnDetail + "\'"+ str(int(record_data[1])) + "\'"+" : { \'TP\' : " + "\'"+ str(float(record_data[4]))+ "\'" + ", \'NLC\' : "+ "\'"+str(float(record_data[5]))+ "\'" +", \'NLCP\' : "+ "\'"+str(float(record_data[6])) + "\'"+", \'VAT_DIFF\' : " + "\'"+str(float(record_data[7])) + "\'" + ", \'QTY\' : "+ "\'"+str(int(record_data[3]))+ "\'" + " }"
|
68 |
grnDetail = grnDetail + "\'"+ str(int(record_data[1])) + "\'"+" : { \'TP\' : " + "\'"+ str(float(record_data[4]))+ "\'" + ", \'NLC\' : "+ "\'"+str(float(record_data[5]))+ "\'" +", \'NLCP\' : "+ "\'"+str(float(record_data[6])) + "\'"+", \'VAT_DIFF\' : " + "\'"+str(float(record_data[7])) + "\'" + ", \'QTY\' : "+ "\'"+str(int(record_data[3]))+ "\'" + " }"
|
| 67 |
weightedNlc = weightedNlc + float(record_data[6]) * float(record_data[3])
|
69 |
weightedNlc = weightedNlc + float(record_data[6]) * float(record_data[3])
|
| - |
|
70 |
multipliedQty = multipliedQty + float(record_data[3])
|
| 68 |
break
|
71 |
break
|
| 69 |
|
72 |
|
| 70 |
if availability > int(record_data[3]):
|
73 |
if availability > int(record_data[3]):
|
| 71 |
availability = availability - int(record_data[3])
|
74 |
availability = availability - int(record_data[3])
|
| 72 |
grnDetail = grnDetail + "\'"+ str(int(record_data[1])) + "\'"+" : { \'TP\' : " + "\'"+ str(float(record_data[4]))+ "\'" + ", \'NLC\' : "+ "\'"+str(float(record_data[5]))+ "\'" +", \'NLCP\' : "+ "\'"+str(float(record_data[6])) + "\'"+", \'VAT_DIFF\' : " + "\'"+str(float(record_data[7])) + "\'" + ", \'QTY\' : "+ "\'"+str(int(record_data[3]))+ "\'" + " }"+", "
|
75 |
grnDetail = grnDetail + "\'"+ str(int(record_data[1])) + "\'"+" : { \'TP\' : " + "\'"+ str(float(record_data[4]))+ "\'" + ", \'NLC\' : "+ "\'"+str(float(record_data[5]))+ "\'" +", \'NLCP\' : "+ "\'"+str(float(record_data[6])) + "\'"+", \'VAT_DIFF\' : " + "\'"+str(float(record_data[7])) + "\'" + ", \'QTY\' : "+ "\'"+str(int(record_data[3]))+ "\'" + " }"+", "
|
| 73 |
weightedNlc = weightedNlc + float(record_data[6]) * float(record_data[3])
|
76 |
weightedNlc = weightedNlc + float(record_data[6]) * float(record_data[3])
|
| - |
|
77 |
multipliedQty = multipliedQty + float(record_data[3])
|
| 74 |
continue
|
78 |
continue
|
| 75 |
|
79 |
|
| 76 |
if availability < int(record_data[3]):
|
80 |
if availability < int(record_data[3]):
|
| 77 |
grnDetail = grnDetail + "\'"+ str(int(record_data[1])) + "\'"+" : { \'TP\' : " + "\'"+ str(float(record_data[4]))+ "\'" + ", \'NLC\' : "+ "\'"+str(float(record_data[5]))+ "\'" +", \'NLCP\' : "+ "\'"+str(float(record_data[6])) + "\'"+", \'VAT_DIFF\' : " + "\'"+str(float(record_data[7])) + "\'" + ", \'QTY\' : "+ "\'"+str(int(availability))+ "\'" + " }"
|
81 |
grnDetail = grnDetail + "\'"+ str(int(record_data[1])) + "\'"+" : { \'TP\' : " + "\'"+ str(float(record_data[4]))+ "\'" + ", \'NLC\' : "+ "\'"+str(float(record_data[5]))+ "\'" +", \'NLCP\' : "+ "\'"+str(float(record_data[6])) + "\'"+", \'VAT_DIFF\' : " + "\'"+str(float(record_data[7])) + "\'" + ", \'QTY\' : "+ "\'"+str(int(availability))+ "\'" + " }"
|
| 78 |
weightedNlc = weightedNlc + float(record_data[6]) * float(availability)
|
82 |
weightedNlc = weightedNlc + float(record_data[6]) * float(availability)
|
| - |
|
83 |
multipliedQty = multipliedQty + float(availability)
|
| 79 |
break
|
84 |
break
|
| 80 |
else:
|
85 |
else:
|
| 81 |
continue
|
86 |
continue
|
| 82 |
|
87 |
|
| 83 |
weightedNlc = weightedNlc/stockQuantity
|
88 |
weightedNlc = weightedNlc/multipliedQty
|
| 84 |
grnDetail = grnDetail + "}"
|
89 |
grnDetail = grnDetail + "}"
|
| 85 |
|
90 |
|
| 86 |
print weightedNlc
|
91 |
print weightedNlc
|
| 87 |
print grnDetail
|
92 |
print grnDetail
|
| 88 |
|
93 |
|