| Line 2264... |
Line 2264... |
| 2264 |
<table border="1" style="width:100%;">
|
2264 |
<table border="1" style="width:100%;">
|
| 2265 |
<thead>
|
2265 |
<thead>
|
| 2266 |
<tr><th>Item Id</th>
|
2266 |
<tr><th>Item Id</th>
|
| 2267 |
<th>Product Name</th>
|
2267 |
<th>Product Name</th>
|
| 2268 |
<th>Current Price</th>
|
2268 |
<th>Current Price</th>
|
| - |
|
2269 |
<th>Our Rating</th>
|
| - |
|
2270 |
<th>Our Shipping Time</th>
|
| 2269 |
<th>Preffered Seller</th>
|
2271 |
<th>Preffered Seller</th>
|
| 2270 |
<th>Preffered Seller SP</th>
|
2272 |
<th>Preffered Seller SP</th>
|
| - |
|
2273 |
<th>Preffered Seller Rating</th>
|
| - |
|
2274 |
<th>Preffered Seller Shipping Time</th>
|
| - |
|
2275 |
<th>Price Variance %</th>
|
| 2271 |
<th>Flipkart Inventory</th>
|
2276 |
<th>Flipkart Inventory</th>
|
| 2272 |
<th>Total Inventory</th>
|
2277 |
<th>Total Inventory</th>
|
| 2273 |
<th>Sales History</th>
|
2278 |
<th>Sales History</th>
|
| 2274 |
</tr></thead>
|
2279 |
</tr></thead>
|
| 2275 |
<tbody>"""
|
2280 |
<tbody>"""
|
| Line 2279... |
Line 2284... |
| 2279 |
netInventory=''
|
2284 |
netInventory=''
|
| 2280 |
if not inventoryMap.has_key(mpHistory.item_id):
|
2285 |
if not inventoryMap.has_key(mpHistory.item_id):
|
| 2281 |
netInventory='Info Not Available'
|
2286 |
netInventory='Info Not Available'
|
| 2282 |
else:
|
2287 |
else:
|
| 2283 |
netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
|
2288 |
netInventory = str(getNetAvailability(inventoryMap.get(mpHistory.item_id)))
|
| - |
|
2289 |
ourSt = mpHistory.ourShippingTime.split('-')
|
| 2284 |
if mpHistory.prefferedSellerSellingPrice=='WS Retail':
|
2290 |
pfSt = mpHistory.prefferedSellerShippingTime.split('-')
|
| - |
|
2291 |
if mpHistory.prefferedSellerName=='WS Retail' and mpHistory.ourRating > mpHistory.prefferedSellerRating and int(ourSt[0])<=int(pfSt[0]):
|
| 2285 |
style="""background-color:red;\""""
|
2292 |
style="""background-color:red;\""""
|
| 2286 |
else:
|
2293 |
else:
|
| 2287 |
style="\""
|
2294 |
style="\""
|
| 2288 |
message+="""<tr>
|
2295 |
message+="""<tr>
|
| 2289 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.item_id)+"""</td>
|
2296 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.item_id)+"""</td>
|
| 2290 |
<td style="text-align:center;"""+str(style)+""">"""+xstr(catItem.brand)+" "+xstr(catItem.model_name)+" "+xstr(catItem.model_number)+" "+xstr(catItem.color)+"""</td>
|
2297 |
<td style="text-align:center;"""+str(style)+""">"""+xstr(catItem.brand)+" "+xstr(catItem.model_name)+" "+xstr(catItem.model_number)+" "+xstr(catItem.color)+"""</td>
|
| 2291 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourSellingPrice)+"""</td>
|
2298 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourSellingPrice)+"""</td>
|
| - |
|
2299 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourRating)+"""</td>
|
| - |
|
2300 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourShippingTime)+"""</td>
|
| 2292 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerName)+"""</td>
|
2301 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerName)+"""</td>
|
| 2293 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerSellingPrice)+"""</td>
|
2302 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerSellingPrice)+"""</td>
|
| - |
|
2303 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerRating)+"""</td>
|
| - |
|
2304 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.prefferedSellerShippingTime)+"""</td>
|
| - |
|
2305 |
<td style="text-align:center;"""+str(style)+""">"""+str(round(((mpHistory.prefferedSellerSellingPrice-mpHistory.ourSellingPrice)/mpHistory.ourSellingPrice)*100))+"%"+"""</td>
|
| 2294 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourInventory)+"""</td>
|
2306 |
<td style="text-align:center;"""+str(style)+""">"""+str(mpHistory.ourInventory)+"""</td>
|
| 2295 |
<td style="text-align:center;"""+str(style)+""">"""+netInventory+"""</td>
|
2307 |
<td style="text-align:center;"""+str(style)+""">"""+netInventory+"""</td>
|
| 2296 |
<td style="text-align:center;"""+str(style)+""">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
|
2308 |
<td style="text-align:center;"""+str(style)+""">"""+getOosString((itemSaleMap.get(mpHistory.item_id))[1])+"""</td>
|
| 2297 |
</tr>"""
|
2309 |
</tr>"""
|
| 2298 |
message+="""</tbody></table></body></html>"""
|
2310 |
message+="""</tbody></table></body></html>"""
|