Subversion Repositories SmartDukaan

Rev

Rev 34299 | Rev 34996 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
34240 tejus.loha 1 
package com.spice.profitmandi.dao.service;
2 
 
34275 tejus.loha 3 
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
34979 ranu 4 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
34275 tejus.loha 5 
import com.spice.profitmandi.dao.entity.auth.AuthUser;
34979 ranu 6 
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
34240 tejus.loha 7 
import com.spice.profitmandi.dao.model.purchaseSaleRatio.CatalogAgedModel;
34275 tejus.loha 8 
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
34979 ranu 9 
import com.spice.profitmandi.dao.repository.cs.CsService;
34240 tejus.loha 10 
import com.spice.profitmandi.dao.repository.warehouse.WarehouseSupplierInvoiceRepository;
34275 tejus.loha 11 
import com.spice.profitmandi.service.AuthService;
34249 tejus.loha 12 
import org.apache.logging.log4j.LogManager;
13 
import org.apache.logging.log4j.Logger;
34240 tejus.loha 14 
import org.springframework.beans.factory.annotation.Autowired;
15 
import org.springframework.mail.javamail.JavaMailSender;
16 
import org.springframework.mail.javamail.MimeMessageHelper;
17 
import org.springframework.stereotype.Service;
34250 tejus.loha 18 
import org.springframework.transaction.annotation.Transactional;
34240 tejus.loha 19 
 
20 
import javax.mail.MessagingException;
21 
import javax.mail.internet.InternetAddress;
22 
import javax.mail.internet.MimeMessage;
23 
import java.io.UnsupportedEncodingException;
24 
import java.time.LocalDateTime;
34275 tejus.loha 25 
import java.util.*;
34240 tejus.loha 26 
import java.util.stream.Collectors;
27 
 
28 
@Service
34250 tejus.loha 29 
@Transactional(rollbackFor = Throwable.class)
34240 tejus.loha 30 
public class PurSaleServiceImpl implements PurSaleService {
31 
 
34249 tejus.loha 32 
    private static final Logger LOGGER = LogManager.getLogger(PurSaleServiceImpl.class);
33 
 
34 
 
34240 tejus.loha 35 
    @Autowired
36 
    WarehouseSupplierInvoiceRepository warehouseSupplierInvoiceRepository;
37 
 
38 
    @Autowired
39 
    JavaMailSender mailSender;
40 
 
34275 tejus.loha 41 
    @Autowired
42 
    AuthService authService;
43 
    @Autowired
44 
    AuthRepository authRepository;
45 
 
34979 ranu 46 
    @Autowired
47 
    CsService csService;
48 
 
34240 tejus.loha 49 
    @Override
34275 tejus.loha 50 
    public void moreThen10DaysEgedStockReport() throws MessagingException, UnsupportedEncodingException, ProfitMandiBusinessException {
51 
        LocalDateTime startDate = LocalDateTime.now().minusMonths(3);
52 
        LocalDateTime endDate = LocalDateTime.now();
34299 tejus.loha 53 
        List<CatalogAgedModel> moreThen10DaysAgedCatalogModels = getCatalogModelsOlderThan10Days(startDate, endDate);
34240 tejus.loha 54 
        StringBuilder sb = new StringBuilder();
34979 ranu 55 
        sb.append("<html><body><b>Aging Stock List: Items that are 7 days old or older (Date Range - " + startDate.toLocalDate() + " To " + endDate.toLocalDate() + " )</b>" + "<br/><table style='border:1px solid black ;padding: 5px ;bgColor=green'>");
34240 tejus.loha 56 
        sb.append("<tbody>" +
57 
                "<tr>" +
58 
                "<th style='border:1px solid black;padding: 5px'>No.</th>" +
59 
                "<th style='border:1px solid black;padding: 5px'>Brand</th>" +
60 
                "<th style='border:1px solid black;padding: 5px'>Vendor</th>" +
61 
                "<th style='border:1px solid black;padding: 5px'>Category</th>" +
62 
                "<th style='border:1px solid black;padding: 5px'>Model</th>" +
34297 tejus.loha 63 
                "<th style='border:1px solid black;padding: 5px'>Colour</th>" +
34240 tejus.loha 64 
                "<th style='border:1px solid black;padding: 5px'>Purchase</th>" +
65 
                "<th style='border:1px solid black;padding: 5px'>Sold</th>" +
66 
                "<th style='border:1px solid black;padding: 5px'>Unsold</th>" +
67 
                "<th style='border:1px solid black;padding: 5px'>Age</th>" +
68 
 
69 
                "</tr>");
70 
 
34299 tejus.loha 71 
 
72 
        moreThen10DaysAgedCatalogModels.sort(Comparator.comparingInt(CatalogAgedModel::getAge).reversed());
34240 tejus.loha 73 
        int i = 1;
74 
        for (CatalogAgedModel catalogAgedModel : moreThen10DaysAgedCatalogModels) {
75 
            sb.append("<tr>");
76 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + (i++) + "</td>");
77 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getBrand() + "</td>");
78 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getSupplier() + "</td>");
79 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getStatus() + "</td>");
34275 tejus.loha 80 
            if (catalogAgedModel.getBrand().equals("Samsung")) {
81 
                sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getModel() + "</td>");
82 
            } else {
34262 tejus.loha 83 
                sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getModelName() + "</td>");
84 
            }
34297 tejus.loha 85 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getColor().replaceFirst("f_", "") + "</td>");
34240 tejus.loha 86 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getPurchase() + "</td>");
87 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getSold() + "</td>");
88 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getUnsold() + "</td>");
89 
            sb.append("<td style='border:1px solid black;padding: 5px'>" + catalogAgedModel.getAge() + "</td>");
90 
            sb.append("</tr>");
91 
 
92 
        }
34275 tejus.loha 93 
        String subject = "Aging Stock Report: 10 Days or Older";
34240 tejus.loha 94 
        String messageText = sb.toString();
95 
        MimeMessage message = mailSender.createMimeMessage();
96 
        MimeMessageHelper helper = new MimeMessageHelper(message, true);
34979 ranu 97 
        List<AuthUser> salesAuthUserList = csService.getAuthUserIds(ProfitMandiConstants.TICKET_CATEGORY_SALES, Arrays.asList(EscalationType.L1, EscalationType.L2));
98 
        List<String> salesTeamMails = salesAuthUserList.stream().map(x->x.getEmailId()).collect(Collectors.toList());
34275 tejus.loha 99 
        List<String> allEmails = new ArrayList<>(Arrays.asList(
34263 tejus.loha 100 
                "sm@smartdukaan.com",
34275 tejus.loha 101 
                "manish.gupta1@smartdukaan.com",
34263 tejus.loha 102 
                "tarun.verma@smartdukaan.com",
34275 tejus.loha 103 
                "niranjan.kala@smartdukaan.com",
104 
                "mohit.gulati@smartdukaan.com"
105 
//                "tejus.lohani@smartdukaan.com"
34299 tejus.loha 106 
        ));
34254 tejus.loha 107 
 
34979 ranu 108 
        allEmails.addAll(salesTeamMails);
109 
 
34297 tejus.loha 110 
//         niranjan kala(authId -54) Team Emails,
34275 tejus.loha 111 
        List<Integer> allReportees = authService.getAllReportees(54);
112 
        List<AuthUser> authUsers = authRepository.selectAllAuthUserByIds(allReportees);
113 
        List<String> categotyTeamEmails = authUsers.stream().map(x -> x.getEmailId()).collect(Collectors.toList());
114 
 
115 
        allEmails.addAll(categotyTeamEmails);
116 
        String[] emailTo = allEmails.toArray(new String[allEmails.size()]);
34240 tejus.loha 117 
        helper.setSubject(subject);
118 
        helper.setText(messageText, true);
119 
        helper.setTo(emailTo);
34275 tejus.loha 120 
        InternetAddress senderAddress = new InternetAddress("noreply@smartdukaan.com", "Smart Dukaan");
34240 tejus.loha 121 
        helper.setFrom(senderAddress);
122 
        mailSender.send(message);
123 
 
124 
    }
125 
 
126 
    @Override
34275 tejus.loha 127 
    public List<CatalogAgedModel> getCatalogModelsOlderThan10Days(LocalDateTime startDate, LocalDateTime endDate) {
34240 tejus.loha 128 
        List<CatalogAgedModel> fiterCatalogAgedModels =
34275 tejus.loha 129 
                warehouseSupplierInvoiceRepository.selectCatalogAge(startDate, endDate, null, 0, null)
34979 ranu 130 
                        .stream().filter(x -> x.getAge() >= 7 && x.getUnsold() > 0).collect(Collectors.toList());
34275 tejus.loha 131 
        LOGGER.info("fiterCatalogAgedModels - " + fiterCatalogAgedModels);
34240 tejus.loha 132 
        return fiterCatalogAgedModels;
133 
    }
134 
//    192.168.0.16:8080
135 
}