| Line 366... |
Line 366... |
| 366 |
}
|
366 |
}
|
| 367 |
if(nonMovingStockSaleListEMT!=null && nonMovingStockSaleListEMT.size()>2){
|
367 |
if(nonMovingStockSaleListEMT!=null && nonMovingStockSaleListEMT.size()>2){
|
| 368 |
Collections.sort(nonMovingStockSaleListEMT, new SnmMovingStockSaleDetailComparator());
|
368 |
Collections.sort(nonMovingStockSaleListEMT, new SnmMovingStockSaleDetailComparator());
|
| 369 |
}
|
369 |
}
|
| 370 |
|
370 |
|
| - |
|
371 |
|
| - |
|
372 |
List<StockSaleDetail> itemToReplenishMT = new ArrayList<StockSaleDetail>();
|
| - |
|
373 |
List<StockSaleDetail> itemToReplenishEMT = new ArrayList<StockSaleDetail>();
|
| - |
|
374 |
for(StockSaleDetail ssDetail : movingStockSaleListMT){
|
| - |
|
375 |
if(ssDetail.getNodStock() <= 5){
|
| - |
|
376 |
itemToReplenishMT.add(ssDetail);
|
| - |
|
377 |
}
|
| - |
|
378 |
}
|
| - |
|
379 |
for(StockSaleDetail ssDetail : movingStockSaleListEMT){
|
| - |
|
380 |
if(ssDetail.getNodStock() <= 5){
|
| - |
|
381 |
itemToReplenishEMT.add(ssDetail);
|
| - |
|
382 |
}
|
| - |
|
383 |
}
|
| - |
|
384 |
|
| - |
|
385 |
if(itemToReplenishMT!=null && itemToReplenishMT.size()>2){
|
| - |
|
386 |
Collections.sort(itemToReplenishMT, new MovingStockSaleDetailComparator());
|
| - |
|
387 |
}
|
| - |
|
388 |
if(itemToReplenishEMT!=null && itemToReplenishEMT.size()>2){
|
| - |
|
389 |
Collections.sort(itemToReplenishEMT, new MovingStockSaleDetailComparator());
|
| - |
|
390 |
}
|
| - |
|
391 |
|
| 371 |
StringBuffer sb = new StringBuffer();
|
392 |
StringBuffer sb = new StringBuffer();
|
| 372 |
sb.append("<html>" );
|
393 |
sb.append("<html>" );
|
| 373 |
sb.append("<table border=\"1\" align=\"center\">"
|
394 |
sb.append("<table border=\"1\" align=\"center\">"
|
| 374 |
+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
|
395 |
+ "<caption><b>" + "ITEMS TO REPLENISH" + "</b></caption>"
|
| 375 |
+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
|
396 |
+ "<tr>" + "<td><b>" + "ITEM-ID" + "</b></td>"
|
| Line 380... |
Line 401... |
| 380 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
401 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
| 381 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
402 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
| 382 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
403 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
| 383 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
404 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
| 384 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
405 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
| 385 |
+ "<td><b>" + "SALES-HISTORY-WS" + "</b></td>"
|
- |
|
| 386 |
+ "<td><b>" + "AVG-SALE-WS" + "</b></td>"
|
- |
|
| 387 |
+ "<td><b>" + "SALES-HISTORY-EBAY" + "</b></td>"
|
- |
|
| 388 |
+ "<td><b>" + "AVG-SALES-EBAY" + "</b></td>"
|
- |
|
| 389 |
+ "<td><b>" + "SALES-HISTORY-SD" + "</b></td>"
|
- |
|
| 390 |
+ "<td><b>" + "AVG-SALES-SD" + "</b></td>"
|
- |
|
| 391 |
+ "<td><b>" + "SALES-HISTORY-FK" + "</b></td>"
|
- |
|
| 392 |
+ "<td><b>" + "AVG-SALES-FK" + "</b></td>"
|
- |
|
| 393 |
+ "<td><b>" + "SALES-HISTORY-MFN" + "</b></td>"
|
- |
|
| 394 |
+ "<td><b>" + "AVG-SALES-MFN" + "</b></td>"
|
- |
|
| 395 |
+ "</tr>");
|
406 |
+ "</tr>");
|
| 396 |
int i=1;
|
407 |
int i=1;
|
| 397 |
for(StockSaleDetail ssDetail : movingStockSaleListMT){
|
408 |
for(StockSaleDetail ssDetail : itemToReplenishMT){
|
| 398 |
if(i==10){
|
409 |
if(i==10){
|
| 399 |
break;
|
410 |
break;
|
| 400 |
}
|
411 |
}
|
| 401 |
sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
|
412 |
sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
|
| 402 |
+ "<td>" + ssDetail.getBrand() + "</td>"
|
413 |
+ "<td>" + ssDetail.getBrand() + "</td>"
|
| Line 406... |
Line 417... |
| 406 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
417 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
| 407 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
418 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
| 408 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
419 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
| 409 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
420 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
| 410 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
421 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
| 411 |
+ "<td>" + ssDetail.getSalesHistoryWS() + "</td>"
|
- |
|
| 412 |
+ "<td>" + ssDetail.getAvgSalesWS() + "</td>"
|
- |
|
| 413 |
+ "<td>" + ssDetail.getSalesHistoryEbay() + "</td>"
|
- |
|
| 414 |
+ "<td>" + ssDetail.getAvgSalesEbay() + "</td>"
|
- |
|
| 415 |
+ "<td>" + ssDetail.getSalesHistorySD() + "</td>"
|
- |
|
| 416 |
+ "<td>" + ssDetail.getAvgSalesSD() + "</td>"
|
- |
|
| 417 |
+ "<td>" + ssDetail.getSalesHistoryFK() + "</td>"
|
- |
|
| 418 |
+ "<td>" + ssDetail.getAvgSalesFK() + "</td>"
|
- |
|
| 419 |
+ "<td>" + ssDetail.getSalesHistoryMFN() + "</td>"
|
- |
|
| 420 |
+ "<td>" + ssDetail.getAvgSalesMFN() + "</td>"
|
- |
|
| 421 |
+ "</tr>");
|
422 |
+ "</tr>");
|
| 422 |
i++;
|
423 |
i++;
|
| 423 |
}
|
424 |
}
|
| 424 |
|
425 |
|
| 425 |
sb.append("</table>" );
|
426 |
sb.append("</table>" );
|
| Line 434... |
Line 435... |
| 434 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
435 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
| 435 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
436 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
| 436 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
437 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
| 437 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
438 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
| 438 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
439 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
| 439 |
+ "<td><b>" + "SALES-HISTORY-WS" + "</b></td>"
|
- |
|
| 440 |
+ "<td><b>" + "AVG-SALE-WS" + "</b></td>"
|
- |
|
| 441 |
+ "<td><b>" + "SALES-HISTORY-EBAY" + "</b></td>"
|
- |
|
| 442 |
+ "<td><b>" + "AVG-SALES-EBAY" + "</b></td>"
|
- |
|
| 443 |
+ "<td><b>" + "SALES-HISTORY-SD" + "</b></td>"
|
- |
|
| 444 |
+ "<td><b>" + "AVG-SALES-SD" + "</b></td>"
|
- |
|
| 445 |
+ "<td><b>" + "SALES-HISTORY-FK" + "</b></td>"
|
- |
|
| 446 |
+ "<td><b>" + "AVG-SALES-FK" + "</b></td>"
|
- |
|
| 447 |
+ "<td><b>" + "SALES-HISTORY-MFN" + "</b></td>"
|
- |
|
| 448 |
+ "<td><b>" + "AVG-SALES-MFN" + "</b></td>"
|
- |
|
| 449 |
+ "</tr>");
|
440 |
+ "</tr>");
|
| 450 |
i=1;
|
441 |
i=1;
|
| 451 |
for(StockSaleDetail ssDetail : slowMovingStockSaleListMT){
|
442 |
for(StockSaleDetail ssDetail : slowMovingStockSaleListMT){
|
| 452 |
if(i==10){
|
443 |
if(i==10){
|
| 453 |
break;
|
444 |
break;
|
| Line 460... |
Line 451... |
| 460 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
451 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
| 461 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
452 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
| 462 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
453 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
| 463 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
454 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
| 464 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
455 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
| 465 |
+ "<td>" + ssDetail.getSalesHistoryWS() + "</td>"
|
- |
|
| 466 |
+ "<td>" + ssDetail.getAvgSalesWS() + "</td>"
|
- |
|
| 467 |
+ "<td>" + ssDetail.getSalesHistoryEbay() + "</td>"
|
- |
|
| 468 |
+ "<td>" + ssDetail.getAvgSalesEbay() + "</td>"
|
- |
|
| 469 |
+ "<td>" + ssDetail.getSalesHistorySD() + "</td>"
|
- |
|
| 470 |
+ "<td>" + ssDetail.getAvgSalesSD() + "</td>"
|
- |
|
| 471 |
+ "<td>" + ssDetail.getSalesHistoryFK() + "</td>"
|
- |
|
| 472 |
+ "<td>" + ssDetail.getAvgSalesFK() + "</td>"
|
- |
|
| 473 |
+ "<td>" + ssDetail.getSalesHistoryMFN() + "</td>"
|
- |
|
| 474 |
+ "<td>" + ssDetail.getAvgSalesMFN() + "</td>"
|
- |
|
| 475 |
+ "</tr>");
|
456 |
+ "</tr>");
|
| 476 |
i++;
|
457 |
i++;
|
| 477 |
}
|
458 |
}
|
| 478 |
|
459 |
|
| 479 |
sb.append("</table>" );
|
460 |
sb.append("</table>" );
|
| Line 488... |
Line 469... |
| 488 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
469 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
| 489 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
470 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
| 490 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
471 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
| 491 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
472 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
| 492 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
473 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
| 493 |
+ "<td><b>" + "SALES-HISTORY-WS" + "</b></td>"
|
- |
|
| 494 |
+ "<td><b>" + "AVG-SALE-WS" + "</b></td>"
|
- |
|
| 495 |
+ "<td><b>" + "SALES-HISTORY-EBAY" + "</b></td>"
|
- |
|
| 496 |
+ "<td><b>" + "AVG-SALES-EBAY" + "</b></td>"
|
- |
|
| 497 |
+ "<td><b>" + "SALES-HISTORY-SD" + "</b></td>"
|
- |
|
| 498 |
+ "<td><b>" + "AVG-SALES-SD" + "</b></td>"
|
- |
|
| 499 |
+ "<td><b>" + "SALES-HISTORY-FK" + "</b></td>"
|
- |
|
| 500 |
+ "<td><b>" + "AVG-SALES-FK" + "</b></td>"
|
- |
|
| 501 |
+ "<td><b>" + "SALES-HISTORY-MFN" + "</b></td>"
|
- |
|
| 502 |
+ "<td><b>" + "AVG-SALES-MFN" + "</b></td>"
|
- |
|
| 503 |
+ "</tr>");
|
474 |
+ "</tr>");
|
| 504 |
i=1;
|
475 |
i=1;
|
| 505 |
for(StockSaleDetail ssDetail : nonMovingStockSaleListMT){
|
476 |
for(StockSaleDetail ssDetail : nonMovingStockSaleListMT){
|
| 506 |
if(i==10){
|
477 |
if(i==10){
|
| 507 |
break;
|
478 |
break;
|
| Line 514... |
Line 485... |
| 514 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
485 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
| 515 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
486 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
| 516 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
487 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
| 517 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
488 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
| 518 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
489 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
| 519 |
+ "<td>" + ssDetail.getSalesHistoryWS() + "</td>"
|
- |
|
| 520 |
+ "<td>" + ssDetail.getAvgSalesWS() + "</td>"
|
- |
|
| 521 |
+ "<td>" + ssDetail.getSalesHistoryEbay() + "</td>"
|
- |
|
| 522 |
+ "<td>" + ssDetail.getAvgSalesEbay() + "</td>"
|
- |
|
| 523 |
+ "<td>" + ssDetail.getSalesHistorySD() + "</td>"
|
- |
|
| 524 |
+ "<td>" + ssDetail.getAvgSalesSD() + "</td>"
|
- |
|
| 525 |
+ "<td>" + ssDetail.getSalesHistoryFK() + "</td>"
|
- |
|
| 526 |
+ "<td>" + ssDetail.getAvgSalesFK() + "</td>"
|
- |
|
| 527 |
+ "<td>" + ssDetail.getSalesHistoryMFN() + "</td>"
|
- |
|
| 528 |
+ "<td>" + ssDetail.getAvgSalesMFN() + "</td>"
|
- |
|
| 529 |
+ "</tr>");
|
490 |
+ "</tr>");
|
| 530 |
i++;
|
491 |
i++;
|
| 531 |
}
|
492 |
}
|
| 532 |
|
493 |
|
| 533 |
sb.append("</table>");
|
494 |
sb.append("</table>");
|
| Line 551... |
Line 512... |
| 551 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
512 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
| 552 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
513 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
| 553 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
514 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
| 554 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
515 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
| 555 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
516 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
| 556 |
+ "<td><b>" + "SALES-HISTORY-WS" + "</b></td>"
|
- |
|
| 557 |
+ "<td><b>" + "AVG-SALE-WS" + "</b></td>"
|
- |
|
| 558 |
+ "<td><b>" + "SALES-HISTORY-EBAY" + "</b></td>"
|
- |
|
| 559 |
+ "<td><b>" + "AVG-SALES-EBAY" + "</b></td>"
|
- |
|
| 560 |
+ "<td><b>" + "SALES-HISTORY-SD" + "</b></td>"
|
- |
|
| 561 |
+ "<td><b>" + "AVG-SALES-SD" + "</b></td>"
|
- |
|
| 562 |
+ "<td><b>" + "SALES-HISTORY-FK" + "</b></td>"
|
- |
|
| 563 |
+ "<td><b>" + "AVG-SALES-FK" + "</b></td>"
|
- |
|
| 564 |
+ "<td><b>" + "SALES-HISTORY-MFN" + "</b></td>"
|
- |
|
| 565 |
+ "<td><b>" + "AVG-SALES-MFN" + "</b></td>"
|
- |
|
| 566 |
+ "</tr>");
|
517 |
+ "</tr>");
|
| 567 |
i=1;
|
518 |
i=1;
|
| 568 |
for(StockSaleDetail ssDetail : movingStockSaleListEMT){
|
519 |
for(StockSaleDetail ssDetail : itemToReplenishEMT){
|
| 569 |
if(i==10){
|
520 |
if(i==10){
|
| 570 |
break;
|
521 |
break;
|
| 571 |
}
|
522 |
}
|
| 572 |
sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
|
523 |
sb.append("<tr>" + "<td><b>" + ssDetail.getItemId() + "</b></td>"
|
| 573 |
+ "<td>" + ssDetail.getBrand() + "</td>"
|
524 |
+ "<td>" + ssDetail.getBrand() + "</td>"
|
| Line 577... |
Line 528... |
| 577 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
528 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
| 578 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
529 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
| 579 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
530 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
| 580 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
531 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
| 581 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
532 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
| 582 |
+ "<td>" + ssDetail.getSalesHistoryWS() + "</td>"
|
- |
|
| 583 |
+ "<td>" + ssDetail.getAvgSalesWS() + "</td>"
|
- |
|
| 584 |
+ "<td>" + ssDetail.getSalesHistoryEbay() + "</td>"
|
- |
|
| 585 |
+ "<td>" + ssDetail.getAvgSalesEbay() + "</td>"
|
- |
|
| 586 |
+ "<td>" + ssDetail.getSalesHistorySD() + "</td>"
|
- |
|
| 587 |
+ "<td>" + ssDetail.getAvgSalesSD() + "</td>"
|
- |
|
| 588 |
+ "<td>" + ssDetail.getSalesHistoryFK() + "</td>"
|
- |
|
| 589 |
+ "<td>" + ssDetail.getAvgSalesFK() + "</td>"
|
- |
|
| 590 |
+ "<td>" + ssDetail.getSalesHistoryMFN() + "</td>"
|
- |
|
| 591 |
+ "<td>" + ssDetail.getAvgSalesMFN() + "</td>"
|
- |
|
| 592 |
+ "</tr>");
|
533 |
+ "</tr>");
|
| 593 |
i++;
|
534 |
i++;
|
| 594 |
}
|
535 |
}
|
| 595 |
|
536 |
|
| 596 |
sb.append("</table>" );
|
537 |
sb.append("</table>" );
|
| Line 605... |
Line 546... |
| 605 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
546 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
| 606 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
547 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
| 607 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
548 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
| 608 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
549 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
| 609 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
550 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
| 610 |
+ "<td><b>" + "SALES-HISTORY-WS" + "</b></td>"
|
- |
|
| 611 |
+ "<td><b>" + "AVG-SALE-WS" + "</b></td>"
|
- |
|
| 612 |
+ "<td><b>" + "SALES-HISTORY-EBAY" + "</b></td>"
|
- |
|
| 613 |
+ "<td><b>" + "AVG-SALES-EBAY" + "</b></td>"
|
- |
|
| 614 |
+ "<td><b>" + "SALES-HISTORY-SD" + "</b></td>"
|
- |
|
| 615 |
+ "<td><b>" + "AVG-SALES-SD" + "</b></td>"
|
- |
|
| 616 |
+ "<td><b>" + "SALES-HISTORY-FK" + "</b></td>"
|
- |
|
| 617 |
+ "<td><b>" + "AVG-SALES-FK" + "</b></td>"
|
- |
|
| 618 |
+ "<td><b>" + "SALES-HISTORY-MFN" + "</b></td>"
|
- |
|
| 619 |
+ "<td><b>" + "AVG-SALES-MFN" + "</b></td>"
|
- |
|
| 620 |
+ "</tr>");
|
551 |
+ "</tr>");
|
| 621 |
i=1;
|
552 |
i=1;
|
| 622 |
for(StockSaleDetail ssDetail : slowMovingStockSaleListEMT){
|
553 |
for(StockSaleDetail ssDetail : slowMovingStockSaleListEMT){
|
| 623 |
if(i==10){
|
554 |
if(i==10){
|
| 624 |
break;
|
555 |
break;
|
| Line 631... |
Line 562... |
| 631 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
562 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
| 632 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
563 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
| 633 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
564 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
| 634 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
565 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
| 635 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
566 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
| 636 |
+ "<td>" + ssDetail.getSalesHistoryWS() + "</td>"
|
- |
|
| 637 |
+ "<td>" + ssDetail.getAvgSalesWS() + "</td>"
|
- |
|
| 638 |
+ "<td>" + ssDetail.getSalesHistoryEbay() + "</td>"
|
- |
|
| 639 |
+ "<td>" + ssDetail.getAvgSalesEbay() + "</td>"
|
- |
|
| 640 |
+ "<td>" + ssDetail.getSalesHistorySD() + "</td>"
|
- |
|
| 641 |
+ "<td>" + ssDetail.getAvgSalesSD() + "</td>"
|
- |
|
| 642 |
+ "<td>" + ssDetail.getSalesHistoryFK() + "</td>"
|
- |
|
| 643 |
+ "<td>" + ssDetail.getAvgSalesFK() + "</td>"
|
- |
|
| 644 |
+ "<td>" + ssDetail.getSalesHistoryMFN() + "</td>"
|
- |
|
| 645 |
+ "<td>" + ssDetail.getAvgSalesMFN() + "</td>"
|
- |
|
| 646 |
+ "</tr>");
|
567 |
+ "</tr>");
|
| 647 |
i++;
|
568 |
i++;
|
| 648 |
}
|
569 |
}
|
| 649 |
|
570 |
|
| 650 |
sb.append("</table>" );
|
571 |
sb.append("</table>" );
|
| Line 659... |
Line 580... |
| 659 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
580 |
+ "<td><b>" + "STOCK-QTY" + "</b></td>"
|
| 660 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
581 |
+ "<td><b>" + "STOCK-VALUE" + "</b></td>"
|
| 661 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
582 |
+ "<td><b>" + "NOD-STOCK" + "</b></td>"
|
| 662 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
583 |
+ "<td><b>" + "SALES-HISTORY-ALL" + "</b></td>"
|
| 663 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
584 |
+ "<td><b>" + "AVG-SALE-ALL" + "</b></td>"
|
| 664 |
+ "<td><b>" + "SALES-HISTORY-WS" + "</b></td>"
|
- |
|
| 665 |
+ "<td><b>" + "AVG-SALE-WS" + "</b></td>"
|
- |
|
| 666 |
+ "<td><b>" + "SALES-HISTORY-EBAY" + "</b></td>"
|
- |
|
| 667 |
+ "<td><b>" + "AVG-SALES-EBAY" + "</b></td>"
|
- |
|
| 668 |
+ "<td><b>" + "SALES-HISTORY-SD" + "</b></td>"
|
- |
|
| 669 |
+ "<td><b>" + "AVG-SALES-SD" + "</b></td>"
|
- |
|
| 670 |
+ "<td><b>" + "SALES-HISTORY-FK" + "</b></td>"
|
- |
|
| 671 |
+ "<td><b>" + "AVG-SALES-FK" + "</b></td>"
|
- |
|
| 672 |
+ "<td><b>" + "SALES-HISTORY-MFN" + "</b></td>"
|
- |
|
| 673 |
+ "<td><b>" + "AVG-SALES-MFN" + "</b></td>"
|
- |
|
| 674 |
+ "</tr>");
|
585 |
+ "</tr>");
|
| 675 |
i=1;
|
586 |
i=1;
|
| 676 |
for(StockSaleDetail ssDetail : nonMovingStockSaleListEMT){
|
587 |
for(StockSaleDetail ssDetail : nonMovingStockSaleListEMT){
|
| 677 |
if(i==10){
|
588 |
if(i==10){
|
| 678 |
break;
|
589 |
break;
|
| Line 685... |
Line 596... |
| 685 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
596 |
+ "<td>" + ssDetail.getStockQuantity() + "</td>"
|
| 686 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
597 |
+ "<td>" + ssDetail.getStockValue() + "</td>"
|
| 687 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
598 |
+ "<td>" + ssDetail.getNodStock() + "</td>"
|
| 688 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
599 |
+ "<td>" + ssDetail.getSalesHistoryAll() + "</td>"
|
| 689 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
600 |
+ "<td>" + ssDetail.getAvgSalesAll() + "</td>"
|
| 690 |
+ "<td>" + ssDetail.getSalesHistoryWS() + "</td>"
|
- |
|
| 691 |
+ "<td>" + ssDetail.getAvgSalesWS() + "</td>"
|
- |
|
| 692 |
+ "<td>" + ssDetail.getSalesHistoryEbay() + "</td>"
|
- |
|
| 693 |
+ "<td>" + ssDetail.getAvgSalesEbay() + "</td>"
|
- |
|
| 694 |
+ "<td>" + ssDetail.getSalesHistorySD() + "</td>"
|
- |
|
| 695 |
+ "<td>" + ssDetail.getAvgSalesSD() + "</td>"
|
- |
|
| 696 |
+ "<td>" + ssDetail.getSalesHistoryFK() + "</td>"
|
- |
|
| 697 |
+ "<td>" + ssDetail.getAvgSalesFK() + "</td>"
|
- |
|
| 698 |
+ "<td>" + ssDetail.getSalesHistoryMFN() + "</td>"
|
- |
|
| 699 |
+ "<td>" + ssDetail.getAvgSalesMFN() + "</td>"
|
- |
|
| 700 |
+ "</tr>");
|
601 |
+ "</tr>");
|
| 701 |
i++;
|
602 |
i++;
|
| 702 |
}
|
603 |
}
|
| 703 |
|
604 |
|
| 704 |
sb.append("</table>");
|
605 |
sb.append("</table>");
|