Subversion Repositories SmartDukaan

Rev

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

Rev 9334 Rev 9337
Line 59... Line 59...
59 
    response = urllib2.urlopen(req)
 59 
    response = urllib2.urlopen(req)
60 
    print response
 60 
    print response
61 
    json_input = response.read()
 61 
    json_input = response.read()
62 
    vendorInfo = json.loads(json_input)
 62 
    vendorInfo = json.loads(json_input)
63 
    rank ,otherInventory ,ourInventory, offerPrice, ourSp,iterator = 0, 0, 0, 0, 0, 0
 63 
    rank ,otherInventory ,ourInventory, offerPrice, ourSp,iterator = 0, 0, 0, 0, 0, 0
- 
 
 64 
    secondLowestSellerName=''
- 
 
 65 
    secondLowestSellerSp=0
- 
 
 66 
    secondLowestSellerInventory=0
64 
    for vendor in vendorInfo:
 67 
    for vendor in vendorInfo:
65 
        if iterator == 0:
 68 
        if iterator == 0:
66 
            lowestSellerName = vendor['vendorDisplayName']
 69 
            lowestSellerName = vendor['vendorDisplayName']
67 
            lowestSp = vendor['sellingPrice']
 70 
            lowestSp = vendor['sellingPrice']
68
71
Line 86... Line 89...
86 
 
 89 
 
87 
def read_data(filename):
 90 
def read_data(filename):
88 
    all_lines = []
 91 
    all_lines = []
89 
    all_supc=[]
 92 
    all_supc=[]
90 
    iclient = InventoryClient().get_client()
 93 
    iclient = InventoryClient().get_client()
91 
    DataService.initialize('catalog','192.168')
 94 
    DataService.initialize('catalog','192.168.166.135')
92 
    workbook = xlrd.open_workbook(filename)
 95 
    workbook = xlrd.open_workbook(filename)
93 
    sheet = workbook.sheet_by_index(0)
 96 
    sheet = workbook.sheet_by_index(0)
94 
    num_rows = sheet.nrows
 97 
    num_rows = sheet.nrows
95 
    for rownum in range(1, num_rows):
 98 
    for rownum in range(1, num_rows):
96 
        print sheet.row_values(rownum)
 99 
        print sheet.row_values(rownum)
Line 143... Line 146...
143 
    sheet.write(0, 19, "Lowest Possible TP", heading_xf)
 146 
    sheet.write(0, 19, "Lowest Possible TP", heading_xf)
144 
    sheet.write(0, 20, "Can Compete", heading_xf)
 147 
    sheet.write(0, 20, "Can Compete", heading_xf)
145 
    sheet.write(0, 21, "Proposed TP", heading_xf)
 148 
    sheet.write(0, 21, "Proposed TP", heading_xf)
146 
    sheet.write(0, 22, "Proposed SP", heading_xf)
149 
    sheet.write(0, 22, "Proposed SP", heading_xf)
147
150
148 
    i = 1
 151 
    i, sheet_iterator=1,1
149 
    for one_line in all_lines:
 152 
    for one_line in all_lines:
150 
        supc = all_supc[i-1]
 153 
        supc = all_supc[i-1]
151 
        supc_data = fetchDetails(supc)
 154 
        supc_data = fetchDetails(supc)
152
155
153 
        courierCost = 45
 156 
        courierCost = 45
Line 165... Line 168...
165 
            temp.append(one_line)
 168 
            temp.append(one_line)
166 
            buyBoxItems.append(temp)
 169 
            buyBoxItems.append(temp)
167 
            i+=1
 170 
            i+=1
168 
            continue
 171 
            continue
169
172
170 
        sheet.write(i, 0, one_line.item_id)
 173 
        sheet.write(sheet_iterator, 0, one_line.item_id)
171 
        sheet.write(i, 1, one_line.category_name)
 174 
        sheet.write(sheet_iterator, 1, one_line.category_name)
172 
        sheet.write(i, 2, one_line.product_group)
 175 
        sheet.write(sheet_iterator, 2, one_line.product_group)
173 
        sheet.write(i, 3, supc)
 176 
        sheet.write(sheet_iterator, 3, supc)
174 
        sheet.write(i, 4, one_line.brand)
 177 
        sheet.write(sheet_iterator, 4, one_line.brand)
175 
        sheet.write(i, 5, one_line.model_name)
 178 
        sheet.write(sheet_iterator, 5, one_line.model_name)
176 
        sheet.write(i, 6, one_line.model_number)
 179 
        sheet.write(sheet_iterator, 6, one_line.model_number)
177 
        sheet.write(i, 7, one_line.color)
 180 
        sheet.write(sheet_iterator, 7, one_line.color)
178 
        sheet.write(i, 8, supc_data.ourSp)
 181 
        sheet.write(sheet_iterator, 8, supc_data.ourSp)
179 
        sheet.write(i, 9, round(supc_data.ourSp*0.9597-courierCost))
 182 
        sheet.write(sheet_iterator, 9, round(supc_data.ourSp*0.9597-courierCost))
180 
        sheet.write(i, 10, supc_data.offerPrice)
 183 
        sheet.write(sheet_iterator, 10, supc_data.offerPrice)
181 
        sheet.write(i, 11, supc_data.rank)
 184 
        sheet.write(sheet_iterator, 11, supc_data.rank)
182 
        sheet.write(i, 12, supc_data.lowestSellerName)
 185 
        sheet.write(sheet_iterator, 12, supc_data.lowestSellerName)
183 
        sheet.write(i, 13, supc_data.lowestSp)
 186 
        sheet.write(sheet_iterator, 13, supc_data.lowestSp)
184 
        if one_line.parent_category ==10011:
 187 
        if one_line.parent_category ==10011:
185 
            lowestTp = (supc_data.lowestSp*(1-.0803))-courierCost
 188 
            lowestTp = (supc_data.lowestSp*(1-.0803))-courierCost
186 
        else:
 189 
        else:
187 
            lowestTp = supc_data.lowestSp*0.9497-courierCost
 190 
            lowestTp = supc_data.lowestSp*0.9497-courierCost
188 
        sheet.write(i, 14, round(lowestTp))
 191 
        sheet.write(sheet_iterator, 14, round(lowestTp))
189 
        sheet.write(i, 15, )
 192 
        sheet.write(sheet_iterator, 15, )
190 
        sheet.write(i, 16, supc_data.otherInventory)
 193 
        sheet.write(sheet_iterator, 16, supc_data.otherInventory)
191 
        sheet.write(i, 17, supc_data.ourInventory)
 194 
        sheet.write(sheet_iterator, 17, supc_data.ourInventory)
192 
        sheet.write(i, 18, one_line.our_nlc)
 195 
        sheet.write(sheet_iterator, 18, one_line.our_nlc)
193 
        if supc_data.rank==1:
 196 
        if supc_data.rank==1:
194 
            i+=1
 197 
            i+=1
- 
 
 198 
            sheet_iterator+=1
195 
            continue
 199 
            continue
196 
        lowest_possible_tp = one_line.our_nlc/0.988+15+6
 200 
        lowest_possible_tp = one_line.our_nlc/0.988+15+6
197 
        sheet.write(i, 19, round(lowest_possible_tp))
 201 
        sheet.write(sheet_iterator, 19, round(lowest_possible_tp))
198 
        proposed_tp = 0
 202 
        proposed_tp = 0
199 
        if lowestTp > lowest_possible_tp:
 203 
        if lowestTp > lowest_possible_tp:
200 
            sheet.write(i, 20, "Yes")
 204 
            sheet.write(sheet_iterator, 20, "Yes")
201 
            proposed_tp  = max(lowestTp - max((10, lowestTp*0.001), lowest_possible_tp))
 205 
            proposed_tp  = max(lowestTp - max((10, lowestTp*0.001)), lowest_possible_tp)
202 
            sheet.write(i, 21, round(proposed_tp))
 206 
            sheet.write(sheet_iterator, 21, round(proposed_tp))
203 
            sheet.write(i, 22, round((proposed_tp+courierCost)/0.9597))
207 
            sheet.write(sheet_iterator, 22, round((proposed_tp+courierCost)/0.9597))
204 
        else:
 208 
        else:
205 
            sheet.write(i, 20, "No")
 209 
            sheet.write(sheet_iterator, 20, "No")
206 
        i= i+1
 210 
        i= i+1
- 
 
 211 
        sheet_iterator+=1
207
212
208 
    createSheetForBuyBoxItems(buyBoxItems,wbk)
 213 
    createSheetForBuyBoxItems(buyBoxItems,wbk)
209 
    wbk.save(filename)
 214 
    wbk.save(filename)
210 
 
 215 
 
211 
def createSheetForBuyBoxItems(buyBoxItems,wbk):
 216 
def createSheetForBuyBoxItems(buyBoxItems,wbk):
212 
    sheet = wbk.add_sheet('BuyBoxItems')
 217 
    sheet = wbk.add_sheet('BuyBoxItems')