| Line 31... |
Line 31... |
| 31 |
raise Exception("No vendor found for the id: " + str(vendorId))
|
31 |
raise Exception("No vendor found for the id: " + str(vendorId))
|
| 32 |
|
32 |
|
| 33 |
workbook = xlrd.open_workbook(filename)
|
33 |
workbook = xlrd.open_workbook(filename)
|
| 34 |
sheet = workbook.sheet_by_index(0)
|
34 |
sheet = workbook.sheet_by_index(0)
|
| 35 |
num_rows = sheet.nrows
|
35 |
num_rows = sheet.nrows
|
| - |
|
36 |
keys = []
|
| 36 |
new_items = []
|
37 |
new_items = []
|
| 37 |
phased_out_items = []
|
38 |
phased_out_items = []
|
| 38 |
updated_items = []
|
39 |
updated_items = []
|
| 39 |
unchanged_items = []
|
40 |
unchanged_items = []
|
| 40 |
|
41 |
|
| Line 47... |
Line 48... |
| 47 |
if isinstance(model_number, float):
|
48 |
if isinstance(model_number, float):
|
| 48 |
model_number = str(int(model_number))
|
49 |
model_number = str(int(model_number))
|
| 49 |
|
50 |
|
| 50 |
item = None
|
51 |
item = None
|
| 51 |
vendor_item_pricing = None
|
52 |
vendor_item_pricing = None
|
| - |
|
53 |
if product_group.strip().lower() == 'New Handset'.strip().lower():
|
| - |
|
54 |
for our_group in ["handsets", "mobile handset", "smart phone"]:
|
| - |
|
55 |
new_key = our_group.strip().lower() + '|' + brand.strip().lower() + '|' + model_number.strip().lower() + '|' + color.strip().lower()
|
| - |
|
56 |
keys.append(new_key)
|
| - |
|
57 |
else:
|
| - |
|
58 |
new_key = product_group.strip().lower() + '|' + brand.strip().lower() + '|' + model_number.strip().lower() + '|' + color.strip().lower()
|
| - |
|
59 |
keys.append(new_key)
|
| 52 |
|
60 |
|
| - |
|
61 |
i = 0
|
| - |
|
62 |
for key in keys:
|
| 53 |
key = product_group.strip().lower() + '|' + brand.strip().lower() + '|' + model_number.strip().lower() + '|' + color.strip().lower()
|
63 |
i = i + 1
|
| 54 |
vendor_item_mapping = VendorItemMapping.get_by(vendor=vendor, item_key=key)
|
64 |
vendor_item_mapping = VendorItemMapping.get_by(vendor=vendor, item_key=key)
|
| 55 |
if vendor_item_mapping:
|
65 |
if vendor_item_mapping:
|
| 56 |
item = vendor_item_mapping.item
|
66 |
item = vendor_item_mapping.item
|
| 57 |
if item is not None and item.status != status.PHASED_OUT:
|
67 |
if item is not None and item.status != status.PHASED_OUT:
|
| 58 |
vendor_item_pricing = VendorItemPricing.get_by(vendor=vendor, item=item)
|
68 |
vendor_item_pricing = VendorItemPricing.get_by(vendor=vendor, item=item)
|
| 59 |
if vendor_item_pricing is None:
|
69 |
if vendor_item_pricing is None:
|
| 60 |
updated_items.append(sheet.row_values(rownum)[0:9] + [None, item.mrp, None, None, item.sellingPrice])
|
70 |
updated_items.append(sheet.row_values(rownum)[0:9] + [None, item.mrp, None, None, item.sellingPrice])
|
| 61 |
elif item.mrp != mrp or vendor_item_pricing.dealerPrice != dp or vendor_item_pricing.transfer_price != xfer_price or vendor_item_pricing.mop != mop:
|
71 |
elif item.mrp != mrp or vendor_item_pricing.dealerPrice != dp or vendor_item_pricing.transfer_price != xfer_price or vendor_item_pricing.mop != mop:
|
| 62 |
updated_items.append(sheet.row_values(rownum)[0:9] + [vendor_item_pricing.dealerPrice, item.mrp, vendor_item_pricing.mop, vendor_item_pricing.transfer_price, item.sellingPrice])
|
72 |
updated_items.append(sheet.row_values(rownum)[0:9] + [vendor_item_pricing.dealerPrice, item.mrp, vendor_item_pricing.mop, vendor_item_pricing.transfer_price, item.sellingPrice])
|
| - |
|
73 |
else:
|
| - |
|
74 |
unchanged_items.append(rownum)
|
| 63 |
else:
|
75 |
else:
|
| 64 |
unchanged_items.append(rownum)
|
76 |
phased_out_items.append(rownum)
|
| 65 |
else:
|
77 |
break
|
| 66 |
phased_out_items.append(rownum)
|
78 |
elif i == len(keys):
|
| 67 |
else:
|
- |
|
| 68 |
new_items.append(rownum)
|
79 |
new_items.append(rownum)
|
| 69 |
|
80 |
|
| 70 |
write_report("/tmp/new_items.csv", new_items, sheet, False)
|
81 |
write_report("/tmp/new_items.csv", new_items, sheet, False)
|
| 71 |
write_report("/tmp/phased_out_items.csv", phased_out_items, sheet, False)
|
82 |
write_report("/tmp/phased_out_items.csv", phased_out_items, sheet, False)
|
| 72 |
write_report("/tmp/updated_items.csv", updated_items, sheet, True)
|
83 |
write_report("/tmp/updated_items.csv", updated_items, sheet, True)
|
| 73 |
write_report("/tmp/unchanged_items.csv", unchanged_items, sheet, False)
|
84 |
write_report("/tmp/unchanged_items.csv", unchanged_items, sheet, False)
|