Subversion Repositories SmartDukaan

Rev

Rev 11539 | Rev 12654 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 11539 Rev 12650
Line 29... Line 29...
29 
    workbook = xlrd.open_workbook(filename)
 29 
    workbook = xlrd.open_workbook(filename)
30 
    sheet = workbook.sheet_by_index(0)
 30 
    sheet = workbook.sheet_by_index(0)
31 
    num_rows = sheet.nrows
 31 
    num_rows = sheet.nrows
32 
    updatedOn = to_java_date(datetime.datetime.now())
 32 
    updatedOn = to_java_date(datetime.datetime.now())
33 
    cclient = CatalogClient().get_client()
 33 
    cclient = CatalogClient().get_client()
- 
 
 34 
    tcategories = cclient.getAllCategories()
- 
 
 35 
    parent_category_ids = []
- 
 
 36 
    categoryMap = {}
- 
 
 37 
    for tcategory in tcategories:
- 
 
 38 
        if tcategory.parent_category_id not in parent_category_ids:
- 
 
 39 
            parent_category_ids.append(tcategory.parent_category_id)
- 
 
 40
- 
 
 41 
    for tcategory in tcategories:
- 
 
 42 
        if tcategory.id not in parent_category_ids:
- 
 
 43 
            categoryMap[tcategory.label] = tcategory.id
- 
 
 44 
    prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
34 
    iclient = InventoryClient().get_client()
 45 
    iclient = InventoryClient().get_client()
35
46
36 
    for rownum in range(1, num_rows):
 47 
    for rownum in range(1, num_rows):
37 
        print sheet.row_values(rownum)
 48 
        print sheet.row_values(rownum)
38 
        message = ""
 49 
        message = ""
39 
        try:
 50 
        try:
40 
            product_group, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type = sheet.row_values(rownum)[0:16]
 51 
            product_group, category_name, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type = sheet.row_values(rownum)[0:17]
41
52
42 
            if isinstance(model_number, float):
 53 
            if isinstance(model_number, float):
43 
                model_number = str(int(model_number))
 54 
                model_number = str(int(model_number))
44
55
45
56
Line 48... Line 59...
48 
            item.brand = brand
 59 
            item.brand = brand
49 
            item.modelNumber = model_number
 60 
            item.modelNumber = model_number
50 
            item.modelName = model_name
 61 
            item.modelName = model_name
51 
            item.color = color
 62 
            item.color = color
52 
            item.mrp = round(mrp)
 63 
            item.mrp = round(mrp)
- 
 
 64 
            #if item is risky
- 
 
 65 
            if category_name.strip():
- 
 
 66 
                item.category = categoryMap[category_name.strip()]
- 
 
 67 
                item.itemStatus = 8
53 
            item.sellingPrice = round(sp)
 68 
            item.sellingPrice = round(sp)
54 
            item.startDate = long(to_java_date(datetime.datetime(1899, 12, 30) + timedelta(days=int(start_date))))
 69 
            item.startDate = long(to_java_date(datetime.datetime(1899, 12, 30) + timedelta(days=int(start_date))))
55 
            item.preferredInsurer = preferred_vendor
 70 
            item.preferredInsurer = preferred_vendor
56 
            item.risky = risky
 71 
            item.risky = int(risky)
57 
            item.weight = weight
 72 
            item.weight = weight
58 
            item.updatedOn = updatedOn
 73 
            item.updatedOn = updatedOn
59 
            item.type = int(item_type)
 74 
            item.type = int(item_type)
60 
            for c in (1,2,3,4,5):
 75 
            for c in (1,2,3,4,5):
61 
                try:
 76 
                try:
62 
                    item_id = cclient.addItem(item)
 77 
                    item_id = cclient.addItem(item)
- 
 
 78 
                    item.id = item_id
- 
 
 79 
                    for c1 in (5,5,5,5,5):
- 
 
 80 
                        try:
- 
 
 81 
                            prodClient.addItem(item)
- 
 
 82 
                            break
- 
 
 83 
                        except:
- 
 
 84 
                            prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
63 
                    break
 85 
                    break
64 
                except Exception as e:
 86 
                except Exception as e:
65 
                    cclient = CatalogClient().get_client()
87 
                    cclient = CatalogClient().get_client()
66
88
67 
            vip = VendorItemPricing()
 89 
            vip = VendorItemPricing()