| Line 2... |
Line 2... |
| 2 |
|
2 |
|
| 3 |
import in.shop2020.model.v1.catalog.Amazonlisted;
|
3 |
import in.shop2020.model.v1.catalog.Amazonlisted;
|
| 4 |
import in.shop2020.model.v1.catalog.CatalogService.Client;
|
4 |
import in.shop2020.model.v1.catalog.CatalogService.Client;
|
| 5 |
import in.shop2020.model.v1.catalog.SnapdealItem;
|
5 |
import in.shop2020.model.v1.catalog.SnapdealItem;
|
| 6 |
import in.shop2020.model.v1.order.AmazonFbaSalesSnapshot;
|
6 |
import in.shop2020.model.v1.order.AmazonFbaSalesSnapshot;
|
| - |
|
7 |
import in.shop2020.model.v1.order.SnapdealOrder;
|
| 7 |
import in.shop2020.support.utils.ReportsUtils;
|
8 |
import in.shop2020.support.utils.ReportsUtils;
|
| 8 |
import in.shop2020.thrift.clients.CatalogClient;
|
9 |
import in.shop2020.thrift.clients.CatalogClient;
|
| 9 |
import in.shop2020.thrift.clients.TransactionClient;
|
10 |
import in.shop2020.thrift.clients.TransactionClient;
|
| 10 |
|
11 |
|
| 11 |
import java.io.BufferedInputStream;
|
12 |
import java.io.BufferedInputStream;
|
| Line 170... |
Line 171... |
| 170 |
HSSFWorkbook workbook = new HSSFWorkbook(iFile);
|
171 |
HSSFWorkbook workbook = new HSSFWorkbook(iFile);
|
| 171 |
HSSFSheet sheet = workbook.getSheetAt(0);
|
172 |
HSSFSheet sheet = workbook.getSheetAt(0);
|
| 172 |
Client CatalogClient=null;
|
173 |
Client CatalogClient=null;
|
| 173 |
StringBuilder sb = new StringBuilder();
|
174 |
StringBuilder sb = new StringBuilder();
|
| 174 |
try {
|
175 |
try {
|
| 175 |
CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
|
176 |
//CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
|
| - |
|
177 |
CatalogClient = new CatalogClient().getClient();
|
| 176 |
} catch (TTransportException e) {
|
178 |
} catch (TTransportException e) {
|
| 177 |
// TODO Auto-generated catch block
|
179 |
// TODO Auto-generated catch block
|
| 178 |
e.printStackTrace();
|
180 |
e.printStackTrace();
|
| 179 |
}
|
181 |
}
|
| 180 |
for (int iterator=(sheet.getFirstRowNum()+1);iterator<=sheet.getLastRowNum();iterator++){
|
182 |
for (int iterator=(sheet.getFirstRowNum()+1);iterator<=sheet.getLastRowNum();iterator++){
|
| Line 184... |
Line 186... |
| 184 |
continue;
|
186 |
continue;
|
| 185 |
}
|
187 |
}
|
| 186 |
else {
|
188 |
else {
|
| 187 |
sku=(long) sheet.getRow(iterator).getCell(0).getNumericCellValue();
|
189 |
sku=(long) sheet.getRow(iterator).getCell(0).getNumericCellValue();
|
| 188 |
snapdealItem = CatalogClient.getSnapdealItem(sku);
|
190 |
snapdealItem = CatalogClient.getSnapdealItem(sku);
|
| - |
|
191 |
if(snapdealItem.getItem_id()==0){
|
| - |
|
192 |
snapdealItem = new SnapdealItem();
|
| - |
|
193 |
snapdealItem.setItem_id(sku);
|
| - |
|
194 |
}
|
| 189 |
}
|
195 |
}
|
| 190 |
|
196 |
|
| 191 |
if (!checkEmptyString(sheet.getRow(iterator).getCell(1))){
|
197 |
if (!checkEmptyString(sheet.getRow(iterator).getCell(1))){
|
| 192 |
long warehouseId = (long) sheet.getRow(iterator).getCell(1).getNumericCellValue();
|
198 |
long warehouseId = (long) sheet.getRow(iterator).getCell(1).getNumericCellValue();
|
| 193 |
snapdealItem.setWarehouseId(warehouseId);
|
199 |
snapdealItem.setWarehouseId(warehouseId);
|