Subversion Repositories SmartDukaan

Rev

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

Rev 25785 Rev 25837
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