| Line 372... |
Line 372... |
| 372 |
public void migrateChallansToInvoices() throws Exception {
|
372 |
public void migrateChallansToInvoices() throws Exception {
|
| 373 |
Map<String, List<Order>> invoiceOrdersMap = orderRepository.selectAllChallans().stream()
|
373 |
Map<String, List<Order>> invoiceOrdersMap = orderRepository.selectAllChallans().stream()
|
| 374 |
.filter(x -> !x.getLineItem().getHsnCode().equals("NOGST"))
|
374 |
.filter(x -> !x.getLineItem().getHsnCode().equals("NOGST"))
|
| 375 |
.collect(Collectors.groupingBy(Order::getInvoiceNumber, Collectors.toList()));
|
375 |
.collect(Collectors.groupingBy(Order::getInvoiceNumber, Collectors.toList()));
|
| 376 |
|
376 |
|
| 377 |
List<List<? extends Serializable>> rows = new ArrayList<>();
|
377 |
List<List<?>> rows = new ArrayList<>();
|
| 378 |
for (String invoice : invoiceOrdersMap.keySet()) {
|
378 |
for (String invoice : invoiceOrdersMap.keySet()) {
|
| 379 |
Order oneOrder = invoiceOrdersMap.get(invoice).get(0);
|
379 |
Order oneOrder = invoiceOrdersMap.get(invoice).get(0);
|
| 380 |
int totalOrders = invoiceOrdersMap.get(invoice).size();
|
380 |
int totalOrders = invoiceOrdersMap.get(invoice).size();
|
| 381 |
LineItem lineItem = oneOrder.getLineItem();
|
381 |
LineItem lineItem = oneOrder.getLineItem();
|
| 382 |
oneOrder.setBillingTimestamp(LocalDateTime.now());
|
382 |
oneOrder.setBillingTimestamp(LocalDateTime.now());
|
| Line 546... |
Line 546... |
| 546 |
s.setCreatedBy(175120474);
|
546 |
s.setCreatedBy(175120474);
|
| 547 |
return s;
|
547 |
return s;
|
| 548 |
}
|
548 |
}
|
| 549 |
|
549 |
|
| 550 |
public void findMismatchesInIndent() throws Exception {
|
550 |
public void findMismatchesInIndent() throws Exception {
|
| 551 |
/*
|
- |
|
| 552 |
* List<SaholicInventorySnapshot> saholicInventorySnapshots =
|
- |
|
| 553 |
* saholicInventorySnapshotRepository.selectAll(); Map<Integer, Integer>
|
- |
|
| 554 |
* itemReservedMap = saholicInventorySnapshots.stream().filter(x ->
|
- |
|
| 555 |
* x.getReserved() > 0)
|
- |
|
| 556 |
* .collect(Collectors.groupingBy(SaholicInventorySnapshot::getItemId,
|
- |
|
| 557 |
* Collectors.summingInt(SaholicInventorySnapshot::getReserved)));
|
- |
|
| 558 |
*/
|
- |
|
| 559 |
List<Order> allInProcessOrders = orderRepository.selectAllOrder(OrderStatus.SUBMITTED_FOR_PROCESSING);
|
551 |
List<Order> allInProcessOrders = orderRepository.selectAllOrder(OrderStatus.SUBMITTED_FOR_PROCESSING);
|
| 560 |
|
552 |
|
| 561 |
/*
|
- |
|
| 562 |
* Map<Integer, Integer> lineItemQtyMap = allInProcessOrders
|
- |
|
| 563 |
* .stream().collect(Collectors.groupingBy(y -> y.getLineItem().getItemId(),
|
- |
|
| 564 |
* Collectors.summingInt(y -> y.getLineItem().getQuantity())));
|
- |
|
| 565 |
*/
|
- |
|
| 566 |
|
- |
|
| 567 |
/*
|
- |
|
| 568 |
* Map<Integer, Order> orderMap =
|
- |
|
| 569 |
* allInProcessOrders.stream().collect(Collectors.toMap(Order::getId, x->x));
|
- |
|
| 570 |
* Map<Integer, List<Order>> itemOrdersMap = allInProcessOrders.stream()
|
- |
|
| 571 |
* .collect(Collectors.groupingBy(o->o.getLineItem().getItemId(),
|
- |
|
| 572 |
* Collectors.toList()));
|
- |
|
| 573 |
*/
|
- |
|
| 574 |
|
- |
|
| 575 |
Map<String, Integer> lineItemWhQtyMap = allInProcessOrders.stream()
|
553 |
Map<String, Integer> lineItemWhQtyMap = allInProcessOrders.stream()
|
| 576 |
.collect(Collectors.groupingBy(y -> y.getLineItem().getItemId() + "-" + y.getFulfilmentWarehouseId(),
|
554 |
.collect(Collectors.groupingBy(y -> y.getLineItem().getItemId() + "-" + y.getFulfilmentWarehouseId(),
|
| 577 |
Collectors.summingInt(y -> y.getLineItem().getQuantity())));
|
555 |
Collectors.summingInt(y -> y.getLineItem().getQuantity())));
|
| 578 |
|
556 |
|
| 579 |
/*
|
- |
|
| 580 |
* itemReservedMap.forEach((itemId, reserved)->{
|
- |
|
| 581 |
* if(lineItemQtyMap.containsKey(itemId)) { int orderedQty =
|
- |
|
| 582 |
* lineItemQtyMap.get(itemId); System.out.printf("%d\t%d\t%d\n",itemId,
|
- |
|
| 583 |
* orderedQty, reserved); } else {
|
- |
|
| 584 |
* saholicInventorySnapshotRepository.removeAllReservations(itemId);
|
- |
|
| 585 |
* System.out.printf("%d\t%d\t%d\n",itemId, 0, reserved); } });
|
- |
|
| 586 |
*/
|
- |
|
| 587 |
|
- |
|
| 588 |
lineItemWhQtyMap.forEach((key, value) -> {
|
557 |
lineItemWhQtyMap.forEach((key, value) -> {
|
| 589 |
|
558 |
|
| 590 |
int itemId = Integer.parseInt(key.split("-")[0]);
|
559 |
int itemId = Integer.parseInt(key.split("-")[0]);
|
| 591 |
int warehouseId = Integer.parseInt(key.split("-")[1]);
|
560 |
int warehouseId = Integer.parseInt(key.split("-")[1]);
|
| 592 |
System.out.printf("%d\t%d\t%d\n", itemId, warehouseId, value);
|
561 |
System.out.printf("%d\t%d\t%d\n", itemId, warehouseId, value);
|
| Line 599... |
Line 568... |
| 599 |
cis.setAvailability(0);
|
568 |
cis.setAvailability(0);
|
| 600 |
saholicInventorySnapshotRepository.persist(cis);
|
569 |
saholicInventorySnapshotRepository.persist(cis);
|
| 601 |
}
|
570 |
}
|
| 602 |
cis.setReserved(value);
|
571 |
cis.setReserved(value);
|
| 603 |
});
|
572 |
});
|
| 604 |
/*
|
- |
|
| 605 |
* List<SaholicReservationInventorySnapshot> reservationInventorySnapshots =
|
- |
|
| 606 |
* saholicReservationInventorySnapshotRepository.selectAll(); Map<Integer,
|
- |
|
| 607 |
* SaholicReservationInventorySnapshot> reservationInventorySnapshotsMap
|
- |
|
| 608 |
* =reservationInventorySnapshots.stream()
|
- |
|
| 609 |
* .collect(Collectors.toMap(x->x.getOrderId(), x->x));
|
- |
|
| 610 |
*
|
- |
|
| 611 |
* List<Integer> orderIds =
|
- |
|
| 612 |
* reservationInventorySnapshots.stream().map(x->x.getOrderId()).collect(
|
- |
|
| 613 |
* Collectors.toList()); List<Order> orders =
|
- |
|
| 614 |
* orderRepository.selectByOrderIds(orderIds);
|
- |
|
| 615 |
* orders.stream().filter(x->Arrays.asList(OrderStatus.PAYMENT_PENDING,
|
- |
|
| 616 |
* OrderStatus.PAYMENT_FAILED). contains(x.getStatus())).forEach(x->{
|
- |
|
| 617 |
* SaholicReservationInventorySnapshot snapshot =
|
- |
|
| 618 |
* reservationInventorySnapshotsMap.get(x.getId()); try {
|
- |
|
| 619 |
* saholicInventorySnapshotRepository.reduceReservationCount(snapshot.getItemId(
|
- |
|
| 620 |
* ), snapshot.getWarehouseId(), snapshot.getReserved(), snapshot.getOrderId());
|
- |
|
| 621 |
* System.out.printf("%d Reduced by %d for Order Id %d\n",snapshot.getItemId(),
|
- |
|
| 622 |
* snapshot.getReserved(), snapshot.getOrderId()); }
|
- |
|
| 623 |
* catch(ProfitMandiBusinessException e) {
|
- |
|
| 624 |
* LOGGER.info("Problem whiile reducing count for Order Id - {}",
|
- |
|
| 625 |
* snapshot.getOrderId()); } });
|
- |
|
| 626 |
*/
|
- |
|
| 627 |
// throw new Exception();
|
- |
|
| 628 |
}
|
573 |
}
|
| 629 |
|
574 |
|
| 630 |
public void fixSchemePayouts() throws Exception {
|
575 |
public void fixSchemePayouts() throws Exception {
|
| 631 |
LOGGER.info("In fix scheme Payouts");
|
576 |
LOGGER.info("In fix scheme Payouts");
|
| 632 |
LocalDateTime startDate = LocalDate.of(2019, 9, 1).atStartOfDay();
|
577 |
LocalDateTime startDate = LocalDate.of(2019, 9, 1).atStartOfDay();
|
| Line 706... |
Line 651... |
| 706 |
}
|
651 |
}
|
| 707 |
|
652 |
|
| 708 |
public void mailDashboardScreenshots() throws Exception {
|
653 |
public void mailDashboardScreenshots() throws Exception {
|
| 709 |
System.setProperty("webdriver.chrome.driver", "/usr/bin/chromedriver");
|
654 |
System.setProperty("webdriver.chrome.driver", "/usr/bin/chromedriver");
|
| 710 |
|
655 |
|
| 711 |
|
- |
|
| 712 |
|
- |
|
| 713 |
|
- |
|
| 714 |
ChromeOptions options = new ChromeOptions();
|
656 |
ChromeOptions options = new ChromeOptions();
|
| 715 |
options.addArguments("--headless");
|
657 |
options.addArguments("--headless");
|
| 716 |
options.addArguments("--no-sandbox");
|
658 |
options.addArguments("--no-sandbox");
|
| 717 |
options.addArguments("start-maximized");
|
659 |
options.addArguments("start-maximized");
|
| 718 |
options.addArguments("disable-infobars");
|
660 |
options.addArguments("disable-infobars");
|
| Line 725... |
Line 667... |
| 725 |
driver.manage().deleteAllCookies();
|
667 |
driver.manage().deleteAllCookies();
|
| 726 |
// Specifiying pageLoadTimeout and Implicit wait
|
668 |
// Specifiying pageLoadTimeout and Implicit wait
|
| 727 |
driver.manage().timeouts().pageLoadTimeout(40, TimeUnit.SECONDS);
|
669 |
driver.manage().timeouts().pageLoadTimeout(40, TimeUnit.SECONDS);
|
| 728 |
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
|
670 |
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
|
| 729 |
|
671 |
|
| 730 |
|
- |
|
| 731 |
Map<String, Set<Integer>> authUserPartnerIdMapping = csService.getAuthUserPartnerIdMapping();
|
672 |
Map<String, Set<Integer>> authUserPartnerIdMapping = csService.getAuthUserPartnerIdMapping();
|
| 732 |
Set<Integer> allPartners = new HashSet<>();
|
673 |
Set<Integer> allPartners = new HashSet<>();
|
| 733 |
Map<Integer, File> partnerSnapshotMap = new HashMap<>();
|
674 |
Map<Integer, File> partnerSnapshotMap = new HashMap<>();
|
| 734 |
authUserPartnerIdMapping.values().stream().forEach(x -> allPartners.addAll(x));
|
675 |
authUserPartnerIdMapping.values().stream().forEach(x -> allPartners.addAll(x));
|
| 735 |
System.out.println(allPartners.size());
|
676 |
System.out.println(allPartners.size());
|
| Line 746... |
Line 687... |
| 746 |
Map<Integer, File> emailSnapshotMap = new HashMap<>();
|
687 |
Map<Integer, File> emailSnapshotMap = new HashMap<>();
|
| 747 |
for (int fofoId : partnerIds) {
|
688 |
for (int fofoId : partnerIds) {
|
| 748 |
body.append(String.format("<br/><img src=\"cid:%d\"/>", fofoId));
|
689 |
body.append(String.format("<br/><img src=\"cid:%d\"/>", fofoId));
|
| 749 |
emailSnapshotMap.put(fofoId, partnerSnapshotMap.get(fofoId));
|
690 |
emailSnapshotMap.put(fofoId, partnerSnapshotMap.get(fofoId));
|
| 750 |
}
|
691 |
}
|
| 751 |
Utils.sendEmbeddedHtmlMail(mailSender,
|
692 |
Utils.sendEmbeddedHtmlMail(mailSender, new String[] { email }, new String[] {},
|
| 752 |
new String[] { email },
|
- |
|
| 753 |
new String[] {},
|
- |
|
| 754 |
String.format("Franchise Screenshots - %s", FormattingUtils.formatDate(LocalDateTime.now())),
|
693 |
String.format("Franchise Screenshots - %s", FormattingUtils.formatDate(LocalDateTime.now())),
|
| 755 |
body.toString(), emailSnapshotMap );
|
694 |
body.toString(), emailSnapshotMap);
|
| 756 |
}
|
695 |
}
|
| 757 |
driver.quit();
|
696 |
driver.quit();
|
| 758 |
}
|
697 |
}
|
| 759 |
}
|
698 |
}
|
| 760 |
|
699 |
|