| Line 132... |
Line 132... |
| 132 |
rowhead.createCell((short) 8).setCellValue("Lowest Seller Snapdeal Inventory");
|
132 |
rowhead.createCell((short) 8).setCellValue("Lowest Seller Snapdeal Inventory");
|
| 133 |
rowhead.createCell((short) 9).setCellValue("Our Flipkart SP");
|
133 |
rowhead.createCell((short) 9).setCellValue("Our Flipkart SP");
|
| 134 |
rowhead.createCell((short) 10).setCellValue("Lowest Seller Flipkart");
|
134 |
rowhead.createCell((short) 10).setCellValue("Lowest Seller Flipkart");
|
| 135 |
rowhead.createCell((short) 11).setCellValue("Lowest Flipkart SP");
|
135 |
rowhead.createCell((short) 11).setCellValue("Lowest Flipkart SP");
|
| 136 |
rowhead.createCell((short) 12).setCellValue("Our Flipkart Inventory");
|
136 |
rowhead.createCell((short) 12).setCellValue("Our Flipkart Inventory");
|
| 137 |
rowhead.createCell((short) 13).setCellValue("MFN Price");
|
137 |
rowhead.createCell((short) 13).setCellValue("Our Price");
|
| 138 |
rowhead.createCell((short) 14).setCellValue("FBA Price");
|
- |
|
| 139 |
rowhead.createCell((short) 15).setCellValue("Lowest Seller Amazon");
|
138 |
rowhead.createCell((short) 14).setCellValue("Lowest Amazon Seller");
|
| 140 |
rowhead.createCell((short) 16).setCellValue("Lowest Amazon SP");
|
139 |
rowhead.createCell((short) 15).setCellValue("Lowest Amazon Price");
|
| 141 |
rowhead.createCell((short) 17).setCellValue("MFN Inventory");
|
- |
|
| 142 |
rowhead.createCell((short) 18).setCellValue("FBA Inventory");
|
- |
|
| 143 |
Client cc = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
|
140 |
Client cc = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
|
| 144 |
data = cc.getUploadResultById(Long.valueOf(this.requestId));
|
141 |
data = cc.getUploadResultById(Long.valueOf(this.requestId));
|
| 145 |
int iterator=1;
|
142 |
int iterator=1;
|
| 146 |
for (CompetitorPricing item : data){
|
143 |
for (CompetitorPricing item : data){
|
| 147 |
HSSFRow row = sheet.createRow((short)iterator);
|
144 |
HSSFRow row = sheet.createRow((short)iterator);
|
| Line 156... |
Line 153... |
| 156 |
row.createCell((short) 8).setCellValue(item.getLowestSnapdealSellerInventory());
|
153 |
row.createCell((short) 8).setCellValue(item.getLowestSnapdealSellerInventory());
|
| 157 |
row.createCell((short) 9).setCellValue(item.getOurFlipkartPrice());
|
154 |
row.createCell((short) 9).setCellValue(item.getOurFlipkartPrice());
|
| 158 |
row.createCell((short) 10).setCellValue(item.getLowestFlipkartSeller());
|
155 |
row.createCell((short) 10).setCellValue(item.getLowestFlipkartSeller());
|
| 159 |
row.createCell((short) 11).setCellValue(item.getLowestFlipkartPrice());
|
156 |
row.createCell((short) 11).setCellValue(item.getLowestFlipkartPrice());
|
| 160 |
row.createCell((short) 12).setCellValue(item.getOurFlipkartInventory());
|
157 |
row.createCell((short) 12).setCellValue(item.getOurFlipkartInventory());
|
| 161 |
row.createCell((short) 13).setCellValue(item.getOurMfnPrice());
|
158 |
row.createCell((short) 13).setCellValue(item.getOurAmazonPrice());
|
| 162 |
row.createCell((short) 14).setCellValue(item.getOurFbaPrice());
|
- |
|
| 163 |
row.createCell((short) 15).setCellValue(item.getLowestAmazonSeller());
|
159 |
row.createCell((short) 14).setCellValue(item.getLowestAmazonSeller());
|
| 164 |
row.createCell((short) 16).setCellValue(item.getLowestAmazonPrice());
|
160 |
row.createCell((short) 15).setCellValue(item.getLowestAmazonPrice());
|
| 165 |
row.createCell((short) 17).setCellValue(item.getOurMfnInventory());
|
- |
|
| 166 |
row.createCell((short) 18).setCellValue(item.getOurFbaInventory());
|
- |
|
| 167 |
iterator++;
|
161 |
iterator++;
|
| 168 |
}
|
162 |
}
|
| 169 |
FileOutputStream fileOut = null;
|
163 |
FileOutputStream fileOut = null;
|
| 170 |
try {
|
164 |
try {
|
| 171 |
fileOut = new FileOutputStream(file);
|
165 |
fileOut = new FileOutputStream(file);
|