| Line 813... |
Line 813... |
| 813 |
row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
|
813 |
row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
|
| 814 |
row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
|
814 |
row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
|
| 815 |
|
815 |
|
| 816 |
i=1;
|
816 |
i=1;
|
| 817 |
for(StockSaleDetail ssDetail : nonMovingStockSaleList){
|
817 |
for(StockSaleDetail ssDetail : nonMovingStockSaleList){
|
| 818 |
row = movingSheet.createRow(i);
|
818 |
row = nonMovingSheet.createRow(i);
|
| 819 |
row.createCell(0).setCellValue(ssDetail.getItemId()+"");
|
819 |
row.createCell(0).setCellValue(ssDetail.getItemId()+"");
|
| 820 |
row.createCell(1).setCellValue(ssDetail.getCategory());
|
820 |
row.createCell(1).setCellValue(ssDetail.getCategory());
|
| 821 |
row.createCell(2).setCellValue(ssDetail.getProductGroup());
|
821 |
row.createCell(2).setCellValue(ssDetail.getProductGroup());
|
| 822 |
row.createCell(3).setCellValue(ssDetail.getBrand());
|
822 |
row.createCell(3).setCellValue(ssDetail.getBrand());
|
| 823 |
row.createCell(4).setCellValue(ssDetail.getModelName());
|
823 |
row.createCell(4).setCellValue(ssDetail.getModelName());
|
| Line 868... |
Line 868... |
| 868 |
row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
|
868 |
row.createCell(21).setCellValue("Sales History(Amazon-MFN)");
|
| 869 |
row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
|
869 |
row.createCell(22).setCellValue("Avg Sales(Amazon-MFN)");
|
| 870 |
|
870 |
|
| 871 |
i=1;
|
871 |
i=1;
|
| 872 |
for(StockSaleDetail ssDetail : slowMovingStockSaleList){
|
872 |
for(StockSaleDetail ssDetail : slowMovingStockSaleList){
|
| 873 |
row = movingSheet.createRow(i);
|
873 |
row = slowMovingSheet.createRow(i);
|
| 874 |
row.createCell(0).setCellValue(ssDetail.getItemId()+"");
|
874 |
row.createCell(0).setCellValue(ssDetail.getItemId()+"");
|
| 875 |
row.createCell(1).setCellValue(ssDetail.getCategory());
|
875 |
row.createCell(1).setCellValue(ssDetail.getCategory());
|
| 876 |
row.createCell(2).setCellValue(ssDetail.getProductGroup());
|
876 |
row.createCell(2).setCellValue(ssDetail.getProductGroup());
|
| 877 |
row.createCell(3).setCellValue(ssDetail.getBrand());
|
877 |
row.createCell(3).setCellValue(ssDetail.getBrand());
|
| 878 |
row.createCell(4).setCellValue(ssDetail.getModelName());
|
878 |
row.createCell(4).setCellValue(ssDetail.getModelName());
|