| Line 89... |
Line 89... |
| 89 |
private ItemLoaderModel createLoaderModel(XSSFRow row) throws ProfitMandiBusinessException {
|
89 |
private ItemLoaderModel createLoaderModel(XSSFRow row) throws ProfitMandiBusinessException {
|
| 90 |
ItemLoaderModel itemLoaderModel = new ItemLoaderModel();
|
90 |
ItemLoaderModel itemLoaderModel = new ItemLoaderModel();
|
| 91 |
int i = 0;
|
91 |
int i = 0;
|
| 92 |
itemLoaderModel.setRowIndex(row.getRowNum());
|
92 |
itemLoaderModel.setRowIndex(row.getRowNum());
|
| 93 |
try {
|
93 |
try {
|
| 94 |
itemLoaderModel.setProductGroup(row.getCell(i++).getStringCellValue());
|
94 |
itemLoaderModel.setProductGroup(row.getCell(i++).getStringCellValue().trim());
|
| 95 |
itemLoaderModel.setCategoryId((int) row.getCell(i++).getNumericCellValue());
|
95 |
itemLoaderModel.setCategoryId((int) row.getCell(i++).getNumericCellValue());
|
| 96 |
itemLoaderModel.setCategory(row.getCell(i++).getStringCellValue());
|
96 |
itemLoaderModel.setCategory(row.getCell(i++).getStringCellValue().trim());
|
| 97 |
itemLoaderModel.setHsnCode(String.valueOf((int) row.getCell(i++).getNumericCellValue()));
|
97 |
itemLoaderModel.setHsnCode(String.valueOf((int) row.getCell(i++).getNumericCellValue()));
|
| 98 |
itemLoaderModel.setBrand(row.getCell(i++).getStringCellValue());
|
98 |
itemLoaderModel.setBrand(row.getCell(i++).getStringCellValue().trim());
|
| 99 |
itemLoaderModel.setModelNumber(row.getCell(i++).getStringCellValue());
|
99 |
itemLoaderModel.setModelNumber(row.getCell(i++).getStringCellValue().trim());
|
| 100 |
Cell modelCell = row.getCell(i++);
|
100 |
Cell modelCell = row.getCell(i++);
|
| 101 |
if (modelCell == null) {
|
101 |
if (modelCell == null) {
|
| 102 |
itemLoaderModel.setModelName("");
|
102 |
itemLoaderModel.setModelName("");
|
| 103 |
} else {
|
103 |
} else {
|
| 104 |
itemLoaderModel.setModelName(modelCell.getStringCellValue());
|
104 |
itemLoaderModel.setModelName(modelCell.getStringCellValue().trim());
|
| 105 |
}
|
105 |
}
|
| 106 |
itemLoaderModel.setColor(row.getCell(i++).getStringCellValue());
|
106 |
itemLoaderModel.setColor(row.getCell(i++).getStringCellValue().trim());
|
| 107 |
//MRP SP MOP DP TP NLC Startdate Preferred Vendor Risky
|
107 |
//MRP SP MOP DP TP NLC Startdate Preferred Vendor Risky
|
| 108 |
// Weight Item type(1 for Serialized and 2 for non-serialized) TaxRate
|
108 |
// Weight Item type(1 for Serialized and 2 for non-serialized) TaxRate
|
| 109 |
itemLoaderModel.setMrp(row.getCell(i++).getNumericCellValue());
|
109 |
itemLoaderModel.setMrp(row.getCell(i++).getNumericCellValue());
|
| 110 |
itemLoaderModel.setSp(row.getCell(i++).getNumericCellValue());
|
110 |
itemLoaderModel.setSp(row.getCell(i++).getNumericCellValue());
|
| 111 |
itemLoaderModel.setMop(row.getCell(i++).getNumericCellValue());
|
111 |
itemLoaderModel.setMop(row.getCell(i++).getNumericCellValue());
|
| Line 143... |
Line 143... |
| 143 |
if (cell == null) {
|
143 |
if (cell == null) {
|
| 144 |
return "Null cell";
|
144 |
return "Null cell";
|
| 145 |
}
|
145 |
}
|
| 146 |
switch (cell.getCellTypeEnum()) {
|
146 |
switch (cell.getCellTypeEnum()) {
|
| 147 |
case STRING:
|
147 |
case STRING:
|
| 148 |
return cell.getStringCellValue();
|
148 |
return cell.getStringCellValue().trim();
|
| 149 |
case NUMERIC:
|
149 |
case NUMERIC:
|
| 150 |
if (DateUtil.isCellDateFormatted(cell)) {
|
150 |
if (DateUtil.isCellDateFormatted(cell)) {
|
| 151 |
return cell.getDateCellValue().toString();
|
151 |
return cell.getDateCellValue().toString();
|
| 152 |
} else {
|
152 |
} else {
|
| 153 |
return Double.toString(cell.getNumericCellValue());
|
153 |
return Double.toString(cell.getNumericCellValue());
|