Subversion Repositories SmartDukaan

Rev

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

Rev 33452 Rev 33464
Line 267... Line 267...
267 
 
 267 
 
268 
    private static final String[] STOCK_AGEING_MAIL_LIST = new String[]{"uday.singh@smartudkaan.com", "mohinder.mutreja@smartdukaan.com", "ankit.bhatia@smartdukaan.com", "tarun.verma@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "manish.gupta@smartdukaan.com"};
 268 
    private static final String[] STOCK_AGEING_MAIL_LIST = new String[]{"uday.singh@smartudkaan.com", "mohinder.mutreja@smartdukaan.com", "ankit.bhatia@smartdukaan.com", "tarun.verma@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "manish.gupta@smartdukaan.com"};
269 
 
 269 
 
270 
    private static final String[] ITEMWISE_PENDING_INDENT_MAIL_LIST = new String[]{"kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com", "uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "niranjan.kala@smartdukaan.com"};
 270 
    private static final String[] ITEMWISE_PENDING_INDENT_MAIL_LIST = new String[]{"kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com", "uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "niranjan.kala@smartdukaan.com"};
271 
 
 271 
 
272 
    private static final String[] INDENT_TERTIARY_MAIL_LIST = new String[]{"uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com"};
 272 
    private static final String[] INDENT_TERTIARY_MAIL_LIST = new String[]{"uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com", "vinay.p@smartdukaan.com"};
273 
 
 273 
 
274 
    private static final String[] EMPLOYEE_ATTENDANCE_MAIL_LIST = new String[]{"sm@smartdukaan.com", "sm@smartdukaan.com"};
 274 
    private static final String[] EMPLOYEE_ATTENDANCE_MAIL_LIST = new String[]{"sm@smartdukaan.com", "sm@smartdukaan.com"};
275 
 
 275 
 
276 
    private List<OrderStatus> orderStatusList = Arrays.asList(OrderStatus.SUBMITTED_FOR_PROCESSING);
 276 
    private List<OrderStatus> orderStatusList = Arrays.asList(OrderStatus.SUBMITTED_FOR_PROCESSING);
277 
 
 277 
 
Line 1028... Line 1028...
1028 
 
 1028 
 
1029 
    @Autowired
 1029 
    @Autowired
1030 
    PriceCircularService priceCircularService;
 1030 
    PriceCircularService priceCircularService;
1031 
 
 1031 
 
1032 
    public void test() throws Exception {
 1032 
    public void test() throws Exception {
- 
 
 1033 
        this.findTodayPocoBillingItems();
1033 
        LocalDate startDate = LocalDate.of(2024, Month.MAY, 1);
 1034 
//        LocalDate startDate = LocalDate.of(2024, Month.MAY, 1);
1034 
        List<PriceDropIMEI> priceDropIMEIList = priceDropIMEIRepository.selectAllByCreditedBetween(startDate.atStartOfDay(), startDate.plusMonths(1).atTime(Utils.MAX_TIME));
 1035 
//        List<PriceDropIMEI> priceDropIMEIList = priceDropIMEIRepository.selectAllByCreditedBetween(startDate.atStartOfDay(), startDate.plusMonths(1).atTime(Utils.MAX_TIME));
1035 
        Set<Integer> inventoryItemIds = priceDropIMEIList.stream().map(x -> x.getInventoryItemId()).collect(Collectors.toSet());
 1036 
//        Set<Integer> inventoryItemIds = priceDropIMEIList.stream().map(x -> x.getInventoryItemId()).collect(Collectors.toSet());
1036 
        List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
 1037 
//        List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
1037 
        List<String> headers = Arrays.asList("FofoId", "Serial Number", "Original DP", "DP(Inc PDs)", "PDs credited", "Fixed amount", "Discount", "Percentage Amount", "Margins Calc.", "Margins credited", "SoldOut");
 1038 
//        List<String> headers = Arrays.asList("FofoId", "Serial Number", "Original DP", "DP(Inc PDs)", "PDs credited", "Fixed amount", "Discount", "Percentage Amount", "Margins Calc.", "Margins credited", "SoldOut");
1038 
 
 1039 
//
1039 
        List<List<?>> rows = new ArrayList<>();
 1040 
//        List<List<?>> rows = new ArrayList<>();
1040 
        for (InventoryItem inventoryItem : inventoryItems) {
 1041 
//        for (InventoryItem inventoryItem : inventoryItems) {
1041 
            InventoryPayoutModel ipm = priceCircularService.getPayouts(inventoryItem);
 1042 
//            InventoryPayoutModel ipm = priceCircularService.getPayouts(inventoryItem);
1042 
            ipm.getActualRolloutAmount();
 1043 
//            ipm.getActualRolloutAmount();
1043 
            rows.add(Arrays.asList(inventoryItem.getFofoId(), inventoryItem.getSerialNumber(), ipm.getDp() + ipm.getPriceDropAmount(), ipm.getDp(), 0d,//PDs credited
 1044 
//                        rows.add(Arrays.asList(inventoryItem.getFofoId(), inventoryItem.getSerialNumber(), ipm.getDp() + ipm.getPriceDropAmount(), ipm.getDp(), 0d,//PDs credited
1044 
                    ipm.getFixedAmount(), ipm.getDiscountAmount(), ipm.getPercentageAmount(), ipm.getActualRolloutAmount(), ipm.getPaidAmount(), inventoryItem.getLastScanType().equals(ScanType.SALE)));
 1045 
//                    ipm.getFixedAmount(), ipm.getDiscountAmount(), ipm.getPercentageAmount(), ipm.getActualRolloutAmount(), ipm.getPaidAmount(), inventoryItem.getLastScanType().equals(ScanType.SALE)));
1045 
        }
 1046 
//        }
1046 
        ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);
 1047 
//        ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);
1047 
        FileOutputStream fos = new FileOutputStream(new File("/Users/amit/data.csv"));
 1048 
//        FileOutputStream fos = new FileOutputStream(new File("/Users/amit/data.csv"));
1048 
        baos.writeTo(fos);
 1049 
//        baos.writeTo(fos);
1049 
 
 1050 
 
1050 
 
 1051 
 
1051 
    }
 1052 
    }
1052 
 
 1053 
 
1053 
    public void test4() throws Exception {
 1054 
    public void test4() throws Exception {
Line 4716... Line 4717...
4716 
 
 4717 
 
4717 
        String[] email = sendTo.toArray(new String[sendTo.size()]);
 4718 
        String[] email = sendTo.toArray(new String[sendTo.size()]);
4718 
        this.sendMailOfHtmlFormat(mailSender, email, sb.toString(), null, subject);
 4719 
        this.sendMailOfHtmlFormat(mailSender, email, sb.toString(), null, subject);
4719 
 
 4720 
 
4720 
    }
 4721 
    }
- 
 
 4722 
 
- 
 
 4723 
    public void findTodayPocoBillingItems() throws MessagingException, ProfitMandiBusinessException, IOException {
- 
 
 4724 
        LocalDateTime endDate = LocalDate.now().atStartOfDay().plusDays(1);
- 
 
 4725 
        LocalDateTime startDate = LocalDate.now().atStartOfDay().minusDays(1);
- 
 
 4726 
 
- 
 
 4727 
        List<LiveDemoOrderLineItemModel> pocoBillingOrderLineItemModels = orderRepository.findTodayPocoBillingItems(startDate, endDate);
- 
 
 4728 
        LOGGER.info("pocoBillingOrderLineItemModels {}", pocoBillingOrderLineItemModels);
- 
 
 4729 
        String subject = "Poco Billing";
- 
 
 4730 
        StringBuilder sb = new StringBuilder();
- 
 
 4731 
 
- 
 
 4732 
        sb.append("<html><body><p>Hi,\n");
- 
 
 4733 
        sb.append("<p>Please check poco billed order :</p>\n" + " <table style='border:1px solid black ;padding: 5px; border-collapse: collapse;'>");
- 
 
 4734 
 
- 
 
 4735 
        sb.append("<th style='border:1px solid black;padding: 5px'>Brand</th>\n");
- 
 
 4736 
        sb.append("<th style='border:1px solid black;padding: 5px'>Model Number</th>\n");
- 
 
 4737 
        sb.append("<th style='border:1px solid black;padding: 5px'>Model Name</th>\n");
- 
 
 4738 
        sb.append("<th style='border:1px solid black;padding: 5px'>Serial Number</th>\n");
- 
 
 4739 
        sb.append("<th style='border:1px solid black;padding: 5px'>Retailer State</th>\n");
- 
 
 4740 
        sb.append("<th style='border:1px solid black;padding: 5px'>Billing Date</th>\n");
- 
 
 4741 
        sb.append("</tr>\n");
- 
 
 4742 
        for (LiveDemoOrderLineItemModel pocoModel : pocoBillingOrderLineItemModels) {
- 
 
 4743 
            sb.append("<tr>");
- 
 
 4744 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getBrand() + "</td>\n");
- 
 
 4745 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getModelNumber() + "</td>\n");
- 
 
 4746 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getModelName() + "</td>\n");
- 
 
 4747 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getSerialNumber() + "</td>\n");
- 
 
 4748 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getState() + "</td>\n");
- 
 
 4749 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + pocoModel.getFormattedBillingDate() + "</td>\n");
- 
 
 4750 
 
- 
 
 4751 
            sb.append("</tr>\n");
- 
 
 4752 
 
- 
 
 4753 
            }
- 
 
 4754 
       List<String> sendTo = Arrays.asList("uday.singh@smartdukaan.com", "kuldeep.kumar@smartdukaan.com", "nishant.ohri@smartdukaan.com");
- 
 
 4755 
 
- 
 
 4756 
        String[] email = sendTo.toArray(new String[sendTo.size()]);
- 
 
 4757 
        this.sendMailOfHtmlFormat(mailSender, email, sb.toString(), null, subject);
- 
 
 4758 
 
- 
 
 4759 
    }
4721 
 
 4760 
 
4722 
 
 4761 
 
4723 
    public void monthlyTargetForInternalTeam() throws MessagingException, ProfitMandiBusinessException, IOException {
 4762 
    public void monthlyTargetForInternalTeam() throws MessagingException, ProfitMandiBusinessException, IOException {
4724 
 
 4763 
 
4725 
        LocalDateTime curDate = LocalDateTime.now();
 4764 
        LocalDateTime curDate = LocalDateTime.now();