| Line 103... |
Line 103... |
| 103 |
BufferedWriter slowMovingBufferedWriter = new BufferedWriter(new FileWriter(
|
103 |
BufferedWriter slowMovingBufferedWriter = new BufferedWriter(new FileWriter(
|
| 104 |
slowMovingFile));
|
104 |
slowMovingFile));
|
| 105 |
BufferedWriter movingBufferedWriter = new BufferedWriter(new FileWriter(
|
105 |
BufferedWriter movingBufferedWriter = new BufferedWriter(new FileWriter(
|
| 106 |
movingFile));
|
106 |
movingFile));
|
| 107 |
nonMovingBufferedWriter.write(StringUtils.join(new String[] { "ItemId", "Category", "ProductGroup",
|
107 |
nonMovingBufferedWriter.write(StringUtils.join(new String[] { "ItemId", "Category", "ProductGroup",
|
| 108 |
"Brand", "Model Name", "Model Number", "Color", "Stock Qty", "Stock Value", "NOD Stock",
|
108 |
"Brand", "Model Name", "Model Number", "Color", "Product", "Stock Qty", "Stock Value", "NOD Stock",
|
| 109 |
"Sales History(All-Sources)", "Avg Sales(All-Sources)", "Sales History(Website)",
|
109 |
"Sales History(All-Sources)", "Avg Sales(All-Sources)", "Sales History(Website)",
|
| 110 |
"Avg Sales(Website)", "Sales History(Ebay)", "Avg Sales(Ebay)", "Sales History(Snapdeal)",
|
110 |
"Avg Sales(Website)", "Sales History(Ebay)", "Avg Sales(Ebay)", "Sales History(Snapdeal)",
|
| 111 |
"Avg Sales(Snapdeal)", "Sales History(Flipkart)", "Avg Sales(Flipkart)",
|
111 |
"Avg Sales(Snapdeal)", "Sales History(Flipkart)", "Avg Sales(Flipkart)",
|
| 112 |
"Sales History(Amazon-MFN)", "Avg Sales(Amazon-MFN)"}, '\t'));
|
112 |
"Sales History(Amazon-MFN)", "Avg Sales(Amazon-MFN)"}, '\t'));
|
| 113 |
slowMovingBufferedWriter.write(StringUtils.join(new String[] { "ItemId", "Category", "ProductGroup",
|
113 |
slowMovingBufferedWriter.write(StringUtils.join(new String[] { "ItemId", "Category", "ProductGroup",
|
| 114 |
"Brand", "Model Name", "Model Number", "Color", "Stock Qty", "Stock Value", "NOD Stock",
|
114 |
"Brand", "Model Name", "Model Number", "Color", "Product", "Stock Qty", "Stock Value", "NOD Stock",
|
| 115 |
"Sales History(All-Sources)", "Avg Sales(All-Sources)", "Sales History(Website)",
|
115 |
"Sales History(All-Sources)", "Avg Sales(All-Sources)", "Sales History(Website)",
|
| 116 |
"Avg Sales(Website)", "Sales History(Ebay)", "Avg Sales(Ebay)", "Sales History(Snapdeal)",
|
116 |
"Avg Sales(Website)", "Sales History(Ebay)", "Avg Sales(Ebay)", "Sales History(Snapdeal)",
|
| 117 |
"Avg Sales(Snapdeal)", "Sales History(Flipkart)", "Avg Sales(Flipkart)",
|
117 |
"Avg Sales(Snapdeal)", "Sales History(Flipkart)", "Avg Sales(Flipkart)",
|
| 118 |
"Sales History(Amazon-MFN)", "Avg Sales(Amazon-MFN)"}, '\t'));
|
118 |
"Sales History(Amazon-MFN)", "Avg Sales(Amazon-MFN)"}, '\t'));
|
| 119 |
movingBufferedWriter.write(StringUtils.join(new String[] { "ItemId", "Category", "ProductGroup",
|
119 |
movingBufferedWriter.write(StringUtils.join(new String[] { "ItemId", "Category", "ProductGroup",
|
| 120 |
"Brand", "Model Name", "Model Number", "Color", "Stock Qty", "Stock Value", "NOD Stock",
|
120 |
"Brand", "Model Name", "Model Number", "Color", "Product", "Stock Qty", "Stock Value", "NOD Stock",
|
| 121 |
"Sales History(All-Sources)", "Avg Sales(All-Sources)", "Sales History(Website)",
|
121 |
"Sales History(All-Sources)", "Avg Sales(All-Sources)", "Sales History(Website)",
|
| 122 |
"Avg Sales(Website)", "Sales History(Ebay)", "Avg Sales(Ebay)", "Sales History(Snapdeal)",
|
122 |
"Avg Sales(Website)", "Sales History(Ebay)", "Avg Sales(Ebay)", "Sales History(Snapdeal)",
|
| 123 |
"Avg Sales(Snapdeal)", "Sales History(Flipkart)", "Avg Sales(Flipkart)",
|
123 |
"Avg Sales(Snapdeal)", "Sales History(Flipkart)", "Avg Sales(Flipkart)",
|
| 124 |
"Sales History(Amazon-MFN)", "Avg Sales(Amazon-MFN)"}, '\t'));
|
124 |
"Sales History(Amazon-MFN)", "Avg Sales(Amazon-MFN)"}, '\t'));
|
| 125 |
|
125 |
|
| Line 248... |
Line 248... |
| 248 |
if(totalAverageSale<=0.0) {
|
248 |
if(totalAverageSale<=0.0) {
|
| 249 |
nonMovingBufferedWriter.write('\n');
|
249 |
nonMovingBufferedWriter.write('\n');
|
| 250 |
nonMovingBufferedWriter.write(StringUtils.join(
|
250 |
nonMovingBufferedWriter.write(StringUtils.join(
|
| 251 |
new String[] {
|
251 |
new String[] {
|
| 252 |
String.valueOf(item.getId()),
|
252 |
String.valueOf(item.getId()),
|
| 253 |
categoryIdLabelMap.get(item.getCatalogItemId()),
|
253 |
categoryIdLabelMap.get(item.getCategory()),
|
| 254 |
item.getProductGroup(),
|
254 |
item.getProductGroup(),
|
| 255 |
item.getBrand(),
|
255 |
item.getBrand(),
|
| 256 |
item.getModelName(),
|
256 |
item.getModelName(),
|
| 257 |
item.getModelNumber(),
|
257 |
item.getModelNumber(),
|
| 258 |
item.getColor(),
|
258 |
item.getColor(),
|
| - |
|
259 |
item.getBrand() + " " + item.getModelName() + " " + item.getModelNumber() + " " + item.getColor(),
|
| 259 |
stockCount.toString(),
|
260 |
stockCount.toString(),
|
| 260 |
stockValue.toString(),
|
261 |
stockValue.toString(),
|
| 261 |
totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()).toString(): "0",
|
262 |
totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()).toString(): "0",
|
| 262 |
totalSaleHistory.substring(0, totalSaleHistory.length()-1),
|
263 |
totalSaleHistory.substring(0, totalSaleHistory.length()-1),
|
| 263 |
totalAverageSale.toString(),
|
264 |
totalAverageSale.toString(),
|
| Line 277... |
Line 278... |
| 277 |
if(nodStock>30) {
|
278 |
if(nodStock>30) {
|
| 278 |
slowMovingBufferedWriter.write('\n');
|
279 |
slowMovingBufferedWriter.write('\n');
|
| 279 |
slowMovingBufferedWriter.write(StringUtils.join(
|
280 |
slowMovingBufferedWriter.write(StringUtils.join(
|
| 280 |
new String[] {
|
281 |
new String[] {
|
| 281 |
String.valueOf(item.getId()),
|
282 |
String.valueOf(item.getId()),
|
| 282 |
categoryIdLabelMap.get(item.getCatalogItemId()),
|
283 |
categoryIdLabelMap.get(item.getCategory()),
|
| 283 |
item.getProductGroup(),
|
284 |
item.getProductGroup(),
|
| 284 |
item.getBrand(),
|
285 |
item.getBrand(),
|
| 285 |
item.getModelName(),
|
286 |
item.getModelName(),
|
| 286 |
item.getModelNumber(),
|
287 |
item.getModelNumber(),
|
| 287 |
item.getColor(),
|
288 |
item.getColor(),
|
| - |
|
289 |
item.getBrand() + " " + item.getModelName() + " " + item.getModelNumber() + " " + item.getColor(),
|
| 288 |
stockCount.toString(),
|
290 |
stockCount.toString(),
|
| 289 |
stockValue.toString(),
|
291 |
stockValue.toString(),
|
| 290 |
totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()).toString(): "0",
|
292 |
totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()).toString(): "0",
|
| 291 |
totalSaleHistory.substring(0, totalSaleHistory.length()-1),
|
293 |
totalSaleHistory.substring(0, totalSaleHistory.length()-1),
|
| 292 |
totalAverageSale.toString(),
|
294 |
totalAverageSale.toString(),
|
| Line 303... |
Line 305... |
| 303 |
} else {
|
305 |
} else {
|
| 304 |
movingBufferedWriter.write('\n');
|
306 |
movingBufferedWriter.write('\n');
|
| 305 |
movingBufferedWriter.write(StringUtils.join(
|
307 |
movingBufferedWriter.write(StringUtils.join(
|
| 306 |
new String[] {
|
308 |
new String[] {
|
| 307 |
String.valueOf(item.getId()),
|
309 |
String.valueOf(item.getId()),
|
| 308 |
categoryIdLabelMap.get(item.getCatalogItemId()),
|
310 |
categoryIdLabelMap.get(item.getCategory()),
|
| 309 |
item.getProductGroup(),
|
311 |
item.getProductGroup(),
|
| 310 |
item.getBrand(),
|
312 |
item.getBrand(),
|
| 311 |
item.getModelName(),
|
313 |
item.getModelName(),
|
| 312 |
item.getModelNumber(),
|
314 |
item.getModelNumber(),
|
| 313 |
item.getColor(),
|
315 |
item.getColor(),
|
| - |
|
316 |
item.getBrand() + " " + item.getModelName() + " " + item.getModelNumber() + " " + item.getColor(),
|
| 314 |
stockCount.toString(),
|
317 |
stockCount.toString(),
|
| 315 |
stockValue.toString(),
|
318 |
stockValue.toString(),
|
| 316 |
totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()).toString(): "0",
|
319 |
totalAverageSale>0 ? new Long(new Double(stockCount/totalAverageSale).longValue()).toString(): "0",
|
| 317 |
totalSaleHistory.substring(0, totalSaleHistory.length()-1),
|
320 |
totalSaleHistory.substring(0, totalSaleHistory.length()-1),
|
| 318 |
totalAverageSale.toString(),
|
321 |
totalAverageSale.toString(),
|