| Line 166... |
Line 166... |
| 166 |
List<Integer> intervals, OutputStream outputStream) {
|
166 |
List<Integer> intervals, OutputStream outputStream) {
|
| 167 |
SXSSFWorkbook workbook = new SXSSFWorkbook();
|
167 |
SXSSFWorkbook workbook = new SXSSFWorkbook();
|
| 168 |
|
168 |
|
| 169 |
// CreationHelper createHelper = workbook.getCreationHelper();
|
169 |
// CreationHelper createHelper = workbook.getCreationHelper();
|
| 170 |
boolean showPartner = inventoryItemAgingModels.get(0).getFofoId() == 0;
|
170 |
boolean showPartner = inventoryItemAgingModels.get(0).getFofoId() == 0;
|
| 171 |
int nonValueColumns = 6;
|
171 |
int nonValueColumns = showPartner ? 9 : 6;
|
| 172 |
SXSSFSheet sheet = workbook.createSheet("InventoryItemAging");
|
172 |
SXSSFSheet sheet = workbook.createSheet("InventoryItemAging");
|
| 173 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 0, 0));
|
173 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 0, 0));
|
| 174 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
|
174 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
|
| 175 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 2, 2));
|
175 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 2, 2));
|
| 176 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 3, 3));
|
176 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 3, 3));
|
| Line 183... |
Line 183... |
| 183 |
Row rowPriceQuantity = sheet.createRow(rowIndex++);
|
183 |
Row rowPriceQuantity = sheet.createRow(rowIndex++);
|
| 184 |
int i=0;
|
184 |
int i=0;
|
| 185 |
if(showPartner) {
|
185 |
if(showPartner) {
|
| 186 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 6, 6));
|
186 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 6, 6));
|
| 187 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 7, 7));
|
187 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 7, 7));
|
| 188 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 7, 8));
|
188 |
sheet.addMergedRegion(new CellRangeAddress(0, 1, 8, 8));
|
| 189 |
Cell cellFofoIdHeader = rowHeader.createCell(i++);
|
189 |
Cell cellFofoIdHeader = rowHeader.createCell(i++);
|
| 190 |
cellFofoIdHeader.setCellValue("Partner Id");
|
190 |
cellFofoIdHeader.setCellValue("Partner Id");
|
| 191 |
Cell cellStoreCodeHeader = rowHeader.createCell(i++);
|
191 |
Cell cellStoreCodeHeader = rowHeader.createCell(i++);
|
| 192 |
cellStoreCodeHeader.setCellValue("Store Code");
|
192 |
cellStoreCodeHeader.setCellValue("Store Code");
|
| 193 |
Cell cellStoreNameHeader = rowHeader.createCell(i++);
|
193 |
Cell cellStoreNameHeader = rowHeader.createCell(i++);
|
| 194 |
cellStoreNameHeader.setCellValue("Store Name");
|
194 |
cellStoreNameHeader.setCellValue("Store Name");
|
| 195 |
nonValueColumns = 9;
|
- |
|
| 196 |
}
|
195 |
}
|
| 197 |
Cell cellItemIdHeader = rowHeader.createCell(i++);
|
196 |
Cell cellItemIdHeader = rowHeader.createCell(i++);
|
| 198 |
cellItemIdHeader.setCellValue("Item Id");
|
197 |
cellItemIdHeader.setCellValue("Item Id");
|
| 199 |
Cell cellBrandHeader = rowHeader.createCell(i++);
|
198 |
Cell cellBrandHeader = rowHeader.createCell(i++);
|
| 200 |
cellBrandHeader.setCellValue("Brand");
|
199 |
cellBrandHeader.setCellValue("Brand");
|