Subversion Repositories SmartDukaan

Rev

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

Rev 13045 Rev 15728
Line 32... Line 32...
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()
 34 
    tcategories = cclient.getAllCategories()
35 
    parent_category_ids = []
35 
    parent_category_ids = []
36 
    categoryMap = {}
 36 
    categoryMap = {}
- 
 
 37 
    #0-Delhi 1-Maha 2-Blr 3-Ggn 4-Rajasthan 5-Telangana 6-Gujarat
- 
 
 38
37 
    for tcategory in tcategories:
 39 
    for tcategory in tcategories:
38 
        if tcategory.parent_category_id not in parent_category_ids:
 40 
        if tcategory.parent_category_id not in parent_category_ids:
39 
            parent_category_ids.append(tcategory.parent_category_id)
 41 
            parent_category_ids.append(tcategory.parent_category_id)
40
42
41 
    for tcategory in tcategories:
 43 
    for tcategory in tcategories:
Line 45... Line 47...
45 
    iclient = InventoryClient().get_client()
 47 
    iclient = InventoryClient().get_client()
46
48
47 
    for rownum in range(1, num_rows):
 49 
    for rownum in range(1, num_rows):
48 
        #print sheet.row_values(rownum)
 50 
        #print sheet.row_values(rownum)
49 
        message = ""
 51 
        message = ""
- 
 
 52 
        states = {}
50 
        try:
 53 
        try:
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]
 54 
            product_group, category_name, brand, model_number, model_name, color, mrp, sp, mop, dp, tp, nlc, start_date, preferred_vendor, risky, weight, item_type, states[0], states[3], states[1], states[2]  = sheet.row_values(rownum)[0:21]
52 
            if isinstance(model_number, float):
 55 
            if isinstance(model_number, float):
53 
                model_number = str(int(model_number))
 56 
                model_number = str(int(model_number))
54
57
55
58
56 
            item = Item()
 59 
            item = Item()
Line 72... Line 75...
72 
            item.preferredVendor = preferred_vendor
 75 
            item.preferredVendor = preferred_vendor
73 
            item.risky = int(risky)
 76 
            item.risky = int(risky)
74 
            item.weight = weight
 77 
            item.weight = weight
75 
            item.updatedOn = updatedOn
 78 
            item.updatedOn = updatedOn
76 
            item.type = int(item_type)
 79 
            item.type = int(item_type)
- 
 
 80 
            for key,val in states.iteritems():
- 
 
 81 
                states[key] = val*100
77 
            for c in (1,2,3,4,5):
 82 
            for c in (1,2,3,4,5):
78 
                try:
 83 
                try:
79 
                    item_id = cclient.addItem(item)
 84 
                    item_id = cclient.addItem(item)
80 
                    print "for row {1} item added\t{0}".format(item_id, rownum)
 85 
                    print "for row {1} item added\t{0}".format(item_id, rownum)
81 
                    item.id = item_id
 86 
                    item.id = item_id
- 
 
 87 
                    if len(states)>0:
- 
 
 88 
                        for c2 in (1,2,3,4,5):
- 
 
 89 
                            try:
- 
 
 90 
                                cclient.updateItemStateVat(item_id, states)
- 
 
 91 
                                break
- 
 
 92 
                            except Exception as e:
- 
 
 93 
                                cclient = CatalogClient().get_client()
82 
                    for c1 in (5,5,5,5,5):
 94 
                    for c1 in (5,5,5,5,5):
83 
                        try:
 95 
                        try:
84 
                            prodClient.addItem(item)
 96 
                            prodClient.addItem(item)
- 
 
 97 
                            if len(states) > 0:
- 
 
 98 
                                for c3 in (1,2,3,4,5):
- 
 
 99 
                                    try:
- 
 
 100 
                                        prodClient.updateItemStateVat(item_id, states)
- 
 
 101 
                                        break
- 
 
 102 
                                    except Exception as e:
- 
 
 103 
                                        prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
85 
                            break
 104 
                            break
86 
                        except:
 105 
                        except:
87 
                            prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
 106 
                            prodClient = CatalogClient("catalog_service_server_host_prod").get_client()
88 
                    break
 107 
                    break
89 
                except Exception as e:
 108 
                except Exception as e: