| Line 1749... |
Line 1749... |
| 1749 |
if len(successfulAutoDecrease)==0 and len(successfulAutoIncrease)==0 :
|
1749 |
if len(successfulAutoDecrease)==0 and len(successfulAutoIncrease)==0 :
|
| 1750 |
print "returning"
|
1750 |
print "returning"
|
| 1751 |
return
|
1751 |
return
|
| 1752 |
xstr = lambda s: s or ""
|
1752 |
xstr = lambda s: s or ""
|
| 1753 |
message="""<html>
|
1753 |
message="""<html>
|
| 1754 |
<h3 style="color:red;">Test Run.Please validate with costing sheet before taking any decision></h3>
|
1754 |
<h3 style="color:red;">Test Run.Please validate with costing sheet before taking any decision</h3>
|
| 1755 |
<body>
|
1755 |
<body>
|
| 1756 |
<h3>Auto Decrease Items</h3>
|
1756 |
<h3>Auto Decrease Items</h3>
|
| 1757 |
<table border="1" style="width:100%;">
|
1757 |
<table border="1" style="width:100%;">
|
| 1758 |
<thead>
|
1758 |
<thead>
|
| 1759 |
<tr><th>Item Id</th>
|
1759 |
<tr><th>Item Id</th>
|
| Line 1791... |
Line 1791... |
| 1791 |
<td style="text-align:center">"""+str(item.item_id)+"""</td>
|
1791 |
<td style="text-align:center">"""+str(item.item_id)+"""</td>
|
| 1792 |
<td style="text-align:center">"""+sku+"""</td>
|
1792 |
<td style="text-align:center">"""+sku+"""</td>
|
| 1793 |
<td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
|
1793 |
<td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
|
| 1794 |
<td style="text-align:center">"""+str(item.ourSellingPrice)+"""</td>
|
1794 |
<td style="text-align:center">"""+str(item.ourSellingPrice)+"""</td>
|
| 1795 |
<td style="text-align:center">"""+str(math.ceil(item.proposedSp))+"""</td>
|
1795 |
<td style="text-align:center">"""+str(math.ceil(item.proposedSp))+"""</td>
|
| 1796 |
<td style="text-align:center">"""+str(math.ceil(item.proposedSp))+"""</td>
|
- |
|
| 1797 |
<td style="text-align:center">"""+str(round(subsidy))+"""</td>
|
1796 |
<td style="text-align:center">"""+str(round(subsidy))+"""</td>
|
| 1798 |
<td style="text-align:center">"""+str(round(oldMargin))+" ("+str(round((oldMargin/item.ourSellingPrice)*100,1))+"%)"+"""</td>
|
1797 |
<td style="text-align:center">"""+str(round(oldMargin))+" ("+str(round((oldMargin/item.ourSellingPrice)*100,1))+"%)"+"""</td>
|
| 1799 |
<td style="text-align:center">"""+str(newMargin)+" ("+str(round((newMargin/item.proposedSp)*100,1))+"%)"+"""</td>
|
1798 |
<td style="text-align:center">"""+str(newMargin)+" ("+str(round((newMargin/item.proposedSp)*100,1))+"%)"+"""</td>
|
| 1800 |
<td style="text-align:center">"""+str(item.commission)+" %"+"""</td>
|
1799 |
<td style="text-align:center">"""+str(item.commission)+" %"+"""</td>
|
| 1801 |
<td style="text-align:center">"""+str(item.returnProvision)+" %"+"""</td>
|
1800 |
<td style="text-align:center">"""+str(item.returnProvision)+" %"+"""</td>
|