Subversion Repositories SmartDukaan

Rev

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

Rev 33434 Rev 33444
Line 4647... Line 4647...
4647 
 
 4647 
 
4648 
        }
 4648 
        }
4649 
 
 4649 
 
4650 
    }
 4650 
    }
4651 
 
 4651 
 
- 
 
 4652 
 
- 
 
 4653 
    public void findAllLiveDemoBrandItemsByBillingDate() throws MessagingException, ProfitMandiBusinessException, IOException {
- 
 
 4654 
        LocalDateTime endDate = LocalDate.now().atStartOfDay().minusDays(8);
- 
 
 4655 
 
- 
 
 4656 
        List<LiveDemoOrderLineItemModel> liveDemoOrderLineItemModels = orderRepository.findAllLiveDemoBrandItemsByBillingDate(endDate.minusDays(60), endDate);
- 
 
 4657 
        LOGGER.info("liveDemoOrderLineItemModels {}", liveDemoOrderLineItemModels);
- 
 
 4658 
        String subject = "Billed Live Demo Model";
- 
 
 4659 
        StringBuilder sb = new StringBuilder();
- 
 
 4660 
 
- 
 
 4661 
        sb.append("<html><body><p>Hi,\n");
- 
 
 4662 
        sb.append("<p>Please check live demo billed order :</p>\n" + " <table style='border:1px solid black ;padding: 5px; border-collapse: collapse;'>");
- 
 
 4663 
 
- 
 
 4664 
        sb.append("<th style='border:1px solid black;padding: 5px'>Item Id</th>\n");
- 
 
 4665 
        sb.append("<th style='border:1px solid black;padding: 5px'>Invoice Number</th>\n");
- 
 
 4666 
        sb.append("<th style='border:1px solid black;padding: 5px'>Brand</th>\n");
- 
 
 4667 
        sb.append("<th style='border:1px solid black;padding: 5px'>Model Number</th>\n");
- 
 
 4668 
        sb.append("<th style='border:1px solid black;padding: 5px'>Model Name</th>\n");
- 
 
 4669 
        sb.append("<th style='border:1px solid black;padding: 5px'>Serial Number</th>\n");
- 
 
 4670 
        sb.append("<th style='border:1px solid black;padding: 5px'>Retailer Name</th>\n");
- 
 
 4671 
        sb.append("<th style='border:1px solid black;padding: 5px'>Retailer City</th>\n");
- 
 
 4672 
        sb.append("<th style='border:1px solid black;padding: 5px'>Retailer Pincode</th>\n");
- 
 
 4673 
        sb.append("<th style='border:1px solid black;padding: 5px'>Retailer State</th>\n");
- 
 
 4674 
        sb.append("<th style='border:1px solid black;padding: 5px'>Billing Date</th>\n");
- 
 
 4675 
        sb.append("</tr>\n");
- 
 
 4676 
        for (LiveDemoOrderLineItemModel liveDemoModel : liveDemoOrderLineItemModels) {
- 
 
 4677 
            sb.append("<tr>");
- 
 
 4678 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getItemId() + "</td>\n");
- 
 
 4679 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getInvoiceNumber() + "</td>\n");
- 
 
 4680 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getBrand() + "</td>\n");
- 
 
 4681 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getModelNumber() + "</td>\n");
- 
 
 4682 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getModelName() + "</td>\n");
- 
 
 4683 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getSerialNumber() + "</td>\n");
- 
 
 4684 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getRetailerName() + "</td>\n");
- 
 
 4685 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getRetailerCity() + "</td>\n");
- 
 
 4686 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getRetailerPincode() + "</td>\n");
- 
 
 4687 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getState() + "</td>\n");
- 
 
 4688 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + liveDemoModel.getFormattedBillingDate() + "</td>\n");
- 
 
 4689 
 
- 
 
 4690 
            sb.append("</tr>\n");
- 
 
 4691 
 
- 
 
 4692 
            }
- 
 
 4693 
        List<String> sendTo = Arrays.asList("kamini.sharma@smartdukaan.com", "niranjan.kala@smartdukaan.com",
- 
 
 4694 
                "mohit.gulati@smartdukaan.com", "vinay.p@smartdukaan.com","shivam.gupta@smartdukaan.com");
- 
 
 4695 
 
- 
 
 4696 
 
- 
 
 4697 
        String[] email = sendTo.toArray(new String[sendTo.size()]);
- 
 
 4698 
        this.sendMailOfHtmlFormat(mailSender, email, sb.toString(), null, subject);
- 
 
 4699 
 
- 
 
 4700 
    }
- 
 
 4701 
 
- 
 
 4702 
 
4652 
    public void monthlyTargetForInternalTeam() throws MessagingException, ProfitMandiBusinessException, IOException {
 4703 
    public void monthlyTargetForInternalTeam() throws MessagingException, ProfitMandiBusinessException, IOException {
4653 
 
 4704 
 
4654 
        LocalDateTime curDate = LocalDateTime.now();
 4705 
        LocalDateTime curDate = LocalDateTime.now();
4655 
 
 4706 
 
4656 
        List<Integer> categoryIds = Arrays.asList(ProfitMandiConstants.TICKET_CATEGORY_CATEGORY, ProfitMandiConstants.TICKET_CATEGORY_RBM, ProfitMandiConstants.TICKET_CATEGORY_SALES, ProfitMandiConstants.TICKET_CATEGORY_MARKETING, ProfitMandiConstants.TICKET_CATEGORY_ACCOUNTS, ProfitMandiConstants.TICKET_CATEGORY_BUSINESSINTELLIGENT);
 4707 
        List<Integer> categoryIds = Arrays.asList(ProfitMandiConstants.TICKET_CATEGORY_CATEGORY, ProfitMandiConstants.TICKET_CATEGORY_RBM, ProfitMandiConstants.TICKET_CATEGORY_SALES, ProfitMandiConstants.TICKET_CATEGORY_MARKETING, ProfitMandiConstants.TICKET_CATEGORY_ACCOUNTS, ProfitMandiConstants.TICKET_CATEGORY_BUSINESSINTELLIGENT);