| Line 21... |
Line 21... |
| 21 |
sheet = workbook.sheet_by_index(0)
|
21 |
sheet = workbook.sheet_by_index(0)
|
| 22 |
num_rows = sheet.nrows
|
22 |
num_rows = sheet.nrows
|
| 23 |
updatedOn = datetime.datetime.now()
|
23 |
updatedOn = datetime.datetime.now()
|
| 24 |
for rownum in range(1, num_rows):
|
24 |
for rownum in range(1, num_rows):
|
| 25 |
print sheet.row_values(rownum)
|
25 |
print sheet.row_values(rownum)
|
| 26 |
hotspot_category, brand, model_number, color, model_name, mrp, mop, dp, xfer_price, weight, start_date, deal_text, deal_value, comments, catalog_item_id, category_id = sheet.row_values(rownum)[0:17]
|
26 |
#hotspot_category, brand, model_number, color, model_name, mrp, mop, dp, xfer_price, weight, start_date, deal_text, deal_value, comments, catalog_item_id, category_id = sheet.row_values(rownum)[0:17]
|
| - |
|
27 |
brand, model_number, model_name, color, dp, mrp, unused_fbp, comments, hotspot_category, unused_feature, xfer_price, weight, start_date, deal_text, deal_value, catalog_item_id, category_id = sheet.row_values(rownum)[0:17]
|
| 27 |
if isinstance(model_number, float):
|
28 |
if isinstance(model_number, float):
|
| 28 |
model_number = str(int(model_number))
|
29 |
model_number = str(int(model_number))
|
| 29 |
item = Item.get_by(manufacturer_name=brand, model_number=model_number, color=color)
|
30 |
item = Item.get_by(manufacturer_name=brand, model_number=model_number, color=color)
|
| 30 |
if item is None:
|
31 |
if item is None:
|
| 31 |
print "[ADDING:]{0} {1} {2} to our catalogue.".format(brand, model_number, color)
|
32 |
print "[ADDING:]{0} {1} {2} to our catalogue.".format(brand, model_number, color)
|
| Line 34... |
Line 35... |
| 34 |
item.model_number = model_number
|
35 |
item.model_number = model_number
|
| 35 |
item.color = color
|
36 |
item.color = color
|
| 36 |
item.status = status.IN_PROCESS
|
37 |
item.status = status.IN_PROCESS
|
| 37 |
item.addedOn = updatedOn
|
38 |
item.addedOn = updatedOn
|
| 38 |
session.add(item)
|
39 |
session.add(item)
|
| 39 |
'''
|
40 |
'''
|
| 40 |
#Set the catalog_item_id.
|
41 |
#Set the catalog_item_id.
|
| 41 |
similar_item = Item.query.filter_by(manufacturer_name = brand, model_number=model_number).first()
|
42 |
similar_item = Item.query.filter_by(manufacturer_name = brand, model_number=model_number).first()
|
| 42 |
print similar_item
|
43 |
print similar_item
|
| 43 |
if similar_item is None or similar_item.catalog_item_id is None:
|
44 |
if similar_item is None or similar_item.catalog_item_id is None:
|
| 44 |
#Use the entity_id_generator
|
45 |
#Use the entity_id_generator
|
| Line 47... |
Line 48... |
| 47 |
entity_id.id = entity_id.id + 1
|
48 |
entity_id.id = entity_id.id + 1
|
| 48 |
else:
|
49 |
else:
|
| 49 |
#If it already exists for a brand and model_number, set it as same.
|
50 |
#If it already exists for a brand and model_number, set it as same.
|
| 50 |
item.catalog_item_id = similar_item.catalog_item_id
|
51 |
item.catalog_item_id = similar_item.catalog_item_id
|
| 51 |
'''
|
52 |
'''
|
| 52 |
#added category and entity id
|
- |
|
| 53 |
|
53 |
|
| - |
|
54 |
#Add category and entity id
|
| 54 |
item.catalog_item_id = int(catalog_item_id)
|
55 |
item.catalog_item_id = int(catalog_item_id)
|
| 55 |
item.category = int(category_id)
|
56 |
item.category = int(category_id)
|
| 56 |
item.status = status.ACTIVE
|
57 |
item.status = status.ACTIVE
|
| - |
|
58 |
|
| 57 |
item.hotspotCategory = hotspot_category
|
59 |
item.hotspotCategory = hotspot_category
|
| 58 |
|
60 |
|
| 59 |
item.model_name = model_name
|
61 |
item.model_name = model_name
|
| 60 |
if mrp != "":
|
62 |
if mrp != "":
|
| 61 |
item.mrp = mrp
|
63 |
item.mrp = mrp
|
| 62 |
else:
|
64 |
#else:
|
| 63 |
item.mrp = dp + dp/5
|
65 |
# item.mrp = dp + dp/5
|
| - |
|
66 |
'''
|
| 64 |
if mop != "":
|
67 |
if mop != "":
|
| 65 |
item.mop = mop
|
68 |
item.mop = mop
|
| - |
|
69 |
'''
|
| 66 |
if dp != "":
|
70 |
if dp != "":
|
| 67 |
item.dealerPrice = dp
|
71 |
item.dealerPrice = dp
|
| 68 |
item.sellingPrice = dp
|
72 |
item.sellingPrice = dp
|
| 69 |
else:
|
73 |
#else:
|
| 70 |
item.dealerPrice = mrp - mrp/5
|
74 |
# item.dealerPrice = mrp - mrp/5
|
| 71 |
item.sellingPrice= mrp - mrp/5
|
75 |
# item.sellingPrice= mrp - mrp/5
|
| 72 |
if xfer_price !="":
|
76 |
if xfer_price !="":
|
| 73 |
item.transfer_price = xfer_price
|
77 |
item.transfer_price = xfer_price
|
| 74 |
if weight != "":
|
78 |
if weight != "":
|
| 75 |
item.weight = weight
|
79 |
item.weight = weight
|
| 76 |
if start_date != "":
|
80 |
if start_date != "":
|