Subversion Repositories SmartDukaan

Rev

Rev 12220 | Rev 12222 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12220 Rev 12221
Line 179... Line 179...
179 
					}
 179 
					}
180 
				}
 180 
				}
181 
				if(stockCount<=0) {
 181 
				if(stockCount<=0) {
182 
					continue;
 182 
					continue;
183 
				}
 183 
				}
- 
 
 184 
				if(oosStatusMapByItem.containsKey(item.getId())){
184 
				for(OOSStatus oosStatus : oosStatusMapByItem.get(item.getId())) {
 185 
					for(OOSStatus oosStatus : oosStatusMapByItem.get(item.getId())) {
185 
					switch(oosStatus.getSourceId()) {
 186 
						switch(oosStatus.getSourceId()) {
186 
					case 0:
187 
						case 0:
187 
						if(oosStatus.isIs_oos()== false) {
 188 
							if(oosStatus.isIs_oos()== false) {
188 
							totalInStockDays++;
 189 
								totalInStockDays++;
189 
							totalOrderCount += oosStatus.getNum_orders();
 190 
								totalOrderCount += oosStatus.getNum_orders();
190 
							totalSaleHistory.append(oosStatus.getNum_orders() + "-");
 191 
								totalSaleHistory.append(oosStatus.getNum_orders() + "-");
191 
						} else {
 192 
							} else {
192 
							totalSaleHistory.append("X-");
 193 
								totalSaleHistory.append("X-");
193 
						}
 194 
							}
194 
						break;
 195 
							break;
195 
					case 1:
196 
						case 1:
196 
						if(oosStatus.isIs_oos()== false) {
 197 
							if(oosStatus.isIs_oos()== false) {
197 
							websiteInStockDays++;
 198 
								websiteInStockDays++;
198 
							websiteOrderCount += oosStatus.getNum_orders();
 199 
								websiteOrderCount += oosStatus.getNum_orders();
199 
							websiteSaleHistory.append(oosStatus.getNum_orders() + "-");
 200 
								websiteSaleHistory.append(oosStatus.getNum_orders() + "-");
200 
						} else {
 201 
							} else {
201 
							websiteSaleHistory.append("X-");
 202 
								websiteSaleHistory.append("X-");
202 
						}
 203 
							}
203 
						break;
 204 
							break;
204 
					case 3:
205 
						case 3:
205 
						if(oosStatus.isIs_oos()== false) {
 206 
							if(oosStatus.isIs_oos()== false) {
206 
							amzn_mfnInStockDays++;
 207 
								amzn_mfnInStockDays++;
207 
							amzn_mfnOrderCount += oosStatus.getNum_orders();
 208 
								amzn_mfnOrderCount += oosStatus.getNum_orders();
208 
							amzn_mfnSaleHistory.append(oosStatus.getNum_orders() + "-");
 209 
								amzn_mfnSaleHistory.append(oosStatus.getNum_orders() + "-");
209 
						} else {
 210 
							} else {
210 
							amzn_mfnSaleHistory.append("X-");
 211 
								amzn_mfnSaleHistory.append("X-");
- 
 
 212 
							}
- 
 
 213 
							break;
- 
 
 214 
						case 6:
- 
 
 215 
							if(oosStatus.isIs_oos()== false) {
- 
 
 216 
								ebayInStockDays++;
- 
 
 217 
								ebayOrderCount += oosStatus.getNum_orders();
- 
 
 218 
								ebaySaleHistory.append(oosStatus.getNum_orders() + "-");
- 
 
 219 
							} else {
- 
 
 220 
								ebaySaleHistory.append("X-");
- 
 
 221 
							}
- 
 
 222 
							break;
- 
 
 223 
						case 7:
- 
 
 224 
							if(oosStatus.isIs_oos()== false) {
- 
 
 225 
								snapdealInStockDays++;
- 
 
 226 
								snapdealOrderCount += oosStatus.getNum_orders();
- 
 
 227 
								snapdealSaleHistory.append(oosStatus.getNum_orders() + "-");
- 
 
 228 
							} else {
- 
 
 229 
								snapdealSaleHistory.append("X-");
- 
 
 230 
							}
- 
 
 231 
							break;
- 
 
 232 
						case 8:
- 
 
 233 
							if(oosStatus.isIs_oos()== false) {
- 
 
 234 
								flipkartInStockDays++;
- 
 
 235 
								flipkartOrderCount += oosStatus.getNum_orders();
- 
 
 236 
								flipkartSaleHistory.append(oosStatus.getNum_orders() + "-");
- 
 
 237 
							} else {
- 
 
 238 
								flipkartSaleHistory.append("X-");
- 
 
 239 
							}
- 
 
 240 
							break;
- 
 
 241 
						default:
- 
 
 242 
							//do nothing
- 
 
 243 
							break;
211 
						}
 244 
						}
212 
						break;
 - 
 
213 
					case 6:
- 
 
214 
						if(oosStatus.isIs_oos()== false) {
 - 
 
215 
							ebayInStockDays++;
 - 
 
216 
							ebayOrderCount += oosStatus.getNum_orders();
 - 
 
217 
							ebaySaleHistory.append(oosStatus.getNum_orders() + "-");
 - 
 
218 
						} else {
 - 
 
219 
							ebaySaleHistory.append("X-");
 - 
 
220 
						}
 - 
 
221 
						break;
 - 
 
222 
					case 7:
- 
 
223 
						if(oosStatus.isIs_oos()== false) {
 - 
 
224 
							snapdealInStockDays++;
 - 
 
225 
							snapdealOrderCount += oosStatus.getNum_orders();
 - 
 
226 
							snapdealSaleHistory.append(oosStatus.getNum_orders() + "-");
 - 
 
227 
						} else {
 - 
 
228 
							snapdealSaleHistory.append("X-");
 - 
 
229 
						}
 - 
 
230 
						break;
 - 
 
231 
					case 8:
- 
 
232 
						if(oosStatus.isIs_oos()== false) {
 - 
 
233 
							flipkartInStockDays++;
 - 
 
234 
							flipkartOrderCount += oosStatus.getNum_orders();
 - 
 
235 
							flipkartSaleHistory.append(oosStatus.getNum_orders() + "-");
 - 
 
236 
						} else {
 - 
 
237 
							flipkartSaleHistory.append("X-");
 - 
 
238 
						}
 - 
 
239 
						break;
 - 
 
240 
					default:
 - 
 
241 
						//do nothing
 - 
 
242 
						break;
 - 
 
243 
					}
 245 
					}
244 
				}
 246 
				}
- 
 
 247 
				else{
- 
 
 248 
					System.out.println("Oos Status is not available for item : - "+ item.getId());
- 
 
 249 
				}
245 
				totalAverageSale    = (double)totalOrderCount/totalInStockDays;
 250 
				totalAverageSale    = (double)totalOrderCount/totalInStockDays;
246 
				totalAverageSale    = Math.round(totalAverageSale * 10.0)/10.0;
 251 
				totalAverageSale    = Math.round(totalAverageSale * 10.0)/10.0;
247 
				websiteAverageSale  = (double)websiteOrderCount/websiteInStockDays;
 252 
				websiteAverageSale  = (double)websiteOrderCount/websiteInStockDays;
248 
				websiteAverageSale  = Math.round(websiteAverageSale * 10.0)/10.0;
 253 
				websiteAverageSale  = Math.round(websiteAverageSale * 10.0)/10.0;
249 
				ebayAverageSale     = (double)ebayOrderCount/ebayInStockDays;
 254 
				ebayAverageSale     = (double)ebayOrderCount/ebayInStockDays;
Line 365... Line 370...
365 
				Collections.sort(nonMovingStockSaleListMT, new SnmMovingStockSaleDetailComparator());
 370 
				Collections.sort(nonMovingStockSaleListMT, new SnmMovingStockSaleDetailComparator());
366 
			}
 371 
			}
367 
			if(nonMovingStockSaleListEMT!=null && nonMovingStockSaleListEMT.size()>2){
 372 
			if(nonMovingStockSaleListEMT!=null && nonMovingStockSaleListEMT.size()>2){
368 
				Collections.sort(nonMovingStockSaleListEMT, new SnmMovingStockSaleDetailComparator());
 373 
				Collections.sort(nonMovingStockSaleListEMT, new SnmMovingStockSaleDetailComparator());
369 
			}
 374 
			}
370
375 
 
371
376 
 
372 
			List<StockSaleDetail> itemToReplenishMT = new ArrayList<StockSaleDetail>();
 377 
			List<StockSaleDetail> itemToReplenishMT = new ArrayList<StockSaleDetail>();
373 
			List<StockSaleDetail> itemToReplenishEMT = new ArrayList<StockSaleDetail>();
 378 
			List<StockSaleDetail> itemToReplenishEMT = new ArrayList<StockSaleDetail>();
374 
			for(StockSaleDetail ssDetail  : movingStockSaleListMT){
 379 
			for(StockSaleDetail ssDetail  : movingStockSaleListMT){
375 
				if(ssDetail.getNodStock() <= 5){
 380 
				if(ssDetail.getNodStock() <= 5){
376 
					itemToReplenishMT.add(ssDetail);
 381 
					itemToReplenishMT.add(ssDetail);
Line 379... Line 384...
379 
			for(StockSaleDetail ssDetail  : movingStockSaleListEMT){
 384 
			for(StockSaleDetail ssDetail  : movingStockSaleListEMT){
380 
				if(ssDetail.getNodStock() <= 5){
 385 
				if(ssDetail.getNodStock() <= 5){
381 
					itemToReplenishEMT.add(ssDetail);
 386 
					itemToReplenishEMT.add(ssDetail);
382 
				}
 387 
				}
383 
			}
 388 
			}
384
389 
 
385 
			if(itemToReplenishMT!=null && itemToReplenishMT.size()>2){
 390 
			if(itemToReplenishMT!=null && itemToReplenishMT.size()>2){
386 
				Collections.sort(itemToReplenishMT, new MovingStockSaleDetailComparator());
 391 
				Collections.sort(itemToReplenishMT, new MovingStockSaleDetailComparator());
387 
			}
 392 
			}
388 
			if(itemToReplenishEMT!=null && itemToReplenishEMT.size()>2){
 393 
			if(itemToReplenishEMT!=null && itemToReplenishEMT.size()>2){
389 
				Collections.sort(itemToReplenishEMT, new MovingStockSaleDetailComparator());
 394 
				Collections.sort(itemToReplenishEMT, new MovingStockSaleDetailComparator());
390 
			}
 395 
			}
391
396 
 
392 
			StringBuffer sb = new StringBuffer();
 397 
			StringBuffer sb = new StringBuffer();
393 
			sb.append("<html>" );
 398 
			sb.append("<html>" );
394 
			sb.append("<table border=\"1\" align=\"center\">"
 399 
			sb.append("<table border=\"1\" align=\"center\">"
395 
					+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
 400 
					+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
396 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
401 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
Line 408... Line 413...
408 
			for(StockSaleDetail ssDetail  : itemToReplenishMT){
 413 
			for(StockSaleDetail ssDetail  : itemToReplenishMT){
409 
				if(i==10){
 414 
				if(i==10){
410 
					break;
 415 
					break;
411 
				}
 416 
				}
412 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
417 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
413 
					+ "<td>" + ssDetail.getBrand() + "</td>"
 418 
						+ "<td>" + ssDetail.getBrand() + "</td>"
414 
					+ "<td>" + ssDetail.getCategory() + "</td>"
 419 
						+ "<td>" + ssDetail.getCategory() + "</td>"
415 
					+ "<td>" + ssDetail.getProductGroup() + "</td>"
 420 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
416 
					+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
 421 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
417 
					+ "<td>" + ssDetail.getStockQuantity() + "</td>"
 422 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
418 
					+ "<td>" + ssDetail.getStockValue() + "</td>"
 423 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
419 
					+ "<td>" + ssDetail.getNodStock() + "</td>"
 424 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
420 
					+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
 425 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
421 
					+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
 426 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
422 
					+ "</tr>");
 427 
						+ "</tr>");
423 
				i++;
 428 
				i++;
424 
			}
 429 
			}
425
430 
 
426 
			sb.append("</table>" );
 431 
			sb.append("</table>" );
427
432 
 
428 
			sb.append("<table border=\"1\" align=\"center\">"
 433 
			sb.append("<table border=\"1\" align=\"center\">"
429 
					+ "<caption><b>" + "SLOW MOVING ITEMS" + "</b></caption>"
 434 
					+ "<caption><b>" + "SLOW MOVING ITEMS" + "</b></caption>"
430 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
435 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
431 
					+ "<td><b>" + "BRAND" + "</b></td>"
 436 
					+ "<td><b>" + "BRAND" + "</b></td>"
432 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
 437 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
Line 442... Line 447...
442 
			for(StockSaleDetail ssDetail  : slowMovingStockSaleListMT){
 447 
			for(StockSaleDetail ssDetail  : slowMovingStockSaleListMT){
443 
				if(i==10){
 448 
				if(i==10){
444 
					break;
 449 
					break;
445 
				}
 450 
				}
446 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
451 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
447 
					+ "<td>" + ssDetail.getBrand() + "</td>"
 452 
						+ "<td>" + ssDetail.getBrand() + "</td>"
448 
					+ "<td>" + ssDetail.getCategory() + "</td>"
 453 
						+ "<td>" + ssDetail.getCategory() + "</td>"
449 
					+ "<td>" + ssDetail.getProductGroup() + "</td>"
 454 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
450 
					+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
 455 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
451 
					+ "<td>" + ssDetail.getStockQuantity() + "</td>"
 456 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
452 
					+ "<td>" + ssDetail.getStockValue() + "</td>"
 457 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
453 
					+ "<td>" + ssDetail.getNodStock() + "</td>"
 458 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
454 
					+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
 459 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
455 
					+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
 460 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
456 
					+ "</tr>");
 461 
						+ "</tr>");
457 
				i++;
 462 
				i++;
458 
			}
 463 
			}
459
464 
 
460 
			sb.append("</table>" );
 465 
			sb.append("</table>" );
461
466 
 
462 
			sb.append("<table border=\"1\" align=\"center\">"
 467 
			sb.append("<table border=\"1\" align=\"center\">"
463 
					+ "<caption><b>" + "NON MOVING ITEMS" + "</b></caption>"
 468 
					+ "<caption><b>" + "NON MOVING ITEMS" + "</b></caption>"
464 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
469 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
465 
					+ "<td><b>" + "BRAND" + "</b></td>"
 470 
					+ "<td><b>" + "BRAND" + "</b></td>"
466 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
 471 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
Line 476... Line 481...
476 
			for(StockSaleDetail ssDetail  : nonMovingStockSaleListMT){
 481 
			for(StockSaleDetail ssDetail  : nonMovingStockSaleListMT){
477 
				if(i==10){
 482 
				if(i==10){
478 
					break;
 483 
					break;
479 
				}
 484 
				}
480 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
485 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
481 
					+ "<td>" + ssDetail.getBrand() + "</td>"
 486 
						+ "<td>" + ssDetail.getBrand() + "</td>"
482 
					+ "<td>" + ssDetail.getCategory() + "</td>"
 487 
						+ "<td>" + ssDetail.getCategory() + "</td>"
483 
					+ "<td>" + ssDetail.getProductGroup() + "</td>"
 488 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
484 
					+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
 489 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
485 
					+ "<td>" + ssDetail.getStockQuantity() + "</td>"
 490 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
486 
					+ "<td>" + ssDetail.getStockValue() + "</td>"
 491 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
487 
					+ "<td>" + ssDetail.getNodStock() + "</td>"
 492 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
488 
					+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
 493 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
489 
					+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
 494 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
490 
					+ "</tr>");
 495 
						+ "</tr>");
491 
				i++;
 496 
				i++;
492 
			}
 497 
			}
493
498 
 
494 
			sb.append("</table>");
 499 
			sb.append("</table>");
495 
			sb.append("</html>");
 500 
			sb.append("</html>");
496
501 
 
497 
			BufferedWriter out = new BufferedWriter(new FileWriter("/tmp/MobileTablets-StockSales-file.htm"));
 502 
			BufferedWriter out = new BufferedWriter(new FileWriter("/tmp/MobileTablets-StockSales-file.htm"));
498 
			out.write(sb.toString());
 503 
			out.write(sb.toString());
499 
			out.flush();
 504 
			out.flush();
500 
			out.close();
 505 
			out.close();
501
506 
 
502
507 
 
503 
			sb = new StringBuffer();
 508 
			sb = new StringBuffer();
504 
			sb.append("<html>" );
 509 
			sb.append("<html>" );
505 
			sb.append("<table border=\"1\" align=\"center\">"
 510 
			sb.append("<table border=\"1\" align=\"center\">"
506 
					+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
 511 
					+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
507 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
512 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
Line 519... Line 524...
519 
			for(StockSaleDetail ssDetail  : itemToReplenishEMT){
 524 
			for(StockSaleDetail ssDetail  : itemToReplenishEMT){
520 
				if(i==10){
 525 
				if(i==10){
521 
					break;
 526 
					break;
522 
				}
 527 
				}
523 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
528 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
524 
					+ "<td>" + ssDetail.getBrand() + "</td>"
 529 
						+ "<td>" + ssDetail.getBrand() + "</td>"
525 
					+ "<td>" + ssDetail.getCategory() + "</td>"
 530 
						+ "<td>" + ssDetail.getCategory() + "</td>"
526 
					+ "<td>" + ssDetail.getProductGroup() + "</td>"
 531 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
527 
					+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
 532 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
528 
					+ "<td>" + ssDetail.getStockQuantity() + "</td>"
 533 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
529 
					+ "<td>" + ssDetail.getStockValue() + "</td>"
 534 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
530 
					+ "<td>" + ssDetail.getNodStock() + "</td>"
 535 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
531 
					+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
 536 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
532 
					+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
 537 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
533 
					+ "</tr>");
 538 
						+ "</tr>");
534 
				i++;
 539 
				i++;
535 
			}
 540 
			}
536
541 
 
537 
			sb.append("</table>" );
 542 
			sb.append("</table>" );
538
543 
 
539 
			sb.append("<table border=\"1\" align=\"center\">"
 544 
			sb.append("<table border=\"1\" align=\"center\">"
540 
					+ "<caption><b>" + "SLOW MOVING ITEMS" + "</b></caption>"
 545 
					+ "<caption><b>" + "SLOW MOVING ITEMS" + "</b></caption>"
541 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
546 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
542 
					+ "<td><b>" + "BRAND" + "</b></td>"
 547 
					+ "<td><b>" + "BRAND" + "</b></td>"
543 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
 548 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
Line 553... Line 558...
553 
			for(StockSaleDetail ssDetail  : slowMovingStockSaleListEMT){
 558 
			for(StockSaleDetail ssDetail  : slowMovingStockSaleListEMT){
554 
				if(i==10){
 559 
				if(i==10){
555 
					break;
 560 
					break;
556 
				}
 561 
				}
557 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
562 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
558 
					+ "<td>" + ssDetail.getBrand() + "</td>"
 563 
						+ "<td>" + ssDetail.getBrand() + "</td>"
559 
					+ "<td>" + ssDetail.getCategory() + "</td>"
 564 
						+ "<td>" + ssDetail.getCategory() + "</td>"
560 
					+ "<td>" + ssDetail.getProductGroup() + "</td>"
 565 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
561 
					+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
 566 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
562 
					+ "<td>" + ssDetail.getStockQuantity() + "</td>"
 567 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
563 
					+ "<td>" + ssDetail.getStockValue() + "</td>"
 568 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
564 
					+ "<td>" + ssDetail.getNodStock() + "</td>"
 569 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
565 
					+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
 570 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
566 
					+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
 571 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
567 
					+ "</tr>");
 572 
						+ "</tr>");
568 
				i++;
 573 
				i++;
569 
			}
 574 
			}
570
575 
 
571 
			sb.append("</table>" );
 576 
			sb.append("</table>" );
572
577 
 
573 
			sb.append("<table border=\"1\" align=\"center\">"
 578 
			sb.append("<table border=\"1\" align=\"center\">"
574 
					+ "<caption><b>" + "NON MOVING ITEMS" + "</b></caption>"
 579 
					+ "<caption><b>" + "NON MOVING ITEMS" + "</b></caption>"
575 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
580 
					+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
576 
					+ "<td><b>" + "BRAND" + "</b></td>"
 581 
					+ "<td><b>" + "BRAND" + "</b></td>"
577 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
 582 
					+ "<td><b>" + "CATEGORY" + "</b></td>"
Line 587... Line 592...
587 
			for(StockSaleDetail ssDetail  : nonMovingStockSaleListEMT){
 592 
			for(StockSaleDetail ssDetail  : nonMovingStockSaleListEMT){
588 
				if(i==10){
 593 
				if(i==10){
589 
					break;
 594 
					break;
590 
				}
 595 
				}
591 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
596 
				sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
592 
					+ "<td>" + ssDetail.getBrand() + "</td>"
 597 
						+ "<td>" + ssDetail.getBrand() + "</td>"
593 
					+ "<td>" + ssDetail.getCategory() + "</td>"
 598 
						+ "<td>" + ssDetail.getCategory() + "</td>"
594 
					+ "<td>" + ssDetail.getProductGroup() + "</td>"
 599 
						+ "<td>" + ssDetail.getProductGroup() + "</td>"
595 
					+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
 600 
						+ "<td>" + ssDetail.getBrand() +" "+ ssDetail.getModelName()+ " "+ssDetail.getModelNumber()+ " "+ssDetail.getColor() + "</td>"
596 
					+ "<td>" + ssDetail.getStockQuantity() + "</td>"
 601 
						+ "<td>" + ssDetail.getStockQuantity() + "</td>"
597 
					+ "<td>" + ssDetail.getStockValue() + "</td>"
 602 
						+ "<td>" + ssDetail.getStockValue() + "</td>"
598 
					+ "<td>" + ssDetail.getNodStock() + "</td>"
 603 
						+ "<td>" + ssDetail.getNodStock() + "</td>"
599 
					+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
 604 
						+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
600 
					+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
 605 
						+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
601 
					+ "</tr>");
 606 
						+ "</tr>");
602 
				i++;
 607 
				i++;
603 
			}
 608 
			}
604
609 
 
605 
			sb.append("</table>");
 610 
			sb.append("</table>");
606 
			sb.append("</html>");
 611 
			sb.append("</html>");
607
612 
 
608 
			out = new BufferedWriter(new FileWriter("/tmp/ExceptMobileTablets-StockSales-file.htm"));
 613 
			out = new BufferedWriter(new FileWriter("/tmp/ExceptMobileTablets-StockSales-file.htm"));
609 
			out.write(sb.toString());
 614 
			out.write(sb.toString());
610 
			out.flush();
 615 
			out.flush();
611 
			out.close();
 616 
			out.close();
612
617 
 
613 
			createXlsFile(movingStockSaleListMT, slowMovingStockSaleListMT, nonMovingStockSaleListMT, true);
 618 
			createXlsFile(movingStockSaleListMT, slowMovingStockSaleListMT, nonMovingStockSaleListMT, true);
614 
			createXlsFile(movingStockSaleListEMT, slowMovingStockSaleListEMT, nonMovingStockSaleListEMT, false);
 619 
			createXlsFile(movingStockSaleListEMT, slowMovingStockSaleListEMT, nonMovingStockSaleListEMT, false);
615 
 
 620 
 
616
621 
 
617 
			GmailUtils mailer = new GmailUtils();
 622 
			GmailUtils mailer = new GmailUtils();
618 
			mailer.sendSSLMessage(mailTo, "Stock Sales Report - Mobile And Tablets ", "", senderAccountMail, senderAccountPswd, tmpDir +"/"+ stockSalesReportMT.getName(), "/tmp/MobileTablets-StockSales-file.htm");
 623 
			mailer.sendSSLMessage(mailTo, "Stock Sales Report - Mobile And Tablets ", "", senderAccountMail, senderAccountPswd, tmpDir +"/"+ stockSalesReportMT.getName(), "/tmp/MobileTablets-StockSales-file.htm");
619 
			mailer.sendSSLMessage(mailTo, "Stock Sales Report - Except Mobile And Tablets ", "", senderAccountMail, senderAccountPswd, tmpDir +"/"+stockSalesReportEMT.getName(), "/tmp/ExceptMobileTablets-StockSales-file.htm");
 624 
			mailer.sendSSLMessage(mailTo, "Stock Sales Report - Except Mobile And Tablets ", "", senderAccountMail, senderAccountPswd, tmpDir +"/"+stockSalesReportEMT.getName(), "/tmp/ExceptMobileTablets-StockSales-file.htm");
620 
		} catch (Exception e) {
 625 
		} catch (Exception e) {
621 
			logger.error("Error in generating/sending Stock Sales Report", e);
 626 
			logger.error("Error in generating/sending Stock Sales Report", e);