| Line 811... |
Line 811... |
| 811 |
sh1.write(row3, inc(), result[9])
|
811 |
sh1.write(row3, inc(), result[9])
|
| 812 |
inc()
|
812 |
inc()
|
| 813 |
if int(subOrder.get("quantity")) > 0:
|
813 |
if int(subOrder.get("quantity")) > 0:
|
| 814 |
sh1.write(row3, i, int(subOrder.get("amountPaid"))/int(subOrder.get("quantity")))
|
814 |
sh1.write(row3, i, int(subOrder.get("amountPaid"))/int(subOrder.get("quantity")))
|
| 815 |
skuData = getSkuData(morder.get("storeId"), subOrder.get("productCode"))
|
815 |
skuData = getSkuData(morder.get("storeId"), subOrder.get("productCode"))
|
| 816 |
if morder.get("storeId") in (1,2,4,5):
|
816 |
if morder.get("storeId") in (1,2,4,5,6):
|
| 817 |
skuData = db1.MasterData.find_one({'identifier':subOrder.get("productCode").strip(), 'source_id':morder.get("storeId")})
|
817 |
skuData = db1.MasterData.find_one({'identifier':subOrder.get("productCode").strip(), 'source_id':morder.get("storeId")})
|
| 818 |
elif morder.get("storeId") == 3:
|
818 |
elif morder.get("storeId") == 3:
|
| 819 |
skuData = db1.MasterData.find_one({'secondaryIdentifier':subOrder.get("productCode").strip(), 'source_id':morder.get("storeId")})
|
819 |
skuData = db1.MasterData.find_one({'secondaryIdentifier':subOrder.get("productCode").strip(), 'source_id':morder.get("storeId")})
|
| 820 |
if skuData is not None:
|
820 |
if skuData is not None:
|
| 821 |
sh1.write(row3, inc(), skuData.get("skuBundleId"))
|
821 |
sh1.write(row3, inc(), skuData.get("skuBundleId"))
|
| Line 908... |
Line 908... |
| 908 |
|
908 |
|
| 909 |
wb.save(XLS_FILENAME)
|
909 |
wb.save(XLS_FILENAME)
|
| 910 |
workbook.save(XLS_O_FILENAME)
|
910 |
workbook.save(XLS_O_FILENAME)
|
| 911 |
|
911 |
|
| 912 |
def getSkuData(storeId, identifier):
|
912 |
def getSkuData(storeId, identifier):
|
| 913 |
if storeId in (1,2,4,5):
|
913 |
if storeId in (1,2,4,5,6):
|
| 914 |
skuData = client.Catalog.MasterData.find_one({'identifier':identifier, 'source_id':storeId})
|
914 |
skuData = client.Catalog.MasterData.find_one({'identifier':identifier, 'source_id':storeId})
|
| 915 |
elif storeId == 3:
|
915 |
elif storeId == 3:
|
| 916 |
skuData = client.Catalog.MasterData.find_one({'secondaryIdentifier':identifier, 'source_id':storeId})
|
916 |
skuData = client.Catalog.MasterData.find_one({'secondaryIdentifier':identifier, 'source_id':storeId})
|
| 917 |
return skuData
|
917 |
return skuData
|
| 918 |
|
918 |
|