| Line 183... |
Line 183... |
| 183 |
int i=0;
|
183 |
int i=0;
|
| 184 |
if(showPartner) {
|
184 |
if(showPartner) {
|
| 185 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 6, 6));
|
185 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 6, 6));
|
| 186 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 7, 7));
|
186 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 7, 7));
|
| 187 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 8, 8));
|
187 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 8, 8));
|
| - |
|
188 |
}
|
| - |
|
189 |
sheet.trackAllColumnsForAutoSizing();
|
| - |
|
190 |
if(showPartner) {
|
| 188 |
Cell cellFofoIdHeader = rowHeader.createCell(i++);
|
191 |
Cell cellFofoIdHeader = rowHeader.createCell(i++);
|
| 189 |
cellFofoIdHeader.setCellValue("Partner Id");
|
192 |
cellFofoIdHeader.setCellValue("Partner Id");
|
| 190 |
Cell cellStoreCodeHeader = rowHeader.createCell(i++);
|
193 |
Cell cellStoreCodeHeader = rowHeader.createCell(i++);
|
| 191 |
cellStoreCodeHeader.setCellValue("Store Code");
|
194 |
cellStoreCodeHeader.setCellValue("Store Code");
|
| 192 |
Cell cellStoreNameHeader = rowHeader.createCell(i++);
|
195 |
Cell cellStoreNameHeader = rowHeader.createCell(i++);
|
| 193 |
cellStoreNameHeader.setCellValue("Store Name");
|
196 |
cellStoreNameHeader.setCellValue("Store Name");
|
| 194 |
}
|
197 |
}
|
| 195 |
sheet.trackAllColumnsForAutoSizing();
|
- |
|
| 196 |
Cell cellItemIdHeader = rowHeader.createCell(i++);
|
198 |
Cell cellItemIdHeader = rowHeader.createCell(i++);
|
| 197 |
cellItemIdHeader.setCellValue("Item Id");
|
199 |
cellItemIdHeader.setCellValue("Item Id");
|
| 198 |
Cell cellBrandHeader = rowHeader.createCell(i++);
|
200 |
Cell cellBrandHeader = rowHeader.createCell(i++);
|
| 199 |
cellBrandHeader.setCellValue("Brand");
|
201 |
cellBrandHeader.setCellValue("Brand");
|
| 200 |
Cell cellModelNameHeader = rowHeader.createCell(i++);
|
202 |
Cell cellModelNameHeader = rowHeader.createCell(i++);
|
| Line 234... |
Line 236... |
| 234 |
}
|
236 |
}
|
| 235 |
for (InventoryItemAgingModel inventoryItemAgingModel : inventoryItemAgingModels) {
|
237 |
for (InventoryItemAgingModel inventoryItemAgingModel : inventoryItemAgingModels) {
|
| 236 |
i=0;
|
238 |
i=0;
|
| 237 |
Row rowValues = sheet.createRow(rowIndex++);
|
239 |
Row rowValues = sheet.createRow(rowIndex++);
|
| 238 |
if(showPartner) {
|
240 |
if(showPartner) {
|
| 239 |
rowHeader.createCell(i++).setCellValue(inventoryItemAgingModel.getFofoId());
|
241 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getFofoId());
|
| 240 |
rowHeader.createCell(i++).setCellValue(inventoryItemAgingModel.getStoreCode());
|
242 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getStoreCode());
|
| 241 |
rowHeader.createCell(i++).setCellValue(inventoryItemAgingModel.getStoreName());
|
243 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getStoreName());
|
| 242 |
}
|
244 |
}
|
| 243 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getItemId());
|
245 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getItemId());
|
| 244 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getBrand());
|
246 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getBrand());
|
| 245 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getModelName());
|
247 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getModelName());
|
| 246 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getModelNumber());
|
248 |
rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getModelNumber());
|