| Line 55... |
Line 55... |
| 55 |
result_data = cursor.fetchall()
|
55 |
result_data = cursor.fetchall()
|
| 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 |
|
- |
|
| 61 |
multipliedQty = 0.0
|
60 |
multipliedQty = 0.0
|
| 62 |
|
61 |
|
| 63 |
if result_data:
|
62 |
if result_data:
|
| - |
|
63 |
|
| 64 |
for record_data in result_data:
|
64 |
for record_data in result_data:
|
| 65 |
print record_data[6]
|
65 |
print record_data[6]
|
| 66 |
if record_data[6] is not None:
|
66 |
if record_data[6] is not None:
|
| 67 |
if availability == int(record_data[3]):
|
67 |
if availability == 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]))+ "\'" + " }"
|
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]))+ "\'" + " }"
|
| Line 82... |
Line 82... |
| 82 |
weightedNlc = weightedNlc + float(record_data[6]) * float(availability)
|
82 |
weightedNlc = weightedNlc + float(record_data[6]) * float(availability)
|
| 83 |
multipliedQty = multipliedQty + float(availability)
|
83 |
multipliedQty = multipliedQty + float(availability)
|
| 84 |
break
|
84 |
break
|
| 85 |
else:
|
85 |
else:
|
| 86 |
continue
|
86 |
continue
|
| 87 |
|
87 |
|
| - |
|
88 |
if multipliedQty == 0.0:
|
| - |
|
89 |
multipliedQty = multipliedQty + 1.0
|
| 88 |
weightedNlc = weightedNlc/multipliedQty
|
90 |
weightedNlc = weightedNlc/multipliedQty
|
| 89 |
grnDetail = grnDetail + "}"
|
91 |
grnDetail = grnDetail + "}"
|
| 90 |
|
92 |
|
| 91 |
print weightedNlc
|
93 |
print weightedNlc
|
| 92 |
print grnDetail
|
94 |
print grnDetail
|